75: );
76:
77: TYPE line_type IS RECORD
78: (
79: line_no gmi_discrete_transfer_lines.line_no%TYPE
80: ,opm_item_id gmi_discrete_transfer_lines.opm_item_id%TYPE
81: ,opm_whse_code gmi_discrete_transfer_lines.opm_whse_code%TYPE
82: ,opm_location gmi_discrete_transfer_lines.opm_location%TYPE
83: ,opm_lot_id gmi_discrete_transfer_lines.opm_lot_id%TYPE
76:
77: TYPE line_type IS RECORD
78: (
79: line_no gmi_discrete_transfer_lines.line_no%TYPE
80: ,opm_item_id gmi_discrete_transfer_lines.opm_item_id%TYPE
81: ,opm_whse_code gmi_discrete_transfer_lines.opm_whse_code%TYPE
82: ,opm_location gmi_discrete_transfer_lines.opm_location%TYPE
83: ,opm_lot_id gmi_discrete_transfer_lines.opm_lot_id%TYPE
84: ,opm_lot_expiration_date gmi_discrete_transfer_lines.opm_lot_expiration_date%TYPE
77: TYPE line_type IS RECORD
78: (
79: line_no gmi_discrete_transfer_lines.line_no%TYPE
80: ,opm_item_id gmi_discrete_transfer_lines.opm_item_id%TYPE
81: ,opm_whse_code gmi_discrete_transfer_lines.opm_whse_code%TYPE
82: ,opm_location gmi_discrete_transfer_lines.opm_location%TYPE
83: ,opm_lot_id gmi_discrete_transfer_lines.opm_lot_id%TYPE
84: ,opm_lot_expiration_date gmi_discrete_transfer_lines.opm_lot_expiration_date%TYPE
85: ,opm_lot_status gmi_discrete_transfer_lines.opm_lot_status%TYPE
78: (
79: line_no gmi_discrete_transfer_lines.line_no%TYPE
80: ,opm_item_id gmi_discrete_transfer_lines.opm_item_id%TYPE
81: ,opm_whse_code gmi_discrete_transfer_lines.opm_whse_code%TYPE
82: ,opm_location gmi_discrete_transfer_lines.opm_location%TYPE
83: ,opm_lot_id gmi_discrete_transfer_lines.opm_lot_id%TYPE
84: ,opm_lot_expiration_date gmi_discrete_transfer_lines.opm_lot_expiration_date%TYPE
85: ,opm_lot_status gmi_discrete_transfer_lines.opm_lot_status%TYPE
86: ,opm_grade gmi_discrete_transfer_lines.opm_grade%TYPE
79: line_no gmi_discrete_transfer_lines.line_no%TYPE
80: ,opm_item_id gmi_discrete_transfer_lines.opm_item_id%TYPE
81: ,opm_whse_code gmi_discrete_transfer_lines.opm_whse_code%TYPE
82: ,opm_location gmi_discrete_transfer_lines.opm_location%TYPE
83: ,opm_lot_id gmi_discrete_transfer_lines.opm_lot_id%TYPE
84: ,opm_lot_expiration_date gmi_discrete_transfer_lines.opm_lot_expiration_date%TYPE
85: ,opm_lot_status gmi_discrete_transfer_lines.opm_lot_status%TYPE
86: ,opm_grade gmi_discrete_transfer_lines.opm_grade%TYPE
87: ,opm_charge_acct_id gmi_discrete_transfer_lines.opm_charge_acct_id%TYPE
80: ,opm_item_id gmi_discrete_transfer_lines.opm_item_id%TYPE
81: ,opm_whse_code gmi_discrete_transfer_lines.opm_whse_code%TYPE
82: ,opm_location gmi_discrete_transfer_lines.opm_location%TYPE
83: ,opm_lot_id gmi_discrete_transfer_lines.opm_lot_id%TYPE
84: ,opm_lot_expiration_date gmi_discrete_transfer_lines.opm_lot_expiration_date%TYPE
85: ,opm_lot_status gmi_discrete_transfer_lines.opm_lot_status%TYPE
86: ,opm_grade gmi_discrete_transfer_lines.opm_grade%TYPE
87: ,opm_charge_acct_id gmi_discrete_transfer_lines.opm_charge_acct_id%TYPE
88: ,opm_charge_au_id gmi_discrete_transfer_lines.opm_charge_au_id%TYPE
81: ,opm_whse_code gmi_discrete_transfer_lines.opm_whse_code%TYPE
82: ,opm_location gmi_discrete_transfer_lines.opm_location%TYPE
83: ,opm_lot_id gmi_discrete_transfer_lines.opm_lot_id%TYPE
84: ,opm_lot_expiration_date gmi_discrete_transfer_lines.opm_lot_expiration_date%TYPE
85: ,opm_lot_status gmi_discrete_transfer_lines.opm_lot_status%TYPE
86: ,opm_grade gmi_discrete_transfer_lines.opm_grade%TYPE
87: ,opm_charge_acct_id gmi_discrete_transfer_lines.opm_charge_acct_id%TYPE
88: ,opm_charge_au_id gmi_discrete_transfer_lines.opm_charge_au_id%TYPE
89: ,opm_reason_code gmi_discrete_transfer_lines.opm_reason_code%TYPE
82: ,opm_location gmi_discrete_transfer_lines.opm_location%TYPE
83: ,opm_lot_id gmi_discrete_transfer_lines.opm_lot_id%TYPE
84: ,opm_lot_expiration_date gmi_discrete_transfer_lines.opm_lot_expiration_date%TYPE
85: ,opm_lot_status gmi_discrete_transfer_lines.opm_lot_status%TYPE
86: ,opm_grade gmi_discrete_transfer_lines.opm_grade%TYPE
87: ,opm_charge_acct_id gmi_discrete_transfer_lines.opm_charge_acct_id%TYPE
88: ,opm_charge_au_id gmi_discrete_transfer_lines.opm_charge_au_id%TYPE
89: ,opm_reason_code gmi_discrete_transfer_lines.opm_reason_code%TYPE
90: ,odm_inv_organization_id gmi_discrete_transfer_lines.odm_inv_organization_id%TYPE
83: ,opm_lot_id gmi_discrete_transfer_lines.opm_lot_id%TYPE
84: ,opm_lot_expiration_date gmi_discrete_transfer_lines.opm_lot_expiration_date%TYPE
85: ,opm_lot_status gmi_discrete_transfer_lines.opm_lot_status%TYPE
86: ,opm_grade gmi_discrete_transfer_lines.opm_grade%TYPE
87: ,opm_charge_acct_id gmi_discrete_transfer_lines.opm_charge_acct_id%TYPE
88: ,opm_charge_au_id gmi_discrete_transfer_lines.opm_charge_au_id%TYPE
89: ,opm_reason_code gmi_discrete_transfer_lines.opm_reason_code%TYPE
90: ,odm_inv_organization_id gmi_discrete_transfer_lines.odm_inv_organization_id%TYPE
91: ,odm_item_id gmi_discrete_transfer_lines.odm_item_id%TYPE
84: ,opm_lot_expiration_date gmi_discrete_transfer_lines.opm_lot_expiration_date%TYPE
85: ,opm_lot_status gmi_discrete_transfer_lines.opm_lot_status%TYPE
86: ,opm_grade gmi_discrete_transfer_lines.opm_grade%TYPE
87: ,opm_charge_acct_id gmi_discrete_transfer_lines.opm_charge_acct_id%TYPE
88: ,opm_charge_au_id gmi_discrete_transfer_lines.opm_charge_au_id%TYPE
89: ,opm_reason_code gmi_discrete_transfer_lines.opm_reason_code%TYPE
90: ,odm_inv_organization_id gmi_discrete_transfer_lines.odm_inv_organization_id%TYPE
91: ,odm_item_id gmi_discrete_transfer_lines.odm_item_id%TYPE
92: ,odm_item_revision gmi_discrete_transfer_lines.odm_item_revision%TYPE
85: ,opm_lot_status gmi_discrete_transfer_lines.opm_lot_status%TYPE
86: ,opm_grade gmi_discrete_transfer_lines.opm_grade%TYPE
87: ,opm_charge_acct_id gmi_discrete_transfer_lines.opm_charge_acct_id%TYPE
88: ,opm_charge_au_id gmi_discrete_transfer_lines.opm_charge_au_id%TYPE
89: ,opm_reason_code gmi_discrete_transfer_lines.opm_reason_code%TYPE
90: ,odm_inv_organization_id gmi_discrete_transfer_lines.odm_inv_organization_id%TYPE
91: ,odm_item_id gmi_discrete_transfer_lines.odm_item_id%TYPE
92: ,odm_item_revision gmi_discrete_transfer_lines.odm_item_revision%TYPE
93: ,odm_subinventory gmi_discrete_transfer_lines.odm_subinventory%TYPE
86: ,opm_grade gmi_discrete_transfer_lines.opm_grade%TYPE
87: ,opm_charge_acct_id gmi_discrete_transfer_lines.opm_charge_acct_id%TYPE
88: ,opm_charge_au_id gmi_discrete_transfer_lines.opm_charge_au_id%TYPE
89: ,opm_reason_code gmi_discrete_transfer_lines.opm_reason_code%TYPE
90: ,odm_inv_organization_id gmi_discrete_transfer_lines.odm_inv_organization_id%TYPE
91: ,odm_item_id gmi_discrete_transfer_lines.odm_item_id%TYPE
92: ,odm_item_revision gmi_discrete_transfer_lines.odm_item_revision%TYPE
93: ,odm_subinventory gmi_discrete_transfer_lines.odm_subinventory%TYPE
94: ,odm_locator_id gmi_discrete_transfer_lines.odm_locator_id%TYPE
87: ,opm_charge_acct_id gmi_discrete_transfer_lines.opm_charge_acct_id%TYPE
88: ,opm_charge_au_id gmi_discrete_transfer_lines.opm_charge_au_id%TYPE
89: ,opm_reason_code gmi_discrete_transfer_lines.opm_reason_code%TYPE
90: ,odm_inv_organization_id gmi_discrete_transfer_lines.odm_inv_organization_id%TYPE
91: ,odm_item_id gmi_discrete_transfer_lines.odm_item_id%TYPE
92: ,odm_item_revision gmi_discrete_transfer_lines.odm_item_revision%TYPE
93: ,odm_subinventory gmi_discrete_transfer_lines.odm_subinventory%TYPE
94: ,odm_locator_id gmi_discrete_transfer_lines.odm_locator_id%TYPE
95: ,odm_lot_number VARCHAR2(80)
88: ,opm_charge_au_id gmi_discrete_transfer_lines.opm_charge_au_id%TYPE
89: ,opm_reason_code gmi_discrete_transfer_lines.opm_reason_code%TYPE
90: ,odm_inv_organization_id gmi_discrete_transfer_lines.odm_inv_organization_id%TYPE
91: ,odm_item_id gmi_discrete_transfer_lines.odm_item_id%TYPE
92: ,odm_item_revision gmi_discrete_transfer_lines.odm_item_revision%TYPE
93: ,odm_subinventory gmi_discrete_transfer_lines.odm_subinventory%TYPE
94: ,odm_locator_id gmi_discrete_transfer_lines.odm_locator_id%TYPE
95: ,odm_lot_number VARCHAR2(80)
96: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
89: ,opm_reason_code gmi_discrete_transfer_lines.opm_reason_code%TYPE
90: ,odm_inv_organization_id gmi_discrete_transfer_lines.odm_inv_organization_id%TYPE
91: ,odm_item_id gmi_discrete_transfer_lines.odm_item_id%TYPE
92: ,odm_item_revision gmi_discrete_transfer_lines.odm_item_revision%TYPE
93: ,odm_subinventory gmi_discrete_transfer_lines.odm_subinventory%TYPE
94: ,odm_locator_id gmi_discrete_transfer_lines.odm_locator_id%TYPE
95: ,odm_lot_number VARCHAR2(80)
96: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
97: ,odm_charge_account_id gmi_discrete_transfer_lines.odm_charge_account_id%TYPE
90: ,odm_inv_organization_id gmi_discrete_transfer_lines.odm_inv_organization_id%TYPE
91: ,odm_item_id gmi_discrete_transfer_lines.odm_item_id%TYPE
92: ,odm_item_revision gmi_discrete_transfer_lines.odm_item_revision%TYPE
93: ,odm_subinventory gmi_discrete_transfer_lines.odm_subinventory%TYPE
94: ,odm_locator_id gmi_discrete_transfer_lines.odm_locator_id%TYPE
95: ,odm_lot_number VARCHAR2(80)
96: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
97: ,odm_charge_account_id gmi_discrete_transfer_lines.odm_charge_account_id%TYPE
98: ,odm_period_id gmi_discrete_transfer_lines.odm_period_id%TYPE
92: ,odm_item_revision gmi_discrete_transfer_lines.odm_item_revision%TYPE
93: ,odm_subinventory gmi_discrete_transfer_lines.odm_subinventory%TYPE
94: ,odm_locator_id gmi_discrete_transfer_lines.odm_locator_id%TYPE
95: ,odm_lot_number VARCHAR2(80)
96: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
97: ,odm_charge_account_id gmi_discrete_transfer_lines.odm_charge_account_id%TYPE
98: ,odm_period_id gmi_discrete_transfer_lines.odm_period_id%TYPE
99: ,odm_unit_cost gmi_discrete_transfer_lines.odm_unit_cost%TYPE
100: ,odm_reason_id gmi_discrete_transfer_lines.odm_reason_id%TYPE
93: ,odm_subinventory gmi_discrete_transfer_lines.odm_subinventory%TYPE
94: ,odm_locator_id gmi_discrete_transfer_lines.odm_locator_id%TYPE
95: ,odm_lot_number VARCHAR2(80)
96: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
97: ,odm_charge_account_id gmi_discrete_transfer_lines.odm_charge_account_id%TYPE
98: ,odm_period_id gmi_discrete_transfer_lines.odm_period_id%TYPE
99: ,odm_unit_cost gmi_discrete_transfer_lines.odm_unit_cost%TYPE
100: ,odm_reason_id gmi_discrete_transfer_lines.odm_reason_id%TYPE
101: ,quantity gmi_discrete_transfer_lines.quantity%TYPE
94: ,odm_locator_id gmi_discrete_transfer_lines.odm_locator_id%TYPE
95: ,odm_lot_number VARCHAR2(80)
96: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
97: ,odm_charge_account_id gmi_discrete_transfer_lines.odm_charge_account_id%TYPE
98: ,odm_period_id gmi_discrete_transfer_lines.odm_period_id%TYPE
99: ,odm_unit_cost gmi_discrete_transfer_lines.odm_unit_cost%TYPE
100: ,odm_reason_id gmi_discrete_transfer_lines.odm_reason_id%TYPE
101: ,quantity gmi_discrete_transfer_lines.quantity%TYPE
102: ,quantity_um gmi_discrete_transfer_lines.quantity_um%TYPE
95: ,odm_lot_number VARCHAR2(80)
96: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
97: ,odm_charge_account_id gmi_discrete_transfer_lines.odm_charge_account_id%TYPE
98: ,odm_period_id gmi_discrete_transfer_lines.odm_period_id%TYPE
99: ,odm_unit_cost gmi_discrete_transfer_lines.odm_unit_cost%TYPE
100: ,odm_reason_id gmi_discrete_transfer_lines.odm_reason_id%TYPE
101: ,quantity gmi_discrete_transfer_lines.quantity%TYPE
102: ,quantity_um gmi_discrete_transfer_lines.quantity_um%TYPE
103: ,quantity2 gmi_discrete_transfer_lines.quantity2%TYPE
96: ,odm_lot_expiration_date gmi_discrete_transfer_lines.odm_lot_expiration_date%TYPE
97: ,odm_charge_account_id gmi_discrete_transfer_lines.odm_charge_account_id%TYPE
98: ,odm_period_id gmi_discrete_transfer_lines.odm_period_id%TYPE
99: ,odm_unit_cost gmi_discrete_transfer_lines.odm_unit_cost%TYPE
100: ,odm_reason_id gmi_discrete_transfer_lines.odm_reason_id%TYPE
101: ,quantity gmi_discrete_transfer_lines.quantity%TYPE
102: ,quantity_um gmi_discrete_transfer_lines.quantity_um%TYPE
103: ,quantity2 gmi_discrete_transfer_lines.quantity2%TYPE
104: ,opm_primary_quantity gmi_discrete_transfer_lines.opm_primary_quantity%TYPE
97: ,odm_charge_account_id gmi_discrete_transfer_lines.odm_charge_account_id%TYPE
98: ,odm_period_id gmi_discrete_transfer_lines.odm_period_id%TYPE
99: ,odm_unit_cost gmi_discrete_transfer_lines.odm_unit_cost%TYPE
100: ,odm_reason_id gmi_discrete_transfer_lines.odm_reason_id%TYPE
101: ,quantity gmi_discrete_transfer_lines.quantity%TYPE
102: ,quantity_um gmi_discrete_transfer_lines.quantity_um%TYPE
103: ,quantity2 gmi_discrete_transfer_lines.quantity2%TYPE
104: ,opm_primary_quantity gmi_discrete_transfer_lines.opm_primary_quantity%TYPE
105: ,odm_primary_quantity gmi_discrete_transfer_lines.odm_primary_quantity%TYPE
98: ,odm_period_id gmi_discrete_transfer_lines.odm_period_id%TYPE
99: ,odm_unit_cost gmi_discrete_transfer_lines.odm_unit_cost%TYPE
100: ,odm_reason_id gmi_discrete_transfer_lines.odm_reason_id%TYPE
101: ,quantity gmi_discrete_transfer_lines.quantity%TYPE
102: ,quantity_um gmi_discrete_transfer_lines.quantity_um%TYPE
103: ,quantity2 gmi_discrete_transfer_lines.quantity2%TYPE
104: ,opm_primary_quantity gmi_discrete_transfer_lines.opm_primary_quantity%TYPE
105: ,odm_primary_quantity gmi_discrete_transfer_lines.odm_primary_quantity%TYPE
106: ,lot_level gmi_discrete_transfer_lines.lot_level%TYPE
99: ,odm_unit_cost gmi_discrete_transfer_lines.odm_unit_cost%TYPE
100: ,odm_reason_id gmi_discrete_transfer_lines.odm_reason_id%TYPE
101: ,quantity gmi_discrete_transfer_lines.quantity%TYPE
102: ,quantity_um gmi_discrete_transfer_lines.quantity_um%TYPE
103: ,quantity2 gmi_discrete_transfer_lines.quantity2%TYPE
104: ,opm_primary_quantity gmi_discrete_transfer_lines.opm_primary_quantity%TYPE
105: ,odm_primary_quantity gmi_discrete_transfer_lines.odm_primary_quantity%TYPE
106: ,lot_level gmi_discrete_transfer_lines.lot_level%TYPE
107: ,attribute_category gmi_discrete_transfer_lines.attribute_category%TYPE
100: ,odm_reason_id gmi_discrete_transfer_lines.odm_reason_id%TYPE
101: ,quantity gmi_discrete_transfer_lines.quantity%TYPE
102: ,quantity_um gmi_discrete_transfer_lines.quantity_um%TYPE
103: ,quantity2 gmi_discrete_transfer_lines.quantity2%TYPE
104: ,opm_primary_quantity gmi_discrete_transfer_lines.opm_primary_quantity%TYPE
105: ,odm_primary_quantity gmi_discrete_transfer_lines.odm_primary_quantity%TYPE
106: ,lot_level gmi_discrete_transfer_lines.lot_level%TYPE
107: ,attribute_category gmi_discrete_transfer_lines.attribute_category%TYPE
108: ,attribute1 gmi_discrete_transfer_lines.attribute1%TYPE
101: ,quantity gmi_discrete_transfer_lines.quantity%TYPE
102: ,quantity_um gmi_discrete_transfer_lines.quantity_um%TYPE
103: ,quantity2 gmi_discrete_transfer_lines.quantity2%TYPE
104: ,opm_primary_quantity gmi_discrete_transfer_lines.opm_primary_quantity%TYPE
105: ,odm_primary_quantity gmi_discrete_transfer_lines.odm_primary_quantity%TYPE
106: ,lot_level gmi_discrete_transfer_lines.lot_level%TYPE
107: ,attribute_category gmi_discrete_transfer_lines.attribute_category%TYPE
108: ,attribute1 gmi_discrete_transfer_lines.attribute1%TYPE
109: ,attribute2 gmi_discrete_transfer_lines.attribute2%TYPE
102: ,quantity_um gmi_discrete_transfer_lines.quantity_um%TYPE
103: ,quantity2 gmi_discrete_transfer_lines.quantity2%TYPE
104: ,opm_primary_quantity gmi_discrete_transfer_lines.opm_primary_quantity%TYPE
105: ,odm_primary_quantity gmi_discrete_transfer_lines.odm_primary_quantity%TYPE
106: ,lot_level gmi_discrete_transfer_lines.lot_level%TYPE
107: ,attribute_category gmi_discrete_transfer_lines.attribute_category%TYPE
108: ,attribute1 gmi_discrete_transfer_lines.attribute1%TYPE
109: ,attribute2 gmi_discrete_transfer_lines.attribute2%TYPE
110: ,attribute3 gmi_discrete_transfer_lines.attribute3%TYPE
103: ,quantity2 gmi_discrete_transfer_lines.quantity2%TYPE
104: ,opm_primary_quantity gmi_discrete_transfer_lines.opm_primary_quantity%TYPE
105: ,odm_primary_quantity gmi_discrete_transfer_lines.odm_primary_quantity%TYPE
106: ,lot_level gmi_discrete_transfer_lines.lot_level%TYPE
107: ,attribute_category gmi_discrete_transfer_lines.attribute_category%TYPE
108: ,attribute1 gmi_discrete_transfer_lines.attribute1%TYPE
109: ,attribute2 gmi_discrete_transfer_lines.attribute2%TYPE
110: ,attribute3 gmi_discrete_transfer_lines.attribute3%TYPE
111: ,attribute4 gmi_discrete_transfer_lines.attribute4%TYPE
104: ,opm_primary_quantity gmi_discrete_transfer_lines.opm_primary_quantity%TYPE
105: ,odm_primary_quantity gmi_discrete_transfer_lines.odm_primary_quantity%TYPE
106: ,lot_level gmi_discrete_transfer_lines.lot_level%TYPE
107: ,attribute_category gmi_discrete_transfer_lines.attribute_category%TYPE
108: ,attribute1 gmi_discrete_transfer_lines.attribute1%TYPE
109: ,attribute2 gmi_discrete_transfer_lines.attribute2%TYPE
110: ,attribute3 gmi_discrete_transfer_lines.attribute3%TYPE
111: ,attribute4 gmi_discrete_transfer_lines.attribute4%TYPE
112: ,attribute5 gmi_discrete_transfer_lines.attribute5%TYPE
105: ,odm_primary_quantity gmi_discrete_transfer_lines.odm_primary_quantity%TYPE
106: ,lot_level gmi_discrete_transfer_lines.lot_level%TYPE
107: ,attribute_category gmi_discrete_transfer_lines.attribute_category%TYPE
108: ,attribute1 gmi_discrete_transfer_lines.attribute1%TYPE
109: ,attribute2 gmi_discrete_transfer_lines.attribute2%TYPE
110: ,attribute3 gmi_discrete_transfer_lines.attribute3%TYPE
111: ,attribute4 gmi_discrete_transfer_lines.attribute4%TYPE
112: ,attribute5 gmi_discrete_transfer_lines.attribute5%TYPE
113: ,attribute6 gmi_discrete_transfer_lines.attribute6%TYPE
106: ,lot_level gmi_discrete_transfer_lines.lot_level%TYPE
107: ,attribute_category gmi_discrete_transfer_lines.attribute_category%TYPE
108: ,attribute1 gmi_discrete_transfer_lines.attribute1%TYPE
109: ,attribute2 gmi_discrete_transfer_lines.attribute2%TYPE
110: ,attribute3 gmi_discrete_transfer_lines.attribute3%TYPE
111: ,attribute4 gmi_discrete_transfer_lines.attribute4%TYPE
112: ,attribute5 gmi_discrete_transfer_lines.attribute5%TYPE
113: ,attribute6 gmi_discrete_transfer_lines.attribute6%TYPE
114: ,attribute7 gmi_discrete_transfer_lines.attribute7%TYPE
107: ,attribute_category gmi_discrete_transfer_lines.attribute_category%TYPE
108: ,attribute1 gmi_discrete_transfer_lines.attribute1%TYPE
109: ,attribute2 gmi_discrete_transfer_lines.attribute2%TYPE
110: ,attribute3 gmi_discrete_transfer_lines.attribute3%TYPE
111: ,attribute4 gmi_discrete_transfer_lines.attribute4%TYPE
112: ,attribute5 gmi_discrete_transfer_lines.attribute5%TYPE
113: ,attribute6 gmi_discrete_transfer_lines.attribute6%TYPE
114: ,attribute7 gmi_discrete_transfer_lines.attribute7%TYPE
115: ,attribute8 gmi_discrete_transfer_lines.attribute8%TYPE
108: ,attribute1 gmi_discrete_transfer_lines.attribute1%TYPE
109: ,attribute2 gmi_discrete_transfer_lines.attribute2%TYPE
110: ,attribute3 gmi_discrete_transfer_lines.attribute3%TYPE
111: ,attribute4 gmi_discrete_transfer_lines.attribute4%TYPE
112: ,attribute5 gmi_discrete_transfer_lines.attribute5%TYPE
113: ,attribute6 gmi_discrete_transfer_lines.attribute6%TYPE
114: ,attribute7 gmi_discrete_transfer_lines.attribute7%TYPE
115: ,attribute8 gmi_discrete_transfer_lines.attribute8%TYPE
116: ,attribute9 gmi_discrete_transfer_lines.attribute9%TYPE
109: ,attribute2 gmi_discrete_transfer_lines.attribute2%TYPE
110: ,attribute3 gmi_discrete_transfer_lines.attribute3%TYPE
111: ,attribute4 gmi_discrete_transfer_lines.attribute4%TYPE
112: ,attribute5 gmi_discrete_transfer_lines.attribute5%TYPE
113: ,attribute6 gmi_discrete_transfer_lines.attribute6%TYPE
114: ,attribute7 gmi_discrete_transfer_lines.attribute7%TYPE
115: ,attribute8 gmi_discrete_transfer_lines.attribute8%TYPE
116: ,attribute9 gmi_discrete_transfer_lines.attribute9%TYPE
117: ,attribute10 gmi_discrete_transfer_lines.attribute10%TYPE
110: ,attribute3 gmi_discrete_transfer_lines.attribute3%TYPE
111: ,attribute4 gmi_discrete_transfer_lines.attribute4%TYPE
112: ,attribute5 gmi_discrete_transfer_lines.attribute5%TYPE
113: ,attribute6 gmi_discrete_transfer_lines.attribute6%TYPE
114: ,attribute7 gmi_discrete_transfer_lines.attribute7%TYPE
115: ,attribute8 gmi_discrete_transfer_lines.attribute8%TYPE
116: ,attribute9 gmi_discrete_transfer_lines.attribute9%TYPE
117: ,attribute10 gmi_discrete_transfer_lines.attribute10%TYPE
118: ,attribute11 gmi_discrete_transfer_lines.attribute11%TYPE
111: ,attribute4 gmi_discrete_transfer_lines.attribute4%TYPE
112: ,attribute5 gmi_discrete_transfer_lines.attribute5%TYPE
113: ,attribute6 gmi_discrete_transfer_lines.attribute6%TYPE
114: ,attribute7 gmi_discrete_transfer_lines.attribute7%TYPE
115: ,attribute8 gmi_discrete_transfer_lines.attribute8%TYPE
116: ,attribute9 gmi_discrete_transfer_lines.attribute9%TYPE
117: ,attribute10 gmi_discrete_transfer_lines.attribute10%TYPE
118: ,attribute11 gmi_discrete_transfer_lines.attribute11%TYPE
119: ,attribute12 gmi_discrete_transfer_lines.attribute12%TYPE
112: ,attribute5 gmi_discrete_transfer_lines.attribute5%TYPE
113: ,attribute6 gmi_discrete_transfer_lines.attribute6%TYPE
114: ,attribute7 gmi_discrete_transfer_lines.attribute7%TYPE
115: ,attribute8 gmi_discrete_transfer_lines.attribute8%TYPE
116: ,attribute9 gmi_discrete_transfer_lines.attribute9%TYPE
117: ,attribute10 gmi_discrete_transfer_lines.attribute10%TYPE
118: ,attribute11 gmi_discrete_transfer_lines.attribute11%TYPE
119: ,attribute12 gmi_discrete_transfer_lines.attribute12%TYPE
120: ,attribute13 gmi_discrete_transfer_lines.attribute13%TYPE
113: ,attribute6 gmi_discrete_transfer_lines.attribute6%TYPE
114: ,attribute7 gmi_discrete_transfer_lines.attribute7%TYPE
115: ,attribute8 gmi_discrete_transfer_lines.attribute8%TYPE
116: ,attribute9 gmi_discrete_transfer_lines.attribute9%TYPE
117: ,attribute10 gmi_discrete_transfer_lines.attribute10%TYPE
118: ,attribute11 gmi_discrete_transfer_lines.attribute11%TYPE
119: ,attribute12 gmi_discrete_transfer_lines.attribute12%TYPE
120: ,attribute13 gmi_discrete_transfer_lines.attribute13%TYPE
121: ,attribute14 gmi_discrete_transfer_lines.attribute14%TYPE
114: ,attribute7 gmi_discrete_transfer_lines.attribute7%TYPE
115: ,attribute8 gmi_discrete_transfer_lines.attribute8%TYPE
116: ,attribute9 gmi_discrete_transfer_lines.attribute9%TYPE
117: ,attribute10 gmi_discrete_transfer_lines.attribute10%TYPE
118: ,attribute11 gmi_discrete_transfer_lines.attribute11%TYPE
119: ,attribute12 gmi_discrete_transfer_lines.attribute12%TYPE
120: ,attribute13 gmi_discrete_transfer_lines.attribute13%TYPE
121: ,attribute14 gmi_discrete_transfer_lines.attribute14%TYPE
122: ,attribute15 gmi_discrete_transfer_lines.attribute15%TYPE
115: ,attribute8 gmi_discrete_transfer_lines.attribute8%TYPE
116: ,attribute9 gmi_discrete_transfer_lines.attribute9%TYPE
117: ,attribute10 gmi_discrete_transfer_lines.attribute10%TYPE
118: ,attribute11 gmi_discrete_transfer_lines.attribute11%TYPE
119: ,attribute12 gmi_discrete_transfer_lines.attribute12%TYPE
120: ,attribute13 gmi_discrete_transfer_lines.attribute13%TYPE
121: ,attribute14 gmi_discrete_transfer_lines.attribute14%TYPE
122: ,attribute15 gmi_discrete_transfer_lines.attribute15%TYPE
123: ,attribute16 gmi_discrete_transfer_lines.attribute16%TYPE
116: ,attribute9 gmi_discrete_transfer_lines.attribute9%TYPE
117: ,attribute10 gmi_discrete_transfer_lines.attribute10%TYPE
118: ,attribute11 gmi_discrete_transfer_lines.attribute11%TYPE
119: ,attribute12 gmi_discrete_transfer_lines.attribute12%TYPE
120: ,attribute13 gmi_discrete_transfer_lines.attribute13%TYPE
121: ,attribute14 gmi_discrete_transfer_lines.attribute14%TYPE
122: ,attribute15 gmi_discrete_transfer_lines.attribute15%TYPE
123: ,attribute16 gmi_discrete_transfer_lines.attribute16%TYPE
124: ,attribute17 gmi_discrete_transfer_lines.attribute17%TYPE
117: ,attribute10 gmi_discrete_transfer_lines.attribute10%TYPE
118: ,attribute11 gmi_discrete_transfer_lines.attribute11%TYPE
119: ,attribute12 gmi_discrete_transfer_lines.attribute12%TYPE
120: ,attribute13 gmi_discrete_transfer_lines.attribute13%TYPE
121: ,attribute14 gmi_discrete_transfer_lines.attribute14%TYPE
122: ,attribute15 gmi_discrete_transfer_lines.attribute15%TYPE
123: ,attribute16 gmi_discrete_transfer_lines.attribute16%TYPE
124: ,attribute17 gmi_discrete_transfer_lines.attribute17%TYPE
125: ,attribute18 gmi_discrete_transfer_lines.attribute18%TYPE
118: ,attribute11 gmi_discrete_transfer_lines.attribute11%TYPE
119: ,attribute12 gmi_discrete_transfer_lines.attribute12%TYPE
120: ,attribute13 gmi_discrete_transfer_lines.attribute13%TYPE
121: ,attribute14 gmi_discrete_transfer_lines.attribute14%TYPE
122: ,attribute15 gmi_discrete_transfer_lines.attribute15%TYPE
123: ,attribute16 gmi_discrete_transfer_lines.attribute16%TYPE
124: ,attribute17 gmi_discrete_transfer_lines.attribute17%TYPE
125: ,attribute18 gmi_discrete_transfer_lines.attribute18%TYPE
126: ,attribute19 gmi_discrete_transfer_lines.attribute19%TYPE
119: ,attribute12 gmi_discrete_transfer_lines.attribute12%TYPE
120: ,attribute13 gmi_discrete_transfer_lines.attribute13%TYPE
121: ,attribute14 gmi_discrete_transfer_lines.attribute14%TYPE
122: ,attribute15 gmi_discrete_transfer_lines.attribute15%TYPE
123: ,attribute16 gmi_discrete_transfer_lines.attribute16%TYPE
124: ,attribute17 gmi_discrete_transfer_lines.attribute17%TYPE
125: ,attribute18 gmi_discrete_transfer_lines.attribute18%TYPE
126: ,attribute19 gmi_discrete_transfer_lines.attribute19%TYPE
127: ,attribute20 gmi_discrete_transfer_lines.attribute20%TYPE
120: ,attribute13 gmi_discrete_transfer_lines.attribute13%TYPE
121: ,attribute14 gmi_discrete_transfer_lines.attribute14%TYPE
122: ,attribute15 gmi_discrete_transfer_lines.attribute15%TYPE
123: ,attribute16 gmi_discrete_transfer_lines.attribute16%TYPE
124: ,attribute17 gmi_discrete_transfer_lines.attribute17%TYPE
125: ,attribute18 gmi_discrete_transfer_lines.attribute18%TYPE
126: ,attribute19 gmi_discrete_transfer_lines.attribute19%TYPE
127: ,attribute20 gmi_discrete_transfer_lines.attribute20%TYPE
128: ,attribute21 gmi_discrete_transfer_lines.attribute21%TYPE
121: ,attribute14 gmi_discrete_transfer_lines.attribute14%TYPE
122: ,attribute15 gmi_discrete_transfer_lines.attribute15%TYPE
123: ,attribute16 gmi_discrete_transfer_lines.attribute16%TYPE
124: ,attribute17 gmi_discrete_transfer_lines.attribute17%TYPE
125: ,attribute18 gmi_discrete_transfer_lines.attribute18%TYPE
126: ,attribute19 gmi_discrete_transfer_lines.attribute19%TYPE
127: ,attribute20 gmi_discrete_transfer_lines.attribute20%TYPE
128: ,attribute21 gmi_discrete_transfer_lines.attribute21%TYPE
129: ,attribute22 gmi_discrete_transfer_lines.attribute22%TYPE
122: ,attribute15 gmi_discrete_transfer_lines.attribute15%TYPE
123: ,attribute16 gmi_discrete_transfer_lines.attribute16%TYPE
124: ,attribute17 gmi_discrete_transfer_lines.attribute17%TYPE
125: ,attribute18 gmi_discrete_transfer_lines.attribute18%TYPE
126: ,attribute19 gmi_discrete_transfer_lines.attribute19%TYPE
127: ,attribute20 gmi_discrete_transfer_lines.attribute20%TYPE
128: ,attribute21 gmi_discrete_transfer_lines.attribute21%TYPE
129: ,attribute22 gmi_discrete_transfer_lines.attribute22%TYPE
130: ,attribute23 gmi_discrete_transfer_lines.attribute23%TYPE
123: ,attribute16 gmi_discrete_transfer_lines.attribute16%TYPE
124: ,attribute17 gmi_discrete_transfer_lines.attribute17%TYPE
125: ,attribute18 gmi_discrete_transfer_lines.attribute18%TYPE
126: ,attribute19 gmi_discrete_transfer_lines.attribute19%TYPE
127: ,attribute20 gmi_discrete_transfer_lines.attribute20%TYPE
128: ,attribute21 gmi_discrete_transfer_lines.attribute21%TYPE
129: ,attribute22 gmi_discrete_transfer_lines.attribute22%TYPE
130: ,attribute23 gmi_discrete_transfer_lines.attribute23%TYPE
131: ,attribute24 gmi_discrete_transfer_lines.attribute24%TYPE
124: ,attribute17 gmi_discrete_transfer_lines.attribute17%TYPE
125: ,attribute18 gmi_discrete_transfer_lines.attribute18%TYPE
126: ,attribute19 gmi_discrete_transfer_lines.attribute19%TYPE
127: ,attribute20 gmi_discrete_transfer_lines.attribute20%TYPE
128: ,attribute21 gmi_discrete_transfer_lines.attribute21%TYPE
129: ,attribute22 gmi_discrete_transfer_lines.attribute22%TYPE
130: ,attribute23 gmi_discrete_transfer_lines.attribute23%TYPE
131: ,attribute24 gmi_discrete_transfer_lines.attribute24%TYPE
132: ,attribute25 gmi_discrete_transfer_lines.attribute25%TYPE
125: ,attribute18 gmi_discrete_transfer_lines.attribute18%TYPE
126: ,attribute19 gmi_discrete_transfer_lines.attribute19%TYPE
127: ,attribute20 gmi_discrete_transfer_lines.attribute20%TYPE
128: ,attribute21 gmi_discrete_transfer_lines.attribute21%TYPE
129: ,attribute22 gmi_discrete_transfer_lines.attribute22%TYPE
130: ,attribute23 gmi_discrete_transfer_lines.attribute23%TYPE
131: ,attribute24 gmi_discrete_transfer_lines.attribute24%TYPE
132: ,attribute25 gmi_discrete_transfer_lines.attribute25%TYPE
133: ,attribute26 gmi_discrete_transfer_lines.attribute26%TYPE
126: ,attribute19 gmi_discrete_transfer_lines.attribute19%TYPE
127: ,attribute20 gmi_discrete_transfer_lines.attribute20%TYPE
128: ,attribute21 gmi_discrete_transfer_lines.attribute21%TYPE
129: ,attribute22 gmi_discrete_transfer_lines.attribute22%TYPE
130: ,attribute23 gmi_discrete_transfer_lines.attribute23%TYPE
131: ,attribute24 gmi_discrete_transfer_lines.attribute24%TYPE
132: ,attribute25 gmi_discrete_transfer_lines.attribute25%TYPE
133: ,attribute26 gmi_discrete_transfer_lines.attribute26%TYPE
134: ,attribute27 gmi_discrete_transfer_lines.attribute27%TYPE
127: ,attribute20 gmi_discrete_transfer_lines.attribute20%TYPE
128: ,attribute21 gmi_discrete_transfer_lines.attribute21%TYPE
129: ,attribute22 gmi_discrete_transfer_lines.attribute22%TYPE
130: ,attribute23 gmi_discrete_transfer_lines.attribute23%TYPE
131: ,attribute24 gmi_discrete_transfer_lines.attribute24%TYPE
132: ,attribute25 gmi_discrete_transfer_lines.attribute25%TYPE
133: ,attribute26 gmi_discrete_transfer_lines.attribute26%TYPE
134: ,attribute27 gmi_discrete_transfer_lines.attribute27%TYPE
135: ,attribute28 gmi_discrete_transfer_lines.attribute28%TYPE
128: ,attribute21 gmi_discrete_transfer_lines.attribute21%TYPE
129: ,attribute22 gmi_discrete_transfer_lines.attribute22%TYPE
130: ,attribute23 gmi_discrete_transfer_lines.attribute23%TYPE
131: ,attribute24 gmi_discrete_transfer_lines.attribute24%TYPE
132: ,attribute25 gmi_discrete_transfer_lines.attribute25%TYPE
133: ,attribute26 gmi_discrete_transfer_lines.attribute26%TYPE
134: ,attribute27 gmi_discrete_transfer_lines.attribute27%TYPE
135: ,attribute28 gmi_discrete_transfer_lines.attribute28%TYPE
136: ,attribute29 gmi_discrete_transfer_lines.attribute29%TYPE
129: ,attribute22 gmi_discrete_transfer_lines.attribute22%TYPE
130: ,attribute23 gmi_discrete_transfer_lines.attribute23%TYPE
131: ,attribute24 gmi_discrete_transfer_lines.attribute24%TYPE
132: ,attribute25 gmi_discrete_transfer_lines.attribute25%TYPE
133: ,attribute26 gmi_discrete_transfer_lines.attribute26%TYPE
134: ,attribute27 gmi_discrete_transfer_lines.attribute27%TYPE
135: ,attribute28 gmi_discrete_transfer_lines.attribute28%TYPE
136: ,attribute29 gmi_discrete_transfer_lines.attribute29%TYPE
137: ,attribute30 gmi_discrete_transfer_lines.attribute30%TYPE
130: ,attribute23 gmi_discrete_transfer_lines.attribute23%TYPE
131: ,attribute24 gmi_discrete_transfer_lines.attribute24%TYPE
132: ,attribute25 gmi_discrete_transfer_lines.attribute25%TYPE
133: ,attribute26 gmi_discrete_transfer_lines.attribute26%TYPE
134: ,attribute27 gmi_discrete_transfer_lines.attribute27%TYPE
135: ,attribute28 gmi_discrete_transfer_lines.attribute28%TYPE
136: ,attribute29 gmi_discrete_transfer_lines.attribute29%TYPE
137: ,attribute30 gmi_discrete_transfer_lines.attribute30%TYPE
138: /* *********************************************************************** */
131: ,attribute24 gmi_discrete_transfer_lines.attribute24%TYPE
132: ,attribute25 gmi_discrete_transfer_lines.attribute25%TYPE
133: ,attribute26 gmi_discrete_transfer_lines.attribute26%TYPE
134: ,attribute27 gmi_discrete_transfer_lines.attribute27%TYPE
135: ,attribute28 gmi_discrete_transfer_lines.attribute28%TYPE
136: ,attribute29 gmi_discrete_transfer_lines.attribute29%TYPE
137: ,attribute30 gmi_discrete_transfer_lines.attribute30%TYPE
138: /* *********************************************************************** */
139: ,opm_item_no ic_item_mst.item_no%TYPE
132: ,attribute25 gmi_discrete_transfer_lines.attribute25%TYPE
133: ,attribute26 gmi_discrete_transfer_lines.attribute26%TYPE
134: ,attribute27 gmi_discrete_transfer_lines.attribute27%TYPE
135: ,attribute28 gmi_discrete_transfer_lines.attribute28%TYPE
136: ,attribute29 gmi_discrete_transfer_lines.attribute29%TYPE
137: ,attribute30 gmi_discrete_transfer_lines.attribute30%TYPE
138: /* *********************************************************************** */
139: ,opm_item_no ic_item_mst.item_no%TYPE
140: ,lot_control NUMBER /* same as OPM item lot control flag */
133: ,attribute26 gmi_discrete_transfer_lines.attribute26%TYPE
134: ,attribute27 gmi_discrete_transfer_lines.attribute27%TYPE
135: ,attribute28 gmi_discrete_transfer_lines.attribute28%TYPE
136: ,attribute29 gmi_discrete_transfer_lines.attribute29%TYPE
137: ,attribute30 gmi_discrete_transfer_lines.attribute30%TYPE
138: /* *********************************************************************** */
139: ,opm_item_no ic_item_mst.item_no%TYPE
140: ,lot_control NUMBER /* same as OPM item lot control flag */
141: /* Jalaj Srivastava Bug 3812701 */
149: );
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
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
162: ,opm_primary_quantity gmi_discrete_transfer_lots.opm_primary_quantity%TYPE
163: ,odm_primary_quantity gmi_discrete_transfer_lots.odm_primary_quantity%TYPE
169: TYPE line_type_tbl IS TABLE OF line_type INDEX BY BINARY_INTEGER;
170:
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 */