APPS.GMIVDBL dependencies on IC_ITEM_MST

Line 53: | ic_item_mst_insert to GMIGAPIB.Create_Item. 2) Added |

49: | gmi_conv_audit_id_s. Was incorrectly calling |
50: | gmi_conv_audit_detail_id_s. |
51: | 11-Sep-2003 Teresa Wong B2378017 - Modified code to support new |
52: | classes. 1) Moved the call to gmi_item_categories from |
53: | ic_item_mst_insert to GMIGAPIB.Create_Item. 2) Added |
54: | p_item_rec parameter to gmi_item_categories. 3) Added |
55: | code to get category set information and to call |
56: | gmi_item_categories_insert. |
57: | 24-Feb-2004 Anoop Baddam B3151733 - Added a new procedure |

Line 75: FUNCTION ic_item_mst_insert

71:
72: /* All routines will update 'return_status' and 'error_text' in line */
73: /* with the return value from the database. */
74:
75: FUNCTION ic_item_mst_insert
76: (p_ic_item_mst_row IN ic_item_mst%ROWTYPE, x_ic_item_mst_row IN OUT NOCOPY ic_item_mst%ROWTYPE)
77: RETURN BOOLEAN
78: IS
79: BEGIN

Line 76: (p_ic_item_mst_row IN ic_item_mst%ROWTYPE, x_ic_item_mst_row IN OUT NOCOPY ic_item_mst%ROWTYPE)

72: /* All routines will update 'return_status' and 'error_text' in line */
73: /* with the return value from the database. */
74:
75: FUNCTION ic_item_mst_insert
76: (p_ic_item_mst_row IN ic_item_mst%ROWTYPE, x_ic_item_mst_row IN OUT NOCOPY ic_item_mst%ROWTYPE)
77: RETURN BOOLEAN
78: IS
79: BEGIN
80:

Line 83: x_ic_item_mst_row := p_ic_item_mst_row;

79: BEGIN
80:
81: /* Copy input record to output record */
82:
83: x_ic_item_mst_row := p_ic_item_mst_row;
84:
85: /* Fill in any missing surrogates; */
86: IF x_ic_item_mst_row.item_id IS NULL
87: THEN

Line 86: IF x_ic_item_mst_row.item_id IS NULL

82:
83: x_ic_item_mst_row := p_ic_item_mst_row;
84:
85: /* Fill in any missing surrogates; */
86: IF x_ic_item_mst_row.item_id IS NULL
87: THEN
88: SELECT gem5_item_id_s.nextval INTO x_ic_item_mst_row.item_id FROM dual;
89: END IF;
90:

Line 88: SELECT gem5_item_id_s.nextval INTO x_ic_item_mst_row.item_id FROM dual;

84:
85: /* Fill in any missing surrogates; */
86: IF x_ic_item_mst_row.item_id IS NULL
87: THEN
88: SELECT gem5_item_id_s.nextval INTO x_ic_item_mst_row.item_id FROM dual;
89: END IF;
90:
91: IF x_ic_item_mst_row.whse_item_id IS NULL
92: THEN

Line 91: IF x_ic_item_mst_row.whse_item_id IS NULL

87: THEN
88: SELECT gem5_item_id_s.nextval INTO x_ic_item_mst_row.item_id FROM dual;
89: END IF;
90:
91: IF x_ic_item_mst_row.whse_item_id IS NULL
92: THEN
93: x_ic_item_mst_row.whse_item_id := x_ic_item_mst_row.item_id;
94: END IF;
95:

Line 93: x_ic_item_mst_row.whse_item_id := x_ic_item_mst_row.item_id;

89: END IF;
90:
91: IF x_ic_item_mst_row.whse_item_id IS NULL
92: THEN
93: x_ic_item_mst_row.whse_item_id := x_ic_item_mst_row.item_id;
94: END IF;
95:
96:
97:

Line 98: INSERT INTO ic_item_mst

94: END IF;
95:
96:
97:
98: INSERT INTO ic_item_mst
99: ( item_id
100: , item_no
101: , item_desc1
102: , item_desc2

Line 197: ( x_ic_item_mst_row.item_id

193: , attribute_category
194: , ont_pricing_qty_source -- P Lowe Bug 2233859
195: )
196: VALUES
197: ( x_ic_item_mst_row.item_id
198: , x_ic_item_mst_row.item_no
199: , x_ic_item_mst_row.item_desc1
200: , x_ic_item_mst_row.item_desc2
201: , x_ic_item_mst_row.alt_itema

Line 198: , x_ic_item_mst_row.item_no

194: , ont_pricing_qty_source -- P Lowe Bug 2233859
195: )
196: VALUES
197: ( x_ic_item_mst_row.item_id
198: , x_ic_item_mst_row.item_no
199: , x_ic_item_mst_row.item_desc1
200: , x_ic_item_mst_row.item_desc2
201: , x_ic_item_mst_row.alt_itema
202: , x_ic_item_mst_row.alt_itemb

Line 199: , x_ic_item_mst_row.item_desc1

195: )
196: VALUES
197: ( x_ic_item_mst_row.item_id
198: , x_ic_item_mst_row.item_no
199: , x_ic_item_mst_row.item_desc1
200: , x_ic_item_mst_row.item_desc2
201: , x_ic_item_mst_row.alt_itema
202: , x_ic_item_mst_row.alt_itemb
203: , x_ic_item_mst_row.item_um

Line 200: , x_ic_item_mst_row.item_desc2

196: VALUES
197: ( x_ic_item_mst_row.item_id
198: , x_ic_item_mst_row.item_no
199: , x_ic_item_mst_row.item_desc1
200: , x_ic_item_mst_row.item_desc2
201: , x_ic_item_mst_row.alt_itema
202: , x_ic_item_mst_row.alt_itemb
203: , x_ic_item_mst_row.item_um
204: , x_ic_item_mst_row.dualum_ind

Line 201: , x_ic_item_mst_row.alt_itema

197: ( x_ic_item_mst_row.item_id
198: , x_ic_item_mst_row.item_no
199: , x_ic_item_mst_row.item_desc1
200: , x_ic_item_mst_row.item_desc2
201: , x_ic_item_mst_row.alt_itema
202: , x_ic_item_mst_row.alt_itemb
203: , x_ic_item_mst_row.item_um
204: , x_ic_item_mst_row.dualum_ind
205: , x_ic_item_mst_row.item_um2

Line 202: , x_ic_item_mst_row.alt_itemb

198: , x_ic_item_mst_row.item_no
199: , x_ic_item_mst_row.item_desc1
200: , x_ic_item_mst_row.item_desc2
201: , x_ic_item_mst_row.alt_itema
202: , x_ic_item_mst_row.alt_itemb
203: , x_ic_item_mst_row.item_um
204: , x_ic_item_mst_row.dualum_ind
205: , x_ic_item_mst_row.item_um2
206: , x_ic_item_mst_row.deviation_lo

Line 203: , x_ic_item_mst_row.item_um

199: , x_ic_item_mst_row.item_desc1
200: , x_ic_item_mst_row.item_desc2
201: , x_ic_item_mst_row.alt_itema
202: , x_ic_item_mst_row.alt_itemb
203: , x_ic_item_mst_row.item_um
204: , x_ic_item_mst_row.dualum_ind
205: , x_ic_item_mst_row.item_um2
206: , x_ic_item_mst_row.deviation_lo
207: , x_ic_item_mst_row.deviation_hi

Line 204: , x_ic_item_mst_row.dualum_ind

200: , x_ic_item_mst_row.item_desc2
201: , x_ic_item_mst_row.alt_itema
202: , x_ic_item_mst_row.alt_itemb
203: , x_ic_item_mst_row.item_um
204: , x_ic_item_mst_row.dualum_ind
205: , x_ic_item_mst_row.item_um2
206: , x_ic_item_mst_row.deviation_lo
207: , x_ic_item_mst_row.deviation_hi
208: , x_ic_item_mst_row.level_code

Line 205: , x_ic_item_mst_row.item_um2

201: , x_ic_item_mst_row.alt_itema
202: , x_ic_item_mst_row.alt_itemb
203: , x_ic_item_mst_row.item_um
204: , x_ic_item_mst_row.dualum_ind
205: , x_ic_item_mst_row.item_um2
206: , x_ic_item_mst_row.deviation_lo
207: , x_ic_item_mst_row.deviation_hi
208: , x_ic_item_mst_row.level_code
209: , x_ic_item_mst_row.lot_ctl

Line 206: , x_ic_item_mst_row.deviation_lo

202: , x_ic_item_mst_row.alt_itemb
203: , x_ic_item_mst_row.item_um
204: , x_ic_item_mst_row.dualum_ind
205: , x_ic_item_mst_row.item_um2
206: , x_ic_item_mst_row.deviation_lo
207: , x_ic_item_mst_row.deviation_hi
208: , x_ic_item_mst_row.level_code
209: , x_ic_item_mst_row.lot_ctl
210: , x_ic_item_mst_row.lot_indivisible

Line 207: , x_ic_item_mst_row.deviation_hi

203: , x_ic_item_mst_row.item_um
204: , x_ic_item_mst_row.dualum_ind
205: , x_ic_item_mst_row.item_um2
206: , x_ic_item_mst_row.deviation_lo
207: , x_ic_item_mst_row.deviation_hi
208: , x_ic_item_mst_row.level_code
209: , x_ic_item_mst_row.lot_ctl
210: , x_ic_item_mst_row.lot_indivisible
211: , x_ic_item_mst_row.sublot_ctl

Line 208: , x_ic_item_mst_row.level_code

204: , x_ic_item_mst_row.dualum_ind
205: , x_ic_item_mst_row.item_um2
206: , x_ic_item_mst_row.deviation_lo
207: , x_ic_item_mst_row.deviation_hi
208: , x_ic_item_mst_row.level_code
209: , x_ic_item_mst_row.lot_ctl
210: , x_ic_item_mst_row.lot_indivisible
211: , x_ic_item_mst_row.sublot_ctl
212: , x_ic_item_mst_row.loct_ctl

Line 209: , x_ic_item_mst_row.lot_ctl

205: , x_ic_item_mst_row.item_um2
206: , x_ic_item_mst_row.deviation_lo
207: , x_ic_item_mst_row.deviation_hi
208: , x_ic_item_mst_row.level_code
209: , x_ic_item_mst_row.lot_ctl
210: , x_ic_item_mst_row.lot_indivisible
211: , x_ic_item_mst_row.sublot_ctl
212: , x_ic_item_mst_row.loct_ctl
213: , x_ic_item_mst_row.noninv_ind

Line 210: , x_ic_item_mst_row.lot_indivisible

206: , x_ic_item_mst_row.deviation_lo
207: , x_ic_item_mst_row.deviation_hi
208: , x_ic_item_mst_row.level_code
209: , x_ic_item_mst_row.lot_ctl
210: , x_ic_item_mst_row.lot_indivisible
211: , x_ic_item_mst_row.sublot_ctl
212: , x_ic_item_mst_row.loct_ctl
213: , x_ic_item_mst_row.noninv_ind
214: , x_ic_item_mst_row.match_type

Line 211: , x_ic_item_mst_row.sublot_ctl

207: , x_ic_item_mst_row.deviation_hi
208: , x_ic_item_mst_row.level_code
209: , x_ic_item_mst_row.lot_ctl
210: , x_ic_item_mst_row.lot_indivisible
211: , x_ic_item_mst_row.sublot_ctl
212: , x_ic_item_mst_row.loct_ctl
213: , x_ic_item_mst_row.noninv_ind
214: , x_ic_item_mst_row.match_type
215: , x_ic_item_mst_row.inactive_ind

Line 212: , x_ic_item_mst_row.loct_ctl

208: , x_ic_item_mst_row.level_code
209: , x_ic_item_mst_row.lot_ctl
210: , x_ic_item_mst_row.lot_indivisible
211: , x_ic_item_mst_row.sublot_ctl
212: , x_ic_item_mst_row.loct_ctl
213: , x_ic_item_mst_row.noninv_ind
214: , x_ic_item_mst_row.match_type
215: , x_ic_item_mst_row.inactive_ind
216: , x_ic_item_mst_row.inv_type

Line 213: , x_ic_item_mst_row.noninv_ind

209: , x_ic_item_mst_row.lot_ctl
210: , x_ic_item_mst_row.lot_indivisible
211: , x_ic_item_mst_row.sublot_ctl
212: , x_ic_item_mst_row.loct_ctl
213: , x_ic_item_mst_row.noninv_ind
214: , x_ic_item_mst_row.match_type
215: , x_ic_item_mst_row.inactive_ind
216: , x_ic_item_mst_row.inv_type
217: , x_ic_item_mst_row.shelf_life

Line 214: , x_ic_item_mst_row.match_type

210: , x_ic_item_mst_row.lot_indivisible
211: , x_ic_item_mst_row.sublot_ctl
212: , x_ic_item_mst_row.loct_ctl
213: , x_ic_item_mst_row.noninv_ind
214: , x_ic_item_mst_row.match_type
215: , x_ic_item_mst_row.inactive_ind
216: , x_ic_item_mst_row.inv_type
217: , x_ic_item_mst_row.shelf_life
218: , x_ic_item_mst_row.retest_interval

Line 215: , x_ic_item_mst_row.inactive_ind

211: , x_ic_item_mst_row.sublot_ctl
212: , x_ic_item_mst_row.loct_ctl
213: , x_ic_item_mst_row.noninv_ind
214: , x_ic_item_mst_row.match_type
215: , x_ic_item_mst_row.inactive_ind
216: , x_ic_item_mst_row.inv_type
217: , x_ic_item_mst_row.shelf_life
218: , x_ic_item_mst_row.retest_interval
219: , x_ic_item_mst_row.item_abccode

Line 216: , x_ic_item_mst_row.inv_type

212: , x_ic_item_mst_row.loct_ctl
213: , x_ic_item_mst_row.noninv_ind
214: , x_ic_item_mst_row.match_type
215: , x_ic_item_mst_row.inactive_ind
216: , x_ic_item_mst_row.inv_type
217: , x_ic_item_mst_row.shelf_life
218: , x_ic_item_mst_row.retest_interval
219: , x_ic_item_mst_row.item_abccode
220: , x_ic_item_mst_row.gl_class

Line 217: , x_ic_item_mst_row.shelf_life

213: , x_ic_item_mst_row.noninv_ind
214: , x_ic_item_mst_row.match_type
215: , x_ic_item_mst_row.inactive_ind
216: , x_ic_item_mst_row.inv_type
217: , x_ic_item_mst_row.shelf_life
218: , x_ic_item_mst_row.retest_interval
219: , x_ic_item_mst_row.item_abccode
220: , x_ic_item_mst_row.gl_class
221: , x_ic_item_mst_row.inv_class

Line 218: , x_ic_item_mst_row.retest_interval

214: , x_ic_item_mst_row.match_type
215: , x_ic_item_mst_row.inactive_ind
216: , x_ic_item_mst_row.inv_type
217: , x_ic_item_mst_row.shelf_life
218: , x_ic_item_mst_row.retest_interval
219: , x_ic_item_mst_row.item_abccode
220: , x_ic_item_mst_row.gl_class
221: , x_ic_item_mst_row.inv_class
222: , x_ic_item_mst_row.sales_class

Line 219: , x_ic_item_mst_row.item_abccode

215: , x_ic_item_mst_row.inactive_ind
216: , x_ic_item_mst_row.inv_type
217: , x_ic_item_mst_row.shelf_life
218: , x_ic_item_mst_row.retest_interval
219: , x_ic_item_mst_row.item_abccode
220: , x_ic_item_mst_row.gl_class
221: , x_ic_item_mst_row.inv_class
222: , x_ic_item_mst_row.sales_class
223: , x_ic_item_mst_row.ship_class

Line 220: , x_ic_item_mst_row.gl_class

216: , x_ic_item_mst_row.inv_type
217: , x_ic_item_mst_row.shelf_life
218: , x_ic_item_mst_row.retest_interval
219: , x_ic_item_mst_row.item_abccode
220: , x_ic_item_mst_row.gl_class
221: , x_ic_item_mst_row.inv_class
222: , x_ic_item_mst_row.sales_class
223: , x_ic_item_mst_row.ship_class
224: , x_ic_item_mst_row.frt_class

Line 221: , x_ic_item_mst_row.inv_class

217: , x_ic_item_mst_row.shelf_life
218: , x_ic_item_mst_row.retest_interval
219: , x_ic_item_mst_row.item_abccode
220: , x_ic_item_mst_row.gl_class
221: , x_ic_item_mst_row.inv_class
222: , x_ic_item_mst_row.sales_class
223: , x_ic_item_mst_row.ship_class
224: , x_ic_item_mst_row.frt_class
225: , x_ic_item_mst_row.price_class

Line 222: , x_ic_item_mst_row.sales_class

218: , x_ic_item_mst_row.retest_interval
219: , x_ic_item_mst_row.item_abccode
220: , x_ic_item_mst_row.gl_class
221: , x_ic_item_mst_row.inv_class
222: , x_ic_item_mst_row.sales_class
223: , x_ic_item_mst_row.ship_class
224: , x_ic_item_mst_row.frt_class
225: , x_ic_item_mst_row.price_class
226: , x_ic_item_mst_row.storage_class

Line 223: , x_ic_item_mst_row.ship_class

219: , x_ic_item_mst_row.item_abccode
220: , x_ic_item_mst_row.gl_class
221: , x_ic_item_mst_row.inv_class
222: , x_ic_item_mst_row.sales_class
223: , x_ic_item_mst_row.ship_class
224: , x_ic_item_mst_row.frt_class
225: , x_ic_item_mst_row.price_class
226: , x_ic_item_mst_row.storage_class
227: , x_ic_item_mst_row.purch_class

Line 224: , x_ic_item_mst_row.frt_class

220: , x_ic_item_mst_row.gl_class
221: , x_ic_item_mst_row.inv_class
222: , x_ic_item_mst_row.sales_class
223: , x_ic_item_mst_row.ship_class
224: , x_ic_item_mst_row.frt_class
225: , x_ic_item_mst_row.price_class
226: , x_ic_item_mst_row.storage_class
227: , x_ic_item_mst_row.purch_class
228: , x_ic_item_mst_row.tax_class

Line 225: , x_ic_item_mst_row.price_class

221: , x_ic_item_mst_row.inv_class
222: , x_ic_item_mst_row.sales_class
223: , x_ic_item_mst_row.ship_class
224: , x_ic_item_mst_row.frt_class
225: , x_ic_item_mst_row.price_class
226: , x_ic_item_mst_row.storage_class
227: , x_ic_item_mst_row.purch_class
228: , x_ic_item_mst_row.tax_class
229: , x_ic_item_mst_row.customs_class

Line 226: , x_ic_item_mst_row.storage_class

222: , x_ic_item_mst_row.sales_class
223: , x_ic_item_mst_row.ship_class
224: , x_ic_item_mst_row.frt_class
225: , x_ic_item_mst_row.price_class
226: , x_ic_item_mst_row.storage_class
227: , x_ic_item_mst_row.purch_class
228: , x_ic_item_mst_row.tax_class
229: , x_ic_item_mst_row.customs_class
230: , x_ic_item_mst_row.alloc_class

Line 227: , x_ic_item_mst_row.purch_class

223: , x_ic_item_mst_row.ship_class
224: , x_ic_item_mst_row.frt_class
225: , x_ic_item_mst_row.price_class
226: , x_ic_item_mst_row.storage_class
227: , x_ic_item_mst_row.purch_class
228: , x_ic_item_mst_row.tax_class
229: , x_ic_item_mst_row.customs_class
230: , x_ic_item_mst_row.alloc_class
231: , x_ic_item_mst_row.planning_class

Line 228: , x_ic_item_mst_row.tax_class

224: , x_ic_item_mst_row.frt_class
225: , x_ic_item_mst_row.price_class
226: , x_ic_item_mst_row.storage_class
227: , x_ic_item_mst_row.purch_class
228: , x_ic_item_mst_row.tax_class
229: , x_ic_item_mst_row.customs_class
230: , x_ic_item_mst_row.alloc_class
231: , x_ic_item_mst_row.planning_class
232: , x_ic_item_mst_row.itemcost_class

Line 229: , x_ic_item_mst_row.customs_class

225: , x_ic_item_mst_row.price_class
226: , x_ic_item_mst_row.storage_class
227: , x_ic_item_mst_row.purch_class
228: , x_ic_item_mst_row.tax_class
229: , x_ic_item_mst_row.customs_class
230: , x_ic_item_mst_row.alloc_class
231: , x_ic_item_mst_row.planning_class
232: , x_ic_item_mst_row.itemcost_class
233: , x_ic_item_mst_row.cost_mthd_code

Line 230: , x_ic_item_mst_row.alloc_class

226: , x_ic_item_mst_row.storage_class
227: , x_ic_item_mst_row.purch_class
228: , x_ic_item_mst_row.tax_class
229: , x_ic_item_mst_row.customs_class
230: , x_ic_item_mst_row.alloc_class
231: , x_ic_item_mst_row.planning_class
232: , x_ic_item_mst_row.itemcost_class
233: , x_ic_item_mst_row.cost_mthd_code
234: , x_ic_item_mst_row.upc_code

Line 231: , x_ic_item_mst_row.planning_class

227: , x_ic_item_mst_row.purch_class
228: , x_ic_item_mst_row.tax_class
229: , x_ic_item_mst_row.customs_class
230: , x_ic_item_mst_row.alloc_class
231: , x_ic_item_mst_row.planning_class
232: , x_ic_item_mst_row.itemcost_class
233: , x_ic_item_mst_row.cost_mthd_code
234: , x_ic_item_mst_row.upc_code
235: , x_ic_item_mst_row.grade_ctl

Line 232: , x_ic_item_mst_row.itemcost_class

228: , x_ic_item_mst_row.tax_class
229: , x_ic_item_mst_row.customs_class
230: , x_ic_item_mst_row.alloc_class
231: , x_ic_item_mst_row.planning_class
232: , x_ic_item_mst_row.itemcost_class
233: , x_ic_item_mst_row.cost_mthd_code
234: , x_ic_item_mst_row.upc_code
235: , x_ic_item_mst_row.grade_ctl
236: , x_ic_item_mst_row.status_ctl

Line 233: , x_ic_item_mst_row.cost_mthd_code

229: , x_ic_item_mst_row.customs_class
230: , x_ic_item_mst_row.alloc_class
231: , x_ic_item_mst_row.planning_class
232: , x_ic_item_mst_row.itemcost_class
233: , x_ic_item_mst_row.cost_mthd_code
234: , x_ic_item_mst_row.upc_code
235: , x_ic_item_mst_row.grade_ctl
236: , x_ic_item_mst_row.status_ctl
237: , x_ic_item_mst_row.qc_grade

Line 234: , x_ic_item_mst_row.upc_code

230: , x_ic_item_mst_row.alloc_class
231: , x_ic_item_mst_row.planning_class
232: , x_ic_item_mst_row.itemcost_class
233: , x_ic_item_mst_row.cost_mthd_code
234: , x_ic_item_mst_row.upc_code
235: , x_ic_item_mst_row.grade_ctl
236: , x_ic_item_mst_row.status_ctl
237: , x_ic_item_mst_row.qc_grade
238: , x_ic_item_mst_row.lot_status

Line 235: , x_ic_item_mst_row.grade_ctl

231: , x_ic_item_mst_row.planning_class
232: , x_ic_item_mst_row.itemcost_class
233: , x_ic_item_mst_row.cost_mthd_code
234: , x_ic_item_mst_row.upc_code
235: , x_ic_item_mst_row.grade_ctl
236: , x_ic_item_mst_row.status_ctl
237: , x_ic_item_mst_row.qc_grade
238: , x_ic_item_mst_row.lot_status
239: , x_ic_item_mst_row.bulk_id

Line 236: , x_ic_item_mst_row.status_ctl

232: , x_ic_item_mst_row.itemcost_class
233: , x_ic_item_mst_row.cost_mthd_code
234: , x_ic_item_mst_row.upc_code
235: , x_ic_item_mst_row.grade_ctl
236: , x_ic_item_mst_row.status_ctl
237: , x_ic_item_mst_row.qc_grade
238: , x_ic_item_mst_row.lot_status
239: , x_ic_item_mst_row.bulk_id
240: , x_ic_item_mst_row.pkg_id

Line 237: , x_ic_item_mst_row.qc_grade

233: , x_ic_item_mst_row.cost_mthd_code
234: , x_ic_item_mst_row.upc_code
235: , x_ic_item_mst_row.grade_ctl
236: , x_ic_item_mst_row.status_ctl
237: , x_ic_item_mst_row.qc_grade
238: , x_ic_item_mst_row.lot_status
239: , x_ic_item_mst_row.bulk_id
240: , x_ic_item_mst_row.pkg_id
241: , x_ic_item_mst_row.qcitem_id

Line 238: , x_ic_item_mst_row.lot_status

234: , x_ic_item_mst_row.upc_code
235: , x_ic_item_mst_row.grade_ctl
236: , x_ic_item_mst_row.status_ctl
237: , x_ic_item_mst_row.qc_grade
238: , x_ic_item_mst_row.lot_status
239: , x_ic_item_mst_row.bulk_id
240: , x_ic_item_mst_row.pkg_id
241: , x_ic_item_mst_row.qcitem_id
242: , x_ic_item_mst_row.qchold_res_code

Line 239: , x_ic_item_mst_row.bulk_id

235: , x_ic_item_mst_row.grade_ctl
236: , x_ic_item_mst_row.status_ctl
237: , x_ic_item_mst_row.qc_grade
238: , x_ic_item_mst_row.lot_status
239: , x_ic_item_mst_row.bulk_id
240: , x_ic_item_mst_row.pkg_id
241: , x_ic_item_mst_row.qcitem_id
242: , x_ic_item_mst_row.qchold_res_code
243: , x_ic_item_mst_row.expaction_code

Line 240: , x_ic_item_mst_row.pkg_id

236: , x_ic_item_mst_row.status_ctl
237: , x_ic_item_mst_row.qc_grade
238: , x_ic_item_mst_row.lot_status
239: , x_ic_item_mst_row.bulk_id
240: , x_ic_item_mst_row.pkg_id
241: , x_ic_item_mst_row.qcitem_id
242: , x_ic_item_mst_row.qchold_res_code
243: , x_ic_item_mst_row.expaction_code
244: , x_ic_item_mst_row.fill_qty

Line 241: , x_ic_item_mst_row.qcitem_id

237: , x_ic_item_mst_row.qc_grade
238: , x_ic_item_mst_row.lot_status
239: , x_ic_item_mst_row.bulk_id
240: , x_ic_item_mst_row.pkg_id
241: , x_ic_item_mst_row.qcitem_id
242: , x_ic_item_mst_row.qchold_res_code
243: , x_ic_item_mst_row.expaction_code
244: , x_ic_item_mst_row.fill_qty
245: , x_ic_item_mst_row.fill_um

Line 242: , x_ic_item_mst_row.qchold_res_code

238: , x_ic_item_mst_row.lot_status
239: , x_ic_item_mst_row.bulk_id
240: , x_ic_item_mst_row.pkg_id
241: , x_ic_item_mst_row.qcitem_id
242: , x_ic_item_mst_row.qchold_res_code
243: , x_ic_item_mst_row.expaction_code
244: , x_ic_item_mst_row.fill_qty
245: , x_ic_item_mst_row.fill_um
246: , x_ic_item_mst_row.expaction_interval

Line 243: , x_ic_item_mst_row.expaction_code

239: , x_ic_item_mst_row.bulk_id
240: , x_ic_item_mst_row.pkg_id
241: , x_ic_item_mst_row.qcitem_id
242: , x_ic_item_mst_row.qchold_res_code
243: , x_ic_item_mst_row.expaction_code
244: , x_ic_item_mst_row.fill_qty
245: , x_ic_item_mst_row.fill_um
246: , x_ic_item_mst_row.expaction_interval
247: , x_ic_item_mst_row.phantom_type

Line 244: , x_ic_item_mst_row.fill_qty

240: , x_ic_item_mst_row.pkg_id
241: , x_ic_item_mst_row.qcitem_id
242: , x_ic_item_mst_row.qchold_res_code
243: , x_ic_item_mst_row.expaction_code
244: , x_ic_item_mst_row.fill_qty
245: , x_ic_item_mst_row.fill_um
246: , x_ic_item_mst_row.expaction_interval
247: , x_ic_item_mst_row.phantom_type
248: , x_ic_item_mst_row.whse_item_id

Line 245: , x_ic_item_mst_row.fill_um

241: , x_ic_item_mst_row.qcitem_id
242: , x_ic_item_mst_row.qchold_res_code
243: , x_ic_item_mst_row.expaction_code
244: , x_ic_item_mst_row.fill_qty
245: , x_ic_item_mst_row.fill_um
246: , x_ic_item_mst_row.expaction_interval
247: , x_ic_item_mst_row.phantom_type
248: , x_ic_item_mst_row.whse_item_id
249: , x_ic_item_mst_row.experimental_ind

Line 246: , x_ic_item_mst_row.expaction_interval

242: , x_ic_item_mst_row.qchold_res_code
243: , x_ic_item_mst_row.expaction_code
244: , x_ic_item_mst_row.fill_qty
245: , x_ic_item_mst_row.fill_um
246: , x_ic_item_mst_row.expaction_interval
247: , x_ic_item_mst_row.phantom_type
248: , x_ic_item_mst_row.whse_item_id
249: , x_ic_item_mst_row.experimental_ind
250: , x_ic_item_mst_row.exported_date

Line 247: , x_ic_item_mst_row.phantom_type

243: , x_ic_item_mst_row.expaction_code
244: , x_ic_item_mst_row.fill_qty
245: , x_ic_item_mst_row.fill_um
246: , x_ic_item_mst_row.expaction_interval
247: , x_ic_item_mst_row.phantom_type
248: , x_ic_item_mst_row.whse_item_id
249: , x_ic_item_mst_row.experimental_ind
250: , x_ic_item_mst_row.exported_date
251: , x_ic_item_mst_row.created_by

Line 248: , x_ic_item_mst_row.whse_item_id

244: , x_ic_item_mst_row.fill_qty
245: , x_ic_item_mst_row.fill_um
246: , x_ic_item_mst_row.expaction_interval
247: , x_ic_item_mst_row.phantom_type
248: , x_ic_item_mst_row.whse_item_id
249: , x_ic_item_mst_row.experimental_ind
250: , x_ic_item_mst_row.exported_date
251: , x_ic_item_mst_row.created_by
252: , x_ic_item_mst_row.creation_date

Line 249: , x_ic_item_mst_row.experimental_ind

245: , x_ic_item_mst_row.fill_um
246: , x_ic_item_mst_row.expaction_interval
247: , x_ic_item_mst_row.phantom_type
248: , x_ic_item_mst_row.whse_item_id
249: , x_ic_item_mst_row.experimental_ind
250: , x_ic_item_mst_row.exported_date
251: , x_ic_item_mst_row.created_by
252: , x_ic_item_mst_row.creation_date
253: , x_ic_item_mst_row.last_updated_by

Line 250: , x_ic_item_mst_row.exported_date

246: , x_ic_item_mst_row.expaction_interval
247: , x_ic_item_mst_row.phantom_type
248: , x_ic_item_mst_row.whse_item_id
249: , x_ic_item_mst_row.experimental_ind
250: , x_ic_item_mst_row.exported_date
251: , x_ic_item_mst_row.created_by
252: , x_ic_item_mst_row.creation_date
253: , x_ic_item_mst_row.last_updated_by
254: , x_ic_item_mst_row.last_update_date

Line 251: , x_ic_item_mst_row.created_by

247: , x_ic_item_mst_row.phantom_type
248: , x_ic_item_mst_row.whse_item_id
249: , x_ic_item_mst_row.experimental_ind
250: , x_ic_item_mst_row.exported_date
251: , x_ic_item_mst_row.created_by
252: , x_ic_item_mst_row.creation_date
253: , x_ic_item_mst_row.last_updated_by
254: , x_ic_item_mst_row.last_update_date
255: , x_ic_item_mst_row.last_update_login

Line 252: , x_ic_item_mst_row.creation_date

248: , x_ic_item_mst_row.whse_item_id
249: , x_ic_item_mst_row.experimental_ind
250: , x_ic_item_mst_row.exported_date
251: , x_ic_item_mst_row.created_by
252: , x_ic_item_mst_row.creation_date
253: , x_ic_item_mst_row.last_updated_by
254: , x_ic_item_mst_row.last_update_date
255: , x_ic_item_mst_row.last_update_login
256: , x_ic_item_mst_row.trans_cnt

Line 253: , x_ic_item_mst_row.last_updated_by

249: , x_ic_item_mst_row.experimental_ind
250: , x_ic_item_mst_row.exported_date
251: , x_ic_item_mst_row.created_by
252: , x_ic_item_mst_row.creation_date
253: , x_ic_item_mst_row.last_updated_by
254: , x_ic_item_mst_row.last_update_date
255: , x_ic_item_mst_row.last_update_login
256: , x_ic_item_mst_row.trans_cnt
257: , x_ic_item_mst_row.delete_mark

Line 254: , x_ic_item_mst_row.last_update_date

250: , x_ic_item_mst_row.exported_date
251: , x_ic_item_mst_row.created_by
252: , x_ic_item_mst_row.creation_date
253: , x_ic_item_mst_row.last_updated_by
254: , x_ic_item_mst_row.last_update_date
255: , x_ic_item_mst_row.last_update_login
256: , x_ic_item_mst_row.trans_cnt
257: , x_ic_item_mst_row.delete_mark
258: , x_ic_item_mst_row.text_code

Line 255: , x_ic_item_mst_row.last_update_login

251: , x_ic_item_mst_row.created_by
252: , x_ic_item_mst_row.creation_date
253: , x_ic_item_mst_row.last_updated_by
254: , x_ic_item_mst_row.last_update_date
255: , x_ic_item_mst_row.last_update_login
256: , x_ic_item_mst_row.trans_cnt
257: , x_ic_item_mst_row.delete_mark
258: , x_ic_item_mst_row.text_code
259: , x_ic_item_mst_row.seq_dpnd_class

Line 256: , x_ic_item_mst_row.trans_cnt

252: , x_ic_item_mst_row.creation_date
253: , x_ic_item_mst_row.last_updated_by
254: , x_ic_item_mst_row.last_update_date
255: , x_ic_item_mst_row.last_update_login
256: , x_ic_item_mst_row.trans_cnt
257: , x_ic_item_mst_row.delete_mark
258: , x_ic_item_mst_row.text_code
259: , x_ic_item_mst_row.seq_dpnd_class
260: , x_ic_item_mst_row.commodity_code

Line 257: , x_ic_item_mst_row.delete_mark

253: , x_ic_item_mst_row.last_updated_by
254: , x_ic_item_mst_row.last_update_date
255: , x_ic_item_mst_row.last_update_login
256: , x_ic_item_mst_row.trans_cnt
257: , x_ic_item_mst_row.delete_mark
258: , x_ic_item_mst_row.text_code
259: , x_ic_item_mst_row.seq_dpnd_class
260: , x_ic_item_mst_row.commodity_code
261: , x_ic_item_mst_row.attribute1

Line 258: , x_ic_item_mst_row.text_code

254: , x_ic_item_mst_row.last_update_date
255: , x_ic_item_mst_row.last_update_login
256: , x_ic_item_mst_row.trans_cnt
257: , x_ic_item_mst_row.delete_mark
258: , x_ic_item_mst_row.text_code
259: , x_ic_item_mst_row.seq_dpnd_class
260: , x_ic_item_mst_row.commodity_code
261: , x_ic_item_mst_row.attribute1
262: , x_ic_item_mst_row.attribute2

Line 259: , x_ic_item_mst_row.seq_dpnd_class

255: , x_ic_item_mst_row.last_update_login
256: , x_ic_item_mst_row.trans_cnt
257: , x_ic_item_mst_row.delete_mark
258: , x_ic_item_mst_row.text_code
259: , x_ic_item_mst_row.seq_dpnd_class
260: , x_ic_item_mst_row.commodity_code
261: , x_ic_item_mst_row.attribute1
262: , x_ic_item_mst_row.attribute2
263: , x_ic_item_mst_row.attribute3

Line 260: , x_ic_item_mst_row.commodity_code

256: , x_ic_item_mst_row.trans_cnt
257: , x_ic_item_mst_row.delete_mark
258: , x_ic_item_mst_row.text_code
259: , x_ic_item_mst_row.seq_dpnd_class
260: , x_ic_item_mst_row.commodity_code
261: , x_ic_item_mst_row.attribute1
262: , x_ic_item_mst_row.attribute2
263: , x_ic_item_mst_row.attribute3
264: , x_ic_item_mst_row.attribute4

Line 261: , x_ic_item_mst_row.attribute1

257: , x_ic_item_mst_row.delete_mark
258: , x_ic_item_mst_row.text_code
259: , x_ic_item_mst_row.seq_dpnd_class
260: , x_ic_item_mst_row.commodity_code
261: , x_ic_item_mst_row.attribute1
262: , x_ic_item_mst_row.attribute2
263: , x_ic_item_mst_row.attribute3
264: , x_ic_item_mst_row.attribute4
265: , x_ic_item_mst_row.attribute5

Line 262: , x_ic_item_mst_row.attribute2

258: , x_ic_item_mst_row.text_code
259: , x_ic_item_mst_row.seq_dpnd_class
260: , x_ic_item_mst_row.commodity_code
261: , x_ic_item_mst_row.attribute1
262: , x_ic_item_mst_row.attribute2
263: , x_ic_item_mst_row.attribute3
264: , x_ic_item_mst_row.attribute4
265: , x_ic_item_mst_row.attribute5
266: , x_ic_item_mst_row.attribute6

Line 263: , x_ic_item_mst_row.attribute3

259: , x_ic_item_mst_row.seq_dpnd_class
260: , x_ic_item_mst_row.commodity_code
261: , x_ic_item_mst_row.attribute1
262: , x_ic_item_mst_row.attribute2
263: , x_ic_item_mst_row.attribute3
264: , x_ic_item_mst_row.attribute4
265: , x_ic_item_mst_row.attribute5
266: , x_ic_item_mst_row.attribute6
267: , x_ic_item_mst_row.attribute7

Line 264: , x_ic_item_mst_row.attribute4

260: , x_ic_item_mst_row.commodity_code
261: , x_ic_item_mst_row.attribute1
262: , x_ic_item_mst_row.attribute2
263: , x_ic_item_mst_row.attribute3
264: , x_ic_item_mst_row.attribute4
265: , x_ic_item_mst_row.attribute5
266: , x_ic_item_mst_row.attribute6
267: , x_ic_item_mst_row.attribute7
268: , x_ic_item_mst_row.attribute8

Line 265: , x_ic_item_mst_row.attribute5

261: , x_ic_item_mst_row.attribute1
262: , x_ic_item_mst_row.attribute2
263: , x_ic_item_mst_row.attribute3
264: , x_ic_item_mst_row.attribute4
265: , x_ic_item_mst_row.attribute5
266: , x_ic_item_mst_row.attribute6
267: , x_ic_item_mst_row.attribute7
268: , x_ic_item_mst_row.attribute8
269: , x_ic_item_mst_row.attribute9

Line 266: , x_ic_item_mst_row.attribute6

262: , x_ic_item_mst_row.attribute2
263: , x_ic_item_mst_row.attribute3
264: , x_ic_item_mst_row.attribute4
265: , x_ic_item_mst_row.attribute5
266: , x_ic_item_mst_row.attribute6
267: , x_ic_item_mst_row.attribute7
268: , x_ic_item_mst_row.attribute8
269: , x_ic_item_mst_row.attribute9
270: , x_ic_item_mst_row.attribute10

Line 267: , x_ic_item_mst_row.attribute7

263: , x_ic_item_mst_row.attribute3
264: , x_ic_item_mst_row.attribute4
265: , x_ic_item_mst_row.attribute5
266: , x_ic_item_mst_row.attribute6
267: , x_ic_item_mst_row.attribute7
268: , x_ic_item_mst_row.attribute8
269: , x_ic_item_mst_row.attribute9
270: , x_ic_item_mst_row.attribute10
271: , x_ic_item_mst_row.attribute11

Line 268: , x_ic_item_mst_row.attribute8

264: , x_ic_item_mst_row.attribute4
265: , x_ic_item_mst_row.attribute5
266: , x_ic_item_mst_row.attribute6
267: , x_ic_item_mst_row.attribute7
268: , x_ic_item_mst_row.attribute8
269: , x_ic_item_mst_row.attribute9
270: , x_ic_item_mst_row.attribute10
271: , x_ic_item_mst_row.attribute11
272: , x_ic_item_mst_row.attribute12

Line 269: , x_ic_item_mst_row.attribute9

265: , x_ic_item_mst_row.attribute5
266: , x_ic_item_mst_row.attribute6
267: , x_ic_item_mst_row.attribute7
268: , x_ic_item_mst_row.attribute8
269: , x_ic_item_mst_row.attribute9
270: , x_ic_item_mst_row.attribute10
271: , x_ic_item_mst_row.attribute11
272: , x_ic_item_mst_row.attribute12
273: , x_ic_item_mst_row.attribute13

Line 270: , x_ic_item_mst_row.attribute10

266: , x_ic_item_mst_row.attribute6
267: , x_ic_item_mst_row.attribute7
268: , x_ic_item_mst_row.attribute8
269: , x_ic_item_mst_row.attribute9
270: , x_ic_item_mst_row.attribute10
271: , x_ic_item_mst_row.attribute11
272: , x_ic_item_mst_row.attribute12
273: , x_ic_item_mst_row.attribute13
274: , x_ic_item_mst_row.attribute14

Line 271: , x_ic_item_mst_row.attribute11

267: , x_ic_item_mst_row.attribute7
268: , x_ic_item_mst_row.attribute8
269: , x_ic_item_mst_row.attribute9
270: , x_ic_item_mst_row.attribute10
271: , x_ic_item_mst_row.attribute11
272: , x_ic_item_mst_row.attribute12
273: , x_ic_item_mst_row.attribute13
274: , x_ic_item_mst_row.attribute14
275: , x_ic_item_mst_row.attribute15

Line 272: , x_ic_item_mst_row.attribute12

268: , x_ic_item_mst_row.attribute8
269: , x_ic_item_mst_row.attribute9
270: , x_ic_item_mst_row.attribute10
271: , x_ic_item_mst_row.attribute11
272: , x_ic_item_mst_row.attribute12
273: , x_ic_item_mst_row.attribute13
274: , x_ic_item_mst_row.attribute14
275: , x_ic_item_mst_row.attribute15
276: , x_ic_item_mst_row.attribute16

Line 273: , x_ic_item_mst_row.attribute13

269: , x_ic_item_mst_row.attribute9
270: , x_ic_item_mst_row.attribute10
271: , x_ic_item_mst_row.attribute11
272: , x_ic_item_mst_row.attribute12
273: , x_ic_item_mst_row.attribute13
274: , x_ic_item_mst_row.attribute14
275: , x_ic_item_mst_row.attribute15
276: , x_ic_item_mst_row.attribute16
277: , x_ic_item_mst_row.attribute17

Line 274: , x_ic_item_mst_row.attribute14

270: , x_ic_item_mst_row.attribute10
271: , x_ic_item_mst_row.attribute11
272: , x_ic_item_mst_row.attribute12
273: , x_ic_item_mst_row.attribute13
274: , x_ic_item_mst_row.attribute14
275: , x_ic_item_mst_row.attribute15
276: , x_ic_item_mst_row.attribute16
277: , x_ic_item_mst_row.attribute17
278: , x_ic_item_mst_row.attribute18

Line 275: , x_ic_item_mst_row.attribute15

271: , x_ic_item_mst_row.attribute11
272: , x_ic_item_mst_row.attribute12
273: , x_ic_item_mst_row.attribute13
274: , x_ic_item_mst_row.attribute14
275: , x_ic_item_mst_row.attribute15
276: , x_ic_item_mst_row.attribute16
277: , x_ic_item_mst_row.attribute17
278: , x_ic_item_mst_row.attribute18
279: , x_ic_item_mst_row.attribute19

Line 276: , x_ic_item_mst_row.attribute16

272: , x_ic_item_mst_row.attribute12
273: , x_ic_item_mst_row.attribute13
274: , x_ic_item_mst_row.attribute14
275: , x_ic_item_mst_row.attribute15
276: , x_ic_item_mst_row.attribute16
277: , x_ic_item_mst_row.attribute17
278: , x_ic_item_mst_row.attribute18
279: , x_ic_item_mst_row.attribute19
280: , x_ic_item_mst_row.attribute20

Line 277: , x_ic_item_mst_row.attribute17

273: , x_ic_item_mst_row.attribute13
274: , x_ic_item_mst_row.attribute14
275: , x_ic_item_mst_row.attribute15
276: , x_ic_item_mst_row.attribute16
277: , x_ic_item_mst_row.attribute17
278: , x_ic_item_mst_row.attribute18
279: , x_ic_item_mst_row.attribute19
280: , x_ic_item_mst_row.attribute20
281: , x_ic_item_mst_row.attribute21

Line 278: , x_ic_item_mst_row.attribute18

274: , x_ic_item_mst_row.attribute14
275: , x_ic_item_mst_row.attribute15
276: , x_ic_item_mst_row.attribute16
277: , x_ic_item_mst_row.attribute17
278: , x_ic_item_mst_row.attribute18
279: , x_ic_item_mst_row.attribute19
280: , x_ic_item_mst_row.attribute20
281: , x_ic_item_mst_row.attribute21
282: , x_ic_item_mst_row.attribute22

Line 279: , x_ic_item_mst_row.attribute19

275: , x_ic_item_mst_row.attribute15
276: , x_ic_item_mst_row.attribute16
277: , x_ic_item_mst_row.attribute17
278: , x_ic_item_mst_row.attribute18
279: , x_ic_item_mst_row.attribute19
280: , x_ic_item_mst_row.attribute20
281: , x_ic_item_mst_row.attribute21
282: , x_ic_item_mst_row.attribute22
283: , x_ic_item_mst_row.attribute23

Line 280: , x_ic_item_mst_row.attribute20

276: , x_ic_item_mst_row.attribute16
277: , x_ic_item_mst_row.attribute17
278: , x_ic_item_mst_row.attribute18
279: , x_ic_item_mst_row.attribute19
280: , x_ic_item_mst_row.attribute20
281: , x_ic_item_mst_row.attribute21
282: , x_ic_item_mst_row.attribute22
283: , x_ic_item_mst_row.attribute23
284: , x_ic_item_mst_row.attribute24

Line 281: , x_ic_item_mst_row.attribute21

277: , x_ic_item_mst_row.attribute17
278: , x_ic_item_mst_row.attribute18
279: , x_ic_item_mst_row.attribute19
280: , x_ic_item_mst_row.attribute20
281: , x_ic_item_mst_row.attribute21
282: , x_ic_item_mst_row.attribute22
283: , x_ic_item_mst_row.attribute23
284: , x_ic_item_mst_row.attribute24
285: , x_ic_item_mst_row.attribute25

Line 282: , x_ic_item_mst_row.attribute22

278: , x_ic_item_mst_row.attribute18
279: , x_ic_item_mst_row.attribute19
280: , x_ic_item_mst_row.attribute20
281: , x_ic_item_mst_row.attribute21
282: , x_ic_item_mst_row.attribute22
283: , x_ic_item_mst_row.attribute23
284: , x_ic_item_mst_row.attribute24
285: , x_ic_item_mst_row.attribute25
286: , x_ic_item_mst_row.attribute26

Line 283: , x_ic_item_mst_row.attribute23

279: , x_ic_item_mst_row.attribute19
280: , x_ic_item_mst_row.attribute20
281: , x_ic_item_mst_row.attribute21
282: , x_ic_item_mst_row.attribute22
283: , x_ic_item_mst_row.attribute23
284: , x_ic_item_mst_row.attribute24
285: , x_ic_item_mst_row.attribute25
286: , x_ic_item_mst_row.attribute26
287: , x_ic_item_mst_row.attribute27

Line 284: , x_ic_item_mst_row.attribute24

280: , x_ic_item_mst_row.attribute20
281: , x_ic_item_mst_row.attribute21
282: , x_ic_item_mst_row.attribute22
283: , x_ic_item_mst_row.attribute23
284: , x_ic_item_mst_row.attribute24
285: , x_ic_item_mst_row.attribute25
286: , x_ic_item_mst_row.attribute26
287: , x_ic_item_mst_row.attribute27
288: , x_ic_item_mst_row.attribute28

Line 285: , x_ic_item_mst_row.attribute25

281: , x_ic_item_mst_row.attribute21
282: , x_ic_item_mst_row.attribute22
283: , x_ic_item_mst_row.attribute23
284: , x_ic_item_mst_row.attribute24
285: , x_ic_item_mst_row.attribute25
286: , x_ic_item_mst_row.attribute26
287: , x_ic_item_mst_row.attribute27
288: , x_ic_item_mst_row.attribute28
289: , x_ic_item_mst_row.attribute29

Line 286: , x_ic_item_mst_row.attribute26

282: , x_ic_item_mst_row.attribute22
283: , x_ic_item_mst_row.attribute23
284: , x_ic_item_mst_row.attribute24
285: , x_ic_item_mst_row.attribute25
286: , x_ic_item_mst_row.attribute26
287: , x_ic_item_mst_row.attribute27
288: , x_ic_item_mst_row.attribute28
289: , x_ic_item_mst_row.attribute29
290: , x_ic_item_mst_row.attribute30

Line 287: , x_ic_item_mst_row.attribute27

283: , x_ic_item_mst_row.attribute23
284: , x_ic_item_mst_row.attribute24
285: , x_ic_item_mst_row.attribute25
286: , x_ic_item_mst_row.attribute26
287: , x_ic_item_mst_row.attribute27
288: , x_ic_item_mst_row.attribute28
289: , x_ic_item_mst_row.attribute29
290: , x_ic_item_mst_row.attribute30
291: , x_ic_item_mst_row.attribute_category

Line 288: , x_ic_item_mst_row.attribute28

284: , x_ic_item_mst_row.attribute24
285: , x_ic_item_mst_row.attribute25
286: , x_ic_item_mst_row.attribute26
287: , x_ic_item_mst_row.attribute27
288: , x_ic_item_mst_row.attribute28
289: , x_ic_item_mst_row.attribute29
290: , x_ic_item_mst_row.attribute30
291: , x_ic_item_mst_row.attribute_category
292: , x_ic_item_mst_row.ont_pricing_qty_source -- P Lowe Bug 2233859

Line 289: , x_ic_item_mst_row.attribute29

285: , x_ic_item_mst_row.attribute25
286: , x_ic_item_mst_row.attribute26
287: , x_ic_item_mst_row.attribute27
288: , x_ic_item_mst_row.attribute28
289: , x_ic_item_mst_row.attribute29
290: , x_ic_item_mst_row.attribute30
291: , x_ic_item_mst_row.attribute_category
292: , x_ic_item_mst_row.ont_pricing_qty_source -- P Lowe Bug 2233859
293: );

Line 290: , x_ic_item_mst_row.attribute30

286: , x_ic_item_mst_row.attribute26
287: , x_ic_item_mst_row.attribute27
288: , x_ic_item_mst_row.attribute28
289: , x_ic_item_mst_row.attribute29
290: , x_ic_item_mst_row.attribute30
291: , x_ic_item_mst_row.attribute_category
292: , x_ic_item_mst_row.ont_pricing_qty_source -- P Lowe Bug 2233859
293: );
294:

Line 291: , x_ic_item_mst_row.attribute_category

287: , x_ic_item_mst_row.attribute27
288: , x_ic_item_mst_row.attribute28
289: , x_ic_item_mst_row.attribute29
290: , x_ic_item_mst_row.attribute30
291: , x_ic_item_mst_row.attribute_category
292: , x_ic_item_mst_row.ont_pricing_qty_source -- P Lowe Bug 2233859
293: );
294:
295: GMIGUTL.DB_ERRNUM := NULL;

Line 292: , x_ic_item_mst_row.ont_pricing_qty_source -- P Lowe Bug 2233859

288: , x_ic_item_mst_row.attribute28
289: , x_ic_item_mst_row.attribute29
290: , x_ic_item_mst_row.attribute30
291: , x_ic_item_mst_row.attribute_category
292: , x_ic_item_mst_row.ont_pricing_qty_source -- P Lowe Bug 2233859
293: );
294:
295: GMIGUTL.DB_ERRNUM := NULL;
296:

Line 300: -- gmi_item_categories(x_ic_item_mst_row);

296:
297: -- TKW 9/11/2003 B2378017 Moved gmi_item_categories to Create_Item procedure.
298: --Jalaj Srivastava Bug 1735676
299: --Item Categories convergence
300: -- gmi_item_categories(x_ic_item_mst_row);
301:
302: RETURN TRUE;
303:
304: EXCEPTION

Line 316: END ic_item_mst_insert;

312: GMIGUTL.DB_ERRNUM := SQLCODE;
313: GMIGUTL.DB_ERRMSG:= SQLERRM;
314: RETURN FALSE;
315:
316: END ic_item_mst_insert;
317:
318:
319: --BEGIN BUG#3151733 Anoop.
320: PROCEDURE mtl_item_categories_insert(p_ic_item_mst_row IN ic_item_mst%ROWTYPE,

Line 320: PROCEDURE mtl_item_categories_insert(p_ic_item_mst_row IN ic_item_mst%ROWTYPE,

316: END ic_item_mst_insert;
317:
318:
319: --BEGIN BUG#3151733 Anoop.
320: PROCEDURE mtl_item_categories_insert(p_ic_item_mst_row IN ic_item_mst%ROWTYPE,
321: l_category_set_id IN NUMBER,l_category_id IN NUMBER)
322: IS
323: CURSOR c_inventory_org IS
324: SELECT organization_id

Line 346: OPEN get_inventory_item_id(p_ic_item_mst_row.ITEM_NO);

342:
343: l_inventory_item_id NUMBER;
344: l_mult_item_cat_assign_flag mtl_category_sets.mult_item_cat_assign_flag%TYPE;
345: BEGIN
346: OPEN get_inventory_item_id(p_ic_item_mst_row.ITEM_NO);
347: FETCH get_inventory_item_id into l_inventory_item_id;
348: CLOSE get_inventory_item_id;
349:
350: OPEN get_mult_item_cat_assign_flag;

Line 388: p_ic_item_mst_row.last_update_date,

384: l_inventory_item_id,
385: Cur_get_organizations_rec.organization_id,
386: l_category_set_id,
387: l_category_id,
388: p_ic_item_mst_row.last_update_date,
389: p_ic_item_mst_row.last_updated_by,
390: p_ic_item_mst_row.creation_date,
391: p_ic_item_mst_row.created_by,
392: NULL,

Line 389: p_ic_item_mst_row.last_updated_by,

385: Cur_get_organizations_rec.organization_id,
386: l_category_set_id,
387: l_category_id,
388: p_ic_item_mst_row.last_update_date,
389: p_ic_item_mst_row.last_updated_by,
390: p_ic_item_mst_row.creation_date,
391: p_ic_item_mst_row.created_by,
392: NULL,
393: NULL,

Line 390: p_ic_item_mst_row.creation_date,

386: l_category_set_id,
387: l_category_id,
388: p_ic_item_mst_row.last_update_date,
389: p_ic_item_mst_row.last_updated_by,
390: p_ic_item_mst_row.creation_date,
391: p_ic_item_mst_row.created_by,
392: NULL,
393: NULL,
394: NULL,

Line 391: p_ic_item_mst_row.created_by,

387: l_category_id,
388: p_ic_item_mst_row.last_update_date,
389: p_ic_item_mst_row.last_updated_by,
390: p_ic_item_mst_row.creation_date,
391: p_ic_item_mst_row.created_by,
392: NULL,
393: NULL,
394: NULL,
395: NULL,

Line 416: PROCEDURE GMI_ITEM_CATEGORIES (p_item_rec IN GMIGAPI.item_rec_typ, p_ic_item_mst_row IN ic_item_mst%ROWTYPE)

412: END mtl_item_categories_insert;
413: --END BUG#3151733 Anoop.
414:
415: -- TKW 9/11/2003 B2378017 Changed signature of proc below.
416: PROCEDURE GMI_ITEM_CATEGORIES (p_item_rec IN GMIGAPI.item_rec_typ, p_ic_item_mst_row IN ic_item_mst%ROWTYPE)
417: IS
418: Cursor get_category_set_id(Vopm_class gmi_category_sets.opm_class%TYPE) IS
419: SELECT gmi.category_set_id,mtl.structure_id
420: FROM gmi_category_sets gmi,

Line 431: IF (p_ic_item_mst_row.alloc_class IS NOT NULL) THEN

427: l_structure_id NUMBER;
428:
429: BEGIN
430:
431: IF (p_ic_item_mst_row.alloc_class IS NOT NULL) THEN
432:
433: OPEN get_category_set_id('ALLOC_CLASS');
434: FETCH get_category_set_id into l_category_set_id,l_structure_id;
435: CLOSE get_category_set_id;

Line 437: gmi_item_categories_insert(p_ic_item_mst_row,

433: OPEN get_category_set_id('ALLOC_CLASS');
434: FETCH get_category_set_id into l_category_set_id,l_structure_id;
435: CLOSE get_category_set_id;
436:
437: gmi_item_categories_insert(p_ic_item_mst_row,
438: l_category_set_id,
439: p_ic_item_mst_row.alloc_class,
440: l_structure_id,
441: l_category_id);

Line 439: p_ic_item_mst_row.alloc_class,

435: CLOSE get_category_set_id;
436:
437: gmi_item_categories_insert(p_ic_item_mst_row,
438: l_category_set_id,
439: p_ic_item_mst_row.alloc_class,
440: l_structure_id,
441: l_category_id);
442:
443: UPDATE ic_item_mst set alloc_category_id = l_category_id

Line 443: UPDATE ic_item_mst set alloc_category_id = l_category_id

439: p_ic_item_mst_row.alloc_class,
440: l_structure_id,
441: l_category_id);
442:
443: UPDATE ic_item_mst set alloc_category_id = l_category_id
444: WHERE item_id = p_ic_item_mst_row.item_id;
445:
446: END IF;
447:

Line 444: WHERE item_id = p_ic_item_mst_row.item_id;

440: l_structure_id,
441: l_category_id);
442:
443: UPDATE ic_item_mst set alloc_category_id = l_category_id
444: WHERE item_id = p_ic_item_mst_row.item_id;
445:
446: END IF;
447:
448: IF (p_ic_item_mst_row.itemcost_class IS NOT NULL) THEN

Line 448: IF (p_ic_item_mst_row.itemcost_class IS NOT NULL) THEN

444: WHERE item_id = p_ic_item_mst_row.item_id;
445:
446: END IF;
447:
448: IF (p_ic_item_mst_row.itemcost_class IS NOT NULL) THEN
449:
450: OPEN get_category_set_id('COST_CLASS');
451: FETCH get_category_set_id into l_category_set_id,l_structure_id;
452: CLOSE get_category_set_id;

Line 454: gmi_item_categories_insert(p_ic_item_mst_row,

450: OPEN get_category_set_id('COST_CLASS');
451: FETCH get_category_set_id into l_category_set_id,l_structure_id;
452: CLOSE get_category_set_id;
453:
454: gmi_item_categories_insert(p_ic_item_mst_row,
455: l_category_set_id,
456: p_ic_item_mst_row.itemcost_class,
457: l_structure_id,
458: l_category_id);

Line 456: p_ic_item_mst_row.itemcost_class,

452: CLOSE get_category_set_id;
453:
454: gmi_item_categories_insert(p_ic_item_mst_row,
455: l_category_set_id,
456: p_ic_item_mst_row.itemcost_class,
457: l_structure_id,
458: l_category_id);
459:
460: UPDATE ic_item_mst set cost_category_id = l_category_id

Line 460: UPDATE ic_item_mst set cost_category_id = l_category_id

456: p_ic_item_mst_row.itemcost_class,
457: l_structure_id,
458: l_category_id);
459:
460: UPDATE ic_item_mst set cost_category_id = l_category_id
461: WHERE item_id = p_ic_item_mst_row.item_id;
462:
463: END IF;
464:

Line 461: WHERE item_id = p_ic_item_mst_row.item_id;

457: l_structure_id,
458: l_category_id);
459:
460: UPDATE ic_item_mst set cost_category_id = l_category_id
461: WHERE item_id = p_ic_item_mst_row.item_id;
462:
463: END IF;
464:
465: IF (p_ic_item_mst_row.customs_class IS NOT NULL) THEN

Line 465: IF (p_ic_item_mst_row.customs_class IS NOT NULL) THEN

461: WHERE item_id = p_ic_item_mst_row.item_id;
462:
463: END IF;
464:
465: IF (p_ic_item_mst_row.customs_class IS NOT NULL) THEN
466:
467: OPEN get_category_set_id('CUSTOMS_CLASS');
468: FETCH get_category_set_id into l_category_set_id,l_structure_id;
469: CLOSE get_category_set_id;

Line 471: gmi_item_categories_insert(p_ic_item_mst_row,

467: OPEN get_category_set_id('CUSTOMS_CLASS');
468: FETCH get_category_set_id into l_category_set_id,l_structure_id;
469: CLOSE get_category_set_id;
470:
471: gmi_item_categories_insert(p_ic_item_mst_row,
472: l_category_set_id,
473: p_ic_item_mst_row.customs_class,
474: l_structure_id,
475: l_category_id);

Line 473: p_ic_item_mst_row.customs_class,

469: CLOSE get_category_set_id;
470:
471: gmi_item_categories_insert(p_ic_item_mst_row,
472: l_category_set_id,
473: p_ic_item_mst_row.customs_class,
474: l_structure_id,
475: l_category_id);
476:
477: UPDATE ic_item_mst set customs_category_id = l_category_id

Line 477: UPDATE ic_item_mst set customs_category_id = l_category_id

473: p_ic_item_mst_row.customs_class,
474: l_structure_id,
475: l_category_id);
476:
477: UPDATE ic_item_mst set customs_category_id = l_category_id
478: WHERE item_id = p_ic_item_mst_row.item_id;
479:
480: END IF;
481:

Line 478: WHERE item_id = p_ic_item_mst_row.item_id;

474: l_structure_id,
475: l_category_id);
476:
477: UPDATE ic_item_mst set customs_category_id = l_category_id
478: WHERE item_id = p_ic_item_mst_row.item_id;
479:
480: END IF;
481:
482:

Line 483: IF (p_ic_item_mst_row.frt_class IS NOT NULL) THEN

479:
480: END IF;
481:
482:
483: IF (p_ic_item_mst_row.frt_class IS NOT NULL) THEN
484:
485: OPEN get_category_set_id('FRT_CLASS');
486: FETCH get_category_set_id into l_category_set_id,l_structure_id;
487: CLOSE get_category_set_id;

Line 489: gmi_item_categories_insert(p_ic_item_mst_row,

485: OPEN get_category_set_id('FRT_CLASS');
486: FETCH get_category_set_id into l_category_set_id,l_structure_id;
487: CLOSE get_category_set_id;
488:
489: gmi_item_categories_insert(p_ic_item_mst_row,
490: l_category_set_id,
491: p_ic_item_mst_row.frt_class,
492: l_structure_id,
493: l_category_id);

Line 491: p_ic_item_mst_row.frt_class,

487: CLOSE get_category_set_id;
488:
489: gmi_item_categories_insert(p_ic_item_mst_row,
490: l_category_set_id,
491: p_ic_item_mst_row.frt_class,
492: l_structure_id,
493: l_category_id);
494:
495: UPDATE ic_item_mst set frt_category_id = l_category_id

Line 495: UPDATE ic_item_mst set frt_category_id = l_category_id

491: p_ic_item_mst_row.frt_class,
492: l_structure_id,
493: l_category_id);
494:
495: UPDATE ic_item_mst set frt_category_id = l_category_id
496: WHERE item_id = p_ic_item_mst_row.item_id;
497:
498: END IF;
499:

Line 496: WHERE item_id = p_ic_item_mst_row.item_id;

492: l_structure_id,
493: l_category_id);
494:
495: UPDATE ic_item_mst set frt_category_id = l_category_id
496: WHERE item_id = p_ic_item_mst_row.item_id;
497:
498: END IF;
499:
500:

Line 501: IF (p_ic_item_mst_row.gl_class IS NOT NULL) THEN

497:
498: END IF;
499:
500:
501: IF (p_ic_item_mst_row.gl_class IS NOT NULL) THEN
502:
503: OPEN get_category_set_id('GL_CLASS');
504: FETCH get_category_set_id into l_category_set_id,l_structure_id;
505: CLOSE get_category_set_id;

Line 507: gmi_item_categories_insert(p_ic_item_mst_row,

503: OPEN get_category_set_id('GL_CLASS');
504: FETCH get_category_set_id into l_category_set_id,l_structure_id;
505: CLOSE get_category_set_id;
506:
507: gmi_item_categories_insert(p_ic_item_mst_row,
508: l_category_set_id,
509: p_ic_item_mst_row.gl_class,
510: l_structure_id,
511: l_category_id);

Line 509: p_ic_item_mst_row.gl_class,

505: CLOSE get_category_set_id;
506:
507: gmi_item_categories_insert(p_ic_item_mst_row,
508: l_category_set_id,
509: p_ic_item_mst_row.gl_class,
510: l_structure_id,
511: l_category_id);
512:
513: UPDATE ic_item_mst set gl_category_id = l_category_id

Line 513: UPDATE ic_item_mst set gl_category_id = l_category_id

509: p_ic_item_mst_row.gl_class,
510: l_structure_id,
511: l_category_id);
512:
513: UPDATE ic_item_mst set gl_category_id = l_category_id
514: WHERE item_id = p_ic_item_mst_row.item_id;
515:
516: END IF;
517:

Line 514: WHERE item_id = p_ic_item_mst_row.item_id;

510: l_structure_id,
511: l_category_id);
512:
513: UPDATE ic_item_mst set gl_category_id = l_category_id
514: WHERE item_id = p_ic_item_mst_row.item_id;
515:
516: END IF;
517:
518: IF (p_ic_item_mst_row.inv_class IS NOT NULL) THEN

Line 518: IF (p_ic_item_mst_row.inv_class IS NOT NULL) THEN

514: WHERE item_id = p_ic_item_mst_row.item_id;
515:
516: END IF;
517:
518: IF (p_ic_item_mst_row.inv_class IS NOT NULL) THEN
519:
520: OPEN get_category_set_id('INV_CLASS');
521: FETCH get_category_set_id into l_category_set_id,l_structure_id;
522: CLOSE get_category_set_id;

Line 524: gmi_item_categories_insert(p_ic_item_mst_row,

520: OPEN get_category_set_id('INV_CLASS');
521: FETCH get_category_set_id into l_category_set_id,l_structure_id;
522: CLOSE get_category_set_id;
523:
524: gmi_item_categories_insert(p_ic_item_mst_row,
525: l_category_set_id,
526: p_ic_item_mst_row.inv_class,
527: l_structure_id,
528: l_category_id);

Line 526: p_ic_item_mst_row.inv_class,

522: CLOSE get_category_set_id;
523:
524: gmi_item_categories_insert(p_ic_item_mst_row,
525: l_category_set_id,
526: p_ic_item_mst_row.inv_class,
527: l_structure_id,
528: l_category_id);
529:
530: UPDATE ic_item_mst set inv_category_id = l_category_id

Line 530: UPDATE ic_item_mst set inv_category_id = l_category_id

526: p_ic_item_mst_row.inv_class,
527: l_structure_id,
528: l_category_id);
529:
530: UPDATE ic_item_mst set inv_category_id = l_category_id
531: WHERE item_id = p_ic_item_mst_row.item_id;
532:
533: END IF;
534:

Line 531: WHERE item_id = p_ic_item_mst_row.item_id;

527: l_structure_id,
528: l_category_id);
529:
530: UPDATE ic_item_mst set inv_category_id = l_category_id
531: WHERE item_id = p_ic_item_mst_row.item_id;
532:
533: END IF;
534:
535: IF (p_ic_item_mst_row.price_class IS NOT NULL) THEN

Line 535: IF (p_ic_item_mst_row.price_class IS NOT NULL) THEN

531: WHERE item_id = p_ic_item_mst_row.item_id;
532:
533: END IF;
534:
535: IF (p_ic_item_mst_row.price_class IS NOT NULL) THEN
536:
537: OPEN get_category_set_id('PRICE_CLASS');
538: FETCH get_category_set_id into l_category_set_id,l_structure_id;
539: CLOSE get_category_set_id;

Line 541: gmi_item_categories_insert(p_ic_item_mst_row,

537: OPEN get_category_set_id('PRICE_CLASS');
538: FETCH get_category_set_id into l_category_set_id,l_structure_id;
539: CLOSE get_category_set_id;
540:
541: gmi_item_categories_insert(p_ic_item_mst_row,
542: l_category_set_id,
543: p_ic_item_mst_row.price_class,
544: l_structure_id,
545: l_category_id);

Line 543: p_ic_item_mst_row.price_class,

539: CLOSE get_category_set_id;
540:
541: gmi_item_categories_insert(p_ic_item_mst_row,
542: l_category_set_id,
543: p_ic_item_mst_row.price_class,
544: l_structure_id,
545: l_category_id);
546:
547: UPDATE ic_item_mst set price_category_id = l_category_id

Line 547: UPDATE ic_item_mst set price_category_id = l_category_id

543: p_ic_item_mst_row.price_class,
544: l_structure_id,
545: l_category_id);
546:
547: UPDATE ic_item_mst set price_category_id = l_category_id
548: WHERE item_id = p_ic_item_mst_row.item_id;
549:
550: END IF;
551:

Line 548: WHERE item_id = p_ic_item_mst_row.item_id;

544: l_structure_id,
545: l_category_id);
546:
547: UPDATE ic_item_mst set price_category_id = l_category_id
548: WHERE item_id = p_ic_item_mst_row.item_id;
549:
550: END IF;
551:
552: IF (p_ic_item_mst_row.purch_class IS NOT NULL) THEN

Line 552: IF (p_ic_item_mst_row.purch_class IS NOT NULL) THEN

548: WHERE item_id = p_ic_item_mst_row.item_id;
549:
550: END IF;
551:
552: IF (p_ic_item_mst_row.purch_class IS NOT NULL) THEN
553:
554: OPEN get_category_set_id('PURCH_CLASS');
555: FETCH get_category_set_id into l_category_set_id,l_structure_id;
556: CLOSE get_category_set_id;

