DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on GMI_MOVE_ORDER_LINE_UTIL

Line 1: PACKAGE BODY GMI_MOVE_ORDER_LINE_UTIL AS

1: PACKAGE BODY GMI_MOVE_ORDER_LINE_UTIL AS
2: /* $Header: GMIUMOLB.pls 120.0 2005/05/25 16:13:10 appldev noship $ */
3: /* ===========================================================================
4: | Copyright (c) 2000 Oracle Corporation |
5: | TVP, Reading, England |

Line 13: | Body of package GMI_Move_order_line_Util |

9: | GMIUMOLB.pls |
10: | |
11: | DESCRIPTION |
12: | |
13: | Body of package GMI_Move_order_line_Util |
14: | |
15: | NOTES |
16: | |
17: | HISTORY |

Line 37: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMI_MOVE_ORDER_LINE_UTIL';

33: */
34:
35: /* Global constant holding the package name */
36:
37: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMI_MOVE_ORDER_LINE_UTIL';
38:
39:
40: /* Function Convert_Miss_To_Null */
41:

Line 472: l_mo_line_rec := GMI_MOVE_ORDER_LINE_util.Query_Row( p_line_id );

468: )
469: IS
470: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
471: BEGIN
472: l_mo_line_rec := GMI_MOVE_ORDER_LINE_util.Query_Row( p_line_id );
473: l_mo_line_rec.Line_Status := p_status;
474: l_mo_line_rec.last_update_date := SYSDATE;
475: l_mo_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
476: l_mo_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

Line 478: GMI_MOVE_ORDER_LINE_UTIL.Update_Row(l_mo_line_rec);

474: l_mo_line_rec.last_update_date := SYSDATE;
475: l_mo_line_rec.last_updated_by := FND_GLOBAL.USER_ID;
476: l_mo_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
477:
478: GMI_MOVE_ORDER_LINE_UTIL.Update_Row(l_mo_line_rec);
479:
480: EXCEPTION
481:
482: WHEN OTHERS THEN

Line 2128: l_mo_line_tbl(1) := GMI_Move_Order_Line_Util.Query_Row( p_mo_line_id);

2124: /* call directed pick and put away api */
2125: IF ( p_move_order_type = 3 )
2126: THEN
2127: /* Get The Move Order line (1 line) */
2128: l_mo_line_tbl(1) := GMI_Move_Order_Line_Util.Query_Row( p_mo_line_id);
2129:
2130: l_mo_line_rec.line_id := p_mo_line_id;
2131:
2132: GMI_Move_Order_Line_Util.Lock_Row(

Line 2132: GMI_Move_Order_Line_Util.Lock_Row(

2128: l_mo_line_tbl(1) := GMI_Move_Order_Line_Util.Query_Row( p_mo_line_id);
2129:
2130: l_mo_line_rec.line_id := p_mo_line_id;
2131:
2132: GMI_Move_Order_Line_Util.Lock_Row(
2133: p_mo_line_rec => l_mo_line_rec
2134: , x_mo_line_rec => ll_mo_line_rec
2135: , x_return_status => x_return_status);
2136:

Line 2461: l_mo_line_tbl(1) := GMI_Move_Order_Line_Util.Query_Row( p_mo_line_id);

2457: THEN
2458: gmi_reservation_util.println('Move Order type is 3');
2459: /* Get The Move Order line (1 line) */
2460: gmi_reservation_util.println('Going to query the row with id = '||p_mo_line_id);
2461: l_mo_line_tbl(1) := GMI_Move_Order_Line_Util.Query_Row( p_mo_line_id);
2462:
2463:
2464: l_mo_line_rec.line_id := p_mo_line_id;
2465: gmi_reservation_util.println('Value of l_mo_line_rec.line_id using to lock row is '||l_mo_line_rec.line_id);

Line 2466: GMI_Move_Order_Line_Util.Lock_Row(

2462:
2463:
2464: l_mo_line_rec.line_id := p_mo_line_id;
2465: gmi_reservation_util.println('Value of l_mo_line_rec.line_id using to lock row is '||l_mo_line_rec.line_id);
2466: GMI_Move_Order_Line_Util.Lock_Row(
2467: p_mo_line_rec => l_mo_line_rec
2468: , x_mo_line_rec => ll_mo_line_rec
2469: , x_return_status => x_return_status);
2470:

Line 2951: GMI_Move_Order_Line_Util.Line_Auto_Detail

2947:
2948:
2949: GMI_Reservation_Util.PrintLn('(opm_dbg) in alloc engine b4 call to LINE_AUTO_DETAIL');
2950:
2951: GMI_Move_Order_Line_Util.Line_Auto_Detail
2952: ( p_mo_line_id => l_mo_line_id
2953: , p_init_msg_list => 1
2954: , p_transaction_header_id => 0
2955: , p_transaction_mode => 1

Line 3044: GMI_Move_Order_Line_Util. Line_Pick_Confirm

3040:
3041: WSH_UTIL_CORE.PRINTMSG( ' START PICK CONFIRMATION');
3042: WSH_UTIL_CORE.PRINTMSG;
3043:
3044: GMI_Move_Order_Line_Util. Line_Pick_Confirm
3045: ( p_mo_line_id => l_mo_line_id
3046: , p_init_msg_list => 1
3047: , p_move_order_type => 3
3048: , x_delivered_qty => l_detailed_qty

Line 3930: END GMI_MOVE_ORDER_LINE_UTIL;

3926: WHERE move_order_line_id = p_line_id;*/
3927: END update_txn_source_line;
3928:
3929:
3930: END GMI_MOVE_ORDER_LINE_UTIL;