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.6.12010000.3 2008/08/06 08:17:01 ubhat 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 513: PAY_SA_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

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

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

1111: ELSE
1112: l_city:= rec_primary_address.city;
1113: END IF;
1114:
1115: l_country:=PAY_SA_ARCHIVE.get_country_name(rec_primary_address.country);
1116: l_emp_city := null;
1117: IF rec_employer_address.style = 'SA' THEN
1118: l_emp_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1119: ELSE

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

1119: ELSE
1120: l_emp_city:= rec_employer_address.city;
1121: END IF;
1122:
1123: l_emp_country:=PAY_SA_ARCHIVE.get_country_name(rec_employer_address.country);
1124: l_org_city := null;
1125: IF rec_org_address.style = 'SA' THEN
1126: --l_org_city:= hr_general.decode_lookup('SA_CITY',rec_employer_address.city);
1127: l_org_city:= hr_general.decode_lookup('SA_CITY',rec_org_address.city);

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

1129: --l_org_city:= rec_employer_address.city;
1130: l_org_city:= rec_org_address.city;
1131: END IF;
1132:
1133: l_org_country:=PAY_SA_ARCHIVE.get_country_name(rec_org_address.country);
1134:
1135:
1136:
1137: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');*/

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

1145: OPEN get_upper_base;
1146: FETCH get_upper_base INTO l_upper_base;
1147: CLOSE get_upper_base;
1148:
1149: l_defined_balance_id := PAY_SA_ARCHIVE.GET_DEFINED_BALANCE_ID('GOSI_REFERENCE_EARNINGS_ASG_YTD');
1150: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
1151:
1152: --Check for lower and upper limits of the reference salary
1153:

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

2144: OPEN csr_def_balance(rec_get_balance.balance_type_id,rec_get_balance.balance_dim_id);
2145: FETCH csr_def_balance INTO l_defined_balance_id;
2146: CLOSE csr_def_balance;
2147:
2148: PAY_SA_ARCHIVE.SETUP_BALANCE_DEFINITIONS(p_balance_name => rec_get_balance.narrative
2149: ,p_defined_balance_id => l_defined_balance_id
2150: ,p_balance_type_id => rec_get_balance.balance_type_id);
2151: END LOOP;
2152: CLOSE csr_get_balance;

Line 2381: END PAY_SA_ARCHIVE;

2377: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2378: END IF;
2379:
2380: END ARCHIVE_CODE;
2381: END PAY_SA_ARCHIVE;