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

Line 171: -- OE_PC_VALIDATION_PKGS and run this procedure. To selectively generate

167: -- SQL selects only the ones that needs to be generated (new) or regenerated.
168: -- based on timestamping of the corresponding records
169: -- Selective regeneration:
170: -- to regenrate all the the packages again, one could delete all the records in
171: -- OE_PC_VALIDATION_PKGS and run this procedure. To selectively generate
172: -- validation for a specific validation tmplt or a record set, one could touch
173: -- (update the last update date) of the corresponding records and run this
174: -- procedure.
175: CURSOR C_CR IS

Line 209: FROM OE_PC_VALIDATION_PKGS vp

205: vt.validation_tmplt_id, rs.record_set_id)
206: NOT IN
207: (SELECT vp.validating_entity_id, vp.validation_entity_id,
208: vp.validation_tmplt_id, vp.record_set_id
209: FROM OE_PC_VALIDATION_PKGS vp
210: WHERE vp.validating_entity_id = ve.entity_id
211: AND vp.validation_entity_id = ve.validation_entity_id
212: AND vp.validation_tmplt_id = vt.validation_tmplt_id
213: AND vp.record_set_id = rs.record_set_id