PACKAGE: APPS.PAY_PAYCABPS_XMLP_PKG

Source

1 PACKAGE PAY_PAYCABPS_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYCABPSS.pls 120.0 2007/12/28 06:43:10 srikrish noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_SESSION_DATE DATE;
6 
7   P_REPORT_TITLE VARCHAR2(60);
8 
9   P_CONC_REQUEST_ID NUMBER;
10 
11   P_REFERENCE_MONTH VARCHAR2(10);
12 
13   P_GRE NUMBER;
14 
15   P_PROVINCE_OR_LOCATION VARCHAR2(32767);
16 
17   P_PROVINCE VARCHAR2(5);
18 
19   P_LOCATION NUMBER;
20 
21   LP_GRE VARCHAR2(500);
22 
23   LP_PROVINCE_OR_LOCATION VARCHAR2(100) := ' ';
24 
25   P_END_DATE DATE;
26 
27   LP_MASTER_GROUP VARCHAR2(200);
28 
29   P_CANONICAL_REFERENCE_MONTH VARCHAR2(40);
30 
31   CP_PROVINCE VARCHAR2(25);
32 
33   CP_LOCATION VARCHAR2(32767);
34 
35   CP_LOCATION_CODE VARCHAR2(20);
36 
37   CP_GRE_NAME VARCHAR2(32767);
38 
39   C_BUSINESS_GROUP_NAME VARCHAR2(32767);
40 
41   C_REPORT_SUBTITLE VARCHAR2(60);
42 
43   C_START_DATE VARCHAR2(11);
44 
45   C_END_DATE VARCHAR2(11);
46 
47   C_PROVINCE_NAME VARCHAR2(20);
48 
49   C_LOCATION_CODE VARCHAR2(20);
50 
51   C_GRE_NAME VARCHAR2(240);
52 
53   CP_SEED_BAL_FLAG VARCHAR2(2);
54 
55   CP_SUPP_EARN_FLAG VARCHAR2(2);
56 
57   CP_SUPP_EARN_VIEW VARCHAR2(100) := 'pay_ca_supp_earnings_v';
58 
59   FUNCTION BEFOREREPORT RETURN BOOLEAN;
60 
61   FUNCTION AFTERPFORM RETURN BOOLEAN;
62 
63   FUNCTION L_ALL_EMP_AVG_HRSFORMULA(REGULAR_HRS_WORKED IN NUMBER
64                                    ,CF_EMP_COUNT IN NUMBER
65                                    ,END_DATE IN DATE
66                                    ,START_DATE IN DATE) RETURN NUMBER;
67 
68   FUNCTION CF_FEEDFORMULA(PROV_OR_LOC IN VARCHAR2
69                          ,GRE_NAME IN VARCHAR2) RETURN CHAR;
70 
71   FUNCTION G_PAYMENTSGROUPFILTER(HOURLY_PAID_AMT IN NUMBER
72                                 ,SALARIED_PAID_AMT IN NUMBER
73                                 ,OTHER_PAID_AMT IN NUMBER) RETURN BOOLEAN;
74 
75   FUNCTION CF_EMP_COUNTFORMULA(PP_PAY_BASIS IN VARCHAR2
76                               ,GRE IN NUMBER
77                               ,PP_PAYROLL_NAME IN VARCHAR2) RETURN NUMBER;
78 
79   FUNCTION CF_PARTTIME_EMP_COUNTFORMULA(PP_PAY_BASIS IN VARCHAR2
80                                        ,GRE IN NUMBER
81                                        ,PP_PAYROLL_NAME IN VARCHAR2) RETURN NUMBER;
82 
83   FUNCTION CF_TOTAL_HOURSFORMULA(OVERTIME_HOURS IN NUMBER
84                                 ,REGULAR_HRS_WORKED IN NUMBER) RETURN NUMBER;
85 
86   FUNCTION AFTERREPORT RETURN BOOLEAN;
87 
88   FUNCTION CP_PROVINCE_P RETURN VARCHAR2;
89 
90   FUNCTION CP_LOCATION_P RETURN VARCHAR2;
91 
92   FUNCTION CP_LOCATION_CODE_P RETURN VARCHAR2;
93 
94   FUNCTION CP_GRE_NAME_P RETURN VARCHAR2;
95 
96   FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2;
97 
98   FUNCTION C_REPORT_SUBTITLE_P RETURN VARCHAR2;
99 
100   FUNCTION C_START_DATE_P RETURN VARCHAR2;
101 
102   FUNCTION C_END_DATE_P RETURN VARCHAR2;
103 
104   FUNCTION C_PROVINCE_NAME_P RETURN VARCHAR2;
105 
106   FUNCTION C_LOCATION_CODE_P RETURN VARCHAR2;
107 
108   FUNCTION C_GRE_NAME_P RETURN VARCHAR2;
109 
110   FUNCTION CP_SEED_BAL_FLAG_P RETURN VARCHAR2;
111 
112   FUNCTION CP_SUPP_EARN_FLAG_P RETURN VARCHAR2;
113 
114   FUNCTION CP_SUPP_EARN_VIEW_P RETURN VARCHAR2;
115 
116   FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN CHAR;
117 
118 
119   PKG_HRLY_COUNT NUMBER := 0;
120 
121   PKG_SAL_COUNT NUMBER := 0;
122 
123   PKG_OTHER_COUNT NUMBER := 0;
124 
125   PKG_PAYMENTS_COUNT NUMBER := 0;
126 
127 END PAY_PAYCABPS_XMLP_PKG;