APPS.HXT_RETRO_MIX dependencies on PAY_PAYWSQEE_PKG

Line 287: pay_paywsqee_pkg.get_input_value_details (

283: pbl_value (i) := NULL;
284: END LOOP;
285:
286: -- Get input values details for this element
287: pay_paywsqee_pkg.get_input_value_details (
288: p_element_type_id,
289: p_date_worked,
290: hxt_value (1).SEQUENCE,
291: hxt_value (2).SEQUENCE,

Line 670: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence (p_batch_id);

666: || pbl_value (i)); --HXT115
667: END LOOP;
668:
669: -- Get next sequence number
670: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence (p_batch_id);
671: hxt_util.DEBUG ( 'batch_sequence = '
672: || TO_CHAR (p_batch_sequence)); --HXT115
673:
674: -- Add new hours data

Line 1297: -- pay_paywsqee_pkg.next_batch_sequence in insert_pay_batch_lines procedure

1293: -- bug 3217343 fix BEGIN
1294: -- get the next batch_seq for this batch_id only once and increment the
1295: -- sequence by 1 whenever insert_pay_batch_lines is called.
1296: -- This way the multiple expensive calls to
1297: -- pay_paywsqee_pkg.next_batch_sequence in insert_pay_batch_lines procedure
1298: -- can be avoided.
1299:
1300: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);
1301:

Line 1300: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);

1296: -- This way the multiple expensive calls to
1297: -- pay_paywsqee_pkg.next_batch_sequence in insert_pay_batch_lines procedure
1298: -- can be avoided.
1299:
1300: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);
1301:
1302: -- bug 3217343 fix END
1303: FOR l_hours_rec IN current_hours (p_tim_id)
1304: LOOP

Line 2375: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);

2371: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
2372:
2373: BEGIN
2374:
2375: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);
2376:
2377: FOR l_leftover IN leftover_hours (p_tim_id)
2378: LOOP
2379: --begin SIR65

Line 2416: pay_paywsqee_pkg.get_input_value_details (

2412: pbl_value (14),
2413: pbl_value (15);
2414: CLOSE rate_paid_cur;
2415: -- Get input values details for this element
2416: pay_paywsqee_pkg.get_input_value_details (
2417: l_leftover.element_type_id,
2418: l_leftover.date_worked,
2419: hxt_value (1).SEQUENCE,
2420: hxt_value (2).SEQUENCE,

Line 2813: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);

2809: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
2810:
2811: BEGIN
2812:
2813: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);
2814:
2815: FOR l_leftover IN leftover_amount (p_tim_id)
2816: LOOP
2817: