1: PACKAGE BODY PAY_DK_ARCHIVE_EIN AS
2: /* $Header: pydkeina.pkb 120.49.12020000.5 2012/12/18 12:40:40 rsahai ship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE_EIN.';
1: PACKAGE BODY PAY_DK_ARCHIVE_EIN AS
2: /* $Header: pydkeina.pkb 120.49.12020000.5 2012/12/18 12:40:40 rsahai ship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE_EIN.';
6: g_payroll_action_id NUMBER ;
7: g_le_assignment_action_id NUMBER ;
8: g_business_group_id NUMBER;
9: g_legal_employer_id NUMBER;
152: ,p_sender_id OUT NOCOPY VARCHAR2
153: ) IS
154:
155: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
156: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
157: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
158: -- ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
159: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE') /* 9489806 */
160: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'START_DATE') /* 9489806 */
153: ) IS
154:
155: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
156: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
157: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
158: -- ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
159: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE') /* 9489806 */
160: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'START_DATE') /* 9489806 */
161: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'END_DATE') /* 9489806 */
154:
155: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
156: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
157: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
158: -- ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
159: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE') /* 9489806 */
160: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'START_DATE') /* 9489806 */
161: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'END_DATE') /* 9489806 */
162: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
155: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
156: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
157: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
158: -- ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
159: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE') /* 9489806 */
160: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'START_DATE') /* 9489806 */
161: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'END_DATE') /* 9489806 */
162: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
163: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
156: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
157: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
158: -- ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
159: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE') /* 9489806 */
160: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'START_DATE') /* 9489806 */
161: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'END_DATE') /* 9489806 */
162: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
163: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
164: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'SENDER_ID')
157: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
158: -- ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
159: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE') /* 9489806 */
160: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'START_DATE') /* 9489806 */
161: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'END_DATE') /* 9489806 */
162: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
163: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
164: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'SENDER_ID')
165: ,effective_date
158: -- ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
159: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE') /* 9489806 */
160: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'START_DATE') /* 9489806 */
161: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'END_DATE') /* 9489806 */
162: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
163: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
164: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'SENDER_ID')
165: ,effective_date
166: ,business_group_id
159: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE') /* 9489806 */
160: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'START_DATE') /* 9489806 */
161: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'END_DATE') /* 9489806 */
162: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
163: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
164: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'SENDER_ID')
165: ,effective_date
166: ,business_group_id
167: FROM pay_payroll_actions
160: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'START_DATE') /* 9489806 */
161: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'END_DATE') /* 9489806 */
162: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
163: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
164: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'SENDER_ID')
165: ,effective_date
166: ,business_group_id
167: FROM pay_payroll_actions
168: WHERE payroll_action_id = p_payroll_action_id;
336: g_sender_id:=NULL;
337:
338: hr_utility.set_location('RANGE_CODE:Before Calling all parameters',2);
339:
340: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
341: p_payroll_action_id
342: ,l_business_group_id
343: ,g_legal_employer_id
344: ,g_effective_date
757: IF g_debug THEN
758: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
759: END IF;
760:
761: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
762: p_payroll_action_id
763: ,g_business_group_id
764: ,g_legal_employer_id
765: ,g_effective_date
1939: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
1940: END IF;
1941:
1942: /* Fetching report parameters */
1943: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
1944: l_payroll_action_id
1945: ,g_business_group_id
1946: ,g_legal_employer_id
1947: ,g_effective_date
4269: g_test_submission :=NULL;
4270: g_company_terminating :=NULL;
4271: g_sender_id :=NULL;
4272:
4273: END PAY_DK_ARCHIVE_EIN;