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.GMI_SHIPPING_UTIL dependencies on IC_TRAN_PND

Line 85: l_old_transaction_row ic_tran_pnd%ROWTYPE;

81: , x_msg_count OUT NOCOPY NUMBER
82: , x_msg_data OUT NOCOPY VARCHAR2
83: )
84: IS
85: l_old_transaction_row ic_tran_pnd%ROWTYPE;
86: l_new_transaction_row ic_tran_pnd%ROWTYPE;
87: l_line_id ic_tran_pnd.line_id%TYPE;
88: l_item_id ic_tran_pnd.item_id%TYPE;
89: l_location ic_tran_pnd.location%TYPE;

Line 86: l_new_transaction_row ic_tran_pnd%ROWTYPE;

82: , x_msg_data OUT NOCOPY VARCHAR2
83: )
84: IS
85: l_old_transaction_row ic_tran_pnd%ROWTYPE;
86: l_new_transaction_row ic_tran_pnd%ROWTYPE;
87: l_line_id ic_tran_pnd.line_id%TYPE;
88: l_item_id ic_tran_pnd.item_id%TYPE;
89: l_location ic_tran_pnd.location%TYPE;
90: l_lot_id ic_tran_pnd.lot_id%TYPE;

Line 87: l_line_id ic_tran_pnd.line_id%TYPE;

83: )
84: IS
85: l_old_transaction_row ic_tran_pnd%ROWTYPE;
86: l_new_transaction_row ic_tran_pnd%ROWTYPE;
87: l_line_id ic_tran_pnd.line_id%TYPE;
88: l_item_id ic_tran_pnd.item_id%TYPE;
89: l_location ic_tran_pnd.location%TYPE;
90: l_lot_id ic_tran_pnd.lot_id%TYPE;
91: l_reduction_factor NUMBER;

Line 88: l_item_id ic_tran_pnd.item_id%TYPE;

84: IS
85: l_old_transaction_row ic_tran_pnd%ROWTYPE;
86: l_new_transaction_row ic_tran_pnd%ROWTYPE;
87: l_line_id ic_tran_pnd.line_id%TYPE;
88: l_item_id ic_tran_pnd.item_id%TYPE;
89: l_location ic_tran_pnd.location%TYPE;
90: l_lot_id ic_tran_pnd.lot_id%TYPE;
91: l_reduction_factor NUMBER;
92: l_delta_trans_qty2 NUMBER;

Line 89: l_location ic_tran_pnd.location%TYPE;

85: l_old_transaction_row ic_tran_pnd%ROWTYPE;
86: l_new_transaction_row ic_tran_pnd%ROWTYPE;
87: l_line_id ic_tran_pnd.line_id%TYPE;
88: l_item_id ic_tran_pnd.item_id%TYPE;
89: l_location ic_tran_pnd.location%TYPE;
90: l_lot_id ic_tran_pnd.lot_id%TYPE;
91: l_reduction_factor NUMBER;
92: l_delta_trans_qty2 NUMBER;
93: l_trans_id NUMBER;

Line 90: l_lot_id ic_tran_pnd.lot_id%TYPE;

86: l_new_transaction_row ic_tran_pnd%ROWTYPE;
87: l_line_id ic_tran_pnd.line_id%TYPE;
88: l_item_id ic_tran_pnd.item_id%TYPE;
89: l_location ic_tran_pnd.location%TYPE;
90: l_lot_id ic_tran_pnd.lot_id%TYPE;
91: l_reduction_factor NUMBER;
92: l_delta_trans_qty2 NUMBER;
93: l_trans_id NUMBER;
94: l_staged_ind NUMBER;

Line 99: FROM ic_tran_pnd

95: l_lock_status BOOLEAN;
96:
97: CURSOR default_transaction_c IS
98: SELECT trans_id, staged_ind
99: FROM ic_tran_pnd
100: WHERE doc_type='OMSO'
101: AND line_id = p_shipping_line.source_line_id
102: -- AND item_id = l_item_id -- REMOVED for bug 3403418
103: AND lot_id = 0

Line 112: FROM ic_tran_pnd

108:
109: CURSOR get_opm_transaction_c
110: IS
111: SELECT trans_id
112: FROM ic_tran_pnd
113: WHERE doc_type='OMSO'
114: AND line_id = p_shipping_line.source_line_id
115: -- AND item_id = l_item_id -- REMOVED for bug 3403418
116: AND lot_id = l_lot_id

Line 138: /* row in ic_tran_pnd. If any of these retrievals fails there is no */

134: GMI_RESERVATION_UTIL.println('Start Of OPM BackOrder Routine');
135:
136: /* Try and retrieve the original transaction. To do this we need */
137: /* to determine a number of keys so that we can locate the correct */
138: /* row in ic_tran_pnd. If any of these retrievals fails there is no */
139: /* point in continuing, so let the exception raised take over. */
140:
141: GMI_reservation_Util.PrintLn('Find OPM Item ID');
142:

Line 228: UPDATE ic_tran_pnd

224: /* BUG 1577035 BEGIN Set staged_ind = 0 in backorder scenario
225: ============================================================= */
226: /* BUG 1575873 the qty becomes 0 when back order is created, the
227: default qty should be the cycle count qty */
228: UPDATE ic_tran_pnd
229: SET staged_ind = 0,
230: trans_qty = -1 * p_shipping_line.cycle_count_quantity,
231: trans_qty2 = -1 * p_shipping_line.cycle_count_quantity2
232: WHERE trans_id = l_old_transaction_rec.trans_id;

Line 245: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

241: /* BUG 1577035 END
242: ================== */
243: ELSE
244:
245: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
246: (l_old_transaction_rec, l_old_transaction_rec )
247: THEN
248: /* We have the transaction we need. */
249: /* Before Completing any transactions lets Lock The Rows. */

Line 301: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

297: /* Set Trans Id To fetch */
298:
299: l_old_transaction_rec.trans_id := l_trans_id;
300:
301: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
302: (l_old_transaction_rec, l_old_transaction_rec )
303: THEN
304: GMI_RESERVATION_UTIL.println('Found Transaction ID => '|| l_old_transaction_rec.trans_id);
305:

Line 473: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

469: CLOSE default_transaction_c;
470: /* We need to increase the amounts in the existing transaction */
471: l_old_transaction_rec.trans_id := l_trans_id;
472:
473: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
474: (l_old_transaction_rec, l_old_transaction_rec )
475: THEN
476: l_old_transaction_rec.trans_qty := -1 * (ABS(l_old_transaction_rec.trans_qty) + p_shipping_line.cycle_count_quantity);
477:

Line 530: l_transaction_row ic_tran_pnd%ROWTYPE;

526: PROCEDURE unreserve_inv
527: ( p_trans_id IN NUMBER
528: , x_return_status OUT NOCOPY VARCHAR2)
529: IS
530: l_transaction_row ic_tran_pnd%ROWTYPE;
531: l_line_id ic_tran_pnd.line_id%TYPE;
532: l_item_id ic_tran_pnd.item_id%TYPE;
533: l_location ic_tran_pnd.location%TYPE;
534: l_lot_id ic_tran_pnd.lot_id%TYPE;

