APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_PAGE_LAYOUTS

Line 1500: FROM pa_page_layouts

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

Line 3211: FROM pa_object_page_layouts popl, pa_page_layouts ppl

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

Line 3904: p_page_id IN pa_page_layouts.page_id%TYPE

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

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

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