DBA Data[Home] [Help]

APPS.MSC_UPDATE_PLAN_OPTIONS_PK dependencies on MSC_PLANS

Line 14: UPDATE msc_plans

10:
11: BEGIN
12:
13:
14: UPDATE msc_plans
15: SET
16: data_start_date = SYSDATE,
17: data_completion_date = NULL,
18: last_update_date = SYSDATE,

Line 52: UPDATE msc_plans

48: arg_plan_id IN NUMBER,
49: arg_user_id IN NUMBER) IS
50: BEGIN
51:
52: UPDATE msc_plans
53: SET data_completion_date = SYSDATE,
54: last_update_date = SYSDATE,
55: last_updated_by = arg_user_id
56: WHERE plan_id = arg_plan_id;