APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_RES_MEMBER_ID_TEMP

Line 1646: 'PA_RES_MEMBER_ID_TEMP',

1642: 10,
1643: 100);
1644:
1645: FND_STATS.SET_TABLE_STATS('PA',
1646: 'PA_RES_MEMBER_ID_TEMP',
1647: 100,
1648: 10,
1649: 100);
1650: */

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

1651: -- Proper Fix for 4887312 *** RAMURTHY 03/01/06 02:33 pm ***
1652: -- It solves the issue above wrt commit by the FND_STATS.SET_TABLE_STATS call
1653:
1654: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBERS_TEMP',100,10,100);
1655: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBER_ID_TEMP',100,10,100);
1656:
1657: -- End Bug fix 4887312
1658: /***********************************************
1659: * Deleting from the temp tables in the beginning as well

Line 1664: DELETE FROM pa_res_member_id_temp;

1660: * to be on the safe side.
1661: ***********************************************/
1662: DELETE FROM pa_res_members_temp;
1663:
1664: DELETE FROM pa_res_member_id_temp;
1665: /*************************************************/
1666:
1667: -- Looping through the source Resource list member ID table
1668: -- and inserting the values to

Line 1669: -- the temp table pa_res_member_id_temp.

1665: /*************************************************/
1666:
1667: -- Looping through the source Resource list member ID table
1668: -- and inserting the values to
1669: -- the temp table pa_res_member_id_temp.
1670:
1671: IF p_src_res_list_member_id_tbl.count > 0 THEN
1672:
1673: FOR i IN p_src_res_list_member_id_tbl.first ..

Line 1677: INSERT INTO pa_res_member_id_temp

1673: FOR i IN p_src_res_list_member_id_tbl.first ..
1674: p_src_res_list_member_id_tbl.last
1675: LOOP
1676: --hr_utility.trace('p_src_res_list_member_id_tbl(i) IS : ' || p_src_res_list_member_id_tbl(i));
1677: INSERT INTO pa_res_member_id_temp
1678: (resource_list_member_id,
1679: order_id)
1680: VALUES(p_src_res_list_member_id_tbl(i),
1681: i);

Line 1741: FROM pa_res_member_id_temp b,

1737: a.revenue_category ,
1738: NULL ,
1739: a.resource_class_id ,
1740: a.res_format_id
1741: FROM pa_res_member_id_temp b,
1742: pa_resource_list_members a
1743: WHERE a.resource_list_member_id = b.resource_list_member_id;
1744:
1745: -- Updating the ORG ID column to be -1 for those RLM's whose formats

Line 2072: pa_res_member_id_temp b

2068:
2069: SELECT a.org_id
2070: BULK COLLECT INTO x_dest_res_list_member_id_tbl
2071: FROM pa_res_members_temp a,
2072: pa_res_member_id_temp b
2073: WHERE a.resource_list_member_id = b.resource_list_member_id
2074: AND a.order_id = b.order_id
2075: ORDER BY b.order_id;
2076:

Line 2085: DELETE FROM pa_res_member_id_temp;

2081: END IF;
2082: -- Clearing Temp tables
2083: DELETE FROM pa_res_members_temp;
2084:
2085: DELETE FROM pa_res_member_id_temp;
2086:
2087:
2088: EXCEPTION
2089: WHEN l_exception THEN