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_PROGRESS_REPORT_WORKFLOW dependencies on PA_PROGRESS_REPORT_VERS

Line 89: FROM pa_wf_processes, pa_progress_report_vers pprv

85:
86: CURSOR get_last_workflow_info
87: IS
88: SELECT MAX(item_key)
89: FROM pa_wf_processes, pa_progress_report_vers pprv
90: WHERE item_type = p_item_type
91: AND description = p_process_name
92: AND pprv.version_id = p_version_id
93: AND entity_key1 = pprv.object_id

Line 289: FROM pa_progress_report_vers

285: l_name fnd_user.user_name%type; -- Added for bug 5027098
286:
287: CURSOR get_progress_status IS
288: SELECT report_status_code
289: FROM pa_progress_report_vers
290: WHERE version_id = l_version_id;
291:
292:
293: BEGIN

Line 503: (SELECT * FROM pa_progress_report_vers pprv, pa_object_page_layouts popl

499: CURSOR is_auto_published IS
500: SELECT 'Y'
501: FROM dual
502: WHERE exists
503: (SELECT * FROM pa_progress_report_vers pprv, pa_object_page_layouts popl
504: WHERE pprv.version_id = l_version_id
505: AND pprv.object_id = popl.object_id
506: AND pprv.object_type = popl.object_type
507: AND popl.approval_required = 'A');

Line 2049: from pa_progress_report_vals prval, pa_progress_report_vers prver

2045: l_reported_by_id NUMBER;
2046:
2047: cursor pr_vals is
2048: select prval.version_id,prver.overview briefoverview, prval.attribute1 summary,prval.attribute2 issues,prval.attribute3 accomplishments,prval.attribute4 plans
2049: from pa_progress_report_vals prval, pa_progress_report_vers prver
2050: where prval.version_id = document_id
2051: and prver.version_id = document_id
2052: and region_code = 'PA_PROGRESS_GENERAL_TOP';
2053:

Line 2071: pa_progress_report_vers pprv,

2067: and ppp.object_type = pprv.object_type
2068: and trunc(sysdate) between papf.effective_START_DATE and nvl(papf.effective_END_DATE, sysdate+1);
2069: /*
2070: SELECT pprv.*, pl.meaning progress_status FROM
2071: pa_progress_report_vers pprv,
2072: pa_lookups pl
2073: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2074: AND pl.lookup_code = pprv.progress_status_code
2075: and pprv.version_id = document_id

Line 2187: from pa_progress_report_vals prval, pa_progress_report_vers prver

2183: l_reported_by_id NUMBER;
2184: l_comment VARCHAR2(240);
2185: cursor pr_vals is
2186: select prval.version_id,prver.overview briefoverview, prval.attribute1 summary,prval.attribute2 issues,prval.attribute3 accomplishments,prval.attribute4 plans
2187: from pa_progress_report_vals prval, pa_progress_report_vers prver
2188: where prval.version_id = document_id
2189: and prver.version_id = document_id
2190: and region_code = 'PA_PROGRESS_GENERAL_TOP';
2191:

Line 2209: pa_progress_report_vers pprv,

2205: and ppp.object_type = pprv.object_type
2206: and trunc(sysdate) between papf.effective_START_DATE and nvl(papf.effective_END_DATE, sysdate+1);
2207: /*
2208: SELECT pprv.*, pl.meaning progress_status FROM
2209: pa_progress_report_vers pprv,
2210: pa_lookups pl
2211: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2212: AND pl.lookup_code = pprv.progress_status_code
2213: and pprv.version_id = document_id

Line 2337: from pa_progress_report_vals prval, pa_progress_report_vers prver

2333: l_submitter_name VARCHAR2(200);
2334:
2335: cursor pr_vals is
2336: select prval.version_id,prver.overview briefoverview, prval.attribute1 summary,prval.attribute2 issues,prval.attribute3 accomplishments,prval.attribute4 plans
2337: from pa_progress_report_vals prval, pa_progress_report_vers prver
2338: where prval.version_id = document_id
2339: and prver.version_id = document_id
2340: and region_code = 'PA_PROGRESS_GENERAL_TOP';
2341:

Line 2344: pa_progress_report_vers pprv,

2340: and region_code = 'PA_PROGRESS_GENERAL_TOP';
2341:
2342: CURSOR get_report_info IS
2343: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2344: pa_progress_report_vers pprv,
2345: pa_lookups pl,
2346: pa_project_parties ppp,
2347: per_all_people_f papf
2348: where lookup_type like 'PROGRESS_SYSTEM_STATUS'

Line 2360: pa_progress_report_vers pprv

2356: and trunc(sysdate) between papf.effective_START_DATE and nvl(papf.effective_END_DATE, sysdate+1);
2357:
2358: CURSOR get_wf_info is
2359: select max(item_type), max(item_key) from pa_wf_processes,
2360: pa_progress_report_vers pprv
2361: where wf_type_code = 'Progress Report'
2362: and entity_key2= document_id
2363: AND entity_key1 = pprv.object_id
2364: AND pprv.object_type = 'PA_PROJECTS'

Line 2370: pa_progress_report_vers pprv,

2366:
2367:
2368: /*
2369: SELECT pprv.*, pl.meaning progress_status FROM
2370: pa_progress_report_vers pprv,
2371: pa_lookups pl
2372: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2373: AND pl.lookup_code = pprv.progress_status_code
2374: and pprv.version_id = document_id

Line 2619: pa_progress_report_vers pprv

2615:
2616:
2617: CURSOR get_report_info IS
2618: /* SELECT pprv.report_content FROM
2619: pa_progress_report_vers pprv
2620: where
2621: pprv.version_id = document_id
2622: AND pprv.object_type = 'PA_PROJECTS'*/
2623: select PAGE_CONTENT from PA_PAGE_CONTENTS