[Home] [Help]
1: PACKAGE BODY pay_ie_p30lock AS
2: /* $Header: pyiep30p.pkb 120.7.12000000.2 2007/06/21 11:53:56 vikgupta ship $ */
3:
4: g_package CONSTANT VARCHAR2(30) := 'Pay_ie_P30lock';
5:
1: PACKAGE BODY pay_ie_p30lock AS
2: /* $Header: pyiep30p.pkb 120.7.12000000.2 2007/06/21 11:53:56 vikgupta ship $ */
3:
4: g_package CONSTANT VARCHAR2(30) := 'Pay_ie_P30lock';
5:
6:
7: FUNCTION get_parameter(
8: p_parameter_string in varchar2
46: ,p_business_group_id out NOCOPY number
47: ,p_token_value out NOCOPY VARCHAR2 ) IS
48:
49: CURSOR csr_parameter_info(p_payroll_action_id IN NUMBER) IS
50: SELECT pay_ie_p30lock.get_parameter(legislative_parameters, p_token)
51: ,business_group_id
52: FROM pay_payroll_actions
53: WHERE payroll_action_id = p_payroll_action_id;
54: l_proc VARCHAR2(160):= g_package||'.get_all_parameters ';
86: BEGIN
87:
88: hr_utility.set_location('Entering ' || l_proc,10);
89:
90: pay_ie_p30lock.get_all_parameters
91: (p_payroll_action_id => pactid,
92: p_token => 'END_DATE',
93: p_business_group_id => l_business_group_id,
94: p_token_value => l_end_date);
193:
194:
195: BEGIN
196: hr_utility.set_location('Entering ' || l_proc,10);
197: pay_ie_p30lock.get_all_parameters
198: (p_payroll_action_id => pactid,
199: p_token => 'END_DATE',
200: p_business_group_id => l_business_group_id,
201: p_token_value => l_end_date);
200: p_business_group_id => l_business_group_id,
201: p_token_value => l_end_date);
202:
203: --Added for bug fix 3567562,to get the consolidation set parameter
204: pay_ie_p30lock.get_all_parameters (
205: p_payroll_action_id => pactid
206: , p_token => 'CONSOLIDATION'
207: , p_business_group_id => l_business_group_id
208: , p_token_value => l_consolidation_set);
290: BEGIN
291:
292: hr_utility.set_location('Entering ' || l_proc,10);
293:
294: pay_ie_p30lock.get_all_parameters
295: (p_payroll_action_id => pactid,
296: p_token => 'PAYROLL_ACTION_ID',
297: p_business_group_id => l_business_group_id,
298: p_token_value => l_pay_action_id);