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_PICK_WAVE_CONFIRM_PVT dependencies on IC_TRAN_PND

Line 189: l_location IC_TRAN_PND.LOCATION%TYPE;

185: l_msg_data VARCHAR2(2000);
186: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
187: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
188: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
189: l_location IC_TRAN_PND.LOCATION%TYPE;
190: l_ic_item_mst_rec GMI_RESERVATION_UTIL.ic_item_mst_rec;
191: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
192: l_trans_qty NUMBER;
193: l_trans_qty2 NUMBER;

Line 249: FROM ic_tran_pnd

245: p_location VARCHAR2,
246: p_item_id NUMBER)
247: is
248: SELECT SUM(ABS(trans_qty)),SUM(ABS(trans_qty2))
249: FROM ic_tran_pnd
250: WHERE line_id = p_line_id
251: AND ( lot_id > 0
252: OR location <> p_location )
253: -- AND item_id = p_item_id -- REMOVED for bug 3403418

Line 270: FROM ic_tran_pnd

266: CURSOR cur_txn_with_default ( p_line_id NUMBER,
267: p_item_id NUMBER)
268: is
269: SELECT SUM(ABS(trans_qty)),SUM(ABS(trans_qty2))
270: FROM ic_tran_pnd
271: WHERE line_id = p_line_id
272: -- AND item_id = p_item_id -- REMOVED for bug 3403418
273: AND doc_type = 'OMSO'
274: AND staged_ind = 0

Line 282: FROM ic_tran_pnd

278: CURSOR check_default_lot ( p_line_id NUMBER,
279: p_item_id NUMBER)
280: IS
281: SELECT count(*)
282: FROM ic_tran_pnd
283: WHERE line_id = p_line_id
284: -- AND item_id = p_item_id -- REMOVED for bug 3403418
285: AND doc_type = 'OMSO'
286: AND staged_ind = 0

Line 304: FROM IC_TRAN_PND tran,

300: lots.lot_no,
301: lots.lot_id,
302: lots.sublot_no,
303: loct.INVENTORY_LOCATION_ID locator_id
304: FROM IC_TRAN_PND tran,
305: IC_LOTS_MST lots,
306: IC_LOCT_MST loct
307: WHERE lots.lot_id = tran.lot_id
308: AND lots.item_id = tran.item_id

Line 362: From ic_tran_pnd pnd

358: p_location IN VARCHAR2)
359: IS
360: Select nvl(sum(trans_qty),0)
361: ,nvl(sum(nvl(trans_qty2,0)),0)
362: From ic_tran_pnd pnd
363: Where pnd.completed_ind =0
364: AND pnd.delete_mark = 0
365: AND pnd.staged_ind = 1
366: AND pnd.doc_type= 'OMSO'

Line 375: FROM ic_tran_pnd

371: -- End Bug 3609713
372:
373: CURSOR qty_sum_for_del IS
374: SELECT SUM(ABS(trans_qty)),SUM(ABS(trans_qty2))
375: FROM ic_tran_pnd
376: WHERE line_id = l_mo_line_rec.txn_source_line_id
377: AND line_detail_id = l_delivery_detail_id
378: AND delete_mark = 0;
379:

Line 399: FROM ic_tran_pnd trans

395: p_item_id NUMBER,
396: p_mo_line_id NUMBER)
397: is
398: SELECT SUM(ABS(nvl(trans_qty,0))),SUM(ABS(nvl(trans_qty2,0)))
399: FROM ic_tran_pnd trans
400: , ic_loct_inv lots
401: , ic_lots_sts sts
402: WHERE trans.line_id = p_line_id
403: AND trans.lot_id > 0

Line 441: FROM ic_tran_pnd tran

437: AND inv.lot_status = sts.lot_status
438: ;
439: CURSOR qty_sum_for_del_sts IS
440: SELECT SUM(ABS(trans_qty)),SUM(ABS(trans_qty2))
441: FROM ic_tran_pnd tran
442: , ic_loct_inv inv -- get status
443: , ic_lots_sts sts -- status check
444: WHERE tran.line_id = l_mo_line_rec.txn_source_line_id
445: AND tran.line_detail_id = l_delivery_detail_id

Line 465: FROM ic_tran_pnd

461: p_line_detail_id IN NUMBER) IS
462: SELECT trans_id
463: , trans_qty
464: , trans_qty2
465: FROM ic_tran_pnd
466: WHERE line_id = p_line_id
467: -- AND item_id = p_item_id -- REMOVED for bug 3403418
468: AND doc_type = 'OMSO'
469: AND staged_ind = 1

