APPS.PA_PROGRESS_REPORT_PKG dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 651: cursor C is select ROWID from PA_OBJECT_PAGE_LAYOUTS

647: l_version_id NUMBER;
648: l_rowid ROWID;
649: l_layout_id NUMBER;
650:
651: cursor C is select ROWID from PA_OBJECT_PAGE_LAYOUTS
652: where object_Page_Layout_id = l_layout_id;
653:
654: BEGIN
655:

Line 659: SELECT pa_object_page_layouts_s.nextval

655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657:
658: --get the unique task id from the Oracle Sequence
659: SELECT pa_object_page_layouts_s.nextval
660: INTO l_layout_id
661: FROM DUAL;
662:
663:

Line 664: insert into PA_OBJECT_PAGE_LAYOUTS (

660: INTO l_layout_id
661: FROM DUAL;
662:
663:
664: insert into PA_OBJECT_PAGE_LAYOUTS (
665: OBJECT_ID,
666: OBJECT_TYPE,
667: PAGE_ID,
668: PAGE_TYPE_CODE,

Line 778: update PA_OBJECT_PAGE_LAYOUTS set

774: ) is
775: begin
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777:
778: update PA_OBJECT_PAGE_LAYOUTS set
779: OBJECT_ID = Nvl(p_object_id, object_id),
780: OBJECT_TYPE = Nvl(p_object_type, object_type),
781: PAGE_ID = Nvl(p_page_id, page_id),
782: PAGE_TYPE_CODE = Nvl(p_page_type_code, page_type_CODE),

Line 834: DELETE FROM PA_OBJECT_PAGE_LAYOUTS

830: ) is
831: begin
832: x_return_status := FND_API.G_RET_STS_SUCCESS;
833:
834: DELETE FROM PA_OBJECT_PAGE_LAYOUTS
835: where object_ID = p_object_id
836: AND object_type = p_object_type;
837:
838: