APPS.CN_COMP_PLAN_PUB dependencies on CN_QUOTAS

Line 34: l_quota_type_code cn_quotas.quota_type_code%TYPE;

30: l_dummy NUMBER;
31: l_rc_overlap cn_comp_plans.allow_rev_class_overlap%TYPE;
32: l_rev_class_total NUMBER := 0;
33: l_rev_class_total_unique NUMBER := 0;
34: l_quota_type_code cn_quotas.quota_type_code%TYPE;
35: l_quota_start_date DATE;
36: l_quota_end_date DATE;
37: l_flag BOOLEAN;
38:

Line 50: cn_quotas_v q,

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
54: AND NVL (TRUNC (dh.end_date), TRUNC (q.start_date)) >=

Line 109: FROM cn_quotas_v

105: SELECT quota_id, quota_type_code, start_date,
106: end_date
107: INTO x_pe_id, l_quota_type_code, l_quota_start_date,
108: l_quota_end_date
109: FROM cn_quotas_v
110: WHERE NAME = p_pe_name AND org_id = p_org_id ;
111: EXCEPTION
112: WHEN NO_DATA_FOUND
113: THEN

Line 261: p_plan_element_name IN cn_quotas.NAME%TYPE,

257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_comp_plan_name IN cn_comp_plans.NAME%TYPE,
259: p_comp_start_date IN DATE,
260: p_comp_end_date IN DATE,
261: p_plan_element_name IN cn_quotas.NAME%TYPE,
262: p_org_id IN cn_quotas.org_id%TYPE,
263: x_loading_status OUT NOCOPY VARCHAR2
264: )
265: IS

Line 262: p_org_id IN cn_quotas.org_id%TYPE,

258: p_comp_plan_name IN cn_comp_plans.NAME%TYPE,
259: p_comp_start_date IN DATE,
260: p_comp_end_date IN DATE,
261: p_plan_element_name IN cn_quotas.NAME%TYPE,
262: p_org_id IN cn_quotas.org_id%TYPE,
263: x_loading_status OUT NOCOPY VARCHAR2
264: )
265: IS
266: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Plan_Element_Assign';