Line 531: l_line_id ic_tran_pnd.line_id%TYPE;

527: ( p_trans_id IN NUMBER
528: , x_return_status OUT NOCOPY VARCHAR2)
529: IS
530: l_transaction_row ic_tran_pnd%ROWTYPE;
531: l_line_id ic_tran_pnd.line_id%TYPE;
532: l_item_id ic_tran_pnd.item_id%TYPE;
533: l_location ic_tran_pnd.location%TYPE;
534: l_lot_id ic_tran_pnd.lot_id%TYPE;
535: l_reduction_factor NUMBER;

Line 532: l_item_id ic_tran_pnd.item_id%TYPE;

528: , x_return_status OUT NOCOPY VARCHAR2)
529: IS
530: l_transaction_row ic_tran_pnd%ROWTYPE;
531: l_line_id ic_tran_pnd.line_id%TYPE;
532: l_item_id ic_tran_pnd.item_id%TYPE;
533: l_location ic_tran_pnd.location%TYPE;
534: l_lot_id ic_tran_pnd.lot_id%TYPE;
535: l_reduction_factor NUMBER;
536: l_delta_trans_qty2 NUMBER;

Line 533: l_location ic_tran_pnd.location%TYPE;

529: IS
530: l_transaction_row ic_tran_pnd%ROWTYPE;
531: l_line_id ic_tran_pnd.line_id%TYPE;
532: l_item_id ic_tran_pnd.item_id%TYPE;
533: l_location ic_tran_pnd.location%TYPE;
534: l_lot_id ic_tran_pnd.lot_id%TYPE;
535: l_reduction_factor NUMBER;
536: l_delta_trans_qty2 NUMBER;
537: l_trans_id NUMBER;

Line 534: l_lot_id ic_tran_pnd.lot_id%TYPE;

530: l_transaction_row ic_tran_pnd%ROWTYPE;
531: l_line_id ic_tran_pnd.line_id%TYPE;
532: l_item_id ic_tran_pnd.item_id%TYPE;
533: l_location ic_tran_pnd.location%TYPE;
534: l_lot_id ic_tran_pnd.lot_id%TYPE;
535: l_reduction_factor NUMBER;
536: l_delta_trans_qty2 NUMBER;
537: l_trans_id NUMBER;
538: l_staged_ind NUMBER;

Line 547: FROM ic_tran_pnd

543: l_msg_data varchar2(3000);
544:
545: CURSOR default_transaction_c IS
546: SELECT trans_id
547: FROM ic_tran_pnd
548: WHERE doc_type='OMSO'
549: AND line_id = l_transaction_rec.line_id
550: -- AND item_id = l_item_id -- REMOVED for bug 3403418
551: AND lot_id = 0

Line 566: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

562: SAVEPOINT process_backorders;
563: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
564:
565: l_transaction_rec.trans_id := p_trans_id;
566: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
567: (l_transaction_rec, l_transaction_rec )
568: THEN
569: GMI_reservation_Util.PrintLn('Find OPM Item ID');
570:

Line 642: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

638: END IF;
639:
640: l_transaction_rec.trans_id := l_trans_id;
641:
642: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
643: (l_transaction_rec, l_transaction_rec )
644: THEN
645: /* balance the default lot */
646: GMI_RESERVATION_UTIL.balance_default_lot

Line 679: l_old_transaction_row ic_tran_pnd%ROWTYPE;

675: IS
676:
677: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
678: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
679: l_old_transaction_row ic_tran_pnd%ROWTYPE;
680: l_new_transaction_row ic_tran_pnd%ROWTYPE;
681: l_line_id ic_tran_pnd.line_id%TYPE;
682: l_item_id ic_tran_pnd.item_id%TYPE;
683: l_location ic_tran_pnd.location%TYPE;

Line 680: l_new_transaction_row ic_tran_pnd%ROWTYPE;

676:
677: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
678: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
679: l_old_transaction_row ic_tran_pnd%ROWTYPE;
680: l_new_transaction_row ic_tran_pnd%ROWTYPE;
681: l_line_id ic_tran_pnd.line_id%TYPE;
682: l_item_id ic_tran_pnd.item_id%TYPE;
683: l_location ic_tran_pnd.location%TYPE;
684: l_lot_id ic_tran_pnd.lot_id%TYPE;

Line 681: l_line_id ic_tran_pnd.line_id%TYPE;

677: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
678: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
679: l_old_transaction_row ic_tran_pnd%ROWTYPE;
680: l_new_transaction_row ic_tran_pnd%ROWTYPE;
681: l_line_id ic_tran_pnd.line_id%TYPE;
682: l_item_id ic_tran_pnd.item_id%TYPE;
683: l_location ic_tran_pnd.location%TYPE;
684: l_lot_id ic_tran_pnd.lot_id%TYPE;
685: l_delta_trans_qty2 NUMBER;

Line 682: l_item_id ic_tran_pnd.item_id%TYPE;

678: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
679: l_old_transaction_row ic_tran_pnd%ROWTYPE;
680: l_new_transaction_row ic_tran_pnd%ROWTYPE;
681: l_line_id ic_tran_pnd.line_id%TYPE;
682: l_item_id ic_tran_pnd.item_id%TYPE;
683: l_location ic_tran_pnd.location%TYPE;
684: l_lot_id ic_tran_pnd.lot_id%TYPE;
685: l_delta_trans_qty2 NUMBER;
686: l_delta_trans_qty1 NUMBER;

Line 683: l_location ic_tran_pnd.location%TYPE;

679: l_old_transaction_row ic_tran_pnd%ROWTYPE;
680: l_new_transaction_row ic_tran_pnd%ROWTYPE;
681: l_line_id ic_tran_pnd.line_id%TYPE;
682: l_item_id ic_tran_pnd.item_id%TYPE;
683: l_location ic_tran_pnd.location%TYPE;
684: l_lot_id ic_tran_pnd.lot_id%TYPE;
685: l_delta_trans_qty2 NUMBER;
686: l_delta_trans_qty1 NUMBER;
687: l_trans_id NUMBER;

Line 684: l_lot_id ic_tran_pnd.lot_id%TYPE;

680: l_new_transaction_row ic_tran_pnd%ROWTYPE;
681: l_line_id ic_tran_pnd.line_id%TYPE;
682: l_item_id ic_tran_pnd.item_id%TYPE;
683: l_location ic_tran_pnd.location%TYPE;
684: l_lot_id ic_tran_pnd.lot_id%TYPE;
685: l_delta_trans_qty2 NUMBER;
686: l_delta_trans_qty1 NUMBER;
687: l_trans_id NUMBER;
688: l_lock_status BOOLEAN;

Line 701: FROM ic_tran_pnd

