DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on GMI_TRANS_ENGINE_PUB

Line 3239: l_trans_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3235: l_reservation_id NUMBER;
3236: l_primary_quantity NUMBER;
3237: l_txn_source_line_id NUMBER;
3238: l_error_code NUMBER;
3239: l_trans_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3240: l_trans_row ic_tran_pnd%ROWTYPE;
3241:
3242: cursor c_line_info IS
3243: SELECT quantity

Line 3350: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION

3346: GMI_Reservation_Util.PrintLn('trans_qty = ' || l_trans_rec.trans_qty);
3347: IF abs(l_trans_rec.trans_qty) <= l_quantity_to_delete THEN
3348: -- if so, simply delete the rsv , will balance default later
3349: GMI_Reservation_Util.PrintLn('set delete trans' );
3350: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3351: ( 1
3352: , FND_API.G_FALSE
3353: , FND_API.G_FALSE
3354: , FND_API.G_VALID_LEVEL_FULL

Line 3372: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

3368: ELSE
3369: GMI_Reservation_Util.PrintLn('update ic_tran_pnd ' );
3370: l_trans_rec.trans_qty := -1 * (abs(l_trans_rec.trans_qty) - l_quantity_to_delete);
3371: l_trans_rec.trans_qty2 := -1 * (abs(l_trans_rec.trans_qty2) - l_quantity2_to_delete);
3372: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3373: ( 1
3374: , FND_API.G_FALSE
3375: , FND_API.G_FALSE
3376: , FND_API.G_VALID_LEVEL_FULL

Line 3438: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION

3434: END IF;
3435: ELSE
3436: /* delete this default lot, and created a new one */
3437: GMI_Reservation_Util.PrintLn('delete trans trans_id'||l_trans_rec.trans_id);
3438: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3439: ( 1
3440: , FND_API.G_FALSE
3441: , FND_API.G_FALSE
3442: , FND_API.G_VALID_LEVEL_FULL

Line 3462: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

3458: From ic_whse_mst
3459: Where mtl_organization_id = l_ship_from_org_id
3460: and rownum = 1; -- just in case, should only have 1 row
3461:
3462: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3463: ( 1
3464: , FND_API.G_FALSE
3465: , FND_API.G_FALSE
3466: , FND_API.G_VALID_LEVEL_FULL

Line 3631: l_trans_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3627: l_primary_uom_code VARCHAR2(3);
3628: l_inventory_Item_id NUMBER;
3629: l_prim_quantity_to_delete NUMBER;
3630: l_remaining_quantity NUMBER;
3631: l_trans_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3632: l_trans_row ic_tran_pnd%ROWTYPE;
3633:
3634: cursor c_line_info IS
3635: SELECT quantity

Line 3803: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION

3799: /* may have to consider indivisible */
3800: IF abs(l_trans_rec.trans_qty) <= l_quantity_to_delete THEN
3801: -- if so, simply delete the rsv , will balance default later
3802: gmi_reservation_util.println('Going to delete tran in reduceMove');
3803: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3804: ( 1
3805: , FND_API.G_FALSE
3806: , FND_API.G_FALSE
3807: , FND_API.G_VALID_LEVEL_FULL

Line 3825: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

3821: ELSE
3822: gmi_reservation_util.println('In ELSE and will be updateing ic_tran');
3823: l_trans_rec.trans_qty := -1 * (abs(l_trans_rec.trans_qty) - l_quantity_to_delete);
3824: l_trans_rec.trans_qty2:= -1 * (abs(l_trans_rec.trans_qty2) - l_quantity2_to_delete);
3825: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3826: ( 1
3827: , FND_API.G_FALSE
3828: , FND_API.G_FALSE
3829: , FND_API.G_VALID_LEVEL_FULL