Package BANINST1.foksels

Common routines for selecting accounting codes (FOKSELS).

Program units

f_pending_def_edit	Checks if a document exists in the Document in Progress Table.
f_pending_approval	Checks if a document exists in the Unapproved Document Table.
f_pending_posting	Checks if a document exists in the Approved Document Table.
p_get_fobsysc_rec	Gets System Control record.
p_get_fobprof_rec	Gets User Profile record.
p_get_ftvcoas_rec	Gets chart of accounts record.
p_get_ftvacci_rec	Gets accounting index record.
p_get_ftvfund_rec	Gets fund record.
p_get_ftvftyp_rec	Gets fund type record.
p_get_ftvorgn_rec	Gets organization record.
p_get_ftvacct_rec	Gets account record.
p_get_ftvactl_rec	Gets Control Account Validation record.
p_get_ftvprog_rec	Gets program record.
p_get_ftvactv_rec	Gets activity record.
p_get_ftvlocn_rec	Gets location record.
p_get_ftvfspd_rec	Gets fiscal period record.
p_get_ftvfsyr_rec	Gets fiscal year record.
p_get_ftvatyp_rec	Gets account type record.
f_get_ftvsdat	Gets System Data Validation record.
p_get_ftvsdat_rec	Gets System Data Validation record.
f_get_ftvsdat_data	Gets the data value from the System Data Validation table.

Types

ref_cursortype

Reference cursor

Cursors

GetCOASC	Selects chart of accounts record.
GetAcciC	Selects accounting index record.
GetFundC	Selects fund record.
GetftypC	Selects fund type record.
GetOrgnC	Selects organization record.
GetAcctC	Selects account record.
GetatypC	Selects account type record.
GetActlC	Selects Control Account Validation record.
GetProgC	Selects program record.
GetActvC	Selects activity record.
GetLocnC	Selects location record.
GetFspdC	Selects fiscal period record.
GetFsyrC	Selects fiscal year record.
CheckRUCLSecurityC	Selects User to Rule Group record.
GetSyscC	Selects System Control record.
getprofC	Selects User Profile record.

ref_cursortype

TYPE ref_cursortype IS REF CURSOR;

Reference cursor

GetCOASC

CURSOR GetCOASC(coas     FTVCOAS.FTVCOAS_COAS_CODE%TYPE,
                asofdate DATE)
RETURN ftvcoas%ROWTYPE ;

Selects chart of accounts record.

GetAcciC

CURSOR GetAcciC(coas     FTVACCI.FTVACCI_COAS_CODE%TYPE,
                acci     FTVACCI.FTVACCI_ACCI_CODE%TYPE,
                asofdate DATE)
RETURN ftvacci%ROWTYPE ;

Selects accounting index record.

GetFundC

CURSOR GetFundC(coas     FTVFUND.FTVFUND_COAS_CODE%TYPE,
                fund     FTVFUND.FTVFUND_FUND_CODE%TYPE,
                asofdate DATE)
RETURN ftvfund%ROWTYPE ;

Selects fund record.

GetftypC

CURSOR GetftypC(coas     FTVftyp.FTVftyp_COAS_CODE%TYPE,
                ftyp     FTVftyp.FTVftyp_ftyp_CODE%TYPE,
                asofdate DATE)
RETURN ftvftyp%ROWTYPE ;

Selects fund type record.

GetOrgnC

CURSOR GetOrgnC(coas     FTVORGN.FTVORGN_COAS_CODE%TYPE,
                orgn     FTVORGN.FTVORGN_ORGN_CODE%TYPE,
                asofdate DATE)
RETURN ftvorgn%ROWTYPE;

Selects organization record.

GetAcctC

CURSOR GetAcctC(coas     FTVACCT.FTVACCT_COAS_CODE%TYPE,
                acct     FTVACCT.FTVACCT_ACCT_CODE%TYPE,
                asofdate DATE)
RETURN ftvacct%ROWTYPE ;

Selects account record.

GetatypC

CURSOR GetatypC(coas     FTVATYP.FTVATYP_COAS_CODE%TYPE,
                atyp     FTVATYP.FTVATYP_ATYP_CODE%TYPE,
                asofdate DATE)
RETURN ftvatyp%ROWTYPE;

Selects account type record.

GetActlC

CURSOR GetActlC(coas     FTVACTL.FTVACTL_COAS_CODE%TYPE,
                atyp     FTVACTL.FTVACTL_ATYP_CODE%TYPE,
                seq_num  FTVACTL.FTVACTL_SEQ_NUM%TYPE,
                asofdate DATE)
RETURN ftvactl%ROWTYPE;

Selects Control Account Validation record. More than one record may match the criteria when seq_num IS NULL

GetProgC

CURSOR GetProgC(coas     FTVPROG.FTVPROG_COAS_CODE%TYPE,
                prog     FTVPROG.FTVPROG_PROG_CODE%TYPE,
                asofdate DATE)
RETURN ftvprog%ROWTYPE ;

Selects program record.

GetActvC

CURSOR GetActvC(coas     FTVACTV.FTVACTV_COAS_CODE%TYPE,
                actv     FTVACTV.FTVACTV_ACTV_CODE%TYPE,
                asofdate DATE)
RETURN ftvactv%ROWTYPE;

Selects activity record.

GetLocnC

CURSOR GetLocnC(coas     FTVLOCN.FTVLOCN_COAS_CODE%TYPE,
                locn     FTVLOCN.FTVLOCN_LOCN_CODE%TYPE,
                asofdate DATE)
RETURN ftvlocn%ROWTYPE ;

Selects location record.

GetFspdC

CURSOR GetFspdC(coas     FTVFSPD.FTVFSPD_COAS_CODE%TYPE,
                fsyr     FTVFSPD.FTVFSPD_FSYR_CODE%TYPE,
                fspd     FTVFSPD.FTVFSPD_FSPD_CODE%TYPE DEFAULT NULL,
                asofdate DATE)
RETURN ftvfspd%ROWTYPE ;

Selects fiscal period record.

GetFsyrC

CURSOR GetFsyrC(coas     FTVFSYR.FTVFSYR_COAS_CODE%TYPE,
                fsyr     FTVFSYR.FTVFSYR_FSYR_CODE%TYPE,
                asofdate DATE)
RETURN ftvfsyr%ROWTYPE ;

Selects fiscal year record.

CheckRUCLSecurityC

CURSOR CheckRUCLSecurityC(user_code FORUSRG.FORUSRG_USER_ID_ENTERED%TYPE,
                          rucl_code FORUSRG.FORUSRG_RULE_GROUP%TYPE)
RETURN forusrg%ROWTYPE;

Selects User to Rule Group record.

GetSyscC

CURSOR GetSyscC (asofdate DATE DEFAULT SYSDATE)
RETURN fobsysc%ROWTYPE;

Selects System Control record.

getprofC

CURSOR getprofC(in_user_id fobprof.fobprof_user_id%TYPE)
RETURN fobprof%ROWTYPE;

Selects User Profile record.

f_pending_def_edit

Function f_pending_def_edit(p_seq_code fobdinp.fobdinp_seq_code%TYPE,
                            p_doc_num  fobdinp.fobdinp_doc_num%TYPE)
  RETURN VARCHAR2

Checks if a document exists in the Document in Progress Table.

Returns

Y if found, otherwise N.

f_pending_approval

Function f_pending_approval(p_seq_code fobuapp.fobuapp_seq_num%TYPE,
                            p_doc_code fobuapp.fobuapp_doc_code%TYPE)
  RETURN VARCHAR2

Checks if a document exists in the Unapproved Document Table.

Returns

Y if found, otherwise N.

f_pending_posting