Line 558: gmi_item_categories_insert(p_ic_item_mst_row,

554: OPEN get_category_set_id('PURCH_CLASS');
555: FETCH get_category_set_id into l_category_set_id,l_structure_id;
556: CLOSE get_category_set_id;
557:
558: gmi_item_categories_insert(p_ic_item_mst_row,
559: l_category_set_id,
560: p_ic_item_mst_row.purch_class,
561: l_structure_id,
562: l_category_id);

Line 560: p_ic_item_mst_row.purch_class,

556: CLOSE get_category_set_id;
557:
558: gmi_item_categories_insert(p_ic_item_mst_row,
559: l_category_set_id,
560: p_ic_item_mst_row.purch_class,
561: l_structure_id,
562: l_category_id);
563:
564: UPDATE ic_item_mst set purch_category_id = l_category_id

Line 564: UPDATE ic_item_mst set purch_category_id = l_category_id

560: p_ic_item_mst_row.purch_class,
561: l_structure_id,
562: l_category_id);
563:
564: UPDATE ic_item_mst set purch_category_id = l_category_id
565: WHERE item_id = p_ic_item_mst_row.item_id;
566:
567: END IF;
568:

Line 565: WHERE item_id = p_ic_item_mst_row.item_id;

561: l_structure_id,
562: l_category_id);
563:
564: UPDATE ic_item_mst set purch_category_id = l_category_id
565: WHERE item_id = p_ic_item_mst_row.item_id;
566:
567: END IF;
568:
569:

Line 570: IF (p_ic_item_mst_row.sales_class IS NOT NULL) THEN

566:
567: END IF;
568:
569:
570: IF (p_ic_item_mst_row.sales_class IS NOT NULL) THEN
571:
572: OPEN get_category_set_id('SALES_CLASS');
573: FETCH get_category_set_id into l_category_set_id,l_structure_id;
574: CLOSE get_category_set_id;

Line 576: gmi_item_categories_insert(p_ic_item_mst_row,

572: OPEN get_category_set_id('SALES_CLASS');
573: FETCH get_category_set_id into l_category_set_id,l_structure_id;
574: CLOSE get_category_set_id;
575:
576: gmi_item_categories_insert(p_ic_item_mst_row,
577: l_category_set_id,
578: p_ic_item_mst_row.sales_class,
579: l_structure_id,
580: l_category_id);

Line 578: p_ic_item_mst_row.sales_class,

574: CLOSE get_category_set_id;
575:
576: gmi_item_categories_insert(p_ic_item_mst_row,
577: l_category_set_id,
578: p_ic_item_mst_row.sales_class,
579: l_structure_id,
580: l_category_id);
581:
582: UPDATE ic_item_mst set sales_category_id = l_category_id

Line 582: UPDATE ic_item_mst set sales_category_id = l_category_id

578: p_ic_item_mst_row.sales_class,
579: l_structure_id,
580: l_category_id);
581:
582: UPDATE ic_item_mst set sales_category_id = l_category_id
583: WHERE item_id = p_ic_item_mst_row.item_id;
584:
585: END IF;
586:

Line 583: WHERE item_id = p_ic_item_mst_row.item_id;

579: l_structure_id,
580: l_category_id);
581:
582: UPDATE ic_item_mst set sales_category_id = l_category_id
583: WHERE item_id = p_ic_item_mst_row.item_id;
584:
585: END IF;
586:
587:

Line 588: IF (p_ic_item_mst_row.ship_class IS NOT NULL) THEN

584:
585: END IF;
586:
587:
588: IF (p_ic_item_mst_row.ship_class IS NOT NULL) THEN
589:
590: OPEN get_category_set_id('SHIP_CLASS');
591: FETCH get_category_set_id into l_category_set_id,l_structure_id;
592: CLOSE get_category_set_id;

Line 594: gmi_item_categories_insert(p_ic_item_mst_row,

590: OPEN get_category_set_id('SHIP_CLASS');
591: FETCH get_category_set_id into l_category_set_id,l_structure_id;
592: CLOSE get_category_set_id;
593:
594: gmi_item_categories_insert(p_ic_item_mst_row,
595: l_category_set_id,
596: p_ic_item_mst_row.ship_class,
597: l_structure_id,
598: l_category_id);

Line 596: p_ic_item_mst_row.ship_class,

592: CLOSE get_category_set_id;
593:
594: gmi_item_categories_insert(p_ic_item_mst_row,
595: l_category_set_id,
596: p_ic_item_mst_row.ship_class,
597: l_structure_id,
598: l_category_id);
599:
600: UPDATE ic_item_mst set ship_category_id = l_category_id

Line 600: UPDATE ic_item_mst set ship_category_id = l_category_id

596: p_ic_item_mst_row.ship_class,
597: l_structure_id,
598: l_category_id);
599:
600: UPDATE ic_item_mst set ship_category_id = l_category_id
601: WHERE item_id = p_ic_item_mst_row.item_id;
602:
603: END IF;
604:

Line 601: WHERE item_id = p_ic_item_mst_row.item_id;

597: l_structure_id,
598: l_category_id);
599:
600: UPDATE ic_item_mst set ship_category_id = l_category_id
601: WHERE item_id = p_ic_item_mst_row.item_id;
602:
603: END IF;
604:
605:

Line 606: IF (p_ic_item_mst_row.storage_class IS NOT NULL) THEN

602:
603: END IF;
604:
605:
606: IF (p_ic_item_mst_row.storage_class IS NOT NULL) THEN
607:
608: OPEN get_category_set_id('STORAGE_CLASS');
609: FETCH get_category_set_id into l_category_set_id,l_structure_id;
610: CLOSE get_category_set_id;

Line 612: gmi_item_categories_insert(p_ic_item_mst_row,

608: OPEN get_category_set_id('STORAGE_CLASS');
609: FETCH get_category_set_id into l_category_set_id,l_structure_id;
610: CLOSE get_category_set_id;
611:
612: gmi_item_categories_insert(p_ic_item_mst_row,
613: l_category_set_id,
614: p_ic_item_mst_row.storage_class,
615: l_structure_id,
616: l_category_id);

Line 614: p_ic_item_mst_row.storage_class,

610: CLOSE get_category_set_id;
611:
612: gmi_item_categories_insert(p_ic_item_mst_row,
613: l_category_set_id,
614: p_ic_item_mst_row.storage_class,
615: l_structure_id,
616: l_category_id);
617:
618: UPDATE ic_item_mst set storage_category_id = l_category_id

Line 618: UPDATE ic_item_mst set storage_category_id = l_category_id

614: p_ic_item_mst_row.storage_class,
615: l_structure_id,
616: l_category_id);
617:
618: UPDATE ic_item_mst set storage_category_id = l_category_id
619: WHERE item_id = p_ic_item_mst_row.item_id;
620:
621: END IF;
622:

Line 619: WHERE item_id = p_ic_item_mst_row.item_id;

615: l_structure_id,
616: l_category_id);
617:
618: UPDATE ic_item_mst set storage_category_id = l_category_id
619: WHERE item_id = p_ic_item_mst_row.item_id;
620:
621: END IF;
622:
623:

Line 624: IF (p_ic_item_mst_row.tax_class IS NOT NULL) THEN

620:
621: END IF;
622:
623:
624: IF (p_ic_item_mst_row.tax_class IS NOT NULL) THEN
625:
626: OPEN get_category_set_id('TAX_CLASS');
627: FETCH get_category_set_id into l_category_set_id,l_structure_id;
628: CLOSE get_category_set_id;

Line 630: gmi_item_categories_insert(p_ic_item_mst_row,

626: OPEN get_category_set_id('TAX_CLASS');
627: FETCH get_category_set_id into l_category_set_id,l_structure_id;
628: CLOSE get_category_set_id;
629:
630: gmi_item_categories_insert(p_ic_item_mst_row,
631: l_category_set_id,
632: p_ic_item_mst_row.tax_class,
633: l_structure_id,
634: l_category_id);

Line 632: p_ic_item_mst_row.tax_class,

628: CLOSE get_category_set_id;
629:
630: gmi_item_categories_insert(p_ic_item_mst_row,
631: l_category_set_id,
632: p_ic_item_mst_row.tax_class,
633: l_structure_id,
634: l_category_id);
635:
636: UPDATE ic_item_mst set tax_class = null

Line 636: UPDATE ic_item_mst set tax_class = null

632: p_ic_item_mst_row.tax_class,
633: l_structure_id,
634: l_category_id);
635:
636: UPDATE ic_item_mst set tax_class = null
637: WHERE item_id = p_ic_item_mst_row.item_id;
638:
639: INSERT INTO IC_TAXN_ASC(
640: ictax_class,

Line 637: WHERE item_id = p_ic_item_mst_row.item_id;

633: l_structure_id,
634: l_category_id);
635:
636: UPDATE ic_item_mst set tax_class = null
637: WHERE item_id = p_ic_item_mst_row.item_id;
638:
639: INSERT INTO IC_TAXN_ASC(
640: ictax_class,
641: tax_category_id,

Line 652: p_ic_item_mst_row.tax_class,

648: last_update_date,
649: last_updated_by,
650: last_update_login)
651: VALUES(
652: p_ic_item_mst_row.tax_class,
653: l_category_id,
654: p_ic_item_mst_row.item_id,
655: 0,
656: NULL,

Line 654: p_ic_item_mst_row.item_id,

650: last_update_login)
651: VALUES(
652: p_ic_item_mst_row.tax_class,
653: l_category_id,
654: p_ic_item_mst_row.item_id,
655: 0,
656: NULL,
657: 0,
658: p_ic_item_mst_row.creation_date,

Line 658: p_ic_item_mst_row.creation_date,

654: p_ic_item_mst_row.item_id,
655: 0,
656: NULL,
657: 0,
658: p_ic_item_mst_row.creation_date,
659: p_ic_item_mst_row.created_by,
660: p_ic_item_mst_row.last_update_date,
661: p_ic_item_mst_row.last_updated_by,
662: p_ic_item_mst_row.last_update_login);

Line 659: p_ic_item_mst_row.created_by,

655: 0,
656: NULL,
657: 0,
658: p_ic_item_mst_row.creation_date,
659: p_ic_item_mst_row.created_by,
660: p_ic_item_mst_row.last_update_date,
661: p_ic_item_mst_row.last_updated_by,
662: p_ic_item_mst_row.last_update_login);
663:

Line 660: p_ic_item_mst_row.last_update_date,

656: NULL,
657: 0,
658: p_ic_item_mst_row.creation_date,
659: p_ic_item_mst_row.created_by,
660: p_ic_item_mst_row.last_update_date,
661: p_ic_item_mst_row.last_updated_by,
662: p_ic_item_mst_row.last_update_login);
663:
664: END IF;

Line 661: p_ic_item_mst_row.last_updated_by,

657: 0,
658: p_ic_item_mst_row.creation_date,
659: p_ic_item_mst_row.created_by,
660: p_ic_item_mst_row.last_update_date,
661: p_ic_item_mst_row.last_updated_by,
662: p_ic_item_mst_row.last_update_login);
663:
664: END IF;
665:

Line 662: p_ic_item_mst_row.last_update_login);

658: p_ic_item_mst_row.creation_date,
659: p_ic_item_mst_row.created_by,
660: p_ic_item_mst_row.last_update_date,
661: p_ic_item_mst_row.last_updated_by,
662: p_ic_item_mst_row.last_update_login);
663:
664: END IF;
665:
666:

Line 667: IF (p_ic_item_mst_row.planning_class IS NOT NULL) THEN

663:
664: END IF;
665:
666:
667: IF (p_ic_item_mst_row.planning_class IS NOT NULL) THEN
668:
669: OPEN get_category_set_id('PLANNING_CLASS');
670: FETCH get_category_set_id into l_category_set_id,l_structure_id;
671: CLOSE get_category_set_id;

Line 673: gmi_item_categories_insert(p_ic_item_mst_row,

669: OPEN get_category_set_id('PLANNING_CLASS');
670: FETCH get_category_set_id into l_category_set_id,l_structure_id;
671: CLOSE get_category_set_id;
672:
673: gmi_item_categories_insert(p_ic_item_mst_row,
674: l_category_set_id,
675: p_ic_item_mst_row.planning_class,
676: l_structure_id,
677: l_category_id);

Line 675: p_ic_item_mst_row.planning_class,

671: CLOSE get_category_set_id;
672:
673: gmi_item_categories_insert(p_ic_item_mst_row,
674: l_category_set_id,
675: p_ic_item_mst_row.planning_class,
676: l_structure_id,
677: l_category_id);
678:
679: UPDATE ic_item_mst set planning_category_id = l_category_id

Line 679: UPDATE ic_item_mst set planning_category_id = l_category_id

675: p_ic_item_mst_row.planning_class,
676: l_structure_id,
677: l_category_id);
678:
679: UPDATE ic_item_mst set planning_category_id = l_category_id
680: WHERE item_id = p_ic_item_mst_row.item_id;
681:
682: END IF;
683:

Line 680: WHERE item_id = p_ic_item_mst_row.item_id;

676: l_structure_id,
677: l_category_id);
678:
679: UPDATE ic_item_mst set planning_category_id = l_category_id
680: WHERE item_id = p_ic_item_mst_row.item_id;
681:
682: END IF;
683:
684:

Line 685: IF (p_ic_item_mst_row.seq_dpnd_class IS NOT NULL) THEN

681:
682: END IF;
683:
684:
685: IF (p_ic_item_mst_row.seq_dpnd_class IS NOT NULL) THEN
686:
687: OPEN get_category_set_id('SEQ_CLASS');
688: FETCH get_category_set_id into l_category_set_id,l_structure_id;
689: CLOSE get_category_set_id;

Line 691: gmi_item_categories_insert(p_ic_item_mst_row,

687: OPEN get_category_set_id('SEQ_CLASS');
688: FETCH get_category_set_id into l_category_set_id,l_structure_id;
689: CLOSE get_category_set_id;
690:
691: gmi_item_categories_insert(p_ic_item_mst_row,
692: l_category_set_id,
693: p_ic_item_mst_row.seq_dpnd_class,
694: l_structure_id,
695: l_category_id);

Line 693: p_ic_item_mst_row.seq_dpnd_class,

689: CLOSE get_category_set_id;
690:
691: gmi_item_categories_insert(p_ic_item_mst_row,
692: l_category_set_id,
693: p_ic_item_mst_row.seq_dpnd_class,
694: l_structure_id,
695: l_category_id);
696:
697: UPDATE ic_item_mst set seq_category_id = l_category_id

Line 697: UPDATE ic_item_mst set seq_category_id = l_category_id

693: p_ic_item_mst_row.seq_dpnd_class,
694: l_structure_id,
695: l_category_id);
696:
697: UPDATE ic_item_mst set seq_category_id = l_category_id
698: WHERE item_id = p_ic_item_mst_row.item_id;
699:
700: END IF;
701:

Line 698: WHERE item_id = p_ic_item_mst_row.item_id;

694: l_structure_id,
695: l_category_id);
696:
697: UPDATE ic_item_mst set seq_category_id = l_category_id
698: WHERE item_id = p_ic_item_mst_row.item_id;
699:
700: END IF;
701:
702: -- TKW 9/11/2003 B2378017 Added four new classes.

Line 709: gmi_item_categories_insert(p_ic_item_mst_row,

705: OPEN get_category_set_id('GL_BUSINESS_CLASS');
706: FETCH get_category_set_id into l_category_set_id,l_structure_id;
707: CLOSE get_category_set_id;
708:
709: gmi_item_categories_insert(p_ic_item_mst_row,
710: l_category_set_id,
711: p_item_rec.gl_business_class,
712: l_structure_id,
713: l_category_id);

Line 724: gmi_item_categories_insert(p_ic_item_mst_row,

720: OPEN get_category_set_id('GL_PRODUCT_LINE');
721: FETCH get_category_set_id into l_category_set_id,l_structure_id;
722: CLOSE get_category_set_id;
723:
724: gmi_item_categories_insert(p_ic_item_mst_row,
725: l_category_set_id,
726: p_item_rec.gl_prod_line,
727: l_structure_id,
728: l_category_id);

Line 739: gmi_item_categories_insert(p_ic_item_mst_row,

735: OPEN get_category_set_id('SUB_STANDARD_CLASS');
736: FETCH get_category_set_id into l_category_set_id,l_structure_id;
737: CLOSE get_category_set_id;
738:
739: gmi_item_categories_insert(p_ic_item_mst_row,
740: l_category_set_id,
741: p_item_rec.sub_standard_class,
742: l_structure_id,
743: l_category_id);

Line 754: gmi_item_categories_insert(p_ic_item_mst_row,

750: OPEN get_category_set_id('TECH_CLASS');
751: FETCH get_category_set_id into l_category_set_id,l_structure_id;
752: CLOSE get_category_set_id;
753:
754: gmi_item_categories_insert(p_ic_item_mst_row,
755: l_category_set_id,
756: p_item_rec.tech_class,
757: l_structure_id,
758: l_category_id);

Line 764: PROCEDURE GMI_ITEM_CATEGORIES_INSERT (p_ic_item_mst_row IN ic_item_mst%ROWTYPE,

760: END IF;
761:
762: END GMI_ITEM_CATEGORIES;
763:
764: PROCEDURE GMI_ITEM_CATEGORIES_INSERT (p_ic_item_mst_row IN ic_item_mst%ROWTYPE,
765: p_category_set_id NUMBER,
766: p_category_concat_segs mtl_categories_v.category_concat_segs%TYPE,
767: p_structure_id NUMBER,
768: p_category_id IN OUT NOCOPY NUMBER)

Line 793: p_ic_item_mst_row.item_id,

789: last_update_date,
790: last_update_login
791: )
792: VALUES (
793: p_ic_item_mst_row.item_id,
794: p_category_set_id,
795: p_category_id,
796: p_ic_item_mst_row.created_by,
797: p_ic_item_mst_row.creation_date,

Line 796: p_ic_item_mst_row.created_by,

792: VALUES (
793: p_ic_item_mst_row.item_id,
794: p_category_set_id,
795: p_category_id,
796: p_ic_item_mst_row.created_by,
797: p_ic_item_mst_row.creation_date,
798: p_ic_item_mst_row.last_updated_by,
799: p_ic_item_mst_row.last_update_date,
800: p_ic_item_mst_row.last_update_login

Line 797: p_ic_item_mst_row.creation_date,

793: p_ic_item_mst_row.item_id,
794: p_category_set_id,
795: p_category_id,
796: p_ic_item_mst_row.created_by,
797: p_ic_item_mst_row.creation_date,
798: p_ic_item_mst_row.last_updated_by,
799: p_ic_item_mst_row.last_update_date,
800: p_ic_item_mst_row.last_update_login
801: );

Line 798: p_ic_item_mst_row.last_updated_by,

794: p_category_set_id,
795: p_category_id,
796: p_ic_item_mst_row.created_by,
797: p_ic_item_mst_row.creation_date,
798: p_ic_item_mst_row.last_updated_by,
799: p_ic_item_mst_row.last_update_date,
800: p_ic_item_mst_row.last_update_login
801: );
802: --BUG#3151733 Anoop.

Line 799: p_ic_item_mst_row.last_update_date,

795: p_category_id,
796: p_ic_item_mst_row.created_by,
797: p_ic_item_mst_row.creation_date,
798: p_ic_item_mst_row.last_updated_by,
799: p_ic_item_mst_row.last_update_date,
800: p_ic_item_mst_row.last_update_login
801: );
802: --BUG#3151733 Anoop.
803: mtl_item_categories_insert(p_ic_item_mst_row,p_category_set_id,p_category_id);

Line 800: p_ic_item_mst_row.last_update_login

796: p_ic_item_mst_row.created_by,
797: p_ic_item_mst_row.creation_date,
798: p_ic_item_mst_row.last_updated_by,
799: p_ic_item_mst_row.last_update_date,
800: p_ic_item_mst_row.last_update_login
801: );
802: --BUG#3151733 Anoop.
803: mtl_item_categories_insert(p_ic_item_mst_row,p_category_set_id,p_category_id);
804: END GMI_ITEM_CATEGORIES_INSERT;

Line 803: mtl_item_categories_insert(p_ic_item_mst_row,p_category_set_id,p_category_id);

799: p_ic_item_mst_row.last_update_date,
800: p_ic_item_mst_row.last_update_login
801: );
802: --BUG#3151733 Anoop.
803: mtl_item_categories_insert(p_ic_item_mst_row,p_category_set_id,p_category_id);
804: END GMI_ITEM_CATEGORIES_INSERT;
805:
806:
807: FUNCTION ic_item_mst_select

Line 807: FUNCTION ic_item_mst_select

803: mtl_item_categories_insert(p_ic_item_mst_row,p_category_set_id,p_category_id);
804: END GMI_ITEM_CATEGORIES_INSERT;
805:
806:
807: FUNCTION ic_item_mst_select
808: (p_ic_item_mst_row IN ic_item_mst%ROWTYPE, x_ic_item_mst_row IN OUT NOCOPY ic_item_mst%ROWTYPE)
809: RETURN BOOLEAN
810: IS
811: BEGIN

Line 808: (p_ic_item_mst_row IN ic_item_mst%ROWTYPE, x_ic_item_mst_row IN OUT NOCOPY ic_item_mst%ROWTYPE)

804: END GMI_ITEM_CATEGORIES_INSERT;
805:
806:
807: FUNCTION ic_item_mst_select
808: (p_ic_item_mst_row IN ic_item_mst%ROWTYPE, x_ic_item_mst_row IN OUT NOCOPY ic_item_mst%ROWTYPE)
809: RETURN BOOLEAN
810: IS
811: BEGIN
812:

Line 813: IF p_ic_item_mst_row.item_no IS NOT NULL

809: RETURN BOOLEAN
810: IS
811: BEGIN
812:
813: IF p_ic_item_mst_row.item_no IS NOT NULL
814: THEN
815: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
816: WHERE item_no=p_ic_item_mst_row.item_no;
817: ELSE

Line 815: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst

811: BEGIN
812:
813: IF p_ic_item_mst_row.item_no IS NOT NULL
814: THEN
815: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
816: WHERE item_no=p_ic_item_mst_row.item_no;
817: ELSE
818: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
819: WHERE item_id=p_ic_item_mst_row.item_id;

Line 816: WHERE item_no=p_ic_item_mst_row.item_no;

812:
813: IF p_ic_item_mst_row.item_no IS NOT NULL
814: THEN
815: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
816: WHERE item_no=p_ic_item_mst_row.item_no;
817: ELSE
818: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
819: WHERE item_id=p_ic_item_mst_row.item_id;
820: END IF;

Line 818: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst

814: THEN
815: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
816: WHERE item_no=p_ic_item_mst_row.item_no;
817: ELSE
818: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
819: WHERE item_id=p_ic_item_mst_row.item_id;
820: END IF;
821:
822: GMIGUTL.DB_ERRNUM := NULL;

Line 819: WHERE item_id=p_ic_item_mst_row.item_id;

815: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
816: WHERE item_no=p_ic_item_mst_row.item_no;
817: ELSE
818: SELECT * INTO x_ic_item_mst_row FROM ic_item_mst
819: WHERE item_id=p_ic_item_mst_row.item_id;
820: END IF;
821:
822: GMIGUTL.DB_ERRNUM := NULL;
823: RETURN TRUE;

Line 846: END ic_item_mst_select;

842: GMIGUTL.DB_ERRNUM := SQLCODE;
843: GMIGUTL.DB_ERRMSG:= SQLERRM;
844: RETURN FALSE;
845:
846: END ic_item_mst_select;
847:
848: FUNCTION ic_lots_mst_insert
849: (p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE, x_ic_lots_mst_row IN OUT NOCOPY ic_lots_mst%ROWTYPE)
850: RETURN BOOLEAN