DBA Data[Home] [Help]

APPS.PAY_NO_PACCR_PKG dependencies on PAY_NO_PACCR_PKG

Line 1: PACKAGE BODY PAY_NO_PACCR_PKG AS

1: PACKAGE BODY PAY_NO_PACCR_PKG AS
2: /* $Header: pynopaccr.pkb 120.5.12000000.3 2007/07/05 10:07:34 kseth noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_NO_PACCR_PKG.';

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

1: PACKAGE BODY PAY_NO_PACCR_PKG AS
2: /* $Header: pynopaccr.pkb 120.5.12000000.3 2007/07/05 10:07:34 kseth noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_NO_PACCR_PKG.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7: g_err_num NUMBER;
8:
9:

Line 77: PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')

73:
74:
75: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
76: SELECT
77: PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
78: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
79: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'RESTRICT_EMPLR_CONTR')
80: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ELEMENT_NAME')
81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')

Line 78: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')

74:
75: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
76: SELECT
77: PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
78: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
79: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'RESTRICT_EMPLR_CONTR')
80: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ELEMENT_NAME')
81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')
82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')

Line 79: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'RESTRICT_EMPLR_CONTR')

75: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
76: SELECT
77: PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
78: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
79: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'RESTRICT_EMPLR_CONTR')
80: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ELEMENT_NAME')
81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')
82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')
83: ,effective_date

Line 80: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ELEMENT_NAME')

76: SELECT
77: PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
78: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
79: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'RESTRICT_EMPLR_CONTR')
80: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ELEMENT_NAME')
81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')
82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')
83: ,effective_date
84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))

Line 81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')

77: PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'PAYROLL')
78: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
79: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'RESTRICT_EMPLR_CONTR')
80: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ELEMENT_NAME')
81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')
82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')
83: ,effective_date
84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))
85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

Line 82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')

78: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
79: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'RESTRICT_EMPLR_CONTR')
80: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ELEMENT_NAME')
81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')
82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')
83: ,effective_date
84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))
85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
86: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))

80: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ELEMENT_NAME')
81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')
82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')
83: ,effective_date
84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))
85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
86: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,business_group_id
88: FROM pay_payroll_actions

Line 85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))

81: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'EOY_CODE')
82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')
83: ,effective_date
84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))
85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
86: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,business_group_id
88: FROM pay_payroll_actions
89: WHERE payroll_action_id = p_payroll_action_id;

Line 86: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')

82: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'COSTING_SEG')
83: ,effective_date
84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))
85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
86: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,business_group_id
88: FROM pay_payroll_actions
89: WHERE payroll_action_id = p_payroll_action_id;
90:

Line 226: PAY_NO_PACCR_PKG.GET_ALL_PARAMETERS(

222: ORDER BY ppf.person_id';
223:
224:
225: -- Fetch the input parameter values
226: PAY_NO_PACCR_PKG.GET_ALL_PARAMETERS(
227: pactid
228: ,l_business_group_id
229: ,l_payroll_id
230: ,l_le_id

Line 1738: END PAY_NO_PACCR_PKG;

1734: HR_UTILITY.RAISE_ERROR;
1735: END WritetoCLOB;
1736:
1737:
1738: END PAY_NO_PACCR_PKG;