eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_PAGE_LAYOUT_REGIONS

Line 3284: FROM pa_page_layout_regions pplr

3280: WHERE version_id = l_last_published_version_id;
3281:
3282: CURSOR get_all_regions_from_template IS
3283: SELECT pplr.*
3284: FROM pa_page_layout_regions pplr
3285: WHERE pplr.page_id = l_page_id;
3286:
3287: CURSOR get_project_manager
3288: IS

Line 3933: from pa_page_layout_regions layout, pa_page_type_regions type

3929: select
3930: layout.region_source_type,
3931: layout.view_region_code,
3932: layout.region_source_code
3933: from pa_page_layout_regions layout, pa_page_type_regions type
3934: where layout.page_id = c_page_id
3935: and layout.region_source_type in ('STD','STD_CUST','DFF')
3936: and type.page_type_code = 'PPR'
3937: and type.region_source_type = layout.region_source_type

Line 3942: Type region_source_type_tbl_typ is table of pa_page_layout_regions.region_source_type%TYPE index by binary_integer;

3938: and type.region_source_code = decode(layout.region_source_type,'STD_CUST',layout.view_region_code,layout.region_source_code)
3939: and nvl(layout.region_style, 'N') <> 'LINK'
3940: and type.mandatory_flag = 'N';
3941:
3942: Type region_source_type_tbl_typ is table of pa_page_layout_regions.region_source_type%TYPE index by binary_integer;
3943: Type view_region_code_tbl_typ is table of pa_page_layout_regions.view_region_code%TYPE index by binary_integer;
3944: Type region_source_code_tbl_typ is table of pa_page_layout_regions.region_source_code%TYPE index by binary_integer;
3945:
3946: l_region_source_type_tbl region_source_type_tbl_typ;

Line 3943: Type view_region_code_tbl_typ is table of pa_page_layout_regions.view_region_code%TYPE index by binary_integer;

3939: and nvl(layout.region_style, 'N') <> 'LINK'
3940: and type.mandatory_flag = 'N';
3941:
3942: Type region_source_type_tbl_typ is table of pa_page_layout_regions.region_source_type%TYPE index by binary_integer;
3943: Type view_region_code_tbl_typ is table of pa_page_layout_regions.view_region_code%TYPE index by binary_integer;
3944: Type region_source_code_tbl_typ is table of pa_page_layout_regions.region_source_code%TYPE index by binary_integer;
3945:
3946: l_region_source_type_tbl region_source_type_tbl_typ;
3947: l_view_region_code_tbl view_region_code_tbl_typ;

Line 3944: Type region_source_code_tbl_typ is table of pa_page_layout_regions.region_source_code%TYPE index by binary_integer;

3940: and type.mandatory_flag = 'N';
3941:
3942: Type region_source_type_tbl_typ is table of pa_page_layout_regions.region_source_type%TYPE index by binary_integer;
3943: Type view_region_code_tbl_typ is table of pa_page_layout_regions.view_region_code%TYPE index by binary_integer;
3944: Type region_source_code_tbl_typ is table of pa_page_layout_regions.region_source_code%TYPE index by binary_integer;
3945:
3946: l_region_source_type_tbl region_source_type_tbl_typ;
3947: l_view_region_code_tbl view_region_code_tbl_typ;
3948: l_region_source_code_tbl region_source_code_tbl_typ;

Line 3952: l_temp_region_src_code pa_page_layout_regions.region_source_code%TYPE;

3948: l_region_source_code_tbl region_source_code_tbl_typ;
3949:
3950: l_found boolean;
3951: j number;
3952: l_temp_region_src_code pa_page_layout_regions.region_source_code%TYPE;
3953: l_module_name varchar2(100) := 'PA_PROGRESS_REPORT_PVT';
3954:
3955: BEGIN
3956: x_msg_count := 0;