APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on CN_QUOTAS_V

Line 1662: FROM cn_quotas_v

1658: p_prefix => p_prefix);
1659:
1660: -- Check if Plan Element already exists in the Target Instance
1661: SELECT COUNT(name) INTO l_reuse_count
1662: FROM cn_quotas_v
1663: WHERE name = v_name_node_value_new
1664: AND org_id = p_org_id;
1665:
1666: --If Plan Element exists then do not Insert otherwise insert a new Record.

Line 1671: FROM cn_quotas_v

1667: IF l_reuse_count > 0 THEN
1668:
1669:
1670: SELECT quota_status INTO v_plan_element_rec.status
1671: FROM cn_quotas_v
1672: WHERE name=v_name_node_value_new
1673: AND org_id=p_org_id;
1674:
1675: IF v_plan_element_rec.status = 'COMPLETE' THEN

Line 1686: FROM cn_quotas_v

1682:
1683: g_miss_pe_exp_rec.new_pe_name:=v_name_node_value_new; --pe name can change if customer prefix and import
1684:
1685: SELECT quota_id INTO g_miss_pe_exp_rec.new_pe_id
1686: FROM cn_quotas_v
1687: WHERE name = v_name_node_value_new;
1688:
1689:
1690: l_pe_counter := l_pe_counter + 1;

Line 2533: FROM cn_quotas_v

2529: COMMIT;
2530: -- New value of plan element for Interdependent cases
2531: g_miss_pe_exp_rec.new_pe_name := v_plan_element_rec.name;
2532: SELECT COUNT(name) INTO l_new_pe_name
2533: FROM cn_quotas_v
2534: WHERE name = v_plan_element_rec.name;
2535: IF l_new_pe_name > 0 THEN
2536: SELECT quota_id INTO g_miss_pe_exp_rec.new_pe_id
2537: FROM cn_quotas_v

Line 2537: FROM cn_quotas_v

2533: FROM cn_quotas_v
2534: WHERE name = v_plan_element_rec.name;
2535: IF l_new_pe_name > 0 THEN
2536: SELECT quota_id INTO g_miss_pe_exp_rec.new_pe_id
2537: FROM cn_quotas_v
2538: WHERE name = v_plan_element_rec.name;
2539:
2540: l_pe_counter := l_pe_counter + 1;
2541: g_miss_pe_exp_tbl(l_pe_counter).old_pe_name := g_miss_pe_exp_rec.old_pe_name;

Line 2742: FROM cn_quotas_v

2738:
2739: -- Check if PE exists in the Target System
2740: l_pe_name_count := 0;
2741: SELECT count(name) INTO l_pe_name_count
2742: FROM cn_quotas_v
2743: WHERE name = v_quota_assign_tbl(i).name;
2744: IF l_pe_name_count > 0 THEN
2745: SELECT quota_id,start_date,end_date
2746: INTO v_quota_assign_tbl(i).quota_id,v_quota_assign_tbl(i).start_date, v_quota_assign_tbl(i).end_date

Line 2747: FROM cn_quotas_v

2743: WHERE name = v_quota_assign_tbl(i).name;
2744: IF l_pe_name_count > 0 THEN
2745: SELECT quota_id,start_date,end_date
2746: INTO v_quota_assign_tbl(i).quota_id,v_quota_assign_tbl(i).start_date, v_quota_assign_tbl(i).end_date
2747: FROM cn_quotas_v
2748: WHERE name = v_quota_assign_tbl(i).name
2749: AND org_id = p_org_id;
2750: ELSE
2751: ROLLBACK TO Create_CompPlan;