APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RES_MEMBER_ID_TEMP

Line 2477: 'PA_RES_MEMBER_ID_TEMP',

2473: 10,
2474: 100);
2475:
2476: FND_STATS.SET_TABLE_STATS('PA',
2477: 'PA_RES_MEMBER_ID_TEMP',
2478: 100,
2479: 10,
2480: 100);
2481: */

Line 2488: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBER_ID_TEMP',100,10,100);

2484: -- Proper Fix for 4887312 *** RAMURTHY 03/01/06 02:33 pm ***
2485: -- It solves the issue above wrt commit by the FND_STATS.SET_TABLE_STATS call
2486:
2487: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBERS_TEMP',100,10,100);
2488: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBER_ID_TEMP',100,10,100);
2489:
2490: -- End Bug fix 4887312
2491:
2492: /***********************************************

Line 2498: DELETE FROM pa_res_member_id_temp;

2494: * to be on the safe side.
2495: ***********************************************/
2496: DELETE FROM pa_res_members_temp;
2497:
2498: DELETE FROM pa_res_member_id_temp;
2499: /************************************************************
2500: * Created a script to create 2 tables in the DB
2501: * 1. pa_res_member_id_temp which would only hold the
2502: * resource_list_member_id

Line 2501: * 1. pa_res_member_id_temp which would only hold the

2497:
2498: DELETE FROM pa_res_member_id_temp;
2499: /************************************************************
2500: * Created a script to create 2 tables in the DB
2501: * 1. pa_res_member_id_temp which would only hold the
2502: * resource_list_member_id
2503: * 2. pa_res_members_temp which would hold the
2504: * resource_list_member_id and all the other attributes
2505: * which need to be defaulted

Line 2509: * First insert into the pa_res_member_id_temp table just the

2505: * which need to be defaulted
2506: *************************************************************/
2507:
2508: /***************************************************************
2509: * First insert into the pa_res_member_id_temp table just the
2510: * resource_list_member_id which have been passed as IN param's
2511: **************************************************************/
2512: FOR i in p_resource_list_members.first..p_resource_list_members.last
2513: LOOP

Line 2514: INSERT INTO pa_res_member_id_temp

2510: * resource_list_member_id which have been passed as IN param's
2511: **************************************************************/
2512: FOR i in p_resource_list_members.first..p_resource_list_members.last
2513: LOOP
2514: INSERT INTO pa_res_member_id_temp
2515: (resource_list_member_id,
2516: order_id)
2517: VALUES(p_resource_list_members(i),
2518: i);

Line 2602: FROM pa_res_member_id_temp b,

2598: NULL ,
2599: NULL ,
2600: NULL ,
2601: NULL
2602: FROM pa_res_member_id_temp b,
2603: pa_resource_list_members a,
2604: pa_res_formats_b fmt,
2605: pa_res_types_b typ
2606: WHERE a.resource_list_member_id = b.resource_list_member_id

Line 2718: * and pa_res_member_id_temp table to keep in sync.

2714: * pa_res_members_temp and Bulk collect it into the OUT var's.
2715: *********************************************************************/
2716: /**********************************************************
2717: * Added an extra order ID join between the pa_res_members_temp
2718: * and pa_res_member_id_temp table to keep in sync.
2719: * Bug - 3473425
2720: **********************************************************/
2721: /*********************************************************
2722: * Bug - 3473324

Line 2797: pa_res_member_id_temp b

2793: x_rate_expenditure_type ,
2794: x_rate_func_curr_code
2795: -- x_rate_incurred_by_org_id
2796: FROM pa_res_members_temp a,
2797: pa_res_member_id_temp b
2798: WHERE a.resource_list_member_id = b.resource_list_member_id
2799: AND a.order_id = b.order_id
2800: ORDER BY b.order_id;
2801:

Line 2809: DELETE FROM pa_res_member_id_temp;

2805: END IF;
2806:
2807: DELETE FROM pa_res_members_temp;
2808:
2809: DELETE FROM pa_res_member_id_temp;
2810:
2811: EXCEPTION
2812: WHEN l_exception THEN
2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;