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 1782: * pa_resource_list_members table or not.

1778:
1779: /**********************************************************
1780: * For each of the resource_list_memeber_id in the table.
1781: * We'll first check if an entry is present in the
1782: * pa_resource_list_members table or not.
1783: * If it is present then we'll call the
1784: * Pa_Planning_resource_pvt.Update_Planning_Resource api,
1785: * which would just update the corr record in the table.
1786: * If it is not present then we'll call the

Line 1815: FROM PA_RESOURCE_LIST_MEMBERS

1811: SELECT resource_list_member_id,
1812: record_version_number
1813: INTO L_planning_resource_in_tbl(i).p_resource_list_member_id,
1814: l_rlm_record_version_number
1815: FROM PA_RESOURCE_LIST_MEMBERS
1816: WHERE resource_list_id = l_old_resource_list_rec.resource_list_id
1817: AND ALIAS = L_planning_resource_in_tbl(i).p_resource_alias;
1818:
1819: l_check_exist := 'Y';

Line 1840: FROM PA_RESOURCE_LIST_MEMBERS

1836: SELECT resource_list_member_id,
1837: record_version_number
1838: INTO l_planning_resource_in_tbl(i).p_resource_list_member_id,
1839: l_rlm_record_version_number
1840: FROM PA_RESOURCE_LIST_MEMBERS
1841: WHERE resource_list_id = l_old_resource_list_rec.resource_list_id
1842: AND ALIAS = L_planning_resource_in_tbl(i).p_resource_alias
1843: AND object_type = l_object_type
1844: AND object_id = l_object_id;

Line 1861: From pa_resource_list_members

1857: If L_planning_resource_in_tbl(i).p_resource_list_member_id Is not Null Then
1858: Begin
1859: Select record_version_number
1860: Into l_rlm_record_version_number
1861: From pa_resource_list_members
1862: Where resource_list_member_id = L_planning_resource_in_tbl(i).p_resource_list_member_id;
1863:
1864: Exception
1865: When No_Data_Found Then

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

2285: END IF;
2286:
2287: /**************************************************
2288: * Call to the Delete_Planning_Resources procedure
2289: * to Delete all the members from the pa_resource_list_members
2290: * table. We are passing a table of resource_list_member_id's
2291: * to the procedure.
2292: **************************************************/
2293: /*****************************************************

Line 2301: FROM Pa_resource_list_members

2297: * ******************************************************/
2298: BEGIN
2299: SELECT resource_list_member_id
2300: BULK COLLECT INTO l_res_list_member_id_tbl
2301: FROM Pa_resource_list_members
2302: WHERE resource_list_id = p_res_list_id;
2303: EXCEPTION
2304: WHEN OTHERS THEN
2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2396: * pa_resource_list_members table or in the pa_plan_rl_formats

2392: END IF;
2393:
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: *****************************************************/

Line 2406: (SELECT 'Y' from pa_resource_list_members

2402: SELECT 'Y'
2403: INTO l_exist_res_list
2404: FROM DUAL
2405: WHERE EXISTS
2406: (SELECT 'Y' from pa_resource_list_members
2407: WHERE resource_list_id = P_res_list_id
2408: UNION
2409: SELECT 'Y' from pa_plan_rl_formats
2410: WHERE resource_list_id = P_res_list_id);

Line 3383: Pa_Resource_List_Members rlm,

3379: P_Prj_Id IN Number) Is
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

Line 3398: Pa_Resource_List_Members

3394: Cursor c2(P_rlm_Id IN Number) Is
3395: Select
3396: Record_Version_Number
3397: From
3398: Pa_Resource_List_Members
3399: Where
3400: Resource_List_Member_Id = P_rlm_Id;
3401:
3402: l_rlm_id Number := Null;