DBA Data[Home] [Help]

APPS.IEC_QUOTAUPDATE_PVT dependencies on IEC_G_SUBSET_RT_INFO

Line 47: FROM IEC_G_SUBSET_RT_INFO WHERE LIST_SUBSET_ID = P_LIST_SUBSET_ID

43: l_quota NUMBER;
44: l_release_strategy VARCHAR2(30);
45: CURSOR c_quota IS
46: SELECT nvl(WORKING_QUOTA,0) WORKING_QUOTA
47: FROM IEC_G_SUBSET_RT_INFO WHERE LIST_SUBSET_ID = P_LIST_SUBSET_ID
48: for UPDATE OF WORKING_QUOTA;
49:
50: BEGIN
51:

Line 68: UPDATE IEC_G_SUBSET_RT_INFO SET

64: ELSE
65: l_rt_quota := v_quota.working_quota - P_QUOTA_USED;
66: END IF;
67:
68: UPDATE IEC_G_SUBSET_RT_INFO SET
69: WORKING_QUOTA = l_rt_quota WHERE CURRENT OF c_quota;
70: END LOOP;
71: END IF;
72: END IF;