eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_QUOTA_RULE_PVT dependencies on CN_REVENUE_CLASSES

Line 25: l_old_name cn_revenue_classes.NAME%TYPE;

21: RETURN quota_rule_rec_type
22: IS
23: l_quota_rule quota_rule_rec_type;
24: l_loading_status VARCHAR2 (2000);
25: l_old_name cn_revenue_classes.NAME%TYPE;
26: l_old_revenue_class_id NUMBER;
27: l_old_quota_rule_id NUMBER;
28: BEGIN
29: l_quota_rule.plan_element_name := LTRIM (RTRIM (p_quota_name));

Line 214: select NAME into l_temp_rc_old from cn_revenue_classes where

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
216: and org_id = p_quota_rule_old.org_id;
217: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_PROD_CHANGE');
218: fnd_message.set_token('PROD_OLD', l_temp_rc_old);

Line 373: FROM cn_revenue_classes_all

369:
370: BEGIN
371: SELECT NAME
372: INTO p_quota_rule.revenue_class_name
373: FROM cn_revenue_classes_all
374: WHERE revenue_class_id = p_quota_rule.revenue_class_id;
375: EXCEPTION
376: WHEN NO_DATA_FOUND
377: THEN