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_NO_PAYSLIP_ARCHIVE dependencies on PAY_NO_PAYSLIP_ARCHIVE

Line 1: PACKAGE BODY PAY_NO_PAYSLIP_ARCHIVE AS

1: PACKAGE BODY PAY_NO_PAYSLIP_ARCHIVE AS
2: /* $Header: pynoparc.pkb 120.7 2007/07/13 11:57:10 nmuthusa noship $ */
3:
4:
5: ----------------- Globals , Record types , Tables -------------------------------------------------

Line 66: g_package VARCHAR2(33) := ' PAY_NO_PAYSLIP_ARCHIVE.';

62: g_lock_table lock_table;
63: g_index NUMBER := -1;
64: g_index_assact NUMBER := -1;
65: g_index_bal NUMBER := -1;
66: g_package VARCHAR2(33) := ' PAY_NO_PAYSLIP_ARCHIVE.';
67: g_payroll_action_id NUMBER;
68: g_arc_payroll_action_id NUMBER;
69: g_business_group_id NUMBER;
70: g_format_mask VARCHAR2(50);

Line 136: SELECT PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

132: ,p_payroll_id OUT NOCOPY VARCHAR2
133: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
134: --
135: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
136: SELECT PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
137: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
138: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
139: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
140: ,effective_date

Line 137: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')

133: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
134: --
135: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
136: SELECT PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
137: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
138: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
139: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
140: ,effective_date
141: ,business_group_id

Line 138: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')

134: --
135: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
136: SELECT PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
137: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
138: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
139: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
140: ,effective_date
141: ,business_group_id
142: FROM pay_payroll_actions

Line 139: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')

135: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
136: SELECT PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
137: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
138: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
139: ,PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
140: ,effective_date
141: ,business_group_id
142: FROM pay_payroll_actions
143: WHERE payroll_action_id = p_payroll_action_id;

Line 480: PAY_NO_PAYSLIP_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

476: IF g_debug THEN
477: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
478: END IF;
479:
480: PAY_NO_PAYSLIP_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
481: ,l_business_group_id
482: ,l_start_date
483: ,l_end_date
484: ,l_effective_date

Line 945: PAY_NO_PAYSLIP_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

941: IF g_debug THEN
942: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
943: END IF;
944:
945: PAY_NO_PAYSLIP_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
946: ,l_business_group_id
947: ,l_start_date
948: ,l_end_date
949: ,l_effective_date

Line 1640: l_country := PAY_NO_PAYSLIP_ARCHIVE.get_country_name(rec_primary_address.country);

1636: ELSE
1637: l_postal_code := rec_primary_address.postal_code;
1638: END IF;
1639:
1640: l_country := PAY_NO_PAYSLIP_ARCHIVE.get_country_name(rec_primary_address.country);
1641:
1642: IF rec_employer_address.style = 'NO' THEN
1643: l_emp_postal_code := hr_general.decode_lookup('NO_POSTAL_CODE',rec_employer_address.postal_code);
1644: ELSE

Line 1648: l_emp_country := PAY_NO_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);

1644: ELSE
1645: l_emp_postal_code := rec_employer_address.postal_code;
1646: END IF;
1647:
1648: l_emp_country := PAY_NO_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);
1649:
1650: /* Getting Legal Employer Phone Number String */
1651:
1652: le_phone_num_str := NULL;

Line 3418: PAY_NO_PAYSLIP_ARCHIVE.SETUP_BALANCE_DEFINITIONS

3414: OPEN csr_def_balance(rec_get_balance.balance_type_id,rec_get_balance.balance_dim_id);
3415: FETCH csr_def_balance INTO l_defined_balance_id;
3416: CLOSE csr_def_balance;
3417:
3418: PAY_NO_PAYSLIP_ARCHIVE.SETUP_BALANCE_DEFINITIONS
3419: (p_balance_name => rec_get_balance.narrative
3420: ,p_defined_balance_id => l_defined_balance_id
3421: ,p_balance_type_id => rec_get_balance.balance_type_id);
3422: END LOOP;

Line 3917: SELECT PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

3913: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
3914: -------------
3915: /* cursor to get the payroll_d */
3916: CURSOR csr_payroll (p_payroll_action_id NUMBER) IS
3917: SELECT PAY_NO_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
3918: FROM pay_payroll_actions
3919: WHERE payroll_action_id = p_payroll_action_id ;
3920:
3921:

Line 4939: END PAY_NO_PAYSLIP_ARCHIVE;

4935: END ARCHIVE_MAIN_ELEMENTS;
4936:
4937: ------------------------------------ End of package ----------------------------------------------------------------
4938:
4939: END PAY_NO_PAYSLIP_ARCHIVE;