[Home] [Help]
2514: 10,
2515: 100);
2516:
2517: FND_STATS.SET_TABLE_STATS('PA',
2518: 'PA_RES_MEMBER_ID_TEMP',
2519: 100,
2520: 10,
2521: 100);
2522: */
2525: -- Proper Fix for 4887312 *** RAMURTHY 03/01/06 02:33 pm ***
2526: -- It solves the issue above wrt commit by the FND_STATS.SET_TABLE_STATS call
2527: -- Bug 12533202: Replaced 'PA' by PJI_UTILS.GET_PA_SCHEMA_NAME
2528: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_MEMBERS_TEMP',100,10,100);
2529: PA_TASK_ASSIGNMENT_UTILS.set_table_stats(PJI_UTILS.GET_PA_SCHEMA_NAME,'PA_RES_MEMBER_ID_TEMP',100,10,100);
2530:
2531: -- End Bug fix 4887312
2532:
2533: /***********************************************
2535: * to be on the safe side.
2536: ***********************************************/
2537: DELETE FROM pa_res_members_temp;
2538:
2539: DELETE FROM pa_res_member_id_temp;
2540: /************************************************************
2541: * Created a script to create 2 tables in the DB
2542: * 1. pa_res_member_id_temp which would only hold the
2543: * resource_list_member_id
2538:
2539: DELETE FROM pa_res_member_id_temp;
2540: /************************************************************
2541: * Created a script to create 2 tables in the DB
2542: * 1. pa_res_member_id_temp which would only hold the
2543: * resource_list_member_id
2544: * 2. pa_res_members_temp which would hold the
2545: * resource_list_member_id and all the other attributes
2546: * which need to be defaulted
2546: * which need to be defaulted
2547: *************************************************************/
2548:
2549: /***************************************************************
2550: * First insert into the pa_res_member_id_temp table just the
2551: * resource_list_member_id which have been passed as IN param's
2552: **************************************************************/
2553: FOR i in p_resource_list_members.first..p_resource_list_members.last
2554: LOOP
2551: * resource_list_member_id which have been passed as IN param's
2552: **************************************************************/
2553: FOR i in p_resource_list_members.first..p_resource_list_members.last
2554: LOOP
2555: INSERT INTO pa_res_member_id_temp
2556: (resource_list_member_id,
2557: order_id)
2558: VALUES(p_resource_list_members(i),
2559: i);
2639: NULL ,
2640: NULL ,
2641: NULL ,
2642: NULL
2643: FROM pa_res_member_id_temp b,
2644: pa_resource_list_members a,
2645: pa_res_formats_b fmt,
2646: pa_res_types_b typ
2647: WHERE a.resource_list_member_id = b.resource_list_member_id
2755: * pa_res_members_temp and Bulk collect it into the OUT var's.
2756: *********************************************************************/
2757: /**********************************************************
2758: * Added an extra order ID join between the pa_res_members_temp
2759: * and pa_res_member_id_temp table to keep in sync.
2760: * Bug - 3473425
2761: **********************************************************/
2762: /*********************************************************
2763: * Bug - 3473324
2834: x_rate_expenditure_type ,
2835: x_rate_func_curr_code
2836: -- x_rate_incurred_by_org_id
2837: FROM pa_res_members_temp a,
2838: pa_res_member_id_temp b
2839: WHERE a.resource_list_member_id = b.resource_list_member_id
2840: AND a.order_id = b.order_id
2841: ORDER BY b.order_id;
2842:
2846: END IF;
2847:
2848: DELETE FROM pa_res_members_temp;
2849:
2850: DELETE FROM pa_res_member_id_temp;
2851:
2852: EXCEPTION
2853: WHEN l_exception THEN
2854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;