697:
698: CURSOR default_transaction_c
699: IS
700: SELECT trans_id
701: FROM ic_tran_pnd
702: WHERE doc_type='OMSO'
703: AND line_id = p_shipping_line.source_line_id
704: -- AND item_id = l_item_id -- REMOVED for bug 3403418
705: AND lot_id = 0

Line 717: FROM ic_tran_pnd

713:
714: CURSOR get_opm_transaction_c
715: IS
716: SELECT trans_id
717: FROM ic_tran_pnd
718: WHERE doc_type='OMSO'
719: AND line_id = p_shipping_line.source_line_id
720: -- AND item_id = l_item_id -- REMOVED for bug 3403418
721: AND lot_id = l_lot_id

Line 729: internal issue, before the complete fix for delivery detail in ic_tran_pnd, leave the issue

725: AND delete_mark = 0
726: /* temporary fix for 1794681 */
727: /* Have to back this temp fix out because staging is not working. If split shipping line 3 and 7 for
728: the original qty of 10, there is no way that the invnetory could be found Since this issue is an
729: internal issue, before the complete fix for delivery detail in ic_tran_pnd, leave the issue
730: as it is for now, this is a bigger issue for corrugated */
731: --AND trans_qty >= -1 * ABS(p_shipping_line.requested_quantity + 0.000005)
732: --AND trans_qty <= -1 * ABS(p_shipping_line.requested_quantity - 0.000005)
733: ORDER BY trans_id;

Line 739: FROM ic_tran_pnd

735: /* NC Added the following two cursors. Bug#1675561 */
736: CURSOR get_opm_trans_count
737: IS
738: SELECT count(*)
739: FROM ic_tran_pnd
740: WHERE doc_type = 'OMSO'
741: AND line_id = p_shipping_line.source_line_id
742: -- AND item_id = l_item_id -- REMOVED for bug 3403418
743: AND lot_id = l_lot_id

Line 753: FROM ic_tran_pnd

749:
750: CURSOR get_opm_transaction_c2
751: IS
752: SELECT trans_id
753: FROM ic_tran_pnd
754: WHERE doc_type='OMSO'
755: AND line_id = p_shipping_line.source_line_id
756: AND line_detail_id = p_shipping_line.delivery_detail_id
757: AND delete_mark = 0

Line 764: FROM ic_tran_pnd itp

760: /* B2547509 Added following cursor */
761: CURSOR get_opm_transaction_cnt
762: IS
763: SELECT count(*)
764: FROM ic_tran_pnd itp
765: WHERE doc_type ='OMSO'
766: AND line_id = p_shipping_line.source_line_id
767: AND line_detail_id = p_shipping_line.delivery_detail_id
768: AND delete_mark = 1

Line 863: /* row in ic_tran_pnd. If any of these retrievals fails there is no */

859: Close check_wsh;
860:
861: /* Try and retrieve the original transaction. To do this we need */
862: /* to determine a number of keys so that we can locate the correct */
863: /* row in ic_tran_pnd. If any of these retrievals fails there is no */
864: /* point in continuing, so let the exception raised take over. */
865:
866: SELECT iim.item_id, iim.lot_ctl, iim.loct_ctl INTO l_item_id,l_lot_ctl, l_loct_ctl
867: FROM ic_item_mst iim,

Line 951: UPDATE ic_tran_pnd

947: GMI_RESERVATION_UTIL.println('Multiple deleted transactions found - Manual updates are necessary');
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: ELSIF (l_cnt_trans = 1) THEN
950: /* update the transaction's delete mark to 0 and proceed */
951: UPDATE ic_tran_pnd
952: SET delete_mark = 0
953: WHERE doc_type = 'OMSO'
954: AND line_id = p_shipping_line.source_line_id
955: AND line_detail_id = p_shipping_line.delivery_detail_id

Line 982: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

978: END IF;
979:
980:
981: GMI_RESERVATION_UTIL.println('Retrieve OPM Transaction => ' ||l_old_transaction_rec.trans_id );
982: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
983: (l_old_transaction_rec, l_old_transaction_rec )
984: THEN
985:
986: l_src_qty := GMI_RESERVATION_UTIL.Get_Opm_converted_qty

Line 1204: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

1200: p_line_id => l_new_transaction_rec.line_id
1201: );
1202: IF nvl(l_trans_id,0) > 0 THEN -- bug 2124600
1203: l_new_transaction_rec.trans_id := l_trans_id;
1204: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
1205: (l_new_transaction_rec, l_new_transaction_rec )
1206: THEN
1207: l_new_transaction_rec.trans_qty := 0;
1208: l_new_transaction_rec.trans_qty2 := 0;

Line 1421: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

1417: CLOSE default_transaction_c;
1418:
1419: /* We need to increase the amounts in the existing transaction */
1420: l_old_transaction_rec.trans_id := l_trans_id;
1421: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
1422: (l_old_transaction_rec, l_old_transaction_rec )
1423: THEN
1424: l_old_transaction_rec.trans_qty := l_old_transaction_rec.trans_qty +
1425: l_delta_trans_qty1;

Line 1498: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

1494: OPEN default_transaction_c;
1495: FETCH default_transaction_c INTO l_trans_id;
1496: CLOSE default_transaction_c;
1497: l_new_transaction_rec.trans_id := l_trans_id;
1498: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
1499: (l_new_transaction_rec, l_new_transaction_rec )
1500: THEN
1501: GMI_RESERVATION_UTIL.println('balancing default lot.');
1502: GMI_RESERVATION_UTIL.balance_default_lot

Line 1559: l_old_transaction_row ic_tran_pnd%ROWTYPE;

1555:
1556: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1557: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1558: l_def_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1559: l_old_transaction_row ic_tran_pnd%ROWTYPE;
1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;
1561: l_line_id ic_tran_pnd.line_id%TYPE;
1562: l_item_id ic_tran_pnd.item_id%TYPE;
1563: l_location ic_tran_pnd.location%TYPE;

Line 1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;

1556: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1557: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1558: l_def_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1559: l_old_transaction_row ic_tran_pnd%ROWTYPE;
1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;
1561: l_line_id ic_tran_pnd.line_id%TYPE;
1562: l_item_id ic_tran_pnd.item_id%TYPE;
1563: l_location ic_tran_pnd.location%TYPE;
1564: l_lot_id ic_tran_pnd.lot_id%TYPE;

Line 1561: l_line_id ic_tran_pnd.line_id%TYPE;

1557: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1558: l_def_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1559: l_old_transaction_row ic_tran_pnd%ROWTYPE;
1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;
1561: l_line_id ic_tran_pnd.line_id%TYPE;
1562: l_item_id ic_tran_pnd.item_id%TYPE;
1563: l_location ic_tran_pnd.location%TYPE;
1564: l_lot_id ic_tran_pnd.lot_id%TYPE;
1565: l_delta_trans_qty2 NUMBER;

Line 1562: l_item_id ic_tran_pnd.item_id%TYPE;

