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_XMLCOPY_PVT dependencies on CN_QUOTAS

Line 262: l_quota_id cn_quotas.quota_id%TYPE;

258: l_pe_mtrc_p_sql VARCHAR2(30);
259: l_pe_p_sql VARCHAR2(30);
260: l_open_p_sql NUMBER;
261: l_close_p_sql NUMBER;
262: l_quota_id cn_quotas.quota_id%TYPE;
263: l_failed_plan_name VARCHAR2(2000);
264: l_formula_name_source cn_calc_formulas.name%TYPE;
265: l_pe_source_name cn_quotas.name%TYPE;
266: l_pe_num NUMBER := 0;

Line 265: l_pe_source_name cn_quotas.name%TYPE;

261: l_close_p_sql NUMBER;
262: l_quota_id cn_quotas.quota_id%TYPE;
263: l_failed_plan_name VARCHAR2(2000);
264: l_formula_name_source cn_calc_formulas.name%TYPE;
265: l_pe_source_name cn_quotas.name%TYPE;
266: l_pe_num NUMBER := 0;
267: l_pe_count NUMBER;
268: l_ee_count NUMBER;
269: l_pe_mtrc VARCHAR2(30);

Line 301: (old_pe_name cn_quotas.name%TYPE,

297:
298: l_quota_count NUMBER:=0;
299:
300: TYPE v_pe_exp_rec IS RECORD
301: (old_pe_name cn_quotas.name%TYPE,
302: new_pe_name cn_quotas.name%TYPE,
303: old_pe_id cn_quotas.quota_id%TYPE,
304: new_pe_id cn_quotas.quota_id%TYPE);
305: TYPE v_pe_exp_tbl IS TABLE OF v_pe_exp_rec INDEX BY BINARY_INTEGER;

Line 302: new_pe_name cn_quotas.name%TYPE,

298: l_quota_count NUMBER:=0;
299:
300: TYPE v_pe_exp_rec IS RECORD
301: (old_pe_name cn_quotas.name%TYPE,
302: new_pe_name cn_quotas.name%TYPE,
303: old_pe_id cn_quotas.quota_id%TYPE,
304: new_pe_id cn_quotas.quota_id%TYPE);
305: TYPE v_pe_exp_tbl IS TABLE OF v_pe_exp_rec INDEX BY BINARY_INTEGER;
306: g_miss_pe_exp_rec v_pe_exp_rec;

Line 303: old_pe_id cn_quotas.quota_id%TYPE,

299:
300: TYPE v_pe_exp_rec IS RECORD
301: (old_pe_name cn_quotas.name%TYPE,
302: new_pe_name cn_quotas.name%TYPE,
303: old_pe_id cn_quotas.quota_id%TYPE,
304: new_pe_id cn_quotas.quota_id%TYPE);
305: TYPE v_pe_exp_tbl IS TABLE OF v_pe_exp_rec INDEX BY BINARY_INTEGER;
306: g_miss_pe_exp_rec v_pe_exp_rec;
307: g_miss_pe_exp_tbl v_pe_exp_tbl;

Line 304: new_pe_id cn_quotas.quota_id%TYPE);

300: TYPE v_pe_exp_rec IS RECORD
301: (old_pe_name cn_quotas.name%TYPE,
302: new_pe_name cn_quotas.name%TYPE,
303: old_pe_id cn_quotas.quota_id%TYPE,
304: new_pe_id cn_quotas.quota_id%TYPE);
305: TYPE v_pe_exp_tbl IS TABLE OF v_pe_exp_rec INDEX BY BINARY_INTEGER;
306: g_miss_pe_exp_rec v_pe_exp_rec;
307: g_miss_pe_exp_tbl v_pe_exp_tbl;
308: l_new_pe_name cn_quotas.name%TYPE;

Line 308: l_new_pe_name cn_quotas.name%TYPE;

304: new_pe_id cn_quotas.quota_id%TYPE);
305: TYPE v_pe_exp_tbl IS TABLE OF v_pe_exp_rec INDEX BY BINARY_INTEGER;
306: g_miss_pe_exp_rec v_pe_exp_rec;
307: g_miss_pe_exp_tbl v_pe_exp_tbl;
308: l_new_pe_name cn_quotas.name%TYPE;
309: l_pe_counter NUMBER;
310:
311: TYPE v_pe_collection IS TABLE OF NUMBER;
312: v_pe_tbl v_pe_collection;

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 1762: -- New Column added to cn_quotas table in R12+

1758: v_plan_element_rec.attribute15 := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'Attribute15'),0)));
1759: v_plan_element_rec.rt_sched_custom_flag := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'RtSchedCustomFlag'),0)));
1760: v_plan_element_rec.vesting_flag := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'VestingFlag'),0)));
1761: v_plan_element_rec.period_type := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'PeriodType'),0)));
1762: -- New Column added to cn_quotas table in R12+
1763: v_plan_element_rec.sreps_enddated_flag := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'SalesrepsEnddatedFlag'),0)));
1764: -- Liability and Expense Account Information
1765: l_expense_acc_desc := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'ExpenseAccountDesc'),0)));
1766: l_liability_acc_desc := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'LiabilityAccountDesc'),0)));

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;