APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_PLAN_SCHEDULES

Line 1466: Update MSC_PLAN_SCHEDULES

1462: program_id = v_temp_plan_name_cur.program_id,
1463: program_update_date = v_temp_plan_name_cur.program_update_date
1464: Where plan_id = p_temp_plan_id;
1465:
1466: Update MSC_PLAN_SCHEDULES
1467: set last_updated_by = v_temp_plan_name_cur.last_updated_by,
1468: last_update_date = v_temp_plan_name_cur.last_update_date,
1469: last_update_login = v_temp_plan_name_cur.last_update_login,
1470: request_id = v_temp_plan_name_cur.request_id,

Line 1503: FROM MSC_PLAN_SCHEDULES

1499: CURSOR c_schedules(p_designator_id IN NUMBER,
1500: p_organization_id IN NUMBER,
1501: p_sr_instance_id IN NUMBER) IS
1502: SELECT ROWID
1503: FROM MSC_PLAN_SCHEDULES
1504: WHERE input_schedule_id = p_designator_id
1505: AND organization_id = p_organization_id
1506: AND sr_instance_id = p_sr_instance_id
1507: FOR UPDATE OF input_schedule_id NOWAIT;

Line 1563: Update MSC_PLAN_SCHEDULES

1559: FETCH c_schedules BULK COLLECT INTO l_rowlist;
1560: CLOSE c_schedules;
1561:
1562: FORALL I IN 1..l_rowlist.count
1563: Update MSC_PLAN_SCHEDULES
1564: SET input_schedule_id = v_temp_desig_cur.designator_id
1565: WHERE ROWID=l_rowlist(I);
1566: EXIT;
1567: EXCEPTION