APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_PLAN_SCHEDULES

Line 1581: Update MSC_PLAN_SCHEDULES

1577:
1578: exception when no_data_found then
1579: null;
1580: end ;
1581: Update MSC_PLAN_SCHEDULES
1582: set last_updated_by = v_temp_plan_name_cur.last_updated_by,
1583: last_update_date = v_temp_plan_name_cur.last_update_date,
1584: last_update_login = v_temp_plan_name_cur.last_update_login,
1585: request_id = v_temp_plan_name_cur.request_id,

Line 1618: FROM MSC_PLAN_SCHEDULES

1614: CURSOR c_schedules(p_designator_id IN NUMBER,
1615: p_organization_id IN NUMBER,
1616: p_sr_instance_id IN NUMBER) IS
1617: SELECT ROWID
1618: FROM MSC_PLAN_SCHEDULES
1619: WHERE input_schedule_id = p_designator_id
1620: --AND organization_id = p_organization_id
1621: --AND sr_instance_id = p_sr_instance_id
1622: FOR UPDATE OF input_schedule_id NOWAIT;

Line 1678: Update MSC_PLAN_SCHEDULES

1674: FETCH c_schedules BULK COLLECT INTO l_rowlist;
1675: CLOSE c_schedules;
1676:
1677: FORALL I IN 1..l_rowlist.count
1678: Update MSC_PLAN_SCHEDULES
1679: SET input_schedule_id = v_temp_desig_cur.designator_id
1680: WHERE ROWID=l_rowlist(I);
1681: EXIT;
1682: EXCEPTION