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.IGS_OR_GEN_012_PKG dependencies on IGS_OR_FUNC_FLTR

Line 264: FROM igs_or_func_fltr

260: || (reverse chronological order - newest change first)
261: */
262: CURSOR get_attr_type_cur IS
263: SELECT distinct attr_type
264: FROM igs_or_func_fltr
265: WHERE func_code = p_function_name;
266:
267: CURSOR get_attr_val_cur IS
268: SELECT attr_val

Line 269: FROM igs_or_func_fltr

265: WHERE func_code = p_function_name;
266:
267: CURSOR get_attr_val_cur IS
268: SELECT attr_val
269: FROM igs_or_func_fltr
270: WHERE func_code = p_function_name;
271:
272: l_where_clause VARCHAR2(450);
273: get_attr_type_rec get_attr_type_cur%ROWTYPE;

Line 291: l_where_clause := get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = '''|| p_function_name ||''')';

287: RETURN;
288: END IF;
289: CLOSE get_attr_type_cur;
290:
291: l_where_clause := get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = '''|| p_function_name ||''')';
292:
293: END IF;
294:
295: p_where_clause := l_where_clause;

Line 324: FROM igs_or_func_fltr

320: || (reverse chronological order - newest change first)
321: */
322: CURSOR get_attr_type_cur(cp_function_name VARCHAR2) IS
323: SELECT distinct attr_type
324: FROM igs_or_func_fltr
325: WHERE func_code = p_function_name;
326:
327: l_where_clause VARCHAR2(450);
328: get_attr_type_rec get_attr_type_cur%ROWTYPE;

Line 346: l_where_clause := get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = :PARAMETER.P_FORM_NAME)';

342: RETURN;
343: END IF;
344: CLOSE get_attr_type_cur;
345:
346: l_where_clause := get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = :PARAMETER.P_FORM_NAME)';
347: END IF;
348:
349: p_where_clause := l_where_clause;
350:

Line 378: FROM igs_or_func_fltr

374: || (reverse chronological order - newest change first)
375: */
376: CURSOR get_attr_type_cur(cp_function_name VARCHAR2) IS
377: SELECT distinct attr_type
378: FROM igs_or_func_fltr
379: WHERE func_code = cp_function_name;
380:
381: l_where_clause VARCHAR2(450);
382: get_attr_type_rec get_attr_type_cur%ROWTYPE;

Line 399: l_where_clause := get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = :p_function_name )';

395: RETURN;
396: END IF;
397: CLOSE get_attr_type_cur;
398:
399: l_where_clause := get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = :p_function_name )';
400:
401: END IF;
402:
403: p_where_clause := l_where_clause;

Line 428: FROM igs_or_func_fltr

424: || (reverse chronological order - newest change first)
425: */
426: CURSOR get_attr_type_cur(cp_function_name VARCHAR2) IS
427: SELECT distinct attr_type, inst_org_val
428: FROM igs_or_func_fltr
429: WHERE func_code = cp_function_name;
430:
431: l_where_clause VARCHAR2(450);
432: get_attr_type_rec get_attr_type_cur%ROWTYPE;

Line 457: l_where_clause := l_inst_org_prefix||get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = :PARAMETER.P_FORM_NAME)';

453: ELSIF get_attr_type_rec.inst_org_val = 'I' THEN
454: l_inst_org_prefix := 'OI_';
455: END IF;
456:
457: l_where_clause := l_inst_org_prefix||get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = :PARAMETER.P_FORM_NAME)';
458: END IF;
459:
460: p_where_clause := l_where_clause;
461:

Line 487: FROM igs_or_func_fltr

483: || (reverse chronological order - newest change first)
484: */
485: CURSOR get_attr_type_cur(cp_function_name VARCHAR2) IS
486: SELECT distinct attr_type, inst_org_val
487: FROM igs_or_func_fltr
488: WHERE func_code = cp_function_name;
489:
490: l_where_clause VARCHAR2(450);
491: get_attr_type_rec get_attr_type_cur%ROWTYPE;

Line 514: l_where_clause := l_inst_org_prefix||get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = :p_function_name )';

510: ELSIF get_attr_type_rec.inst_org_val = 'I' THEN
511: l_inst_org_prefix := 'OI_';
512: END IF;
513:
514: l_where_clause := l_inst_org_prefix||get_attr_type_rec.attr_type ||' IN (SELECT attr_val FROM igs_or_func_fltr WHERE func_code = :p_function_name )';
515:
516: END IF;
517:
518: p_where_clause := l_where_clause;