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.PA_PROJECT_STRUCTURE_UTILS dependencies on PJI_PA_PROJ_EVENTS_LOG

Line 3328: FROM pji_pa_proj_events_log LOG,

3324: IS
3325: SELECT 1
3326: FROM dual
3327: WHERE EXISTS (SELECT LOG.event_id
3328: FROM pji_pa_proj_events_log LOG,
3329: pa_proj_element_versions ver
3330: WHERE LOG.event_type='PRG_CHANGE'
3331: AND LOG.event_object =TO_CHAR(ver.prg_group)
3332: AND ver.project_id=p_project_id

Line 5074: -- log type PRG_CHANGE in the pa_pji_proj_events_log, pji_pa_proj_events_log tables.

5070: -- API name : check_pending_link_changes
5071: -- Type : Utils API
5072: -- Pre-reqs : None
5073: -- Return Value : This API returns "Y" if pending link changes exist for a given project as per
5074: -- log type PRG_CHANGE in the pa_pji_proj_events_log, pji_pa_proj_events_log tables.
5075: -- It's created to use from Projects Self Services (sql from vijay r).
5076: --
5077: -- Parameters
5078: -- p_project_id IN NUMBER

Line 5091: from pji_pa_proj_events_log log,pa_proj_element_versions ver

5087: CURSOR c1 IS
5088: select 1
5089: from dual
5090: where exists (select log.event_id
5091: from pji_pa_proj_events_log log,pa_proj_element_versions ver
5092: where log.event_type='PRG_CHANGE'
5093: and log.event_object =to_char(ver.prg_group)
5094: and ver.project_id=p_project_id
5095: union all