APPS.GMIVDX dependencies on GMI_DISCRETE_TRANSFER_LOTS

Line 154: ,opm_lot_id gmi_discrete_transfer_lots.opm_lot_id%TYPE

150:
151: TYPE lot_type IS RECORD
152: (
153: line_no gmi_discrete_transfer_lines.line_no%TYPE
154: ,opm_lot_id gmi_discrete_transfer_lots.opm_lot_id%TYPE
155: ,opm_lot_expiration_date gmi_discrete_transfer_lots.opm_lot_expiration_date%TYPE
156: ,opm_lot_status gmi_discrete_transfer_lots.opm_lot_status%TYPE
157: ,opm_grade gmi_discrete_transfer_lots.opm_grade%TYPE
158: ,odm_lot_number VARCHAR2(80)

Line 155: ,opm_lot_expiration_date gmi_discrete_transfer_lots.opm_lot_expiration_date%TYPE

151: TYPE lot_type IS RECORD
152: (
153: line_no gmi_discrete_transfer_lines.line_no%TYPE
154: ,opm_lot_id gmi_discrete_transfer_lots.opm_lot_id%TYPE
155: ,opm_lot_expiration_date gmi_discrete_transfer_lots.opm_lot_expiration_date%TYPE
156: ,opm_lot_status gmi_discrete_transfer_lots.opm_lot_status%TYPE
157: ,opm_grade gmi_discrete_transfer_lots.opm_grade%TYPE
158: ,odm_lot_number VARCHAR2(80)
159: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE

Line 156: ,opm_lot_status gmi_discrete_transfer_lots.opm_lot_status%TYPE

152: (
153: line_no gmi_discrete_transfer_lines.line_no%TYPE
154: ,opm_lot_id gmi_discrete_transfer_lots.opm_lot_id%TYPE
155: ,opm_lot_expiration_date gmi_discrete_transfer_lots.opm_lot_expiration_date%TYPE
156: ,opm_lot_status gmi_discrete_transfer_lots.opm_lot_status%TYPE
157: ,opm_grade gmi_discrete_transfer_lots.opm_grade%TYPE
158: ,odm_lot_number VARCHAR2(80)
159: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
160: ,quantity gmi_discrete_transfer_lots.quantity%TYPE

Line 157: ,opm_grade gmi_discrete_transfer_lots.opm_grade%TYPE

153: line_no gmi_discrete_transfer_lines.line_no%TYPE
154: ,opm_lot_id gmi_discrete_transfer_lots.opm_lot_id%TYPE
155: ,opm_lot_expiration_date gmi_discrete_transfer_lots.opm_lot_expiration_date%TYPE
156: ,opm_lot_status gmi_discrete_transfer_lots.opm_lot_status%TYPE
157: ,opm_grade gmi_discrete_transfer_lots.opm_grade%TYPE
158: ,odm_lot_number VARCHAR2(80)
159: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
160: ,quantity gmi_discrete_transfer_lots.quantity%TYPE
161: ,quantity2 gmi_discrete_transfer_lots.quantity2%TYPE

Line 160: ,quantity gmi_discrete_transfer_lots.quantity%TYPE

156: ,opm_lot_status gmi_discrete_transfer_lots.opm_lot_status%TYPE
157: ,opm_grade gmi_discrete_transfer_lots.opm_grade%TYPE
158: ,odm_lot_number VARCHAR2(80)
159: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
160: ,quantity gmi_discrete_transfer_lots.quantity%TYPE
161: ,quantity2 gmi_discrete_transfer_lots.quantity2%TYPE
162: ,opm_primary_quantity gmi_discrete_transfer_lots.opm_primary_quantity%TYPE
163: ,odm_primary_quantity gmi_discrete_transfer_lots.odm_primary_quantity%TYPE
164: /* *********************************************************************** */

Line 161: ,quantity2 gmi_discrete_transfer_lots.quantity2%TYPE

157: ,opm_grade gmi_discrete_transfer_lots.opm_grade%TYPE
158: ,odm_lot_number VARCHAR2(80)
159: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
160: ,quantity gmi_discrete_transfer_lots.quantity%TYPE
161: ,quantity2 gmi_discrete_transfer_lots.quantity2%TYPE
162: ,opm_primary_quantity gmi_discrete_transfer_lots.opm_primary_quantity%TYPE
163: ,odm_primary_quantity gmi_discrete_transfer_lots.odm_primary_quantity%TYPE
164: /* *********************************************************************** */
165: ,opm_lot_no ic_lots_mst.lot_no%TYPE

Line 162: ,opm_primary_quantity gmi_discrete_transfer_lots.opm_primary_quantity%TYPE

158: ,odm_lot_number VARCHAR2(80)
159: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
160: ,quantity gmi_discrete_transfer_lots.quantity%TYPE
161: ,quantity2 gmi_discrete_transfer_lots.quantity2%TYPE
162: ,opm_primary_quantity gmi_discrete_transfer_lots.opm_primary_quantity%TYPE
163: ,odm_primary_quantity gmi_discrete_transfer_lots.odm_primary_quantity%TYPE
164: /* *********************************************************************** */
165: ,opm_lot_no ic_lots_mst.lot_no%TYPE
166: ,opm_sublot_no ic_lots_mst.sublot_no%TYPE

Line 163: ,odm_primary_quantity gmi_discrete_transfer_lots.odm_primary_quantity%TYPE

159: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
160: ,quantity gmi_discrete_transfer_lots.quantity%TYPE
161: ,quantity2 gmi_discrete_transfer_lots.quantity2%TYPE
162: ,opm_primary_quantity gmi_discrete_transfer_lots.opm_primary_quantity%TYPE
163: ,odm_primary_quantity gmi_discrete_transfer_lots.odm_primary_quantity%TYPE
164: /* *********************************************************************** */
165: ,opm_lot_no ic_lots_mst.lot_no%TYPE
166: ,opm_sublot_no ic_lots_mst.sublot_no%TYPE
167: );

Line 175: TYPE lot_row_tbl IS TABLE OF gmi_discrete_transfer_lots%ROWTYPE INDEX BY BINARY_INTEGER;

171: TYPE lot_type_tbl IS TABLE OF lot_type INDEX BY BINARY_INTEGER;
172:
173: TYPE line_row_tbl IS TABLE OF gmi_discrete_transfer_lines%ROWTYPE INDEX BY BINARY_INTEGER;
174:
175: TYPE lot_row_tbl IS TABLE OF gmi_discrete_transfer_lots%ROWTYPE INDEX BY BINARY_INTEGER;
176:
177: /* PROCEDURE Declaration */
178:
179: PROCEDURE Create_transfer_pvt