PACKAGE: APPS.PAY_PYAUSGC_XMLP_PKG

Source

1 PACKAGE PAY_PYAUSGC_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PYAUSGCS.pls 120.0 2007/12/13 11:58:27 amakrish noship $ */
3   P_CONC_REQUEST_ID NUMBER;
4 
5   P_BUSINESS_GROUP_ID VARCHAR2(32767);
6 
7   P_SGC_RATE NUMBER;
8 
9   P_DATE DATE;
10 
11   P_DATE1 DATE;
12 
13   P_COST_CENTRE VARCHAR2(32767);
14 
15   P_EMPLOYEE_NUMBER VARCHAR2(32767);
16 
17   P_ALL_EXCEPTION VARCHAR2(10);
18 
19   P_START_DATE DATE;
20 
21   P_END_DATE DATE;
22 
23   P_MON_YYYY VARCHAR2(30);
24 
25   P_REGISTERED_EMPLOYER VARCHAR2(32767);
26 
27   CP_SGC_RATE_1 VARCHAR2(20);
28 
29   CP_START_DATE DATE;
30 
31   CP_END_DATE DATE;
32 
33   CP_SUPER_SAL NUMBER := 0;
34 
35   CP_COMPLIANCE_MESG VARCHAR2(100);
36 
37   CP_WARNING_MESG VARCHAR2(100);
38 
39   CP_SGC_CONTR NUMBER;
40 
41   CP_CURRENCY_CODE VARCHAR2(20);
42 
43   CP_SGC_RATE VARCHAR2(20);
44 
45   FUNCTION AFTERREPORT RETURN BOOLEAN;
46 
47   FUNCTION CF_BUSINESS_GROUPFORMULA RETURN VARCHAR2;
48 
49   FUNCTION BEFOREREPORT RETURN BOOLEAN;
50 
51   FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2;
52 
53   FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
54 
55   FUNCTION CF_PAYAUSGC_PKBFORMULA(ASSIGNMENT_ID IN NUMBER
56                                  ,AGE IN NUMBER) RETURN NUMBER;
57 
58   FUNCTION CF_END_OF_REPORTFORMULA(CS_CNT_ASG_ID IN NUMBER) RETURN CHAR;
59 
60   FUNCTION CF_SGC_RATEFORMULA RETURN CHAR;
61 
62   FUNCTION CF_COST_CENTREFORMULA RETURN VARCHAR2;
63 
64   FUNCTION CF_ALL_EXCEPFORMULA RETURN CHAR;
65 
66   FUNCTION CP_SGC_RATE_1_P RETURN VARCHAR2;
67 
68   FUNCTION CP_START_DATE_P RETURN DATE;
69 
70   FUNCTION CP_END_DATE_P RETURN DATE;
71 
72   FUNCTION CP_SUPER_SAL_P RETURN NUMBER;
73 
74   FUNCTION CP_COMPLIANCE_MESG_P RETURN VARCHAR2;
75 
76   FUNCTION CP_WARNING_MESG_P RETURN VARCHAR2;
77 
78   FUNCTION CP_SGC_CONTR_P RETURN NUMBER;
79 
80   FUNCTION CP_CURRENCY_CODE_P RETURN VARCHAR2;
81 
82   FUNCTION CP_SGC_RATE_P RETURN VARCHAR2;
83 
84 END PAY_PYAUSGC_XMLP_PKG;