DBA Data[Home] [Help]

APPS.CN_QUOTA_RULE_PVT dependencies on CN_QUOTAS_V

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);