1 PACKAGE PSP_PSPRCLSL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PSPRCLSLS.pls 120.4 2007/10/29 07:27:21 amakrish noship $ */
3 P_source_code varchar2(30);
4 P_source_type varchar2(1);
5 P_time_period_id number;
6 P_batch_name varchar2(30);
7 P_CONC_REQUEST_ID number;
8 P_payroll_id number;
9 P_start_date date;
10 CP_credit_amount_sl number;
11 function cf_assignment_numberformula(assignment_id_1 in number) return varchar2 ;
12 function CF_element_nameFormula return VARCHAR2 ;
13 function cf_person_nameformula(person_id_1 in number) return varchar2 ;
14 function cf_amt_sl_dformula(person_id_1 in number, assignment_id_1 in number, element_type_id_1 in number, currency_code_1 in varchar2) return number ;
15 function AfterPForm return boolean ;
16 function cf_mismatch_eltformula(l_debit_amount in number, cf_amt_sl_d in number, l_credit_amount in number) return varchar2 ;
17 function cf_mismatch_assgformula(sum_l_d_assg in number, sum_sl_d_assg in number, sum_l_c_assg in number, sum_sl_c_assg in number) return varchar2 ;
18 function cf_mismatch_personformula(sum_l_d_person in number, sum_sl_d_person in number, sum_l_c_person in number, sum_sl_c_person in number) return varchar2 ;
19 function cf_mismatch_reportformula(sum_l_d_total in number, sum_sl_d_total in number, sum_l_c_total in number, sum_sl_c_total in number) return varchar2 ;
20 function CF_amt_sl_cFormula return Number ;
21 function CF_amt_l_cFormula return Number ;
22 function CF_amt_l_dFormula return Number ;
23 function CF_orgFormula return VARCHAR2 ;
24 function CF_source_typeFormula return VARCHAR2 ;
25 function CF_time_periodFormula return VARCHAR2 ;
26 function BeforeReport return boolean ;
27 function cf_currency_formatformula(currency_code in varchar2) return char ;
28 function cf_currency_codeformula(currency_code in varchar2) return char ;
29 function cf_l_debit_amount_dspformula(l_debit_amount in number, cf_currency_format in varchar2) return char ;
30 function cf_l_credit_amount_dspformula(l_credit_amount in number, cf_currency_format in varchar2) return char ;
31 function cf_mismatch_currencyformula(cs_sum_l_d_total in number, cs_sum_sl_d_total in number, cs_sum_l_c_total in number, cs_sum_sl_c_total in number) return char ;
32 function CP_credit_amount_slFormula return Number ;
33 function cf_amt_sl_d_dspformula(cf_amt_sl_d in number, cf_currency_format in varchar2) return char ;
34 function cf_credit_amount_sl_dspformula(cf_currency_format in varchar2) return char ;
35 function cf_sum_l_d_assg_dspformula(sum_l_d_assg in number, cf_currency_format in varchar2) return char ;
36 function cf_sum_l_c_assg_dspformula(sum_l_c_assg in number, cf_currency_format in varchar2) return char ;
37 function cf_sum_sl_d_assg_dspformula(sum_sl_d_assg in number, cf_currency_format in varchar2) return char ;
38 function cf_sum_sl_c_assg_dspformula(sum_sl_c_assg in number, cf_currency_format in varchar2) return char ;
39 function cf_sum_l_d_person_dspformula(sum_l_d_person in number, cf_currency_format in varchar2) return char ;
40 function cf_sum_l_c_person_dspformula(sum_l_c_person in number, cf_currency_format in varchar2) 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_l_d_total_dspformula(cs_sum_l_d_total in number, cf_currency_format in varchar2) return char ;
44 function cf_sum_sl_d_total_dspformula(cs_sum_sl_d_total in number, cf_currency_format in varchar2) return char ;
45 function cf_sum_sl_c_total_dspformula(cs_sum_sl_c_total in number, cf_currency_format in varchar2) return char ;
46 function cf_sum_l_c_total_dspformula(cs_sum_l_c_total in number, cf_currency_format in varchar2) return char ;
47 function AfterReport return boolean ;
48 Function CP_credit_amount_sl_p return number;
49 END PSP_PSPRCLSL_XMLP_PKG;