APPS.MRP_UPDATE_PLAN_OPTIONS_PK dependencies on MRP_PLANS

Line 17: FROM mrp_plans

13: BEGIN
14:
15: SELECT NVL(organization_selection, SINGLE_ORG)
16: INTO var_org_selection
17: FROM mrp_plans
18: WHERE organization_id = arg_org_id
19: AND compile_designator = arg_compile_desig;
20:
21: IF var_org_selection = SINGLE_ORG THEN

Line 23: UPDATE mrp_plans

19: AND compile_designator = arg_compile_desig;
20:
21: IF var_org_selection = SINGLE_ORG THEN
22:
23: UPDATE mrp_plans
24: SET explosion_start_date = SYSDATE,
25: explosion_completion_date = SYSDATE,
26: data_start_date = SYSDATE,
27: data_completion_date = NULL,

Line 56: UPDATE mrp_plans

52: COMMIT;
53:
54: ELSE
55:
56: UPDATE mrp_plans
57: SET explosion_start_date = SYSDATE,
58: explosion_completion_date = SYSDATE,
59: data_start_date = SYSDATE,
60: data_completion_date = NULL,

Line 215: UPDATE mrp_plans

211: arg_compile_desig IN VARCHAR2) IS
212: var_org_selection INTEGER;
213: BEGIN
214:
215: UPDATE mrp_plans
216: SET data_completion_date = SYSDATE,
217: update_bom = SYS_NO,
218: last_update_date = SYSDATE,
219: last_updated_by = arg_user_id

Line 225: FROM mrp_plans

221: AND compile_designator = arg_compile_desig;
222:
223: SELECT NVL(organization_selection, SINGLE_ORG)
224: INTO var_org_selection
225: FROM mrp_plans
226: WHERE organization_id = arg_org_id
227: AND compile_designator = arg_compile_desig;
228:
229: if var_org_selection <> SINGLE_ORG