eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_RETRO_MIX dependencies on PAY_BATCH_LINES

Line 186: PROCEDURE insert_pay_batch_lines (

182:
183: RETURN l_meaning;
184: END convert_lookup;
185:
186: PROCEDURE insert_pay_batch_lines (
187: p_batch_id NUMBER,
188: p_batch_line_id OUT NOCOPY NUMBER,
189: p_assignment_id NUMBER,
190: p_assignment_number VARCHAR2,

Line 260: TYPE pbl_values_table IS TABLE OF pay_batch_lines.value_1%TYPE

256: INDEX BY BINARY_INTEGER;
257:
258: hxt_value input_values_table;
259:
260: TYPE pbl_values_table IS TABLE OF pay_batch_lines.value_1%TYPE
261: INDEX BY BINARY_INTEGER;
262:
263: pbl_value pbl_values_table;
264: l_value_meaning hr_lookups.meaning%TYPE;

Line 309: hr_utility.set_location ('insert_pay_batch_lines', 10);

305: lv_pbl_flag VARCHAR2 (1) := 'N';
306: BEGIN
307:
308: if g_debug then
309: hr_utility.set_location ('insert_pay_batch_lines', 10);
310: end if;
311:
312: -- Initialize tables
313: FOR i IN 1 .. 15

Line 389: hr_utility.set_location ('insert_pay_batch_lines', 20);

385: hxt_value(14).otl_sequence,
386: hxt_value(15).otl_sequence
387: );
388: if g_debug then
389: hr_utility.set_location ('insert_pay_batch_lines', 20);
390: end if;
391: -- Place OTM data into BEE values per input values
392: hxt_util.DEBUG ('Putting OTM data into BEE values per input values'); --HXT115
393:

Line 423: hr_utility.set_location ('insert_pay_batch_lines', 30);

419: -- the further logic on the screen value for the input values.
420: --
421: lv_pbl_flag := 'N';
422: if g_debug then
423: hr_utility.set_location ('insert_pay_batch_lines', 30);
424:
425: hr_utility.TRACE (
426: 'hxt_value_name_'
427: || TO_CHAR (i)

Line 444: hr_utility.set_location ('insert_pay_batch_lines', 40);

440: --if hxt_value(i).name = 'Hours' then
441: IF l_value_meaning = 'HOURS'
442: THEN
443: if g_debug then
444: hr_utility.set_location ('insert_pay_batch_lines', 40);
445: end if;
446: pbl_value (i) :=
447: convert_lookup (p_hours, hxt_value (i).lookup, p_date_worked);
448: if g_debug then

Line 460: hr_utility.set_location ('insert_pay_batch_lines', 50);

456: --elsif hxt_value(i).name = 'Pay Value' then
457: ELSIF l_value_meaning = 'AMOUNT'
458: THEN
459: if g_debug then
460: hr_utility.set_location ('insert_pay_batch_lines', 50);
461: end if;
462: pbl_value (i) :=
463: convert_lookup (p_amount, hxt_value (i).lookup, p_date_worked);
464: if g_debug then

Line 476: hr_utility.set_location ('insert_pay_batch_lines', 60);

472: --elsif hxt_value(i).name = 'Multiple' then
473: ELSIF l_value_meaning = 'RATE_MULTIPLE'
474: THEN
475: if g_debug then
476: hr_utility.set_location ('insert_pay_batch_lines', 60);
477: end if;
478: pbl_value (i) := convert_lookup (
479: p_rate_multiple,
480: hxt_value (i).lookup,

Line 496: hr_utility.set_location ('insert_pay_batch_lines', 70);

492:
493: ELSIF l_value_meaning = 'HOURLY_RATE'
494: THEN
495: if g_debug then
496: hr_utility.set_location ('insert_pay_batch_lines', 70);
497: end if;
498: pbl_value (i) := convert_lookup (
499: p_hourly_rate,
500: hxt_value (i).lookup,

Line 518: hr_utility.set_location ('insert_pay_batch_lines', 70);

514: --elsif hxt_value(i).name = 'Rate' then
515: ELSIF l_value_meaning = 'RATE'
516: THEN
517: if g_debug then
518: hr_utility.set_location ('insert_pay_batch_lines', 70);
519: end if;
520: pbl_value (i) := convert_lookup (
521: p_hourly_rate,
522: hxt_value (i).lookup,

Line 538: hr_utility.set_location ('insert_pay_batch_lines', 80);

534: --elsif hxt_value(i).name = 'Rate Code' then
535: ELSIF l_value_meaning = 'RATE_CODE'
536: THEN
537: if g_debug then
538: hr_utility.set_location ('insert_pay_batch_lines', 80);
539: end if;
540: pbl_value (i) := convert_lookup (
541: p_rate_code,
542: hxt_value (i).lookup,

Line 558: hr_utility.set_location ('insert_pay_batch_lines', 90);

554: -- BEGIN US localization
555: ELSIF hxt_value (i).NAME = 'Jurisdiction'
556: THEN
557: if g_debug then
558: hr_utility.set_location ('insert_pay_batch_lines', 90);
559: end if;
560:
561: if(p_state_name is not null or
562: p_county_name is not null or

Line 589: hr_utility.set_location ('insert_pay_batch_lines', 100);

585: end if;
586: ELSIF hxt_value (i).NAME = 'Deduction Processing'
587: THEN
588: if g_debug then
589: hr_utility.set_location ('insert_pay_batch_lines', 100);
590: end if;
591: pbl_value (i) := convert_lookup (
592: p_tax_separately_flag,
593: hxt_value (i).lookup,

Line 607: hr_utility.set_location ('insert_pay_batch_lines', 110);

603: end if;
604: ELSIF hxt_value (i).NAME = 'Separate Check'
605: THEN
606: if g_debug then
607: hr_utility.set_location ('insert_pay_batch_lines', 110);
608: end if;
609: pbl_value (i) := convert_lookup (
610: p_separate_check_flag,
611: hxt_value (i).lookup,

Line 628: hr_utility.set_location ('insert_pay_batch_lines', 120);

624:
625: ELSIF hxt_value (i).NAME IS NOT NULL
626: THEN -- pbl_value(i) := NULL;
627: if g_debug then
628: hr_utility.set_location ('insert_pay_batch_lines', 120);
629: hr_utility.TRACE ( 'p_element_type_id :'
630: || p_element_type_id);
631: hr_utility.TRACE ( 'p_assignment_id :'
632: || p_assignment_id);

Line 644: hr_utility.set_location ('insert_pay_batch_lines', 130);

640: );
641:
642: LOOP
643: if g_debug then
644: hr_utility.set_location ('insert_pay_batch_lines', 130);
645: end if;
646: FETCH c_date_input_value INTO l_piv_name;
647: EXIT WHEN c_date_input_value%NOTFOUND;
648: if g_debug then

Line 658: hr_utility.set_location ('insert_pay_batch_lines', 140);

654:
655: IF l_piv_name = hxt_value (i).NAME
656: THEN
657: if g_debug then
658: hr_utility.set_location ('insert_pay_batch_lines', 140);
659: end if;
660: --pbl_value(i) := to_char(p_date_worked,'DD-MON-YYYY');
661: pbl_value (i) := fnd_date.date_to_canonical (p_date_worked);
662: lv_pbl_flag := 'Y';

Line 806: hr_utility.set_location ('insert_pay_batch_lines', 150);

802:
803: IF lv_pbl_flag = 'N'
804: THEN
805: if g_debug then
806: hr_utility.set_location ('insert_pay_batch_lines', 150);
807: end if;
808: pbl_value (i) := NULL;
809: if g_debug then
810: hr_utility.TRACE (

Line 825: hr_utility.set_location ('insert_pay_batch_lines', 160);

821: || lv_pbl_flag);
822: end if;
823: ELSE
824: if g_debug then
825: hr_utility.set_location ('insert_pay_batch_lines', 160);
826: end if;
827: pbl_value (i) := NULL;
828: if g_debug then
829: hr_utility.TRACE (

Line 839: hr_utility.set_location ('insert_pay_batch_lines', 170);

835: end if;
836: END IF;
837:
838: if g_debug then
839: hr_utility.set_location ('insert_pay_batch_lines', 170);
840: end if;
841: hxt_util.DEBUG ( 'value_'
842: || TO_CHAR (i)
843: || ' = '

Line 931: 'Oops...g_lookup_not_found in insert_pay_batch_lines'

927: EXCEPTION
928: WHEN g_lookup_not_found
929: THEN
930: hxt_util.DEBUG (
931: 'Oops...g_lookup_not_found in insert_pay_batch_lines'
932: ); --HXT115
933: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
934: WHEN OTHERS
935: THEN

Line 937: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115

933: RAISE g_lookup_not_found; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
934: WHEN OTHERS
935: THEN
936: hxt_util.DEBUG (SQLERRM); --HXT115
937: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
938: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
939: fnd_message.set_token ('SQLERR', SQLERRM);
940: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
941: END insert_pay_batch_lines;

Line 941: END insert_pay_batch_lines;

937: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
938: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
939: fnd_message.set_token ('SQLERR', SQLERRM);
940: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
941: END insert_pay_batch_lines;
942:
943:
944: --END GLOBAL
945:

Line 1563: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;

1559: l_amount_to_send NUMBER (15, 5);
1560: l_retcode NUMBER; /* BSE107 */
1561: l_location VARCHAR2 (20);
1562:
1563: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;
1564:
1565: BEGIN
1566:
1567: -- Bug 8888777

Line 1580: -- sequence by 1 whenever insert_pay_batch_lines is called.

1576: l_location := 'Step 1A';
1577:
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:

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 1767: -- SELECT pay_batch_lines_s.NEXTVAL

1763:
1764:
1765: --BEGIN GLOBAL
1766: -- select pay_pdt_batch_lines_s.nextval
1767: -- SELECT pay_batch_lines_s.NEXTVAL
1768:
1769: --END GLOBAL
1770: -- INTO l_nextval
1771: -- FROM DUAL;

Line 1824: insert_pay_batch_lines (

1820: -- l_hours_to_send
1821: -- );
1822: -- Bug 8888777
1823: -- Added parent_id in the below call.
1824: insert_pay_batch_lines (
1825: p_batch_id,
1826: l_batch_line_id,
1827: l_hours_rec.assignment_id,
1828: l_hours_rec.assignment_number,

Line 1992: -- SELECT pay_batch_lines_s.NEXTVAL

1988:
1989: /* END BSE107 */
1990: --BEGIN GLOBAL
1991: -- select pay_pdt_batch_lines_s.nextval
1992: -- SELECT pay_batch_lines_s.NEXTVAL
1993:
1994: --END GLOBAL
1995: -- INTO l_nextval
1996: -- FROM DUAL;

Line 2046: insert_pay_batch_lines (

2042: -- l_amount_rec.separate_check_flag, '', '',
2043: -- l_amount_rec.tax_separately_flag, '',
2044: -- l_amount_rec.hours_worked
2045: -- );
2046: insert_pay_batch_lines (
2047: p_batch_id,
2048: l_batch_line_id,
2049: l_amount_rec.assignment_id,
2050: l_amount_rec.assignment_number,

Line 2728: FROM pay_batch_lines pbl

2724: SELECT pbl.value_1, pbl.value_2, pbl.value_3, pbl.value_4,
2725: pbl.value_5, pbl.value_6, pbl.value_7, pbl.value_8,
2726: pbl.value_9, pbl.value_10, pbl.value_11, pbl.value_12,
2727: pbl.value_13, pbl.value_14, pbl.value_15
2728: FROM pay_batch_lines pbl
2729: WHERE pbl.batch_line_id = c_line_id;
2730:
2731: TYPE input_value_record IS RECORD (
2732: SEQUENCE pay_input_values_f.input_value_id%TYPE,

Line 2741: TYPE pbl_values_table IS TABLE OF pay_batch_lines.value_1%TYPE

2737: INDEX BY BINARY_INTEGER;
2738:
2739: hxt_value input_values_table;
2740:
2741: TYPE pbl_values_table IS TABLE OF pay_batch_lines.value_1%TYPE
2742: INDEX BY BINARY_INTEGER;
2743:
2744: pbl_value pbl_values_table;
2745:

Line 2749: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;

2745:
2746: --END GLOBAL
2747: l_value_meaning hr_lookups.meaning%TYPE;
2748:
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);

Line 2943: -- SELECT pay_batch_lines_s.NEXTVAL

2939: --end SIR65
2940:
2941: --BEGIN GLOBAL
2942: -- select pay_pdt_batch_lines_s.nextval
2943: -- SELECT pay_batch_lines_s.NEXTVAL
2944:
2945: --END GLOBAL
2946: -- INTO l_nextval
2947: -- FROM DUAL;

Line 2996: insert_pay_batch_lines (

2992: -- l_leftover.separate_check_flag, '', '',
2993: -- l_leftover.tax_separately_flag, '',
2994: -- 0 - l_leftover.hours_worked
2995: -- );
2996: insert_pay_batch_lines (
2997: p_batch_id,
2998: l_batch_line_id,
2999: l_leftover.assignment_id,
3000: l_leftover.assignment_number,

Line 3205: l_batch_sequence PAY_BATCH_LINES.BATCH_SEQUENCE%TYPE;

3201: -- l_nextval NUMBER (15);
3202: l_batch_line_id NUMBER (15);
3203: l_retcode NUMBER; /* BSE107 */
3204:
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);

Line 3224: -- SELECT pay_batch_lines_s.NEXTVAL

3220: /* END BSE107 - OHM SPR200*/
3221:
3222: --BEGIN GLOBAL
3223: -- select pay_pdt_batch_lines_s.nextval
3224: -- SELECT pay_batch_lines_s.NEXTVAL
3225:
3226: --END GLOBAL
3227: -- INTO l_nextval
3228: -- FROM DUAL;

Line 3277: insert_pay_batch_lines (

3273: -- l_leftover.separate_check_flag, '', '',
3274: -- l_leftover.tax_separately_flag, '',
3275: -- l_leftover.hours_worked
3276: -- );
3277: insert_pay_batch_lines (
3278: p_batch_id,
3279: l_batch_line_id,
3280: l_leftover.assignment_id,
3281: l_leftover.assignment_number,

Line 3372: INDEX(pbl PAY_BATCH_LINES_PK)

3368: CURSOR get_retro_ids( p_batch_id IN NUMBER,
3369: p_tim_id IN NUMBER)
3370: IS SELECT /*+ LEADING(det)
3371: INDEX(det HXT_DET_HOURS_WORKED_F_TIM_FK)
3372: INDEX(pbl PAY_BATCH_LINES_PK)
3373: INDEX(ret HXC_RET_PAY_LATEST_DETAILS_N7) *
3374: det.retro_pbl_line_id,
3375: p_batch_id,
3376: ROWIDTOCHAR(ret.ROWID)

Line 3379: pay_batch_lines pbl

3375: p_batch_id,
3376: ROWIDTOCHAR(ret.ROWID)
3377: FROM hxt_det_hours_worked_f det,
3378: hxc_ret_pay_latest_details ret,
3379: pay_batch_lines pbl
3380: WHERE det.pay_status = 'B'
3381: AND det.effective_end_date <> hr_general.end_of_time
3382: AND det.pbl_line_id = ret.old_pbl_id
3383: AND ret.retro_batch_id IS NULL

Line 3397: INDEX(pbl PAY_BATCH_LINES_PK)

3393: CURSOR get_retro_ids2( p_batch_id IN NUMBER,
3394: p_tim_id IN NUMBER)
3395: IS SELECT /*+ LEADING(det)
3396: INDEX(det HXT_DET_HOURS_WORKED_F_TIM_FK)
3397: INDEX(pbl PAY_BATCH_LINES_PK)
3398: INDEX(ret HXC_RET_PAY_LATEST_DETAILS_N6) *
3399: det.retro_pbl_line_id,
3400: p_batch_id,
3401: ROWIDTOCHAR(ret.ROWID)

Line 3404: pay_batch_lines pbl

3400: p_batch_id,
3401: ROWIDTOCHAR(ret.ROWID)
3402: FROM hxt_det_hours_worked_f det,
3403: hxc_ret_pay_latest_details ret,
3404: pay_batch_lines pbl
3405: WHERE det.pay_status = 'B'
3406: AND det.effective_end_date <> hr_general.end_of_time
3407: AND det.pbl_line_id = ret.pbl_id
3408: AND ret.retro_batch_id IS NULL

Line 3930: pay_batch_lines pbl,

3926: IS SELECT ROWIDTOCHAR(ret.rowid),
3927: det.retro_pbl_line_id
3928: FROM hxt_det_hours_worked_f det,
3929: hxt_sum_hours_worked_f sum,
3930: pay_batch_lines pbl,
3931: hxc_ret_pay_latest_details ret
3932: WHERE pbl.batch_id = p_batch_id
3933: AND pbl.batch_line_id = det.retro_pbl_line_id
3934: AND det.tim_id = p_tim_id

Line 3949: pay_batch_lines pbl,

3945: IS SELECT ROWIDTOCHAR(ret.rowid),
3946: det.retro_pbl_line_id
3947: FROM hxt_det_hours_worked_f det,
3948: hxt_sum_hours_worked_f sum,
3949: pay_batch_lines pbl,
3950: hxc_ret_pay_latest_details ret
3951: WHERE pbl.batch_id = p_batch_id
3952: AND pbl.batch_line_id = det.retro_pbl_line_id
3953: AND det.tim_id = p_tim_id

Line 4056: pay_batch_lines pbl

4052: ret.application_set_id
4053: FROM hxt_det_hours_worked_f det,
4054: hxt_sum_hours_worked_f sum,
4055: hxc_ret_pay_latest_details ret,
4056: pay_batch_lines pbl
4057: WHERE det.retro_batch_id = p_batch_id
4058: AND det.retro_pbl_line_id IS NOT NULL
4059: AND det.pay_status = 'C'
4060: AND det.tim_id = p_tim_id