DBA Data[Home] [Help]

APPS.MST_LAUNCH_PLAN_PKG dependencies on MST_PLANS

Line 45: FROM mst_plans

41: CURSOR C1(p_plan_id in number) IS
42: SELECT
43: Plan_Type, request_id, plan_completion_date,
44: compile_designator,audit_request_id
45: FROM mst_plans
46: WHERE plan_id = p_plan_id;
47:
48: v_rec_c1 c1%rowtype;
49:

Line 151: UPDATE mst_plans

147: lReUseFiles, -- Reuse set up files
148: lAuditMode -- audit mode
149: );
150:
151: UPDATE mst_plans
152: SET request_id = var_snapshot_req_id
153: WHERE plan_id = v_plan_id;
154:
155: COMMIT;