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.AMW_VALID_INSTANCE_SET_GRANTS dependencies on DUAL

Line 95: query_to_exec := 'SELECT 1 from dual WHERE (' || p_obj_ids || ') IN (' || obj_std_pkq;

91: inst_set_preds_rec.parameter9,
92: inst_set_preds_rec.parameter10);
93:
94: IF p_obj_ids IS NOT NULL THEN
95: query_to_exec := 'SELECT 1 from dual WHERE (' || p_obj_ids || ') IN (' || obj_std_pkq;
96: query_to_exec := query_to_exec || ' WHERE ' || mod_pred || ' ))';
97: ELSIF p_parent_obj_sql IS NOT NULL THEN
98: query_to_exec := 'SELECT 1 from dual WHERE EXISTS( ' || obj_std_pkq || ' WHERE ';
99: query_to_exec := query_to_exec || inst_set_preds_rec.predicate || ' AND (';

Line 98: query_to_exec := 'SELECT 1 from dual WHERE EXISTS( ' || obj_std_pkq || ' WHERE ';

94: IF p_obj_ids IS NOT NULL THEN
95: query_to_exec := 'SELECT 1 from dual WHERE (' || p_obj_ids || ') IN (' || obj_std_pkq;
96: query_to_exec := query_to_exec || ' WHERE ' || mod_pred || ' ))';
97: ELSIF p_parent_obj_sql IS NOT NULL THEN
98: query_to_exec := 'SELECT 1 from dual WHERE EXISTS( ' || obj_std_pkq || ' WHERE ';
99: query_to_exec := query_to_exec || inst_set_preds_rec.predicate || ' AND (';
100: query_to_exec := query_to_exec || prim_key_str || ') IN (' || p_parent_obj_sql || '))';
101: END IF;
102:

Line 213: select replace (l_chg_pred, '&TABLE_ALIAS', l_datobj_name) into l_chg_pred from dual;

209:
210: l_chg_pred := l_pred;
211:
212: if INSTR(l_chg_pred, '&TABLE_ALIAS') <> 0 then
213: select replace (l_chg_pred, '&TABLE_ALIAS', l_datobj_name) into l_chg_pred from dual;
214: end if;
215: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER1') <> 0 then
216: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER1', l_param1) into l_chg_pred from dual;
217: end if;

Line 216: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER1', l_param1) into l_chg_pred from dual;

212: if INSTR(l_chg_pred, '&TABLE_ALIAS') <> 0 then
213: select replace (l_chg_pred, '&TABLE_ALIAS', l_datobj_name) into l_chg_pred from dual;
214: end if;
215: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER1') <> 0 then
216: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER1', l_param1) into l_chg_pred from dual;
217: end if;
218: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER2') <> 0 then
219: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER2', l_param2) into l_chg_pred from dual;
220: end if;

Line 219: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER2', l_param2) into l_chg_pred from dual;

215: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER1') <> 0 then
216: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER1', l_param1) into l_chg_pred from dual;
217: end if;
218: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER2') <> 0 then
219: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER2', l_param2) into l_chg_pred from dual;
220: end if;
221: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER3') <> 0 then
222: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER3', l_param3) into l_chg_pred from dual;
223: end if;

Line 222: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER3', l_param3) into l_chg_pred from dual;

218: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER2') <> 0 then
219: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER2', l_param2) into l_chg_pred from dual;
220: end if;
221: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER3') <> 0 then
222: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER3', l_param3) into l_chg_pred from dual;
223: end if;
224: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER4') <> 0 then
225: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER4', l_param4) into l_chg_pred from dual;
226: end if;

Line 225: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER4', l_param4) into l_chg_pred from dual;

221: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER3') <> 0 then
222: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER3', l_param3) into l_chg_pred from dual;
223: end if;
224: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER4') <> 0 then
225: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER4', l_param4) into l_chg_pred from dual;
226: end if;
227: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER5') <> 0 then
228: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER5', l_param5) into l_chg_pred from dual;
229: end if;

