DBA Data[Home] [Help]

APPS.CN_QUOTA_RULES_PKG dependencies on DUAL

Line 51: FROM SYS.DUAL;

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:
54: -- Name
55:

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 481: -- We are deleting an individual quota rule

477: IF x_quota_id IS NOT NULL
478: THEN
479: IF x_quota_rule_id IS NOT NULL
480: THEN
481: -- We are deleting an individual quota rule
482: cn_comp_plans_pkg.set_status (x_comp_plan_id => NULL,
483: x_quota_id => x_quota_id,
484: x_rate_schedule_id => NULL,
485: x_status_code => 'INCOMPLETE',