APPS.CN_QUOTA_RULES_PKG dependencies on CN_QUOTAS

Line 77: l_pe_rec cn_quotas%ROWTYPE;

73: g_created_by NUMBER := fnd_global.user_id;
74: g_last_update_login NUMBER := fnd_global.login_id;
75: g_rowid VARCHAR2 (30);
76: g_program_type VARCHAR2 (30);
77: l_pe_rec cn_quotas%ROWTYPE;
78: BEGIN
79: SELECT *
80: INTO l_pe_rec
81: FROM cn_quotas

Line 81: FROM cn_quotas

77: l_pe_rec cn_quotas%ROWTYPE;
78: BEGIN
79: SELECT *
80: INTO l_pe_rec
81: FROM cn_quotas
82: WHERE quota_id = p_quota_id;
83:
84: IF l_pe_rec.addup_from_rev_class_flag = 'Y'
85: THEN

Line 95: cn_quotas_pkg.begin_record (x_operation => 'UPDATE',

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,
97: x_quota_id => l_pe_rec.quota_id,
98: x_object_version_number => l_pe_rec.object_version_number,
99: x_name => l_pe_rec.NAME,

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 291: l_name cn_quotas.NAME%TYPE;

287: x_status_code VARCHAR2,
288: x_revenue_class_id_old NUMBER
289: )
290: IS
291: l_name cn_quotas.NAME%TYPE;
292: l_org_id cn_quotas.org_id%TYPE;
293: BEGIN
294: IF g_program_type = 'FORM'
295: THEN

Line 292: l_org_id cn_quotas.org_id%TYPE;

288: x_revenue_class_id_old NUMBER
289: )
290: IS
291: l_name cn_quotas.NAME%TYPE;
292: l_org_id cn_quotas.org_id%TYPE;
293: BEGIN
294: IF g_program_type = 'FORM'
295: THEN
296: IF (x_revenue_class_id_old <> x_revenue_class_id)

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 474: l_name cn_quotas.NAME%TYPE;

470: x_quota_rule_id NUMBER,
471: x_revenue_class_id NUMBER
472: )
473: IS
474: l_name cn_quotas.NAME%TYPE;
475: l_org_id cn_quotas.org_id%TYPE;
476: BEGIN
477: IF x_quota_id IS NOT NULL
478: THEN

Line 475: l_org_id cn_quotas.org_id%TYPE;

471: x_revenue_class_id NUMBER
472: )
473: IS
474: l_name cn_quotas.NAME%TYPE;
475: l_org_id cn_quotas.org_id%TYPE;
476: BEGIN
477: IF x_quota_id IS NOT NULL
478: THEN
479: IF x_quota_rule_id IS NOT NULL

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,