1 PACKAGE PSP_PSPRCPGD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPRCPGDS.pls 120.4 2007/10/29 07:27:38 amakrish noship $ */
3 P_source_code varchar2(30);
4 P_SOURCE_CODE_1 varchar2(30);
5 P_source_type varchar2(1);
6 P_time_period_id number;
7 P_batch_name varchar2(30);
8 P_BATCH_NAME_1 varchar2(30);
9 P_CONC_REQUEST_ID number;
10 P_payroll_id number;
11 P_START_DATE date;
12 P_SET_OF_BOOKS_ID number;
13 CP_suspense varchar2(500);
14 CP_credit_amount_pgdl number;
15 -- function cf_assignment_numberformula(assignment_id in number) return varchar2 ;
16 function cf_assignment_numberformula(v_assignment_id in number) return varchar2;
17 -- function cf_person_nameformula(person_id in number) return varchar2 ;
18 function cf_person_nameformula(v_person_id in number) return varchar2;
19 function AfterPForm return boolean ;
20 function cf_mismatch_eltformula(cf_amt_dl_d in number, sl_debit_amount in number, cf_amt_sl_c in number) return varchar2 ;
21 function cf_mismatch_assgformula(sum_dl_d_assg in number, sum_sl_d_assg in number, sum_dl_c_assg in number, sum_sl_c_assg in number) return varchar2 ;
22 function cf_mismatch_personformula(sum_dl_d_person in number, sum_sl_d_person in number, sum_dl_c_person in number, sum_sl_c_person in number) return varchar2 ;
23 function cf_mismatch_reportformula(sum_dl_d_total in number, sum_sl_d_total in number, sum_dl_c_total in number, sum_sl_c_total in number) return varchar2 ;
24 function cf_amt_sl_cformula(gl_code_combination_id in number, sl_credit_amount in number) return number ;
25 --function cf_amt_dl_dformula(gl_code_combination_id in number) return number ;
26 function cf_amt_dl_dformula(v_person_id in number, v_assignment_id in number, v_gl_code_combination_id in number, v_project_id in number, v_task_id in number, v_award_id in number,
27 v_expenditure_type in varchar2, v_expenditure_organization_id in number) return number;
28 function CF_org_reportFormula return VARCHAR2 ;
29 function BeforeReport return boolean ;
30 function CF_source_typeFormula return VARCHAR2 ;
31 function CF_time_periodFormula return VARCHAR2 ;
32 -- function cf_charging_instructionsformu(project_id in number, task_id in number, award_id in number, expenditure_organization_id in number, gl_code_combination_id in number) return char ;
33 function cf_charging_instructionsformu(v_project_id in number, v_task_id in number, v_award_id in number, v_expenditure_organization_id in number, v_gl_code_combination_id in number, v_expenditure_type in varchar2) return char;
34 function cf_currency_codeformula(currency_code in varchar2) return char ;
35 function cf_currency_formatformula(currency_code in varchar2) return char ;
36 function cf_sum_sl_d_total_dspformula(cs_sum_sl_d_total in number, cf_currency_format in varchar2) return char ;
37 function cf_sum_sl_c_total_dspformula(cs_sum_sl_c_total in number, cf_currency_format in varchar2) return char ;
38 function cf_sum_dl_d_total_dspformula(cs_sum_dl_d_total in number, cf_currency_format in varchar2) return char ;
39 function cf_sum_dl_c_total_dspformula(cs_sum_dl_c_total in number, cf_currency_format in varchar2) return char ;
40 function cf_mismatch_currency_totalform(cs_sum_dl_d_total in number, cs_sum_sl_d_total in number, cs_sum_dl_c_total in number, cs_sum_sl_c_total in number) return char ;
41 function cf_sum_sl_d_person_dspformula(sum_sl_d_person in number, cf_currency_format in varchar2) return char ;
42 function cf_sum_sl_c_person_dspformula(sum_sl_c_person in number, cf_currency_format in varchar2) return char ;
43 function cf_sum_dl_d_person_dspformula(sum_dl_d_person in number, cf_currency_format in varchar2) return char ;
44 function cf_sum_dl_c_person_dspformula(sum_dl_c_person in number, cf_currency_format in varchar2) return char ;
45 function cf_sum_sl_d_assg_dspformula(sum_sl_d_assg in number, cf_currency_format in varchar2) return char ;
46 function cf_sum_sl_c_assg_dspformula(sum_sl_c_assg in number, cf_currency_format in varchar2) return char ;
47 function cf_sum_dl_d_assg_dspformula(sum_dl_d_assg in number, cf_currency_format in varchar2) return char ;
48 function cf_sum_dl_c_assg_dspformula(sum_dl_c_assg in number, cf_currency_format in varchar2) return char ;
49 function cf_amt_dl_d_dspformula(cf_amt_dl_d in number, cf_currency_format in varchar2) return char ;
50 function cf_sl_debit_amount_dspformula(sl_debit_amount in number, cf_currency_format in varchar2) return char ;
51 function cf_amt_sl_c_dspformula(cf_amt_sl_c in number, cf_currency_format in varchar2) return char ;
52 function cf_credit_amount_pgdl_dspformu(cf_currency_format in varchar2) return char ;
53 function AfterReport return boolean ;
54 Function CP_suspense_p return varchar2;
55 Function CP_credit_amount_pgdl_p return number;
56 END PSP_PSPRCPGD_XMLP_PKG;