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_SE_PAYSLIP_ARCHIVE dependencies on PAY_SE_PAYSLIP_ARCHIVE

Line 1: PACKAGE BODY PAY_SE_PAYSLIP_ARCHIVE AS

1: PACKAGE BODY PAY_SE_PAYSLIP_ARCHIVE AS
2: /* $Header: pysepysa.pkb 120.5 2010/10/28 08:56:01 vijranga noship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: TYPE element_rec IS RECORD (
5: classification_name VARCHAR2(60)

Line 31: g_package VARCHAR2(33) := ' PAY_SE_PAYSLIP_ARCHIVE.';

27: g_lock_table lock_table;
28: g_index NUMBER := -1;
29: g_index_assact NUMBER := -1;
30: g_index_bal NUMBER := -1;
31: g_package VARCHAR2(33) := ' PAY_SE_PAYSLIP_ARCHIVE.';
32: g_payroll_action_id NUMBER;
33: g_arc_payroll_action_id NUMBER;
34: g_business_group_id NUMBER;
35: g_format_mask VARCHAR2(50);

Line 102: SELECT PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')

98: ,p_payroll_id OUT NOCOPY VARCHAR2
99: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
100: --
101: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
102: SELECT PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
103: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
104: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
105: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
106: ,effective_date

Line 103: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')

99: ,p_consolidation_set OUT NOCOPY VARCHAR2) IS
100: --
101: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
102: SELECT PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
103: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
104: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
105: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
106: ,effective_date
107: ,business_group_id

Line 104: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')

100: --
101: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
102: SELECT PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
103: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
104: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
105: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
106: ,effective_date
107: ,business_group_id
108: FROM pay_payroll_actions

Line 105: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')

101: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
102: SELECT PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'PAYROLL_ID')
103: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'CONSOLIDATION_SET_ID')
104: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'START_DATE')
105: ,PAY_SE_PAYSLIP_ARCHIVE.GET_PARAMETER(legislative_parameters,'END_DATE')
106: ,effective_date
107: ,business_group_id
108: FROM pay_payroll_actions
109: WHERE payroll_action_id = p_payroll_action_id;

Line 232: PAY_SE_PAYSLIP_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

228: IF g_debug THEN
229: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
230: END IF;
231: --fnd_file.put_line(fnd_file.log,'Entering Procedure RANGE_CODE ');
232: PAY_SE_PAYSLIP_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
233: ,l_business_group_id
234: ,l_start_date
235: ,l_end_date
236: ,l_effective_date

Line 472: PAY_SE_PAYSLIP_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id

468: END IF;
469: --fnd_file.put_line(fnd_file.log,'Entering Procedure ASSIGNMENT_ACTION_CODE ');
470: --fnd_file.put_line(fnd_file.log,'p_payroll_action_id === ' || p_payroll_action_id);
471:
472: PAY_SE_PAYSLIP_ARCHIVE.GET_ALL_PARAMETERS(p_payroll_action_id
473: ,l_business_group_id
474: ,l_start_date
475: ,l_end_date
476: ,l_effective_date

Line 972: l_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_primary_address.country);

968: l_postal_code := rec_primary_address.postal_code;
969: END IF;
970: --Bug#8849455 fix Added space between 3 and 4 digits in postal code
971: l_postal_code := substr(l_postal_code,1,3)||' '||substr(l_postal_code,4,2);
972: l_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_primary_address.country);
973: /*
974: IF rec_employer_address.style = 'SE' THEN
975: l_emp_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_employer_address.postal_code);
976: ELSE

Line 979: l_emp_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);

975: l_emp_postal_code := hr_general.decode_lookup('SE_POSTAL_CODE',rec_employer_address.postal_code);
976: ELSE
977: l_emp_postal_code := rec_employer_address.postal_code;
978: END IF;
979: l_emp_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);
980: */
981: --fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');
982: /* INSERT PERSON DETAILS */
983:

Line 2301: PAY_SE_PAYSLIP_ARCHIVE.SETUP_BALANCE_DEFINITIONS

2297: OPEN csr_def_balance(rec_get_balance.balance_type_id,rec_get_balance.balance_dim_id);
2298: FETCH csr_def_balance INTO l_defined_balance_id;
2299: CLOSE csr_def_balance;
2300: --fnd_file.put_line(fnd_file.log,'Calling SETUP_BALANCE_DEFINITIONS in Archive oth balance');
2301: PAY_SE_PAYSLIP_ARCHIVE.SETUP_BALANCE_DEFINITIONS
2302: (p_balance_name => rec_get_balance.narrative
2303: ,p_defined_balance_id => l_defined_balance_id
2304: ,p_balance_type_id => rec_get_balance.balance_type_id);
2305: END LOOP;

Line 3872: l_emp_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);

3868: l_emp_postal_code := rec_employer_address.postal_code;
3869: END IF;
3870: -- Bug#8849455 fix Added space between 3 and 4 digits in postal code
3871: l_emp_postal_code := substr(l_emp_postal_code,1,3)||' '||substr(l_emp_postal_code,4,2);
3872: l_emp_country:=PAY_SE_PAYSLIP_ARCHIVE.get_country_name(rec_employer_address.country);
3873:
3874: pay_action_information_api.create_action_information (
3875: p_action_information_id => l_action_info_id
3876: ,p_action_context_id => p_payroll_action_id

Line 3926: END PAY_SE_PAYSLIP_ARCHIVE;

3922: END if;
3923: RAISE;
3924: END;
3925:
3926: END PAY_SE_PAYSLIP_ARCHIVE;