APPS.CN_QUOTA_RULE_PVT dependencies on CN_QUOTAS

Line 198: select name into l_temp_old from cn_quotas_v where quota_id = p_quota_rule_new.quota_id;

194: x_return_status := fnd_api.g_ret_sts_success;
195: -- Initialize other fields
196: x_msg_data := fnd_api.g_null_char;
197: x_msg_count := fnd_api.g_null_num;
198: select name into l_temp_old from cn_quotas_v where quota_id = p_quota_rule_new.quota_id;
199: IF (p_operation = 'create') THEN
200: fnd_message.set_name('CN','CNR12_NOTE_PE_PROD_UPDATE');
201: fnd_message.set_token('ELIG_PROD', p_quota_rule_new.revenue_class_name);
202: fnd_message.set_token('PE_NAME', l_temp_old);

Line 204: l_temp_new := 'CN_QUOTAS';

200: fnd_message.set_name('CN','CNR12_NOTE_PE_PROD_UPDATE');
201: fnd_message.set_token('ELIG_PROD', p_quota_rule_new.revenue_class_name);
202: fnd_message.set_token('PE_NAME', l_temp_old);
203: l_plan_element_id := p_quota_rule_new.quota_id;
204: l_temp_new := 'CN_QUOTAS';
205: END IF;
206: IF (p_operation = 'delete') THEN
207: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_ELIGPROD_DELETE');
208: fnd_message.set_token('PROD', p_quota_rule_new.revenue_class_name);

Line 211: l_temp_new := 'CN_QUOTAS';

207: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_ELIGPROD_DELETE');
208: fnd_message.set_token('PROD', p_quota_rule_new.revenue_class_name);
209: fnd_message.set_token('PE_NAME', l_temp_old);
210: l_plan_element_id := p_quota_rule_new.quota_id;
211: l_temp_new := 'CN_QUOTAS';
212: END IF;
213: IF (p_operation = 'update') THEN
214: select NAME into l_temp_rc_old from cn_revenue_classes where
215: revenue_class_id = p_quota_rule_old.revenue_class_id

Line 221: l_temp_new := 'CN_QUOTAS';

217: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_PROD_CHANGE');
218: fnd_message.set_token('PROD_OLD', l_temp_rc_old);
219: fnd_message.set_token('PROD_NEW', p_quota_rule_new.revenue_class_name);
220: l_plan_element_id := p_quota_rule_new.quota_id;
221: l_temp_new := 'CN_QUOTAS';
222: END IF;
223: l_note_msg := fnd_message.get;
224: jtf_notes_pub.create_note
225: (p_api_version => 1.0,

Line 304: FROM cn_quotas

300: NAME,
301: incentive_type_code,
302: quota_type_code,
303: org_id
304: FROM cn_quotas
305: WHERE quota_id = c_quota_id;
306:
307: CURSOR c_uplift_csr
308: IS

Line 1391: l_quota_name cn_quotas.NAME%TYPE;

1387: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Quota_Rule';
1388: l_api_version CONSTANT NUMBER := 1.0;
1389: l_quota_id NUMBER;
1390: l_revenue_class_id NUMBER;
1391: l_quota_name cn_quotas.NAME%TYPE;
1392: BEGIN
1393: -- Standard Start of API savepoint
1394: SAVEPOINT delete_quota_rule;
1395: