APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_PAGE_LAYOUTS

Line 1501: FROM pa_page_layouts

1497:
1498: CURSOR get_page_id
1499: IS
1500: SELECT page_id
1501: FROM pa_page_layouts
1502: WHERE page_name = p_page_name
1503: AND page_type_code = p_page_type_code;
1504:
1505: CURSOR report_type_exists

Line 3212: FROM pa_object_page_layouts popl, pa_page_layouts ppl

3208:
3209: CURSOR get_page_id_type
3210: IS
3211: SELECT popl.page_id, popl.page_type_code, popl.reporting_cycle_id, popl.report_offset_days,popl.effective_from
3212: FROM pa_object_page_layouts popl, pa_page_layouts ppl
3213: WHERE popl.object_id = p_object_id
3214: AND popl.object_type = p_object_type
3215: AND popl.report_type_id = p_report_type_id
3216: AND popl.page_id = ppl.page_id

Line 3905: p_page_id IN pa_page_layouts.page_id%TYPE

3901: status report versions using this page layout.
3902: */
3903: PROCEDURE delete_version_data
3904: (
3905: p_page_id IN pa_page_layouts.page_id%TYPE
3906: ,p_region_source_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
3907: ,p_region_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3908: ,p_region_source_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3909: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3927: cursor c_page_layout_regions(c_page_id pa_page_layouts.page_id%TYPE)

3923: This cursor fetches all non mandatory regions selected currently for this page
3924: Currently data can be associated only for the regions of style STD,
3925: STD_CUST and DFF. So this cursor will fetch only these regions.
3926: */
3927: cursor c_page_layout_regions(c_page_id pa_page_layouts.page_id%TYPE)
3928: is
3929: select
3930: layout.region_source_type,
3931: layout.view_region_code,