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_COMP_PLAN_PUB dependencies on CN_QUOTA_ASSIGNS

Line 49: cn_quota_assigns qa,

45: SELECT COUNT (de.value_external_id),
46: COUNT (DISTINCT de.value_external_id)
47: FROM cn_dim_explosion de,
48: cn_quota_rules qr,
49: cn_quota_assigns qa,
50: cn_quotas_v q,
51: cn_dim_hierarchies dh
52: WHERE dh.header_dim_hierarchy_id = l_rev_class_hierarchy_id
53: AND ( ( q.end_date IS NULL

Line 132: FROM cn_quota_assigns

128: INTO l_dummy
129: FROM SYS.DUAL
130: WHERE NOT EXISTS (
131: SELECT 1
132: FROM cn_quota_assigns
133: WHERE quota_id = x_pe_id
134: AND comp_plan_id = x_cp_id);
135: EXCEPTION
136: WHEN NO_DATA_FOUND

Line 269: l_comp_plan_id cn_quota_assigns.comp_plan_id%TYPE;

265: IS
266: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Plan_Element_Assign';
267: l_api_version CONSTANT NUMBER := 1.0;
268: l_lk_meaning cn_lookups.meaning%TYPE;
269: l_comp_plan_id cn_quota_assigns.comp_plan_id%TYPE;
270: l_pe_id cn_quota_assigns.quota_id%TYPE;
271: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
272: l_loading_status VARCHAR2 (1000);
273: BEGIN

Line 270: l_pe_id cn_quota_assigns.quota_id%TYPE;

266: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Plan_Element_Assign';
267: l_api_version CONSTANT NUMBER := 1.0;
268: l_lk_meaning cn_lookups.meaning%TYPE;
269: l_comp_plan_id cn_quota_assigns.comp_plan_id%TYPE;
270: l_pe_id cn_quota_assigns.quota_id%TYPE;
271: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
272: l_loading_status VARCHAR2 (1000);
273: BEGIN
274: -- Standard Start of API savepoint

Line 271: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;

267: l_api_version CONSTANT NUMBER := 1.0;
268: l_lk_meaning cn_lookups.meaning%TYPE;
269: l_comp_plan_id cn_quota_assigns.comp_plan_id%TYPE;
270: l_pe_id cn_quota_assigns.quota_id%TYPE;
271: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
272: l_loading_status VARCHAR2 (1000);
273: BEGIN
274: -- Standard Start of API savepoint
275: SAVEPOINT create_plan_element_assign;

Line 323: cn_quota_assigns_pkg.begin_record

319: RAISE fnd_api.g_exc_error;
320: ELSIF x_loading_status <> 'PLN_QUOTA_ASSIGNED'
321: THEN
322: -- Create comp plan into cn_comp_plans
323: cn_quota_assigns_pkg.begin_record
324: (x_operation => 'INSERT',
325: x_comp_plan_id => l_comp_plan_id,
326: x_quota_id => l_pe_id,
327: x_quota_assign_id => l_quota_assign_id,