APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_NUM_TBL_TYPE

Line 1466: p_src_res_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

1462:
1463: PROCEDURE Copy_Planning_Resources(
1464: p_source_resource_list_id IN Number,
1465: p_destination_resource_list_id IN Number,
1466: p_src_res_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1467: x_dest_res_list_member_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
1468: p_destination_project_id IN Number DEFAULT NULL)
1469: IS
1470:

Line 1467: x_dest_res_list_member_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

1463: PROCEDURE Copy_Planning_Resources(
1464: p_source_resource_list_id IN Number,
1465: p_destination_resource_list_id IN Number,
1466: p_src_res_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1467: x_dest_res_list_member_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
1468: p_destination_project_id IN Number DEFAULT NULL)
1469: IS
1470:
1471: /**********************************

Line 1478: l_bulk_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;

1474: l_control_flag Varchar2(1);
1475: l_object_id Number;
1476: l_object_type VARCHAR2(30);
1477: l_exception EXCEPTION;
1478: l_bulk_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1479: l_bulk_enabled_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
1480: l_old_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1481: l_new_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1482: l_last_analyzed all_tables.last_analyzed%TYPE;

Line 1480: l_old_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;

1476: l_object_type VARCHAR2(30);
1477: l_exception EXCEPTION;
1478: l_bulk_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1479: l_bulk_enabled_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
1480: l_old_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1481: l_new_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1482: l_last_analyzed all_tables.last_analyzed%TYPE;
1483: l_pa_schema VARCHAR2(30);
1484: BEGIN

Line 1481: l_new_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;

1477: l_exception EXCEPTION;
1478: l_bulk_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1479: l_bulk_enabled_flag SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
1480: l_old_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1481: l_new_resource_list_member_id SYSTEM.PA_NUM_TBL_TYPE;
1482: l_last_analyzed all_tables.last_analyzed%TYPE;
1483: l_pa_schema VARCHAR2(30);
1484: BEGIN
1485:

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

1487: --hr_utility.trace('START');
1488: --hr_utility.trace('p_source_resource_list_id IS : ' || p_source_resource_list_id);
1489: --hr_utility.trace('p_destination_resource_list_id IS : ' || p_destination_resource_list_id);
1490: --hr_utility.trace('p_destination_project_id IS : ' || p_destination_project_id);
1491: x_dest_res_list_member_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
1492:
1493: /*******************************************
1494: * If no resource list member ID's passed then
1495: * Just Return without doing anything.

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

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(
1751: l_bulk_resource_list_member_id.count);
1752:
1753: IF l_bulk_resource_list_member_id.count > 0 THEN