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_LTFA dependencies on PAY_FI_ARCHIVE_LTFA

Line 1: PACKAGE BODY PAY_FI_ARCHIVE_LTFA AS

1: PACKAGE BODY PAY_FI_ARCHIVE_LTFA AS
2: /* $Header: pyfiltfa.pkb 120.4.12000000.4 2007/03/20 05:39:29 dbehera noship $ */
3:
4: TYPE lock_rec IS RECORD (
5: archive_assact_id NUMBER);

Line 14: g_package VARCHAR2(33) := ' PAY_FI_ARCHIVE_LTFA.';

10: g_lock_table lock_table;
11: g_index NUMBER := -1;
12: g_index_assact NUMBER := -1;
13: g_index_bal NUMBER := -1;
14: g_package VARCHAR2(33) := ' PAY_FI_ARCHIVE_LTFA.';
15: g_archive VARCHAR2(1);
16: g_emp_type VARCHAR2(2);
17: g_legal_employer_id NUMBER;
18: g_local_unit_id NUMBER ;

Line 90: SELECT PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')

86: ,p_archive OUT NOCOPY VARCHAR2
87: ) IS
88:
89: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
90: SELECT PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
91: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
92: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM')
93: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')
94: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')

Line 91: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')

87: ) IS
88:
89: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
90: SELECT PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
91: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
92: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM')
93: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')
94: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
95: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 92: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM')

88:
89: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
90: SELECT PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
91: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
92: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM')
93: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')
94: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
95: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
96: ,effective_date

Line 93: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')

89: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
90: SELECT PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
91: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
92: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM')
93: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')
94: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
95: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
96: ,effective_date
97: ,business_group_id

Line 94: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')

90: SELECT PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_NAME')
91: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
92: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM')
93: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')
94: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
95: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
96: ,effective_date
97: ,business_group_id
98: FROM pay_payroll_actions

Line 95: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'ARCHIVE')

91: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
92: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM')
93: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'MONTH_RPT')
94: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
95: ,PAY_FI_ARCHIVE_LTFA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
96: ,effective_date
97: ,business_group_id
98: FROM pay_payroll_actions
99: WHERE payroll_action_id = p_payroll_action_id;

Line 328: PAY_FI_ARCHIVE_LTFA.GET_ALL_PARAMETERS(

324: g_lu_assignment_action_id := NULL ;
325:
326:
327: --fnd_file.put_line(fnd_file.log,'Range Code 2');
328: PAY_FI_ARCHIVE_LTFA.GET_ALL_PARAMETERS(
329: p_payroll_action_id
330: ,l_business_group_id
331: ,g_pension_ins_num
332: ,g_legal_employer_id

Line 728: PAY_FI_ARCHIVE_LTFA.GET_ALL_PARAMETERS(

724: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
725: END IF;
726:
727: --fnd_file.put_line(fnd_file.log,'Assignment Action Code 1');
728: PAY_FI_ARCHIVE_LTFA.GET_ALL_PARAMETERS(
729: p_payroll_action_id
730: ,l_business_group_id
731: ,g_pension_ins_num
732: ,g_legal_employer_id

Line 1131: PAY_FI_ARCHIVE_LTFA.GET_ALL_PARAMETERS(

1127: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);
1128: END IF;
1129: /*
1130: --fnd_file.put_line(fnd_file.log,'Deinitialization Code 1');
1131: PAY_FI_ARCHIVE_LTFA.GET_ALL_PARAMETERS(
1132: p_payroll_action_id
1133: ,l_business_group_id
1134: ,l_pension_type
1135: ,g_pension_provider

Line 1227: END PAY_FI_ARCHIVE_LTFA;

1223: g_local_unit_id := NULL ;
1224: g_effective_date := NULL ;
1225: g_pension_ins_num := NULL ;
1226: g_payroll_action_id := NULL ;
1227: END PAY_FI_ARCHIVE_LTFA;