Line 479: l_tran_row IC_TRAN_PND%ROWTYPE;

475: d_trans_id NUMBER;
476: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
477: l_available_qty NUMBER;
478: l_available_qty2 NUMBER;
479: l_tran_row IC_TRAN_PND%ROWTYPE;
480: l_pick_slip_number NUMBER;
481: OM_G_installed VARCHAR2(30);
482: l_allow_negative_inv NUMBER; /* 2690711 */
483: /* End Enhancement 2320442 - Lakshmi Swamy */

Line 1106: UPDATE ic_tran_pnd -- NOT NEEDED

1102: /* On Update i.e lot_id, qc_grade, locator_id, */
1103: /* NC added delivery_detail_id and staged_ind in the where clause */
1104: /* -- BUG#1675561*/
1105:
1106: UPDATE ic_tran_pnd -- NOT NEEDED
1107: SET staged_ind =1
1108: --line_detail_id = l_shipping_attr(1).delivery_detail_id
1109: WHERE trans_id = l_mo_line_txn_rec.trans_id AND
1110: staged_ind <> 1 and delete_mark <> 1;

Line 1129: UPDATE ic_tran_pnd

1125: FND_MSG_PUB.Add;
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128:
1129: UPDATE ic_tran_pnd
1130: SET pick_slip_number = l_pick_slip_number
1131: WHERE trans_id = l_mo_line_txn_rec.trans_id;
1132:
1133: /* End of Setting the pick slip number - Bug2455422 */

Line 1346: UPDATE ic_tran_pnd

1342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1343: END IF;
1344:
1345: IF (d_trans_id is NOT NULL) THEN
1346: UPDATE ic_tran_pnd
1347: SET pick_slip_number = NULL
1348: WHERE trans_id = d_trans_id;
1349: END IF;
1350: /* End Bug2936797 */

Line 2389: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

2385: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2386: , p_requested_qty IN NUMBER
2387: , p_requested_qty2 IN NUMBER
2388: , p_delivery_detail_id IN NUMBER
2389: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
2390: , x_return_status OUT NOCOPY VARCHAR2
2391: , x_msg_count OUT NOCOPY NUMBER
2392: , x_msg_data OUT NOCOPY VARCHAR2
2393: )

Line 2402: /* Split ic_tran_pnd to have remaining quantity backordered.

2398: BEGIN
2399:
2400: l_dflt_nonctl_tran_rec := p_dflt_nonctl_tran_rec;
2401:
2402: /* Split ic_tran_pnd to have remaining quantity backordered.
2403: set the staged ind on original line to 1 */
2404:
2405: l_dflt_nonctl_tran_rec.trans_qty := (-1) *(ABS(l_dflt_nonctl_tran_rec.trans_qty) - p_requested_qty);
2406: l_dflt_nonctl_tran_rec.trans_qty2 := (-1) *(ABS(l_dflt_nonctl_tran_rec.trans_qty2) - p_requested_qty2);

Line 2504: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE

2500: , p_requested_qty2 IN NUMBER
2501: , p_delivery_detail_id IN NUMBER
2502: , x_available_qty OUT NOCOPY NUMBER
2503: , x_available_qty2 OUT NOCOPY NUMBER
2504: , x_tran_row OUT NOCOPY IC_TRAN_PND%ROWTYPE
2505: , x_return_status OUT NOCOPY VARCHAR2
2506: , x_msg_count OUT NOCOPY NUMBER
2507: , x_msg_data OUT NOCOPY VARCHAR2
2508: )

Line 2523: FROM ic_tran_pnd

2519:
2520:
2521: CURSOR staged_qty_CUR IS
2522: SELECT NVL(sum(trans_qty),0), NVL(sum(trans_qty2),0)
2523: FROM ic_tran_pnd
2524: WHERE item_id = p_item_id
2525: AND whse_code = p_whse_code
2526: AND doc_type = 'OMSO'
2527: AND staged_ind = 1

Line 2549: l_tran_row IC_TRAN_PND%ROWTYPE;

2545: l_trans_id NUMBER;
2546: l_dflt_nonctl_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2547: l_dflt_nonctl_tran_rec1 GMI_TRANS_ENGINE_PUB.ictran_rec;
2548: l_validation_level VARCHAR2(4) := FND_API.G_VALID_LEVEL_FULL;
2549: l_tran_row IC_TRAN_PND%ROWTYPE;
2550: l_onhand_qty NUMBER := 0; -- Bug 2910069
2551: l_onhand_qty2 NUMBER := 0; -- Bug 2910069
2552: l_backorder_qty NUMBER := 0;
2553: l_backorder_qty2 NUMBER := 0;

