19: x_period_quota_id IN OUT NOCOPY NUMBER
20: )
21: IS
22: BEGIN
23: SELECT cn_period_quotas_s.NEXTVAL
24: INTO x_period_quota_id
25: FROM DUAL;
26: END get_uid;
27:
172: )
173: IS
174: CURSOR l_period_quotas_cr
175: IS
176: SELECT --cn_period_quotas_s.nextval,
177: p_period_id c1,
178: p_quota_id c2,
179: p_period_target c3,
180: 0 c4,
205: IF p_quota_id IS NOT NULL
206: THEN
207: FOR l_period_quota IN l_period_quotas_cr
208: LOOP
209: SELECT cn_period_quotas_s.NEXTVAL
210: INTO l_pqs
211: FROM DUAL;
212:
213: INSERT INTO cn_period_quotas
328: IF (x_quota_id IS NOT NULL AND l_insert_flag = 'Y') THEN
329:
330: FOR l_period_quota IN l_period_quotas_cr
331: LOOP
332: SELECT cn_period_quotas_s.NEXTVAL
333: INTO l_pqs
334: FROM DUAL;
335:
336: INSERT INTO cn_period_quotas