DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_DPSA dependencies on PAY_FI_ARCHIVE_DPSA

Line 1: PACKAGE BODY PAY_FI_ARCHIVE_DPSA AS

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.';

Line 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);

Line 80: SELECT PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER_ID')

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

Line 81: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_ID')

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')

Line 82: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'YEAR_RPT')

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

Line 83: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'TRANSACTION_TYPE')

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

Line 84: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'DEDUCTIONS_SS') DEDUCTIONS_SS

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

Line 85: ,PAY_FI_ARCHIVE_DPSA.GET_PARAMETER(legislative_parameters,'ARCHIVE')

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;

Line 243: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS(

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

Line 591: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS(

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

Line 1157: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS

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

Line 3133: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS(

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

Line 3506: END PAY_FI_ARCHIVE_DPSA;

3502: g_deduction_ss :=NULL;
3503: g_effective_date :=NULL;
3504: g_archive :=NULL;
3505:
3506: END PAY_FI_ARCHIVE_DPSA;