APPS.PAY_DK_ARCHIVE_EIN dependencies on PAY_DK_ARCHIVE_EIN

Line 1: PACKAGE BODY PAY_DK_ARCHIVE_EIN AS

1: PACKAGE BODY PAY_DK_ARCHIVE_EIN AS
2: /* $Header: pydkeina.pkb 120.1.12010000.2 2008/10/14 14:37:00 pvelugul ship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE_EIN.';

Line 5: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE_EIN.';

1: PACKAGE BODY PAY_DK_ARCHIVE_EIN AS
2: /* $Header: pydkeina.pkb 120.1.12010000.2 2008/10/14 14:37:00 pvelugul 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;

Line 114: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')

110: ,p_company_terminating OUT NOCOPY VARCHAR2
111: ) IS
112:
113: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
114: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
115: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
116: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
117: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
118: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')

Line 115: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')

111: ) IS
112:
113: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
114: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
115: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
116: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
117: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
118: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
119: ,effective_date

Line 116: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')

112:
113: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
114: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
115: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
116: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
117: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
118: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
119: ,effective_date
120: ,business_group_id

Line 117: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')

113: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
114: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
115: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
116: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
117: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
118: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
119: ,effective_date
120: ,business_group_id
121: FROM pay_payroll_actions

Line 118: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')

114: SELECT PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
115: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL')
116: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'PAYROLL_PERIOD')
117: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
118: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
119: ,effective_date
120: ,business_group_id
121: FROM pay_payroll_actions
122: WHERE payroll_action_id = p_payroll_action_id;

Line 245: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(

241: g_company_terminating:=NULL;
242:
243: -- fnd_file.put_line(fnd_file.log,'Range Code 3');
244:
245: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
246: p_payroll_action_id
247: ,l_business_group_id
248: ,g_legal_employer_id
249: ,g_effective_date

Line 645: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(

641: IF g_debug THEN
642: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
643: END IF;
644:
645: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
646: p_payroll_action_id
647: ,g_business_group_id
648: ,g_legal_employer_id
649: ,g_effective_date

Line 1087: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(

1083: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
1084: END IF;
1085:
1086: /* Fetching report parameters */
1087: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
1088: l_payroll_action_id
1089: ,g_business_group_id
1090: ,g_legal_employer_id
1091: ,g_effective_date

Line 1709: END PAY_DK_ARCHIVE_EIN;

1705: g_payroll_period :=NULL;
1706: g_test_submission :=NULL;
1707: g_company_terminating :=NULL;
1708:
1709: END PAY_DK_ARCHIVE_EIN;