[Home] [Help]
1: PACKAGE BODY pay_ie_p30lock AS
2: /* $Header: pyiep30p.pkb 120.12 2011/09/15 09:35:53 rsahai ship $ */
3:
4: g_package CONSTANT VARCHAR2(30) := 'Pay_ie_P30lock';
5:
1: PACKAGE BODY pay_ie_p30lock AS
2: /* $Header: pyiep30p.pkb 120.12 2011/09/15 09:35:53 rsahai 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);
199:
200:
201: BEGIN
202: hr_utility.set_location('Entering ' || l_proc,10);
203: pay_ie_p30lock.get_all_parameters
204: (p_payroll_action_id => pactid,
205: p_token => 'END_DATE',
206: p_business_group_id => l_business_group_id,
207: p_token_value => l_end_date);
206: p_business_group_id => l_business_group_id,
207: p_token_value => l_end_date);
208:
209: --Added for bug fix 3567562,to get the consolidation set parameter
210: pay_ie_p30lock.get_all_parameters (
211: p_payroll_action_id => pactid
212: , p_token => 'CONSOLIDATION'
213: , p_business_group_id => l_business_group_id
214: , p_token_value => l_consolidation_set);
296: BEGIN
297:
298: hr_utility.set_location('Entering ' || l_proc,10);
299:
300: pay_ie_p30lock.get_all_parameters
301: (p_payroll_action_id => pactid,
302: p_token => 'PAYROLL_ACTION_ID',
303: p_business_group_id => l_business_group_id,
304: p_token_value => l_pay_action_id);