APPS.CN_CALC_SUB_QUOTAS_PKG dependencies on CN_CALC_SUB_QUOTAS_ALL

Line 143: UPDATE cn_calc_sub_quotas_all SET

139: ) IS
140:
141: BEGIN
142:
143: UPDATE cn_calc_sub_quotas_all SET
144: calc_sub_quota_id = p_calc_sub_quota_id,
145: calc_sub_batch_id = p_calc_sub_batch_id,
146: quota_id = p_quota_id
147: ,attribute_category = p_attribute_category

Line 175: DELETE cn_calc_sub_quotas_all

171:
172: Procedure delete_row ( p_calc_sub_quota_id NUMBER ) IS
173:
174: BEGIN
175: DELETE cn_calc_sub_quotas_all
176: WHERE calc_sub_quota_id = p_calc_sub_quota_id;
177:
178: IF (sql%notfound) THEN
179: raise no_data_found;

Line 209: SELECT * FROM cn_calc_sub_quotas_all

205: P_LAST_UPDATE_DATE DATE ,
206: P_LAST_UPDATED_BY NUMBER
207: ) IS
208: CURSOR C IS
209: SELECT * FROM cn_calc_sub_quotas_all
210: WHERE calc_sub_quota_id = p_calc_sub_quota_id
211: FOR UPDATE OF calc_sub_quota_id NOWAIT;
212:
213: Recinfo C%ROWTYPE;