APPS.PAY_US_PAYMENT_PKG dependencies on PAY_US_PAYMENT_PKG

Line 1: PACKAGE BODY pay_us_payment_pkg AS

1: PACKAGE BODY pay_us_payment_pkg AS
2: /* $Header: pyuspymt.pkb 120.0 2005/05/29 09:52:43 appldev noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_payment_pkg

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_payment_pkg
21:
22: Description : This package contains the function get_trx_date to
23: fetch the payment date.
24:

Line 160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);

156: l_override_date pay_payroll_actions.overriding_dd_date%TYPE;
157: l_table_count NUMBER;
158: BEGIN
159: -- hr_utility.trace_on (NULL, 'PYMT');
160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);
161: hr_utility.TRACE ('p_business_group_id: ' || p_business_group_id);
162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);
163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);
164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);

Line 187: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date',

183: IF ltr_override_date_table (j).payroll_action_id =
184: p_payroll_action_id
185: THEN
186: l_override_date := ltr_override_date_table (j).override_date;
187: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date',
188: 20
189: );
190: EXIT;
191: END IF;

Line 210: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 30);

206: INTO l_override_date;
207:
208: CLOSE c_get_override_date;
209:
210: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 30);
211: l_table_count := ltr_override_date_table.COUNT;
212: ltr_override_date_table (l_table_count).payroll_action_id :=
213: p_payroll_action_id;
214: ltr_override_date_table (l_table_count).override_date :=

Line 223: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 40);

219: THEN
220: IF p_payment_date IS NOT NULL
221: THEN
222: l_override_date := p_payment_date;
223: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 40);
224: ELSIF p_pre_payment_id IS NOT NULL
225: THEN
226: /* Just fetch prepayment action's effective_date with pre_payment_id.
227: This improves performance by not checking for interlocks */

Line 235: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 50);

231: INTO l_override_date;
232:
233: CLOSE c_get_pymt_date_with_prepay_id;
234:
235: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 50);
236: ELSE
237: /* With the help of interlocks, get prepayment effective_date */
238: OPEN c_get_pymt_effective_date (p_business_group_id,
239: p_payroll_action_id,

Line 254: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 60);

250: INTO l_override_date;
251:
252: CLOSE c_get_pymt_effective_date;
253:
254: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 60);
255: END IF; -- if p_payment_date is not null
256: END IF; -- if l_override_date is null
257: END IF;
258:

Line 262: END pay_us_payment_pkg;

258:
259: -- if p_override_date is not null
260: RETURN l_override_date;
261: END;
262: END pay_us_payment_pkg;