[Home] [Help]
230: END IF;
231:
232: -- we need to validate that the role actually belongs to the role_type
233: SELECT 'Y' INTO l_status
234: FROM dual
235: WHERE exists
236: (
237: SELECT role_list_id FROM pa_role_list_members
238: WHERE role_list_id = x_role_list_id
397: ,x_return_status out NOCOPY varchar2 --File.Sql.39 bug 4440895
398: ,x_error_message_code out NOCOPY varchar2) IS --File.Sql.39 bug 4440895
399: cursor c_allow_schedule is
400: --select '1'
401: --from dual
402: --where exists
403: select 'Y'
404: from pa_role_controls
405: where project_role_id=p_role_id
427: ---FUNCTION Get_Schedulable_flag
428: FUNCTION Get_Schedulable_flag (p_role_id in number) return varchar2 is
429: cursor c_allow_schedule is
430: --select '1'
431: --from dual
432: --where exists
433: select 'Y'
434: from pa_role_controls
435: where project_role_id=p_role_id
471: ,x_return_status out NOCOPY varchar2 --File.Sql.39 bug 4440895
472: ,x_error_message_code out NOCOPY varchar2) IS --File.Sql.39 bug 4440895
473: cursor c_seed_roles is
474: --select '1'
475: --from dual
476: --where exists
477: select 'Y'
478: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
479: pa_project_role_types_b */
531: and role_control_code =p_role_control_code;
532: /* Fix for bug 1829383 */
533: cursor c_seed_roles is
534: --select '1'
535: --from dual
536: --where exists
537: select 'Y'
538: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types to
539: pa_project_role_types_b */
610: ,x_error_message_code out NOCOPY varchar2) IS --File.Sql.39 bug 4440895
611:
612: cursor c_role_list_in_use is
613: --select '1'
614: --from dual
615: --where exists
616: select 'Y'
617: from pa_projects_all
618: where role_list_id=p_role_list_id
834: * table.
835: *********************************************************/
836: cursor c_role_in_use is
837: SELECT '1'
838: FROM dual
839: WHERE EXISTS (SELECT 'Y'
840: FROM pa_project_parties ppp
841: WHERE ppp.project_role_id=p_role_id)
842: OR EXISTS