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 297: (old_pe_name cn_quotas.name%TYPE,

293: l_period_end_date DATE;
294: l_exp_name_source cn_calc_sql_exps.name%TYPE;
295:
296: TYPE v_pe_exp_rec IS RECORD
297: (old_pe_name cn_quotas.name%TYPE,
298: new_pe_name cn_quotas.name%TYPE,
299: old_pe_id cn_quotas.quota_id%TYPE,
300: new_pe_id cn_quotas.quota_id%TYPE);
301: TYPE v_pe_exp_tbl IS TABLE OF v_pe_exp_rec INDEX BY BINARY_INTEGER;

Line 298: new_pe_name cn_quotas.name%TYPE,

294: l_exp_name_source cn_calc_sql_exps.name%TYPE;
295:
296: TYPE v_pe_exp_rec IS RECORD
297: (old_pe_name cn_quotas.name%TYPE,
298: new_pe_name cn_quotas.name%TYPE,
299: old_pe_id cn_quotas.quota_id%TYPE,
300: new_pe_id cn_quotas.quota_id%TYPE);
301: TYPE v_pe_exp_tbl IS TABLE OF v_pe_exp_rec INDEX BY BINARY_INTEGER;
302: g_miss_pe_exp_rec v_pe_exp_rec;

Line 299: old_pe_id cn_quotas.quota_id%TYPE,

295:
296: TYPE v_pe_exp_rec IS RECORD
297: (old_pe_name cn_quotas.name%TYPE,
298: new_pe_name cn_quotas.name%TYPE,
299: old_pe_id cn_quotas.quota_id%TYPE,
300: new_pe_id cn_quotas.quota_id%TYPE);
301: TYPE v_pe_exp_tbl IS TABLE OF v_pe_exp_rec INDEX BY BINARY_INTEGER;
302: g_miss_pe_exp_rec v_pe_exp_rec;
303: g_miss_pe_exp_tbl v_pe_exp_tbl;

Line 300: new_pe_id cn_quotas.quota_id%TYPE);

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

Line 304: l_new_pe_name cn_quotas.name%TYPE;

300: new_pe_id cn_quotas.quota_id%TYPE);
301: TYPE v_pe_exp_tbl IS TABLE OF v_pe_exp_rec INDEX BY BINARY_INTEGER;
302: g_miss_pe_exp_rec v_pe_exp_rec;
303: g_miss_pe_exp_tbl v_pe_exp_tbl;
304: l_new_pe_name cn_quotas.name%TYPE;
305: l_pe_counter NUMBER;
306:
307: CURSOR c_expense_account_id (p_exp_acc_desc VARCHAR2) IS
308: SELECT code_combination_id

Line 1500: FROM cn_quotas_v

1496: p_prefix => p_prefix);
1497:
1498: -- Check if Plan Element already exists in the Target Instance
1499: SELECT COUNT(name) INTO l_reuse_count
1500: FROM cn_quotas_v
1501: WHERE name = v_name_node_value_new
1502: AND org_id = p_org_id;
1503:
1504: --If Plan Element exists then do not Insert otherwise insert a new Record.

Line 1556: -- New Column added to cn_quotas table in R12+

1552: v_plan_element_rec.attribute15 := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'Attribute15'),0)));
1553: 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)));
1554: v_plan_element_rec.vesting_flag := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'VestingFlag'),0)));
1555: v_plan_element_rec.period_type := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'PeriodType'),0)));
1556: -- New Column added to cn_quotas table in R12+
1557: v_plan_element_rec.sreps_enddated_flag := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'SalesrepsEnddatedFlag'),0)));
1558: -- Liability and Expense Account Information
1559: l_expense_acc_desc := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'ExpenseAccountDesc'),0)));
1560: l_liability_acc_desc := dbms_xmldom.getNodeValue(dbms_xmldom.getFirstChild(dbms_xmldom.item(dbms_xmldom.getChildrenByTagName(v_element_cast,'LiabilityAccountDesc'),0)));

Line 2164: FROM cn_quotas_v

2160: COMMIT;
2161: -- New value of plan element for Interdependent cases
2162: g_miss_pe_exp_rec.new_pe_name := v_plan_element_rec.name;
2163: SELECT COUNT(name) INTO l_new_pe_name
2164: FROM cn_quotas_v
2165: WHERE name = v_plan_element_rec.name;
2166: IF l_new_pe_name > 0 THEN
2167: SELECT quota_id INTO g_miss_pe_exp_rec.new_pe_id
2168: FROM cn_quotas_v

Line 2168: FROM cn_quotas_v

2164: FROM cn_quotas_v
2165: WHERE name = v_plan_element_rec.name;
2166: IF l_new_pe_name > 0 THEN
2167: SELECT quota_id INTO g_miss_pe_exp_rec.new_pe_id
2168: FROM cn_quotas_v
2169: WHERE name = v_plan_element_rec.name;
2170: l_pe_counter := l_pe_counter + 1;
2171: g_miss_pe_exp_tbl(l_pe_counter).old_pe_name := g_miss_pe_exp_rec.old_pe_name;
2172: g_miss_pe_exp_tbl(l_pe_counter).old_pe_id := g_miss_pe_exp_rec.old_pe_id;

Line 2363: FROM cn_quotas_v

2359:
2360: -- Check if PE exists in the Target System
2361: l_pe_name_count := 0;
2362: SELECT count(name) INTO l_pe_name_count
2363: FROM cn_quotas_v
2364: WHERE name = v_quota_assign_tbl(i).name;
2365: IF l_pe_name_count > 0 THEN
2366: SELECT quota_id,start_date,end_date
2367: INTO v_quota_assign_tbl(i).quota_id,v_quota_assign_tbl(i).start_date, v_quota_assign_tbl(i).end_date

Line 2368: FROM cn_quotas_v

2364: WHERE name = v_quota_assign_tbl(i).name;
2365: IF l_pe_name_count > 0 THEN
2366: SELECT quota_id,start_date,end_date
2367: INTO v_quota_assign_tbl(i).quota_id,v_quota_assign_tbl(i).start_date, v_quota_assign_tbl(i).end_date
2368: FROM cn_quotas_v
2369: WHERE name = v_quota_assign_tbl(i).name
2370: AND org_id = p_org_id;
2371: ELSE
2372: ROLLBACK TO Create_CompPlan;