DBA Data[Home] [Help]

APPS.PAY_DK_ABSR_PKG dependencies on PAY_DK_ABSR_PKG

Line 1: PACKAGE BODY PAY_DK_ABSR_PKG AS

1: PACKAGE BODY PAY_DK_ABSR_PKG AS
2: /* $Header: pydkabsr.pkb 120.1 2010/08/21 19:43:10 rsahai noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_ABSR_PKG.';

Line 5: g_package CONSTANT varchar2(33) := 'PAY_DK_ABSR_PKG.';

1: PACKAGE BODY PAY_DK_ABSR_PKG AS
2: /* $Header: pydkabsr.pkb 120.1 2010/08/21 19:43:10 rsahai noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_ABSR_PKG.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7: g_err_num NUMBER;
8:
9:

Line 94: PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')

90: IS
91:
92: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
93: SELECT
94: PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
95: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')
97: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date

Line 95: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')

91:
92: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
93: SELECT
94: PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
95: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')
97: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

Line 96: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')

92: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
93: SELECT
94: PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
95: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')
97: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
100: ,business_group_id

Line 97: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')

93: SELECT
94: PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
95: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')
97: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
100: ,business_group_id
101: FROM pay_payroll_actions

Line 99: ,fnd_date.canonical_to_date(PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

95: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
96: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')
97: ,PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
98: ,effective_date
99: ,fnd_date.canonical_to_date(PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
100: ,business_group_id
101: FROM pay_payroll_actions
102: WHERE payroll_action_id = p_payroll_action_id;
103:

Line 331: PAY_DK_ABSR_PKG.GET_ALL_PARAMETERS(

327: AND ppa.business_group_id = ppf.business_group_id
328: ORDER BY ppf.person_id';
329:
330: -- Fetch the input parameter values
331: PAY_DK_ABSR_PKG.GET_ALL_PARAMETERS(
332: pactid
333: ,l_business_group_id
334: ,l_payroll_id
335: ,l_sender_id

Line 790: SELECT PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')

786: IF g_debug THEN
787: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',10);
788: END IF;
789:
790: SELECT PAY_DK_ABSR_PKG.GET_PARAMETER(legislative_parameters,'YEAR')
791: INTO l_year
792: FROM pay_payroll_actions
793: WHERE payroll_action_id = p_payroll_action_id;
794:

Line 1497: END PAY_DK_ABSR_PKG;

1493: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
1494: HR_UTILITY.RAISE_ERROR;
1495: END WritetoCLOB;
1496:
1497: END PAY_DK_ABSR_PKG;