APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_PROGRESS_REPORT_VALS

Line 309: FROM PA_Progress_report_VALS

305: l_rowid ROWID;
306:
307: CURSOR check_record_version IS
308: SELECT ROWID
309: FROM PA_Progress_report_VALS
310: WHERE version_id = p_version_id
311: AND region_source_type = p_region_source_type
312: AND region_code = p_region_code
313: AND record_sequence = p_record_sequence

Line 574: FROM PA_progress_report_VALS

570: l_rowid ROWID;
571:
572: CURSOR check_record_version IS
573: SELECT ROWID
574: FROM PA_progress_report_VALS
575: WHERE version_id = p_version_id
576: AND region_source_type = p_region_source_type
577: AND region_code = p_region_code
578: AND record_sequence = p_record_sequence

Line 2107: -- delete all records in pa_progress_report_vals under the p_version_id

2103:
2104:
2105: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
2106:
2107: -- delete all records in pa_progress_report_vals under the p_version_id
2108: pa_progress_report_pkg.delete_progress_report_vals
2109: (
2110: p_version_id,
2111: x_return_status ,

Line 3273: FROM pa_progress_report_vals

3269: );
3270:
3271: CURSOR get_all_regions IS
3272: SELECT *
3273: FROM pa_progress_report_vals
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

Line 3488: -- copy it, create entries in pa_progress_report_vals table

3484:
3485: --debug_msg ('no published report');
3486:
3487: -- if there is existing published report
3488: -- copy it, create entries in pa_progress_report_vals table
3489: /* No need to create an empty region rows if there is no prior publised
3490: Report - msundare */
3491: /******************
3492: FOR obj_page_value_rec IN get_all_regions_from_template LOOP

Line 3621: -- copy it, create entries in pa_progress_report_vals table

3617:
3618: IF x_return_status = FND_API.g_ret_sts_success then
3619: --debug_msg ('published report' || To_char(l_last_published_version_id));
3620: -- if there is existing published report
3621: -- copy it, create entries in pa_progress_report_vals table
3622: FOR obj_page_value_rec IN get_all_regions LOOP
3623:
3624: --debug_msg ('published report' || obj_page_value_rec.region_code);
3625: pa_progress_report_pkg.insert_progress_report_val_row

Line 3741: SELECT attribute7 FROM pa_progress_report_vals

3737:
3738:
3739:
3740: CURSOR get_percent_complete IS
3741: SELECT attribute7 FROM pa_progress_report_vals
3742: WHERE version_id = p_version_id
3743: AND region_code = 'PA_PROGRESS_PROJECT_DATES';
3744:
3745: CURSOR get_object_info IS

Line 3864: -- UPDATE pa_progress_report_vals

3860:
3861:
3862: IF l_object_type = 'PA_PROJECTS' THEN
3863:
3864: -- UPDATE pa_progress_report_vals
3865: -- SET
3866: -- attribute1= To_char(l_sch_start_date, 'YYYY-MM-DD')
3867: -- ,attribute2= To_char(l_sch_end_date, 'YYYY-MM-DD')
3868: -- ,attribute3 = To_char(l_est_start_date, 'YYYY-MM-DD')

Line 4039: delete from pa_progress_report_vals

4035: pa_debug.g_err_stage := 'l_temp_region_src_code :'||l_temp_region_src_code;
4036: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4037: end if;
4038:
4039: delete from pa_progress_report_vals
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