eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLAN_RES_LIST_PUB dependencies on PA_RESOURCE_LIST_MEMBERS

Line 294: From Pa_resource_list_members

290: IS
291:
292: Cursor C_Member_Details(P_Member_Id IN Number) Is
293: Select *
294: From Pa_resource_list_members
295: Where
296: resource_list_member_id=P_Member_Id;
297:
298: member_rec_details C_Member_Details%RowType;

Line 330: FROM pa_resource_list_members

326:
327: BEGIN
328: SELECT resource_list_member_id
329: INTO l_member_id
330: FROM pa_resource_list_members
331: WHERE alias = p_planning_resource_in_tbl(i).P_resource_alias
332: and resource_list_id = P_Plan_res_list_Rec.p_resource_list_id;
333: EXCEPTION
334: WHEN NO_DATA_FOUND THEN

Line 351: FROM PA_RESOURCE_LIST_MEMBERS

347: END IF;
348:
349: SELECT resource_list_member_id
350: INTO l_member_id
351: FROM PA_RESOURCE_LIST_MEMBERS
352: WHERE resource_list_id = P_Plan_res_list_Rec.p_resource_list_id
353: AND ALIAS = p_planning_resource_in_tbl(i).p_resource_alias
354: AND object_type = l_object_type
355: AND object_id = l_object_id;

Line 1797: * pa_resource_list_members table or not.

1793:
1794: /**********************************************************
1795: * For each of the resource_list_memeber_id in the table.
1796: * We'll first check if an entry is present in the
1797: * pa_resource_list_members table or not.
1798: * If it is present then we'll call the
1799: * Pa_Planning_resource_pvt.Update_Planning_Resource api,
1800: * which would just update the corr record in the table.
1801: * If it is not present then we'll call the

Line 1830: FROM PA_RESOURCE_LIST_MEMBERS

1826: SELECT resource_list_member_id,
1827: record_version_number
1828: INTO L_planning_resource_in_tbl(i).p_resource_list_member_id,
1829: l_rlm_record_version_number
1830: FROM PA_RESOURCE_LIST_MEMBERS
1831: WHERE resource_list_id = l_old_resource_list_rec.resource_list_id
1832: AND ALIAS = L_planning_resource_in_tbl(i).p_resource_alias;
1833:
1834: l_check_exist := 'Y';

Line 1855: FROM PA_RESOURCE_LIST_MEMBERS

1851: SELECT resource_list_member_id,
1852: record_version_number
1853: INTO l_planning_resource_in_tbl(i).p_resource_list_member_id,
1854: l_rlm_record_version_number
1855: FROM PA_RESOURCE_LIST_MEMBERS
1856: WHERE resource_list_id = l_old_resource_list_rec.resource_list_id
1857: AND ALIAS = L_planning_resource_in_tbl(i).p_resource_alias
1858: AND object_type = l_object_type
1859: AND object_id = l_object_id;

Line 1876: From pa_resource_list_members

1872: If L_planning_resource_in_tbl(i).p_resource_list_member_id Is not Null Then
1873: Begin
1874: Select record_version_number
1875: Into l_rlm_record_version_number
1876: From pa_resource_list_members
1877: Where resource_list_member_id = L_planning_resource_in_tbl(i).p_resource_list_member_id;
1878:
1879: Exception
1880: When No_Data_Found Then

Line 2304: * to Delete all the members from the pa_resource_list_members

2300: END IF;
2301:
2302: /**************************************************
2303: * Call to the Delete_Planning_Resources procedure
2304: * to Delete all the members from the pa_resource_list_members
2305: * table. We are passing a table of resource_list_member_id's
2306: * to the procedure.
2307: **************************************************/
2308: /*****************************************************

Line 2316: FROM Pa_resource_list_members

2312: * ******************************************************/
2313: BEGIN
2314: SELECT resource_list_member_id
2315: BULK COLLECT INTO l_res_list_member_id_tbl
2316: FROM Pa_resource_list_members
2317: WHERE resource_list_id = p_res_list_id;
2318: EXCEPTION
2319: WHEN OTHERS THEN
2320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2411: * pa_resource_list_members table or in the pa_plan_rl_formats

2407: END IF;
2408:
2409: /*****************************************************
2410: * Check if the resource_list_id passed exists in the
2411: * pa_resource_list_members table or in the pa_plan_rl_formats
2412: * table. If it does then ewe cannot delete the record from
2413: * the pa_resource_lists_all_bg table, as corr child members
2414: * are present.
2415: *****************************************************/

Line 2421: (SELECT 'Y' from pa_resource_list_members

2417: SELECT 'Y'
2418: INTO l_exist_res_list
2419: FROM DUAL
2420: WHERE EXISTS
2421: (SELECT 'Y' from pa_resource_list_members
2422: WHERE resource_list_id = P_res_list_id
2423: UNION
2424: SELECT 'Y' from pa_plan_rl_formats
2425: WHERE resource_list_id = P_res_list_id);

Line 3415: Pa_Resource_List_Members rlm,

3411: P_Prj_Id IN Number) Is
3412: Select
3413: rlm.Resource_List_Member_Id
3414: From
3415: Pa_Resource_List_Members rlm,
3416: Pa_Resource_Lists_All_BG rl
3417: Where
3418: rlm.Alias = P_Alias
3419: And rlm.Resource_List_Id = P_Res_List_Id

Line 3430: Pa_Resource_List_Members

3426: Cursor c2(P_rlm_Id IN Number) Is
3427: Select
3428: Record_Version_Number
3429: From
3430: Pa_Resource_List_Members
3431: Where
3432: Resource_List_Member_Id = P_rlm_Id;
3433:
3434: l_rlm_id Number := Null;