APPS.CN_SRP_RULE_UPLIFTS_PKG dependencies on CN_SRP_RULE_UPLIFTS_ALL

Line 36: INSERT INTO cn_srp_rule_uplifts_all

32: IF ( p_srp_plan_assign_id IS NOT NULL AND p_quota_id IS NOT NULL) THEN
33:
34: -- Inserting a new cn_quota_assigns
35:
36: INSERT INTO cn_srp_rule_uplifts_all
37: (
38: srp_rule_uplift_id
39: ,srp_quota_rule_id
40: ,quota_rule_uplift_id

Line 75: INSERT INTO cn_srp_rule_uplifts_all

71:
72: ELSIF ( p_srp_plan_assign_id IS NOT NULL AND p_quota_id IS NULL) THEN
73: -- Inserting a new plan assignment
74:
75: INSERT INTO cn_srp_rule_uplifts_all
76: (
77: srp_rule_uplift_id
78: ,srp_quota_rule_id
79: ,quota_rule_uplift_id

Line 116: INSERT INTO cn_srp_rule_uplifts_all

112: -- Inserting a new Quota Rule Uplifts
113:
114: IF p_quota_rule_id IS NOT NULL THEN
115:
116: INSERT INTO cn_srp_rule_uplifts_all
117: ( srp_rule_uplift_id
118: ,srp_quota_rule_id
119: ,quota_rule_uplift_id
120: ,payment_factor

Line 152: INSERT INTO cn_srp_rule_uplifts_all

148: -- clku, handle the case of inserting srp quota rules which already have
149: -- uplift factor at PE Level. Bug 2788644
150: ELSIF ( p_quota_rule_id IS NOT NULL AND p_quota_rule_uplift_id IS NULL) THEN
151:
152: INSERT INTO cn_srp_rule_uplifts_all
153: ( srp_rule_uplift_id
154: ,srp_quota_rule_id
155: ,quota_rule_uplift_id
156: ,payment_factor

Line 205: UPDATE cn_srp_rule_uplifts_all

201: BEGIN
202: IF p_srp_rule_uplift_id IS NOT NULL THEN
203:
204: -- Called from srp rule Uplift block
205: UPDATE cn_srp_rule_uplifts_all
206: SET
207: -- Should be an optional column as it can be null for
208: -- quota types 'revenue' and 'draw'. But it is mandatory and
209: -- this nvl protects against a null value coming back from the

Line 254: DELETE FROM cn_srp_rule_uplifts_all sru

250: p_quota_rule_uplift_id IS NULL ) THEN
251:
252: -- cn_quota_assigns Record has been deleted
253: -- for each srp plan assign record
254: DELETE FROM cn_srp_rule_uplifts_all sru
255: WHERE sru.srp_quota_rule_id IN
256: ( SELECT sqr.srp_quota_rule_id
257: FROM cn_srp_quota_rules_all sqr
258: , cn_srp_quota_assigns sqa

Line 269: DELETE FROM cn_srp_rule_uplifts_all sru

265: AND p_quota_id IS NULL
266: AND p_quota_rule_id IS NULL) THEN
267:
268: -- cn_srp_plan_assigns record has been deleted
269: DELETE FROM cn_srp_rule_uplifts_all sru
270: WHERE sru.srp_quota_rule_id IN
271: ( SELECT sqr.srp_quota_rule_id
272: FROM cn_srp_quota_rules_all sqr
273: WHERE sqr.srp_plan_assign_id = p_srp_plan_assign_id )

Line 281: DELETE FROM cn_srp_rule_uplifts_all sru

277: AND p_quota_id IS NOT NULL
278: AND p_quota_rule_id IS NOT NULL) THEN
279:
280: -- cn_quota_rules record deleted
281: DELETE FROM cn_srp_rule_uplifts_all sru
282: WHERE sru.srp_quota_rule_id IN
283: (SELECT sqr.srp_quota_rule_id
284: FROM cn_srp_quota_rules_all sqr, cn_quota_rules_all qr
285: WHERE sqr.quota_rule_id = p_quota_rule_id

Line 293: DELETE FROM cn_srp_rule_uplifts_all

289: ELSIF ( p_quota_rule_uplift_id IS NOT NULL) THEN
290:
291: -- cn_quota_rule_uplifts record deleted
292:
293: DELETE FROM cn_srp_rule_uplifts_all
294: WHERE quota_rule_uplift_id = p_quota_rule_uplift_id
295: ;
296:
297: ELSIF ( p_quota_id IS NOT NULL ) THEN

Line 298: DELETE FROM cn_srp_rule_uplifts_all sru

294: WHERE quota_rule_uplift_id = p_quota_rule_uplift_id
295: ;
296:
297: ELSIF ( p_quota_id IS NOT NULL ) THEN
298: DELETE FROM cn_srp_rule_uplifts_all sru
299: WHERE sru.srp_quota_rule_id IN
300: (SELECT sqr.srp_quota_rule_id
301: FROM cn_quota_rules_all qr,
302: cn_srp_quota_rules_all sqr

Line 318: UPDATE cn_srp_rule_uplifts_all u

314: PROCEDURE update_record ( p_quota_rule_uplift_id NUMBER
315: ,p_quota_factor NUMBER
316: ,p_payment_factor NUMBER) IS
317: BEGIN
318: UPDATE cn_srp_rule_uplifts_all u
319: set u.payment_factor = p_payment_factor
320: , u.quota_factor = p_quota_factor
321: WHERE u.quota_rule_uplift_id = p_quota_rule_uplift_id
322: AND EXISTS (SELECT 'quota rule uplift belongs to a uncustomized quota'