1558: l_def_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1559: l_old_transaction_row ic_tran_pnd%ROWTYPE;
1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;
1561: l_line_id ic_tran_pnd.line_id%TYPE;
1562: l_item_id ic_tran_pnd.item_id%TYPE;
1563: l_location ic_tran_pnd.location%TYPE;
1564: l_lot_id ic_tran_pnd.lot_id%TYPE;
1565: l_delta_trans_qty2 NUMBER;
1566: l_delta_trans_qty1 NUMBER;

Line 1563: l_location ic_tran_pnd.location%TYPE;

1559: l_old_transaction_row ic_tran_pnd%ROWTYPE;
1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;
1561: l_line_id ic_tran_pnd.line_id%TYPE;
1562: l_item_id ic_tran_pnd.item_id%TYPE;
1563: l_location ic_tran_pnd.location%TYPE;
1564: l_lot_id ic_tran_pnd.lot_id%TYPE;
1565: l_delta_trans_qty2 NUMBER;
1566: l_delta_trans_qty1 NUMBER;
1567: l_trans_id NUMBER;

Line 1564: l_lot_id ic_tran_pnd.lot_id%TYPE;

1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;
1561: l_line_id ic_tran_pnd.line_id%TYPE;
1562: l_item_id ic_tran_pnd.item_id%TYPE;
1563: l_location ic_tran_pnd.location%TYPE;
1564: l_lot_id ic_tran_pnd.lot_id%TYPE;
1565: l_delta_trans_qty2 NUMBER;
1566: l_delta_trans_qty1 NUMBER;
1567: l_trans_id NUMBER;
1568: l_lock_status BOOLEAN;

Line 1581: FROM ic_tran_pnd

1577: The split happens for the interface in split_trans */
1578: CURSOR get_opm_transaction_c
1579: IS
1580: SELECT trans_id
1581: FROM ic_tran_pnd
1582: WHERE doc_type='OMSO'
1583: AND line_id = p_shipping_line.source_line_id
1584: AND line_detail_id = p_shipping_line.delivery_detail_id
1585: AND delete_mark = 0

Line 1592: FROM ic_tran_pnd itp

1588: /* B2547509 Added following cursor */
1589: CURSOR get_opm_transaction_cnt
1590: IS
1591: SELECT count(*)
1592: FROM ic_tran_pnd itp
1593: WHERE doc_type ='OMSO'
1594: AND line_id = p_shipping_line.source_line_id
1595: AND line_detail_id = p_shipping_line.delivery_detail_id
1596: AND delete_mark = 1

Line 1632: UPDATE ic_tran_pnd

1628: GMI_RESERVATION_UTIL.println('Multiple deleted transactions found - Manual updates are necessary');
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: ELSIF (l_cnt_trans = 1) THEN
1631: /* update the transaction's delete mark to 0 and proceed */
1632: UPDATE ic_tran_pnd
1633: SET delete_mark = 0
1634: WHERE doc_type = 'OMSO'
1635: AND line_id = p_shipping_line.source_line_id
1636: AND line_detail_id = p_shipping_line.delivery_detail_id

Line 1653: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

1649: CLOSE get_opm_transaction_c;
1650: END IF;
1651:
1652: GMI_RESERVATION_UTIL.println('Retrieve OPM Transaction => ' ||l_old_transaction_rec.trans_id );
1653: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
1654: (l_old_transaction_rec, l_old_transaction_rec )
1655: THEN
1656: -- PK Bug 3527599 Moving Lock_Inventory call from here to just before
1657: -- UPDATE_PENDING_TO_COMPLETED call.

Line 1747: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

1743: );
1744: /* because OM int is done first, there might not be a default lot associated with this line_id*/
1745: IF nvl(l_trans_id,0) > 0 THEN -- no balancing if no default exist
1746: l_new_transaction_rec.trans_id := l_trans_id;
1747: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
1748: (l_new_transaction_rec, l_new_transaction_rec )
1749: THEN
1750: l_ship_qty_above := p_shipping_line.ship_tolerance_above * abs(l_old_transaction_rec.trans_qty) /100;
1751: l_ship_qty_below := p_shipping_line.ship_tolerance_below * abs(l_old_transaction_rec.trans_qty) /100;

Line 1947: UPDATE ic_tran_pnd

1943:
1944:
1945: /* this only happens for non control item where the shared default lot is not good */
1946: /*IF p_action_flag = 'B' THEN
1947: UPDATE ic_tran_pnd
1948: SET line_id = p_source_line_id ,
1949: staged_ind = 0
1950: WHERE line_id = p_original_source_line_id and
1951: doc_type = 'OMSO' and

Line 1955: UPDATE ic_tran_pnd

1951: doc_type = 'OMSO' and
1952: completed_ind = 0 and
1953: delete_mark = 0;
1954: ELSE*/
1955: UPDATE ic_tran_pnd
1956: SET line_id = p_source_line_id
1957: WHERE line_id = p_original_source_line_id and
1958: doc_type = 'OMSO' and
1959: completed_ind = 0 and

Line 1965: GMI_RESERVATION_UTIL.println('No Update in ic_tran_pnd, line_id='||p_source_line_id);

1961: --END IF;
1962: IF (SQL%NOTFOUND) THEN
1963: /* bug 1783859 */
1964: /*for a pure back order line, this trans may not exsit, no error should be returned*/
1965: GMI_RESERVATION_UTIL.println('No Update in ic_tran_pnd, line_id='||p_source_line_id);
1966: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1967: --RAISE NO_DATA_FOUND;
1968: END IF;
1969:

Line 2003: l_old_transaction_row ic_tran_pnd%ROWTYPE ;

1999: x_msg_data OUT NOCOPY VARCHAR2)
2000: IS
2001: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2002: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2003: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
2004: l_new_transaction_row ic_tran_pnd%ROWTYPE;
2005: l_line_id ic_tran_pnd.line_id%TYPE;
2006: l_item_id ic_tran_pnd.item_id%TYPE;
2007: l_location ic_tran_pnd.location%TYPE;

Line 2004: l_new_transaction_row ic_tran_pnd%ROWTYPE;

2000: IS
2001: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2002: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2003: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
2004: l_new_transaction_row ic_tran_pnd%ROWTYPE;
2005: l_line_id ic_tran_pnd.line_id%TYPE;
2006: l_item_id ic_tran_pnd.item_id%TYPE;
2007: l_location ic_tran_pnd.location%TYPE;
2008: l_lot_id ic_tran_pnd.lot_id%TYPE;

Line 2005: l_line_id ic_tran_pnd.line_id%TYPE;

2001: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2002: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2003: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
2004: l_new_transaction_row ic_tran_pnd%ROWTYPE;
2005: l_line_id ic_tran_pnd.line_id%TYPE;
2006: l_item_id ic_tran_pnd.item_id%TYPE;
2007: l_location ic_tran_pnd.location%TYPE;
2008: l_lot_id ic_tran_pnd.lot_id%TYPE;
2009: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;

