DBA Data[Home] [Help]

APPS.PAY_PAYKRHCL_XMLP_PKG dependencies on PAY_KR_REPORT_PKG

Line 127: CP_HIA_BUSINESS_PLACE_CODE := RPAD(SUBSTR(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

123:
124: FUNCTION CF_GET_DATAFORMULA(ASSIGNMENT_ACTION_ID IN NUMBER
125: ,ACTUAL_TERMINATION_DATE IN DATE) RETURN NUMBER IS
126: BEGIN
127: CP_HIA_BUSINESS_PLACE_CODE := RPAD(SUBSTR(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
128: ,X_KR_HIA_BUSINESS_PLACE_CODE)
129: ,1
130: ,8)
131: ,8

Line 133: CP_HIA_HI_NUMBER := PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

129: ,1
130: ,8)
131: ,8
132: ,' ');
133: CP_HIA_HI_NUMBER := PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
134: ,X_KR_HIA_HI_NUMBER);
135: CP_HIA_EMPLOYEE_NAME := PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
136: ,X_KR_HIA_EMPLOYEE_NAME);
137: CP_HIA_REGISTRATION_NUMBER := REPLACE(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

Line 135: CP_HIA_EMPLOYEE_NAME := PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

131: ,8
132: ,' ');
133: CP_HIA_HI_NUMBER := PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
134: ,X_KR_HIA_HI_NUMBER);
135: CP_HIA_EMPLOYEE_NAME := PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
136: ,X_KR_HIA_EMPLOYEE_NAME);
137: CP_HIA_REGISTRATION_NUMBER := REPLACE(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
138: ,X_KR_HIA_REGISTRATION_NUMBER)
139: ,'-');

Line 137: CP_HIA_REGISTRATION_NUMBER := REPLACE(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

133: CP_HIA_HI_NUMBER := PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
134: ,X_KR_HIA_HI_NUMBER);
135: CP_HIA_EMPLOYEE_NAME := PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
136: ,X_KR_HIA_EMPLOYEE_NAME);
137: CP_HIA_REGISTRATION_NUMBER := REPLACE(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
138: ,X_KR_HIA_REGISTRATION_NUMBER)
139: ,'-');
140: CP_HIA_QUALIFIED_DATE := TO_CHAR(FND_DATE.CANONICAL_TO_DATE(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
141: ,X_KR_HIA_QUALIFIED_DATE))

Line 140: CP_HIA_QUALIFIED_DATE := TO_CHAR(FND_DATE.CANONICAL_TO_DATE(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

136: ,X_KR_HIA_EMPLOYEE_NAME);
137: CP_HIA_REGISTRATION_NUMBER := REPLACE(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
138: ,X_KR_HIA_REGISTRATION_NUMBER)
139: ,'-');
140: CP_HIA_QUALIFIED_DATE := TO_CHAR(FND_DATE.CANONICAL_TO_DATE(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
141: ,X_KR_HIA_QUALIFIED_DATE))
142: ,'YYYYMMDD');
143: CP_HI_PREM_EE_WO_ADJ_ASG_YTD := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
144: ,X_HI_PREM_EE_WO_ADJ));

Line 143: CP_HI_PREM_EE_WO_ADJ_ASG_YTD := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

139: ,'-');
140: CP_HIA_QUALIFIED_DATE := TO_CHAR(FND_DATE.CANONICAL_TO_DATE(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
141: ,X_KR_HIA_QUALIFIED_DATE))
142: ,'YYYYMMDD');
143: CP_HI_PREM_EE_WO_ADJ_ASG_YTD := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
144: ,X_HI_PREM_EE_WO_ADJ));
145: CP_EARNINGS_SUBJ_HI_ASG_YTD := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
146: ,X_EARNINGS_SUBJ_HI));
147: CP_HI_WORKING_MONTHS := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

Line 145: CP_EARNINGS_SUBJ_HI_ASG_YTD := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

141: ,X_KR_HIA_QUALIFIED_DATE))
142: ,'YYYYMMDD');
143: CP_HI_PREM_EE_WO_ADJ_ASG_YTD := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
144: ,X_HI_PREM_EE_WO_ADJ));
145: CP_EARNINGS_SUBJ_HI_ASG_YTD := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
146: ,X_EARNINGS_SUBJ_HI));
147: CP_HI_WORKING_MONTHS := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
148: ,X_HI_WORKING_MONTHS));
149: CP_TERMINATION_DATE := ACTUAL_TERMINATION_DATE;

Line 147: CP_HI_WORKING_MONTHS := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

143: CP_HI_PREM_EE_WO_ADJ_ASG_YTD := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
144: ,X_HI_PREM_EE_WO_ADJ));
145: CP_EARNINGS_SUBJ_HI_ASG_YTD := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
146: ,X_EARNINGS_SUBJ_HI));
147: CP_HI_WORKING_MONTHS := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
148: ,X_HI_WORKING_MONTHS));
149: CP_TERMINATION_DATE := ACTUAL_TERMINATION_DATE;
150: CP_SEQUENCE_NUMBER := CP_SEQUENCE_NUMBER + 1;
151: CP_NUMBER_OF_MONTHS_PAID := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

Line 151: CP_NUMBER_OF_MONTHS_PAID := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID

147: CP_HI_WORKING_MONTHS := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
148: ,X_HI_WORKING_MONTHS));
149: CP_TERMINATION_DATE := ACTUAL_TERMINATION_DATE;
150: CP_SEQUENCE_NUMBER := CP_SEQUENCE_NUMBER + 1;
151: CP_NUMBER_OF_MONTHS_PAID := TO_NUMBER(PAY_KR_REPORT_PKG.GET_ARCHIVE_ITEMS(ASSIGNMENT_ACTION_ID
152: ,X_KR_HI_NUM_OF_MTHS_PREM_PAID));
153: RETURN (1);
154: END CF_GET_DATAFORMULA;
155: