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 1640: 'PA_RES_MEMBERS_TEMP',

1636: -- ***** TEMP fix - proper fix will be done later
1637: -- Bug 4887312
1638: /*
1639: FND_STATS.SET_TABLE_STATS('PA',
1640: 'PA_RES_MEMBERS_TEMP',
1641: 100,
1642: 10,
1643: 100);
1644:

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

1650: */
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: /***********************************************

Line 1662: DELETE FROM pa_res_members_temp;

1658: /***********************************************
1659: * Deleting from the temp tables in the beginning as well
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:

Line 1691: INSERT INTO pa_res_members_temp

1687: -- with values for corresponding
1688: -- RLM's which has a match in the destination list.
1689:
1690: --hr_utility.trace('before temp insert');
1691: INSERT INTO pa_res_members_temp
1692: (resource_list_member_id ,
1693: order_id ,
1694: person_id ,
1695: project_role_id ,

Line 1748: UPDATE pa_res_members_temp rlmtmp

1744:
1745: -- Updating the ORG ID column to be -1 for those RLM's whose formats
1746: -- don't exist on the destination list:
1747:
1748: UPDATE pa_res_members_temp rlmtmp
1749: SET org_id = -1
1750: WHERE NOT EXISTS (
1751: SELECT 'Y'
1752: FROM Pa_Plan_rl_formats

Line 1778: pa_res_members_temp b

1774: BULK COLLECT INTO l_bulk_resource_list_member_id,
1775: l_bulk_enabled_flag,
1776: l_old_resource_list_member_id
1777: FROM pa_resource_list_members a,
1778: pa_res_members_temp b
1779: WHERE a.resource_list_id = p_destination_resource_list_id
1780: -- To process only those RLM which has corr formats as that of source RL.
1781: AND b.org_id IS NULL
1782: AND a.res_format_id = b.spread_curve_id

Line 1829: UPDATE pa_res_members_temp

1825: IF l_bulk_resource_list_member_id.count > 0 THEN
1826:
1827: FORALL j IN l_bulk_resource_list_member_id.first ..
1828: l_bulk_resource_list_member_id.last
1829: UPDATE pa_res_members_temp
1830: SET org_id = DECODE(l_bulk_enabled_flag(j), 'Y' ,
1831: l_bulk_resource_list_member_id(j),-1)
1832: WHERE resource_list_member_id = l_old_resource_list_member_id(j);
1833:

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

1832: WHERE resource_list_member_id = l_old_resource_list_member_id(j);
1833:
1834: END IF;
1835:
1836: -- So now, in pa_res_members_temp, All the source RLM's which have a match,
1837: -- have ORG_ID NOT NULL - if it is enabled, it is the RLM ID of the
1838: -- destination RLM; if it is not enabled it is -1, a dummy value which
1839: -- is converted to NULL later.
1840:

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

1837: -- have ORG_ID NOT NULL - if it is enabled, it is the RLM ID of the
1838: -- destination RLM; if it is not enabled it is -1, a dummy value which
1839: -- is converted to NULL later.
1840:
1841: -- There are now records in pa_res_members_temp where ORG_ID
1842: -- is NULL - these are source RLM's which don't have a match.
1843: -- They are created
1844: -- if the list is not centrally controlled.
1845:

Line 1854: FROM pa_res_members_temp

1850: l_bulk_resource_list_member_id.delete; -- initializing the table
1851:
1852: SELECT DISTINCT resource_list_member_id
1853: BULK COLLECT INTO l_bulk_resource_list_member_id
1854: FROM pa_res_members_temp
1855: WHERE org_id IS NULL;
1856:
1857: l_new_resource_list_member_id := SYSTEM.PA_NUM_TBL_TYPE();
1858: l_new_resource_list_member_id.extend(

Line 2050: UPDATE pa_res_members_temp

2046: IF l_bulk_resource_list_member_id.count > 0 THEN
2047:
2048: FORALL x IN l_bulk_resource_list_member_id.first ..
2049: l_bulk_resource_list_member_id.last
2050: UPDATE pa_res_members_temp
2051: SET org_id = l_new_resource_list_member_id(x)
2052: WHERE resource_list_member_id = l_bulk_resource_list_member_id(x);
2053:
2054: END IF;

Line 2060: UPDATE pa_res_members_temp

2056: END IF; -- (l_control_flag <> 'Y')
2057:
2058: -- Converting the -1's to NULL
2059:
2060: UPDATE pa_res_members_temp
2061: SET org_id = NULL
2062: WHERE org_id = -1;
2063:
2064: -- Now, each record in the temp table has the value for ORG_ID that we

Line 2071: FROM pa_res_members_temp a,

2067: -- Populating the out table.
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;

Line 2083: DELETE FROM pa_res_members_temp;

2079: THEN
2080: RAISE l_exception;
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: