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 27: FROM pa_resource_list_members

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

Line 846: * to to the Insert Into PA_RESOURCE_LIST_MEMBERS.

842:
843: /***********************************************************
844: * Do a Check to determine the uniqueness of the resource
845: * in the Resource list. Only if it is Unique we need
846: * to to the Insert Into PA_RESOURCE_LIST_MEMBERS.
847: * If it is not Unique then we should display an error
848: * saying 'Planning resource already exists in this
849: * Planning resource list'
850: * If its = 'Y' dont insert. If it is = 'N' then insert.

Line 865: From pa_resource_list_members

861: **********************************************************/
862: BEGIN
863: Select 'Y'
864: Into l_unique_res_list
865: From pa_resource_list_members
866: Where resource_list_id = p_resource_list_id
867: And res_format_id = p_res_format_id
868: --Added the below 2 lines to check for the uniqueness
869: -- on a list/proj combination.

Line 936: * Insert Into Pa_resource_list_members

932: p_organization_id => l_organization_id,
933: p_expenditure_type => l_expenditure_type); --DJ
934:
935: /*************************************************
936: * Insert Into Pa_resource_list_members
937: ************************************************/
938: IF l_res_list_member_id IS NULL THEN
939: SELECT pa_resource_list_members_s.NEXTVAL
940: INTO l_res_list_member_id

Line 939: SELECT pa_resource_list_members_s.NEXTVAL

935: /*************************************************
936: * Insert Into Pa_resource_list_members
937: ************************************************/
938: IF l_res_list_member_id IS NULL THEN
939: SELECT pa_resource_list_members_s.NEXTVAL
940: INTO l_res_list_member_id
941: FROM dual;
942: END IF;
943:

Line 954: * pa_resource_list_members table.

950:
951: /********************************************
952: * Call to Pa_Planning_Resource_pkg.insert_row
953: * Procedure, which will insert into the
954: * pa_resource_list_members table.
955: ********************************************/
956: --Added for CBS bug13535688 & 13546557
957: /* l_expenditure_type:=p_expenditure_type;
958: Commented the above line for Bug13546557

Line 1075: UPDATE pa_resource_list_members

1071: * If the values for spread curve id, etc method code
1072: * and mfc cost type id are Not null then retain the same values
1073: * else use the derived values(from above).
1074: *****************************************************/
1075: UPDATE pa_resource_list_members
1076: SET spread_curve_id = DECODE(spread_curve_id,NULL,
1077: l_spread_curve_id, spread_curve_id),
1078: etc_method_code = DECODE(etc_method_code,NULL,
1079: l_etc_method_code, etc_method_code)

Line 1095: UPDATE pa_resource_list_members

1091: END;
1092:
1093: IF l_res_type_code IN ('BOM_EQUIPMENT','BOM_LABOR','INVENTORY_ITEM')
1094: THEN
1095: UPDATE pa_resource_list_members
1096: SET mfc_cost_type_id = DECODE(mfc_cost_type_id,NULL,
1097: l_mfc_cost_type_id, mfc_cost_type_id)
1098: WHERE resource_list_member_id = l_res_list_member_id;
1099: ELSE

Line 1100: UPDATE pa_resource_list_members

1096: SET mfc_cost_type_id = DECODE(mfc_cost_type_id,NULL,
1097: l_mfc_cost_type_id, mfc_cost_type_id)
1098: WHERE resource_list_member_id = l_res_list_member_id;
1099: ELSE
1100: UPDATE pa_resource_list_members
1101: SET mfc_cost_type_id = NULL
1102: WHERE resource_list_member_id = l_res_list_member_id;
1103: END IF;
1104:

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

1105: /**************************************************
1106: * If the p_resource_alias is Null then
1107: * we need to derive it by call to procedure
1108: * PA_PLANNING_RESOURCE_DEFAULTS. Get_Plan_Res_Combination
1109: * and then we need to update the table pa_resource_list_members
1110: * with the derived value.
1111: ***************************************************/
1112: IF p_resource_alias IS NULL
1113: THEN

Line 1162: UPDATE pa_resource_list_members

1158: -- Return;
1159: END IF;
1160:
1161: BEGIN
1162: UPDATE pa_resource_list_members
1163: SET alias = l_resource_alias
1164: WHERE resource_list_member_id = l_res_list_member_id;
1165: EXCEPTION
1166: WHEN OTHERS THEN

Line 1190: * the table PA_RESOURCE_LIST_MEMBERS

1186: * Validate and update attributes on an existing
1187: * planning resource for a resource list.
1188: * It first checks for the Uniqueness of the
1189: * resource list. If it is Unique then it updates
1190: * the table PA_RESOURCE_LIST_MEMBERS
1191: * with the values passed.
1192: ************************************/
1193: PROCEDURE Update_Planning_Resource
1194: (p_resource_list_id IN NUMBER,

Line 1268: FROM pa_resource_list_members

1264: x_return_status := FND_API.G_RET_STS_SUCCESS;
1265: BEGIN
1266: SELECT object_type,object_id
1267: INTO l_object_type,l_object_id
1268: FROM pa_resource_list_members
1269: WHERE resource_list_member_id = p_resource_list_member_id;
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1373: * pa_resource_list_members table.

1369: END IF;
1370:
1371: /************************************
1372: * If it is Unique we go ahead with the Update to
1373: * pa_resource_list_members table.
1374: * Update using the values passed.
1375: *****************************************/
1376:
1377: pa_res_list_members_pkg.update_row

Line 1467: FROM pa_resource_list_members

1463:
1464: BEGIN
1465: SELECT resource_list_id, migration_code
1466: INTO l_resource_list_id, l_migration_code
1467: FROM pa_resource_list_members
1468: WHERE resource_list_member_id = p_resource_list_member_id;
1469:
1470: EXCEPTION WHEN OTHERS THEN
1471: RETURN;

Line 1742: pa_resource_list_members a

1738: NULL ,
1739: a.resource_class_id ,
1740: a.res_format_id
1741: FROM pa_res_member_id_temp b,
1742: pa_resource_list_members a
1743: WHERE a.resource_list_member_id = b.resource_list_member_id;
1744:
1745: -- Updating the ORG ID column to be -1 for those RLM's whose formats
1746: -- don't exist on the destination list:

Line 1777: FROM pa_resource_list_members a,

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

Line 1866: SELECT pa_resource_list_members_s.NEXTVAL

1862:
1863: FOR i IN l_bulk_resource_list_member_id.first ..
1864: l_bulk_resource_list_member_id.last
1865: LOOP
1866: SELECT pa_resource_list_members_s.NEXTVAL
1867: INTO l_new_resource_list_member_id(i)
1868: FROM dual;
1869: END LOOP;
1870:

Line 1880: INSERT INTO PA_RESOURCE_LIST_MEMBERS

1876: --hr_utility.trace('INSIDE IF l_bulk_resource_list_member_id.count is ' || l_bulk_resource_list_member_id.count);
1877: FORALL k IN l_bulk_resource_list_member_id.first ..
1878: l_bulk_resource_list_member_id.last
1879:
1880: INSERT INTO PA_RESOURCE_LIST_MEMBERS
1881: ( RESOURCE_LIST_MEMBER_ID ,
1882: RESOURCE_LIST_ID ,
1883: RESOURCE_ID ,
1884: ALIAS ,

Line 2034: FROM pa_resource_list_members a

2030: SYSDATE ,
2031: SYSDATE ,
2032: FND_GLOBAL.USER_ID ,
2033: FND_GLOBAL.LOGIN_ID
2034: FROM pa_resource_list_members a
2035: WHERE a.resource_list_id = p_source_resource_list_id
2036: AND a.resource_list_member_id =
2037: l_bulk_resource_list_member_id(k);
2038: