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_MOVE_ORDER_LINE_UTIL dependencies on GMI_MOVE_ORDER_GLOBAL

Line 49: p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec

45: inv_pick_wave_pick_confirm_pub.tracelog(p_message, p_module);
46: END;
47: FUNCTION Convert_Miss_To_Null
48: (
49: p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
50: )
51: RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
52: IS
53: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec := p_mo_line_rec;

Line 51: RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec

47: FUNCTION Convert_Miss_To_Null
48: (
49: p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
50: )
51: RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
52: IS
53: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec := p_mo_line_rec;
54: BEGIN
55: /* =======================================================================

Line 53: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec := p_mo_line_rec;

49: p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
50: )
51: RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
52: IS
53: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec := p_mo_line_rec;
54: BEGIN
55: /* =======================================================================
56: Raise a temporary error, for Dummy calls
57: ======================================================================= */

Line 364: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec

360:
361: /* Procedure Update_Row */
362:
363: PROCEDURE Update_Row
364: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
365: )
366: IS
367: BEGIN
368:

Line 470: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;

466: ( p_line_id IN Number,
467: p_status IN Number
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;

Line 499: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec

495:
496: /* Procedure Insert_Row */
497:
498: PROCEDURE Insert_Row
499: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
500: )
501: IS
502: err_num NUMBER;
503: err_msg VARCHAR2(100);

Line 715: ) RETURN GMI_Move_Order_GLOBAL.mo_line_tbl

711: /* Function Get_Lines */
712:
713: FUNCTION Get_Lines
714: ( p_header_id IN NUMBER
715: ) RETURN GMI_Move_Order_GLOBAL.mo_line_tbl
716: IS
717: BEGIN
718:
719: RETURN Query_Rows

Line 730: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec

726: /* Function Query_Row */
727:
728: FUNCTION Query_Row
729: ( p_line_id IN NUMBER
730: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
731: IS
732: BEGIN
733:
734: RETURN Query_Rows

Line 749: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_tbl

745: FUNCTION Query_Rows
746: ( p_line_id IN NUMBER default NULL
747: , p_header_id IN NUMBER default NULL
748:
749: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_tbl
750: IS
751: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
752: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
753:

Line 751: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;

747: , p_header_id IN NUMBER default NULL
748:
749: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_tbl
750: IS
751: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
752: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
753:
754:
755: CURSOR l_mo_line_csr IS

Line 752: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;

748:
749: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_tbl
750: IS
751: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
752: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
753:
754:
755: CURSOR l_mo_line_csr IS
756: SELECT ATTRIBUTE1

Line 982: , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec

978: /* Procedure lock_Row */
979:
980: PROCEDURE Lock_Row
981: ( x_return_status OUT NOCOPY VARCHAR2
982: , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
983: , x_mo_line_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.mo_line_rec
984: )
985: IS
986: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;

Line 983: , x_mo_line_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.mo_line_rec

979:
980: PROCEDURE Lock_Row
981: ( x_return_status OUT NOCOPY VARCHAR2
982: , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
983: , x_mo_line_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.mo_line_rec
984: )
985: IS
986: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
987:

Line 986: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;

982: , p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
983: , x_mo_line_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.mo_line_rec
984: )
985: IS
986: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
987:
988: CURSOR c_lock_mol( mo_line_id IN NUMBER) IS
989: SELECT ATTRIBUTE1
990: , ATTRIBUTE10

Line 1208: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec

1204: /* Function Get_Values */
1205: /*
1206:
1207: FUNCTION Get_Values
1208: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
1209: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec :=
1210: INV_Move_Order_PUB.G_MISS_mo_line_rec
1211: ) RETURN INV_Move_Order_PUB.Trolin_Val_Rec_Type
1212: IS

Line 1209: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec :=

1205: /*
1206:
1207: FUNCTION Get_Values
1208: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
1209: , p_old_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec :=
1210: INV_Move_Order_PUB.G_MISS_mo_line_rec
1211: ) RETURN INV_Move_Order_PUB.Trolin_Val_Rec_Type
1212: IS
1213: l_trolin_val_rec INV_Move_Order_PUB.Trolin_Val_Rec_Type;

Line 1425: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec

1421:
1422: -- Function Get_Ids
1423:
1424: FUNCTION Get_Ids
1425: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
1426: , p_trolin_val_rec IN INV_Move_Order_PUB.Trolin_Val_Rec_Type
1427: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
1428: IS
1429: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;

Line 1427: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec

1423:
1424: FUNCTION Get_Ids
1425: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
1426: , p_trolin_val_rec IN INV_Move_Order_PUB.Trolin_Val_Rec_Type
1427: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
1428: IS
1429: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
1430: BEGIN
1431:

Line 1429: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;

1425: ( p_mo_line_rec IN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
1426: , p_trolin_val_rec IN INV_Move_Order_PUB.Trolin_Val_Rec_Type
1427: ) RETURN GMI_MOVE_ORDER_GLOBAL.mo_line_rec
1428: IS
1429: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
1430: BEGIN
1431:
1432: -- initialize return_status.
1433:

Line 2058: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;

2054: l_temp_id NUMBER;
2055: l_serial_number VARCHAR2(30);
2056:
2057: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
2058: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;
2059: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2060: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2061: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2062: l_default_lot_index NUMBER;

Line 2059: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;

2055: l_serial_number VARCHAR2(30);
2056:
2057: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
2058: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;
2059: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2060: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2061: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2062: l_default_lot_index NUMBER;
2063:

Line 2060: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;

2056:
2057: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
2058: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;
2059: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2060: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2061: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2062: l_default_lot_index NUMBER;
2063:
2064: l_pick_release_status INV_PICK_RELEASE_PUB.INV_RELEASE_STATUS_Tbl_Type;

Line 2061: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;

2057: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
2058: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;
2059: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2060: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2061: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2062: l_default_lot_index NUMBER;
2063:
2064: l_pick_release_status INV_PICK_RELEASE_PUB.INV_RELEASE_STATUS_Tbl_Type;
2065: l_return_status VARCHAR2(1);

Line 2425: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;

2421: l_init_msg_list VARCHAR2(255) := FND_API.G_TRUE;
2422: l_api_name CONSTANT VARCHAR2(30) := 'Line_Pick_Confirm';
2423: x_success NUMBER;
2424:
2425: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;
2426: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2427: -- HW OPM changes for NOCOPY
2428: ll_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2429: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;

Line 2426: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;

2422: l_api_name CONSTANT VARCHAR2(30) := 'Line_Pick_Confirm';
2423: x_success NUMBER;
2424:
2425: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;
2426: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2427: -- HW OPM changes for NOCOPY
2428: ll_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2429: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2430: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;

Line 2428: ll_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;

2424:
2425: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;
2426: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2427: -- HW OPM changes for NOCOPY
2428: ll_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2429: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2430: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2431:
2432: l_return_status VARCHAR2(1);

Line 2429: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;

2425: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;
2426: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2427: -- HW OPM changes for NOCOPY
2428: ll_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2429: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2430: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2431:
2432: l_return_status VARCHAR2(1);
2433: l_grouping_rule_id NUMBER;

Line 2430: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;

2426: l_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2427: -- HW OPM changes for NOCOPY
2428: ll_mo_line_tbl GMI_Move_Order_Global.mo_line_tbl;
2429: l_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2430: ll_mo_line_rec GMI_Move_Order_Global.mo_line_rec;
2431:
2432: l_return_status VARCHAR2(1);
2433: l_grouping_rule_id NUMBER;
2434: l_count NUMBER;