APPS.CN_QUOTAS_PKG dependencies on CN_QUOTAS

Line 1: PACKAGE BODY cn_quotas_pkg AS

1: PACKAGE BODY cn_quotas_pkg AS
2: /* $Header: cnpliqob.pls 120.4.12000000.5 2007/10/10 00:48:56 rnagired ship $ */
3:
4: /*
5: Date Name Description

Line 100: SELECT cn_quotas_s.NEXTVAL

96: x_quota_id IN OUT NOCOPY NUMBER
97: )
98: IS
99: BEGIN
100: SELECT cn_quotas_s.NEXTVAL
101: INTO x_quota_id
102: FROM SYS.DUAL;
103: END get_uid;
104:

Line 123: UPDATE cn_quotas_all

119: cn_period_quotas_pkg.DELETE_RECORD (x_quota_id => x_quota_id);
120: -- delete rt quota asgns id
121: cn_rt_quota_asgns_pkg.DELETE_RECORD (x_quota_id => x_quota_id, x_calc_formula_id => NULL, x_rt_quota_asgn_id => NULL);
122:
123: UPDATE cn_quotas_all
124: SET delete_flag = 'Y'
125: WHERE quota_id = x_quota_id;
126: END DELETE_RECORD;
127:

Line 199: INSERT INTO cn_quotas

195: THEN
196: get_uid (x_quota_id);
197: END IF;
198:
199: INSERT INTO cn_quotas
200: (quota_id,
201: NAME,
202: target,
203: quota_type_code,

Line 318: UPDATE cn_quotas

314: x_end_date DATE
315: )
316: IS
317: BEGIN
318: UPDATE cn_quotas
319: SET start_date = x_start_date,
320: end_date = x_end_date
321: WHERE quota_id = x_quota_id;
322: END;

Line 405: FROM cn_quotas

401:
402: CURSOR c
403: IS
404: SELECT *
405: FROM cn_quotas
406: WHERE quota_id = x_quota_id;
407:
408: -- clku
409: CURSOR srp_quota_assigns_curs

Line 435: FROM cn_quotas

431: CLOSE c;
432:
433: SELECT object_version_number
434: INTO l_old_ovn
435: FROM cn_quotas
436: WHERE quota_id = x_quota_id;
437:
438: l_ovn := (NVL (l_old_ovn, 1) + 1);
439:

Line 440: UPDATE cn_quotas

436: WHERE quota_id = x_quota_id;
437:
438: l_ovn := (NVL (l_old_ovn, 1) + 1);
439:
440: UPDATE cn_quotas
441: SET quota_id = x_quota_id,
442: NAME = x_name,
443: target = x_target,
444: quota_type_code = x_quota_type_code,

Line 945: FROM cn_quotas

941: IS
942: CURSOR c
943: IS
944: SELECT *
945: FROM cn_quotas
946: WHERE quota_id = x_quota_id
947: FOR UPDATE OF quota_id NOWAIT;
948:
949: recinfo c%ROWTYPE;

Line 1236: END cn_quotas_pkg;

1232: THEN
1233: DELETE_RECORD (x_quota_id, x_name);
1234: END IF;
1235: END begin_record;
1236: END cn_quotas_pkg;