APPS.CN_SRP_QUOTA_RULES_PKG dependencies on CN_QUOTA_RULES

Line 34: FROM cn_quota_rules_all qr,

30: SELECT qr.target,
31: qr.payment_amount,
32: qr.performance_goal,
33: sqr.srp_quota_rule_id
34: FROM cn_quota_rules_all qr,
35: cn_srp_quota_rules_all sqr
36: WHERE qr.quota_rule_id = sqr.quota_rule_id
37: AND sqr.srp_quota_assign_id = x_srp_quota_assign_id
38: ;

Line 63: -- Descr: This program will be called from cn_quota_rules, when the user

59: END synch_target;
60:
61: ---------------------------------------------------------------------------+
62: -- PROCEDURE UPDATE_RECORD
63: -- Descr: This program will be called from cn_quota_rules, when the user
64: -- modifiy the target, payment_amount, performance goal
65: -- Case1: x_quota_rule_id is NOT NULL when called from cn_quota_rules
66: -- Case2: x_srp_quota_rule_id IS NOT NULL FROM forms Only.
67: ---------------------------------------------------------------------------+

Line 65: -- Case1: x_quota_rule_id is NOT NULL when called from cn_quota_rules

61: ---------------------------------------------------------------------------+
62: -- PROCEDURE UPDATE_RECORD
63: -- Descr: This program will be called from cn_quota_rules, when the user
64: -- modifiy the target, payment_amount, performance goal
65: -- Case1: x_quota_rule_id is NOT NULL when called from cn_quota_rules
66: -- Case2: x_srp_quota_rule_id IS NOT NULL FROM forms Only.
67: ---------------------------------------------------------------------------+
68: PROCEDURE update_record ( x_quota_rule_id NUMBER
69: ,x_srp_quota_rule_id NUMBER := NULL

Line 212: ,cn_quota_rules_all qr

208: ,Sysdate
209: ,fnd_global.login_id
210: ,sqa.org_id
211: FROM cn_srp_quota_assigns_all sqa
212: ,cn_quota_rules_all qr
213: WHERE sqa.srp_plan_assign_id = x_srp_plan_assign_id
214: AND sqa.quota_id = x_quota_id
215: AND qr.quota_id = sqa.quota_id
216: AND sqa.quota_type_code IN ('FORMULA','EXTERNAL')

Line 253: ,cn_quota_rules_all qr

249: ,Sysdate
250: ,fnd_global.login_id
251: ,sqa.org_id
252: FROM cn_srp_quota_assigns_all sqa
253: ,cn_quota_rules_all qr
254: WHERE sqa.srp_plan_assign_id = x_srp_plan_assign_id
255: AND sqa.quota_id = qr.quota_id
256: AND sqa.quota_type_code IN ('FORMULA','EXTERNAL')
257: ;

Line 261: -- Inserting a new cn_quota_rules record

257: ;
258:
259: ELSIF (x_srp_plan_assign_id IS NULL AND x_quota_id IS NOT NULL) THEN
260:
261: -- Inserting a new cn_quota_rules record
262: IF x_quota_rule_id IS NOT NULL THEN
263:
264: -- Bug 2507490
265: INSERT INTO cn_srp_quota_rules_all

Line 296: ,cn_quota_rules_all qr

292: ,Sysdate
293: ,fnd_global.login_id
294: ,sqa.org_id
295: FROM cn_srp_quota_assigns_all sqa
296: ,cn_quota_rules_all qr
297: WHERE sqa.quota_id = x_quota_id
298: AND qr.quota_id = sqa.quota_id
299: AND qr.quota_rule_id = x_quota_rule_id
300: AND sqa.quota_type_code IN ('FORMULA','EXTERNAL')

Line 338: ,cn_quota_rules_all qr

334: ,Sysdate
335: ,fnd_global.login_id
336: ,sqa.org_id
337: FROM cn_srp_quota_assigns_all sqa
338: ,cn_quota_rules_all qr
339: WHERE sqa.quota_id = x_quota_id
340: AND qr.quota_id = sqa.quota_id
341: AND sqa.quota_type_code IN ('FORMULA', 'EXTERNAL')
342: ;

Line 424: -- cn_quota_rules record deleted

420: ELSIF ( x_srp_plan_assign_id IS NULL
421: AND x_quota_id IS NOT NULL
422: AND x_quota_rule_id IS NOT NULL) THEN
423:
424: -- cn_quota_rules record deleted
425: -- The revenue_class_id is also passed to ensure we can delete the
426: -- per_quota_rc records.
427:
428: -- ** Delete SRp Quota rule uplifs before delete the srp quota rules

Line 456: FROM cn_quota_rules

452: ,p_quota_rule_uplift_id => NULL);
453:
454: DELETE FROM cn_srp_quota_rules_all
455: WHERE quota_rule_id IN (SELECT quota_rule_id
456: FROM cn_quota_rules
457: WHERE quota_id = x_quota_id);
458:
459: END IF;
460: