DBA Data[Home] [Help]

APPS.PAY_FR_DADS_PKG dependencies on PAY_FR_DADS_PKG

Line 1: package body PAY_FR_DADS_PKG as

1: package body PAY_FR_DADS_PKG as
2: /* $Header: pyfrdads.pkb 120.1 2006/03/16 10:31 aparkes noship $ */
3: --
4: -- Globals
5: --

Line 6: g_package CONSTANT VARCHAR2(20):= 'pay_fr_dads_pkg.';

2: /* $Header: pyfrdads.pkb 120.1 2006/03/16 10:31 aparkes noship $ */
3: --
4: -- Globals
5: --
6: g_package CONSTANT VARCHAR2(20):= 'pay_fr_dads_pkg.';
7: --
8: g_cache_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
9: g_param_issuing_estab_id hr_organization_information.organization_id%TYPE;
10: g_param_company_id hr_organization_information.organization_id%TYPE;

Line 120: pay_fr_dads_pkg.get_all_parameters (

116: hr_utility.set_location('Entering ' || l_proc,20);
117: --
118: if g_cache_payroll_action_id is null
119: or g_cache_payroll_action_id <> pactid then
120: pay_fr_dads_pkg.get_all_parameters (
121: p_payroll_action_id => pactid
122: ,p_issuing_estab_id => g_param_issuing_estab_id
123: ,p_company_id => g_param_company_id
124: ,p_estab_id => g_param_estab_id

Line 175: pay_fr_dads_pkg.get_all_parameters (

171: --
172: hr_utility.set_location('Entering ' || l_proc, 10);
173: if g_cache_payroll_action_id is null
174: or g_cache_payroll_action_id <> p_payroll_action_id then
175: pay_fr_dads_pkg.get_all_parameters (
176: p_payroll_action_id => p_payroll_action_id
177: ,p_issuing_estab_id => g_param_issuing_estab_id
178: ,p_company_id => g_param_company_id
179: ,p_estab_id => g_param_estab_id

Line 297: SELECT pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ISSUING_ESTAB_ID')

293: ,p_start_date out nocopy date
294: ,p_effective_date out nocopy date) is
295: --
296: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
297: SELECT pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ISSUING_ESTAB_ID')
298: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'COMPANY_ID')
299: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ESTAB_ID')
300: ,business_group_id
301: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'REFERENCE')

Line 298: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'COMPANY_ID')

294: ,p_effective_date out nocopy date) is
295: --
296: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
297: SELECT pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ISSUING_ESTAB_ID')
298: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'COMPANY_ID')
299: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ESTAB_ID')
300: ,business_group_id
301: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'REFERENCE')
302: ,start_date

Line 299: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ESTAB_ID')

295: --
296: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
297: SELECT pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ISSUING_ESTAB_ID')
298: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'COMPANY_ID')
299: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ESTAB_ID')
300: ,business_group_id
301: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'REFERENCE')
302: ,start_date
303: ,effective_date

Line 301: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'REFERENCE')

297: SELECT pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ISSUING_ESTAB_ID')
298: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'COMPANY_ID')
299: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ESTAB_ID')
300: ,business_group_id
301: ,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'REFERENCE')
302: ,start_date
303: ,effective_date
304: FROM pay_payroll_actions
305: WHERE payroll_action_id = p_payroll_action_id;

Line 354: pay_fr_dads_pkg.get_all_parameters (

350: --
351: BEGIN
352: if g_cache_payroll_action_id is null
353: or g_cache_payroll_action_id <> p_payroll_action_id then
354: pay_fr_dads_pkg.get_all_parameters (
355: p_payroll_action_id => p_payroll_action_id
356: ,p_issuing_estab_id => g_param_issuing_estab_id
357: ,p_company_id => g_param_company_id
358: ,p_estab_id => g_param_estab_id

Line 407: END pay_fr_dads_pkg;

403: --
404: --
405: end deinitialize_code;
406: --
407: END pay_fr_dads_pkg;