1: PACKAGE BODY PAY_FI_ARCHIVE_TEL AS
2: /* $Header: pyfitela.pkb 120.16.12000000.3 2007/03/20 06:54:37 dbehera noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
12:
13: g_index NUMBER := -1;
14: g_index_assact NUMBER := -1;
15: g_index_bal NUMBER := -1;
16: g_package VARCHAR2(33) := ' PAY_FI_ARCHIVE_TEL.';
17: g_payroll_action_id NUMBER;
18:
19: g_arc_payroll_action_id NUMBER;
20: -- Record for Absence
105: )
106: IS
107: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
108: SELECT
109: PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM') PPID
110: ,TO_NUMBER ( PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID') ) Legal
111: ,TO_NUMBER (PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID') ) Local_unit
112: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REPORT') Annual_Report
113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))
106: IS
107: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
108: SELECT
109: PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM') PPID
110: ,TO_NUMBER ( PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID') ) Legal
111: ,TO_NUMBER (PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID') ) Local_unit
112: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REPORT') Annual_Report
113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))
114: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
107: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
108: SELECT
109: PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM') PPID
110: ,TO_NUMBER ( PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID') ) Legal
111: ,TO_NUMBER (PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID') ) Local_unit
112: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REPORT') Annual_Report
113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))
114: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
115: -- ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'TEST') TEST_OR_NOT
108: SELECT
109: PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM') PPID
110: ,TO_NUMBER ( PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID') ) Legal
111: ,TO_NUMBER (PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID') ) Local_unit
112: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REPORT') Annual_Report
113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))
114: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
115: -- ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'TEST') TEST_OR_NOT
116: ,effective_date Effective_date
109: PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'PENSION_INS_NUM') PPID
110: ,TO_NUMBER ( PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID') ) Legal
111: ,TO_NUMBER (PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID') ) Local_unit
112: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REPORT') Annual_Report
113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))
114: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
115: -- ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'TEST') TEST_OR_NOT
116: ,effective_date Effective_date
117: ,business_group_id BG_ID FROM pay_payroll_actions
110: ,TO_NUMBER ( PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID') ) Legal
111: ,TO_NUMBER (PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID') ) Local_unit
112: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REPORT') Annual_Report
113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))
114: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
115: -- ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'TEST') TEST_OR_NOT
116: ,effective_date Effective_date
117: ,business_group_id BG_ID FROM pay_payroll_actions
118: WHERE payroll_action_id = p_payroll_action_id;
111: ,TO_NUMBER (PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID') ) Local_unit
112: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REPORT') Annual_Report
113: ,FND_DATE.CANONICAL_TO_DATE(PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'REF_DATE'))
114: ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
115: -- ,PAY_FI_ARCHIVE_TEL.GET_PARAMETER(legislative_parameters,'TEST') TEST_OR_NOT
116: ,effective_date Effective_date
117: ,business_group_id BG_ID FROM pay_payroll_actions
118: WHERE payroll_action_id = p_payroll_action_id;
119:
341: g_local_unit_id := null;
342: g_annual_report:= null;
343: g_archive := null;
344:
345: PAY_FI_ARCHIVE_TEL.GET_ALL_PARAMETERS
346: (p_payroll_action_id
347: ,g_business_group_id
348: ,g_effective_date
349: ,g_pension_ins_num
777: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
778: END IF;
779: fnd_file.put_line(fnd_file.log,' ASSIGNMENT_ACTION_CODE ');
780:
781: PAY_FI_ARCHIVE_TEL.GET_ALL_PARAMETERS
782: (p_payroll_action_id
783: ,g_business_group_id
784: ,g_effective_date
785: ,g_pension_ins_num
929: g_local_unit_id := null;
930: g_annual_report:= null;
931: g_archive := null;
932:
933: PAY_FI_ARCHIVE_TEL.GET_ALL_PARAMETERS
934: (p_payroll_action_id
935: ,g_business_group_id
936: ,g_effective_date
937: ,g_pension_ins_num
2137: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2138: END IF;
2139:
2140: END ARCHIVE_CODE;
2141: END PAY_FI_ARCHIVE_TEL;