50: l_return_status := 'S';
51:
52: EGO_Globals.G_Catalog_Group_Rec := EGO_Globals.G_Catalog_Group_Tbl(l_Table_Index);
53:
54: EGO_Item_Catalog_Pub.G_KF_Segment_Values(1) :=
55: EGO_Globals.G_Catalog_Group_Rec.Segment1;
56: EGO_Item_Catalog_Pub.G_KF_Segment_Values(2) :=
57: EGO_Globals.G_Catalog_Group_Rec.Segment2;
58: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
52: EGO_Globals.G_Catalog_Group_Rec := EGO_Globals.G_Catalog_Group_Tbl(l_Table_Index);
53:
54: EGO_Item_Catalog_Pub.G_KF_Segment_Values(1) :=
55: EGO_Globals.G_Catalog_Group_Rec.Segment1;
56: EGO_Item_Catalog_Pub.G_KF_Segment_Values(2) :=
57: EGO_Globals.G_Catalog_Group_Rec.Segment2;
58: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
59: EGO_Globals.G_Catalog_Group_Rec.Segment3;
60: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
54: EGO_Item_Catalog_Pub.G_KF_Segment_Values(1) :=
55: EGO_Globals.G_Catalog_Group_Rec.Segment1;
56: EGO_Item_Catalog_Pub.G_KF_Segment_Values(2) :=
57: EGO_Globals.G_Catalog_Group_Rec.Segment2;
58: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
59: EGO_Globals.G_Catalog_Group_Rec.Segment3;
60: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
61: EGO_Globals.G_Catalog_Group_Rec.Segment4;
62: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
56: EGO_Item_Catalog_Pub.G_KF_Segment_Values(2) :=
57: EGO_Globals.G_Catalog_Group_Rec.Segment2;
58: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
59: EGO_Globals.G_Catalog_Group_Rec.Segment3;
60: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
61: EGO_Globals.G_Catalog_Group_Rec.Segment4;
62: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
63: EGO_Globals.G_Catalog_Group_Rec.Segment5;
64: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
58: EGO_Item_Catalog_Pub.G_KF_Segment_Values(3) :=
59: EGO_Globals.G_Catalog_Group_Rec.Segment3;
60: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
61: EGO_Globals.G_Catalog_Group_Rec.Segment4;
62: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
63: EGO_Globals.G_Catalog_Group_Rec.Segment5;
64: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
65: EGO_Globals.G_Catalog_Group_Rec.Segment6;
66: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
60: EGO_Item_Catalog_Pub.G_KF_Segment_Values(4) :=
61: EGO_Globals.G_Catalog_Group_Rec.Segment4;
62: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
63: EGO_Globals.G_Catalog_Group_Rec.Segment5;
64: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
65: EGO_Globals.G_Catalog_Group_Rec.Segment6;
66: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
67: EGO_Globals.G_Catalog_Group_Rec.Segment7;
68: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
62: EGO_Item_Catalog_Pub.G_KF_Segment_Values(5) :=
63: EGO_Globals.G_Catalog_Group_Rec.Segment5;
64: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
65: EGO_Globals.G_Catalog_Group_Rec.Segment6;
66: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
67: EGO_Globals.G_Catalog_Group_Rec.Segment7;
68: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
69: EGO_Globals.G_Catalog_Group_Rec.Segment8;
70: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
64: EGO_Item_Catalog_Pub.G_KF_Segment_Values(6) :=
65: EGO_Globals.G_Catalog_Group_Rec.Segment6;
66: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
67: EGO_Globals.G_Catalog_Group_Rec.Segment7;
68: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
69: EGO_Globals.G_Catalog_Group_Rec.Segment8;
70: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
71: EGO_Globals.G_Catalog_Group_Rec.Segment9;
72: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
66: EGO_Item_Catalog_Pub.G_KF_Segment_Values(7) :=
67: EGO_Globals.G_Catalog_Group_Rec.Segment7;
68: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
69: EGO_Globals.G_Catalog_Group_Rec.Segment8;
70: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
71: EGO_Globals.G_Catalog_Group_Rec.Segment9;
72: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
73: EGO_Globals.G_Catalog_Group_Rec.Segment10;
74: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
68: EGO_Item_Catalog_Pub.G_KF_Segment_Values(8) :=
69: EGO_Globals.G_Catalog_Group_Rec.Segment8;
70: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
71: EGO_Globals.G_Catalog_Group_Rec.Segment9;
72: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
73: EGO_Globals.G_Catalog_Group_Rec.Segment10;
74: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
75: EGO_Globals.G_Catalog_Group_Rec.Segment11;
76: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
70: EGO_Item_Catalog_Pub.G_KF_Segment_Values(9) :=
71: EGO_Globals.G_Catalog_Group_Rec.Segment9;
72: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
73: EGO_Globals.G_Catalog_Group_Rec.Segment10;
74: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
75: EGO_Globals.G_Catalog_Group_Rec.Segment11;
76: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
77: EGO_Globals.G_Catalog_Group_Rec.Segment12;
78: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
72: EGO_Item_Catalog_Pub.G_KF_Segment_Values(10) :=
73: EGO_Globals.G_Catalog_Group_Rec.Segment10;
74: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
75: EGO_Globals.G_Catalog_Group_Rec.Segment11;
76: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
77: EGO_Globals.G_Catalog_Group_Rec.Segment12;
78: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
79: EGO_Globals.G_Catalog_Group_Rec.Segment13;
80: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
74: EGO_Item_Catalog_Pub.G_KF_Segment_Values(11) :=
75: EGO_Globals.G_Catalog_Group_Rec.Segment11;
76: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
77: EGO_Globals.G_Catalog_Group_Rec.Segment12;
78: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
79: EGO_Globals.G_Catalog_Group_Rec.Segment13;
80: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
81: EGO_Globals.G_Catalog_Group_Rec.Segment14;
82: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
76: EGO_Item_Catalog_Pub.G_KF_Segment_Values(12) :=
77: EGO_Globals.G_Catalog_Group_Rec.Segment12;
78: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
79: EGO_Globals.G_Catalog_Group_Rec.Segment13;
80: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
81: EGO_Globals.G_Catalog_Group_Rec.Segment14;
82: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
83: EGO_Globals.G_Catalog_Group_Rec.Segment15;
84: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
78: EGO_Item_Catalog_Pub.G_KF_Segment_Values(13) :=
79: EGO_Globals.G_Catalog_Group_Rec.Segment13;
80: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
81: EGO_Globals.G_Catalog_Group_Rec.Segment14;
82: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
83: EGO_Globals.G_Catalog_Group_Rec.Segment15;
84: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
85: EGO_Globals.G_Catalog_Group_Rec.Segment16;
86: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
80: EGO_Item_Catalog_Pub.G_KF_Segment_Values(14) :=
81: EGO_Globals.G_Catalog_Group_Rec.Segment14;
82: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
83: EGO_Globals.G_Catalog_Group_Rec.Segment15;
84: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
85: EGO_Globals.G_Catalog_Group_Rec.Segment16;
86: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
87: EGO_Globals.G_Catalog_Group_Rec.Segment17;
88: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
82: EGO_Item_Catalog_Pub.G_KF_Segment_Values(15) :=
83: EGO_Globals.G_Catalog_Group_Rec.Segment15;
84: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
85: EGO_Globals.G_Catalog_Group_Rec.Segment16;
86: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
87: EGO_Globals.G_Catalog_Group_Rec.Segment17;
88: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
89: EGO_Globals.G_Catalog_Group_Rec.Segment18;
90: EGO_Item_Catalog_Pub.G_KF_Segment_Values(19) :=
84: EGO_Item_Catalog_Pub.G_KF_Segment_Values(16) :=
85: EGO_Globals.G_Catalog_Group_Rec.Segment16;
86: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
87: EGO_Globals.G_Catalog_Group_Rec.Segment17;
88: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
89: EGO_Globals.G_Catalog_Group_Rec.Segment18;
90: EGO_Item_Catalog_Pub.G_KF_Segment_Values(19) :=
91: EGO_Globals.G_Catalog_Group_Rec.Segment19;
92: EGO_Item_Catalog_Pub.G_KF_Segment_Values(20) :=
86: EGO_Item_Catalog_Pub.G_KF_Segment_Values(17) :=
87: EGO_Globals.G_Catalog_Group_Rec.Segment17;
88: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
89: EGO_Globals.G_Catalog_Group_Rec.Segment18;
90: EGO_Item_Catalog_Pub.G_KF_Segment_Values(19) :=
91: EGO_Globals.G_Catalog_Group_Rec.Segment19;
92: EGO_Item_Catalog_Pub.G_KF_Segment_Values(20) :=
93: EGO_Globals.G_Catalog_Group_Rec.Segment20;
94:
88: EGO_Item_Catalog_Pub.G_KF_Segment_Values(18) :=
89: EGO_Globals.G_Catalog_Group_Rec.Segment18;
90: EGO_Item_Catalog_Pub.G_KF_Segment_Values(19) :=
91: EGO_Globals.G_Catalog_Group_Rec.Segment19;
92: EGO_Item_Catalog_Pub.G_KF_Segment_Values(20) :=
93: EGO_Globals.G_Catalog_Group_Rec.Segment20;
94:
95:
96:
97: /* Assign null to the segments that are not used */
98:
99: FOR i in 1..20
100: LOOP
101: IF EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) = FND_API.G_MISS_CHAR
102: THEN
103: EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) := null;
104: END IF;
105: END LOOP;
99: FOR i in 1..20
100: LOOP
101: IF EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) = FND_API.G_MISS_CHAR
102: THEN
103: EGO_Item_Catalog_Pub.G_KF_Segment_Values(i) := null;
104: END IF;
105: END LOOP;
106:
107: --