[Home] [Help]
47: IS
48:
49: Cursor C_Res_List_Details(P_Res_List_Id IN Number) IS
50: Select *
51: From Pa_Resource_Lists_All_Bg
52: Where resource_list_id=P_Res_List_Id;
53:
54: Rec_Details C_Res_List_Details%RowType;
55:
72: -- Get the Resource list id from the Resource list name if the name is not defaulted to null.
73: IF l_resource_list_name is not null and l_resource_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
74: SELECT resource_list_id
75: INTO l_resource_list_id
76: FROM pa_resource_lists_all_bg
77: WHERE name=l_resource_list_name;
78: END IF;
79: END IF;
80:
1545: start_date_active,
1546: end_date_active,
1547: job_group_id,
1548: use_for_wp_flag
1549: FROM PA_RESOURCE_LISTS_ALL_BG
1550: WHERE resource_list_id = p_resource_list_id;
1551:
1552: l_old_resource_list_rec resource_list_cursor%RowType;
1553:
2394: /*****************************************************
2395: * Check if the resource_list_id passed exists in the
2396: * pa_resource_list_members table or in the pa_plan_rl_formats
2397: * table. If it does then ewe cannot delete the record from
2398: * the pa_resource_lists_all_bg table, as corr child members
2399: * are present.
2400: *****************************************************/
2401: BEGIN
2402: SELECT 'Y'
3369:
3370: IS
3371:
3372: -- If need to get the resource_list_member_id using the alias then
3373: -- If control_flag <> 'N' from pa_resource_lists_all_bg this means centralized and only need the
3374: -- predicates to resource_list_id and alias to get the resource_list_member_id
3375: -- If the control_flag = 'N' then we need to add predicates for object_type and object_id.
3376: -- The object_type = 'PROJECT' and the object_id is the project_id.
3377: Cursor c1(P_Alias IN Varchar2,
3380: Select
3381: rlm.Resource_List_Member_Id
3382: From
3383: Pa_Resource_List_Members rlm,
3384: Pa_Resource_Lists_All_BG rl
3385: Where
3386: rlm.Alias = P_Alias
3387: And rlm.Resource_List_Id = P_Res_List_Id
3388: And rlm.Resource_List_Id = rl.Resource_List_Id