APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on IC_TXN_REQUEST_LINES

Line 369: UPDATE IC_TXN_REQUEST_LINES

365: )
366: IS
367: BEGIN
368:
369: UPDATE IC_TXN_REQUEST_LINES
370: SET ATTRIBUTE1 = p_mo_line_rec.attribute1
371: , ATTRIBUTE10 = p_mo_line_rec.attribute10
372: , ATTRIBUTE11 = p_mo_line_rec.attribute11
373: , ATTRIBUTE12 = p_mo_line_rec.attribute12

Line 519: INSERT INTO IC_TXN_REQUEST_LINES

515: WSH_UTIL_CORE.Println(' Line Status =>' || p_mo_line_rec.line_status );
516: WSH_UTIL_CORE.Println(' Requested qty =>' || p_mo_line_rec.quantity );
517: WSH_UTIL_CORE.Println(' Detailed qty =>' || p_mo_line_rec.quantity_detailed );
518:
519: INSERT INTO IC_TXN_REQUEST_LINES
520: ( ATTRIBUTE1
521: , ATTRIBUTE10
522: , ATTRIBUTE11
523: , ATTRIBUTE12

Line 690: DELETE FROM IC_TXN_REQUEST_LINES

686: )
687: IS
688: BEGIN
689:
690: DELETE FROM IC_TXN_REQUEST_LINES
691: WHERE LINE_ID = p_line_id
692: ;
693:
694:

Line 829: FROM IC_TXN_REQUEST_LINES

825: , SECONDARY_QUANTITY_DELIVERED
826: , SECONDARY_QUANTITY_DETAILED
827: -- HW BUG#:2296620 added ship_set_id
828: , SHIP_SET_ID
829: FROM IC_TXN_REQUEST_LINES
830: WHERE ( LINE_ID = p_line_id
831: )
832: OR ( HEADER_ID = p_header_id
833: );

Line 1056: FROM IC_TXN_REQUEST_LINES

1052: , SECONDARY_QUANTITY_DELIVERED
1053: , SECONDARY_QUANTITY_DETAILED
1054: -- HW BUG#:2296620 added ship_set_id
1055: , SHIP_SET_ID
1056: FROM IC_TXN_REQUEST_LINES
1057: WHERE LINE_ID = mo_line_id
1058: FOR UPDATE NOWAIT;
1059:
1060: BEGIN

Line 2366: update ic_txn_request_lines

2362: Set the Returned values from the GMI_Reservation_Util.ic_tran_rec_tbl
2363: ================================================================== */
2364: GMI_Reservation_Util.PrintLn('In Reallocate : default_lot_index='||l_default_lot_index||', detail_qty='||x_detailed_qty||', mo_line_id='||l_mo_line_tbl(1).line_id);
2365:
2366: update ic_txn_request_lines
2367: set quantity_detailed = x_detailed_qty
2368: , secondary_quantity_detailed = x_detailed_qty2
2369: where line_id = l_mo_line_tbl(1).line_id;
2370:

Line 2699: FROM ic_txn_request_lines mo,

2695:
2696: CURSOR C_get_lines_count
2697: IS
2698: SELECT COUNT(1)
2699: FROM ic_txn_request_lines mo,
2700: oe_order_lines_all l,
2701: oe_order_headers_all h,
2702: oe_transaction_types_all ta,
2703: oe_transaction_types_tl tt

Line 2736: FROM ic_txn_request_lines mo,

2732: mo.quantity,
2733: mo.quantity_detailed,
2734: mo.quantity_delivered,
2735: mo.inventory_item_id
2736: FROM ic_txn_request_lines mo,
2737: oe_order_lines_all l,
2738: oe_order_headers_all h,
2739: oe_transaction_types_all ta,
2740: oe_transaction_types_tl tt

Line 3248: FROM ic_txn_request_lines

3244: , secondary_quantity
3245: , NVL(quantity_detailed, 0)
3246: , NVL(secondary_quantity_detailed, 0)
3247: , organization_id
3248: FROM ic_txn_request_lines
3249: WHERE line_id = p_line_id
3250: FOR UPDATE;
3251:
3252: cursor c_txn_source_line IS

Line 3534: UPDATE ic_txn_request_lines

3530: GMI_Reservation_Util.PrintLn('Canceling MO Line New qty2 = ' || l_quantity2);
3531: End If;
3532: END IF;
3533: -- Update line status, quantity, and required_quantity
3534: UPDATE ic_txn_request_lines
3535: SET quantity = l_quantity
3536: ,secondary_quantity = l_quantity2
3537: ,line_status = l_line_status
3538: WHERE line_id = p_line_id;

Line 3642: FROM ic_txn_request_lines

3638: , NVL(secondary_quantity_detailed, 0)
3639: , organization_id
3640: , inventory_item_Id
3641: , uom_code
3642: FROM ic_txn_request_lines
3643: WHERE line_id = p_line_id
3644: FOR UPDATE;
3645:
3646: cursor c_primary_uom IS

Line 3886: UPDATE ic_txn_request_lines

3882:
3883: GMI_Reservation_Util.PrintLn('updating move order line with qty '||l_quantity);
3884: gmi_reservation_util.println('For line id '||p_line_id);
3885: -- Update line status, quantity, and required_quantity
3886: UPDATE ic_txn_request_lines
3887: SET quantity = l_quantity
3888: , primary_quantity = l_quantity
3889: , secondary_quantity = l_quantity2
3890: , quantity_detailed = quantity_detailed - l_deleted_quantity

Line 3920: UPDATE ic_txn_request_lines

3916: ( p_line_id IN NUMBER
3917: , p_new_source_line_id IN NUMBER
3918: ) IS
3919: BEGIN
3920: UPDATE ic_txn_request_lines
3921: SET txn_source_line_id = p_new_source_line_id
3922: WHERE line_id = p_line_id;
3923:
3924: /*UPDATE mtl_material_transactions_temp