Line 2577: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

2573: );
2574:
2575: l_dflt_nonctl_tran_rec1.trans_id := l_trans_id;
2576:
2577: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
2578: (l_dflt_nonctl_tran_rec1, l_dflt_nonctl_tran_rec ) THEN
2579:
2580: Open item_mst_dtl;
2581: Fetch item_mst_dtl INTO l_noninv_ind;

Line 2665: UPDATE ic_tran_pnd

2661: FND_MSG_PUB.Add;
2662: RAISE FND_API.G_EXC_ERROR;
2663: END IF;
2664:
2665: UPDATE ic_tran_pnd
2666: SET pick_slip_number = l_pick_slip_number
2667: WHERE trans_id = l_tran_row.trans_id;
2668:
2669: /* End Bug2936797 */

Line 2698: /* Split ic_tran_pnd to have remaining quantity backordered.

2694: GMI_Reservation_Util.PrintLn('p_requested_qty '||p_requested_qty);
2695:
2696: IF (x_available_qty <> 0) THEN
2697: IF (x_available_qty < p_requested_qty) THEN
2698: /* Split ic_tran_pnd to have remaining quantity backordered.
2699: set the staged ind on original line to 1 */
2700:
2701: l_backorder_qty := p_requested_qty - x_available_qty;
2702: l_backorder_qty2 := p_requested_qty2 - x_available_qty2;

Line 2755: /* Split ic_tran_pnd to have remaining quantity backordered.

2751: raise FND_API.G_EXC_ERROR;
2752: END IF;
2753:
2754: ELSIF (p_requested_qty <> ABS(l_dflt_nonctl_tran_rec.trans_qty)) THEN
2755: /* Split ic_tran_pnd to have remaining quantity backordered.
2756: set the staged ind on original line to 1 */
2757:
2758: l_dflt_nonctl_tran_rec.trans_qty := (-1) *(ABS(l_dflt_nonctl_tran_rec.trans_qty) - p_requested_qty);
2759: l_dflt_nonctl_tran_rec.trans_qty2 := (-1) *(ABS(l_dflt_nonctl_tran_rec.trans_qty2) - p_requested_qty2);

Line 2877: UPDATE ic_tran_pnd

2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875:
2876: GMI_reservation_Util.PrintLn('l_tran_row.trans_id '||l_tran_row.trans_id );
2877: UPDATE ic_tran_pnd
2878: SET pick_slip_number = l_pick_slip_number
2879: WHERE trans_id = l_tran_row.trans_id;
2880:
2881: x_tran_row := l_tran_row;

Line 2883: END IF; /* IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND */

2879: WHERE trans_id = l_tran_row.trans_id;
2880:
2881: x_tran_row := l_tran_row;
2882: END IF; /* IF (x_available_qty <> 0) */
2883: END IF; /* IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND */
2884:
2885: EXCEPTION
2886:
2887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2950: FROM IC_TRAN_PND tran,

2946:
2947: CURSOR lot_loct_ctl_trans
2948: IS
2949: SELECT trans_id, trans_qty, trans_qty2
2950: FROM IC_TRAN_PND tran,
2951: IC_LOTS_MST lots,
2952: IC_LOCT_MST loct
2953: WHERE lots.lot_id = tran.lot_id
2954: AND lots.item_id = tran.item_id

Line 2977: update ic_tran_pnd

2973: GMI_Reservation_Util.PrintLn('Parameters- p_line_id:'||p_line_id||', p_delivery_detail_id:'||p_delivery_detail_id||', p_default_location:'||p_default_location);
2974: IF (is_lot_loct_ctl = TRUE) THEN
2975: FOR lot_loct_ctl_trans_rec in lot_loct_ctl_trans
2976: LOOP
2977: update ic_tran_pnd
2978: set trans_qty = trunc (trans_qty, l_TRUNCATE_TO_LENGTH),
2979: trans_qty2= trunc (trans_qty2, l_TRUNCATE_TO_LENGTH)
2980: where current of lot_loct_ctl_trans;
2981: GMI_Reservation_Util.PrintLn('Truncated transaction with trans_id: '||lot_loct_ctl_trans_rec.trans_id||' to '||l_TRUNCATE_TO_LENGTH||'th decimal');