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 1971: pa_progress_report_vers pprv

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

Line 2010: FROM pa_progress_report_vers

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

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

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

Line 2185: pa_progress_report_vers p2

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

Line 2199: pa_progress_report_vers pprv

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

Line 2435: pa_progress_report_vers p2

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

Line 2456: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv

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

Line 2720: FROM pa_progress_report_vers

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

Line 2968: FROM pa_progress_report_vers

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

Line 3009: from pa_progress_report_vers

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

Line 3222: FROM pa_progress_report_vers

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

Line 3232: FROM pa_progress_report_vers p1

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

Line 3242: FROM pa_progress_report_vers

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

Line 3253: FROM pa_progress_report_vers p1

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

Line 3263: FROM pa_progress_report_vers

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

Line 3278: FROM pa_progress_report_vers

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

Line 3293: FROM pa_progress_report_vers

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

Line 3386: -- create an entry in pa_progress_report_vers table

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

Line 3747: FROM pa_progress_report_vers

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

Line 4044: from pa_progress_report_vers

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