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_NUM_TBL_TYPE

Line 1574: p_src_res_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

1570:
1571: PROCEDURE Copy_Planning_Resources(
1572: p_source_resource_list_id IN Number,
1573: p_destination_resource_list_id IN Number,
1574: p_src_res_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1575: x_dest_res_list_member_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
1576: p_destination_project_id IN Number DEFAULT NULL)
1577: IS
1578:

Line 1575: x_dest_res_list_member_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

1571: PROCEDURE Copy_Planning_Resources(
1572: p_source_resource_list_id IN Number,
1573: p_destination_resource_list_id IN Number,
1574: p_src_res_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1575: x_dest_res_list_member_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
1576: p_destination_project_id IN Number DEFAULT NULL)
1577: IS
1578:
1579: /**********************************

Line 1586: l_bulk_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;

1582: l_control_flag Varchar2(1);
1583: l_object_id Number;
1584: l_object_type VARCHAR2(30);
1585: l_exception EXCEPTION;
1586: l_bulk_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1587: l_bulk_enabled_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
1588: l_old_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1589: l_new_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1590: l_last_analyzed all_tables.last_analyzed%TYPE;

Line 1588: l_old_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;

1584: l_object_type VARCHAR2(30);
1585: l_exception EXCEPTION;
1586: l_bulk_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1587: l_bulk_enabled_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
1588: l_old_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1589: l_new_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1590: l_last_analyzed all_tables.last_analyzed%TYPE;
1591: l_pa_schema VARCHAR2(30);
1592: BEGIN

Line 1589: l_new_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;

1585: l_exception EXCEPTION;
1586: l_bulk_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1587: l_bulk_enabled_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
1588: l_old_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1589: l_new_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1590: l_last_analyzed all_tables.last_analyzed%TYPE;
1591: l_pa_schema VARCHAR2(30);
1592: BEGIN
1593:

Line 1599: x_dest_res_list_member_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

1595: --hr_utility.trace('START');
1596: --hr_utility.trace('p_source_resource_list_id IS : ' || p_source_resource_list_id);
1597: --hr_utility.trace('p_destination_resource_list_id IS : ' || p_destination_resource_list_id);
1598: --hr_utility.trace('p_destination_project_id IS : ' || p_destination_project_id);
1599: x_dest_res_list_member_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
1600:
1601: /*******************************************
1602: * If no resource list member ID's passed then
1603: * Just Return without doing anything.

Line 1857: l_new_resource_list_member_id := SYSTEM.PA_NUM_TBL_TYPE();

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(
1859: l_bulk_resource_list_member_id.count);
1860:
1861: IF l_bulk_resource_list_member_id.count > 0 THEN