APPS.GMI_ITEM_PVT dependencies on IC_ITEM_MST

Line 20: --| Insert_Ic_Item_Mst |

16: --| This package contains all utility functions that insert/update Item |
17: --| related tables |
18: --| |
19: --| CONTENTS |
20: --| Insert_Ic_Item_Mst |
21: --| Insert_Ic_Item_Cpg |
22: --| |
23: --| HISTORY |
24: --| |

Line 34: --| Insert_Ic_Item_Mst |

30:
31: -- Func start of comments
32: --+==========================================================================+
33: --| FUNCTION NAME |
34: --| Insert_Ic_Item_Mst |
35: --| |
36: --| USAGE |
37: --| Insert a row into ic_item_mst |
38: --| |

Line 37: --| Insert a row into ic_item_mst |

33: --| FUNCTION NAME |
34: --| Insert_Ic_Item_Mst |
35: --| |
36: --| USAGE |
37: --| Insert a row into ic_item_mst |
38: --| |
39: --| DESCRIPTION |
40: --| This procedure inserts a row into ic_item_mst |
41: --| |

Line 40: --| This procedure inserts a row into ic_item_mst |

36: --| USAGE |
37: --| Insert a row into ic_item_mst |
38: --| |
39: --| DESCRIPTION |
40: --| This procedure inserts a row into ic_item_mst |
41: --| |
42: --| PARAMETERS |
43: --| p_ic_item_mst_rec IN RECORD - Item Master Details |
44: --| |

Line 43: --| p_ic_item_mst_rec IN RECORD - Item Master Details |

39: --| DESCRIPTION |
40: --| This procedure inserts a row into ic_item_mst |
41: --| |
42: --| PARAMETERS |
43: --| p_ic_item_mst_rec IN RECORD - Item Master Details |
44: --| |
45: --| RETURNS |
46: --| TRUE - If insert successful |
47: --| FALSE - If insert fails |

Line 55: FUNCTION Insert_Ic_Item_Mst

51: --| 21-OCT-1999 H.Verdding Added Addition Of Attribute Fields |
52: --| B1042722 |
53: --+==========================================================================+
54: -- Func end of comments
55: FUNCTION Insert_Ic_Item_Mst
56: (p_ic_item_mst_rec IN ic_item_mst%ROWTYPE)
57: RETURN BOOLEAN
58: IS
59:

Line 56: (p_ic_item_mst_rec IN ic_item_mst%ROWTYPE)

52: --| B1042722 |
53: --+==========================================================================+
54: -- Func end of comments
55: FUNCTION Insert_Ic_Item_Mst
56: (p_ic_item_mst_rec IN ic_item_mst%ROWTYPE)
57: RETURN BOOLEAN
58: IS
59:
60: BEGIN

Line 62: INSERT INTO ic_item_mst