Line 2006: l_item_id ic_tran_pnd.item_id%TYPE;

2002: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2003: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
2004: l_new_transaction_row ic_tran_pnd%ROWTYPE;
2005: l_line_id ic_tran_pnd.line_id%TYPE;
2006: l_item_id ic_tran_pnd.item_id%TYPE;
2007: l_location ic_tran_pnd.location%TYPE;
2008: l_lot_id ic_tran_pnd.lot_id%TYPE;
2009: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
2010: l_reduction_factor NUMBER;

Line 2007: l_location ic_tran_pnd.location%TYPE;

2003: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
2004: l_new_transaction_row ic_tran_pnd%ROWTYPE;
2005: l_line_id ic_tran_pnd.line_id%TYPE;
2006: l_item_id ic_tran_pnd.item_id%TYPE;
2007: l_location ic_tran_pnd.location%TYPE;
2008: l_lot_id ic_tran_pnd.lot_id%TYPE;
2009: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
2010: l_reduction_factor NUMBER;
2011: l_delta_trans_qty2 NUMBER;

Line 2008: l_lot_id ic_tran_pnd.lot_id%TYPE;

2004: l_new_transaction_row ic_tran_pnd%ROWTYPE;
2005: l_line_id ic_tran_pnd.line_id%TYPE;
2006: l_item_id ic_tran_pnd.item_id%TYPE;
2007: l_location ic_tran_pnd.location%TYPE;
2008: l_lot_id ic_tran_pnd.lot_id%TYPE;
2009: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
2010: l_reduction_factor NUMBER;
2011: l_delta_trans_qty2 NUMBER;
2012: l_trans_id NUMBER;

Line 2051: ic_tran_pnd

2047: ( p_old_delievery_detail_id NUMBER,
2048: p_old_source_line_id NUMBER
2049: ) IS
2050: SELECT trans_id from
2051: ic_tran_pnd
2052: WHERE line_id = p_old_source_line_id
2053: AND line_detail_id = p_old_delivery_detail_id
2054: AND completed_ind = 0
2055: AND delete_mark = 0

Line 2145: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_old_transaction_rec, l_old_transaction_rec )

2141:
2142: CLOSE fetch_opm_transaction;
2143:
2144: GMI_RESERVATION_UTIL.println('Retrieve OPM Transaction => ' ||l_old_transaction_rec.trans_id );
2145: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_old_transaction_rec, l_old_transaction_rec )
2146: THEN
2147: GMI_reservation_Util.printLn('OPM Transaction found in OPM_UPDATE_TRXS');
2148: -- PK Bug 3527599 No need to lock IC_LOCT_INV when updating / creating pending txn.
2149:

Line 2214: PROCEDURE UPDATE_OPM_IC_TRAN_PND

2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: GMI_RESERVATION_UTIL.Println('Raised When Others in UPDATE_OPM_TRANSACTION');
2212: END UPDATE_OPM_TRANSACTION;
2213:
2214: PROCEDURE UPDATE_OPM_IC_TRAN_PND
2215: ( p_delivery_detail_id IN NUMBER,
2216: p_trans_id IN NUMBER,
2217: p_staged_flag IN NUMBER) IS
2218:

Line 2223: UPDATE ic_tran_pnd

2219: BEGIN
2220: IF ( p_delivery_detail_id IS NOT NULL AND p_trans_id is not NULL) THEN
2221:
2222: IF(p_staged_flag = 0) THEN
2223: UPDATE ic_tran_pnd
2224: SET line_detail_id = p_delivery_detail_id
2225: WHERE trans_id = p_trans_id ;
2226: ELSIF (p_staged_flag = 1) THEN
2227: UPDATE ic_tran_pnd

Line 2227: UPDATE ic_tran_pnd

2223: UPDATE ic_tran_pnd
2224: SET line_detail_id = p_delivery_detail_id
2225: WHERE trans_id = p_trans_id ;
2226: ELSIF (p_staged_flag = 1) THEN
2227: UPDATE ic_tran_pnd
2228: SET line_detail_id = p_delivery_detail_id,
2229: staged_ind = 1
2230: WHERE trans_id = p_trans_id ;
2231: END IF;

Line 2237: GMI_RESERVATION_UTIL.println('*** In update_opm_ic_tran_pnd');

2233: END IF;
2234:
2235: EXCEPTION
2236: WHEN OTHERS THEN
2237: GMI_RESERVATION_UTIL.println('*** In update_opm_ic_tran_pnd');
2238: GMI_RESERVATION_UTIL.println('*** When Others exception raised');
2239: END UPDATE_OPM_IC_TRAN_PND;
2240:
2241: PROCEDURE PRINT_DEBUG

Line 2239: END UPDATE_OPM_IC_TRAN_PND;

2235: EXCEPTION
2236: WHEN OTHERS THEN
2237: GMI_RESERVATION_UTIL.println('*** In update_opm_ic_tran_pnd');
2238: GMI_RESERVATION_UTIL.println('*** When Others exception raised');
2239: END UPDATE_OPM_IC_TRAN_PND;
2240:
2241: PROCEDURE PRINT_DEBUG
2242: (
2243: p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

Line 3032: FROM ic_tran_pnd

3028: p_lot_id in number,
3029: p_location in varchar
3030: )
3031: IS SELECT trans_id, line_detail_id
3032: FROM ic_tran_pnd
3033: WHERE doc_type='OMSO'
3034: AND line_id = p_line
3035: AND item_id = p_item_id
3036: AND lot_id = p_lot_id

Line 3089: From ic_tran_pnd

3085: , l_default_location IN VARCHAR2)
3086: IS
3087: SELECT
3088: count(*)
3089: From ic_tran_pnd
3090: Where line_id = p_line_id
3091: And doc_type = 'OMSO'
3092: And line_detail_id is null
3093: And delete_mark = 0

Line 3280: UPDATE IC_TRAN_PND

3276: UTL_FILE.putf(v_outputfile,',LINE DETAIL ID = %s\n',l_line_detail_id);
3277: -- Check if Line detail id NOT populated
3278: IF l_line_detail_id is NULL THEN
3279: -- Okay Now Perform Updates
3280: UPDATE IC_TRAN_PND
3281: SET LINE_DETAIL_ID = lines.SHIP_ID
3282: WHERE TRANS_ID = l_trans_id;
3283: l_trans_updated := l_trans_updated +1;
3284: ELSE

Line 3349: Update ic_tran_pnd

3345: and wdd.released_status = 'S';
3346: --END BUG#2736088
3347:
3348: /* find out all the trans and update them to the wdd dd_id */
3349: Update ic_tran_pnd
3350: Set line_detail_id = l_line_detail_id
3351: Where line_id = lines.line_id
3352: And doc_type = 'OMSO'
3353: And line_detail_id is null

Line 3504: l_old_transaction_row ic_tran_pnd%ROWTYPE ;

