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_PLAN_RL_FORMATS

Line 1730: Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format(

1726: Raise l_ERROR;
1727:
1728: END;
1729:
1730: Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format(
1731: P_Res_List_Id => L_plan_res_list_Rec.p_resource_list_id,
1732: P_Res_Format_Id => L_Plan_RL_Format_Tbl(i).P_Res_Format_Id,
1733: X_Plan_RL_Format_Id => X_Plan_RL_Format_Tbl(i).X_Plan_RL_Format_Id,
1734: X_Record_Version_Number => X_Plan_RL_Format_Tbl(i).X_Record_Version_Number,

Line 1940: FROM pa_plan_rl_formats

1936: BEGIN
1937:
1938: SELECT 'Y'
1939: INTO l_format_exists
1940: FROM pa_plan_rl_formats
1941: WHERE resource_list_id = L_Plan_res_list_Rec.p_resource_list_id
1942: AND res_format_id = L_planning_resource_in_tbl(i).p_res_format_id;
1943:
1944: EXCEPTION

Line 2350: FROM Pa_Plan_rl_formats

2346: * ******************************************************/
2347: BEGIN
2348: SELECT res_format_id,plan_rl_format_id
2349: BULK COLLECT INTO l_res_format_id_tbl,l_plan_rl_format_id_tbl
2350: FROM Pa_Plan_rl_formats
2351: WHERE resource_list_id = p_res_list_id;
2352: EXCEPTION
2353: WHEN OTHERS THEN
2354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2361: * Call to the Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format API

2357: IF l_res_format_id_tbl.COUNT > 0 THEN
2358: FOR i IN l_res_format_id_tbl.first..l_res_format_id_tbl.last
2359: LOOP
2360: /**************************************************
2361: * Call to the Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format API
2362: * to Delete all the formats from the pa_plan_rl_formats
2363: * table. We are passing table elements
2364: **************************************************/
2365: Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format (

Line 2362: * to Delete all the formats from the pa_plan_rl_formats

2358: FOR i IN l_res_format_id_tbl.first..l_res_format_id_tbl.last
2359: LOOP
2360: /**************************************************
2361: * Call to the Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format API
2362: * to Delete all the formats from the pa_plan_rl_formats
2363: * table. We are passing table elements
2364: **************************************************/
2365: Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format (
2366: P_Res_List_Id => P_res_list_id,

Line 2365: Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format (

2361: * Call to the Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format API
2362: * to Delete all the formats from the pa_plan_rl_formats
2363: * table. We are passing table elements
2364: **************************************************/
2365: Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format (
2366: P_Res_List_Id => P_res_list_id,
2367: P_Res_Format_Id => l_res_format_id_tbl(i),
2368: P_Plan_RL_Format_Id => l_plan_rl_format_id_tbl(i),
2369: X_Return_Status => l_return_status,

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 2409: SELECT 'Y' from pa_plan_rl_formats

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);
2411: EXCEPTION
2412: WHEN NO_DATA_FOUND THEN
2413: l_exist_res_list := 'N';

Line 2480: * Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format

2476: /************************************************************
2477: * Procedure : Create_Plan_RL_Format
2478: * Description : This procedure is used the pass a Table of
2479: * Record, and call the
2480: * Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format
2481: * procedure, which would create the res formats.
2482: * The detailed information is in the spec.
2483: **************************************************************/
2484: Procedure Create_Plan_RL_Format(

Line 2547: Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format(

2543:
2544: End If;
2545: --End of bug 3675288.
2546:
2547: Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format(
2548: P_Res_List_Id =>P_Res_List_Id,
2549: P_Res_Format_Id =>L_Plan_RL_Format_Tbl(i).P_Res_Format_Id,
2550: X_Plan_RL_Format_Id =>X_Plan_RL_Format_Tbl(i).X_Plan_RL_Format_Id,
2551: X_Record_Version_Number =>

Line 2598: * Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format

2594: /************************************************************
2595: * Procedure : Delete_Plan_RL_Format
2596: * Description : This procedure is used the pass a Table of
2597: * Record, and call the
2598: * Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format
2599: * procedure, which would Delete the res formats.
2600: * The detailed information is in the spec.
2601: **************************************************************/
2602: Procedure Delete_Plan_RL_Format (

Line 2632: Pa_Plan_RL_Formats_pvt.Delete_Plan_RL_Format (

2628: ****************************************************************/
2629: FOR i IN 1..P_Plan_RL_Format_Tbl.COUNT
2630: LOOP
2631:
2632: Pa_Plan_RL_Formats_pvt.Delete_Plan_RL_Format (
2633: P_Res_List_Id =>P_Res_List_Id,
2634: P_Res_Format_Id =>L_Plan_RL_Format_Tbl(i).P_Res_Format_Id,
2635: P_Plan_RL_Format_Id =>Null,
2636: X_Return_Status =>X_Return_Status,

Line 2826: FROM pa_plan_rl_formats

2822: BEGIN
2823:
2824: SELECT 'Y'
2825: INTO l_format_exists
2826: FROM pa_plan_rl_formats
2827: WHERE resource_list_id = p_resource_list_id
2828: AND res_format_id = L_planning_resource_in_tbl(i).p_res_format_id;
2829:
2830: EXCEPTION