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 2108: -- delete all records in pa_progress_report_vals under the p_version_id

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

Line 3274: FROM pa_progress_report_vals

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

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

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

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

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

Line 3742: SELECT attribute7 FROM pa_progress_report_vals

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

Line 3865: -- UPDATE pa_progress_report_vals

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

Line 4040: delete from pa_progress_report_vals

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