3500: x_msg_data OUT NOCOPY VARCHAR2)
3501: IS
3502: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3503: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3504: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
3505: l_new_transaction_row ic_tran_pnd%ROWTYPE;
3506: l_trans_id ic_tran_pnd.trans_id%TYPE;
3507: l_item_id ic_tran_pnd.item_id%TYPE;
3508: l_location ic_tran_pnd.location%TYPE;

Line 3505: l_new_transaction_row ic_tran_pnd%ROWTYPE;

3501: IS
3502: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3503: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3504: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
3505: l_new_transaction_row ic_tran_pnd%ROWTYPE;
3506: l_trans_id ic_tran_pnd.trans_id%TYPE;
3507: l_item_id ic_tran_pnd.item_id%TYPE;
3508: l_location ic_tran_pnd.location%TYPE;
3509: l_lot_id ic_tran_pnd.lot_id%TYPE;

Line 3506: l_trans_id ic_tran_pnd.trans_id%TYPE;

3502: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3503: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3504: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
3505: l_new_transaction_row ic_tran_pnd%ROWTYPE;
3506: l_trans_id ic_tran_pnd.trans_id%TYPE;
3507: l_item_id ic_tran_pnd.item_id%TYPE;
3508: l_location ic_tran_pnd.location%TYPE;
3509: l_lot_id ic_tran_pnd.lot_id%TYPE;
3510: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;

Line 3507: l_item_id ic_tran_pnd.item_id%TYPE;

3503: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3504: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
3505: l_new_transaction_row ic_tran_pnd%ROWTYPE;
3506: l_trans_id ic_tran_pnd.trans_id%TYPE;
3507: l_item_id ic_tran_pnd.item_id%TYPE;
3508: l_location ic_tran_pnd.location%TYPE;
3509: l_lot_id ic_tran_pnd.lot_id%TYPE;
3510: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
3511: l_new_delivery_detail_id NUMBER;

Line 3508: l_location ic_tran_pnd.location%TYPE;

3504: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
3505: l_new_transaction_row ic_tran_pnd%ROWTYPE;
3506: l_trans_id ic_tran_pnd.trans_id%TYPE;
3507: l_item_id ic_tran_pnd.item_id%TYPE;
3508: l_location ic_tran_pnd.location%TYPE;
3509: l_lot_id ic_tran_pnd.lot_id%TYPE;
3510: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
3511: l_new_delivery_detail_id NUMBER;
3512: l_source_line_id NUMBER;

Line 3509: l_lot_id ic_tran_pnd.lot_id%TYPE;

3505: l_new_transaction_row ic_tran_pnd%ROWTYPE;
3506: l_trans_id ic_tran_pnd.trans_id%TYPE;
3507: l_item_id ic_tran_pnd.item_id%TYPE;
3508: l_location ic_tran_pnd.location%TYPE;
3509: l_lot_id ic_tran_pnd.lot_id%TYPE;
3510: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
3511: l_new_delivery_detail_id NUMBER;
3512: l_source_line_id NUMBER;
3513: l_fulfilled_qty NUMBER;

Line 3532: FROM ic_tran_pnd

3528:
3529:
3530: cursor c_reservations IS
3531: SELECT trans_id, doc_id
3532: FROM ic_tran_pnd
3533: WHERE line_id = p_old_source_line_id
3534: AND line_detail_id = p_old_delivery_detail_id
3535: AND delete_mark = 0
3536: AND doc_type = 'OMSO'

Line 3564: FROM ic_tran_pnd

3560: and mtl.organization_id = l_organization_id;
3561:
3562: Cursor nonctl_reservation IS
3563: SELECT trans_id
3564: FROM ic_tran_pnd
3565: WHERE line_id = p_old_source_line_id
3566: AND line_detail_id = p_old_delivery_detail_id
3567: AND delete_mark = 0
3568: AND doc_type = 'OMSO'

Line 3629: Update ic_tran_pnd

3625: OPEN c_reservations;
3626: LOOP
3627: FETCH c_reservations INTO l_trans_id, l_doc_id;
3628: EXIT WHEN c_reservations%NOTFOUND;
3629: Update ic_tran_pnd
3630: Set line_id = p_new_source_line_id
3631: Where trans_id = l_trans_id;
3632: GMI_RESERVATION_UTIL.Println('l_trans_id is '||l_trans_id);
3633: END LOOP;

Line 3640: Update ic_tran_pnd

3636: /* update the default lot to the new line_id */
3637: oe_debug_pub.add('Going to update ic_tranPnd with new line_id :'||p_new_source_line_id
3638: ||' for trans_id '||l_trans_id,2);
3639: IF l_trans_id > 0 THEN
3640: Update ic_tran_pnd
3641: Set line_id = p_new_source_line_id
3642: Where trans_id = l_trans_id;
3643: END IF;
3644:

Line 3659: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

3655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3656: END IF;
3657:
3658: l_old_transaction_rec.trans_id := l_trans_id;
3659: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3660: (l_old_transaction_rec, l_old_transaction_rec )
3661: THEN
3662: l_orig_txn_exists := 1; --Bug3149635
3663: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_old_source_line_id);

Line 3727: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

3723: l_old_transaction_rec.trans_id := l_new_transaction_row.trans_id;
3724: ELSE
3725: l_old_transaction_rec.trans_id := l_trans_id;
3726: END IF;
3727: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3728: (l_old_transaction_rec, l_old_transaction_rec )
3729: THEN
3730: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_new_source_line_id);
3731: GMI_RESERVATION_UTIL.balance_default_lot

Line 3765: Update ic_tran_pnd

3761: -- null;
3762: /* Bug2901317 */
3763: IF (p_new_delivery_detail_id is NOT NULL) AND (p_old_source_line_id is NOT NULL) AND
3764: (p_new_source_line_id is NOT NULL) AND (p_old_source_line_id <> p_new_source_line_id) THEN
3765: Update ic_tran_pnd
3766: Set line_id = p_new_source_line_id
3767: Where line_id = p_old_source_line_id
3768: and line_detail_id = p_new_delivery_detail_id;
3769: GMI_RESERVATION_UTIL.PrintLn('Updated Here');

Line 3780: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

3776: EXIT WHEN c_reservations%NOTFOUND;
3777:
3778: l_old_transaction_rec.trans_id := l_trans_id;
3779:
3780: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3781: (l_old_transaction_rec, l_old_transaction_rec )
3782: THEN
3783: GMI_RESERVATION_UTIL.Println('got trans for trans_id '||l_trans_id);
3784: GMI_RESERVATION_UTIL.Println('l_qty_to_fulfil '||l_qty_to_fulfil);

Line 3798: update ic_tran_pnd

3794: /* not sure why this */
3795: --l_old_transaction_rec.trans_qty := -1 * (l_qty_to_fulfil);
3796: --l_old_transaction_rec.trans_qty2 := -1 * (l_qty2_to_fulfil);
3797:
3798: update ic_tran_pnd
3799: set trans_qty = -1 * l_qty_to_fulfil
3800: , trans_qty2 = -1 * l_qty2_to_fulfil
3801: Where trans_id = l_trans_id;
3802:

Line 3835: update ic_tran_pnd

3831: l_qty_to_fulfil := 0;
3832: l_qty2_to_fulfil := 0;
3833: ELSIF l_qty_to_fulfil <= 0 THEN
3834: /* simply update the rest with the new wdd id and new line_id */
3835: update ic_tran_pnd
3836: set line_detail_id = p_new_delivery_detail_id
3837: , line_id = p_new_source_line_id
3838: Where trans_id = l_trans_id;
3839: END IF;

Line 3857: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

3853: l_old_transaction_rec.trans_id := l_trans_id;
3854: -- B2985470 old line has txn new should also have one.
3855: l_orig_txn_exists := 1; -- B2985470
3856:
3857: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3858: (l_old_transaction_rec, l_old_transaction_rec )
3859: THEN
3860: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_old_source_line_id);
3861: GMI_RESERVATION_UTIL.balance_default_lot

Line 3886: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

3882: IF l_trans_id > 0 AND p_new_source_line_id <> p_old_source_line_id
3883: THEN -- if it does not exist, don't bother
3884: l_old_transaction_rec.trans_id := l_trans_id;
3885:
3886: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3887: (l_old_transaction_rec, l_old_transaction_rec )
3888: THEN
3889: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_new_source_line_id);
3890: GMI_RESERVATION_UTIL.balance_default_lot

Line 3946: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

3942: IF l_trans_id > 0 AND p_new_source_line_id <> p_old_source_line_id
3943: THEN -- if it does not exist, don't bother
3944: l_old_transaction_rec.trans_id := l_trans_id;
3945:
3946: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3947: (l_old_transaction_rec, l_old_transaction_rec )
3948: THEN
3949: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_new_source_line_id);
3950: GMI_RESERVATION_UTIL.balance_default_lot

Line 4001: l_old_transaction_row ic_tran_pnd%ROWTYPE ;

3997: )
3998: IS
3999: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4000: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4001: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4002: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4003: l_trans_id ic_tran_pnd.trans_id%TYPE;
4004: l_item_id ic_tran_pnd.item_id%TYPE;
4005: l_location ic_tran_pnd.location%TYPE;

Line 4002: l_new_transaction_row ic_tran_pnd%ROWTYPE;

3998: IS
3999: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4000: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4001: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4002: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4003: l_trans_id ic_tran_pnd.trans_id%TYPE;
4004: l_item_id ic_tran_pnd.item_id%TYPE;
4005: l_location ic_tran_pnd.location%TYPE;
4006: l_lot_id ic_tran_pnd.lot_id%TYPE;

Line 4003: l_trans_id ic_tran_pnd.trans_id%TYPE;

3999: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4000: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4001: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4002: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4003: l_trans_id ic_tran_pnd.trans_id%TYPE;
4004: l_item_id ic_tran_pnd.item_id%TYPE;
4005: l_location ic_tran_pnd.location%TYPE;
4006: l_lot_id ic_tran_pnd.lot_id%TYPE;
4007: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;

Line 4004: l_item_id ic_tran_pnd.item_id%TYPE;

4000: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4001: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4002: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4003: l_trans_id ic_tran_pnd.trans_id%TYPE;
4004: l_item_id ic_tran_pnd.item_id%TYPE;
4005: l_location ic_tran_pnd.location%TYPE;
4006: l_lot_id ic_tran_pnd.lot_id%TYPE;
4007: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
4008: l_source_line_id NUMBER;

Line 4005: l_location ic_tran_pnd.location%TYPE;

4001: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4002: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4003: l_trans_id ic_tran_pnd.trans_id%TYPE;
4004: l_item_id ic_tran_pnd.item_id%TYPE;
4005: l_location ic_tran_pnd.location%TYPE;
4006: l_lot_id ic_tran_pnd.lot_id%TYPE;
4007: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
4008: l_source_line_id NUMBER;
4009: l_inventory_item_id NUMBER;

Line 4006: l_lot_id ic_tran_pnd.lot_id%TYPE;

4002: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4003: l_trans_id ic_tran_pnd.trans_id%TYPE;
4004: l_item_id ic_tran_pnd.item_id%TYPE;
4005: l_location ic_tran_pnd.location%TYPE;
4006: l_lot_id ic_tran_pnd.lot_id%TYPE;
4007: l_line_detail_id wsh_delivery_details.delivery_detail_id%TYPE;
4008: l_source_line_id NUMBER;
4009: l_inventory_item_id NUMBER;
4010: l_organization_id NUMBER;

Line 4029: FROM ic_tran_pnd

4025: Where delivery_detail_id = p_delivery_detail_id;
4026:
4027: cursor c_reservations IS
4028: SELECT trans_id
4029: FROM ic_tran_pnd
4030: WHERE line_id = l_source_line_id
4031: AND line_detail_id = p_delivery_detail_id
4032: AND delete_mark = 0
4033: AND doc_type = 'OMSO'

Line 4070: update ic_tran_pnd

4066: END IF;
4067: Close c_reservations;
4068: IF l_trans_id <> 0 THEN -- already ship confirmed, then reopened
4069: l_been_there := 1;
4070: update ic_tran_pnd
4071: set delete_mark=1
4072: Where trans_id=l_trans_id;
4073: END IF;
4074:

Line 4084: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

4080: p_line_id => l_source_line_id
4081: );
4082: l_get_trans := 0;
4083: l_old_transaction_rec.trans_id := l_trans_id;
4084: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
4085: (l_old_transaction_rec, l_old_transaction_rec )
4086: THEN
4087: l_get_trans := 1;
4088: END IF;

Line 4105: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

4101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4102: END IF;
4103: l_get_trans := 0;
4104: /* need to fetch it again */
4105: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
4106: (l_old_transaction_rec, l_old_transaction_rec )
4107: THEN
4108: l_get_trans := 1;
4109: END IF;

Line 4118: update ic_tran_pnd

4114: IF p_shipped_quantity >= abs(l_old_transaction_rec.trans_qty) THEN -- ship the whole thing and more
4115: /* this line is no longer default trans */
4116: l_old_transaction_rec.trans_qty := -1 * (p_shipped_quantity);
4117: l_old_transaction_rec.trans_qty2 := -1 * (p_shipped_quantity2);
4118: update ic_tran_pnd
4119: set trans_qty = l_old_transaction_rec.trans_qty
4120: , trans_qty2 = l_old_transaction_rec.trans_qty2
4121: , line_detail_id = p_delivery_detail_id
4122: , staged_ind = 1

Line 4127: update ic_tran_pnd

4123: Where trans_id = l_trans_id;
4124:
4125: ELSE -- partial ship
4126: GMI_RESERVATION_UTIL.println('split the default lot ','opm.log');
4127: update ic_tran_pnd
4128: set trans_qty = -1 * p_shipped_quantity
4129: , trans_qty2 = -1 * p_shipped_quantity2
4130: , line_detail_id = p_delivery_detail_id
4131: , staged_ind = 1

