1: PACKAGE BODY PAY_FI_ARCHIVE_DPSA AS
2: /* $Header: pyfidpsa.pkb 120.5.12000000.1 2007/04/26 13:01:12 dbehera noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_FI_ARCHIVE_DPSA.';
1: PACKAGE BODY PAY_FI_ARCHIVE_DPSA AS
2: /* $Header: pyfidpsa.pkb 120.5.12000000.1 2007/04/26 13:01:12 dbehera noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_FI_ARCHIVE_DPSA.';
6: g_payroll_action_id NUMBER ;
7: g_le_assignment_action_id NUMBER ;
8: g_lu_assignment_action_id NUMBER ;
9: g_emp_type VARCHAR2(2);
76: ,p_archive OUT NOCOPY VARCHAR2
77: ) IS
78:
79: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
80: SELECT PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
81: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
82: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
83: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'TRANSACTION_TYPE')
84: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'DEDUCTIONS_SS') DEDUCTIONS_SS
77: ) IS
78:
79: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
80: SELECT PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
81: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
82: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
83: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'TRANSACTION_TYPE')
84: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'DEDUCTIONS_SS') DEDUCTIONS_SS
85: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
78:
79: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
80: SELECT PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
81: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
82: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
83: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'TRANSACTION_TYPE')
84: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'DEDUCTIONS_SS') DEDUCTIONS_SS
85: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
86: ,effective_date
79: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
80: SELECT PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
81: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
82: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
83: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'TRANSACTION_TYPE')
84: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'DEDUCTIONS_SS') DEDUCTIONS_SS
85: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
86: ,effective_date
87: ,business_group_id
80: SELECT PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')
81: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
82: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
83: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'TRANSACTION_TYPE')
84: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'DEDUCTIONS_SS') DEDUCTIONS_SS
85: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
86: ,effective_date
87: ,business_group_id
88: FROM pay_payroll_actions
81: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')
82: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')
83: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'TRANSACTION_TYPE')
84: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'DEDUCTIONS_SS') DEDUCTIONS_SS
85: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'ARCHIVE')
86: ,effective_date
87: ,business_group_id
88: FROM pay_payroll_actions
89: WHERE payroll_action_id = p_payroll_action_id;
239: g_deduction_ss := NULL ;
240:
241: fnd_file.put_line(fnd_file.log,'Range Code 3');
242:
243: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS(
244: p_payroll_action_id
245: ,l_business_group_id
246: ,g_legal_employer_id
247: ,g_local_unit_id
587: IF g_debug THEN
588: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
589: END IF;
590:
591: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS(
592: p_payroll_action_id
593: ,g_business_group_id
594: ,g_legal_employer_id
595: ,g_local_unit_id
1153: FETCH csr_rpt_header INTO rg_csr_rpt_header;
1154: CLOSE csr_rpt_header;
1155:
1156: /* Fetching report parameters */
1157: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS
1158: ( rg_csr_rpt_header.payroll_action_id
1159: ,g_business_group_id
1160: ,g_legal_employer_id
1161: ,g_local_unit_id
3129: OPEN csr_prpt_header(p_payroll_action_id);
3130: FETCH csr_prpt_header INTO rg_csr_prpt_header;
3131: CLOSE csr_prpt_header;
3132:
3133: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS(
3134: p_payroll_action_id
3135: ,g_business_group_id
3136: ,g_legal_employer_id
3137: ,g_local_unit_id
3502: g_deduction_ss :=NULL;
3503: g_effective_date :=NULL;
3504: g_archive :=NULL;
3505:
3506: END PAY_FI_ARCHIVE_DPSA;