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_CREDIT_TYPES

Line 408: select name into l_temp_old from cn_credit_types_vl

404:
405: -- CHECK IF CREDIT TYPE WAS UPDATED
406: IF (p_plan_element_old.credit_type_id <> p_plan_element_new.credit_type_id) THEN
407: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_CRTYPE_UPDATE');
408: select name into l_temp_old from cn_credit_types_vl
409: where credit_type_id = p_plan_element_old.credit_type_id
410: and org_id = p_plan_element_old.org_id;
411: select name into l_temp_new from cn_credit_types_vl
412: where credit_type_id = p_plan_element_new.credit_type_id

Line 411: select name into l_temp_new from cn_credit_types_vl

407: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_CRTYPE_UPDATE');
408: select name into l_temp_old from cn_credit_types_vl
409: where credit_type_id = p_plan_element_old.credit_type_id
410: and org_id = p_plan_element_old.org_id;
411: select name into l_temp_new from cn_credit_types_vl
412: where credit_type_id = p_plan_element_new.credit_type_id
413: and org_id = p_plan_element_new.org_id;
414: fnd_message.set_token('PE_OLD_CREDIT', l_temp_old);
415: fnd_message.set_token('PE_NEW_CREDIT', l_temp_new);

Line 1041: FROM cn_credit_types

1037: IF (p_plan_element.credit_type_id IS NOT NULL)
1038: THEN
1039: SELECT COUNT (1)
1040: INTO l_tmp_exist
1041: FROM cn_credit_types
1042: WHERE credit_type_id = p_plan_element.credit_type_id AND org_id = p_plan_element.org_id;
1043:
1044: IF (l_tmp_exist = 0)
1045: THEN

Line 1378: l_credit_type_name cn_credit_types.NAME%TYPE := NULL;

1374: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Plan_Element';
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;

Line 1668: l_credit_type_name cn_credit_types.NAME%TYPE := NULL;

1664: l_ccid NUMBER (15);
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;