APPS.CN_QUOTA_RULES_PKG dependencies on CN_QUOTA_RULES

Line 1: PACKAGE BODY cn_quota_rules_pkg AS

1: PACKAGE BODY cn_quota_rules_pkg AS
2: /* $Header: cnpliqrb.pls 120.5.12000000.2 2007/10/09 22:19:24 rnagired ship $ */
3:
4: /*
5: Date Name Description

Line 49: SELECT cn_quota_rules_s.NEXTVAL

45: x_quota_rule_id IN OUT NOCOPY NUMBER
46: )
47: IS
48: BEGIN
49: SELECT cn_quota_rules_s.NEXTVAL
50: INTO x_quota_rule_id
51: FROM SYS.DUAL;
52: END get_uid;
53:

Line 92: FROM cn_quota_rules

88: SUM (NVL (performance_goal, 0))
89: INTO l_target,
90: l_payment_amount,
91: l_performance_goal
92: FROM cn_quota_rules
93: WHERE quota_id = p_quota_id;
94:
95: cn_quotas_pkg.begin_record (x_operation => 'UPDATE',
96: x_rowid => g_rowid,

Line 194: select cn_quota_rules_s.nextval into x_quota_rule_id from dual;

190: );
191:
192: x_object_version_number := 1 ;
193: IF x_quota_rule_id IS NULL THEN
194: select cn_quota_rules_s.nextval into x_quota_rule_id from dual;
195: END IF;
196: -- Insert Quota Rules
197: -- object version number insert added, clku
198: INSERT INTO cn_quota_rules

Line 198: INSERT INTO cn_quota_rules

194: select cn_quota_rules_s.nextval into x_quota_rule_id from dual;
195: END IF;
196: -- Insert Quota Rules
197: -- object version number insert added, clku
198: INSERT INTO cn_quota_rules
199: (quota_rule_id,
200: quota_id,
201: revenue_class_id,
202: org_id,

Line 325: FROM cn_quota_rules

321: END IF;
322:
323: SELECT (NVL (object_version_number, 1) + 1)
324: INTO x_object_version_number
325: FROM cn_quota_rules
326: WHERE quota_rule_id = x_quota_rule_id;
327:
328: UPDATE cn_quota_rules
329: SET revenue_class_id = x_revenue_class_id,

Line 328: UPDATE cn_quota_rules

324: INTO x_object_version_number
325: FROM cn_quota_rules
326: WHERE quota_rule_id = x_quota_rule_id;
327:
328: UPDATE cn_quota_rules
329: SET revenue_class_id = x_revenue_class_id,
330: quota_id = x_quota_id,
331: target = x_target,
332: payment_amount = x_payment_amount,

Line 424: FROM cn_quota_rules

420: IS
421: CURSOR c
422: IS
423: SELECT *
424: FROM cn_quota_rules
425: WHERE quota_rule_id = x_quota_rule_id
426: FOR UPDATE OF quota_rule_id NOWAIT;
427:
428: recinfo c%ROWTYPE;

Line 500: DELETE FROM cn_quota_rules

496: x_quota_rule_id => x_quota_rule_id,
497: x_revenue_class_id => x_revenue_class_id
498: );
499:
500: DELETE FROM cn_quota_rules
501: WHERE quota_rule_id = x_quota_rule_id;
502:
503: IF (SQL%NOTFOUND)
504: THEN

Line 526: DELETE FROM cn_quota_rules

522: x_quota_rule_id => x_quota_rule_id,
523: x_revenue_class_id => x_revenue_class_id
524: );
525:
526: DELETE FROM cn_quota_rules
527: WHERE quota_id = x_quota_id;
528: END IF;
529:
530: update_quota (x_quota_id);

Line 739: cn_quota_rules qr,

735: IS
736: SELECT rv.NAME
737: FROM cn_dim_explosion de1,
738: cn_dim_explosion de2,
739: cn_quota_rules qr,
740: cn_revenue_classes rv
741: WHERE de1.dim_hierarchy_id = l_dim_hierarchy_id
742: AND de2.dim_hierarchy_id = l_dim_hierarchy_id
743: AND de1.value_external_id = de2.value_external_id

Line 763: cn_quota_rules b

759: LOOP
760: SELECT COUNT (*)
761: INTO l_count
762: FROM cn_dim_explosion a,
763: cn_quota_rules b
764: WHERE a.dim_hierarchy_id = c1_row.dim_hierarchy_id
765: AND a.hierarchy_level <> 0 /*Do not self reference */
766: AND b.quota_id = x_quota_id
767: AND b.revenue_class_id <> NVL (x_revenue_class_id_old, -999)

Line 784: cn_quota_rules c,

780: INTO l_rev_class_name_parent,
781: l_rev_class_name_child
782: FROM cn_revenue_classes a,
783: cn_revenue_classes b,
784: cn_quota_rules c,
785: cn_dim_explosion d
786: WHERE d.hierarchy_level <> 0
787: AND d.dim_hierarchy_id = c1_row.dim_hierarchy_id
788: AND c.revenue_class_id <> NVL (x_revenue_class_id_old, -999)

Line 838: END cn_quota_rules_pkg;

834: END LOOP;
835:
836: RETURN (l_flag); /* return - success */
837: END check_rev_class_hier;
838: END cn_quota_rules_pkg;