APPS.PA_PROGRESS_REPORT_UTILS dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 119: from pa_object_page_layouts pop

115:
116: Cursor C1 is
117: Select nvl(approval_required,'N') approval_required
118: -- ,nvl(auto_publish,'N') auto_publish
119: from pa_object_page_layouts pop
120: ,pa_progress_report_vers prv
121: where pop.object_type = prv.object_type
122: and pop.object_id = prv.object_id
123: and pop.report_type_id = prv.report_type_id ---report_type_id will be there for PPR

Line 127: l_approval_required pa_object_page_layouts.approval_required%TYPE;

123: and pop.report_type_id = prv.report_type_id ---report_type_id will be there for PPR
124: and pop.page_type_code = prv.page_type_code
125: and prv.version_id = p_version_id;
126:
127: l_approval_required pa_object_page_layouts.approval_required%TYPE;
128: l_auto_publish VARCHAR2(1);
129: x_ret_code VARCHAR2(1); --FND_API.G_TRUE%TYPE;
130: x_return_status VARCHAR2(1); --FND_API.G_RET_STS_SUCCESS%TYPE;
131: BEGIN

Line 317: from pa_object_page_layouts

313: ) IS
314:
315: Cursor c_page_type
316: is select page_type_code
317: from pa_object_page_layouts
318: where page_id = p_page_id;
319:
320: CURSOR get_page_type_code
321: IS

Line 565: FROM pa_object_page_layouts

561: IS SELECT 'Y'
562: FROM dual
563: WHERE exists(
564: SELECT page_id
565: FROM pa_object_page_layouts
566: WHERE object_id = p_object_id
567: AND object_type = p_object_type
568: );
569:

Line 684: select page_id from pa_object_page_layouts

680: l_model VARCHAR2(10) := null;
681: l_page_id_s VARCHAR2(10) := null;
682: cursor C1
683: is
684: select page_id from pa_object_page_layouts
685: where page_type_code = p_page_type_code
686: and object_type = p_object_type
687: and object_id = p_object_id;
688:

Line 691: select page_id from pa_object_page_layouts

687: and object_id = p_object_id;
688:
689: cursor C3
690: is
691: select page_id from pa_object_page_layouts
692: where object_id = p_object_id
693: and object_type = p_object_type
694: and report_type_id = p_report_Type_id
695: and page_type_code = p_page_type_code;

Line 962: from pa_object_page_layouts

958:
959: begin
960: select object_page_layout_id
961: into l_object_page_layout_id
962: from pa_object_page_layouts
963: where object_id = p_object_id and
964: object_type = p_object_type and
965: report_Type_id = p_report_Type_id;
966: exception when others then

Line 997: from pa_object_page_layouts

993:
994: begin
995: select object_page_layout_id
996: into l_object_page_layout_id
997: from pa_object_page_layouts
998: where object_id = p_object_id and
999: object_type = p_object_type and
1000: report_Type_id = p_report_Type_id;
1001: exception when others then

Line 1096: from pa_object_page_layouts

1092: Function is_cycle_ok_to_delete(p_reporting_cycle_id IN NUMBER) return varchar2
1093: IS
1094: cursor rep_cycle is
1095: select 'N'
1096: from pa_object_page_layouts
1097: where reporting_cycle_id = p_reporting_cycle_id;
1098:
1099: retval varchar2(1);
1100: l_rep_cycle rep_cycle%rowtype;

Line 1145: FROM fnd_menus m, pa_object_page_layouts o

1141: l_menu_name VARCHAR2(100);
1142: BEGIN
1143: SELECT menu_name
1144: INTO l_menu_name
1145: FROM fnd_menus m, pa_object_page_layouts o
1146: WHERE m.menu_id=o.page_id
1147: AND o.page_type_code='TAB_MENU'
1148: AND o.object_type='PA_PROJECTS'
1149: AND o.object_id=p_project_id;

Line 1158: -- already copied as part of pa_object_page_layouts table.

1154: RETURN 'PA_SINGLE_TAB_MENU';
1155: END get_tab_menu_name;
1156:
1157: -- Notes: Due to bug 3620190 this api is no longer in used. The tab setup is
1158: -- already copied as part of pa_object_page_layouts table.
1159: PROCEDURE copy_project_tab_menu(
1160: p_src_project_id IN NUMBER,
1161: p_dest_project_id IN NUMBER,
1162: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895