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_PLAN_ELEMENT_PVT dependencies on CN_CALC_FORMULAS

Line 349: SELECT NAME INTO l_temp_old FROM CN_CALC_FORMULAS

345: IF (p_plan_element_old.quota_type_code = 'FORMULA') THEN
346: IF (p_plan_element_old.calc_formula_id IS NULL) THEN
347: l_temp_old := '';
348: ELSE
349: SELECT NAME INTO l_temp_old FROM CN_CALC_FORMULAS
350: WHERE CALC_FORMULA_ID = p_plan_element_old.calc_formula_id;
351: END IF;
352: ELSE
353: l_temp_old := p_plan_element_old.package_name;

Line 356: SELECT NAME INTO l_temp_new FROM CN_CALC_FORMULAS

352: ELSE
353: l_temp_old := p_plan_element_old.package_name;
354: END IF;
355: IF (p_plan_element_new.quota_type_code = 'FORMULA') THEN
356: SELECT NAME INTO l_temp_new FROM CN_CALC_FORMULAS
357: WHERE CALC_FORMULA_ID = p_plan_element_new.calc_formula_id;
358: ELSE
359: l_temp_new := p_plan_element_new.package_name;
360: END IF;

Line 1379: l_calc_formula_name cn_calc_formulas.NAME%TYPE := NULL;

1375: l_api_version CONSTANT NUMBER := 1.0;
1376: l_temp_count NUMBER;
1377: l_loading_status VARCHAR2 (50);
1378: l_credit_type_name cn_credit_types.NAME%TYPE := NULL;
1379: l_calc_formula_name cn_calc_formulas.NAME%TYPE := NULL;
1380: l_interval_type_name cn_interval_types.NAME%TYPE := NULL;
1381: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;
1382: g_last_update_date DATE := SYSDATE;
1383: g_last_updated_by NUMBER := fnd_global.user_id;

Line 1381: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;

1377: l_loading_status VARCHAR2 (50);
1378: l_credit_type_name cn_credit_types.NAME%TYPE := NULL;
1379: l_calc_formula_name cn_calc_formulas.NAME%TYPE := NULL;
1380: l_interval_type_name cn_interval_types.NAME%TYPE := NULL;
1381: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;
1382: g_last_update_date DATE := SYSDATE;
1383: g_last_updated_by NUMBER := fnd_global.user_id;
1384: g_creation_date DATE := SYSDATE;
1385: g_created_by NUMBER := fnd_global.user_id;

Line 1644: cn_calc_formulas ccf

1640: )
1641: IS
1642: SELECT ccf.number_dim
1643: FROM cn_quotas_v cq,
1644: cn_calc_formulas ccf
1645: WHERE cq.quota_id = l_quota_id AND cq.calc_formula_id = ccf.calc_formula_id;
1646:
1647: CURSOR c_srp_period_quota_csr (
1648: pe_quota_id cn_quotas.quota_id%TYPE

Line 1669: l_calc_formula_name cn_calc_formulas.NAME%TYPE := NULL;

1665: l_la_ccid NUMBER (15);
1666: l_ea_ccid NUMBER (15);
1667: l_payeechk NUMBER;
1668: l_credit_type_name cn_credit_types.NAME%TYPE := NULL;
1669: l_calc_formula_name cn_calc_formulas.NAME%TYPE := NULL;
1670: l_interval_type_name cn_interval_types.NAME%TYPE := NULL;
1671: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;
1672: l_number_dim_old NUMBER;
1673: l_number_dim_new NUMBER;

Line 1671: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;

1667: l_payeechk NUMBER;
1668: l_credit_type_name cn_credit_types.NAME%TYPE := NULL;
1669: l_calc_formula_name cn_calc_formulas.NAME%TYPE := NULL;
1670: l_interval_type_name cn_interval_types.NAME%TYPE := NULL;
1671: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;
1672: l_number_dim_old NUMBER;
1673: l_number_dim_new NUMBER;
1674: l_number_dim NUMBER;
1675: s_tot_target NUMBER;

Line 1874: FROM cn_calc_formulas

1870: ELSIF p_plan_element.calc_formula_id <> l_old_plan_element.calc_formula_id
1871: THEN
1872: SELECT number_dim
1873: INTO l_number_dim_old
1874: FROM cn_calc_formulas
1875: WHERE calc_formula_id = l_old_plan_element.calc_formula_id;
1876:
1877: SELECT number_dim
1878: INTO l_number_dim_new

Line 1879: FROM cn_calc_formulas

1875: WHERE calc_formula_id = l_old_plan_element.calc_formula_id;
1876:
1877: SELECT number_dim
1878: INTO l_number_dim_new
1879: FROM cn_calc_formulas
1880: WHERE calc_formula_id = p_plan_element.calc_formula_id;
1881:
1882: IF l_number_dim_new <> l_number_dim_old
1883: THEN

Line 2150: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;

2146: AND (qru.start_date < p_start_date OR (p_end_date IS NOT NULL AND qru.end_date IS NULL) OR qru.end_date > p_end_date);
2147:
2148: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_Plan_Element';
2149: l_api_version CONSTANT NUMBER := 1.0;
2150: l_formula_type cn_calc_formulas.formula_type%TYPE := NULL;
2151: l_temp_count NUMBER;
2152: l_quota_id NUMBER;
2153: l_payeechk NUMBER;
2154: l_uplift_dt_range NUMBER; --Added by hanaraya for bug 6505174

Line 2629: x_formula_name cn_calc_formulas.NAME%TYPE;

2625: factor_rec factors%ROWTYPE;
2626: key_factor_total NUMBER := 0;
2627: rule_rec rules%ROWTYPE;
2628: recinfo rt_quota_asgns_curs%ROWTYPE;
2629: x_formula_name cn_calc_formulas.NAME%TYPE;
2630: x_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2631: l_tmp NUMBER;
2632: l_plan_name cn_comp_plans.NAME%TYPE;
2633: l_plan_element plan_element_rec_type;

Line 2630: x_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

2626: key_factor_total NUMBER := 0;
2627: rule_rec rules%ROWTYPE;
2628: recinfo rt_quota_asgns_curs%ROWTYPE;
2629: x_formula_name cn_calc_formulas.NAME%TYPE;
2630: x_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
2631: l_tmp NUMBER;
2632: l_plan_name cn_comp_plans.NAME%TYPE;
2633: l_plan_element plan_element_rec_type;
2634: g_incomplete VARCHAR2 (30) := 'INCOMPLETE';

Line 2687: cn_calc_formulas cf

2683: q.calc_formula_id
2684: INTO x_formula_name,
2685: x_calc_formula_id
2686: FROM cn_quotas q,
2687: cn_calc_formulas cf
2688: WHERE q.quota_id = p_quota_id AND q.calc_formula_id = cf.calc_formula_id(+) AND q.quota_type_code IN ('EXTERNAL', 'FORMULA');
2689:
2690: IF l_plan_element.quota_type_code IN ('FORMULA', 'EXTERNAL')
2691: THEN