APPS.CN_QUOTA_ASSIGN_PVT dependencies on CN_CALC_SQL_EXPS_PVT

Line 48: l_quota_tbl cn_calc_sql_exps_pvt.num_tbl_type;

44: l_quota_id cn_quotas.quota_id%TYPE;
45: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
46: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
47: l_org_id cn_quota_assigns.org_id%TYPE;
48: l_quota_tbl cn_calc_sql_exps_pvt.num_tbl_type;
49: l_note_msg VARCHAR2 (240);
50: l_note_id NUMBER;
51: l_cp_name cn_comp_plans.NAME%TYPE;
52: l_pe_name cn_quotas.NAME%TYPE;

Line 151: cn_calc_sql_exps_pvt.get_dependent_plan_elts

147: -- 4. interdependent quotas must reference only quotas with lower
148: -- sequence number and must reference quotas in same plan
149: IF p_quota_assign.IDQ_FLAG is null THEN
150:
151: cn_calc_sql_exps_pvt.get_dependent_plan_elts
152: (p_api_version => 1.0,
153: p_node_type => 'P',
154: p_node_id => p_quota_assign.quota_id,
155: x_plan_elt_id_tbl => l_quota_tbl,

Line 357: l_quota_tbl cn_calc_sql_exps_pvt.num_tbl_type;

353: l_temp_count NUMBER;
354: l_quota_id cn_quotas.quota_id%TYPE;
355: l_quota_assign_id cn_quota_assigns.quota_assign_id%TYPE;
356: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
357: l_quota_tbl cn_calc_sql_exps_pvt.num_tbl_type;
358: l_msg_count NUMBER;
359: l_msg_data VARCHAR2 (2000);
360: l_org_id cn_quota_assigns.org_id%TYPE;
361: l_note_msg VARCHAR2 (240);

Line 495: cn_calc_sql_exps_pvt.get_dependent_plan_elts

491: -- sequence number and must reference quotas in same plan
492:
493: IF p_quota_assign.IDQ_FLAG is null THEN
494:
495: cn_calc_sql_exps_pvt.get_dependent_plan_elts
496: (p_api_version => 1.0,
497: p_node_type => 'P',
498: p_node_id => p_quota_assign.quota_id,
499: x_plan_elt_id_tbl => l_quota_tbl,