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 1745: Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format(

1741: Raise l_ERROR;
1742:
1743: END;
1744:
1745: Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format(
1746: P_Res_List_Id => L_plan_res_list_Rec.p_resource_list_id,
1747: P_Res_Format_Id => L_Plan_RL_Format_Tbl(i).P_Res_Format_Id,
1748: X_Plan_RL_Format_Id => X_Plan_RL_Format_Tbl(i).X_Plan_RL_Format_Id,
1749: X_Record_Version_Number => X_Plan_RL_Format_Tbl(i).X_Record_Version_Number,

Line 1955: FROM pa_plan_rl_formats

1951: BEGIN
1952:
1953: SELECT 'Y'
1954: INTO l_format_exists
1955: FROM pa_plan_rl_formats
1956: WHERE resource_list_id = L_Plan_res_list_Rec.p_resource_list_id
1957: AND res_format_id = L_planning_resource_in_tbl(i).p_res_format_id;
1958:
1959: EXCEPTION

Line 2365: FROM Pa_Plan_rl_formats

2361: * ******************************************************/
2362: BEGIN
2363: SELECT res_format_id,plan_rl_format_id
2364: BULK COLLECT INTO l_res_format_id_tbl,l_plan_rl_format_id_tbl
2365: FROM Pa_Plan_rl_formats
2366: WHERE resource_list_id = p_res_list_id;
2367: EXCEPTION
2368: WHEN OTHERS THEN
2369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2376: * Call to the Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format API

2372: IF l_res_format_id_tbl.COUNT > 0 THEN
2373: FOR i IN l_res_format_id_tbl.first..l_res_format_id_tbl.last
2374: LOOP
2375: /**************************************************
2376: * Call to the Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format API
2377: * to Delete all the formats from the pa_plan_rl_formats
2378: * table. We are passing table elements
2379: **************************************************/
2380: Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format (

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

2373: FOR i IN l_res_format_id_tbl.first..l_res_format_id_tbl.last
2374: LOOP
2375: /**************************************************
2376: * Call to the Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format API
2377: * to Delete all the formats from the pa_plan_rl_formats
2378: * table. We are passing table elements
2379: **************************************************/
2380: Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format (
2381: P_Res_List_Id => P_res_list_id,

Line 2380: Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format (

2376: * Call to the Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format API
2377: * to Delete all the formats from the pa_plan_rl_formats
2378: * table. We are passing table elements
2379: **************************************************/
2380: Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format (
2381: P_Res_List_Id => P_res_list_id,
2382: P_Res_Format_Id => l_res_format_id_tbl(i),
2383: P_Plan_RL_Format_Id => l_plan_rl_format_id_tbl(i),
2384: X_Return_Status => l_return_status,

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

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);
2426: EXCEPTION
2427: WHEN NO_DATA_FOUND THEN
2428: l_exist_res_list := 'N';

Line 2495: * Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format

2491: /************************************************************
2492: * Procedure : Create_Plan_RL_Format
2493: * Description : This procedure is used the pass a Table of
2494: * Record, and call the
2495: * Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format
2496: * procedure, which would create the res formats.
2497: * The detailed information is in the spec.
2498: **************************************************************/
2499: Procedure Create_Plan_RL_Format(

Line 2564: Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format(

2560:
2561: End If;
2562: --End of bug 3675288.
2563:
2564: Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format(
2565: P_Res_List_Id =>P_Res_List_Id,
2566: P_Res_Format_Id =>L_Plan_RL_Format_Tbl(i).P_Res_Format_Id,
2567: X_Plan_RL_Format_Id =>X_Plan_RL_Format_Tbl(i).X_Plan_RL_Format_Id,
2568: X_Record_Version_Number =>

Line 2618: * Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format

2614: /************************************************************
2615: * Procedure : Delete_Plan_RL_Format
2616: * Description : This procedure is used the pass a Table of
2617: * Record, and call the
2618: * Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format
2619: * procedure, which would Delete the res formats.
2620: * The detailed information is in the spec.
2621: **************************************************************/
2622: Procedure Delete_Plan_RL_Format (

Line 2652: Pa_Plan_RL_Formats_pvt.Delete_Plan_RL_Format (

2648: ****************************************************************/
2649: FOR i IN 1..P_Plan_RL_Format_Tbl.COUNT
2650: LOOP
2651:
2652: Pa_Plan_RL_Formats_pvt.Delete_Plan_RL_Format (
2653: P_Res_List_Id =>P_Res_List_Id,
2654: P_Res_Format_Id =>L_Plan_RL_Format_Tbl(i).P_Res_Format_Id,
2655: P_Plan_RL_Format_Id =>Null,
2656: X_Return_Status =>X_Return_Status,

Line 2858: FROM pa_plan_rl_formats

2854: BEGIN
2855:
2856: SELECT 'Y'
2857: INTO l_format_exists
2858: FROM pa_plan_rl_formats
2859: WHERE resource_list_id = p_resource_list_id
2860: AND res_format_id = L_planning_resource_in_tbl(i).p_res_format_id;
2861:
2862: EXCEPTION