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.OE_PC_CONSTRAINTS_ADMIN_PUB dependencies on OE_PC_EXCLUSIONS

Line 485: utl_file.put_line(l_bodyFileHandle , ' FROM OE_PC_EXCLUSIONS e');

481: utl_file.put_line(l_bodyFileHandle , ' AND decode(c.column_name, ' || l_NULL || ',decode(p_check_all_cols_constraint,''Y'',');
482: utl_file.put_line(l_bodyFileHandle, ' nvl(p_column_name,'||l_DUMMY_COL||'),'||l_DUMMY_COL||'),c.column_name) = nvl(p_column_name,'||l_DUMMY_COL||')');
483: utl_file.put_line(l_bodyFileHandle , ' AND NOT EXISTS (');
484: utl_file.put_line(l_bodyFileHandle , ' SELECT ' || l_Q || 'EXISTS' || l_Q);
485: utl_file.put_line(l_bodyFileHandle , ' FROM OE_PC_EXCLUSIONS e');
486: utl_file.put_line(l_bodyFileHandle , ' WHERE e.responsibility_id = p_responsibility_id');
487: utl_file.put_line(l_bodyFileHandle , ' AND e.assignment_id = a.assignment_id');
488: utl_file.put_line(l_bodyFileHandle , ' AND e.application_id = p_application_id OR e.application_id IS NULL'); --bug3631547
489: -- utl_file.put_line(l_bodyFileHandle , ' AND sysdate BETWEEN nvl(e.start_date_active, sysdate)');

Line 517: utl_file.put_line(l_bodyFileHandle , ' FROM OE_PC_EXCLUSIONS e');

513: utl_file.put_line(l_bodyFileHandle , ' AND decode(honored_by_def_flag,''N'',decode(p_is_caller_defaulting,''Y'',''N'',''Y''),');
514: utl_file.put_line(l_bodyFileHandle , ' nvl(honored_by_def_flag,''Y'')) = ''Y''');
515: utl_file.put_line(l_bodyFileHandle , ' AND NOT EXISTS (');
516: utl_file.put_line(l_bodyFileHandle , ' SELECT ' || l_Q || 'EXISTS' || l_Q);
517: utl_file.put_line(l_bodyFileHandle , ' FROM OE_PC_EXCLUSIONS e');
518: utl_file.put_line(l_bodyFileHandle , ' WHERE e.responsibility_id = p_responsibility_id');
519: utl_file.put_line(l_bodyFileHandle , ' AND e.assignment_id = a.assignment_id');
520: utl_file.put_line(l_bodyFileHandle , ' AND e.application_id = p_application_id OR e.application_id IS NULL'); --bug3631547
521: -- utl_file.put_line(l_bodyFileHandle , ' AND sysdate BETWEEN nvl(e.start_date_active, sysdate)');

Line 633: , OE_PC_EXCLUSIONS E

629: CURSOR C_EXCLUDED_RESP IS
630: SELECT 'FND_RESP'||R.application_id||':'||R.responsibility_id role_name
631: , R.responsibility_name role_display_name
632: FROM FND_RESPONSIBILITY_VL R
633: , OE_PC_EXCLUSIONS E
634: WHERE E.assignment_id = (SELECT assignment_id
635: FROM oe_pc_assignments
636: WHERE constraint_id = p_constraint_id
637: AND responsibility_id IS NULL)