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_INTERVAL_TYPES

Line 291: select NAME into l_temp_old from CN_INTERVAL_TYPES

287: -- CHECK IF INTERVAL TYPE WAS UPDATED
288: IF (p_plan_element_old.interval_type_id <> p_plan_element_new.interval_type_id) THEN
289: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_INTTYPE_UPDATE');
290: l_plan_element_id := p_plan_element_new.quota_id;
291: select NAME into l_temp_old from CN_INTERVAL_TYPES
292: where interval_type_id = p_plan_element_old.interval_type_id
293: and org_id = p_plan_element_old.org_id;
294: select NAME into l_temp_new from CN_INTERVAL_TYPES
295: where interval_type_id = p_plan_element_new.interval_type_id

Line 294: select NAME into l_temp_new from CN_INTERVAL_TYPES

290: l_plan_element_id := p_plan_element_new.quota_id;
291: select NAME into l_temp_old from CN_INTERVAL_TYPES
292: where interval_type_id = p_plan_element_old.interval_type_id
293: and org_id = p_plan_element_old.org_id;
294: select NAME into l_temp_new from CN_INTERVAL_TYPES
295: where interval_type_id = p_plan_element_new.interval_type_id
296: and org_id = p_plan_element_new.org_id;
297: fnd_message.set_token('PE_OLD_INTERVAL', l_temp_old);
298: fnd_message.set_token('PE_NEW_INTERVAL', l_temp_new);

Line 1061: FROM cn_interval_types

1057: IF (p_plan_element.interval_type_id IS NOT NULL)
1058: THEN
1059: SELECT COUNT (*)
1060: INTO l_tmp_exist
1061: FROM cn_interval_types
1062: WHERE interval_type_id = p_plan_element.interval_type_id AND org_id = p_plan_element.org_id;
1063:
1064: -- FROM:chk_pe_required Check interval_type_id can not be missing or NULL
1065: IF (l_tmp_exist = 0)

Line 1380: l_interval_type_name cn_interval_types.NAME%TYPE := NULL;

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;
1384: g_creation_date DATE := SYSDATE;

Line 1670: l_interval_type_name cn_interval_types.NAME%TYPE := NULL;

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;
1674: l_number_dim NUMBER;