[Home] [Help]
PACKAGE: APPS.PAY_PYAUSGC_XMLP_PKG
Source
1 PACKAGE PAY_PYAUSGC_XMLP_PKG 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;