Function f_pending_posting(p_seq_code fobappd.fobappd_seq_code%TYPE,
                           p_doc_num  fobappd.fobappd_doc_num%TYPE,
                           p_seq_num  fobappd.fobappd_seq_num%TYPE DEFAULT NULL,
                           p_bank_num fobappd.fobappd_bank_num%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Checks if a document exists in the Approved Document Table.

Returns

Y if found, otherwise N.

p_get_fobsysc_rec

Procedure p_get_fobsysc_rec(fobsysc_rec IN OUT fobsysc%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2,
                            as_of_date  DATE DEFAULT SYSDATE)

Gets System Control record.

p_get_fobprof_rec

Procedure p_get_fobprof_rec(prof_id     FOBPROF.FOBPROF_USER_ID%TYPE,
                            fobprof_rec IN OUT fobprof%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets User Profile record.

p_get_ftvcoas_rec

Procedure p_get_ftvcoas_rec(coas_code   ftvcoas.FTVCOAS_COAS_CODE%TYPE,
                            asofdate    DATE DEFAULT SYSDATE,
                            ftvcoas_rec IN OUT ftvcoas%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets chart of accounts record.

p_get_ftvacci_rec

Procedure p_get_ftvacci_rec(coas        FTVACCI.FTVACCI_COAS_CODE%TYPE,
                            acci        FTVACCI.FTVACCI_ACCI_CODE%TYPE,
                            asofdate    DATE,
                            ftvacci_rec IN OUT ftvacci%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets accounting index record.

p_get_ftvfund_rec

Procedure p_get_ftvfund_rec(coas              FTVFUND.FTVFUND_COAS_CODE%TYPE,
                            fund              FTVFUND.FTVFUND_FUND_CODE%TYPE,
                            asofdate          DATE DEFAULT SYSDATE,
                            ftvfund_Rec       IN OUT ftvfund%ROWTYPE,
                            error_mesg        IN OUT VARCHAR2,
                            check_termination VARCHAR2 DEFAULT 'Y')

Gets fund record.

p_get_ftvftyp_rec

Procedure p_get_ftvftyp_rec(coas_code   FTVCOAS.FTVCOAS_COAS_CODE%TYPE,
                            in_ftyp     FTVFTYP.FTVFTYP_FTYP_CODE%TYPE,
                            asofdate    DATE DEFAULT SYSDATE,
                            ftvftyp_rec IN OUT ftvftyp%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets fund type record.

p_get_ftvorgn_rec

Procedure p_get_ftvorgn_rec(coas        FTVORGN.FTVORGN_COAS_CODE%TYPE,
                            orgn        FTVORGN.FTVORGN_ORGN_CODE%TYPE,
                            asofdate    DATE DEFAULT SYSDATE,
                            ftvorgn_rec IN OUT ftvorgn%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets organization record.

p_get_ftvacct_rec

Procedure p_get_ftvacct_rec(coas        FTVACCT.FTVACCT_COAS_CODE%TYPE,
                            acct        FTVACCT.FTVACCT_ACCT_CODE%TYPE,
                            asofdate    DATE DEFAULT SYSDATE,
                            ftvacct_Rec IN OUT ftvacct%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets account record.

p_get_ftvactl_rec

Procedure p_get_ftvactl_rec(coas        FTVACTL.FTVACTL_COAS_CODE%TYPE,
                            atyp        FTVACTL.FTVACTL_ATYP_CODE%TYPE,
                            seq_num     FTVACTL.FTVACTL_SEQ_NUM%TYPE,
                            asofdate    DATE DEFAULT SYSDATE,
                            ftvactl_rec OUT ftvactl%ROWTYPE,
                            error_mesg  OUT VARCHAR2)

Gets Control Account Validation record.

p_get_ftvprog_rec

Procedure p_get_ftvprog_rec(coas        FTVPROG.FTVPROG_COAS_CODE%TYPE,
                            prog        FTVPROG.FTVPROG_PROG_CODE%TYPE,
                            asofdate    DATE,
                            ftvprog_Rec IN OUT ftvprog%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets program record.

p_get_ftvactv_rec

Procedure p_get_ftvactv_rec(coas        FTVACTV.FTVACTV_COAS_CODE%TYPE,
                            actv        FTVACTV.FTVACTV_ACTV_CODE%TYPE,
                            asofdate    DATE,
                            ftvactv_rec IN OUT ftvactv%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets activity record.

p_get_ftvlocn_rec

Procedure p_get_ftvlocn_rec(coas        FTVLOCN.FTVLOCN_COAS_CODE%TYPE,
                            locn        FTVLOCN.FTVLOCN_LOCN_CODE%TYPE,
                            asofdate    DATE,
                            ftvlocn_rec IN OUT ftvlocn%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets location record.

p_get_ftvfspd_rec

Procedure p_get_ftvfspd_rec(coas        FTVFSPD.FTVFSPD_COAS_CODE%TYPE,
                            fsyr        FTVFSPD.FTVFSPD_FSYR_CODE%TYPE,
                            fspd        FTVFSPD.FTVFSPD_FSPD_CODE%TYPE DEFAULT NULL,
                            asofdate    DATE DEFAULT NULL,
                            ftvfspd_rec OUT ftvfspd%ROWTYPE,
                            error_mesg  OUT VARCHAR2)

Gets fiscal period record.

p_get_ftvfsyr_rec

Procedure p_get_ftvfsyr_rec(coas        FTVFSYR.FTVFSYR_COAS_CODE%TYPE,
                            fsyr        FTVFSYR.FTVFSYR_FSYR_CODE%TYPE DEFAULT NULL,
                            asofdate    DATE DEFAULT NULL,
                            ftvfsyr_rec OUT ftvfsyr%ROWTYPE,
                            error_mesg  OUT VARCHAR2)

Gets fiscal year record.

p_get_ftvatyp_rec

Procedure p_get_ftvatyp_rec(coas_code   FTVCOAS.FTVCOAS_COAS_CODE%TYPE,
                            in_atyp     FTVATYP.FTVATYP_ATYP_CODE%TYPE,
                            asofdate    DATE,
                            ftvatyp_rec IN OUT ftvatyp%ROWTYPE,
                            error_mesg  IN OUT VARCHAR2)

Gets account type record.

f_get_ftvsdat

Function f_get_ftvsdat(f_entity     IN VARCHAR2,
                       f_attr       IN VARCHAR2,
                       f_code_opt_1 IN VARCHAR2,
                       f_code_opt_2 IN VARCHAR2,
                       f_coas       IN VARCHAR2 := '',
                       f_eff_date   IN DATE := SYSDATE)
  RETURN ref_cursortype

Gets System Data Validation record.

p_get_ftvsdat_rec

Procedure p_get_ftvsdat_rec(f_entity     IN VARCHAR2,
                            f_attr       IN VARCHAR2,
                            f_code_opt_1 IN VARCHAR2,
                            f_code_opt_2 IN VARCHAR2,
                            ftvsdat_rec  IN OUT ftvsdat%ROWTYPE,
                            error_mesg   IN OUT VARCHAR2,
                            f_coas       IN VARCHAR2 := '',
                            f_eff_date   IN DATE := SYSDATE)

Gets System Data Validation record.

f_get_ftvsdat_data

Function f_get_ftvsdat_data(f_entity     IN VARCHAR2,
                            f_attr       IN VARCHAR2 := NULL,
                            f_code_opt_1 IN VARCHAR2 := NULL,
                            f_code_opt_2 IN VARCHAR2 := NULL,
                            f_coas       IN VARCHAR2 := NULL,
                            f_eff_date   IN DATE := SYSDATE)
  RETURN ftvsdat.ftvsdat_data%TYPE

Gets the data value from the System Data Validation table.