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

Line 69: FROM pa_progress_report_vers

65: l_status VARCHAR2 (30);
66:
67: CURSOR get_report_status IS
68: SELECT report_status_code
69: FROM pa_progress_report_vers
70: WHERE version_id = p_version_id;
71:
72: CURSOR get_template_type
73: is

Line 320: FROM pa_progress_report_vers

316: l_status VARCHAR2 (30);
317:
318: CURSOR get_report_status IS
319: SELECT report_status_code
320: FROM pa_progress_report_vers
321: WHERE version_id = p_version_id;
322:
323: CURSOR get_template_type
324: is

Line 515: UPDATE pa_progress_report_vers

511: END IF;
512: END IF;
513:
514: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) THEN
515: UPDATE pa_progress_report_vers
516: SET summary_version_number = summary_version_number +1
517: WHERE version_id = p_version_id;
518:
519: END IF;

Line 586: FROM pa_progress_report_vers

582: l_status VARCHAR2 (30);
583:
584: CURSOR get_report_status IS
585: SELECT report_status_code
586: FROM pa_progress_report_vers
587: WHERE version_id = p_version_id;
588:
589: CURSOR get_template_type
590: is

Line 741: FROM pa_progress_report_vers

737: l_rowid ROWID;
738:
739: CURSOR check_status_published IS
740: SELECT ROWID
741: FROM pa_progress_report_vers
742: WHERE version_id = p_version_id
743: AND report_status_code = 'PROGRESS_REPORT_PUBLISHED';
744:
745: CURSOR get_template_type

Line 763: FROM pa_progress_report_vers p1

759: l_report_Type_id number;
760:
761: CURSOR update_last_published_rep is
762: SELECT version_id,record_version_number,summary_version_number
763: FROM pa_progress_report_vers p1
764: WHERE
765: p1.object_id = l_object_id
766: AND p1.object_type = l_object_type
767: and p1.report_type_id = l_report_type_id

Line 772: FROM pa_progress_report_vers

768: AND p1.report_status_code = 'PROGRESS_REPORT_PUBLISHED'
769: AND p1.version_id =
770: (
771: SELECT MAX(version_id)
772: FROM pa_progress_report_vers
773: WHERE
774: object_id = l_object_id
775: AND object_type = l_object_type
776: and report_type_id = l_report_type_id

Line 781: FROM pa_progress_report_vers

777: AND report_status_code = 'PROGRESS_REPORT_PUBLISHED'
778: and current_flag <> 'Y'
779: AND report_end_Date =
780: (SELECT max(report_end_date)
781: FROM pa_progress_report_vers
782: WHERE
783: object_id = l_object_id
784: AND object_type = l_object_type
785: and report_Type_id = l_report_type_id

Line 791: from pa_progress_report_vers

787: and current_flag <> 'Y'));
788:
789: cursor get_current_report_details is
790: select object_id, object_Type, current_flag, report_Type_id
791: from pa_progress_report_vers
792: where version_id = p_version_id;
793:
794: BEGIN
795: -- Initialize the Error Stack

Line 971: FROM pa_progress_report_vers

967: l_rowid rowid;
968:
969: CURSOR check_status_submitted IS
970: SELECT ROWID
971: FROM pa_progress_report_vers
972: WHERE version_id = p_version_id
973: AND report_status_code = 'PROGRESS_REPORT_SUBMITTED';
974:
975: CURSOR get_template_type

Line 1120: FROM pa_progress_report_vers

1116: l_rowid ROWID;
1117:
1118: CURSOR check_status_submitted IS
1119: SELECT ROWID
1120: FROM pa_progress_report_vers
1121: WHERE version_id = p_version_id
1122: AND report_status_code = 'PROGRESS_REPORT_SUBMITTED';
1123:
1124: CURSOR get_template_type

Line 1282: FROM pa_progress_report_vers

1278:
1279: CURSOR is_report_status_working
1280: IS
1281: SELECT Decode(report_status_code, 'PROGRESS_REPORT_WORKING','Y', 'N')
1282: FROM pa_progress_report_vers
1283: WHERE version_id = p_version_id;
1284:
1285: CURSOR get_person_id
1286: IS

