DBA Data[Home] [Help]

APPS.CN_QUOTA_RULES_PKG dependencies on CN_QUOTAS_ALL

Line 182: l_name cn_quotas_all.NAME%TYPE;

178: x_revenue_class_name VARCHAR2,
179: x_object_version_number IN OUT NOCOPY NUMBER
180: )
181: IS
182: l_name cn_quotas_all.NAME%TYPE;
183: BEGIN
184: -- Change the comp Status
185: cn_comp_plans_pkg.set_status (x_comp_plan_id => NULL,
186: x_quota_id => x_quota_id,

Line 235: FROM cn_quotas_all

231: -- Code from the trigger CN_QUOTA_RULE_TL
232: ----------------------------------------------------------------------------------
233: SELECT NAME
234: INTO l_name
235: FROM cn_quotas_all
236: WHERE quota_id = x_quota_id;
237:
238: cn_mark_events_pkg.mark_event_quota (p_event_name => 'CHANGE_QUOTA_ROLL',
239: p_object_name => l_name,

Line 385: FROM cn_quotas_all

381: SELECT NAME,
382: org_id
383: INTO l_name,
384: l_org_id
385: FROM cn_quotas_all
386: WHERE quota_id = x_quota_id;
387:
388: cn_mark_events_pkg.mark_event_quota (p_event_name => 'CHANGE_QUOTA_ROLL',
389: p_object_name => l_name,

Line 543: FROM cn_quotas_all

539: SELECT NAME,
540: org_id
541: INTO l_name,
542: l_org_id
543: FROM cn_quotas_all
544: WHERE quota_id = x_quota_id;
545:
546: cn_mark_events_pkg.mark_event_quota (p_event_name => 'CHANGE_QUOTA_ROLL',
547: p_object_name => l_name,