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.30 2012/01/19 09:04:10 rpahune ship $ */
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 270: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

266: IF g_debug THEN
267: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
268: END IF;
269:
270: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
271: ,l_business_group_id
272: ,l_start_date
273: ,l_end_date
274: ,l_effective_date

Line 538: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

534: IF g_debug THEN
535: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
536: END IF;
537:
538: PAY_DK_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
539: ,l_business_group_id
540: ,l_start_date
541: ,l_end_date
542: ,l_effective_date

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

1234: ELSE
1235: l_postal_code := rec_primary_address.postal_code;
1236: END IF;
1237:
1238: l_country := PAY_DK_ARCHIVE.get_country_name(rec_primary_address.country);
1239:
1240: IF rec_employer_address.style = 'DK' THEN
1241: l_emp_postal_code := hr_general.decode_lookup('DK_POSTCODE_TOWN',rec_employer_address.postal_code);
1242: ELSE

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

1242: ELSE
1243: l_emp_postal_code := rec_employer_address.postal_code;
1244: END IF;
1245:
1246: l_emp_country := PAY_DK_ARCHIVE.get_country_name(rec_employer_address.country);
1247:
1248: /* Getting Legal Employer Phone Number String */
1249:
1250: le_phone_num_str := NULL;

Line 2639: PAY_DK_ARCHIVE.SETUP_BALANCE_DEFINITIONS

2635: OPEN csr_def_balance(rec_get_balance.balance_type_id,rec_get_balance.balance_dim_id);
2636: FETCH csr_def_balance INTO l_defined_balance_id;
2637: CLOSE csr_def_balance;
2638:
2639: PAY_DK_ARCHIVE.SETUP_BALANCE_DEFINITIONS
2640: (p_balance_name => rec_get_balance.narrative
2641: ,p_defined_balance_id => l_defined_balance_id
2642: ,p_balance_type_id => rec_get_balance.balance_type_id);
2643: END LOOP;

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

3160: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
3161: -------------
3162: /* cursor to get the payroll_d */
3163: CURSOR csr_payroll (p_payroll_action_id NUMBER) IS
3164: SELECT PAY_DK_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
3165: FROM pay_payroll_actions
3166: WHERE payroll_action_id = p_payroll_action_id ;
3167:
3168:

Line 4834: END PAY_DK_ARCHIVE;

4830: END ARCHIVE_MAIN_ELEMENTS;
4831:
4832: ------------------------------------ End of package ----------------------------------------------------------------
4833:
4834: END PAY_DK_ARCHIVE;