APPS.PA_PERF_NOTIFICATION_PKG dependencies on PA_PROJECTS_ALL

Line 11: ,p_project_id In pa_projects_all.project_id%TYPE

7: =====================================================================*/
8: PROCEDURE START_PERF_NOTIFICATION_WF(
9: p_item_type In VARCHAR2
10: ,p_process_name In VARCHAR2
11: ,p_project_id In pa_projects_all.project_id%TYPE
12: ,x_item_key Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
13: ,x_return_status Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
14: ,x_msg_count Out NOCOPY NUMBER --File.Sql.39 bug 4440895
15: ,x_msg_data Out NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 211: ,p_project_id In pa_projects_all.project_id%TYPE

207: =================================================================*/
208: PROCEDURE SET_PERF_NOTIFY_WF_ATTRIBUTES
209: ( p_item_type In VARCHAR2
210: ,p_process_name In VARCHAR2
211: ,p_project_id In pa_projects_all.project_id%TYPE
212: ,p_item_key In NUMBER
213: ,x_return_status Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
214: ,x_msg_count Out NOCOPY NUMBER --File.Sql.39 bug 4440895
215: ,x_msg_data Out NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 235: l_project_name pa_projects_all.name%TYPE;

231:
232: l_module_name VARCHAR2(100) := 'pa.plsql.set_perf_notify_wf_attributes';
233: Invalid_Arg_Exc_CI Exception;
234:
235: l_project_name pa_projects_all.name%TYPE;
236: l_project_number pa_projects_all.segment1%TYPE;
237: l_role varchar2(30) := NULL;
238: l_role_display_name varchar2(30) := NULL; -- Bug 4565156.
239: l_role_users varchar2(30000) := NULL;

Line 236: l_project_number pa_projects_all.segment1%TYPE;

232: l_module_name VARCHAR2(100) := 'pa.plsql.set_perf_notify_wf_attributes';
233: Invalid_Arg_Exc_CI Exception;
234:
235: l_project_name pa_projects_all.name%TYPE;
236: l_project_number pa_projects_all.segment1%TYPE;
237: l_role varchar2(30) := NULL;
238: l_role_display_name varchar2(30) := NULL; -- Bug 4565156.
239: l_role_users varchar2(30000) := NULL;
240: display_name VARCHAR2(2000);

Line 305: FROM pa_projects_all

301: RAISE Invalid_Arg_Exc_CI;
302: END IF;
303:
304: SELECT name, segment1 INTO l_project_name, l_project_number
305: FROM pa_projects_all
306: WHERE project_id=p_project_id;
307:
308: FOR page_var in get_page(p_project_id)
309: LOOP