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 dependencies on PAY_DK_ARCHIVE

Line 1: PACKAGE BODY PAY_DK_ARCHIVE AS

1: PACKAGE BODY PAY_DK_ARCHIVE AS
2: /* $Header: pydkparc.pkb 120.6.12000000.6 2007/08/31 10:22:11 saurai noship $ */
3:
4:
5: ----------------- Globals , Record types , Tables -------------------------------------------------

Line 46: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE.';

42: g_lock_table lock_table;
43: g_index NUMBER := -1;
44: g_index_assact NUMBER := -1;
45: g_index_bal NUMBER := -1;
46: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE.';
47: g_payroll_action_id NUMBER;
48: g_arc_payroll_action_id NUMBER;
49: g_business_group_id NUMBER;
50: g_format_mask VARCHAR2(50);

Line 116: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

112: ,p_payroll_id OUT NOCOPY VARCHAR2
113: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
114: --
115: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
116: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
117: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
118: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
119: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
120: ,effective_date

Line 117: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')

113: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
114: --
115: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
116: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
117: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
118: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
119: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
120: ,effective_date
121: ,business_group_id

Line 118: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')

114: --
115: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
116: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
117: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
118: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
119: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
120: ,effective_date
121: ,business_group_id
122: FROM pay_payroll_actions

Line 119: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')

115: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
116: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
117: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
118: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
119: ,PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
120: ,effective_date
121: ,business_group_id
122: FROM pay_payroll_actions
123: WHERE payroll_action_id = p_payroll_action_id;

Line 265: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

261: IF g_debug THEN
262: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
263: END IF;
264:
265: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
266: ,l_business_group_id
267: ,l_start_date
268: ,l_end_date
269: ,l_effective_date

Line 531: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

527: IF g_debug THEN
528: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
529: END IF;
530:
531: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
532: ,l_business_group_id
533: ,l_start_date
534: ,l_end_date
535: ,l_effective_date

Line 1225: l_country := PAY_DK_ARCHIVE.get_country_name(rec_primary_address.country);

1221: ELSE
1222: l_postal_code := rec_primary_address.postal_code;
1223: END IF;
1224:
1225: l_country := PAY_DK_ARCHIVE.get_country_name(rec_primary_address.country);
1226:
1227: IF rec_employer_address.style = 'DK' THEN
1228: l_emp_postal_code := hr_general.decode_lookup('DK_POSTCODE_TOWN',rec_employer_address.postal_code);
1229: ELSE

Line 1233: l_emp_country := PAY_DK_ARCHIVE.get_country_name(rec_employer_address.country);

1229: ELSE
1230: l_emp_postal_code := rec_employer_address.postal_code;
1231: END IF;
1232:
1233: l_emp_country := PAY_DK_ARCHIVE.get_country_name(rec_employer_address.country);
1234:
1235: /* Getting Legal Employer Phone Number String */
1236:
1237: le_phone_num_str := NULL;

Line 2214: PAY_DK_ARCHIVE.SETUP_BALANCE_DEFINITIONS

2210: OPEN csr_def_balance(rec_get_balance.balance_type_id,rec_get_balance.balance_dim_id);
2211: FETCH csr_def_balance INTO l_defined_balance_id;
2212: CLOSE csr_def_balance;
2213:
2214: PAY_DK_ARCHIVE.SETUP_BALANCE_DEFINITIONS
2215: (p_balance_name => rec_get_balance.narrative
2216: ,p_defined_balance_id => l_defined_balance_id
2217: ,p_balance_type_id => rec_get_balance.balance_type_id);
2218: END LOOP;

Line 2722: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

2718: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
2719: -------------
2720: /* cursor to get the payroll_d */
2721: CURSOR csr_payroll (p_payroll_action_id NUMBER) IS
2722: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
2723: FROM pay_payroll_actions
2724: WHERE payroll_action_id = p_payroll_action_id ;
2725:
2726:

Line 3483: END PAY_DK_ARCHIVE;

3479: END ARCHIVE_MAIN_ELEMENTS;
3480:
3481: ------------------------------------ End of package ----------------------------------------------------------------
3482:
3483: END PAY_DK_ARCHIVE;