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 123: l_pages_array EGO_COL_NAME_VALUE_PAIR_ARRAY;

119: l_attr_group_type VARCHAR2(40) := 'EGO_MASTER_ITEMS';
120: l_page_desc VARCHAR2(80) := 'Auto-generated operational attribute page';
121: l_page_id NUMBER;
122: l_association_id NUMBER;
123: l_pages_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
124: l_page_entry_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
125: -- l_name_value_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
126: l_return_status VARCHAR2(1);
127: l_msg_count NUMBER;

Line 124: l_page_entry_array EGO_COL_NAME_VALUE_PAIR_ARRAY;

120: l_page_desc VARCHAR2(80) := 'Auto-generated operational attribute page';
121: l_page_id NUMBER;
122: l_association_id NUMBER;
123: l_pages_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
124: l_page_entry_array EGO_COL_NAME_VALUE_PAIR_ARRAY;
125: -- l_name_value_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
126: l_return_status VARCHAR2(1);
127: l_msg_count NUMBER;
128: l_msg_data VARCHAR2(4000);

Line 134: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

130: BEGIN
131: l_object_id := get_object_id();
132: for k in 1..2 LOOP
133: IF K = 1 THEN
134: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
135: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Physical Attributes'),
136: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Sales and Order Management'),
137: EGO_COL_NAME_VALUE_PAIR_OBJ('30','Planning'),
138: EGO_COL_NAME_VALUE_PAIR_OBJ('40','Purchasing'),

Line 143: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

139: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),
140: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')
141: );
142: ELSE
143: l_pages_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
144: EGO_COL_NAME_VALUE_PAIR_OBJ('70','Service')
145: );
146: END IF;
147: FOR i IN l_pages_array.FIRST .. l_pages_array.LAST LOOP

Line 164: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

160: ,x_msg_count => l_msg_count
161: ,x_msg_data => l_msg_data
162: );
163: IF l_pages_array(i).name = 10 THEN
164: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
165: EGO_COL_NAME_VALUE_PAIR_OBJ('10','PhysicalAttributes')
166: );
167: ELSIF l_pages_array(i).name = 20 THEN
168: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 168: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

164: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
165: EGO_COL_NAME_VALUE_PAIR_OBJ('10','PhysicalAttributes')
166: );
167: ELSIF l_pages_array(i).name = 20 THEN
168: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
169: EGO_COL_NAME_VALUE_PAIR_OBJ('10','OrderManagement'),
170: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Invoicing'),
171: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WebOption')
172: );

Line 174: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

170: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Invoicing'),
171: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WebOption')
172: );
173: ELSIF l_pages_array(i).name = 30 THEN
174: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
175: EGO_COL_NAME_VALUE_PAIR_OBJ('10','GeneralPlanning'),
176: EGO_COL_NAME_VALUE_PAIR_OBJ('20','MPSMRPPlanning'),
177: EGO_COL_NAME_VALUE_PAIR_OBJ('30','LeadTimes')
178: );

Line 180: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

176: EGO_COL_NAME_VALUE_PAIR_OBJ('20','MPSMRPPlanning'),
177: EGO_COL_NAME_VALUE_PAIR_OBJ('30','LeadTimes')
178: );
179: ELSIF l_pages_array(i).name = 40 THEN
180: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
181: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Purchasing'),
182: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Receiving')
183: );
184: ELSIF l_pages_array(i).name = 50 THEN

Line 185: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

181: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Purchasing'),
182: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Receiving')
183: );
184: ELSIF l_pages_array(i).name = 50 THEN
185: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
186: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Inventory')
187: );
188: ELSIF l_pages_array(i).name = 60 THEN
189: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

Line 189: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

185: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
186: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Inventory')
187: );
188: ELSIF l_pages_array(i).name = 60 THEN
189: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
190: EGO_COL_NAME_VALUE_PAIR_OBJ('10','BillofMaterials'),
191: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Costing'),
192: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WorkInProgress'),
193: EGO_COL_NAME_VALUE_PAIR_OBJ('40','ProcessManufacturing')

Line 196: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

192: EGO_COL_NAME_VALUE_PAIR_OBJ('30','WorkInProgress'),
193: EGO_COL_NAME_VALUE_PAIR_OBJ('40','ProcessManufacturing')
194: );
195: ELSIF l_pages_array(i).name = 70 THEN
196: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
197: EGO_COL_NAME_VALUE_PAIR_OBJ('10','AssetManagement'),
198: EGO_COL_NAME_VALUE_PAIR_OBJ('20','Service')
199: );
200: END IF;

Line 253: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

249: ,p_template_name IN VARCHAR2
250: ,p_creation_allowed IN VARCHAR2
251: ,p_end_date IN DATE
252: ,p_owner IN VARCHAR2
253: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
254: ,x_catalog_group_id OUT NOCOPY NUMBER
255: ,x_return_status OUT NOCOPY VARCHAR2
256: ,x_msg_count OUT NOCOPY NUMBER
257: ,x_msg_data OUT NOCOPY VARCHAR2

Line 418: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

414: ,p_data_level IN VARCHAR2
415: ,p_attr_group_name IN VARCHAR2
416: ,p_attr_group_type IN VARCHAR2
417: ,p_enabled_flag IN VARCHAR2
418: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
419: ,x_association_id OUT NOCOPY NUMBER
420: ,x_return_status OUT NOCOPY VARCHAR2
421: ,x_msg_count OUT NOCOPY NUMBER
422: ,x_msg_data OUT NOCOPY VARCHAR2

Line 513: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

509: ,p_page_int_name IN VARCHAR2
510: ,p_name IN VARCHAR2
511: ,p_desc IN VARCHAR2
512: ,p_sequence IN NUMBER
513: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
514: ,x_page_id OUT NOCOPY NUMBER
515: ,x_return_status OUT NOCOPY VARCHAR2
516: ,x_msg_count OUT NOCOPY NUMBER
517: ,x_msg_data OUT NOCOPY VARCHAR2

Line 598: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

594: ,p_attr_group_name IN VARCHAR2
595: ,p_attr_group_type IN VARCHAR2
596: ,p_sequence IN NUMBER
597: ,p_association_id IN NUMBER
598: ,p_extra_params IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
599: ,x_return_status OUT NOCOPY VARCHAR2
600: ,x_msg_count OUT NOCOPY NUMBER
601: ,x_msg_data OUT NOCOPY VARCHAR2
602: ) IS