Line 4175: l_transaction_row ic_tran_pnd%ROWTYPE;

4171: , x_return_status OUT NOCOPY VARCHAR2
4172: ) IS
4173: l_trans_id NUMBER;
4174: l_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4175: l_transaction_row ic_tran_pnd%ROWTYPE;
4176: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4177: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4178: x_msg_count NUMBER;
4179: x_msg_data VARCHAR2(3000);

Line 4176: l_new_transaction_row ic_tran_pnd%ROWTYPE;

4172: ) IS
4173: l_trans_id NUMBER;
4174: l_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4175: l_transaction_row ic_tran_pnd%ROWTYPE;
4176: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4177: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4178: x_msg_count NUMBER;
4179: x_msg_data VARCHAR2(3000);
4180: l_trans_qty NUMBER;

Line 4190: From ic_tran_pnd

4186: cursor c_get_opm_txn is
4187: Select trans_id
4188: , trans_qty
4189: , trans_qty2
4190: From ic_tran_pnd
4191: Where line_detail_id = p_delivery_detail_id
4192: --and line_id = p_source_line_id
4193: and doc_type='OMSO'
4194: and delete_mark = 0;

Line 4227: GMI_RESERVATION_UTIL.println('update the ic_tran_pnd');

4223: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: END IF;
4226: ELSE
4227: GMI_RESERVATION_UTIL.println('update the ic_tran_pnd');
4228: Update ic_tran_pnd
4229: Set trans_qty = -1 * (abs(l_trans_qty) - l_quantity_to_unreserve)
4230: , trans_qty2 = -1 * (abs(l_trans_qty2) - l_quantity_to_unreserve2)
4231: Where trans_id = l_trans_id;

Line 4228: Update ic_tran_pnd

4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: END IF;
4226: ELSE
4227: GMI_RESERVATION_UTIL.println('update the ic_tran_pnd');
4228: Update ic_tran_pnd
4229: Set trans_qty = -1 * (abs(l_trans_qty) - l_quantity_to_unreserve)
4230: , trans_qty2 = -1 * (abs(l_trans_qty2) - l_quantity_to_unreserve2)
4231: Where trans_id = l_trans_id;
4232: END IF;

Line 4234: update ic_tran_pnd

4230: , trans_qty2 = -1 * (abs(l_trans_qty2) - l_quantity_to_unreserve2)
4231: Where trans_id = l_trans_id;
4232: END IF;
4233: ELSE -- p_unreserve_mode = 'CYCLE_COUNT'
4234: update ic_tran_pnd
4235: set staged_ind = 0
4236: Where trans_id = l_trans_id;
4237: END IF; -- of mode
4238: END IF; -- l_trans_id

Line 4322: l_item_id ic_tran_pnd.item_id%TYPE;

4318: p_inventory_item_id IN NUMBER
4319: ,p_mtl_organization_id IN NUMBER
4320: ,x_ctl_ind OUT NOCOPY VARCHAR2)
4321: IS
4322: l_item_id ic_tran_pnd.item_id%TYPE;
4323: l_loct_ctl NUMBER;
4324: l_whse_ctl NUMBER;
4325:
4326: Cursor Get_item_info IS

Line 4384: FROM IC_TRAN_PND IC

4380: -- Get the eligible records from inventory
4381: CURSOR GET_IC_RECORDS (l_source_line_id IN NUMBER
4382: , l_dd_id IN NUMBER)IS
4383: SELECT line_id,line_detail_id
4384: FROM IC_TRAN_PND IC
4385: WHERE IC.line_id = l_source_line_id
4386: AND ic.line_detail_id = l_dd_id
4387: AND IC.staged_ind = 0
4388: AND IC.trans_qty <> 0

Line 4437: -- Get source_line and original line_detail_id from IC_TRAN_PND

4433: -- with the new values
4434: for i IN p_old_dd_ids.FIRST .. p_old_dd_ids.LAST LOOP --{
4435: l_wdd_id := p_old_dd_ids(i);
4436:
4437: -- Get source_line and original line_detail_id from IC_TRAN_PND
4438:
4439: OPEN GET_IC_RECORDS(l_new_source_line_id, l_wdd_id);
4440: FETCH GET_IC_RECORDS into l_line_id,l_ic_dd;
4441:

Line 4447: -- Make sure values are not null and match old dd_id in IC_TRAN_PND

4443: gmi_reservation_util.println('Value of l_icc_dd is '||l_ic_dd);
4444: gmi_reservation_util.println('Value of old dd is '||p_old_dd_ids(i));
4445:
4446:
4447: -- Make sure values are not null and match old dd_id in IC_TRAN_PND
4448: IF ( ( nvl(l_line_id, 0) <> 0) AND ( p_old_dd_ids(i) = l_ic_dd )
4449: AND ( ( nvl(l_ic_dd, 0) <> 0) )) THEN
4450:
4451: -- Update Inventoryu with new delivery_detail_id

Line 4452: gmi_reservation_util.println('Update ic_tran_pnd with new line_detail_id '||p_cons_dd_id);

4448: IF ( ( nvl(l_line_id, 0) <> 0) AND ( p_old_dd_ids(i) = l_ic_dd )
4449: AND ( ( nvl(l_ic_dd, 0) <> 0) )) THEN
4450:
4451: -- Update Inventoryu with new delivery_detail_id
4452: gmi_reservation_util.println('Update ic_tran_pnd with new line_detail_id '||p_cons_dd_id);
4453: UPDATE IC_TRAN_PND IC
4454: SET IC.line_detail_id = p_cons_dd_id
4455: WHERE IC.line_detail_id = l_ic_dd
4456: AND IC.line_id = l_line_id ;

Line 4453: UPDATE IC_TRAN_PND IC

4449: AND ( ( nvl(l_ic_dd, 0) <> 0) )) THEN
4450:
4451: -- Update Inventoryu with new delivery_detail_id
4452: gmi_reservation_util.println('Update ic_tran_pnd with new line_detail_id '||p_cons_dd_id);
4453: UPDATE IC_TRAN_PND IC
4454: SET IC.line_detail_id = p_cons_dd_id
4455: WHERE IC.line_detail_id = l_ic_dd
4456: AND IC.line_id = l_line_id ;
4457:

Line 4459: GMI_RESERVATION_UTIL.println('Error In Updating IC_TRAN_PND');

4455: WHERE IC.line_detail_id = l_ic_dd
4456: AND IC.line_id = l_line_id ;
4457:
4458: IF (SQL%NOTFOUND) THEN
4459: GMI_RESERVATION_UTIL.println('Error In Updating IC_TRAN_PND');
4460: RAISE NO_DATA_FOUND;
4461: END IF; -- of error updating
4462:
4463: END IF; -- of line_id and old_dd_id