eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_UPLOAD_PUB dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 131: -- l_name_value_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

127: l_association_id NUMBER;
128: l_pages_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
129: l_pages_int_array EGO_COL_NAME_VALUE_PAIR_ARRAY; -- Bug 9949093.
130: l_page_entry_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
131: -- l_name_value_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
132: l_return_status VARCHAR2(1);
133: l_msg_count NUMBER;
134: l_msg_data VARCHAR2(4000);
135:

Line 141: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Physical Attributes'),

137: l_object_id := get_object_id();
138: for k in 1..2 LOOP
139: IF K = 1 THEN
140: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
141: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Physical Attributes'),
142: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Sales and Order Management'),
143: EGO_COL_NAME_VALUE_PAIR_OBJ('30','Planning'),
144: EGO_COL_NAME_VALUE_PAIR_OBJ('40','Purchasing'),
145: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),

Line 142: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Sales and Order Management'),

138: for k in 1..2 LOOP
139: IF K = 1 THEN
140: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
141: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Physical Attributes'),
142: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Sales and Order Management'),
143: EGO_COL_NAME_VALUE_PAIR_OBJ('30','Planning'),
144: EGO_COL_NAME_VALUE_PAIR_OBJ('40','Purchasing'),
145: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),
146: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')

Line 143: EGO_COL_NAME_VALUE_PAIR_OBJ('30','Planning'),

139: IF K = 1 THEN
140: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
141: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Physical Attributes'),
142: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Sales and Order Management'),
143: EGO_COL_NAME_VALUE_PAIR_OBJ('30','Planning'),
144: EGO_COL_NAME_VALUE_PAIR_OBJ('40','Purchasing'),
145: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),
146: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')
147: );

Line 144: EGO_COL_NAME_VALUE_PAIR_OBJ('40','Purchasing'),

140: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
141: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Physical Attributes'),
142: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Sales and Order Management'),
143: EGO_COL_NAME_VALUE_PAIR_OBJ('30','Planning'),
144: EGO_COL_NAME_VALUE_PAIR_OBJ('40','Purchasing'),
145: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),
146: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')
147: );
148: --

Line 145: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),

141: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Physical Attributes'),
142: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Sales and Order Management'),
143: EGO_COL_NAME_VALUE_PAIR_OBJ('30','Planning'),
144: EGO_COL_NAME_VALUE_PAIR_OBJ('40','Purchasing'),
145: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),
146: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')
147: );
148: --
149: -- Bug 9949093. Meta data import creating default pages with

Line 146: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')

142: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Sales and Order Management'),
143: EGO_COL_NAME_VALUE_PAIR_OBJ('30','Planning'),
144: EGO_COL_NAME_VALUE_PAIR_OBJ('40','Purchasing'),
145: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),
146: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')
147: );
148: --
149: -- Bug 9949093. Meta data import creating default pages with
150: -- incorrect internal name. New array for internal names.

Line 154: EGO_COL_NAME_VALUE_PAIR_OBJ('10', 'EGO_PHYSICAL_ATTRS_PAGE_NAME'), --Physical Attributes

150: -- incorrect internal name. New array for internal names.
151: -- sreharih. Wed Apr 13 13:54:12 PDT 2011
152: --
153: l_pages_int_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
154: EGO_COL_NAME_VALUE_PAIR_OBJ('10', 'EGO_PHYSICAL_ATTRS_PAGE_NAME'), --Physical Attributes
155: EGO_COL_NAME_VALUE_PAIR_OBJ('20', 'EGO_SALES_PAGE_NAME'),--Sales and Order Management
156: EGO_COL_NAME_VALUE_PAIR_OBJ('30', 'EGO_PLANNING_PAGE_NAME'),--Planning
157: EGO_COL_NAME_VALUE_PAIR_OBJ('40', 'EGO_PURCHASING_PAGE_NAME'),--Purchasing
158: EGO_COL_NAME_VALUE_PAIR_OBJ('50', 'EGO_INVENTORY_PAGE_NAME'),--Inventory/WMS

Line 155: EGO_COL_NAME_VALUE_PAIR_OBJ('20', 'EGO_SALES_PAGE_NAME'),--Sales and Order Management