58: IS
59:
60: BEGIN
61:
62: INSERT INTO ic_item_mst
63: ( item_id
64: , item_no
65: , item_desc1
66: , item_desc2

Line 160: ( p_ic_item_mst_rec.item_id

156: , attribute30
157: , attribute_category
158: )
159: VALUES
160: ( p_ic_item_mst_rec.item_id
161: , p_ic_item_mst_rec.item_no
162: , p_ic_item_mst_rec.item_desc1
163: , p_ic_item_mst_rec.item_desc2
164: , p_ic_item_mst_rec.alt_itema

Line 161: , p_ic_item_mst_rec.item_no

157: , attribute_category
158: )
159: VALUES
160: ( p_ic_item_mst_rec.item_id
161: , p_ic_item_mst_rec.item_no
162: , p_ic_item_mst_rec.item_desc1
163: , p_ic_item_mst_rec.item_desc2
164: , p_ic_item_mst_rec.alt_itema
165: , p_ic_item_mst_rec.alt_itemb

Line 162: , p_ic_item_mst_rec.item_desc1

158: )
159: VALUES
160: ( p_ic_item_mst_rec.item_id
161: , p_ic_item_mst_rec.item_no
162: , p_ic_item_mst_rec.item_desc1
163: , p_ic_item_mst_rec.item_desc2
164: , p_ic_item_mst_rec.alt_itema
165: , p_ic_item_mst_rec.alt_itemb
166: , p_ic_item_mst_rec.item_um

Line 163: , p_ic_item_mst_rec.item_desc2

159: VALUES
160: ( p_ic_item_mst_rec.item_id
161: , p_ic_item_mst_rec.item_no
162: , p_ic_item_mst_rec.item_desc1
163: , p_ic_item_mst_rec.item_desc2
164: , p_ic_item_mst_rec.alt_itema
165: , p_ic_item_mst_rec.alt_itemb
166: , p_ic_item_mst_rec.item_um
167: , p_ic_item_mst_rec.dualum_ind

Line 164: , p_ic_item_mst_rec.alt_itema

160: ( p_ic_item_mst_rec.item_id
161: , p_ic_item_mst_rec.item_no
162: , p_ic_item_mst_rec.item_desc1
163: , p_ic_item_mst_rec.item_desc2
164: , p_ic_item_mst_rec.alt_itema
165: , p_ic_item_mst_rec.alt_itemb
166: , p_ic_item_mst_rec.item_um
167: , p_ic_item_mst_rec.dualum_ind
168: , p_ic_item_mst_rec.item_um2

Line 165: , p_ic_item_mst_rec.alt_itemb

161: , p_ic_item_mst_rec.item_no
162: , p_ic_item_mst_rec.item_desc1
163: , p_ic_item_mst_rec.item_desc2
164: , p_ic_item_mst_rec.alt_itema
165: , p_ic_item_mst_rec.alt_itemb
166: , p_ic_item_mst_rec.item_um
167: , p_ic_item_mst_rec.dualum_ind
168: , p_ic_item_mst_rec.item_um2
169: , p_ic_item_mst_rec.deviation_lo

Line 166: , p_ic_item_mst_rec.item_um

162: , p_ic_item_mst_rec.item_desc1
163: , p_ic_item_mst_rec.item_desc2
164: , p_ic_item_mst_rec.alt_itema
165: , p_ic_item_mst_rec.alt_itemb
166: , p_ic_item_mst_rec.item_um
167: , p_ic_item_mst_rec.dualum_ind
168: , p_ic_item_mst_rec.item_um2
169: , p_ic_item_mst_rec.deviation_lo
170: , p_ic_item_mst_rec.deviation_hi

Line 167: , p_ic_item_mst_rec.dualum_ind

163: , p_ic_item_mst_rec.item_desc2
164: , p_ic_item_mst_rec.alt_itema
165: , p_ic_item_mst_rec.alt_itemb
166: , p_ic_item_mst_rec.item_um
167: , p_ic_item_mst_rec.dualum_ind
168: , p_ic_item_mst_rec.item_um2
169: , p_ic_item_mst_rec.deviation_lo
170: , p_ic_item_mst_rec.deviation_hi
171: , p_ic_item_mst_rec.level_code

Line 168: , p_ic_item_mst_rec.item_um2

164: , p_ic_item_mst_rec.alt_itema
165: , p_ic_item_mst_rec.alt_itemb
166: , p_ic_item_mst_rec.item_um
167: , p_ic_item_mst_rec.dualum_ind
168: , p_ic_item_mst_rec.item_um2
169: , p_ic_item_mst_rec.deviation_lo
170: , p_ic_item_mst_rec.deviation_hi
171: , p_ic_item_mst_rec.level_code
172: , p_ic_item_mst_rec.lot_ctl

Line 169: , p_ic_item_mst_rec.deviation_lo

165: , p_ic_item_mst_rec.alt_itemb
166: , p_ic_item_mst_rec.item_um
167: , p_ic_item_mst_rec.dualum_ind
168: , p_ic_item_mst_rec.item_um2
169: , p_ic_item_mst_rec.deviation_lo
170: , p_ic_item_mst_rec.deviation_hi
171: , p_ic_item_mst_rec.level_code
172: , p_ic_item_mst_rec.lot_ctl
173: , p_ic_item_mst_rec.lot_indivisible

Line 170: , p_ic_item_mst_rec.deviation_hi

166: , p_ic_item_mst_rec.item_um
167: , p_ic_item_mst_rec.dualum_ind
168: , p_ic_item_mst_rec.item_um2
169: , p_ic_item_mst_rec.deviation_lo
170: , p_ic_item_mst_rec.deviation_hi
171: , p_ic_item_mst_rec.level_code
172: , p_ic_item_mst_rec.lot_ctl
173: , p_ic_item_mst_rec.lot_indivisible
174: , p_ic_item_mst_rec.sublot_ctl

Line 171: , p_ic_item_mst_rec.level_code

167: , p_ic_item_mst_rec.dualum_ind
168: , p_ic_item_mst_rec.item_um2
169: , p_ic_item_mst_rec.deviation_lo
170: , p_ic_item_mst_rec.deviation_hi
171: , p_ic_item_mst_rec.level_code
172: , p_ic_item_mst_rec.lot_ctl
173: , p_ic_item_mst_rec.lot_indivisible
174: , p_ic_item_mst_rec.sublot_ctl
175: , p_ic_item_mst_rec.loct_ctl

Line 172: , p_ic_item_mst_rec.lot_ctl

168: , p_ic_item_mst_rec.item_um2
169: , p_ic_item_mst_rec.deviation_lo
170: , p_ic_item_mst_rec.deviation_hi
171: , p_ic_item_mst_rec.level_code
172: , p_ic_item_mst_rec.lot_ctl
173: , p_ic_item_mst_rec.lot_indivisible
174: , p_ic_item_mst_rec.sublot_ctl
175: , p_ic_item_mst_rec.loct_ctl
176: , p_ic_item_mst_rec.noninv_ind

Line 173: , p_ic_item_mst_rec.lot_indivisible

169: , p_ic_item_mst_rec.deviation_lo
170: , p_ic_item_mst_rec.deviation_hi
171: , p_ic_item_mst_rec.level_code
172: , p_ic_item_mst_rec.lot_ctl
173: , p_ic_item_mst_rec.lot_indivisible
174: , p_ic_item_mst_rec.sublot_ctl
175: , p_ic_item_mst_rec.loct_ctl
176: , p_ic_item_mst_rec.noninv_ind
177: , p_ic_item_mst_rec.match_type

Line 174: , p_ic_item_mst_rec.sublot_ctl

170: , p_ic_item_mst_rec.deviation_hi
171: , p_ic_item_mst_rec.level_code
172: , p_ic_item_mst_rec.lot_ctl
173: , p_ic_item_mst_rec.lot_indivisible
174: , p_ic_item_mst_rec.sublot_ctl
175: , p_ic_item_mst_rec.loct_ctl
176: , p_ic_item_mst_rec.noninv_ind
177: , p_ic_item_mst_rec.match_type
178: , p_ic_item_mst_rec.inactive_ind

Line 175: , p_ic_item_mst_rec.loct_ctl

171: , p_ic_item_mst_rec.level_code
172: , p_ic_item_mst_rec.lot_ctl
173: , p_ic_item_mst_rec.lot_indivisible
174: , p_ic_item_mst_rec.sublot_ctl
175: , p_ic_item_mst_rec.loct_ctl
176: , p_ic_item_mst_rec.noninv_ind
177: , p_ic_item_mst_rec.match_type
178: , p_ic_item_mst_rec.inactive_ind
179: , p_ic_item_mst_rec.inv_type

Line 176: , p_ic_item_mst_rec.noninv_ind

172: , p_ic_item_mst_rec.lot_ctl
173: , p_ic_item_mst_rec.lot_indivisible
174: , p_ic_item_mst_rec.sublot_ctl
175: , p_ic_item_mst_rec.loct_ctl
176: , p_ic_item_mst_rec.noninv_ind
177: , p_ic_item_mst_rec.match_type
178: , p_ic_item_mst_rec.inactive_ind
179: , p_ic_item_mst_rec.inv_type
180: , p_ic_item_mst_rec.shelf_life

Line 177: , p_ic_item_mst_rec.match_type

173: , p_ic_item_mst_rec.lot_indivisible
174: , p_ic_item_mst_rec.sublot_ctl
175: , p_ic_item_mst_rec.loct_ctl
176: , p_ic_item_mst_rec.noninv_ind
177: , p_ic_item_mst_rec.match_type
178: , p_ic_item_mst_rec.inactive_ind
179: , p_ic_item_mst_rec.inv_type
180: , p_ic_item_mst_rec.shelf_life
181: , p_ic_item_mst_rec.retest_interval

Line 178: , p_ic_item_mst_rec.inactive_ind

174: , p_ic_item_mst_rec.sublot_ctl
175: , p_ic_item_mst_rec.loct_ctl
176: , p_ic_item_mst_rec.noninv_ind
177: , p_ic_item_mst_rec.match_type
178: , p_ic_item_mst_rec.inactive_ind
179: , p_ic_item_mst_rec.inv_type
180: , p_ic_item_mst_rec.shelf_life
181: , p_ic_item_mst_rec.retest_interval
182: , p_ic_item_mst_rec.item_abccode

Line 179: , p_ic_item_mst_rec.inv_type

175: , p_ic_item_mst_rec.loct_ctl
176: , p_ic_item_mst_rec.noninv_ind
177: , p_ic_item_mst_rec.match_type
178: , p_ic_item_mst_rec.inactive_ind
179: , p_ic_item_mst_rec.inv_type
180: , p_ic_item_mst_rec.shelf_life
181: , p_ic_item_mst_rec.retest_interval
182: , p_ic_item_mst_rec.item_abccode
183: , p_ic_item_mst_rec.gl_class

Line 180: , p_ic_item_mst_rec.shelf_life

176: , p_ic_item_mst_rec.noninv_ind
177: , p_ic_item_mst_rec.match_type
178: , p_ic_item_mst_rec.inactive_ind
179: , p_ic_item_mst_rec.inv_type
180: , p_ic_item_mst_rec.shelf_life
181: , p_ic_item_mst_rec.retest_interval
182: , p_ic_item_mst_rec.item_abccode
183: , p_ic_item_mst_rec.gl_class
184: , p_ic_item_mst_rec.inv_class

Line 181: , p_ic_item_mst_rec.retest_interval

177: , p_ic_item_mst_rec.match_type
178: , p_ic_item_mst_rec.inactive_ind
179: , p_ic_item_mst_rec.inv_type
180: , p_ic_item_mst_rec.shelf_life
181: , p_ic_item_mst_rec.retest_interval
182: , p_ic_item_mst_rec.item_abccode
183: , p_ic_item_mst_rec.gl_class
184: , p_ic_item_mst_rec.inv_class
185: , p_ic_item_mst_rec.sales_class

Line 182: , p_ic_item_mst_rec.item_abccode

178: , p_ic_item_mst_rec.inactive_ind
179: , p_ic_item_mst_rec.inv_type
180: , p_ic_item_mst_rec.shelf_life
181: , p_ic_item_mst_rec.retest_interval
182: , p_ic_item_mst_rec.item_abccode
183: , p_ic_item_mst_rec.gl_class
184: , p_ic_item_mst_rec.inv_class
185: , p_ic_item_mst_rec.sales_class
186: , p_ic_item_mst_rec.ship_class

Line 183: , p_ic_item_mst_rec.gl_class

179: , p_ic_item_mst_rec.inv_type
180: , p_ic_item_mst_rec.shelf_life
181: , p_ic_item_mst_rec.retest_interval
182: , p_ic_item_mst_rec.item_abccode
183: , p_ic_item_mst_rec.gl_class
184: , p_ic_item_mst_rec.inv_class
185: , p_ic_item_mst_rec.sales_class
186: , p_ic_item_mst_rec.ship_class
187: , p_ic_item_mst_rec.frt_class

Line 184: , p_ic_item_mst_rec.inv_class

180: , p_ic_item_mst_rec.shelf_life
181: , p_ic_item_mst_rec.retest_interval
182: , p_ic_item_mst_rec.item_abccode
183: , p_ic_item_mst_rec.gl_class
184: , p_ic_item_mst_rec.inv_class
185: , p_ic_item_mst_rec.sales_class
186: , p_ic_item_mst_rec.ship_class
187: , p_ic_item_mst_rec.frt_class
188: , p_ic_item_mst_rec.price_class

Line 185: , p_ic_item_mst_rec.sales_class

181: , p_ic_item_mst_rec.retest_interval
182: , p_ic_item_mst_rec.item_abccode
183: , p_ic_item_mst_rec.gl_class
184: , p_ic_item_mst_rec.inv_class
185: , p_ic_item_mst_rec.sales_class
186: , p_ic_item_mst_rec.ship_class
187: , p_ic_item_mst_rec.frt_class
188: , p_ic_item_mst_rec.price_class
189: , p_ic_item_mst_rec.storage_class

Line 186: , p_ic_item_mst_rec.ship_class

182: , p_ic_item_mst_rec.item_abccode
183: , p_ic_item_mst_rec.gl_class
184: , p_ic_item_mst_rec.inv_class
185: , p_ic_item_mst_rec.sales_class
186: , p_ic_item_mst_rec.ship_class
187: , p_ic_item_mst_rec.frt_class
188: , p_ic_item_mst_rec.price_class
189: , p_ic_item_mst_rec.storage_class
190: , p_ic_item_mst_rec.purch_class

Line 187: , p_ic_item_mst_rec.frt_class

183: , p_ic_item_mst_rec.gl_class
184: , p_ic_item_mst_rec.inv_class
185: , p_ic_item_mst_rec.sales_class
186: , p_ic_item_mst_rec.ship_class
187: , p_ic_item_mst_rec.frt_class
188: , p_ic_item_mst_rec.price_class
189: , p_ic_item_mst_rec.storage_class
190: , p_ic_item_mst_rec.purch_class
191: , p_ic_item_mst_rec.tax_class

Line 188: , p_ic_item_mst_rec.price_class

184: , p_ic_item_mst_rec.inv_class
185: , p_ic_item_mst_rec.sales_class
186: , p_ic_item_mst_rec.ship_class
187: , p_ic_item_mst_rec.frt_class
188: , p_ic_item_mst_rec.price_class
189: , p_ic_item_mst_rec.storage_class
190: , p_ic_item_mst_rec.purch_class
191: , p_ic_item_mst_rec.tax_class
192: , p_ic_item_mst_rec.customs_class

Line 189: , p_ic_item_mst_rec.storage_class

185: , p_ic_item_mst_rec.sales_class
186: , p_ic_item_mst_rec.ship_class
187: , p_ic_item_mst_rec.frt_class
188: , p_ic_item_mst_rec.price_class
189: , p_ic_item_mst_rec.storage_class
190: , p_ic_item_mst_rec.purch_class
191: , p_ic_item_mst_rec.tax_class
192: , p_ic_item_mst_rec.customs_class
193: , p_ic_item_mst_rec.alloc_class

Line 190: , p_ic_item_mst_rec.purch_class

186: , p_ic_item_mst_rec.ship_class
187: , p_ic_item_mst_rec.frt_class
188: , p_ic_item_mst_rec.price_class
189: , p_ic_item_mst_rec.storage_class
190: , p_ic_item_mst_rec.purch_class
191: , p_ic_item_mst_rec.tax_class
192: , p_ic_item_mst_rec.customs_class
193: , p_ic_item_mst_rec.alloc_class
194: , p_ic_item_mst_rec.planning_class

Line 191: , p_ic_item_mst_rec.tax_class

187: , p_ic_item_mst_rec.frt_class
188: , p_ic_item_mst_rec.price_class
189: , p_ic_item_mst_rec.storage_class
190: , p_ic_item_mst_rec.purch_class
191: , p_ic_item_mst_rec.tax_class
192: , p_ic_item_mst_rec.customs_class
193: , p_ic_item_mst_rec.alloc_class
194: , p_ic_item_mst_rec.planning_class
195: , p_ic_item_mst_rec.itemcost_class

Line 192: , p_ic_item_mst_rec.customs_class

188: , p_ic_item_mst_rec.price_class
189: , p_ic_item_mst_rec.storage_class
190: , p_ic_item_mst_rec.purch_class
191: , p_ic_item_mst_rec.tax_class
192: , p_ic_item_mst_rec.customs_class
193: , p_ic_item_mst_rec.alloc_class
194: , p_ic_item_mst_rec.planning_class
195: , p_ic_item_mst_rec.itemcost_class
196: , p_ic_item_mst_rec.cost_mthd_code

Line 193: , p_ic_item_mst_rec.alloc_class

189: , p_ic_item_mst_rec.storage_class
190: , p_ic_item_mst_rec.purch_class
191: , p_ic_item_mst_rec.tax_class
192: , p_ic_item_mst_rec.customs_class
193: , p_ic_item_mst_rec.alloc_class
194: , p_ic_item_mst_rec.planning_class
195: , p_ic_item_mst_rec.itemcost_class
196: , p_ic_item_mst_rec.cost_mthd_code
197: , p_ic_item_mst_rec.upc_code

Line 194: , p_ic_item_mst_rec.planning_class

190: , p_ic_item_mst_rec.purch_class
191: , p_ic_item_mst_rec.tax_class
192: , p_ic_item_mst_rec.customs_class
193: , p_ic_item_mst_rec.alloc_class
194: , p_ic_item_mst_rec.planning_class
195: , p_ic_item_mst_rec.itemcost_class
196: , p_ic_item_mst_rec.cost_mthd_code
197: , p_ic_item_mst_rec.upc_code
198: , p_ic_item_mst_rec.grade_ctl

Line 195: , p_ic_item_mst_rec.itemcost_class

191: , p_ic_item_mst_rec.tax_class
192: , p_ic_item_mst_rec.customs_class
193: , p_ic_item_mst_rec.alloc_class
194: , p_ic_item_mst_rec.planning_class
195: , p_ic_item_mst_rec.itemcost_class
196: , p_ic_item_mst_rec.cost_mthd_code
197: , p_ic_item_mst_rec.upc_code
198: , p_ic_item_mst_rec.grade_ctl
199: , p_ic_item_mst_rec.status_ctl

Line 196: , p_ic_item_mst_rec.cost_mthd_code

192: , p_ic_item_mst_rec.customs_class
193: , p_ic_item_mst_rec.alloc_class
194: , p_ic_item_mst_rec.planning_class
195: , p_ic_item_mst_rec.itemcost_class
196: , p_ic_item_mst_rec.cost_mthd_code
197: , p_ic_item_mst_rec.upc_code
198: , p_ic_item_mst_rec.grade_ctl
199: , p_ic_item_mst_rec.status_ctl
200: , p_ic_item_mst_rec.qc_grade

Line 197: , p_ic_item_mst_rec.upc_code

193: , p_ic_item_mst_rec.alloc_class
194: , p_ic_item_mst_rec.planning_class
195: , p_ic_item_mst_rec.itemcost_class
196: , p_ic_item_mst_rec.cost_mthd_code
197: , p_ic_item_mst_rec.upc_code
198: , p_ic_item_mst_rec.grade_ctl
199: , p_ic_item_mst_rec.status_ctl
200: , p_ic_item_mst_rec.qc_grade
201: , p_ic_item_mst_rec.lot_status

Line 198: , p_ic_item_mst_rec.grade_ctl

194: , p_ic_item_mst_rec.planning_class
195: , p_ic_item_mst_rec.itemcost_class
196: , p_ic_item_mst_rec.cost_mthd_code
197: , p_ic_item_mst_rec.upc_code
198: , p_ic_item_mst_rec.grade_ctl
199: , p_ic_item_mst_rec.status_ctl
200: , p_ic_item_mst_rec.qc_grade
201: , p_ic_item_mst_rec.lot_status
202: , p_ic_item_mst_rec.bulk_id

Line 199: , p_ic_item_mst_rec.status_ctl

195: , p_ic_item_mst_rec.itemcost_class
196: , p_ic_item_mst_rec.cost_mthd_code
197: , p_ic_item_mst_rec.upc_code
198: , p_ic_item_mst_rec.grade_ctl
199: , p_ic_item_mst_rec.status_ctl
200: , p_ic_item_mst_rec.qc_grade
201: , p_ic_item_mst_rec.lot_status
202: , p_ic_item_mst_rec.bulk_id
203: , p_ic_item_mst_rec.pkg_id

Line 200: , p_ic_item_mst_rec.qc_grade

196: , p_ic_item_mst_rec.cost_mthd_code
197: , p_ic_item_mst_rec.upc_code
198: , p_ic_item_mst_rec.grade_ctl
199: , p_ic_item_mst_rec.status_ctl
200: , p_ic_item_mst_rec.qc_grade
201: , p_ic_item_mst_rec.lot_status
202: , p_ic_item_mst_rec.bulk_id
203: , p_ic_item_mst_rec.pkg_id
204: , p_ic_item_mst_rec.qcitem_id

Line 201: , p_ic_item_mst_rec.lot_status

197: , p_ic_item_mst_rec.upc_code
198: , p_ic_item_mst_rec.grade_ctl
199: , p_ic_item_mst_rec.status_ctl
200: , p_ic_item_mst_rec.qc_grade
201: , p_ic_item_mst_rec.lot_status
202: , p_ic_item_mst_rec.bulk_id
203: , p_ic_item_mst_rec.pkg_id
204: , p_ic_item_mst_rec.qcitem_id
205: , p_ic_item_mst_rec.qchold_res_code

Line 202: , p_ic_item_mst_rec.bulk_id

198: , p_ic_item_mst_rec.grade_ctl
199: , p_ic_item_mst_rec.status_ctl
200: , p_ic_item_mst_rec.qc_grade
201: , p_ic_item_mst_rec.lot_status
202: , p_ic_item_mst_rec.bulk_id
203: , p_ic_item_mst_rec.pkg_id
204: , p_ic_item_mst_rec.qcitem_id
205: , p_ic_item_mst_rec.qchold_res_code
206: , p_ic_item_mst_rec.expaction_code

Line 203: , p_ic_item_mst_rec.pkg_id

199: , p_ic_item_mst_rec.status_ctl
200: , p_ic_item_mst_rec.qc_grade
201: , p_ic_item_mst_rec.lot_status
202: , p_ic_item_mst_rec.bulk_id
203: , p_ic_item_mst_rec.pkg_id
204: , p_ic_item_mst_rec.qcitem_id
205: , p_ic_item_mst_rec.qchold_res_code
206: , p_ic_item_mst_rec.expaction_code
207: , p_ic_item_mst_rec.fill_qty

Line 204: , p_ic_item_mst_rec.qcitem_id

200: , p_ic_item_mst_rec.qc_grade
201: , p_ic_item_mst_rec.lot_status
202: , p_ic_item_mst_rec.bulk_id
203: , p_ic_item_mst_rec.pkg_id
204: , p_ic_item_mst_rec.qcitem_id
205: , p_ic_item_mst_rec.qchold_res_code
206: , p_ic_item_mst_rec.expaction_code
207: , p_ic_item_mst_rec.fill_qty
208: , p_ic_item_mst_rec.fill_um

Line 205: , p_ic_item_mst_rec.qchold_res_code

201: , p_ic_item_mst_rec.lot_status
202: , p_ic_item_mst_rec.bulk_id
203: , p_ic_item_mst_rec.pkg_id
204: , p_ic_item_mst_rec.qcitem_id
205: , p_ic_item_mst_rec.qchold_res_code
206: , p_ic_item_mst_rec.expaction_code
207: , p_ic_item_mst_rec.fill_qty
208: , p_ic_item_mst_rec.fill_um
209: , p_ic_item_mst_rec.expaction_interval

Line 206: , p_ic_item_mst_rec.expaction_code

202: , p_ic_item_mst_rec.bulk_id
203: , p_ic_item_mst_rec.pkg_id
204: , p_ic_item_mst_rec.qcitem_id
205: , p_ic_item_mst_rec.qchold_res_code
206: , p_ic_item_mst_rec.expaction_code
207: , p_ic_item_mst_rec.fill_qty
208: , p_ic_item_mst_rec.fill_um
209: , p_ic_item_mst_rec.expaction_interval
210: , p_ic_item_mst_rec.phantom_type

Line 207: , p_ic_item_mst_rec.fill_qty

203: , p_ic_item_mst_rec.pkg_id
204: , p_ic_item_mst_rec.qcitem_id
205: , p_ic_item_mst_rec.qchold_res_code
206: , p_ic_item_mst_rec.expaction_code
207: , p_ic_item_mst_rec.fill_qty
208: , p_ic_item_mst_rec.fill_um
209: , p_ic_item_mst_rec.expaction_interval
210: , p_ic_item_mst_rec.phantom_type
211: , p_ic_item_mst_rec.whse_item_id

Line 208: , p_ic_item_mst_rec.fill_um

204: , p_ic_item_mst_rec.qcitem_id
205: , p_ic_item_mst_rec.qchold_res_code
206: , p_ic_item_mst_rec.expaction_code
207: , p_ic_item_mst_rec.fill_qty
208: , p_ic_item_mst_rec.fill_um
209: , p_ic_item_mst_rec.expaction_interval
210: , p_ic_item_mst_rec.phantom_type
211: , p_ic_item_mst_rec.whse_item_id
212: , p_ic_item_mst_rec.experimental_ind

Line 209: , p_ic_item_mst_rec.expaction_interval

205: , p_ic_item_mst_rec.qchold_res_code
206: , p_ic_item_mst_rec.expaction_code
207: , p_ic_item_mst_rec.fill_qty
208: , p_ic_item_mst_rec.fill_um
209: , p_ic_item_mst_rec.expaction_interval
210: , p_ic_item_mst_rec.phantom_type
211: , p_ic_item_mst_rec.whse_item_id
212: , p_ic_item_mst_rec.experimental_ind
213: , p_ic_item_mst_rec.exported_date

Line 210: , p_ic_item_mst_rec.phantom_type

206: , p_ic_item_mst_rec.expaction_code
207: , p_ic_item_mst_rec.fill_qty
208: , p_ic_item_mst_rec.fill_um
209: , p_ic_item_mst_rec.expaction_interval
210: , p_ic_item_mst_rec.phantom_type
211: , p_ic_item_mst_rec.whse_item_id
212: , p_ic_item_mst_rec.experimental_ind
213: , p_ic_item_mst_rec.exported_date
214: , p_ic_item_mst_rec.created_by

Line 211: , p_ic_item_mst_rec.whse_item_id

207: , p_ic_item_mst_rec.fill_qty
208: , p_ic_item_mst_rec.fill_um
209: , p_ic_item_mst_rec.expaction_interval
210: , p_ic_item_mst_rec.phantom_type
211: , p_ic_item_mst_rec.whse_item_id
212: , p_ic_item_mst_rec.experimental_ind
213: , p_ic_item_mst_rec.exported_date
214: , p_ic_item_mst_rec.created_by
215: , p_ic_item_mst_rec.creation_date

Line 212: , p_ic_item_mst_rec.experimental_ind

208: , p_ic_item_mst_rec.fill_um
209: , p_ic_item_mst_rec.expaction_interval
210: , p_ic_item_mst_rec.phantom_type
211: , p_ic_item_mst_rec.whse_item_id
212: , p_ic_item_mst_rec.experimental_ind
213: , p_ic_item_mst_rec.exported_date
214: , p_ic_item_mst_rec.created_by
215: , p_ic_item_mst_rec.creation_date
216: , p_ic_item_mst_rec.last_updated_by

Line 213: , p_ic_item_mst_rec.exported_date

209: , p_ic_item_mst_rec.expaction_interval
210: , p_ic_item_mst_rec.phantom_type
211: , p_ic_item_mst_rec.whse_item_id
212: , p_ic_item_mst_rec.experimental_ind
213: , p_ic_item_mst_rec.exported_date
214: , p_ic_item_mst_rec.created_by
215: , p_ic_item_mst_rec.creation_date
216: , p_ic_item_mst_rec.last_updated_by
217: , p_ic_item_mst_rec.last_update_date

Line 214: , p_ic_item_mst_rec.created_by

210: , p_ic_item_mst_rec.phantom_type
211: , p_ic_item_mst_rec.whse_item_id
212: , p_ic_item_mst_rec.experimental_ind
213: , p_ic_item_mst_rec.exported_date
214: , p_ic_item_mst_rec.created_by
215: , p_ic_item_mst_rec.creation_date
216: , p_ic_item_mst_rec.last_updated_by
217: , p_ic_item_mst_rec.last_update_date
218: , p_ic_item_mst_rec.last_update_login

Line 215: , p_ic_item_mst_rec.creation_date

211: , p_ic_item_mst_rec.whse_item_id
212: , p_ic_item_mst_rec.experimental_ind
213: , p_ic_item_mst_rec.exported_date
214: , p_ic_item_mst_rec.created_by
215: , p_ic_item_mst_rec.creation_date
216: , p_ic_item_mst_rec.last_updated_by
217: , p_ic_item_mst_rec.last_update_date
218: , p_ic_item_mst_rec.last_update_login
219: , p_ic_item_mst_rec.trans_cnt

Line 216: , p_ic_item_mst_rec.last_updated_by

212: , p_ic_item_mst_rec.experimental_ind
213: , p_ic_item_mst_rec.exported_date
214: , p_ic_item_mst_rec.created_by
215: , p_ic_item_mst_rec.creation_date
216: , p_ic_item_mst_rec.last_updated_by
217: , p_ic_item_mst_rec.last_update_date
218: , p_ic_item_mst_rec.last_update_login
219: , p_ic_item_mst_rec.trans_cnt
220: , p_ic_item_mst_rec.delete_mark

Line 217: , p_ic_item_mst_rec.last_update_date

213: , p_ic_item_mst_rec.exported_date
214: , p_ic_item_mst_rec.created_by
215: , p_ic_item_mst_rec.creation_date
216: , p_ic_item_mst_rec.last_updated_by
217: , p_ic_item_mst_rec.last_update_date
218: , p_ic_item_mst_rec.last_update_login
219: , p_ic_item_mst_rec.trans_cnt
220: , p_ic_item_mst_rec.delete_mark
221: , p_ic_item_mst_rec.text_code

Line 218: , p_ic_item_mst_rec.last_update_login

214: , p_ic_item_mst_rec.created_by
215: , p_ic_item_mst_rec.creation_date
216: , p_ic_item_mst_rec.last_updated_by
217: , p_ic_item_mst_rec.last_update_date
218: , p_ic_item_mst_rec.last_update_login
219: , p_ic_item_mst_rec.trans_cnt
220: , p_ic_item_mst_rec.delete_mark
221: , p_ic_item_mst_rec.text_code
222: , p_ic_item_mst_rec.seq_dpnd_class

Line 219: , p_ic_item_mst_rec.trans_cnt

215: , p_ic_item_mst_rec.creation_date
216: , p_ic_item_mst_rec.last_updated_by
217: , p_ic_item_mst_rec.last_update_date
218: , p_ic_item_mst_rec.last_update_login
219: , p_ic_item_mst_rec.trans_cnt
220: , p_ic_item_mst_rec.delete_mark
221: , p_ic_item_mst_rec.text_code
222: , p_ic_item_mst_rec.seq_dpnd_class
223: , p_ic_item_mst_rec.commodity_code

Line 220: , p_ic_item_mst_rec.delete_mark

216: , p_ic_item_mst_rec.last_updated_by
217: , p_ic_item_mst_rec.last_update_date
218: , p_ic_item_mst_rec.last_update_login
219: , p_ic_item_mst_rec.trans_cnt
220: , p_ic_item_mst_rec.delete_mark
221: , p_ic_item_mst_rec.text_code
222: , p_ic_item_mst_rec.seq_dpnd_class
223: , p_ic_item_mst_rec.commodity_code
224: , p_ic_item_mst_rec.attribute1

Line 221: , p_ic_item_mst_rec.text_code

217: , p_ic_item_mst_rec.last_update_date
218: , p_ic_item_mst_rec.last_update_login
219: , p_ic_item_mst_rec.trans_cnt
220: , p_ic_item_mst_rec.delete_mark
221: , p_ic_item_mst_rec.text_code
222: , p_ic_item_mst_rec.seq_dpnd_class
223: , p_ic_item_mst_rec.commodity_code
224: , p_ic_item_mst_rec.attribute1
225: , p_ic_item_mst_rec.attribute2

Line 222: , p_ic_item_mst_rec.seq_dpnd_class

218: , p_ic_item_mst_rec.last_update_login
219: , p_ic_item_mst_rec.trans_cnt
220: , p_ic_item_mst_rec.delete_mark
221: , p_ic_item_mst_rec.text_code
222: , p_ic_item_mst_rec.seq_dpnd_class
223: , p_ic_item_mst_rec.commodity_code
224: , p_ic_item_mst_rec.attribute1
225: , p_ic_item_mst_rec.attribute2
226: , p_ic_item_mst_rec.attribute3

Line 223: , p_ic_item_mst_rec.commodity_code

219: , p_ic_item_mst_rec.trans_cnt
220: , p_ic_item_mst_rec.delete_mark
221: , p_ic_item_mst_rec.text_code
222: , p_ic_item_mst_rec.seq_dpnd_class
223: , p_ic_item_mst_rec.commodity_code
224: , p_ic_item_mst_rec.attribute1
225: , p_ic_item_mst_rec.attribute2
226: , p_ic_item_mst_rec.attribute3
227: , p_ic_item_mst_rec.attribute4

Line 224: , p_ic_item_mst_rec.attribute1

220: , p_ic_item_mst_rec.delete_mark
221: , p_ic_item_mst_rec.text_code
222: , p_ic_item_mst_rec.seq_dpnd_class
223: , p_ic_item_mst_rec.commodity_code
224: , p_ic_item_mst_rec.attribute1
225: , p_ic_item_mst_rec.attribute2
226: , p_ic_item_mst_rec.attribute3
227: , p_ic_item_mst_rec.attribute4
228: , p_ic_item_mst_rec.attribute5

Line 225: , p_ic_item_mst_rec.attribute2

221: , p_ic_item_mst_rec.text_code
222: , p_ic_item_mst_rec.seq_dpnd_class
223: , p_ic_item_mst_rec.commodity_code
224: , p_ic_item_mst_rec.attribute1
225: , p_ic_item_mst_rec.attribute2
226: , p_ic_item_mst_rec.attribute3
227: , p_ic_item_mst_rec.attribute4
228: , p_ic_item_mst_rec.attribute5
229: , p_ic_item_mst_rec.attribute6

Line 226: , p_ic_item_mst_rec.attribute3

222: , p_ic_item_mst_rec.seq_dpnd_class
223: , p_ic_item_mst_rec.commodity_code
224: , p_ic_item_mst_rec.attribute1
225: , p_ic_item_mst_rec.attribute2
226: , p_ic_item_mst_rec.attribute3
227: , p_ic_item_mst_rec.attribute4
228: , p_ic_item_mst_rec.attribute5
229: , p_ic_item_mst_rec.attribute6
230: , p_ic_item_mst_rec.attribute7

Line 227: , p_ic_item_mst_rec.attribute4

223: , p_ic_item_mst_rec.commodity_code
224: , p_ic_item_mst_rec.attribute1
225: , p_ic_item_mst_rec.attribute2
226: , p_ic_item_mst_rec.attribute3
227: , p_ic_item_mst_rec.attribute4
228: , p_ic_item_mst_rec.attribute5
229: , p_ic_item_mst_rec.attribute6
230: , p_ic_item_mst_rec.attribute7
231: , p_ic_item_mst_rec.attribute8

Line 228: , p_ic_item_mst_rec.attribute5

224: , p_ic_item_mst_rec.attribute1
225: , p_ic_item_mst_rec.attribute2
226: , p_ic_item_mst_rec.attribute3
227: , p_ic_item_mst_rec.attribute4
228: , p_ic_item_mst_rec.attribute5
229: , p_ic_item_mst_rec.attribute6
230: , p_ic_item_mst_rec.attribute7
231: , p_ic_item_mst_rec.attribute8
232: , p_ic_item_mst_rec.attribute9

Line 229: , p_ic_item_mst_rec.attribute6

225: , p_ic_item_mst_rec.attribute2
226: , p_ic_item_mst_rec.attribute3
227: , p_ic_item_mst_rec.attribute4
228: , p_ic_item_mst_rec.attribute5
229: , p_ic_item_mst_rec.attribute6
230: , p_ic_item_mst_rec.attribute7
231: , p_ic_item_mst_rec.attribute8
232: , p_ic_item_mst_rec.attribute9
233: , p_ic_item_mst_rec.attribute10

Line 230: , p_ic_item_mst_rec.attribute7

226: , p_ic_item_mst_rec.attribute3
227: , p_ic_item_mst_rec.attribute4
228: , p_ic_item_mst_rec.attribute5
229: , p_ic_item_mst_rec.attribute6
230: , p_ic_item_mst_rec.attribute7
231: , p_ic_item_mst_rec.attribute8
232: , p_ic_item_mst_rec.attribute9
233: , p_ic_item_mst_rec.attribute10
234: , p_ic_item_mst_rec.attribute11

Line 231: , p_ic_item_mst_rec.attribute8

227: , p_ic_item_mst_rec.attribute4
228: , p_ic_item_mst_rec.attribute5
229: , p_ic_item_mst_rec.attribute6
230: , p_ic_item_mst_rec.attribute7
231: , p_ic_item_mst_rec.attribute8
232: , p_ic_item_mst_rec.attribute9
233: , p_ic_item_mst_rec.attribute10
234: , p_ic_item_mst_rec.attribute11
235: , p_ic_item_mst_rec.attribute12

Line 232: , p_ic_item_mst_rec.attribute9

228: , p_ic_item_mst_rec.attribute5
229: , p_ic_item_mst_rec.attribute6
230: , p_ic_item_mst_rec.attribute7
231: , p_ic_item_mst_rec.attribute8
232: , p_ic_item_mst_rec.attribute9
233: , p_ic_item_mst_rec.attribute10
234: , p_ic_item_mst_rec.attribute11
235: , p_ic_item_mst_rec.attribute12
236: , p_ic_item_mst_rec.attribute13

Line 233: , p_ic_item_mst_rec.attribute10

229: , p_ic_item_mst_rec.attribute6
230: , p_ic_item_mst_rec.attribute7
231: , p_ic_item_mst_rec.attribute8
232: , p_ic_item_mst_rec.attribute9
233: , p_ic_item_mst_rec.attribute10
234: , p_ic_item_mst_rec.attribute11
235: , p_ic_item_mst_rec.attribute12
236: , p_ic_item_mst_rec.attribute13
237: , p_ic_item_mst_rec.attribute14

Line 234: , p_ic_item_mst_rec.attribute11

230: , p_ic_item_mst_rec.attribute7
231: , p_ic_item_mst_rec.attribute8
232: , p_ic_item_mst_rec.attribute9
233: , p_ic_item_mst_rec.attribute10
234: , p_ic_item_mst_rec.attribute11
235: , p_ic_item_mst_rec.attribute12
236: , p_ic_item_mst_rec.attribute13
237: , p_ic_item_mst_rec.attribute14
238: , p_ic_item_mst_rec.attribute15

Line 235: , p_ic_item_mst_rec.attribute12

231: , p_ic_item_mst_rec.attribute8
232: , p_ic_item_mst_rec.attribute9
233: , p_ic_item_mst_rec.attribute10
234: , p_ic_item_mst_rec.attribute11
235: , p_ic_item_mst_rec.attribute12
236: , p_ic_item_mst_rec.attribute13
237: , p_ic_item_mst_rec.attribute14
238: , p_ic_item_mst_rec.attribute15
239: , p_ic_item_mst_rec.attribute16

Line 236: , p_ic_item_mst_rec.attribute13

232: , p_ic_item_mst_rec.attribute9
233: , p_ic_item_mst_rec.attribute10
234: , p_ic_item_mst_rec.attribute11
235: , p_ic_item_mst_rec.attribute12
236: , p_ic_item_mst_rec.attribute13
237: , p_ic_item_mst_rec.attribute14
238: , p_ic_item_mst_rec.attribute15
239: , p_ic_item_mst_rec.attribute16
240: , p_ic_item_mst_rec.attribute17

Line 237: , p_ic_item_mst_rec.attribute14

233: , p_ic_item_mst_rec.attribute10
234: , p_ic_item_mst_rec.attribute11
235: , p_ic_item_mst_rec.attribute12
236: , p_ic_item_mst_rec.attribute13
237: , p_ic_item_mst_rec.attribute14
238: , p_ic_item_mst_rec.attribute15
239: , p_ic_item_mst_rec.attribute16
240: , p_ic_item_mst_rec.attribute17
241: , p_ic_item_mst_rec.attribute18

Line 238: , p_ic_item_mst_rec.attribute15

234: , p_ic_item_mst_rec.attribute11
235: , p_ic_item_mst_rec.attribute12
236: , p_ic_item_mst_rec.attribute13
237: , p_ic_item_mst_rec.attribute14
238: , p_ic_item_mst_rec.attribute15
239: , p_ic_item_mst_rec.attribute16
240: , p_ic_item_mst_rec.attribute17
241: , p_ic_item_mst_rec.attribute18
242: , p_ic_item_mst_rec.attribute19

Line 239: , p_ic_item_mst_rec.attribute16

235: , p_ic_item_mst_rec.attribute12
236: , p_ic_item_mst_rec.attribute13
237: , p_ic_item_mst_rec.attribute14
238: , p_ic_item_mst_rec.attribute15
239: , p_ic_item_mst_rec.attribute16
240: , p_ic_item_mst_rec.attribute17
241: , p_ic_item_mst_rec.attribute18
242: , p_ic_item_mst_rec.attribute19
243: , p_ic_item_mst_rec.attribute20

Line 240: , p_ic_item_mst_rec.attribute17

236: , p_ic_item_mst_rec.attribute13
237: , p_ic_item_mst_rec.attribute14
238: , p_ic_item_mst_rec.attribute15
239: , p_ic_item_mst_rec.attribute16
240: , p_ic_item_mst_rec.attribute17
241: , p_ic_item_mst_rec.attribute18
242: , p_ic_item_mst_rec.attribute19
243: , p_ic_item_mst_rec.attribute20
244: , p_ic_item_mst_rec.attribute21

Line 241: , p_ic_item_mst_rec.attribute18

237: , p_ic_item_mst_rec.attribute14
238: , p_ic_item_mst_rec.attribute15
239: , p_ic_item_mst_rec.attribute16
240: , p_ic_item_mst_rec.attribute17
241: , p_ic_item_mst_rec.attribute18
242: , p_ic_item_mst_rec.attribute19
243: , p_ic_item_mst_rec.attribute20
244: , p_ic_item_mst_rec.attribute21
245: , p_ic_item_mst_rec.attribute22

Line 242: , p_ic_item_mst_rec.attribute19

238: , p_ic_item_mst_rec.attribute15
239: , p_ic_item_mst_rec.attribute16
240: , p_ic_item_mst_rec.attribute17
241: , p_ic_item_mst_rec.attribute18
242: , p_ic_item_mst_rec.attribute19
243: , p_ic_item_mst_rec.attribute20
244: , p_ic_item_mst_rec.attribute21
245: , p_ic_item_mst_rec.attribute22
246: , p_ic_item_mst_rec.attribute23

Line 243: , p_ic_item_mst_rec.attribute20

239: , p_ic_item_mst_rec.attribute16
240: , p_ic_item_mst_rec.attribute17
241: , p_ic_item_mst_rec.attribute18
242: , p_ic_item_mst_rec.attribute19
243: , p_ic_item_mst_rec.attribute20
244: , p_ic_item_mst_rec.attribute21
245: , p_ic_item_mst_rec.attribute22
246: , p_ic_item_mst_rec.attribute23
247: , p_ic_item_mst_rec.attribute24

Line 244: , p_ic_item_mst_rec.attribute21

240: , p_ic_item_mst_rec.attribute17
241: , p_ic_item_mst_rec.attribute18
242: , p_ic_item_mst_rec.attribute19
243: , p_ic_item_mst_rec.attribute20
244: , p_ic_item_mst_rec.attribute21
245: , p_ic_item_mst_rec.attribute22
246: , p_ic_item_mst_rec.attribute23
247: , p_ic_item_mst_rec.attribute24
248: , p_ic_item_mst_rec.attribute25

Line 245: , p_ic_item_mst_rec.attribute22

241: , p_ic_item_mst_rec.attribute18
242: , p_ic_item_mst_rec.attribute19
243: , p_ic_item_mst_rec.attribute20
244: , p_ic_item_mst_rec.attribute21
245: , p_ic_item_mst_rec.attribute22
246: , p_ic_item_mst_rec.attribute23
247: , p_ic_item_mst_rec.attribute24
248: , p_ic_item_mst_rec.attribute25
249: , p_ic_item_mst_rec.attribute26

Line 246: , p_ic_item_mst_rec.attribute23

242: , p_ic_item_mst_rec.attribute19
243: , p_ic_item_mst_rec.attribute20
244: , p_ic_item_mst_rec.attribute21
245: , p_ic_item_mst_rec.attribute22
246: , p_ic_item_mst_rec.attribute23
247: , p_ic_item_mst_rec.attribute24
248: , p_ic_item_mst_rec.attribute25
249: , p_ic_item_mst_rec.attribute26
250: , p_ic_item_mst_rec.attribute27

Line 247: , p_ic_item_mst_rec.attribute24

243: , p_ic_item_mst_rec.attribute20
244: , p_ic_item_mst_rec.attribute21
245: , p_ic_item_mst_rec.attribute22
246: , p_ic_item_mst_rec.attribute23
247: , p_ic_item_mst_rec.attribute24
248: , p_ic_item_mst_rec.attribute25
249: , p_ic_item_mst_rec.attribute26
250: , p_ic_item_mst_rec.attribute27
251: , p_ic_item_mst_rec.attribute28

Line 248: , p_ic_item_mst_rec.attribute25

244: , p_ic_item_mst_rec.attribute21
245: , p_ic_item_mst_rec.attribute22
246: , p_ic_item_mst_rec.attribute23
247: , p_ic_item_mst_rec.attribute24
248: , p_ic_item_mst_rec.attribute25
249: , p_ic_item_mst_rec.attribute26
250: , p_ic_item_mst_rec.attribute27
251: , p_ic_item_mst_rec.attribute28
252: , p_ic_item_mst_rec.attribute29

Line 249: , p_ic_item_mst_rec.attribute26

245: , p_ic_item_mst_rec.attribute22
246: , p_ic_item_mst_rec.attribute23
247: , p_ic_item_mst_rec.attribute24
248: , p_ic_item_mst_rec.attribute25
249: , p_ic_item_mst_rec.attribute26
250: , p_ic_item_mst_rec.attribute27
251: , p_ic_item_mst_rec.attribute28
252: , p_ic_item_mst_rec.attribute29
253: , p_ic_item_mst_rec.attribute30

Line 250: , p_ic_item_mst_rec.attribute27

246: , p_ic_item_mst_rec.attribute23
247: , p_ic_item_mst_rec.attribute24
248: , p_ic_item_mst_rec.attribute25
249: , p_ic_item_mst_rec.attribute26
250: , p_ic_item_mst_rec.attribute27
251: , p_ic_item_mst_rec.attribute28
252: , p_ic_item_mst_rec.attribute29
253: , p_ic_item_mst_rec.attribute30
254: , p_ic_item_mst_rec.attribute_category

Line 251: , p_ic_item_mst_rec.attribute28

247: , p_ic_item_mst_rec.attribute24
248: , p_ic_item_mst_rec.attribute25
249: , p_ic_item_mst_rec.attribute26
250: , p_ic_item_mst_rec.attribute27
251: , p_ic_item_mst_rec.attribute28
252: , p_ic_item_mst_rec.attribute29
253: , p_ic_item_mst_rec.attribute30
254: , p_ic_item_mst_rec.attribute_category
255: );

Line 252: , p_ic_item_mst_rec.attribute29

248: , p_ic_item_mst_rec.attribute25
249: , p_ic_item_mst_rec.attribute26
250: , p_ic_item_mst_rec.attribute27
251: , p_ic_item_mst_rec.attribute28
252: , p_ic_item_mst_rec.attribute29
253: , p_ic_item_mst_rec.attribute30
254: , p_ic_item_mst_rec.attribute_category
255: );
256:

Line 253: , p_ic_item_mst_rec.attribute30

249: , p_ic_item_mst_rec.attribute26
250: , p_ic_item_mst_rec.attribute27
251: , p_ic_item_mst_rec.attribute28
252: , p_ic_item_mst_rec.attribute29
253: , p_ic_item_mst_rec.attribute30
254: , p_ic_item_mst_rec.attribute_category
255: );
256:
257: RETURN TRUE;

Line 254: , p_ic_item_mst_rec.attribute_category

250: , p_ic_item_mst_rec.attribute27
251: , p_ic_item_mst_rec.attribute28
252: , p_ic_item_mst_rec.attribute29
253: , p_ic_item_mst_rec.attribute30
254: , p_ic_item_mst_rec.attribute_category
255: );
256:
257: RETURN TRUE;
258:

Line 267: , 'insert_ic_item_mst'

263: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
264: -- THEN
265:
266: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
267: , 'insert_ic_item_mst'
268: );
269: -- END IF;
270: RETURN FALSE;
271:

Line 272: END Insert_Ic_Item_Mst;

268: );
269: -- END IF;
270: RETURN FALSE;
271:
272: END Insert_Ic_Item_Mst;
273:
274: -- Func start of comments
275: --+==========================================================================+
276: --| FUNCTION NAME |