APPS.CN_QUOTA_RULE_UPLIFTS_PKG dependencies on CN_QUOTA_RULE_UPLIFTS

Line 1: PACKAGE BODY cn_quota_rule_uplifts_pkg AS

1: PACKAGE BODY cn_quota_rule_uplifts_pkg AS
2: /* $Header: cnpliqrub.pls 120.2 2005/08/05 00:32:02 fmburu ship $ */
3: /*
4: Date Name Description
5: ------------------------------------------------------------------------------+

Line 29: SELECT cn_quota_rule_uplifts_s.NEXTVAL

25: x_quota_rule_uplift_id IN OUT NOCOPY NUMBER
26: )
27: IS
28: BEGIN
29: SELECT cn_quota_rule_uplifts_s.NEXTVAL
30: INTO x_quota_rule_uplift_id
31: FROM SYS.DUAL;
32: END get_uid;
33:

Line 65: INSERT INTO cn_quota_rule_uplifts

61: BEGIN
62: get_uid (x_quota_rule_uplift_id);
63: x_object_version_number := 1;
64:
65: INSERT INTO cn_quota_rule_uplifts
66: (org_id,
67: quota_rule_uplift_id,
68: quota_rule_id,
69: payment_factor,

Line 133: FROM cn_quota_rule_uplifts

129: )
130: IS
131: CURSOR c IS
132: SELECT *
133: FROM cn_quota_rule_uplifts
134: WHERE quota_rule_uplift_id = x_quota_rule_uplift_id;
135:
136: recinfo c%ROWTYPE;
137: BEGIN

Line 145: UPDATE cn_quota_rule_uplifts

141: CLOSE c;
142:
143: x_object_version_number := NVL (recinfo.object_version_number, 1) + 1;
144:
145: UPDATE cn_quota_rule_uplifts
146: SET payment_factor = x_payment_factor,
147: quota_factor = x_quota_factor,
148: start_date = x_start_date,
149: end_date = x_end_date,

Line 207: DELETE FROM cn_quota_rule_uplifts

203: --clku, bug 2257692
204: IF x_quota_rule_uplift_id IS NOT NULL
205: THEN
206: -- delete with id
207: DELETE FROM cn_quota_rule_uplifts
208: WHERE quota_rule_uplift_id = x_quota_rule_uplift_id;
209:
210: IF (SQL%NOTFOUND)
211: THEN

Line 217: DELETE FROM cn_quota_rule_uplifts

213: END IF;
214: ELSIF x_quota_rule_id IS NOT NULL
215: THEN
216: -- Deleting an entire quota rule Uplifts
217: DELETE FROM cn_quota_rule_uplifts
218: WHERE quota_rule_id = x_quota_rule_id;
219: ELSIF x_quota_id IS NOT NULL
220: THEN
221: DELETE FROM cn_quota_rule_uplifts cqru

Line 221: DELETE FROM cn_quota_rule_uplifts cqru

217: DELETE FROM cn_quota_rule_uplifts
218: WHERE quota_rule_id = x_quota_rule_id;
219: ELSIF x_quota_id IS NOT NULL
220: THEN
221: DELETE FROM cn_quota_rule_uplifts cqru
222: WHERE EXISTS (SELECT 1
223: FROM cn_quota_rules crq
224: WHERE crq.quota_rule_id = cqru.quota_rule_id AND crq.quota_id = x_quota_id);
225: END IF;

Line 343: END cn_quota_rule_uplifts_pkg;

339: -- no validation perfromed here. All validation aimed at changing the
340: -- status of the quota is performed in the quota package.
341: NULL;
342: END end_record;
343: END cn_quota_rule_uplifts_pkg;