198: END IF; -- parent id not null
199:
200: END IF; -- update
201:
202: EGO_Item_Catalog_Pub.G_KF_Segment_Values(1) :=
203: EGO_Globals.G_Catalog_Group_Rec.Segment1;
204: EGO_Item_Catalog_Pub.G_KF_Segment_Values(2) :=
205: EGO_Globals.G_Catalog_Group_Rec.Segment2;
206: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
200: END IF; -- update
201:
202: EGO_Item_Catalog_Pub.G_KF_Segment_Values(1) :=
203: EGO_Globals.G_Catalog_Group_Rec.Segment1;
204: EGO_Item_Catalog_Pub.G_KF_Segment_Values(2) :=
205: EGO_Globals.G_Catalog_Group_Rec.Segment2;
206: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
207: EGO_Globals.G_Catalog_Group_Rec.Segment3;
208: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
202: EGO_Item_Catalog_Pub.G_KF_Segment_Values(1) :=
203: EGO_Globals.G_Catalog_Group_Rec.Segment1;
204: EGO_Item_Catalog_Pub.G_KF_Segment_Values(2) :=
205: EGO_Globals.G_Catalog_Group_Rec.Segment2;
206: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
207: EGO_Globals.G_Catalog_Group_Rec.Segment3;
208: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
209: EGO_Globals.G_Catalog_Group_Rec.Segment4;
210: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
204: EGO_Item_Catalog_Pub.G_KF_Segment_Values(2) :=
205: EGO_Globals.G_Catalog_Group_Rec.Segment2;
206: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
207: EGO_Globals.G_Catalog_Group_Rec.Segment3;
208: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
209: EGO_Globals.G_Catalog_Group_Rec.Segment4;
210: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
211: EGO_Globals.G_Catalog_Group_Rec.Segment5;
212: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
206: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
207: EGO_Globals.G_Catalog_Group_Rec.Segment3;
208: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
209: EGO_Globals.G_Catalog_Group_Rec.Segment4;
210: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
211: EGO_Globals.G_Catalog_Group_Rec.Segment5;
212: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
213: EGO_Globals.G_Catalog_Group_Rec.Segment6;
214: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
208: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
209: EGO_Globals.G_Catalog_Group_Rec.Segment4;
210: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
211: EGO_Globals.G_Catalog_Group_Rec.Segment5;
212: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
213: EGO_Globals.G_Catalog_Group_Rec.Segment6;
214: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
215: EGO_Globals.G_Catalog_Group_Rec.Segment7;
216: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
210: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
211: EGO_Globals.G_Catalog_Group_Rec.Segment5;
212: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
213: EGO_Globals.G_Catalog_Group_Rec.Segment6;
214: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
215: EGO_Globals.G_Catalog_Group_Rec.Segment7;
216: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
217: EGO_Globals.G_Catalog_Group_Rec.Segment8;
218: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
212: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
213: EGO_Globals.G_Catalog_Group_Rec.Segment6;
214: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
215: EGO_Globals.G_Catalog_Group_Rec.Segment7;
216: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
217: EGO_Globals.G_Catalog_Group_Rec.Segment8;
218: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
219: EGO_Globals.G_Catalog_Group_Rec.Segment9;
220: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
214: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
215: EGO_Globals.G_Catalog_Group_Rec.Segment7;
216: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
217: EGO_Globals.G_Catalog_Group_Rec.Segment8;
218: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
219: EGO_Globals.G_Catalog_Group_Rec.Segment9;
220: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
221: EGO_Globals.G_Catalog_Group_Rec.Segment10;
222: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
216: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
217: EGO_Globals.G_Catalog_Group_Rec.Segment8;
218: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
219: EGO_Globals.G_Catalog_Group_Rec.Segment9;
220: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
221: EGO_Globals.G_Catalog_Group_Rec.Segment10;
222: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
223: EGO_Globals.G_Catalog_Group_Rec.Segment11;
224: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
218: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
219: EGO_Globals.G_Catalog_Group_Rec.Segment9;
220: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
221: EGO_Globals.G_Catalog_Group_Rec.Segment10;
222: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
223: EGO_Globals.G_Catalog_Group_Rec.Segment11;
224: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
225: EGO_Globals.G_Catalog_Group_Rec.Segment12;
226: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
220: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
221: EGO_Globals.G_Catalog_Group_Rec.Segment10;
222: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
223: EGO_Globals.G_Catalog_Group_Rec.Segment11;
224: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
225: EGO_Globals.G_Catalog_Group_Rec.Segment12;
226: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
227: EGO_Globals.G_Catalog_Group_Rec.Segment13;
228: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
222: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
223: EGO_Globals.G_Catalog_Group_Rec.Segment11;
224: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
225: EGO_Globals.G_Catalog_Group_Rec.Segment12;
226: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
227: EGO_Globals.G_Catalog_Group_Rec.Segment13;
228: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
229: EGO_Globals.G_Catalog_Group_Rec.Segment14;
230: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
224: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
225: EGO_Globals.G_Catalog_Group_Rec.Segment12;
226: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
227: EGO_Globals.G_Catalog_Group_Rec.Segment13;
228: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
229: EGO_Globals.G_Catalog_Group_Rec.Segment14;
230: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
231: EGO_Globals.G_Catalog_Group_Rec.Segment15;
232: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
226: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
227: EGO_Globals.G_Catalog_Group_Rec.Segment13;
228: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
229: EGO_Globals.G_Catalog_Group_Rec.Segment14;
230: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
231: EGO_Globals.G_Catalog_Group_Rec.Segment15;
232: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
233: EGO_Globals.G_Catalog_Group_Rec.Segment16;
234: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
228: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
229: EGO_Globals.G_Catalog_Group_Rec.Segment14;
230: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
231: EGO_Globals.G_Catalog_Group_Rec.Segment15;
232: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
233: EGO_Globals.G_Catalog_Group_Rec.Segment16;
234: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
235: EGO_Globals.G_Catalog_Group_Rec.Segment17;
236: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
230: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
231: EGO_Globals.G_Catalog_Group_Rec.Segment15;
232: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
233: EGO_Globals.G_Catalog_Group_Rec.Segment16;
234: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
235: EGO_Globals.G_Catalog_Group_Rec.Segment17;
236: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
237: EGO_Globals.G_Catalog_Group_Rec.Segment18;
238: EGO_Item_Catalog_Pub.G_KF_Segment_Values(19) :=
232: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
233: EGO_Globals.G_Catalog_Group_Rec.Segment16;
234: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
235: EGO_Globals.G_Catalog_Group_Rec.Segment17;
236: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
237: EGO_Globals.G_Catalog_Group_Rec.Segment18;
238: EGO_Item_Catalog_Pub.G_KF_Segment_Values(19) :=
239: EGO_Globals.G_Catalog_Group_Rec.Segment19;
240: EGO_Item_Catalog_Pub.G_KF_Segment_Values(20) :=
234: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
235: EGO_Globals.G_Catalog_Group_Rec.Segment17;
236: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
237: EGO_Globals.G_Catalog_Group_Rec.Segment18;
238: EGO_Item_Catalog_Pub.G_KF_Segment_Values(19) :=
239: EGO_Globals.G_Catalog_Group_Rec.Segment19;
240: EGO_Item_Catalog_Pub.G_KF_Segment_Values(20) :=
241: EGO_Globals.G_Catalog_Group_Rec.Segment20;
242:
236: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
237: EGO_Globals.G_Catalog_Group_Rec.Segment18;
238: EGO_Item_Catalog_Pub.G_KF_Segment_Values(19) :=
239: EGO_Globals.G_Catalog_Group_Rec.Segment19;
240: EGO_Item_Catalog_Pub.G_KF_Segment_Values(20) :=
241: EGO_Globals.G_Catalog_Group_Rec.Segment20;
242:
243:
244:
245: /* Assign null to the segments that are not used */
246:
247: FOR i in 1..20
248: LOOP
249: IF EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) = FND_API.G_MISS_CHAR
250: THEN
251: EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) := null;
252: END IF;
253: END LOOP;
247: FOR i in 1..20
248: LOOP
249: IF EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) = FND_API.G_MISS_CHAR
250: THEN
251: EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) := null;
252: END IF;
253: END LOOP;
254:
255: --