[Home] [Help]
PACKAGE: APPS.PAY_PYSG8SAD_XMLP_PKG
Source
1 PACKAGE PAY_PYSG8SAD_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PYSG8SADS.pls 120.0 2007/12/13 12:13:39 amakrish noship $ */
3 P_BUSINESS_GROUP_ID number;
4 P_BASIS_YEAR number;
5 P_PERSON_ID number;
6 P_PAYROLL_ACTION_ID number;
7 P_ASSIGNMENT_SET_ID number;
8 P_LEGAL_ENTITY number;
9 P_BASIS_START date;
10 P_BASIS_END date;
11 P_CONC_REQUEST_ID number;
12 CP_OW number;
13 CP_OW_CPF_ER number;
14 CP_OW_CPF_EE number;
15 CP_OW_APR_FUND number;
16 CP_AW number;
17 CP_AW_CPF_ER number;
18 CP_AW_CPF_EE number;
19 CP_AW_APR_FUND number;
20 CP_AW_AMT number;
21 CP_AW_FR_DATE varchar2(20);
22 CP_AW_TO_DATE varchar2(20);
23 CP_REFUND_DATE varchar2(20);
24 CP_ER_CONTRIB number;
25 CP_ER_INTR number;
26 CP_ER_DATE varchar2(20);
27 CP_EE_CONTRIB number;
28 CP_EE_INTR number;
29 CP_EE_DATE varchar2(20);
30 CP_CPF_CAP_YES varchar2(1);
31 CP_ASG_SET_NAME varchar2(25);
32 CP_EMP_NO varchar2(20);
33 CP_CPF_CAP_NO varchar2(1);
34 CP_SYS_DATE varchar2(20);
35 CP_BASIS_END varchar2(20);
36 function AfterReport return boolean ;
37 function CF_business_groupFormula return VARCHAR2 ;
38 function BeforeReport return boolean ;
39 function CF_legislation_codeFormula return VARCHAR2 ;
40 function cf_currency_format_maskformula(cf_legislation_code in varchar2) return varchar2 ;
41 function cf_monthly_detailsformula(assignment_action_id in number, date_earned in varchar2) return number ;
42 function cf_refund_detailsformula(ASSIGNMENT_ACTION_ID2 in number, ASS_EXTRA_ID in varchar2) return number ;
43 function delete_archive_data(t_payroll_action_id in number)return number ;
44 Function CP_OW_p return number;
45 Function CP_OW_CPF_ER_p return number;
46 Function CP_OW_CPF_EE_p return number;
47 Function CP_OW_APR_FUND_p return number;
48 Function CP_AW_p return number;
49 Function CP_AW_CPF_ER_p return number;
50 Function CP_AW_CPF_EE_p return number;
51 Function CP_AW_APR_FUND_p return number;
52 Function CP_AW_AMT_p return number;
53 Function CP_AW_FR_DATE_p return varchar2;
54 Function CP_AW_TO_DATE_p return varchar2;
55 Function CP_REFUND_DATE_p return varchar2;
56 Function CP_ER_CONTRIB_p return number;
57 Function CP_ER_INTR_p return number;
58 Function CP_ER_DATE_p return varchar2;
59 Function CP_EE_CONTRIB_p return number;
60 Function CP_EE_INTR_p return number;
61 Function CP_EE_DATE_p return varchar2;
62 Function CP_CPF_CAP_YES_p return varchar2;
63 Function CP_ASG_SET_NAME_p return varchar2;
64 Function CP_EMP_NO_p return varchar2;
65 Function CP_CPF_CAP_NO_p return varchar2;
66 Function CP_SYS_DATE_p return varchar2;
67 Function CP_BASIS_END_p return varchar2;
68 END PAY_PYSG8SAD_XMLP_PKG;