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 3283: FROM pa_page_layout_regions pplr

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

Line 3932: from pa_page_layout_regions layout, pa_page_type_regions type

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

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

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

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

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

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

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

Line 3951: l_temp_region_src_code pa_page_layout_regions.region_source_code%TYPE;

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