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_RATE_DIMENSIONS_PVT dependencies on CN_CALC_SQL_EXPS

Line 23: WHERE NOT exists (SELECT 1 FROM cn_calc_sql_exps WHERE calc_sql_exp_id = p_calc_sql_exp_id)

19:
20: CURSOR exp_info(p_calc_sql_exp_id NUMBER) IS
21: SELECT 0
22: FROM dual
23: WHERE NOT exists (SELECT 1 FROM cn_calc_sql_exps WHERE calc_sql_exp_id = p_calc_sql_exp_id)
24: UNION ALL
25: SELECT 1
26: FROM cn_calc_sql_exps
27: WHERE calc_sql_exp_id = p_calc_sql_exp_id

Line 26: FROM cn_calc_sql_exps

22: FROM dual
23: WHERE NOT exists (SELECT 1 FROM cn_calc_sql_exps WHERE calc_sql_exp_id = p_calc_sql_exp_id)
24: UNION ALL
25: SELECT 1
26: FROM cn_calc_sql_exps
27: WHERE calc_sql_exp_id = p_calc_sql_exp_id
28: AND exp_type_code like '%DDT%'
29: UNION ALL
30: SELECT 2

Line 31: FROM cn_calc_sql_exps

27: WHERE calc_sql_exp_id = p_calc_sql_exp_id
28: AND exp_type_code like '%DDT%'
29: UNION ALL
30: SELECT 2
31: FROM cn_calc_sql_exps
32: WHERE calc_sql_exp_id = p_calc_sql_exp_id
33: AND (exp_type_code IS NULL OR exp_type_code NOT LIKE '%DDT%');
34:
35: CURSOR name_exists IS

Line 108: -- foreign keys to cn_calc_sql_exps

104: END LOOP;
105: END IF;
106:
107: -- if p_dim_unit_code is EXPRESSION, min_exp_id and max_exp_id should be
108: -- foreign keys to cn_calc_sql_exps
109: -- and exp_type_code should be available for dynamic dimensions
110: IF (p_dim_unit_code = 'EXPRESSION' AND p_tiers_tbl.COUNT > 0) THEN
111: FOR i IN p_tiers_tbl.first..p_tiers_tbl.last LOOP
112: OPEN exp_info(p_tiers_tbl(i).min_exp_id);

Line 959: select name into l_from from cn_calc_sql_exps

955: fnd_message.set_token('TO', l_to);
956: end if;
957: if (l_old_rec.min_exp_id is NOT NULL AND l_old_rec.max_exp_id is NOT NULL)
958: then
959: select name into l_from from cn_calc_sql_exps
960: where calc_sql_exp_id = l_old_rec.min_exp_id;
961: select name into l_to from cn_calc_sql_exps
962: where calc_sql_exp_id = l_old_rec.max_exp_id;
963: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');

Line 961: select name into l_to from cn_calc_sql_exps

957: if (l_old_rec.min_exp_id is NOT NULL AND l_old_rec.max_exp_id is NOT NULL)
958: then
959: select name into l_from from cn_calc_sql_exps
960: where calc_sql_exp_id = l_old_rec.min_exp_id;
961: select name into l_to from cn_calc_sql_exps
962: where calc_sql_exp_id = l_old_rec.max_exp_id;
963: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_DELETE');
964: fnd_message.set_token('FROM', l_from);
965: fnd_message.set_token('TO', l_to);

Line 1179: select name into l_from_old from cn_calc_sql_exps

1175: fnd_message.set_token('NEW_TO', l_to_new);
1176: end if;
1177: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)
1178: then
1179: select name into l_from_old from cn_calc_sql_exps
1180: where calc_sql_exp_id = l_old_rec.min_exp_id;
1181: select name into l_to_old from cn_calc_sql_exps
1182: where calc_sql_exp_id = l_old_rec.max_exp_id;
1183: select name into l_from_new from cn_calc_sql_exps

Line 1181: select name into l_to_old from cn_calc_sql_exps

1177: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)
1178: then
1179: select name into l_from_old from cn_calc_sql_exps
1180: where calc_sql_exp_id = l_old_rec.min_exp_id;
1181: select name into l_to_old from cn_calc_sql_exps
1182: where calc_sql_exp_id = l_old_rec.max_exp_id;
1183: select name into l_from_new from cn_calc_sql_exps
1184: where calc_sql_exp_id = p_min_exp_id;
1185: select name into l_to_new from cn_calc_sql_exps

Line 1183: select name into l_from_new from cn_calc_sql_exps

1179: select name into l_from_old from cn_calc_sql_exps
1180: where calc_sql_exp_id = l_old_rec.min_exp_id;
1181: select name into l_to_old from cn_calc_sql_exps
1182: where calc_sql_exp_id = l_old_rec.max_exp_id;
1183: select name into l_from_new from cn_calc_sql_exps
1184: where calc_sql_exp_id = p_min_exp_id;
1185: select name into l_to_new from cn_calc_sql_exps
1186: where calc_sql_exp_id = p_max_exp_id;
1187: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');

Line 1185: select name into l_to_new from cn_calc_sql_exps

1181: select name into l_to_old from cn_calc_sql_exps
1182: where calc_sql_exp_id = l_old_rec.max_exp_id;
1183: select name into l_from_new from cn_calc_sql_exps
1184: where calc_sql_exp_id = p_min_exp_id;
1185: select name into l_to_new from cn_calc_sql_exps
1186: where calc_sql_exp_id = p_max_exp_id;
1187: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_UPDATE');
1188: fnd_message.set_token('OLD_FROM', l_from_old);
1189: fnd_message.set_token('OLD_TO', l_to_old);

Line 1401: select name into l_from from cn_calc_sql_exps

1397: fnd_message.set_token('TO', l_to);
1398: end if;
1399: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)
1400: then
1401: select name into l_from from cn_calc_sql_exps
1402: where calc_sql_exp_id = p_min_exp_id;
1403: select name into l_to from cn_calc_sql_exps
1404: where calc_sql_exp_id = p_max_exp_id;
1405: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');

Line 1403: select name into l_to from cn_calc_sql_exps

1399: if (p_min_exp_id is NOT NULL AND p_max_exp_id is NOT NULL)
1400: then
1401: select name into l_from from cn_calc_sql_exps
1402: where calc_sql_exp_id = p_min_exp_id;
1403: select name into l_to from cn_calc_sql_exps
1404: where calc_sql_exp_id = p_max_exp_id;
1405: fnd_message.set_name('CN', 'CNR12_NOTE_RT_DIM_TI_CREATE');
1406: fnd_message.set_token('FROM', l_from);
1407: fnd_message.set_token('TO', l_to);