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_AE_ARCHIVE dependencies on PAY_AE_ARCHIVE

Line 1: PACKAGE BODY PAY_AE_ARCHIVE AS

1: PACKAGE BODY PAY_AE_ARCHIVE AS
2: /* $Header: pyaeparc.pkb 120.11.12020000.4 2013/01/31 12:49:38 bkeshary ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 38: g_package VARCHAR2(33) := ' PAY_AE_ARCHIVE.';

34: g_index NUMBER := -1;
35: g_index_assact NUMBER := -1;
36: g_index_bal NUMBER := -1;
37:
38: g_package VARCHAR2(33) := ' PAY_AE_ARCHIVE.';
39: g_payroll_action_id NUMBER;
40: g_arc_payroll_action_id NUMBER;
41: g_business_group_id NUMBER;
42: g_format_mask VARCHAR2(50);

Line 110: SELECT PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

106: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
107: --
108: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
109:
110: SELECT PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
111: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
112: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
113: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
114: ,effective_date

Line 111: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')

107: --
108: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
109:
110: SELECT PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
111: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
112: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
113: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
114: ,effective_date
115: ,business_group_id

Line 112: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')

108: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
109:
110: SELECT PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
111: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
112: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
113: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
114: ,effective_date
115: ,business_group_id
116: FROM pay_payroll_actions

Line 113: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')

109:
110: SELECT PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
111: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
112: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
113: ,PAY_AE_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
114: ,effective_date
115: ,business_group_id
116: FROM pay_payroll_actions
117: WHERE payroll_action_id = p_payroll_action_id;

Line 256: PAY_AE_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

252: IF g_debug THEN
253: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
254: END IF;
255:
256: PAY_AE_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
257: ,l_business_group_id
258: ,l_start_date
259: ,l_end_date
260: ,l_effective_date

Line 522: PAY_AE_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

518: IF g_debug THEN
519: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
520: END IF;
521:
522: PAY_AE_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
523: ,l_business_group_id
524: ,l_start_date
525: ,l_end_date
526: ,l_effective_date

Line 1128: l_country:=PAY_AE_ARCHIVE.get_country_name(rec_primary_address.country);

1124:
1125: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 5');*/
1126:
1127: /* COUNTRY */
1128: l_country:=PAY_AE_ARCHIVE.get_country_name(rec_primary_address.country);
1129:
1130: l_emp_country:=PAY_AE_ARCHIVE.get_country_name(rec_employer_address.country);
1131:
1132: l_org_country:=PAY_AE_ARCHIVE.get_country_name(rec_org_address.country);

Line 1130: l_emp_country:=PAY_AE_ARCHIVE.get_country_name(rec_employer_address.country);

1126:
1127: /* COUNTRY */
1128: l_country:=PAY_AE_ARCHIVE.get_country_name(rec_primary_address.country);
1129:
1130: l_emp_country:=PAY_AE_ARCHIVE.get_country_name(rec_employer_address.country);
1131:
1132: l_org_country:=PAY_AE_ARCHIVE.get_country_name(rec_org_address.country);
1133:
1134: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');*/

Line 1132: l_org_country:=PAY_AE_ARCHIVE.get_country_name(rec_org_address.country);

1128: l_country:=PAY_AE_ARCHIVE.get_country_name(rec_primary_address.country);
1129:
1130: l_emp_country:=PAY_AE_ARCHIVE.get_country_name(rec_employer_address.country);
1131:
1132: l_org_country:=PAY_AE_ARCHIVE.get_country_name(rec_org_address.country);
1133:
1134: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');*/
1135: /* Total Earnings YTD */
1136: /*l_defined_balance_id := PAY_AE_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_EARNINGS_ASG_YTD');

Line 1136: /*l_defined_balance_id := PAY_AE_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_EARNINGS_ASG_YTD');

1132: l_org_country:=PAY_AE_ARCHIVE.get_country_name(rec_org_address.country);
1133:
1134: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');*/
1135: /* Total Earnings YTD */
1136: /*l_defined_balance_id := PAY_AE_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_EARNINGS_ASG_YTD');
1137: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
1138:
1139: l_formatted_value := to_char(l_balance_value, g_format_mask);*/
1140:

Line 1142: /*l_defined_balance_id_ded := PAY_AE_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_DEDUCTIONS_ASG_YTD');

1138:
1139: l_formatted_value := to_char(l_balance_value, g_format_mask);*/
1140:
1141: /* Total Deductions YTD */
1142: /*l_defined_balance_id_ded := PAY_AE_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_DEDUCTIONS_ASG_YTD');
1143: l_balance_value_ded := pay_balance_pkg.get_value(l_defined_balance_id_ded, p_assignment_action_id);
1144:
1145: l_formatted_value_ded := to_char(l_balance_value_ded, g_format_mask);*/
1146:

Line 2242: PAY_AE_ARCHIVE.SETUP_BALANCE_DEFINITIONS(p_balance_name => rec_get_balance.narrative

2238: OPEN csr_uom(rec_get_balance.balance_type_id);
2239: FETCH csr_uom INTO l_uom;
2240: CLOSE csr_uom;
2241:
2242: PAY_AE_ARCHIVE.SETUP_BALANCE_DEFINITIONS(p_balance_name => rec_get_balance.narrative
2243: ,p_defined_balance_id => l_defined_balance_id
2244: ,p_balance_type_id => rec_get_balance.balance_type_id
2245: ,p_uom => l_uom);
2246: END LOOP;

Line 2474: END PAY_AE_ARCHIVE;

2470: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2471: END IF;
2472:
2473: END ARCHIVE_CODE;
2474: END PAY_AE_ARCHIVE;