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_PLANNING_RESOURCE_PVT dependencies on PA_RES_MEMBERS_TEMP

Line 1532: 'PA_RES_MEMBERS_TEMP',

1528: -- ***** TEMP fix - proper fix will be done later
1529: -- Bug 4887312
1530: /*
1531: FND_STATS.SET_TABLE_STATS('PA',
1532: 'PA_RES_MEMBERS_TEMP',
1533: 100,
1534: 10,
1535: 100);
1536:

Line 1546: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBERS_TEMP',100,10,100);

1542: */
1543: -- Proper Fix for 4887312 *** RAMURTHY 03/01/06 02:33 pm ***
1544: -- It solves the issue above wrt commit by the FND_STATS.SET_TABLE_STATS call
1545:
1546: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBERS_TEMP',100,10,100);
1547: PA_TASK_ASSIGNMENT_UTILS.set_table_stats('PA','PA_RES_MEMBER_ID_TEMP',100,10,100);
1548:
1549: -- End Bug fix 4887312
1550: /***********************************************

Line 1554: DELETE FROM pa_res_members_temp;

1550: /***********************************************
1551: * Deleting from the temp tables in the beginning as well
1552: * to be on the safe side.
1553: ***********************************************/
1554: DELETE FROM pa_res_members_temp;
1555:
1556: DELETE FROM pa_res_member_id_temp;
1557: /*************************************************/
1558:

Line 1583: INSERT INTO pa_res_members_temp

1579: -- with values for corresponding
1580: -- RLM's which has a match in the destination list.
1581:
1582: --hr_utility.trace('before temp insert');
1583: INSERT INTO pa_res_members_temp
1584: (resource_list_member_id ,
1585: order_id ,
1586: person_id ,
1587: project_role_id ,

Line 1640: UPDATE pa_res_members_temp rlmtmp

1636:
1637: -- Updating the ORG ID column to be -1 for those RLM's whose formats
1638: -- don't exist on the destination list:
1639:
1640: UPDATE pa_res_members_temp rlmtmp
1641: SET org_id = -1
1642: WHERE NOT EXISTS (
1643: SELECT 'Y'
1644: FROM Pa_Plan_rl_formats

Line 1670: pa_res_members_temp b

1666: BULK COLLECT INTO l_bulk_resource_list_member_id,
1667: l_bulk_enabled_flag,
1668: l_old_resource_list_member_id
1669: FROM pa_resource_list_members a,
1670: pa_res_members_temp b
1671: WHERE a.resource_list_id = p_destination_resource_list_id
1672: -- To process only those RLM which has corr formats as that of source RL.
1673: AND b.org_id IS NULL
1674: AND a.res_format_id = b.spread_curve_id

Line 1721: UPDATE pa_res_members_temp

1717: IF l_bulk_resource_list_member_id.count > 0 THEN
1718:
1719: FORALL j IN l_bulk_resource_list_member_id.first ..
1720: l_bulk_resource_list_member_id.last
1721: UPDATE pa_res_members_temp
1722: SET org_id = DECODE(l_bulk_enabled_flag(j), 'Y' ,
1723: l_bulk_resource_list_member_id(j),-1)
1724: WHERE resource_list_member_id = l_old_resource_list_member_id(j);
1725:

Line 1728: -- So now, in pa_res_members_temp, All the source RLM's which have a match,

1724: WHERE resource_list_member_id = l_old_resource_list_member_id(j);
1725:
1726: END IF;
1727:
1728: -- So now, in pa_res_members_temp, All the source RLM's which have a match,
1729: -- have ORG_ID NOT NULL - if it is enabled, it is the RLM ID of the
1730: -- destination RLM; if it is not enabled it is -1, a dummy value which
1731: -- is converted to NULL later.
1732:

Line 1733: -- There are now records in pa_res_members_temp where ORG_ID

1729: -- have ORG_ID NOT NULL - if it is enabled, it is the RLM ID of the
1730: -- destination RLM; if it is not enabled it is -1, a dummy value which
1731: -- is converted to NULL later.
1732:
1733: -- There are now records in pa_res_members_temp where ORG_ID
1734: -- is NULL - these are source RLM's which don't have a match.
1735: -- They are created
1736: -- if the list is not centrally controlled.
1737:

Line 1746: FROM pa_res_members_temp

1742: l_bulk_resource_list_member_id.delete; -- initializing the table
1743:
1744: SELECT DISTINCT resource_list_member_id
1745: BULK COLLECT INTO l_bulk_resource_list_member_id
1746: FROM pa_res_members_temp
1747: WHERE org_id IS NULL;
1748:
1749: l_new_resource_list_member_id := SYSTEM.PA_NUM_TBL_TYPE();
1750: l_new_resource_list_member_id.extend(

Line 1942: UPDATE pa_res_members_temp

1938: IF l_bulk_resource_list_member_id.count > 0 THEN
1939:
1940: FORALL x IN l_bulk_resource_list_member_id.first ..
1941: l_bulk_resource_list_member_id.last
1942: UPDATE pa_res_members_temp
1943: SET org_id = l_new_resource_list_member_id(x)
1944: WHERE resource_list_member_id = l_bulk_resource_list_member_id(x);
1945:
1946: END IF;

Line 1952: UPDATE pa_res_members_temp

1948: END IF; -- (l_control_flag <> 'Y')
1949:
1950: -- Converting the -1's to NULL
1951:
1952: UPDATE pa_res_members_temp
1953: SET org_id = NULL
1954: WHERE org_id = -1;
1955:
1956: -- Now, each record in the temp table has the value for ORG_ID that we

Line 1963: FROM pa_res_members_temp a,

1959: -- Populating the out table.
1960:
1961: SELECT a.org_id
1962: BULK COLLECT INTO x_dest_res_list_member_id_tbl
1963: FROM pa_res_members_temp a,
1964: pa_res_member_id_temp b
1965: WHERE a.resource_list_member_id = b.resource_list_member_id
1966: AND a.order_id = b.order_id
1967: ORDER BY b.order_id;

Line 1975: DELETE FROM pa_res_members_temp;

1971: THEN
1972: RAISE l_exception;
1973: END IF;
1974: -- Clearing Temp tables
1975: DELETE FROM pa_res_members_temp;
1976:
1977: DELETE FROM pa_res_member_id_temp;
1978:
1979: