eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_ARCHIVE_EHOL dependencies on PAY_DK_ARCHIVE_EHOL

Line 1: PACKAGE BODY PAY_DK_ARCHIVE_EHOL AS

1: PACKAGE BODY PAY_DK_ARCHIVE_EHOL AS
2: /* $Header: pydkeholca.pkb 120.0.12020000.2 2012/07/18 05:29:44 rsahai noship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE_EHOL.';

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

1: PACKAGE BODY PAY_DK_ARCHIVE_EHOL AS
2: /* $Header: pydkeholca.pkb 120.0.12020000.2 2012/07/18 05:29:44 rsahai noship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE_EHOL.';
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 43: hr_utility.set_location(' Entering Function PAY_DK_ARCHIVE_EHOL.GET_COUNTRY_NAME',111);

39:
40: BEGIN
41:
42: IF g_debug THEN
43: hr_utility.set_location(' Entering Function PAY_DK_ARCHIVE_EHOL.GET_COUNTRY_NAME',111);
44: END IF;
45:
46: OPEN csr_get_territory_name(p_territory_code);
47: FETCH csr_get_territory_name into l_country;

Line 53: hr_utility.set_location(' Leaving Function PAY_DK_ARCHIVE_EHOL.GET_COUNTRY_NAME',112);

49:
50: RETURN l_country;
51:
52: IF g_debug THEN
53: hr_utility.set_location(' Leaving Function PAY_DK_ARCHIVE_EHOL.GET_COUNTRY_NAME',112);
54: END IF;
55:
56: END GET_COUNTRY_NAME;
57: --

Line 197: SELECT PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')

193: ,p_msg_txt OUT NOCOPY VARCHAR2
194: ) IS
195:
196: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
197: SELECT PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
198: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL')
199: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'YEAR')
200: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE')
201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')

Line 198: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL')

194: ) IS
195:
196: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
197: SELECT PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
198: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL')
199: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'YEAR')
200: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE')
201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')
202: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'END_DATE')

Line 199: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'YEAR')

195:
196: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
197: SELECT PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
198: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL')
199: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'YEAR')
200: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE')
201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')
202: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'END_DATE')
203: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')

Line 200: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE')

196: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
197: SELECT PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
198: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL')
199: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'YEAR')
200: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE')
201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')
202: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'END_DATE')
203: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
204: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')

Line 201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')

197: SELECT PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
198: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL')
199: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'YEAR')
200: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE')
201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')
202: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'END_DATE')
203: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
204: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
205: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'MESSAGE_TEXT')

Line 202: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'END_DATE')

198: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL')
199: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'YEAR')
200: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE')
201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')
202: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'END_DATE')
203: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
204: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
205: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'MESSAGE_TEXT')
206: ,effective_date

Line 203: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')

199: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'YEAR')
200: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE')
201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')
202: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'END_DATE')
203: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
204: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
205: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'MESSAGE_TEXT')
206: ,effective_date
207: ,business_group_id

Line 204: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')

200: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'PAYROLL_TYPE')
201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')
202: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'END_DATE')
203: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
204: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
205: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'MESSAGE_TEXT')
206: ,effective_date
207: ,business_group_id
208: FROM pay_payroll_actions

Line 205: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'MESSAGE_TEXT')

201: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'START_DATE')
202: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'END_DATE')
203: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'TEST_SUBMISSION')
204: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
205: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'MESSAGE_TEXT')
206: ,effective_date
207: ,business_group_id
208: FROM pay_payroll_actions
209: WHERE payroll_action_id = p_payroll_action_id;

Line 436: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(

432: g_msg_txt:= NULL;
433:
434: hr_utility.set_location('RANGE_CODE:Before Calling all parameters',2);
435:
436: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(
437: p_payroll_action_id
438: ,l_business_group_id
439: ,g_legal_employer_id
440: ,g_effective_date

Line 781: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(

777: IF g_debug THEN
778: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
779: END IF;
780:
781: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(
782: p_payroll_action_id
783: ,g_business_group_id
784: ,g_legal_employer_id
785: ,g_effective_date

Line 1839: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(

1835: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
1836: END IF;
1837:
1838: /* Fetching report parameters */
1839: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(
1840: l_payroll_action_id
1841: ,g_business_group_id
1842: ,g_legal_employer_id
1843: ,g_effective_date

Line 3448: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(

3444: CLOSE cur_report_type;
3445:
3446: fnd_file.put_line(fnd_file.log,'l_report_type generate_xml:'||l_report_type);
3447:
3448: PAY_DK_ARCHIVE_EHOL.GET_ALL_PARAMETERS(
3449: p_payroll_act_id
3450: ,l_business_group_id
3451: ,g_legal_employer_id
3452: ,g_effective_date

Line 3839: END PAY_DK_ARCHIVE_EHOL;

3835: g_test_submission :=NULL;
3836: g_company_terminating :=NULL;
3837: g_msg_txt :=NULL;
3838:
3839: END PAY_DK_ARCHIVE_EHOL;