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_RESOURCE_LIST_MEMBERS

Line 25: FROM pa_resource_list_members

21:
22: BEGIN
23: SELECT 'N'
24: INTO l_check_unique_res
25: FROM pa_resource_list_members
26: WHERE resource_list_id = p_resource_list_id
27: AND alias = p_resource_alias
28: AND object_type = p_object_type
29: AND object_id = p_object_id

Line 758: * to to the Insert Into PA_RESOURCE_LIST_MEMBERS.

754:
755: /***********************************************************
756: * Do a Check to determine the uniqueness of the resource
757: * in the Resource list. Only if it is Unique we need
758: * to to the Insert Into PA_RESOURCE_LIST_MEMBERS.
759: * If it is not Unique then we should display an error
760: * saying 'Planning resource already exists in this
761: * Planning resource list'
762: * If its = 'Y' dont insert. If it is = 'N' then insert.

Line 777: From pa_resource_list_members

773: **********************************************************/
774: BEGIN
775: Select 'Y'
776: Into l_unique_res_list
777: From pa_resource_list_members
778: Where resource_list_id = p_resource_list_id
779: And res_format_id = p_res_format_id
780: --Added the below 2 lines to check for the uniqueness
781: -- on a list/proj combination.

Line 845: * Insert Into Pa_resource_list_members

841: p_organization_id => l_organization_id,
842: p_expenditure_type => l_expenditure_type);
843:
844: /*************************************************
845: * Insert Into Pa_resource_list_members
846: ************************************************/
847: IF l_res_list_member_id IS NULL THEN
848: SELECT pa_resource_list_members_s.NEXTVAL
849: INTO l_res_list_member_id

Line 848: SELECT pa_resource_list_members_s.NEXTVAL

844: /*************************************************
845: * Insert Into Pa_resource_list_members
846: ************************************************/
847: IF l_res_list_member_id IS NULL THEN
848: SELECT pa_resource_list_members_s.NEXTVAL
849: INTO l_res_list_member_id
850: FROM dual;
851: END IF;
852:

Line 863: * pa_resource_list_members table.

859:
860: /********************************************
861: * Call to Pa_Planning_Resource_pkg.insert_row
862: * Procedure, which will insert into the
863: * pa_resource_list_members table.
864: ********************************************/
865:
866: pa_res_list_members_pkg.insert_row
867: (p_resource_list_member_id => l_res_list_member_id,

Line 972: UPDATE pa_resource_list_members

968: * If the values for spread curve id, etc method code
969: * and mfc cost type id are Not null then retain the same values
970: * else use the derived values(from above).
971: *****************************************************/
972: UPDATE pa_resource_list_members
973: SET spread_curve_id = DECODE(spread_curve_id,NULL,
974: l_spread_curve_id, spread_curve_id),
975: etc_method_code = DECODE(etc_method_code,NULL,
976: l_etc_method_code, etc_method_code)

Line 992: UPDATE pa_resource_list_members

988: END;
989:
990: IF l_res_type_code IN ('BOM_EQUIPMENT','BOM_LABOR','INVENTORY_ITEM')
991: THEN
992: UPDATE pa_resource_list_members
993: SET mfc_cost_type_id = DECODE(mfc_cost_type_id,NULL,
994: l_mfc_cost_type_id, mfc_cost_type_id)
995: WHERE resource_list_member_id = l_res_list_member_id;
996: ELSE

Line 997: UPDATE pa_resource_list_members

993: SET mfc_cost_type_id = DECODE(mfc_cost_type_id,NULL,
994: l_mfc_cost_type_id, mfc_cost_type_id)
995: WHERE resource_list_member_id = l_res_list_member_id;
996: ELSE
997: UPDATE pa_resource_list_members
998: SET mfc_cost_type_id = NULL
999: WHERE resource_list_member_id = l_res_list_member_id;
1000: END IF;
1001:

Line 1006: * and then we need to update the table pa_resource_list_members

1002: /**************************************************
1003: * If the p_resource_alias is Null then
1004: * we need to derive it by call to procedure
1005: * PA_PLANNING_RESOURCE_DEFAULTS. Get_Plan_Res_Combination
1006: * and then we need to update the table pa_resource_list_members
1007: * with the derived value.
1008: ***************************************************/
1009: IF p_resource_alias IS NULL
1010: THEN

Line 1059: UPDATE pa_resource_list_members

1055: -- Return;
1056: END IF;
1057:
1058: BEGIN
1059: UPDATE pa_resource_list_members
1060: SET alias = l_resource_alias
1061: WHERE resource_list_member_id = l_res_list_member_id;
1062: EXCEPTION
1063: WHEN OTHERS THEN

Line 1084: * the table PA_RESOURCE_LIST_MEMBERS

1080: * Validate and update attributes on an existing
1081: * planning resource for a resource list.
1082: * It first checks for the Uniqueness of the
1083: * resource list. If it is Unique then it updates
1084: * the table PA_RESOURCE_LIST_MEMBERS
1085: * with the values passed.
1086: ************************************/
1087: PROCEDURE Update_Planning_Resource
1088: (p_resource_list_id IN NUMBER,

Line 1161: FROM pa_resource_list_members

1157: x_return_status := FND_API.G_RET_STS_SUCCESS;
1158: BEGIN
1159: SELECT object_type,object_id
1160: INTO l_object_type,l_object_id
1161: FROM pa_resource_list_members
1162: WHERE resource_list_member_id = p_resource_list_member_id;
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1266: * pa_resource_list_members table.

1262: END IF;
1263:
1264: /************************************
1265: * If it is Unique we go ahead with the Update to
1266: * pa_resource_list_members table.
1267: * Update using the values passed.
1268: *****************************************/
1269:
1270: pa_res_list_members_pkg.update_row

Line 1359: FROM pa_resource_list_members

1355:
1356: BEGIN
1357: SELECT resource_list_id, migration_code
1358: INTO l_resource_list_id, l_migration_code
1359: FROM pa_resource_list_members
1360: WHERE resource_list_member_id = p_resource_list_member_id;
1361:
1362: EXCEPTION WHEN OTHERS THEN
1363: RETURN;

Line 1634: pa_resource_list_members a

1630: NULL ,
1631: a.resource_class_id ,
1632: a.res_format_id
1633: FROM pa_res_member_id_temp b,
1634: pa_resource_list_members a
1635: WHERE a.resource_list_member_id = b.resource_list_member_id;
1636:
1637: -- Updating the ORG ID column to be -1 for those RLM's whose formats
1638: -- don't exist on the destination list:

Line 1669: FROM pa_resource_list_members a,

1665: b.resource_list_member_id -- matching rlm on source list
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

Line 1758: SELECT pa_resource_list_members_s.NEXTVAL

1754:
1755: FOR i IN l_bulk_resource_list_member_id.first ..
1756: l_bulk_resource_list_member_id.last
1757: LOOP
1758: SELECT pa_resource_list_members_s.NEXTVAL
1759: INTO l_new_resource_list_member_id(i)
1760: FROM dual;
1761: END LOOP;
1762:

Line 1772: INSERT INTO PA_RESOURCE_LIST_MEMBERS

1768: --hr_utility.trace('INSIDE IF l_bulk_resource_list_member_id.count is ' || l_bulk_resource_list_member_id.count);
1769: FORALL k IN l_bulk_resource_list_member_id.first ..
1770: l_bulk_resource_list_member_id.last
1771:
1772: INSERT INTO PA_RESOURCE_LIST_MEMBERS
1773: ( RESOURCE_LIST_MEMBER_ID ,
1774: RESOURCE_LIST_ID ,
1775: RESOURCE_ID ,
1776: ALIAS ,

Line 1926: FROM pa_resource_list_members a

1922: SYSDATE ,
1923: SYSDATE ,
1924: FND_GLOBAL.USER_ID ,
1925: FND_GLOBAL.LOGIN_ID
1926: FROM pa_resource_list_members a
1927: WHERE a.resource_list_id = p_source_resource_list_id
1928: AND a.resource_list_member_id =
1929: l_bulk_resource_list_member_id(k);
1930: