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.GMIGAPI dependencies on IC_LOTS_MST

Line 148: , lot_no ic_lots_mst.lot_no%TYPE

144: );
145:
146: TYPE lot_rec_typ IS RECORD
147: ( item_no ic_item_mst.item_no%TYPE
148: , lot_no ic_lots_mst.lot_no%TYPE
149: , sublot_no ic_lots_mst.sublot_no%TYPE
150: , lot_desc ic_lots_mst.lot_desc%TYPE
151: , qc_grade ic_lots_mst.qc_grade%TYPE
152: , expaction_code ic_lots_mst.expaction_code%TYPE

Line 149: , sublot_no ic_lots_mst.sublot_no%TYPE

145:
146: TYPE lot_rec_typ IS RECORD
147: ( item_no ic_item_mst.item_no%TYPE
148: , lot_no ic_lots_mst.lot_no%TYPE
149: , sublot_no ic_lots_mst.sublot_no%TYPE
150: , lot_desc ic_lots_mst.lot_desc%TYPE
151: , qc_grade ic_lots_mst.qc_grade%TYPE
152: , expaction_code ic_lots_mst.expaction_code%TYPE
153: , expaction_date ic_lots_mst.expaction_date%TYPE

Line 150: , lot_desc ic_lots_mst.lot_desc%TYPE

146: TYPE lot_rec_typ IS RECORD
147: ( item_no ic_item_mst.item_no%TYPE
148: , lot_no ic_lots_mst.lot_no%TYPE
149: , sublot_no ic_lots_mst.sublot_no%TYPE
150: , lot_desc ic_lots_mst.lot_desc%TYPE
151: , qc_grade ic_lots_mst.qc_grade%TYPE
152: , expaction_code ic_lots_mst.expaction_code%TYPE
153: , expaction_date ic_lots_mst.expaction_date%TYPE
154: , lot_created ic_lots_mst.lot_created%TYPE

Line 151: , qc_grade ic_lots_mst.qc_grade%TYPE

147: ( item_no ic_item_mst.item_no%TYPE
148: , lot_no ic_lots_mst.lot_no%TYPE
149: , sublot_no ic_lots_mst.sublot_no%TYPE
150: , lot_desc ic_lots_mst.lot_desc%TYPE
151: , qc_grade ic_lots_mst.qc_grade%TYPE
152: , expaction_code ic_lots_mst.expaction_code%TYPE
153: , expaction_date ic_lots_mst.expaction_date%TYPE
154: , lot_created ic_lots_mst.lot_created%TYPE
155: , expire_date ic_lots_mst.expire_date%TYPE

Line 152: , expaction_code ic_lots_mst.expaction_code%TYPE

148: , lot_no ic_lots_mst.lot_no%TYPE
149: , sublot_no ic_lots_mst.sublot_no%TYPE
150: , lot_desc ic_lots_mst.lot_desc%TYPE
151: , qc_grade ic_lots_mst.qc_grade%TYPE
152: , expaction_code ic_lots_mst.expaction_code%TYPE
153: , expaction_date ic_lots_mst.expaction_date%TYPE
154: , lot_created ic_lots_mst.lot_created%TYPE
155: , expire_date ic_lots_mst.expire_date%TYPE
156: , retest_date ic_lots_mst.retest_date%TYPE

Line 153: , expaction_date ic_lots_mst.expaction_date%TYPE

149: , sublot_no ic_lots_mst.sublot_no%TYPE
150: , lot_desc ic_lots_mst.lot_desc%TYPE
151: , qc_grade ic_lots_mst.qc_grade%TYPE
152: , expaction_code ic_lots_mst.expaction_code%TYPE
153: , expaction_date ic_lots_mst.expaction_date%TYPE
154: , lot_created ic_lots_mst.lot_created%TYPE
155: , expire_date ic_lots_mst.expire_date%TYPE
156: , retest_date ic_lots_mst.retest_date%TYPE
157: , strength ic_lots_mst.strength%TYPE DEFAULT 100

Line 154: , lot_created ic_lots_mst.lot_created%TYPE

150: , lot_desc ic_lots_mst.lot_desc%TYPE
151: , qc_grade ic_lots_mst.qc_grade%TYPE
152: , expaction_code ic_lots_mst.expaction_code%TYPE
153: , expaction_date ic_lots_mst.expaction_date%TYPE
154: , lot_created ic_lots_mst.lot_created%TYPE
155: , expire_date ic_lots_mst.expire_date%TYPE
156: , retest_date ic_lots_mst.retest_date%TYPE
157: , strength ic_lots_mst.strength%TYPE DEFAULT 100
158: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0

Line 155: , expire_date ic_lots_mst.expire_date%TYPE

151: , qc_grade ic_lots_mst.qc_grade%TYPE
152: , expaction_code ic_lots_mst.expaction_code%TYPE
153: , expaction_date ic_lots_mst.expaction_date%TYPE
154: , lot_created ic_lots_mst.lot_created%TYPE
155: , expire_date ic_lots_mst.expire_date%TYPE
156: , retest_date ic_lots_mst.retest_date%TYPE
157: , strength ic_lots_mst.strength%TYPE DEFAULT 100
158: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
159: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0

Line 156: , retest_date ic_lots_mst.retest_date%TYPE

152: , expaction_code ic_lots_mst.expaction_code%TYPE
153: , expaction_date ic_lots_mst.expaction_date%TYPE
154: , lot_created ic_lots_mst.lot_created%TYPE
155: , expire_date ic_lots_mst.expire_date%TYPE
156: , retest_date ic_lots_mst.retest_date%TYPE
157: , strength ic_lots_mst.strength%TYPE DEFAULT 100
158: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
159: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
160: , shipvendor_no po_vend_mst.vendor_no%TYPE

Line 157: , strength ic_lots_mst.strength%TYPE DEFAULT 100

153: , expaction_date ic_lots_mst.expaction_date%TYPE
154: , lot_created ic_lots_mst.lot_created%TYPE
155: , expire_date ic_lots_mst.expire_date%TYPE
156: , retest_date ic_lots_mst.retest_date%TYPE
157: , strength ic_lots_mst.strength%TYPE DEFAULT 100
158: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
159: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
160: , shipvendor_no po_vend_mst.vendor_no%TYPE
161: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE

Line 158: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0

154: , lot_created ic_lots_mst.lot_created%TYPE
155: , expire_date ic_lots_mst.expire_date%TYPE
156: , retest_date ic_lots_mst.retest_date%TYPE
157: , strength ic_lots_mst.strength%TYPE DEFAULT 100
158: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
159: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
160: , shipvendor_no po_vend_mst.vendor_no%TYPE
161: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE
162: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE

Line 159: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0

155: , expire_date ic_lots_mst.expire_date%TYPE
156: , retest_date ic_lots_mst.retest_date%TYPE
157: , strength ic_lots_mst.strength%TYPE DEFAULT 100
158: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
159: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
160: , shipvendor_no po_vend_mst.vendor_no%TYPE
161: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE
162: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE
163: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE

Line 161: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE

157: , strength ic_lots_mst.strength%TYPE DEFAULT 100
158: , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
159: , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
160: , shipvendor_no po_vend_mst.vendor_no%TYPE
161: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE
162: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE
163: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE
164: , attribute1 ic_lots_mst.attribute1%TYPE
165: , attribute2 ic_lots_mst.attribute2%TYPE

Line 164: , attribute1 ic_lots_mst.attribute1%TYPE

160: , shipvendor_no po_vend_mst.vendor_no%TYPE
161: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE
162: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE
163: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE
164: , attribute1 ic_lots_mst.attribute1%TYPE
165: , attribute2 ic_lots_mst.attribute2%TYPE
166: , attribute3 ic_lots_mst.attribute3%TYPE
167: , attribute4 ic_lots_mst.attribute4%TYPE
168: , attribute5 ic_lots_mst.attribute5%TYPE

Line 165: , attribute2 ic_lots_mst.attribute2%TYPE

161: , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE
162: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE
163: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE
164: , attribute1 ic_lots_mst.attribute1%TYPE
165: , attribute2 ic_lots_mst.attribute2%TYPE
166: , attribute3 ic_lots_mst.attribute3%TYPE
167: , attribute4 ic_lots_mst.attribute4%TYPE
168: , attribute5 ic_lots_mst.attribute5%TYPE
169: , attribute6 ic_lots_mst.attribute6%TYPE

Line 166: , attribute3 ic_lots_mst.attribute3%TYPE

162: , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE
163: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE
164: , attribute1 ic_lots_mst.attribute1%TYPE
165: , attribute2 ic_lots_mst.attribute2%TYPE
166: , attribute3 ic_lots_mst.attribute3%TYPE
167: , attribute4 ic_lots_mst.attribute4%TYPE
168: , attribute5 ic_lots_mst.attribute5%TYPE
169: , attribute6 ic_lots_mst.attribute6%TYPE
170: , attribute7 ic_lots_mst.attribute7%TYPE

Line 167: , attribute4 ic_lots_mst.attribute4%TYPE

163: , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE
164: , attribute1 ic_lots_mst.attribute1%TYPE
165: , attribute2 ic_lots_mst.attribute2%TYPE
166: , attribute3 ic_lots_mst.attribute3%TYPE
167: , attribute4 ic_lots_mst.attribute4%TYPE
168: , attribute5 ic_lots_mst.attribute5%TYPE
169: , attribute6 ic_lots_mst.attribute6%TYPE
170: , attribute7 ic_lots_mst.attribute7%TYPE
171: , attribute8 ic_lots_mst.attribute8%TYPE

Line 168: , attribute5 ic_lots_mst.attribute5%TYPE

164: , attribute1 ic_lots_mst.attribute1%TYPE
165: , attribute2 ic_lots_mst.attribute2%TYPE
166: , attribute3 ic_lots_mst.attribute3%TYPE
167: , attribute4 ic_lots_mst.attribute4%TYPE
168: , attribute5 ic_lots_mst.attribute5%TYPE
169: , attribute6 ic_lots_mst.attribute6%TYPE
170: , attribute7 ic_lots_mst.attribute7%TYPE
171: , attribute8 ic_lots_mst.attribute8%TYPE
172: , attribute9 ic_lots_mst.attribute9%TYPE

Line 169: , attribute6 ic_lots_mst.attribute6%TYPE

165: , attribute2 ic_lots_mst.attribute2%TYPE
166: , attribute3 ic_lots_mst.attribute3%TYPE
167: , attribute4 ic_lots_mst.attribute4%TYPE
168: , attribute5 ic_lots_mst.attribute5%TYPE
169: , attribute6 ic_lots_mst.attribute6%TYPE
170: , attribute7 ic_lots_mst.attribute7%TYPE
171: , attribute8 ic_lots_mst.attribute8%TYPE
172: , attribute9 ic_lots_mst.attribute9%TYPE
173: , attribute10 ic_lots_mst.attribute10%TYPE

Line 170: , attribute7 ic_lots_mst.attribute7%TYPE

166: , attribute3 ic_lots_mst.attribute3%TYPE
167: , attribute4 ic_lots_mst.attribute4%TYPE
168: , attribute5 ic_lots_mst.attribute5%TYPE
169: , attribute6 ic_lots_mst.attribute6%TYPE
170: , attribute7 ic_lots_mst.attribute7%TYPE
171: , attribute8 ic_lots_mst.attribute8%TYPE
172: , attribute9 ic_lots_mst.attribute9%TYPE
173: , attribute10 ic_lots_mst.attribute10%TYPE
174: , attribute11 ic_lots_mst.attribute11%TYPE

Line 171: , attribute8 ic_lots_mst.attribute8%TYPE

167: , attribute4 ic_lots_mst.attribute4%TYPE
168: , attribute5 ic_lots_mst.attribute5%TYPE
169: , attribute6 ic_lots_mst.attribute6%TYPE
170: , attribute7 ic_lots_mst.attribute7%TYPE
171: , attribute8 ic_lots_mst.attribute8%TYPE
172: , attribute9 ic_lots_mst.attribute9%TYPE
173: , attribute10 ic_lots_mst.attribute10%TYPE
174: , attribute11 ic_lots_mst.attribute11%TYPE
175: , attribute12 ic_lots_mst.attribute12%TYPE

Line 172: , attribute9 ic_lots_mst.attribute9%TYPE

168: , attribute5 ic_lots_mst.attribute5%TYPE
169: , attribute6 ic_lots_mst.attribute6%TYPE
170: , attribute7 ic_lots_mst.attribute7%TYPE
171: , attribute8 ic_lots_mst.attribute8%TYPE
172: , attribute9 ic_lots_mst.attribute9%TYPE
173: , attribute10 ic_lots_mst.attribute10%TYPE
174: , attribute11 ic_lots_mst.attribute11%TYPE
175: , attribute12 ic_lots_mst.attribute12%TYPE
176: , attribute13 ic_lots_mst.attribute13%TYPE

Line 173: , attribute10 ic_lots_mst.attribute10%TYPE

169: , attribute6 ic_lots_mst.attribute6%TYPE
170: , attribute7 ic_lots_mst.attribute7%TYPE
171: , attribute8 ic_lots_mst.attribute8%TYPE
172: , attribute9 ic_lots_mst.attribute9%TYPE
173: , attribute10 ic_lots_mst.attribute10%TYPE
174: , attribute11 ic_lots_mst.attribute11%TYPE
175: , attribute12 ic_lots_mst.attribute12%TYPE
176: , attribute13 ic_lots_mst.attribute13%TYPE
177: , attribute14 ic_lots_mst.attribute14%TYPE

Line 174: , attribute11 ic_lots_mst.attribute11%TYPE

170: , attribute7 ic_lots_mst.attribute7%TYPE
171: , attribute8 ic_lots_mst.attribute8%TYPE
172: , attribute9 ic_lots_mst.attribute9%TYPE
173: , attribute10 ic_lots_mst.attribute10%TYPE
174: , attribute11 ic_lots_mst.attribute11%TYPE
175: , attribute12 ic_lots_mst.attribute12%TYPE
176: , attribute13 ic_lots_mst.attribute13%TYPE
177: , attribute14 ic_lots_mst.attribute14%TYPE
178: , attribute15 ic_lots_mst.attribute15%TYPE

Line 175: , attribute12 ic_lots_mst.attribute12%TYPE

171: , attribute8 ic_lots_mst.attribute8%TYPE
172: , attribute9 ic_lots_mst.attribute9%TYPE
173: , attribute10 ic_lots_mst.attribute10%TYPE
174: , attribute11 ic_lots_mst.attribute11%TYPE
175: , attribute12 ic_lots_mst.attribute12%TYPE
176: , attribute13 ic_lots_mst.attribute13%TYPE
177: , attribute14 ic_lots_mst.attribute14%TYPE
178: , attribute15 ic_lots_mst.attribute15%TYPE
179: , attribute16 ic_lots_mst.attribute16%TYPE

Line 176: , attribute13 ic_lots_mst.attribute13%TYPE

172: , attribute9 ic_lots_mst.attribute9%TYPE
173: , attribute10 ic_lots_mst.attribute10%TYPE
174: , attribute11 ic_lots_mst.attribute11%TYPE
175: , attribute12 ic_lots_mst.attribute12%TYPE
176: , attribute13 ic_lots_mst.attribute13%TYPE
177: , attribute14 ic_lots_mst.attribute14%TYPE
178: , attribute15 ic_lots_mst.attribute15%TYPE
179: , attribute16 ic_lots_mst.attribute16%TYPE
180: , attribute17 ic_lots_mst.attribute17%TYPE

Line 177: , attribute14 ic_lots_mst.attribute14%TYPE

173: , attribute10 ic_lots_mst.attribute10%TYPE
174: , attribute11 ic_lots_mst.attribute11%TYPE
175: , attribute12 ic_lots_mst.attribute12%TYPE
176: , attribute13 ic_lots_mst.attribute13%TYPE
177: , attribute14 ic_lots_mst.attribute14%TYPE
178: , attribute15 ic_lots_mst.attribute15%TYPE
179: , attribute16 ic_lots_mst.attribute16%TYPE
180: , attribute17 ic_lots_mst.attribute17%TYPE
181: , attribute18 ic_lots_mst.attribute18%TYPE

Line 178: , attribute15 ic_lots_mst.attribute15%TYPE

174: , attribute11 ic_lots_mst.attribute11%TYPE
175: , attribute12 ic_lots_mst.attribute12%TYPE
176: , attribute13 ic_lots_mst.attribute13%TYPE
177: , attribute14 ic_lots_mst.attribute14%TYPE
178: , attribute15 ic_lots_mst.attribute15%TYPE
179: , attribute16 ic_lots_mst.attribute16%TYPE
180: , attribute17 ic_lots_mst.attribute17%TYPE
181: , attribute18 ic_lots_mst.attribute18%TYPE
182: , attribute19 ic_lots_mst.attribute19%TYPE

Line 179: , attribute16 ic_lots_mst.attribute16%TYPE

175: , attribute12 ic_lots_mst.attribute12%TYPE
176: , attribute13 ic_lots_mst.attribute13%TYPE
177: , attribute14 ic_lots_mst.attribute14%TYPE
178: , attribute15 ic_lots_mst.attribute15%TYPE
179: , attribute16 ic_lots_mst.attribute16%TYPE
180: , attribute17 ic_lots_mst.attribute17%TYPE
181: , attribute18 ic_lots_mst.attribute18%TYPE
182: , attribute19 ic_lots_mst.attribute19%TYPE
183: , attribute20 ic_lots_mst.attribute20%TYPE

Line 180: , attribute17 ic_lots_mst.attribute17%TYPE

176: , attribute13 ic_lots_mst.attribute13%TYPE
177: , attribute14 ic_lots_mst.attribute14%TYPE
178: , attribute15 ic_lots_mst.attribute15%TYPE
179: , attribute16 ic_lots_mst.attribute16%TYPE
180: , attribute17 ic_lots_mst.attribute17%TYPE
181: , attribute18 ic_lots_mst.attribute18%TYPE
182: , attribute19 ic_lots_mst.attribute19%TYPE
183: , attribute20 ic_lots_mst.attribute20%TYPE
184: , attribute21 ic_lots_mst.attribute21%TYPE

Line 181: , attribute18 ic_lots_mst.attribute18%TYPE

177: , attribute14 ic_lots_mst.attribute14%TYPE
178: , attribute15 ic_lots_mst.attribute15%TYPE
179: , attribute16 ic_lots_mst.attribute16%TYPE
180: , attribute17 ic_lots_mst.attribute17%TYPE
181: , attribute18 ic_lots_mst.attribute18%TYPE
182: , attribute19 ic_lots_mst.attribute19%TYPE
183: , attribute20 ic_lots_mst.attribute20%TYPE
184: , attribute21 ic_lots_mst.attribute21%TYPE
185: , attribute22 ic_lots_mst.attribute22%TYPE

Line 182: , attribute19 ic_lots_mst.attribute19%TYPE

178: , attribute15 ic_lots_mst.attribute15%TYPE
179: , attribute16 ic_lots_mst.attribute16%TYPE
180: , attribute17 ic_lots_mst.attribute17%TYPE
181: , attribute18 ic_lots_mst.attribute18%TYPE
182: , attribute19 ic_lots_mst.attribute19%TYPE
183: , attribute20 ic_lots_mst.attribute20%TYPE
184: , attribute21 ic_lots_mst.attribute21%TYPE
185: , attribute22 ic_lots_mst.attribute22%TYPE
186: , attribute23 ic_lots_mst.attribute23%TYPE

Line 183: , attribute20 ic_lots_mst.attribute20%TYPE

179: , attribute16 ic_lots_mst.attribute16%TYPE
180: , attribute17 ic_lots_mst.attribute17%TYPE
181: , attribute18 ic_lots_mst.attribute18%TYPE
182: , attribute19 ic_lots_mst.attribute19%TYPE
183: , attribute20 ic_lots_mst.attribute20%TYPE
184: , attribute21 ic_lots_mst.attribute21%TYPE
185: , attribute22 ic_lots_mst.attribute22%TYPE
186: , attribute23 ic_lots_mst.attribute23%TYPE
187: , attribute24 ic_lots_mst.attribute24%TYPE

Line 184: , attribute21 ic_lots_mst.attribute21%TYPE

180: , attribute17 ic_lots_mst.attribute17%TYPE
181: , attribute18 ic_lots_mst.attribute18%TYPE
182: , attribute19 ic_lots_mst.attribute19%TYPE
183: , attribute20 ic_lots_mst.attribute20%TYPE
184: , attribute21 ic_lots_mst.attribute21%TYPE
185: , attribute22 ic_lots_mst.attribute22%TYPE
186: , attribute23 ic_lots_mst.attribute23%TYPE
187: , attribute24 ic_lots_mst.attribute24%TYPE
188: , attribute25 ic_lots_mst.attribute25%TYPE

Line 185: , attribute22 ic_lots_mst.attribute22%TYPE

181: , attribute18 ic_lots_mst.attribute18%TYPE
182: , attribute19 ic_lots_mst.attribute19%TYPE
183: , attribute20 ic_lots_mst.attribute20%TYPE
184: , attribute21 ic_lots_mst.attribute21%TYPE
185: , attribute22 ic_lots_mst.attribute22%TYPE
186: , attribute23 ic_lots_mst.attribute23%TYPE
187: , attribute24 ic_lots_mst.attribute24%TYPE
188: , attribute25 ic_lots_mst.attribute25%TYPE
189: , attribute26 ic_lots_mst.attribute26%TYPE

Line 186: , attribute23 ic_lots_mst.attribute23%TYPE

182: , attribute19 ic_lots_mst.attribute19%TYPE
183: , attribute20 ic_lots_mst.attribute20%TYPE
184: , attribute21 ic_lots_mst.attribute21%TYPE
185: , attribute22 ic_lots_mst.attribute22%TYPE
186: , attribute23 ic_lots_mst.attribute23%TYPE
187: , attribute24 ic_lots_mst.attribute24%TYPE
188: , attribute25 ic_lots_mst.attribute25%TYPE
189: , attribute26 ic_lots_mst.attribute26%TYPE
190: , attribute27 ic_lots_mst.attribute27%TYPE

Line 187: , attribute24 ic_lots_mst.attribute24%TYPE

183: , attribute20 ic_lots_mst.attribute20%TYPE
184: , attribute21 ic_lots_mst.attribute21%TYPE
185: , attribute22 ic_lots_mst.attribute22%TYPE
186: , attribute23 ic_lots_mst.attribute23%TYPE
187: , attribute24 ic_lots_mst.attribute24%TYPE
188: , attribute25 ic_lots_mst.attribute25%TYPE
189: , attribute26 ic_lots_mst.attribute26%TYPE
190: , attribute27 ic_lots_mst.attribute27%TYPE
191: , attribute28 ic_lots_mst.attribute28%TYPE

Line 188: , attribute25 ic_lots_mst.attribute25%TYPE

184: , attribute21 ic_lots_mst.attribute21%TYPE
185: , attribute22 ic_lots_mst.attribute22%TYPE
186: , attribute23 ic_lots_mst.attribute23%TYPE
187: , attribute24 ic_lots_mst.attribute24%TYPE
188: , attribute25 ic_lots_mst.attribute25%TYPE
189: , attribute26 ic_lots_mst.attribute26%TYPE
190: , attribute27 ic_lots_mst.attribute27%TYPE
191: , attribute28 ic_lots_mst.attribute28%TYPE
192: , attribute29 ic_lots_mst.attribute29%TYPE

Line 189: , attribute26 ic_lots_mst.attribute26%TYPE

185: , attribute22 ic_lots_mst.attribute22%TYPE
186: , attribute23 ic_lots_mst.attribute23%TYPE
187: , attribute24 ic_lots_mst.attribute24%TYPE
188: , attribute25 ic_lots_mst.attribute25%TYPE
189: , attribute26 ic_lots_mst.attribute26%TYPE
190: , attribute27 ic_lots_mst.attribute27%TYPE
191: , attribute28 ic_lots_mst.attribute28%TYPE
192: , attribute29 ic_lots_mst.attribute29%TYPE
193: , attribute30 ic_lots_mst.attribute30%TYPE

Line 190: , attribute27 ic_lots_mst.attribute27%TYPE

186: , attribute23 ic_lots_mst.attribute23%TYPE
187: , attribute24 ic_lots_mst.attribute24%TYPE
188: , attribute25 ic_lots_mst.attribute25%TYPE
189: , attribute26 ic_lots_mst.attribute26%TYPE
190: , attribute27 ic_lots_mst.attribute27%TYPE
191: , attribute28 ic_lots_mst.attribute28%TYPE
192: , attribute29 ic_lots_mst.attribute29%TYPE
193: , attribute30 ic_lots_mst.attribute30%TYPE
194: , attribute_category ic_lots_mst.attribute_category%TYPE

Line 191: , attribute28 ic_lots_mst.attribute28%TYPE

187: , attribute24 ic_lots_mst.attribute24%TYPE
188: , attribute25 ic_lots_mst.attribute25%TYPE
189: , attribute26 ic_lots_mst.attribute26%TYPE
190: , attribute27 ic_lots_mst.attribute27%TYPE
191: , attribute28 ic_lots_mst.attribute28%TYPE
192: , attribute29 ic_lots_mst.attribute29%TYPE
193: , attribute30 ic_lots_mst.attribute30%TYPE
194: , attribute_category ic_lots_mst.attribute_category%TYPE
195: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'

Line 192: , attribute29 ic_lots_mst.attribute29%TYPE

188: , attribute25 ic_lots_mst.attribute25%TYPE
189: , attribute26 ic_lots_mst.attribute26%TYPE
190: , attribute27 ic_lots_mst.attribute27%TYPE
191: , attribute28 ic_lots_mst.attribute28%TYPE
192: , attribute29 ic_lots_mst.attribute29%TYPE
193: , attribute30 ic_lots_mst.attribute30%TYPE
194: , attribute_category ic_lots_mst.attribute_category%TYPE
195: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
196: );

Line 193: , attribute30 ic_lots_mst.attribute30%TYPE

189: , attribute26 ic_lots_mst.attribute26%TYPE
190: , attribute27 ic_lots_mst.attribute27%TYPE
191: , attribute28 ic_lots_mst.attribute28%TYPE
192: , attribute29 ic_lots_mst.attribute29%TYPE
193: , attribute30 ic_lots_mst.attribute30%TYPE
194: , attribute_category ic_lots_mst.attribute_category%TYPE
195: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
196: );
197:

Line 194: , attribute_category ic_lots_mst.attribute_category%TYPE

190: , attribute27 ic_lots_mst.attribute27%TYPE
191: , attribute28 ic_lots_mst.attribute28%TYPE
192: , attribute29 ic_lots_mst.attribute29%TYPE
193: , attribute30 ic_lots_mst.attribute30%TYPE
194: , attribute_category ic_lots_mst.attribute_category%TYPE
195: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
196: );
197:
198: TYPE conv_rec_typ IS RECORD

Line 201: , lot_no IC_LOTS_MST.lot_no%TYPE DEFAULT NULL

197:
198: TYPE conv_rec_typ IS RECORD
199: (
200: item_no IC_ITEM_MST.item_no%TYPE
201: , lot_no IC_LOTS_MST.lot_no%TYPE DEFAULT NULL
202: , sublot_no IC_LOTS_MST.sublot_no%TYPE DEFAULT NULL
203: , from_uom SY_UOMS_MST.um_code%TYPE
204: , to_uom SY_UOMS_MST.um_code%TYPE
205: , type_factor IC_ITEM_CNV.type_factor%TYPE

Line 202: , sublot_no IC_LOTS_MST.sublot_no%TYPE DEFAULT NULL

198: TYPE conv_rec_typ IS RECORD
199: (
200: item_no IC_ITEM_MST.item_no%TYPE
201: , lot_no IC_LOTS_MST.lot_no%TYPE DEFAULT NULL
202: , sublot_no IC_LOTS_MST.sublot_no%TYPE DEFAULT NULL
203: , from_uom SY_UOMS_MST.um_code%TYPE
204: , to_uom SY_UOMS_MST.um_code%TYPE
205: , type_factor IC_ITEM_CNV.type_factor%TYPE
206: , user_name FND_USER.user_name%TYPE DEFAULT 'OPM'

Line 218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL

214: , from_whse_code ic_tran_cmp.whse_code%TYPE
215: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
216: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
217: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
220: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
221: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
222: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0

Line 219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL

215: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
216: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
217: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
220: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
221: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
222: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
223: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL

Line 276: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL

272: action_code NUMBER(2)
273: , transfer_no ic_xfer_mst.transfer_no%TYPE
274: , orgn_code ic_xfer_mst.orgn_code%TYPE
275: , item_no ic_item_mst.item_no%TYPE
276: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
278: , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
279: , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL
280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL

Line 277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL

273: , transfer_no ic_xfer_mst.transfer_no%TYPE
274: , orgn_code ic_xfer_mst.orgn_code%TYPE
275: , item_no ic_item_mst.item_no%TYPE
276: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
278: , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
279: , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL
280: , cancel_reason_code ic_xfer_mst.cancel_reason_code%TYPE DEFAULT NULL
281: , from_warehouse ic_xfer_mst.from_warehouse%TYPE DEFAULT NULL

Line 297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL

293: , scheduled_receive_date ic_xfer_mst.scheduled_receive_date%TYPE
294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
295: , cancel_date ic_xfer_mst.cancel_date%TYPE
296: , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL

Line 298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL

294: , actual_receive_date ic_xfer_mst.actual_receive_date%TYPE
295: , cancel_date ic_xfer_mst.cancel_date%TYPE
296: , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL

Line 299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL

295: , cancel_date ic_xfer_mst.cancel_date%TYPE
296: , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL

Line 300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL

296: , comments ic_xfer_mst.comments%TYPE DEFAULT NULL
297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL

Line 301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL

297: , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL

Line 302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL

298: , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL

Line 303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL

299: , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL

Line 304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL

300: , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL

Line 305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL

301: , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL

Line 306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL

302: , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL

Line 307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL

303: , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL

Line 308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL

304: , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL

Line 309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL

305: , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL

Line 310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL

306: , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL

Line 311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL

307: , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL

Line 312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL

308: , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL

Line 313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL

309: , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL

Line 314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL

310: , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL

Line 315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL

311: , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL

Line 316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL

312: , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL

Line 317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL

313: , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL

Line 318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL

314: , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL

Line 319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL

315: , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL

Line 320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL

316: , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
324: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL

Line 321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL

317: , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
324: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
325: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL

Line 322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL

318: , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
324: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
325: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
326: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL

Line 323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL

319: , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
324: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
325: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
326: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
327: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL

Line 324: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL

320: , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
324: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
325: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
326: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
327: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
328: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'

Line 325: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL

321: , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
324: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
325: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
326: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
327: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
328: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
329: );

Line 326: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL

322: , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
324: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
325: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
326: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
327: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
328: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
329: );
330:

Line 327: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL

323: , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
324: , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
325: , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
326: , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
327: , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
328: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
329: );
330:
331:

Line 353: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE

349: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
350: , p_lot_rec IN lot_rec_typ
351: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
352: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
353: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
354: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
355: , x_return_status OUT NOCOPY VARCHAR2
356: , x_msg_count OUT NOCOPY NUMBER
357: , x_msg_data OUT NOCOPY VARCHAR2

Line 367: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE

363: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
364: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
365: , p_conv_rec IN GMIGAPI.conv_rec_typ
366: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
367: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
368: , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE
369: , x_return_status OUT NOCOPY VARCHAR2
370: , x_msg_count OUT NOCOPY NUMBER
371: , x_msg_data OUT NOCOPY VARCHAR2

Line 382: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE

378: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
379: , p_qty_rec IN GMIGAPI.qty_rec_typ
380: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
381: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
382: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
383: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
384: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE
385: , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%ROWTYPE
386: , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%ROWTYPE

Line 400: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE

396: , p_validation_level IN NUMBER
397: , p_xfer_rec IN GMIGAPI.xfer_rec_typ
398: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
399: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
400: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
401: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
402: , p_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
403: , x_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE
404: , x_return_status OUT NOCOPY VARCHAR2