151: -- sreharih. Wed Apr 13 13:54:12 PDT 2011
152: --
153: l_pages_int_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
154: EGO_COL_NAME_VALUE_PAIR_OBJ('10', 'EGO_PHYSICAL_ATTRS_PAGE_NAME'), --Physical Attributes
155: EGO_COL_NAME_VALUE_PAIR_OBJ('20', 'EGO_SALES_PAGE_NAME'),--Sales and Order Management
156: EGO_COL_NAME_VALUE_PAIR_OBJ('30', 'EGO_PLANNING_PAGE_NAME'),--Planning
157: EGO_COL_NAME_VALUE_PAIR_OBJ('40', 'EGO_PURCHASING_PAGE_NAME'),--Purchasing
158: EGO_COL_NAME_VALUE_PAIR_OBJ('50', 'EGO_INVENTORY_PAGE_NAME'),--Inventory/WMS
159: EGO_COL_NAME_VALUE_PAIR_OBJ('60', 'EGO_MANUFACTURING_PAGE_NAME')--Manufacturing

Line 156: EGO_COL_NAME_VALUE_PAIR_OBJ('30', 'EGO_PLANNING_PAGE_NAME'),--Planning

152: --
153: l_pages_int_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
154: EGO_COL_NAME_VALUE_PAIR_OBJ('10', 'EGO_PHYSICAL_ATTRS_PAGE_NAME'), --Physical Attributes
155: EGO_COL_NAME_VALUE_PAIR_OBJ('20', 'EGO_SALES_PAGE_NAME'),--Sales and Order Management
156: EGO_COL_NAME_VALUE_PAIR_OBJ('30', 'EGO_PLANNING_PAGE_NAME'),--Planning
157: EGO_COL_NAME_VALUE_PAIR_OBJ('40', 'EGO_PURCHASING_PAGE_NAME'),--Purchasing
158: EGO_COL_NAME_VALUE_PAIR_OBJ('50', 'EGO_INVENTORY_PAGE_NAME'),--Inventory/WMS
159: EGO_COL_NAME_VALUE_PAIR_OBJ('60', 'EGO_MANUFACTURING_PAGE_NAME')--Manufacturing
160: );

Line 157: EGO_COL_NAME_VALUE_PAIR_OBJ('40', 'EGO_PURCHASING_PAGE_NAME'),--Purchasing

153: l_pages_int_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
154: EGO_COL_NAME_VALUE_PAIR_OBJ('10', 'EGO_PHYSICAL_ATTRS_PAGE_NAME'), --Physical Attributes
155: EGO_COL_NAME_VALUE_PAIR_OBJ('20', 'EGO_SALES_PAGE_NAME'),--Sales and Order Management
156: EGO_COL_NAME_VALUE_PAIR_OBJ('30', 'EGO_PLANNING_PAGE_NAME'),--Planning
157: EGO_COL_NAME_VALUE_PAIR_OBJ('40', 'EGO_PURCHASING_PAGE_NAME'),--Purchasing
158: EGO_COL_NAME_VALUE_PAIR_OBJ('50', 'EGO_INVENTORY_PAGE_NAME'),--Inventory/WMS
159: EGO_COL_NAME_VALUE_PAIR_OBJ('60', 'EGO_MANUFACTURING_PAGE_NAME')--Manufacturing
160: );
161:

Line 158: EGO_COL_NAME_VALUE_PAIR_OBJ('50', 'EGO_INVENTORY_PAGE_NAME'),--Inventory/WMS

154: EGO_COL_NAME_VALUE_PAIR_OBJ('10', 'EGO_PHYSICAL_ATTRS_PAGE_NAME'), --Physical Attributes
155: EGO_COL_NAME_VALUE_PAIR_OBJ('20', 'EGO_SALES_PAGE_NAME'),--Sales and Order Management
156: EGO_COL_NAME_VALUE_PAIR_OBJ('30', 'EGO_PLANNING_PAGE_NAME'),--Planning
157: EGO_COL_NAME_VALUE_PAIR_OBJ('40', 'EGO_PURCHASING_PAGE_NAME'),--Purchasing
158: EGO_COL_NAME_VALUE_PAIR_OBJ('50', 'EGO_INVENTORY_PAGE_NAME'),--Inventory/WMS
159: EGO_COL_NAME_VALUE_PAIR_OBJ('60', 'EGO_MANUFACTURING_PAGE_NAME')--Manufacturing
160: );
161:
162: ELSE

Line 159: EGO_COL_NAME_VALUE_PAIR_OBJ('60', 'EGO_MANUFACTURING_PAGE_NAME')--Manufacturing

155: EGO_COL_NAME_VALUE_PAIR_OBJ('20', 'EGO_SALES_PAGE_NAME'),--Sales and Order Management
156: EGO_COL_NAME_VALUE_PAIR_OBJ('30', 'EGO_PLANNING_PAGE_NAME'),--Planning
157: EGO_COL_NAME_VALUE_PAIR_OBJ('40', 'EGO_PURCHASING_PAGE_NAME'),--Purchasing
158: EGO_COL_NAME_VALUE_PAIR_OBJ('50', 'EGO_INVENTORY_PAGE_NAME'),--Inventory/WMS
159: EGO_COL_NAME_VALUE_PAIR_OBJ('60', 'EGO_MANUFACTURING_PAGE_NAME')--Manufacturing
160: );
161:
162: ELSE
163: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 164: EGO_COL_NAME_VALUE_PAIR_OBJ('70','Service')

160: );
161:
162: ELSE
163: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
164: EGO_COL_NAME_VALUE_PAIR_OBJ('70','Service')
165: );
166: l_pages_int_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
167: EGO_COL_NAME_VALUE_PAIR_OBJ('70','EGO_SERVICE_PAGE_NAME')--Service
168: );

Line 167: EGO_COL_NAME_VALUE_PAIR_OBJ('70','EGO_SERVICE_PAGE_NAME')--Service

163: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
164: EGO_COL_NAME_VALUE_PAIR_OBJ('70','Service')
165: );
166: l_pages_int_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
167: EGO_COL_NAME_VALUE_PAIR_OBJ('70','EGO_SERVICE_PAGE_NAME')--Service
168: );
169: END IF;
170: FOR i IN l_pages_array.FIRST .. l_pages_array.LAST LOOP
171:

Line 196: EGO_COL_NAME_VALUE_PAIR_OBJ('10','PhysicalAttributes')

192: ,x_msg_data => l_msg_data
193: );
194: IF l_pages_array(i).name = 10 THEN
195: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
196: EGO_COL_NAME_VALUE_PAIR_OBJ('10','PhysicalAttributes')
197: );
198: ELSIF l_pages_array(i).name = 20 THEN
199: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
200: EGO_COL_NAME_VALUE_PAIR_OBJ('10','OrderManagement'),

Line 200: EGO_COL_NAME_VALUE_PAIR_OBJ('10','OrderManagement'),

196: EGO_COL_NAME_VALUE_PAIR_OBJ('10','PhysicalAttributes')
197: );
198: ELSIF l_pages_array(i).name = 20 THEN
199: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
200: EGO_COL_NAME_VALUE_PAIR_OBJ('10','OrderManagement'),
201: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Invoicing'),
202: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WebOption')
203: );
204: ELSIF l_pages_array(i).name = 30 THEN

Line 201: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Invoicing'),

197: );
198: ELSIF l_pages_array(i).name = 20 THEN
199: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
200: EGO_COL_NAME_VALUE_PAIR_OBJ('10','OrderManagement'),
201: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Invoicing'),
202: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WebOption')
203: );
204: ELSIF l_pages_array(i).name = 30 THEN
205: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 202: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WebOption')

198: ELSIF l_pages_array(i).name = 20 THEN
199: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
200: EGO_COL_NAME_VALUE_PAIR_OBJ('10','OrderManagement'),
201: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Invoicing'),
202: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WebOption')
203: );
204: ELSIF l_pages_array(i).name = 30 THEN
205: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
206: EGO_COL_NAME_VALUE_PAIR_OBJ('10','GeneralPlanning'),

Line 206: EGO_COL_NAME_VALUE_PAIR_OBJ('10','GeneralPlanning'),

202: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WebOption')
203: );
204: ELSIF l_pages_array(i).name = 30 THEN
205: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
206: EGO_COL_NAME_VALUE_PAIR_OBJ('10','GeneralPlanning'),
207: EGO_COL_NAME_VALUE_PAIR_OBJ('20','MPSMRPPlanning'),
208: EGO_COL_NAME_VALUE_PAIR_OBJ('30','LeadTimes')
209: );
210: ELSIF l_pages_array(i).name = 40 THEN

Line 207: EGO_COL_NAME_VALUE_PAIR_OBJ('20','MPSMRPPlanning'),

203: );
204: ELSIF l_pages_array(i).name = 30 THEN
205: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
206: EGO_COL_NAME_VALUE_PAIR_OBJ('10','GeneralPlanning'),
207: EGO_COL_NAME_VALUE_PAIR_OBJ('20','MPSMRPPlanning'),
208: EGO_COL_NAME_VALUE_PAIR_OBJ('30','LeadTimes')
209: );
210: ELSIF l_pages_array(i).name = 40 THEN
211: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 208: EGO_COL_NAME_VALUE_PAIR_OBJ('30','LeadTimes')

204: ELSIF l_pages_array(i).name = 30 THEN
205: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
206: EGO_COL_NAME_VALUE_PAIR_OBJ('10','GeneralPlanning'),
207: EGO_COL_NAME_VALUE_PAIR_OBJ('20','MPSMRPPlanning'),
208: EGO_COL_NAME_VALUE_PAIR_OBJ('30','LeadTimes')
209: );
210: ELSIF l_pages_array(i).name = 40 THEN
211: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
212: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Purchasing'),

Line 212: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Purchasing'),

208: EGO_COL_NAME_VALUE_PAIR_OBJ('30','LeadTimes')
209: );
210: ELSIF l_pages_array(i).name = 40 THEN
211: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
212: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Purchasing'),
213: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Receiving')
214: );
215: ELSIF l_pages_array(i).name = 50 THEN
216: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 213: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Receiving')

209: );
210: ELSIF l_pages_array(i).name = 40 THEN
211: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
212: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Purchasing'),
213: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Receiving')
214: );
215: ELSIF l_pages_array(i).name = 50 THEN
216: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
217: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Inventory')

Line 217: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Inventory')

213: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Receiving')
214: );
215: ELSIF l_pages_array(i).name = 50 THEN
216: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
217: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Inventory')
218: );
219: ELSIF l_pages_array(i).name = 60 THEN
220: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
221: EGO_COL_NAME_VALUE_PAIR_OBJ('10','BillofMaterials'),

Line 221: EGO_COL_NAME_VALUE_PAIR_OBJ('10','BillofMaterials'),

217: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Inventory')
218: );
219: ELSIF l_pages_array(i).name = 60 THEN
220: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
221: EGO_COL_NAME_VALUE_PAIR_OBJ('10','BillofMaterials'),
222: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Costing'),
223: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WorkInProgress'),
224: EGO_COL_NAME_VALUE_PAIR_OBJ('40','ProcessManufacturing')
225: );

Line 222: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Costing'),

218: );
219: ELSIF l_pages_array(i).name = 60 THEN
220: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
221: EGO_COL_NAME_VALUE_PAIR_OBJ('10','BillofMaterials'),
222: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Costing'),
223: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WorkInProgress'),
224: EGO_COL_NAME_VALUE_PAIR_OBJ('40','ProcessManufacturing')
225: );
226: ELSIF l_pages_array(i).name = 70 THEN

Line 223: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WorkInProgress'),

219: ELSIF l_pages_array(i).name = 60 THEN
220: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
221: EGO_COL_NAME_VALUE_PAIR_OBJ('10','BillofMaterials'),
222: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Costing'),
223: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WorkInProgress'),
224: EGO_COL_NAME_VALUE_PAIR_OBJ('40','ProcessManufacturing')
225: );
226: ELSIF l_pages_array(i).name = 70 THEN
227: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 224: EGO_COL_NAME_VALUE_PAIR_OBJ('40','ProcessManufacturing')

220: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
221: EGO_COL_NAME_VALUE_PAIR_OBJ('10','BillofMaterials'),
222: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Costing'),
223: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WorkInProgress'),
224: EGO_COL_NAME_VALUE_PAIR_OBJ('40','ProcessManufacturing')
225: );
226: ELSIF l_pages_array(i).name = 70 THEN
227: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
228: EGO_COL_NAME_VALUE_PAIR_OBJ('10','AssetManagement'),

Line 228: EGO_COL_NAME_VALUE_PAIR_OBJ('10','AssetManagement'),

224: EGO_COL_NAME_VALUE_PAIR_OBJ('40','ProcessManufacturing')
225: );
226: ELSIF l_pages_array(i).name = 70 THEN
227: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
228: EGO_COL_NAME_VALUE_PAIR_OBJ('10','AssetManagement'),
229: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Service')
230: );
231: END IF;
232: FOR j in l_page_entry_array.FIRST .. l_page_entry_array.LAST LOOP

Line 229: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Service')

225: );
226: ELSIF l_pages_array(i).name = 70 THEN
227: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
228: EGO_COL_NAME_VALUE_PAIR_OBJ('10','AssetManagement'),
229: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Service')
230: );
231: END IF;
232: FOR j in l_page_entry_array.FIRST .. l_page_entry_array.LAST LOOP
233: sync_cat_attr_grp_assoc (

Line 311: EGO_COL_NAME_VALUE_PAIR_OBJ('1','PhysicalAttributes'),

307:
308: FOR i IN 1..3 LOOP
309: IF i = 1 THEN
310: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
311: EGO_COL_NAME_VALUE_PAIR_OBJ('1','PhysicalAttributes'),
312: EGO_COL_NAME_VALUE_PAIR_OBJ('2','OrderManagement'),
313: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Invoicing'),
314: EGO_COL_NAME_VALUE_PAIR_OBJ('4','WebOption'),
315: EGO_COL_NAME_VALUE_PAIR_OBJ('5','GeneralPlanning'),

Line 312: EGO_COL_NAME_VALUE_PAIR_OBJ('2','OrderManagement'),

308: FOR i IN 1..3 LOOP
309: IF i = 1 THEN
310: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
311: EGO_COL_NAME_VALUE_PAIR_OBJ('1','PhysicalAttributes'),
312: EGO_COL_NAME_VALUE_PAIR_OBJ('2','OrderManagement'),
313: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Invoicing'),
314: EGO_COL_NAME_VALUE_PAIR_OBJ('4','WebOption'),
315: EGO_COL_NAME_VALUE_PAIR_OBJ('5','GeneralPlanning'),
316: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Manufacturing')

Line 313: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Invoicing'),

309: IF i = 1 THEN
310: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
311: EGO_COL_NAME_VALUE_PAIR_OBJ('1','PhysicalAttributes'),
312: EGO_COL_NAME_VALUE_PAIR_OBJ('2','OrderManagement'),
313: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Invoicing'),
314: EGO_COL_NAME_VALUE_PAIR_OBJ('4','WebOption'),
315: EGO_COL_NAME_VALUE_PAIR_OBJ('5','GeneralPlanning'),
316: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Manufacturing')
317: );

Line 314: EGO_COL_NAME_VALUE_PAIR_OBJ('4','WebOption'),

310: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
311: EGO_COL_NAME_VALUE_PAIR_OBJ('1','PhysicalAttributes'),
312: EGO_COL_NAME_VALUE_PAIR_OBJ('2','OrderManagement'),
313: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Invoicing'),
314: EGO_COL_NAME_VALUE_PAIR_OBJ('4','WebOption'),
315: EGO_COL_NAME_VALUE_PAIR_OBJ('5','GeneralPlanning'),
316: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Manufacturing')
317: );
318: ELSIF i = 2 THEN

Line 315: EGO_COL_NAME_VALUE_PAIR_OBJ('5','GeneralPlanning'),

311: EGO_COL_NAME_VALUE_PAIR_OBJ('1','PhysicalAttributes'),
312: EGO_COL_NAME_VALUE_PAIR_OBJ('2','OrderManagement'),
313: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Invoicing'),
314: EGO_COL_NAME_VALUE_PAIR_OBJ('4','WebOption'),
315: EGO_COL_NAME_VALUE_PAIR_OBJ('5','GeneralPlanning'),
316: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Manufacturing')
317: );
318: ELSIF i = 2 THEN
319: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 316: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Manufacturing')

312: EGO_COL_NAME_VALUE_PAIR_OBJ('2','OrderManagement'),
313: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Invoicing'),
314: EGO_COL_NAME_VALUE_PAIR_OBJ('4','WebOption'),
315: EGO_COL_NAME_VALUE_PAIR_OBJ('5','GeneralPlanning'),
316: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Manufacturing')
317: );
318: ELSIF i = 2 THEN
319: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
320: EGO_COL_NAME_VALUE_PAIR_OBJ('1','LeadTimes'),

Line 320: EGO_COL_NAME_VALUE_PAIR_OBJ('1','LeadTimes'),

316: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Manufacturing')
317: );
318: ELSIF i = 2 THEN
319: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
320: EGO_COL_NAME_VALUE_PAIR_OBJ('1','LeadTimes'),
321: EGO_COL_NAME_VALUE_PAIR_OBJ('2','Purchasing'),
322: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Receiving'),
323: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Inventory'),
324: EGO_COL_NAME_VALUE_PAIR_OBJ('5','BillofMaterials'),

Line 321: EGO_COL_NAME_VALUE_PAIR_OBJ('2','Purchasing'),

317: );
318: ELSIF i = 2 THEN
319: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
320: EGO_COL_NAME_VALUE_PAIR_OBJ('1','LeadTimes'),
321: EGO_COL_NAME_VALUE_PAIR_OBJ('2','Purchasing'),
322: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Receiving'),
323: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Inventory'),
324: EGO_COL_NAME_VALUE_PAIR_OBJ('5','BillofMaterials'),
325: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Costing')

Line 322: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Receiving'),

318: ELSIF i = 2 THEN
319: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
320: EGO_COL_NAME_VALUE_PAIR_OBJ('1','LeadTimes'),
321: EGO_COL_NAME_VALUE_PAIR_OBJ('2','Purchasing'),
322: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Receiving'),
323: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Inventory'),
324: EGO_COL_NAME_VALUE_PAIR_OBJ('5','BillofMaterials'),
325: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Costing')
326: );

Line 323: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Inventory'),

319: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
320: EGO_COL_NAME_VALUE_PAIR_OBJ('1','LeadTimes'),
321: EGO_COL_NAME_VALUE_PAIR_OBJ('2','Purchasing'),
322: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Receiving'),
323: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Inventory'),
324: EGO_COL_NAME_VALUE_PAIR_OBJ('5','BillofMaterials'),
325: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Costing')
326: );
327: ELSE

Line 324: EGO_COL_NAME_VALUE_PAIR_OBJ('5','BillofMaterials'),

320: EGO_COL_NAME_VALUE_PAIR_OBJ('1','LeadTimes'),
321: EGO_COL_NAME_VALUE_PAIR_OBJ('2','Purchasing'),
322: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Receiving'),
323: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Inventory'),
324: EGO_COL_NAME_VALUE_PAIR_OBJ('5','BillofMaterials'),
325: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Costing')
326: );
327: ELSE
328: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 325: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Costing')

321: EGO_COL_NAME_VALUE_PAIR_OBJ('2','Purchasing'),
322: EGO_COL_NAME_VALUE_PAIR_OBJ('3','Receiving'),
323: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Inventory'),
324: EGO_COL_NAME_VALUE_PAIR_OBJ('5','BillofMaterials'),
325: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Costing')
326: );
327: ELSE
328: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
329: EGO_COL_NAME_VALUE_PAIR_OBJ('1','WorkInProgress'),

Line 329: EGO_COL_NAME_VALUE_PAIR_OBJ('1','WorkInProgress'),

325: EGO_COL_NAME_VALUE_PAIR_OBJ('6','Costing')
326: );
327: ELSE
328: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
329: EGO_COL_NAME_VALUE_PAIR_OBJ('1','WorkInProgress'),
330: EGO_COL_NAME_VALUE_PAIR_OBJ('2','ProcessManufacturing'),
331: EGO_COL_NAME_VALUE_PAIR_OBJ('3','AssetManagement'),
332: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Service')
333: );

Line 330: EGO_COL_NAME_VALUE_PAIR_OBJ('2','ProcessManufacturing'),

326: );
327: ELSE
328: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
329: EGO_COL_NAME_VALUE_PAIR_OBJ('1','WorkInProgress'),
330: EGO_COL_NAME_VALUE_PAIR_OBJ('2','ProcessManufacturing'),
331: EGO_COL_NAME_VALUE_PAIR_OBJ('3','AssetManagement'),
332: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Service')
333: );
334: END IF;

Line 331: EGO_COL_NAME_VALUE_PAIR_OBJ('3','AssetManagement'),

327: ELSE
328: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
329: EGO_COL_NAME_VALUE_PAIR_OBJ('1','WorkInProgress'),
330: EGO_COL_NAME_VALUE_PAIR_OBJ('2','ProcessManufacturing'),
331: EGO_COL_NAME_VALUE_PAIR_OBJ('3','AssetManagement'),
332: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Service')
333: );
334: END IF;
335:

Line 332: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Service')

328: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
329: EGO_COL_NAME_VALUE_PAIR_OBJ('1','WorkInProgress'),
330: EGO_COL_NAME_VALUE_PAIR_OBJ('2','ProcessManufacturing'),
331: EGO_COL_NAME_VALUE_PAIR_OBJ('3','AssetManagement'),
332: EGO_COL_NAME_VALUE_PAIR_OBJ('4','Service')
333: );
334: END IF;
335:
336: FOR j in l_ag_assocs_array.FIRST .. l_ag_assocs_array.LAST LOOP