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_RESERVATION_UTIL dependencies on IC_ITEM_MST

Line 66: TYPE ic_item_mst_rec IS RECORD

62: G_DEFAULT_LOCT CONSTANT VARCHAR2(16):= FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
63:
64: /* SUBTYPE transaction_record IS ic_tran_pnd%ROWTYPE; */
65:
66: TYPE ic_item_mst_rec IS RECORD
67: ( item_id ic_item_mst.item_id%TYPE
68: , inventory_item_id mtl_system_items.inventory_item_id%TYPE
69: , item_no ic_item_mst.item_no%TYPE
70: , whse_item_id ic_item_mst.whse_item_id%TYPE

Line 67: ( item_id ic_item_mst.item_id%TYPE

63:
64: /* SUBTYPE transaction_record IS ic_tran_pnd%ROWTYPE; */
65:
66: TYPE ic_item_mst_rec IS RECORD
67: ( item_id ic_item_mst.item_id%TYPE
68: , inventory_item_id mtl_system_items.inventory_item_id%TYPE
69: , item_no ic_item_mst.item_no%TYPE
70: , whse_item_id ic_item_mst.whse_item_id%TYPE
71: , item_um ic_item_mst.item_um%TYPE

Line 69: , item_no ic_item_mst.item_no%TYPE

65:
66: TYPE ic_item_mst_rec IS RECORD
67: ( item_id ic_item_mst.item_id%TYPE
68: , inventory_item_id mtl_system_items.inventory_item_id%TYPE
69: , item_no ic_item_mst.item_no%TYPE
70: , whse_item_id ic_item_mst.whse_item_id%TYPE
71: , item_um ic_item_mst.item_um%TYPE
72: , item_um2 ic_item_mst.item_um2%TYPE
73: , dualum_ind ic_item_mst.dualum_ind%TYPE

Line 70: , whse_item_id ic_item_mst.whse_item_id%TYPE

66: TYPE ic_item_mst_rec IS RECORD
67: ( item_id ic_item_mst.item_id%TYPE
68: , inventory_item_id mtl_system_items.inventory_item_id%TYPE
69: , item_no ic_item_mst.item_no%TYPE
70: , whse_item_id ic_item_mst.whse_item_id%TYPE
71: , item_um ic_item_mst.item_um%TYPE
72: , item_um2 ic_item_mst.item_um2%TYPE
73: , dualum_ind ic_item_mst.dualum_ind%TYPE
74: , alloc_class ic_item_mst.alloc_class%TYPE

Line 71: , item_um ic_item_mst.item_um%TYPE

67: ( item_id ic_item_mst.item_id%TYPE
68: , inventory_item_id mtl_system_items.inventory_item_id%TYPE
69: , item_no ic_item_mst.item_no%TYPE
70: , whse_item_id ic_item_mst.whse_item_id%TYPE
71: , item_um ic_item_mst.item_um%TYPE
72: , item_um2 ic_item_mst.item_um2%TYPE
73: , dualum_ind ic_item_mst.dualum_ind%TYPE
74: , alloc_class ic_item_mst.alloc_class%TYPE
75: , noninv_ind ic_item_mst.noninv_ind%TYPE

Line 72: , item_um2 ic_item_mst.item_um2%TYPE

68: , inventory_item_id mtl_system_items.inventory_item_id%TYPE
69: , item_no ic_item_mst.item_no%TYPE
70: , whse_item_id ic_item_mst.whse_item_id%TYPE
71: , item_um ic_item_mst.item_um%TYPE
72: , item_um2 ic_item_mst.item_um2%TYPE
73: , dualum_ind ic_item_mst.dualum_ind%TYPE
74: , alloc_class ic_item_mst.alloc_class%TYPE
75: , noninv_ind ic_item_mst.noninv_ind%TYPE
76: , deviation_lo ic_item_mst.deviation_lo%TYPE

Line 73: , dualum_ind ic_item_mst.dualum_ind%TYPE

69: , item_no ic_item_mst.item_no%TYPE
70: , whse_item_id ic_item_mst.whse_item_id%TYPE
71: , item_um ic_item_mst.item_um%TYPE
72: , item_um2 ic_item_mst.item_um2%TYPE
73: , dualum_ind ic_item_mst.dualum_ind%TYPE
74: , alloc_class ic_item_mst.alloc_class%TYPE
75: , noninv_ind ic_item_mst.noninv_ind%TYPE
76: , deviation_lo ic_item_mst.deviation_lo%TYPE
77: , deviation_hi ic_item_mst.deviation_lo%TYPE

Line 74: , alloc_class ic_item_mst.alloc_class%TYPE

70: , whse_item_id ic_item_mst.whse_item_id%TYPE
71: , item_um ic_item_mst.item_um%TYPE
72: , item_um2 ic_item_mst.item_um2%TYPE
73: , dualum_ind ic_item_mst.dualum_ind%TYPE
74: , alloc_class ic_item_mst.alloc_class%TYPE
75: , noninv_ind ic_item_mst.noninv_ind%TYPE
76: , deviation_lo ic_item_mst.deviation_lo%TYPE
77: , deviation_hi ic_item_mst.deviation_lo%TYPE
78: , grade_ctl ic_item_mst.grade_ctl%TYPE

Line 75: , noninv_ind ic_item_mst.noninv_ind%TYPE

71: , item_um ic_item_mst.item_um%TYPE
72: , item_um2 ic_item_mst.item_um2%TYPE
73: , dualum_ind ic_item_mst.dualum_ind%TYPE
74: , alloc_class ic_item_mst.alloc_class%TYPE
75: , noninv_ind ic_item_mst.noninv_ind%TYPE
76: , deviation_lo ic_item_mst.deviation_lo%TYPE
77: , deviation_hi ic_item_mst.deviation_lo%TYPE
78: , grade_ctl ic_item_mst.grade_ctl%TYPE
79: , inactive_ind ic_item_mst.inactive_ind%TYPE

Line 76: , deviation_lo ic_item_mst.deviation_lo%TYPE

72: , item_um2 ic_item_mst.item_um2%TYPE
73: , dualum_ind ic_item_mst.dualum_ind%TYPE
74: , alloc_class ic_item_mst.alloc_class%TYPE
75: , noninv_ind ic_item_mst.noninv_ind%TYPE
76: , deviation_lo ic_item_mst.deviation_lo%TYPE
77: , deviation_hi ic_item_mst.deviation_lo%TYPE
78: , grade_ctl ic_item_mst.grade_ctl%TYPE
79: , inactive_ind ic_item_mst.inactive_ind%TYPE
80: , lot_ctl ic_item_mst.lot_ctl%TYPE

Line 77: , deviation_hi ic_item_mst.deviation_lo%TYPE

73: , dualum_ind ic_item_mst.dualum_ind%TYPE
74: , alloc_class ic_item_mst.alloc_class%TYPE
75: , noninv_ind ic_item_mst.noninv_ind%TYPE
76: , deviation_lo ic_item_mst.deviation_lo%TYPE
77: , deviation_hi ic_item_mst.deviation_lo%TYPE
78: , grade_ctl ic_item_mst.grade_ctl%TYPE
79: , inactive_ind ic_item_mst.inactive_ind%TYPE
80: , lot_ctl ic_item_mst.lot_ctl%TYPE
81: , lot_indivisible ic_item_mst.lot_indivisible%TYPE

Line 78: , grade_ctl ic_item_mst.grade_ctl%TYPE

74: , alloc_class ic_item_mst.alloc_class%TYPE
75: , noninv_ind ic_item_mst.noninv_ind%TYPE
76: , deviation_lo ic_item_mst.deviation_lo%TYPE
77: , deviation_hi ic_item_mst.deviation_lo%TYPE
78: , grade_ctl ic_item_mst.grade_ctl%TYPE
79: , inactive_ind ic_item_mst.inactive_ind%TYPE
80: , lot_ctl ic_item_mst.lot_ctl%TYPE
81: , lot_indivisible ic_item_mst.lot_indivisible%TYPE
82: , loct_ctl ic_item_mst.loct_ctl%TYPE);

Line 79: , inactive_ind ic_item_mst.inactive_ind%TYPE

75: , noninv_ind ic_item_mst.noninv_ind%TYPE
76: , deviation_lo ic_item_mst.deviation_lo%TYPE
77: , deviation_hi ic_item_mst.deviation_lo%TYPE
78: , grade_ctl ic_item_mst.grade_ctl%TYPE
79: , inactive_ind ic_item_mst.inactive_ind%TYPE
80: , lot_ctl ic_item_mst.lot_ctl%TYPE
81: , lot_indivisible ic_item_mst.lot_indivisible%TYPE
82: , loct_ctl ic_item_mst.loct_ctl%TYPE);
83:

Line 80: , lot_ctl ic_item_mst.lot_ctl%TYPE

76: , deviation_lo ic_item_mst.deviation_lo%TYPE
77: , deviation_hi ic_item_mst.deviation_lo%TYPE
78: , grade_ctl ic_item_mst.grade_ctl%TYPE
79: , inactive_ind ic_item_mst.inactive_ind%TYPE
80: , lot_ctl ic_item_mst.lot_ctl%TYPE
81: , lot_indivisible ic_item_mst.lot_indivisible%TYPE
82: , loct_ctl ic_item_mst.loct_ctl%TYPE);
83:
84:

Line 81: , lot_indivisible ic_item_mst.lot_indivisible%TYPE

77: , deviation_hi ic_item_mst.deviation_lo%TYPE
78: , grade_ctl ic_item_mst.grade_ctl%TYPE
79: , inactive_ind ic_item_mst.inactive_ind%TYPE
80: , lot_ctl ic_item_mst.lot_ctl%TYPE
81: , lot_indivisible ic_item_mst.lot_indivisible%TYPE
82: , loct_ctl ic_item_mst.loct_ctl%TYPE);
83:
84:
85: TYPE l_ic_tran_rec_tbl IS TABLE OF GMI_TRANS_ENGINE_PUB.ictran_rec

Line 82: , loct_ctl ic_item_mst.loct_ctl%TYPE);

78: , grade_ctl ic_item_mst.grade_ctl%TYPE
79: , inactive_ind ic_item_mst.inactive_ind%TYPE
80: , lot_ctl ic_item_mst.lot_ctl%TYPE
81: , lot_indivisible ic_item_mst.lot_indivisible%TYPE
82: , loct_ctl ic_item_mst.loct_ctl%TYPE);
83:
84:
85: TYPE l_ic_tran_rec_tbl IS TABLE OF GMI_TRANS_ENGINE_PUB.ictran_rec
86: INDEX BY BINARY_INTEGER;

Line 103: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec

99: PROCEDURE Validation_for_Query
100: ( p_query_input IN inv_reservation_global.mtl_reservation_rec_type
101: , x_opm_um OUT NOCOPY VARCHAR2
102: , x_apps_um OUT NOCOPY VARCHAR2
103: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
104: , x_return_status OUT NOCOPY VARCHAR2
105: , x_msg_count OUT NOCOPY NUMBER
106: , x_msg_data OUT NOCOPY VARCHAR2
107: , x_error_code OUT NOCOPY NUMBER /* Bug 2168710 - Added parameter */

Line 113: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec

109:
110: PROCEDURE Validation_before_Allocate
111: ( p_mtl_rsv_rec IN INV_Reservation_Global.mtl_reservation_rec_type
112: , x_allocation_rec OUT NOCOPY GMI_Auto_Allocate_PUB.gmi_allocation_rec
113: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
114: , x_orgn_code OUT NOCOPY VARCHAR2
115: , x_return_status OUT NOCOPY VARCHAR2
116: , x_msg_count OUT NOCOPY NUMBER
117: , x_msg_data OUT NOCOPY VARCHAR2

Line 129: , p_ic_item_mst_rec IN GMI_Reservation_Util.ic_item_mst_rec

125: );
126:
127: PROCEDURE Create_Default_Lot
128: ( p_allocation_rec IN GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec
129: , p_ic_item_mst_rec IN GMI_Reservation_Util.ic_item_mst_rec
130: , p_orgn_code IN VARCHAR2
131: , p_trans_id IN NUMBER DEFAULT NULL
132: , x_return_status OUT NOCOPY VARCHAR2
133: , x_msg_count OUT NOCOPY NUMBER

Line 172: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec

168:
169: PROCEDURE Get_OPM_item_from_Apps
170: ( p_organization_id IN NUMBER
171: , p_inventory_item_id IN NUMBER
172: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER
175: , x_msg_data OUT NOCOPY VARCHAR2
176: );