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_ARRAY

Line 128: l_pages_array EGO_COL_NAME_VALUE_PAIR_ARRAY;

124: l_attr_group_type VARCHAR2(40) := 'EGO_MASTER_ITEMS';
125: l_page_desc VARCHAR2(80) := 'Auto-generated operational attribute page';
126: l_page_id NUMBER;
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);

Line 129: l_pages_int_array EGO_COL_NAME_VALUE_PAIR_ARRAY; -- Bug 9949093.

125: l_page_desc VARCHAR2(80) := 'Auto-generated operational attribute page';
126: l_page_id NUMBER;
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;

Line 130: l_page_entry_array EGO_COL_NAME_VALUE_PAIR_ARRAY;

126: l_page_id NUMBER;
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);

Line 140: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

136: BEGIN
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'),

Line 153: l_pages_int_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

149: -- Bug 9949093. Meta data import creating default pages with
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

Line 163: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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 (
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

Line 166: l_pages_int_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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: );
169: END IF;
170: FOR i IN l_pages_array.FIRST .. l_pages_array.LAST LOOP

Line 195: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

191: ,x_msg_count => l_msg_count
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 (

Line 199: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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'),
201: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Invoicing'),
202: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WebOption')
203: );

Line 205: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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'),
207: EGO_COL_NAME_VALUE_PAIR_OBJ('20','MPSMRPPlanning'),
208: EGO_COL_NAME_VALUE_PAIR_OBJ('30','LeadTimes')
209: );

Line 211: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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'),
213: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Receiving')
214: );
215: ELSIF l_pages_array(i).name = 50 THEN

Line 216: 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')
218: );
219: ELSIF l_pages_array(i).name = 60 THEN
220: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 220: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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'),
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')

Line 227: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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'),
229: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Service')
230: );
231: END IF;

Line 300: l_ag_assocs_array EGO_COL_NAME_VALUE_PAIR_ARRAY;

296: l_data_level VARCHAR2(20) := 'ITEM_ORG';
297: l_application_id NUMBER := 431;
298: l_attr_group_type VARCHAR2(40) := 'EGO_MASTER_ITEMS';
299: l_association_id NUMBER;
300: l_ag_assocs_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
301: l_return_status VARCHAR2(1);
302: l_msg_count NUMBER;
303: l_msg_data VARCHAR2(4000);
304:

Line 310: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

306: l_object_id := get_object_id();
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'),

Line 319: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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'),
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'),

Line 328: l_ag_assocs_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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'),
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')

Line 376: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

372: ,p_template_name IN VARCHAR2
373: ,p_creation_allowed IN VARCHAR2
374: ,p_end_date IN DATE
375: ,p_owner IN VARCHAR2
376: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
377: ,x_catalog_group_id OUT NOCOPY NUMBER
378: ,x_return_status OUT NOCOPY VARCHAR2
379: ,x_msg_count OUT NOCOPY NUMBER
380: ,x_msg_data OUT NOCOPY VARCHAR2

Line 558: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

554: ,p_data_level IN VARCHAR2
555: ,p_attr_group_name IN VARCHAR2
556: ,p_attr_group_type IN VARCHAR2
557: ,p_enabled_flag IN VARCHAR2
558: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
559: ,x_association_id OUT NOCOPY NUMBER
560: ,x_return_status OUT NOCOPY VARCHAR2
561: ,x_msg_count OUT NOCOPY NUMBER
562: ,x_msg_data OUT NOCOPY VARCHAR2

Line 653: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

649: ,p_page_int_name IN VARCHAR2
650: ,p_name IN VARCHAR2
651: ,p_desc IN VARCHAR2
652: ,p_sequence IN NUMBER
653: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
654: ,x_page_id OUT NOCOPY NUMBER
655: ,x_return_status OUT NOCOPY VARCHAR2
656: ,x_msg_count OUT NOCOPY NUMBER
657: ,x_msg_data OUT NOCOPY VARCHAR2

Line 748: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

744: ,p_attr_group_name IN VARCHAR2
745: ,p_attr_group_type IN VARCHAR2
746: ,p_sequence IN NUMBER
747: ,p_association_id IN NUMBER
748: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
749: ,x_return_status OUT NOCOPY VARCHAR2
750: ,x_msg_count OUT NOCOPY NUMBER
751: ,x_msg_data OUT NOCOPY VARCHAR2
752: ) IS