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_PVT dependencies on OE_PC_VALIDATION_PKGS

Line 1226: FROM OE_PC_VALIDATION_PKGS

1222: IS
1223:
1224: CURSOR C IS
1225: SELECT 'Y'
1226: FROM OE_PC_VALIDATION_PKGS
1227: WHERE validating_entity_id = p_entity_id
1228: AND validation_entity_id = p_validation_entity_id
1229: AND validation_tmplt_id = p_validation_tmplt_id
1230: AND record_set_id = p_record_set_id;

Line 1254: l_sql := 'UPDATE OE_PC_VALIDATION_PKGS SET last_update_date = sysdate ' || OE_PC_GLOBALS.NEWLINE;

1250: -- OEXPCRQB.pls which does not have visibility to p_proc_name value.
1251:
1252: if (l_update = 'Y') then
1253: -- make update statement
1254: l_sql := 'UPDATE OE_PC_VALIDATION_PKGS SET last_update_date = sysdate ' || OE_PC_GLOBALS.NEWLINE;
1255: l_sql := l_sql || ' WHERE validating_entity_id = :b1 '||OE_PC_GLOBALS.NEWLINE;
1256: l_sql := l_sql || ' AND validation_entity_id = :b2 '||OE_PC_GLOBALS.NEWLINE;
1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;
1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;

Line 1269: l_sql := l_sql || 'INSERT INTO OE_PC_VALIDATION_PKGS ';

1265:
1266:
1267: else
1268: -- make insert statement
1269: l_sql := l_sql || 'INSERT INTO OE_PC_VALIDATION_PKGS ';
1270: l_sql := l_sql || '( ' || OE_PC_GLOBALS.NEWLINE;
1271: l_sql := l_sql || ' validating_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1272: l_sql := l_sql || ' ,validation_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;

Line 1473: -- create the SQL to insert/update a record into OE_PC_VALIDATION_PKGS to timestamp the

1469:
1470: l_pkg_spec := l_pkg_spec || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;
1471: l_pkg_body := l_pkg_body || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;
1472:
1473: -- create the SQL to insert/update a record into OE_PC_VALIDATION_PKGS to timestamp the
1474: -- generated Package.
1475: --------------------------------------------------------------------------------------
1476: Make_Control_Tbl_Sql( p_entity_id => p_entity_id
1477: ,p_validation_entity_id => p_validation_entity_id