APPS.HXT_RETRO_MIX dependencies on PAY_PAYWSQEE_PKG

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

844: || pbl_value (i)); --HXT115
845: END LOOP;
846:
847: -- Get next sequence number
848: -- l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence (p_batch_id);
849: hxt_util.DEBUG ( 'batch_sequence = '
850: || TO_CHAR (p_batch_sequence)); --HXT115
851:
852: -- Add new hours data

Line 1582: -- pay_paywsqee_pkg.next_batch_sequence in insert_pay_batch_lines procedure

1578: -- bug 3217343 fix BEGIN
1579: -- get the next batch_seq for this batch_id only once and increment the
1580: -- sequence by 1 whenever insert_pay_batch_lines is called.
1581: -- This way the multiple expensive calls to
1582: -- pay_paywsqee_pkg.next_batch_sequence in insert_pay_batch_lines procedure
1583: -- can be avoided.
1584:
1585: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);
1586:

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

1581: -- This way the multiple expensive calls to
1582: -- pay_paywsqee_pkg.next_batch_sequence in insert_pay_batch_lines procedure
1583: -- can be avoided.
1584:
1585: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);
1586:
1587: -- bug 3217343 fix END
1588: FOR l_hours_rec IN current_hours (p_tim_id)
1589: LOOP

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

2749: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
2750:
2751: BEGIN
2752:
2753: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);
2754:
2755: FOR l_leftover IN leftover_hours (p_tim_id)
2756: LOOP
2757: --begin SIR65

Line 2799: pay_paywsqee_pkg.get_input_value_details (

2795: pbl_value (14),
2796: pbl_value (15);
2797: CLOSE rate_paid_cur;
2798: -- Get input values details for this element
2799: pay_paywsqee_pkg.get_input_value_details (
2800: l_leftover.element_type_id,
2801: l_leftover.date_worked,
2802: hxt_value (1).SEQUENCE,
2803: hxt_value (2).SEQUENCE,

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

3205: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
3206:
3207: BEGIN
3208:
3209: l_batch_sequence := pay_paywsqee_pkg.next_batch_sequence(p_batch_id);
3210:
3211: FOR l_leftover IN leftover_amount (p_tim_id)
3212: LOOP
3213: