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_SA_ARCHIVE dependencies on PAY_SA_ARCHIVE

Line 1: PACKAGE BODY PAY_SA_ARCHIVE AS

1: PACKAGE BODY PAY_SA_ARCHIVE AS
2: /* $Header: pysaparc.pkb 120.14.12020000.2 2012/12/20 09:33:06 bkeshary ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 36: g_package VARCHAR2(33) := ' PAY_SA_ARCHIVE.';

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

Line 108: SELECT PAY_SA_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

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

Line 109: ,PAY_SA_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')

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

Line 110: ,PAY_SA_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')

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

Line 111: ,PAY_SA_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')

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

Line 249: PAY_SA_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

245: IF g_debug THEN
246: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
247: END IF;
248:
249: PAY_SA_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
250: ,l_business_group_id
251: ,l_start_date
252: ,l_end_date
253: ,l_effective_date

Line 514: PAY_SA_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

510: IF g_debug THEN
511: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
512: END IF;
513:
514: PAY_SA_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
515: ,l_business_group_id
516: ,l_start_date
517: ,l_end_date
518: ,l_effective_date

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

1124: ELSE
1125: l_city:= rec_primary_address.city;
1126: END IF;
1127:
1128: l_country:=PAY_SA_ARCHIVE.get_country_name(rec_primary_address.country);
1129: l_emp_city := null;
1130: IF rec_employer_address.style = 'SA' THEN
1131: l_emp_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1132: ELSE

Line 1136: l_emp_country:=PAY_SA_ARCHIVE.get_country_name(rec_employer_address.country);

1132: ELSE
1133: l_emp_city:= rec_employer_address.city;
1134: END IF;
1135:
1136: l_emp_country:=PAY_SA_ARCHIVE.get_country_name(rec_employer_address.country);
1137: l_org_city := null;
1138: IF rec_org_address.style = 'SA' THEN
1139: --l_org_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1140: l_org_city:= hr_general.decode_lookup('SA_CITY',rec_org_address.city);

Line 1146: l_org_country:=PAY_SA_ARCHIVE.get_country_name(rec_org_address.country);

1142: --l_org_city:= rec_employer_address.city;
1143: l_org_city:= rec_org_address.city;
1144: END IF;
1145:
1146: l_org_country:=PAY_SA_ARCHIVE.get_country_name(rec_org_address.country);
1147:
1148:
1149:
1150: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');*/

Line 1162: l_defined_balance_id := PAY_SA_ARCHIVE.GET_DEFINED_BALANCE_ID('GOSI_REFERENCE_EARNINGS_ASG_YTD');

1158: OPEN get_upper_base;
1159: FETCH get_upper_base INTO l_upper_base;
1160: CLOSE get_upper_base;
1161:
1162: l_defined_balance_id := PAY_SA_ARCHIVE.GET_DEFINED_BALANCE_ID('GOSI_REFERENCE_EARNINGS_ASG_YTD');
1163: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
1164:
1165: --Check for lower and upper limits of the reference salary
1166:

Line 2256: PAY_SA_ARCHIVE.SETUP_BALANCE_DEFINITIONS(p_balance_name => rec_get_balance.narrative

2252: OPEN csr_def_balance(rec_get_balance.balance_type_id,rec_get_balance.balance_dim_id);
2253: FETCH csr_def_balance INTO l_defined_balance_id;
2254: CLOSE csr_def_balance;
2255:
2256: PAY_SA_ARCHIVE.SETUP_BALANCE_DEFINITIONS(p_balance_name => rec_get_balance.narrative
2257: ,p_defined_balance_id => l_defined_balance_id
2258: ,p_balance_type_id => rec_get_balance.balance_type_id);
2259: END LOOP;
2260: CLOSE csr_get_balance;

Line 2509: END PAY_SA_ARCHIVE;

2505: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2506: END IF;
2507:
2508: END ARCHIVE_CODE;
2509: END PAY_SA_ARCHIVE;