APPS.PA_PROGRESS_REPORT_PKG dependencies on PA_PROGRESS_REPORT_VALS

Line 271: cursor C is select ROWID from PA_PROGRESS_REPORT_VALS

267:
268: l_rowid ROWID;
269: l_record_sequence NUMBER;
270:
271: cursor C is select ROWID from PA_PROGRESS_REPORT_VALS
272: where VERSION_ID = P_VERSION_ID
273: and REGION_SOURCE_TYPE = P_REGION_SOURCE_TYPE
274: and REGION_CODE = P_REGION_CODE
275: and RECORD_SEQUENCE = L_RECORD_SEQUENCE;

Line 282: insert into PA_PROGRESS_REPORT_VALS (

278:
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280:
281:
282: insert into PA_PROGRESS_REPORT_VALS (
283: VERSION_ID,
284: REGION_SOURCE_TYPE,
285: REGION_CODE,
286: RECORD_SEQUENCE,

Line 464: update PA_PROGRESS_REPORT_VALS set

460:
461:
462: --debug_msg ('***********update attribute 3: ' ||P_ATTRIBUTE3 );
463:
464: update PA_PROGRESS_REPORT_VALS set
465: RECORD_VERSION_NUMBER = record_version_number +1,
466:
467: ATTRIBUTE1 = P_ATTRIBUTE1,
468: ATTRIBUTE2 = P_ATTRIBUTE2,

Line 547: delete from PA_PROGRESS_REPORT_VALS

543: begin
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547: delete from PA_PROGRESS_REPORT_VALS
548: where VERSION_ID = P_VERSION_ID
549: and REGION_SOURCE_TYPE = P_REGION_SOURCE_TYPE
550: and REGION_CODE = P_REGION_CODE
551: and RECORD_SEQUENCE = p_record_sequence

Line 575: delete from PA_PROGRESS_REPORT_VALS

571: begin
572:
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574:
575: delete from PA_PROGRESS_REPORT_VALS
576: where VERSION_ID = p_version_id;
577:
578:
579:

Line 602: delete from PA_PROGRESS_REPORT_VALS

598: begin
599:
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
601:
602: delete from PA_PROGRESS_REPORT_VALS
603: where VERSION_ID = p_version_id
604: AND region_source_type = p_region_source_type
605: AND region_code = p_region_code;
606: