APPS.IEC_QUOTAUPDATE_PVT dependencies on IEC_G_LIST_RT_INFO

Line 13: FROM IEC_G_LIST_RT_INFO WHERE LIST_HEADER_ID = P_LIST_HEADER_ID

9: IS
10: l_rt_quota NUMBER;
11: CURSOR c_quota IS
12: SELECT nvl(QUOTA,0) QUOTA, RELEASE_STRATEGY, nvl(WORKING_QUOTA,0) WORKING_QUOTA
13: FROM IEC_G_LIST_RT_INFO WHERE LIST_HEADER_ID = P_LIST_HEADER_ID
14: for UPDATE OF WORKING_QUOTA;
15:
16: BEGIN
17:

Line 28: UPDATE IEC_G_LIST_RT_INFO SET

24: ELSE
25: l_rt_quota := v_quota.working_quota - P_QUOTA_USED;
26: END IF;
27: -- dbms_output.put_line('l_rt_quota='|| l_rt_quota );
28: UPDATE IEC_G_LIST_RT_INFO SET
29: WORKING_QUOTA = l_rt_quota WHERE CURRENT OF c_quota;
30: END IF;
31: END IF;
32: END LOOP;