APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_USER_PREFERENCE_VALUES

Line 1608: FROM MSC_USER_PREFERENCE_VALUES

1604: l_rowlist tab_type;
1605:
1606: CURSOR c_pref(p_plan_id IN VARCHAR2) IS
1607: SELECT ROWID
1608: FROM MSC_USER_PREFERENCE_VALUES
1609: WHERE key IN ('ASCP_PLAN_ID','DRP_PLAN_ID')
1610: AND value = p_plan_id
1611: FOR UPDATE OF value NOWAIT;
1612:

Line 1640: UPDATE MSC_USER_PREFERENCE_VALUES

1636: FETCH c_pref BULK COLLECT INTO l_rowlist;
1637: CLOSE c_pref;
1638:
1639: FORALL I IN 1..l_rowlist.count
1640: UPDATE MSC_USER_PREFERENCE_VALUES
1641: SET VALUE=p_temp_plan_id
1642: WHERE ROWID=l_rowlist(I);
1643: EXIT;
1644: EXCEPTION