Line 1972: pa_progress_report_vers pprv

1968:
1969: CURSOR get_item_key IS
1970: SELECT MAX(pwp.item_key), max(pwp.item_type)
1971: from pa_wf_processes pwp, pa_project_statuses pps,
1972: pa_progress_report_vers pprv
1973: where pwp.item_type = pps.WORKFLOW_ITEM_TYPE
1974: and pps.status_type = 'PROGRESS_REPORT'
1975: and pps.project_status_code = 'PROGRESS_REPORT_SUBMITTED'
1976: AND entity_key2 = p_version_id

Line 2011: FROM pa_progress_report_vers

2007:
2008:
2009: CURSOR check_status_submitted IS
2010: SELECT ROWID
2011: FROM pa_progress_report_vers
2012: WHERE version_id = p_version_id
2013: AND report_status_code = 'PROGRESS_REPORT_SUBMITTED';
2014:
2015:

Line 2119: -- delete record in pa_progress_report_vers under the p_version_id

2115: );
2116:
2117: IF (x_return_status = FND_API.g_ret_sts_success) THEN
2118:
2119: -- delete record in pa_progress_report_vers under the p_version_id
2120: pa_progress_report_pkg.delete_progress_report_ver_row
2121: (
2122: p_version_id,
2123: p_record_version_number,

Line 2186: pa_progress_report_vers p2

2182: WHERE exists
2183: (
2184: SELECT p1.approval_required
2185: FROM pa_object_page_layouts p1,
2186: pa_progress_report_vers p2
2187: WHERE
2188: p2.version_id = p_version_id
2189: AND p2.object_id = p1.object_id
2190: AND p2.object_type = p1.object_type

Line 2200: pa_progress_report_vers pprv

2196:
2197: CURSOR get_item_key IS
2198: SELECT MAX(pwp.item_key), max(pwp.item_type)
2199: from pa_wf_processes pwp, pa_project_statuses pps,
2200: pa_progress_report_vers pprv
2201: where pwp.item_type = pps.WORKFLOW_ITEM_TYPE
2202: and pps.status_type = 'PROGRESS_REPORT'
2203: and pps.project_status_code = 'PROGRESS_REPORT_SUBMITTED'
2204: AND entity_key2 = p_version_id

Line 2436: pa_progress_report_vers p2

2432:
2433: CURSOR check_auto_approve IS
2434: SELECT p1.approval_required
2435: FROM pa_object_page_layouts p1,
2436: pa_progress_report_vers p2
2437: WHERE
2438: p2.version_id = l_version_id
2439: AND p2.object_id = p1.object_id
2440: AND p2.object_type = p1.object_type;

Line 2457: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv

2453: popl.reminder_days, popl.reminder_days_type, popl.record_version_number,popl.pers_function_name,
2454: popl.page_type_code, popl.initial_progress_status, popl.final_progress_status,popl.rollup_progress_status,
2455: popl.report_type_id, popl.approver_source_id, popl.approver_source_type, popl.effective_from,
2456: popl.effective_to, popl.object_page_layout_id
2457: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv
2458: WHERE pprv.version_id = p_version_id
2459: AND popl.object_id = pprv.object_id
2460: AND popl.object_type = pprv.object_type
2461: AND popl.page_type_code = 'PPR'

Line 2721: FROM pa_progress_report_vers

2717:
2718:
2719: CURSOR get_object_id IS
2720: SELECT object_id
2721: FROM pa_progress_report_vers
2722: WHERE version_id = p_version_id
2723: AND object_type = 'PA_PROJECTS'
2724: AND report_status_code = 'PROGRESS_REPORT_WORKING';
2725:

Line 2969: FROM pa_progress_report_vers

2965: l_dummy VARCHAR2(1);
2966:
2967: CURSOR get_object_id IS
2968: SELECT object_id, report_end_date, report_type_id
2969: FROM pa_progress_report_vers
2970: WHERE version_id = p_version_id
2971: AND object_type = 'PA_PROJECTS';
2972:
2973: CURSOR get_wf_info is

Line 3010: from pa_progress_report_vers

3006: select version_id,report_end_Date ,
3007: record_version_number, summary_version_number
3008: into x_version_id,x_report_end_date,
3009: l_record_version_number, l_summary_version_number
3010: from pa_progress_report_vers
3011: where object_id = l_project_id
3012: and object_Type = 'PA_PROJECTS'
3013: and report_type_id = l_report_Type_id
3014: and page_type_code = 'PPR'

Line 3223: FROM pa_progress_report_vers

3219:
3220: CURSOR report_exist
3221: IS
3222: SELECT rowid
3223: FROM pa_progress_report_vers
3224: WHERE object_id = p_object_id
3225: AND object_type = p_object_type
3226: AND report_type_id = p_report_type_id
3227: AND report_status_code = 'PROGRESS_REPORT_PUBLISHED';

Line 3233: FROM pa_progress_report_vers p1

3229: /* Commented and changed as below for bug 5956107
3230: CURSOR get_last_published_version_id
3231: IS
3232: SELECT version_id
3233: FROM pa_progress_report_vers p1
3234: WHERE
3235: p1.object_id = p_object_id
3236: AND p1.object_type = p_object_type
3237: ANd p1.report_type_id = p_report_type_id

Line 3243: FROM pa_progress_report_vers

3239: AND ROWNUM =1
3240: AND p1.report_end_date =
3241: (
3242: SELECT MAX(report_end_date)
3243: FROM pa_progress_report_vers
3244: WHERE
3245: object_id = p_object_id
3246: AND object_type = p_object_type
3247: AND report_type_id = p_report_type_id

Line 3254: FROM pa_progress_report_vers p1

3250:
3251: CURSOR get_last_published_version_id
3252: IS
3253: SELECT version_id
3254: FROM pa_progress_report_vers p1
3255: WHERE
3256: p1.object_id = p_object_id
3257: AND p1.object_type = p_object_type
3258: ANd p1.report_type_id = p_report_type_id

Line 3264: FROM pa_progress_report_vers

3260: AND ROWNUM =1
3261: AND p1.published_date =
3262: (
3263: SELECT MAX(published_date)
3264: FROM pa_progress_report_vers
3265: WHERE
3266: object_id = p_object_id
3267: AND object_type = p_object_type
3268: AND report_type_id = p_report_type_id

Line 3279: FROM pa_progress_report_vers

3275: WHERE version_id = l_last_published_version_id;
3276:
3277: CURSOR get_publish_overview IS
3278: SELECT overview, progress_status_code, REPORT_START_DATE
3279: FROM pa_progress_report_vers
3280: WHERE version_id = l_last_published_version_id;
3281:
3282: CURSOR get_all_regions_from_template IS
3283: SELECT pplr.*

Line 3294: FROM pa_progress_report_vers

3290: from pa_project_parties where project_id = p_object_id;
3291:
3292: CURSOR get_max_report_end_date
3293: IS SELECT MAX(report_end_date)
3294: FROM pa_progress_report_vers
3295: WHERE object_id = p_object_id
3296: AND object_type = p_object_type
3297: AND report_Type_id = p_report_Type_id
3298: ;

Line 3387: -- create an entry in pa_progress_report_vers table

3383: END IF;
3384:
3385: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
3386:
3387: -- create an entry in pa_progress_report_vers table
3388:
3389: --debug_msg('before get dates' || To_char(l_reporting_cycle_id));
3390:
3391: IF l_reporting_cycle_id IS NOT NULL then

Line 3748: FROM pa_progress_report_vers

3744: AND region_code = 'PA_PROGRESS_PROJECT_DATES';
3745:
3746: CURSOR get_object_info IS
3747: SELECT object_id, object_type, report_end_date
3748: FROM pa_progress_report_vers
3749: WHERE version_id = p_version_id;
3750:
3751:
3752: CURSOR get_project_id IS

Line 4045: from pa_progress_report_vers

4041: where region_code = l_temp_region_src_code
4042: and region_source_type = l_region_source_type_tbl(i)
4043: and version_id in
4044: (select version_id
4045: from pa_progress_report_vers
4046: where page_id = p_page_id
4047: and report_status_code in ('PROGRESS_REPORT_WORKING','PROGRESS_REPORT_REJECTED'));
4048: end if;
4049: end loop;