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_FI_ARCHIVE_PYSA dependencies on PAY_FI_ARCHIVE_PYSA

Line 1: PACKAGE BODY PAY_FI_ARCHIVE_PYSA AS

1: PACKAGE BODY PAY_FI_ARCHIVE_PYSA AS
2: /* $Header: pyfipysa.pkb 120.10 2011/05/17 12:57:18 nchinnam ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: TYPE element_rec IS RECORD (
5: classification_name VARCHAR2(60)

Line 27: g_package VARCHAR2(33) := ' PAY_FI_ARCHIVE_PYSA.';

23: g_lock_table lock_table;
24: g_index NUMBER := -1;
25: g_index_assact NUMBER := -1;
26: g_index_bal NUMBER := -1;
27: g_package VARCHAR2(33) := ' PAY_FI_ARCHIVE_PYSA.';
28: g_payroll_action_id NUMBER;
29: g_arc_payroll_action_id NUMBER;
30: g_business_group_id NUMBER;
31: g_format_mask VARCHAR2(50);

Line 96: SELECT PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

92: ,p_payroll_id OUT NOCOPY VARCHAR2
93: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
94: --
95: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
96: SELECT PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
97: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
98: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'START_DATE')
99: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'END_DATE')
100: ,effective_date

Line 97: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')

93: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
94: --
95: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
96: SELECT PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
97: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
98: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'START_DATE')
99: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'END_DATE')
100: ,effective_date
101: ,business_group_id

Line 98: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'START_DATE')

94: --
95: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
96: SELECT PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
97: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
98: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'START_DATE')
99: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'END_DATE')
100: ,effective_date
101: ,business_group_id
102: FROM pay_payroll_actions

Line 99: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'END_DATE')

95: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
96: SELECT PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
97: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
98: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'START_DATE')
99: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'END_DATE')
100: ,effective_date
101: ,business_group_id
102: FROM pay_payroll_actions
103: WHERE payroll_action_id = p_payroll_action_id;

Line 220: PAY_FI_ARCHIVE_PYSA.GET_ALL_PARAMETERS(p_payroll_action_id

216: BEGIN
217: IF g_debug THEN
218: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
219: END IF;
220: PAY_FI_ARCHIVE_PYSA.GET_ALL_PARAMETERS(p_payroll_action_id
221: ,l_business_group_id
222: ,l_start_date
223: ,l_end_date
224: ,l_effective_date

Line 439: PAY_FI_ARCHIVE_PYSA.GET_ALL_PARAMETERS(p_payroll_action_id

435: BEGIN
436: IF g_debug THEN
437: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
438: END IF;
439: PAY_FI_ARCHIVE_PYSA.GET_ALL_PARAMETERS(p_payroll_action_id
440: ,l_business_group_id
441: ,l_start_date
442: ,l_end_date
443: ,l_effective_date

Line 931: l_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_primary_address.country);

927: l_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_primary_address.postal_code);
928: ELSE
929: l_postal_code := rec_primary_address.postal_code;
930: END IF;
931: l_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_primary_address.country);
932: /*
933: IF rec_employer_address.style = 'FI' THEN
934: l_emp_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_employer_address.postal_code);
935: ELSE

Line 938: l_emp_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_employer_address.country);

934: l_emp_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_employer_address.postal_code);
935: ELSE
936: l_emp_postal_code := rec_employer_address.postal_code;
937: END IF;
938: l_emp_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_employer_address.country);
939: */
940: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');*/
941: /* INSERT PERSON DETAILS */
942: pay_action_information_api.create_action_information (

Line 1750: PAY_FI_ARCHIVE_PYSA.SETUP_BALANCE_DEFINITIONS

1746: EXIT WHEN csr_get_balance%NOTFOUND;
1747: OPEN csr_def_balance(rec_get_balance.balance_type_id,rec_get_balance.balance_dim_id);
1748: FETCH csr_def_balance INTO l_defined_balance_id;
1749: CLOSE csr_def_balance;
1750: PAY_FI_ARCHIVE_PYSA.SETUP_BALANCE_DEFINITIONS
1751: (p_balance_name => rec_get_balance.narrative
1752: ,p_defined_balance_id => l_defined_balance_id
1753: ,p_balance_type_id => rec_get_balance.balance_type_id);
1754: END LOOP;

Line 2999: l_emp_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_employer_address.country);

2995: l_emp_postal_code := hr_general.decode_lookup('FI_POSTAL_CODE',rec_employer_address.postal_code);
2996: ELSE
2997: l_emp_postal_code := rec_employer_address.postal_code;
2998: END IF;
2999: l_emp_country:=PAY_FI_ARCHIVE_PYSA.get_country_name(rec_employer_address.country);
3000:
3001: pay_action_information_api.create_action_information (
3002: p_action_information_id => l_action_info_id
3003: ,p_action_context_id => p_payroll_action_id

Line 3044: END PAY_FI_ARCHIVE_PYSA;

3040: END if;
3041: RAISE;
3042: END;
3043:
3044: END PAY_FI_ARCHIVE_PYSA;