Line 228: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER5', l_param5) into l_chg_pred from dual;

224: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER4') <> 0 then
225: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER4', l_param4) into l_chg_pred from dual;
226: end if;
227: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER5') <> 0 then
228: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER5', l_param5) into l_chg_pred from dual;
229: end if;
230: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER6') <> 0 then
231: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER6', l_param6) into l_chg_pred from dual;
232: end if;

Line 231: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER6', l_param6) into l_chg_pred from dual;

227: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER5') <> 0 then
228: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER5', l_param5) into l_chg_pred from dual;
229: end if;
230: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER6') <> 0 then
231: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER6', l_param6) into l_chg_pred from dual;
232: end if;
233: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER7') <> 0 then
234: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER7', l_param7) into l_chg_pred from dual;
235: end if;

Line 234: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER7', l_param7) into l_chg_pred from dual;

230: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER6') <> 0 then
231: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER6', l_param6) into l_chg_pred from dual;
232: end if;
233: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER7') <> 0 then
234: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER7', l_param7) into l_chg_pred from dual;
235: end if;
236: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER8') <> 0 then
237: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER8', l_param8) into l_chg_pred from dual;
238: end if;

Line 237: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER8', l_param8) into l_chg_pred from dual;

233: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER7') <> 0 then
234: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER7', l_param7) into l_chg_pred from dual;
235: end if;
236: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER8') <> 0 then
237: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER8', l_param8) into l_chg_pred from dual;
238: end if;
239: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER9') <> 0 then
240: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER9', l_param9) into l_chg_pred from dual;
241: end if;

Line 240: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER9', l_param9) into l_chg_pred from dual;

236: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER8') <> 0 then
237: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER8', l_param8) into l_chg_pred from dual;
238: end if;
239: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER9') <> 0 then
240: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER9', l_param9) into l_chg_pred from dual;
241: end if;
242: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER10') <> 0 then
243: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER10', l_param10) into l_chg_pred from dual;
244: end if;

Line 243: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER10', l_param10) into l_chg_pred from dual;

239: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER9') <> 0 then
240: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER9', l_param9) into l_chg_pred from dual;
241: end if;
242: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER10') <> 0 then
243: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER10', l_param10) into l_chg_pred from dual;
244: end if;
245: return l_chg_pred;
246: end ;
247: */

Line 268: select replace (l_chg_pred, '&TABLE_ALIAS', l_datobj_name) into l_chg_pred from dual;

264:
265: l_chg_pred := upper(l_pred);
266:
267: if INSTR(l_chg_pred, '&TABLE_ALIAS') <> 0 then
268: select replace (l_chg_pred, '&TABLE_ALIAS', l_datobj_name) into l_chg_pred from dual;
269: end if;
270: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER1') <> 0 then
271: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER1', ':parameter1') into l_chg_pred from dual;
272: end if;

Line 271: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER1', ':parameter1') into l_chg_pred from dual;

267: if INSTR(l_chg_pred, '&TABLE_ALIAS') <> 0 then
268: select replace (l_chg_pred, '&TABLE_ALIAS', l_datobj_name) into l_chg_pred from dual;
269: end if;
270: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER1') <> 0 then
271: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER1', ':parameter1') into l_chg_pred from dual;
272: end if;
273: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER2') <> 0 then
274: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER2', ':parameter2') into l_chg_pred from dual;
275: end if;

Line 274: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER2', ':parameter2') into l_chg_pred from dual;

270: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER1') <> 0 then
271: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER1', ':parameter1') into l_chg_pred from dual;
272: end if;
273: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER2') <> 0 then
274: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER2', ':parameter2') into l_chg_pred from dual;
275: end if;
276: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER3') <> 0 then
277: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER3', ':parameter3') into l_chg_pred from dual;
278: end if;

Line 277: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER3', ':parameter3') into l_chg_pred from dual;

273: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER2') <> 0 then
274: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER2', ':parameter2') into l_chg_pred from dual;
275: end if;
276: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER3') <> 0 then
277: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER3', ':parameter3') into l_chg_pred from dual;
278: end if;
279: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER4') <> 0 then
280: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER4', ':parameter4') into l_chg_pred from dual;
281: end if;

Line 280: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER4', ':parameter4') into l_chg_pred from dual;

276: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER3') <> 0 then
277: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER3', ':parameter3') into l_chg_pred from dual;
278: end if;
279: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER4') <> 0 then
280: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER4', ':parameter4') into l_chg_pred from dual;
281: end if;
282: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER5') <> 0 then
283: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER5', ':parameter5') into l_chg_pred from dual;
284: end if;

Line 283: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER5', ':parameter5') into l_chg_pred from dual;

279: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER4') <> 0 then
280: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER4', ':parameter4') into l_chg_pred from dual;
281: end if;
282: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER5') <> 0 then
283: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER5', ':parameter5') into l_chg_pred from dual;
284: end if;
285: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER6') <> 0 then
286: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER6', ':parameter6') into l_chg_pred from dual;
287: end if;

Line 286: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER6', ':parameter6') into l_chg_pred from dual;

282: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER5') <> 0 then
283: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER5', ':parameter5') into l_chg_pred from dual;
284: end if;
285: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER6') <> 0 then
286: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER6', ':parameter6') into l_chg_pred from dual;
287: end if;
288: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER7') <> 0 then
289: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER7', ':parameter7') into l_chg_pred from dual;
290: end if;

Line 289: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER7', ':parameter7') into l_chg_pred from dual;

285: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER6') <> 0 then
286: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER6', ':parameter6') into l_chg_pred from dual;
287: end if;
288: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER7') <> 0 then
289: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER7', ':parameter7') into l_chg_pred from dual;
290: end if;
291: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER8') <> 0 then
292: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER8', ':parameter8') into l_chg_pred from dual;
293: end if;

Line 292: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER8', ':parameter8') into l_chg_pred from dual;

288: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER7') <> 0 then
289: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER7', ':parameter7') into l_chg_pred from dual;
290: end if;
291: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER8') <> 0 then
292: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER8', ':parameter8') into l_chg_pred from dual;
293: end if;
294: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER9') <> 0 then
295: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER9', ':parameter9') into l_chg_pred from dual;
296: end if;

Line 295: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER9', ':parameter9') into l_chg_pred from dual;

291: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER8') <> 0 then
292: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER8', ':parameter8') into l_chg_pred from dual;
293: end if;
294: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER9') <> 0 then
295: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER9', ':parameter9') into l_chg_pred from dual;
296: end if;
297: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER10') <> 0 then
298: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER10', ':parameterX') into l_chg_pred from dual;
299: end if;

Line 298: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER10', ':parameterX') into l_chg_pred from dual;

294: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER9') <> 0 then
295: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER9', ':parameter9') into l_chg_pred from dual;
296: end if;
297: if INSTR(l_chg_pred, '&GRANT_ALIAS.PARAMETER10') <> 0 then
298: select replace (l_chg_pred, '&GRANT_ALIAS.PARAMETER10', ':parameterX') into l_chg_pred from dual;
299: end if;
300:
301: return l_chg_pred;
302:

Line 437: query_to_exec := 'SELECT 1 from dual WHERE (' || p_obj_ids || ') IN (' || obj_std_pkq;

433: param9,
434: param10);
435:
436: IF p_obj_ids IS NOT NULL THEN
437: query_to_exec := 'SELECT 1 from dual WHERE (' || p_obj_ids || ') IN (' || obj_std_pkq;
438: query_to_exec := query_to_exec || ' WHERE ' || mod_pred || ' ))';
439: END IF;
440: cursor_select := DBMS_SQL.OPEN_CURSOR;
441: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);