APPS.PA_RESOURCES_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 185: l_uncateg_rl_name pa_resource_list_members.alias%TYPE; /* added the variable for bug 2738156 */

181:
182: P_Name VARCHAR2(80); -- Bug 2191972, incresed the size from 60 to 80.
183: /*Commented the code for bug# 4143659 as this is not required.
184: P_START_DATE_ACTIVE pa_resources.start_date_active%TYPE; */
185: l_uncateg_rl_name pa_resource_list_members.alias%TYPE; /* added the variable for bug 2738156 */
186: BEGIN
187: select resource_type_code
188: into P_Resource_Type_Code
189: from pa_resource_types

Line 253: pa_resource_list_members m,

249:
250: select distinct m.alias /* bug 7615636 */
251: into l_uncateg_rl_name
252: from pa_resources r,
253: pa_resource_list_members m,
254: pa_resource_lists_all_bg rl,
255: pa_implementations i
256: where rl.uncategorized_flag = 'Y'
257: and rl.resource_list_id = m.resource_list_id

Line 276: Function Get_Resource_List_Member_Name(p_resource_list_member_Id IN pa_resource_list_members.resource_list_member_id%TYPE)

272: WHEN OTHERS THEN
273: RAISE;
274: END Get_Resource_Name;
275:
276: Function Get_Resource_List_Member_Name(p_resource_list_member_Id IN pa_resource_list_members.resource_list_member_id%TYPE)
277: RETURN VARCHAR2
278: IS
279: l_resource_id pa_resource_list_members.resource_id%TYPE;
280: l_resource_type_id pa_resource_list_members.resource_type_id%TYPE;

Line 279: l_resource_id pa_resource_list_members.resource_id%TYPE;

275:
276: Function Get_Resource_List_Member_Name(p_resource_list_member_Id IN pa_resource_list_members.resource_list_member_id%TYPE)
277: RETURN VARCHAR2
278: IS
279: l_resource_id pa_resource_list_members.resource_id%TYPE;
280: l_resource_type_id pa_resource_list_members.resource_type_id%TYPE;
281: BEGIN
282:
283: select resource_id, resource_type_id

Line 280: l_resource_type_id pa_resource_list_members.resource_type_id%TYPE;

276: Function Get_Resource_List_Member_Name(p_resource_list_member_Id IN pa_resource_list_members.resource_list_member_id%TYPE)
277: RETURN VARCHAR2
278: IS
279: l_resource_id pa_resource_list_members.resource_id%TYPE;
280: l_resource_type_id pa_resource_list_members.resource_type_id%TYPE;
281: BEGIN
282:
283: select resource_id, resource_type_id
284: into l_resource_id,l_resource_type_id

Line 285: from pa_resource_list_members

281: BEGIN
282:
283: select resource_id, resource_type_id
284: into l_resource_id,l_resource_type_id
285: from pa_resource_list_members
286: where resource_list_member_id = p_resource_list_member_Id;
287:
288: return Get_Resource_Name(l_resource_id, l_resource_type_id);
289: