PACKAGE: APPS.PAY_PAYKRHCL_XMLP_PKG

Source

1 PACKAGE PAY_PAYKRHCL_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYKRHCLS.pls 120.0 2007/12/13 12:10:31 amakrish noship $ */
3   P_BUSINESS_GROUP_ID NUMBER;
4 
5   P_CONC_REQUEST_ID NUMBER;
6 
7   P_PAYROLL_ACTION_ID NUMBER;
8   LP_PAYROLL_ACTION_ID NUMBER;
9 
10   P_BP_HI_NUMBER VARCHAR2(50);
11   LP_BP_HI_NUMBER VARCHAR2(50);
12 
13   P_REPORTED_DATE DATE;
14   LP_REPORTED_DATE DATE;
15 
16   CP_HIA_BUSINESS_PLACE_CODE VARCHAR2(200);
17 
18   CP_HIA_HI_NUMBER VARCHAR2(20);
19 
20   CP_HIA_EMPLOYEE_NAME VARCHAR2(50);
21 
22   CP_HIA_REGISTRATION_NUMBER VARCHAR2(20);
23 
24   CP_HIA_QUALIFIED_DATE VARCHAR2(20);
25 
26   CP_HI_PREM_EE_WO_ADJ_ASG_YTD NUMBER;
27 
28   CP_EARNINGS_SUBJ_HI_ASG_YTD NUMBER;
29 
30   CP_HI_WORKING_MONTHS NUMBER;
31 
32   CP_NUMBER_OF_MONTHS_PAID NUMBER;
33 
34   CP_TERMINATION_DATE DATE;
35 
36   CP_SEQUENCE_NUMBER NUMBER := 0;
37 
38   FUNCTION BEFOREREPORT RETURN BOOLEAN;
39 
40   FUNCTION AFTERREPORT RETURN BOOLEAN;
41 
42   FUNCTION CF_BUSINESS_GROUPFORMULA RETURN VARCHAR2;
43 
44   FUNCTION CF_LEGISLATION_CODEFORMULA RETURN VARCHAR2;
45 
46   FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2;
47 
48   PROCEDURE SET_CURRENCY_FORMAT_MASK;
49 
50   FUNCTION P_BUSINESS_GROUP_IDVALIDTRIGGE RETURN BOOLEAN;
51 
52   FUNCTION GET_USER_ENTITY_ID(P_USER_ENTITY_NAME IN FF_USER_ENTITIES.USER_ENTITY_NAME%TYPE) RETURN NUMBER;
53 
54   FUNCTION CF_SEQUENCE_COUNTERFORMULA(CF_SEQUENCE_COUNTER IN NUMBER) RETURN NUMBER;
55 
56   FUNCTION CF_GET_DATAFORMULA(ASSIGNMENT_ACTION_ID IN NUMBER
57                              ,ACTUAL_TERMINATION_DATE IN DATE) RETURN NUMBER;
58 
59   FUNCTION CP_CONCAT_BP_NAMESFORMULA RETURN VARCHAR2;
60 
61   FUNCTION CP_HIA_BUSINESS_PLACE_CODE_P RETURN VARCHAR2;
62 
63   FUNCTION CP_HIA_HI_NUMBER_P RETURN VARCHAR2;
64 
65   FUNCTION CP_HIA_EMPLOYEE_NAME_P RETURN VARCHAR2;
66 
67   FUNCTION CP_HIA_REGISTRATION_NUMBER_P RETURN VARCHAR2;
68 
69   FUNCTION CP_HIA_QUALIFIED_DATE_P RETURN VARCHAR2;
70 
71   FUNCTION CP_HI_PREM_EE_WO_ADJ_ASG_YTD_P RETURN NUMBER;
72 
73   FUNCTION CP_EARNINGS_SUBJ_HI_ASG_YTD_P RETURN NUMBER;
74 
75   FUNCTION CP_HI_WORKING_MONTHS_P RETURN NUMBER;
76 
77   FUNCTION CP_NUMBER_OF_MONTHS_PAID_P RETURN NUMBER;
78 
79   FUNCTION CP_TERMINATION_DATE_P RETURN DATE;
80 
81   FUNCTION CP_SEQUENCE_NUMBER_P RETURN NUMBER;
82 
83   TYPE VARCHAR2_80_TBL IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
84 
85   TYPE NUMBER_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
86 
87   TYPE USER_ENTITY_REC IS RECORD (USER_ENTITY_NAME VARCHAR2_80_TBL,USER_ENTITY_ID NUMBER_TBL,SZ NUMBER := 0);
88 
89   G_USER_ENTITY_REC USER_ENTITY_REC;
90 
91   X_HI_PREM_EE_WO_ADJ NUMBER;
92 
93   X_EARNINGS_SUBJ_HI NUMBER;
94 
95   X_HI_WORKING_MONTHS NUMBER;
96 
97   X_KR_HIA_BUSINESS_PLACE_CODE NUMBER;
98 
99   X_KR_HIA_HI_NUMBER NUMBER;
100 
101   X_KR_HIA_EMPLOYEE_NAME NUMBER;
102 
103   X_KR_HIA_REGISTRATION_NUMBER NUMBER;
104 
105   X_KR_HIA_QUALIFIED_DATE NUMBER;
106 
107   X_KR_HI_NUM_OF_MTHS_PREM_PAID NUMBER;
108 
109 END PAY_PAYKRHCL_XMLP_PKG;