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.