APPS.MRP_UPDATE_RESOURCE dependencies on CRP_AVAILABLE_RESOURCES

Line 164: FROM CRP_AVAILABLE_RESOURCES

160: LAST_UPDATED_BY,
161: CREATION_DATE,
162: CREATED_BY,
163: LAST_UPDATE_LOGIN
164: FROM CRP_AVAILABLE_RESOURCES
165: WHERE (compile_designator=g_compile_designator)
166: AND (organization_id = g_org_id)
167: AND ( (line_id = g_line_id)
168: OR ( (line_id IS NULL) AND (g_line_id IS NULL)))

Line 197: -- re-query data from crp_available_resources

193: g_line_id :=0;
194: g_resource_id :=0;
195:
196: -- load the simulation changes, if there are changes then
197: -- re-query data from crp_available_resources
198:
199: OPEN C_BRC;
200: LOOP
201: FETCH C_BRC INTO g_change_rec;

Line 272: -- re-query data from crp_available_resources

268: g_resource_id :=0;
269:
270:
271: -- load from mrp_form_query for the changes, if the resource changes
272: -- re-query data from crp_available_resources
273:
274: OPEN C_MFQ;
275: LOOP
276: FETCH C_MFQ INTO g_change_rec;

Line 340: -- load from crp_available_resources for all the records

336: ---------------------------------------------------------------------
337: PROCEDURE initialize_table IS
338: BEGIN
339:
340: -- load from crp_available_resources for all the records
341: -- related to the same resource
342: j :=0;
343: g_res_tab.delete;
344: OPEN C_CAR;

Line 916: --to update crp_available_resources table

912: END calculate_change;
913:
914:
915: ------------------------------------------------------------------------
916: --to update crp_available_resources table
917: -----------------------------------------------------------------------------
918: PROCEDURE update_table IS
919: m INTEGER;
920: BEGIN

Line 922: delete crp_available_resources

918: PROCEDURE update_table IS
919: m INTEGER;
920: BEGIN
921: if g_resource_exist then
922: delete crp_available_resources
923: where compile_designator = g_compile_designator
924: and organization_id = g_org_id
925: AND ( (line_id = g_line_id)
926: OR ( (line_id IS NULL) AND (g_line_id IS NULL)))

Line 940: INSERT INTO crp_available_resources

936: IF (g_res_tab(m).resource_hours > 0 AND
937: g_res_tab(m).resource_units > 0) OR
938: g_res_tab(m).max_rate >0 THEN
939:
940: INSERT INTO crp_available_resources
941: (compile_designator,
942: organization_id,
943: line_id,
944: department_id,