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 125: -- l_name_value_obj EGO_COL_NAME_VALUE_PAIR_OBJ;

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);
129:

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

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'),
139: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),

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

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'),
139: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),
140: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')

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

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'),
139: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),
140: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')
141: );

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

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'),
139: EGO_COL_NAME_VALUE_PAIR_OBJ('50','Inventory/WMS'),
140: EGO_COL_NAME_VALUE_PAIR_OBJ('60','Manufacturing')
141: );
142: ELSE

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

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

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

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

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

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
148: sync_cat_item_pages (

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

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 (
169: EGO_COL_NAME_VALUE_PAIR_OBJ('10','OrderManagement'),

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

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: );
173: ELSIF l_pages_array(i).name = 30 THEN

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

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: );
173: ELSIF l_pages_array(i).name = 30 THEN
174: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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

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

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

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: );
179: ELSIF l_pages_array(i).name = 40 THEN

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

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: );
179: ELSIF l_pages_array(i).name = 40 THEN
180: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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

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

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

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
185: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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

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
185: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (
186: EGO_COL_NAME_VALUE_PAIR_OBJ('10','Inventory')

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

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 (
190: EGO_COL_NAME_VALUE_PAIR_OBJ('10','BillofMaterials'),

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

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')
194: );

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

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')
194: );
195: ELSIF l_pages_array(i).name = 70 THEN

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

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')
194: );
195: ELSIF l_pages_array(i).name = 70 THEN
196: l_page_entry_array := EGO_COL_NAME_VALUE_PAIR_ARRAY (

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

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

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

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;
201: FOR j in l_page_entry_array.FIRST .. l_page_entry_array.LAST LOOP

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

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;
201: FOR j in l_page_entry_array.FIRST .. l_page_entry_array.LAST LOOP
202: sync_cat_attr_grp_assoc (