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_RT_QUOTA_ASGN_PVT dependencies on CN_QUOTAS

Line 44: FROM cn_quotas_all

40: org_id
41: INTO l_quota_start_date,
42: l_quota_end_date,
43: l_org_id
44: FROM cn_quotas_all
45: WHERE quota_id = p_quota_id;
46:
47: FOR rt_date IN rate_formula_date_curs
48: LOOP

Line 175: l_temp_new := 'CN_QUOTAS';

171: fnd_message.set_token('RT_TAB', l_temp_old);
172: fnd_message.set_token('ST_DT', p_rt_quota_asgn.start_date);
173: fnd_message.set_token('END_DT', p_rt_quota_asgn.end_date);
174: l_plan_element_id := p_rt_quota_asgn.quota_id;
175: l_temp_new := 'CN_QUOTAS';
176: END IF;
177: IF (p_operation = 'delete') THEN
178: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_RT_ASGN_DEL');
179: fnd_message.set_token('RT_TAB', l_temp_old);

Line 183: l_temp_new := 'CN_QUOTAS';

179: fnd_message.set_token('RT_TAB', l_temp_old);
180: fnd_message.set_token('ST_DATE', p_rt_quota_asgn.start_date);
181: fnd_message.set_token('END_DATE', p_rt_quota_asgn.end_date);
182: l_plan_element_id := p_rt_quota_asgn.quota_id;
183: l_temp_new := 'CN_QUOTAS';
184: END IF;
185: IF (p_operation = 'update') THEN
186: SELECT NAME INTO l_old_rt_name
187: FROM CN_RATE_SCHEDULES

Line 199: l_temp_new := 'CN_QUOTAS';

195: fnd_message.set_token('NEW_RT_TAB', l_temp_old);
196: fnd_message.set_token('NEW_ST_DT', p_rt_quota_asgn.start_date);
197: fnd_message.set_token('NEW_END_DT', p_rt_quota_asgn.end_date);
198: l_plan_element_id := p_rt_quota_asgn.quota_id;
199: l_temp_new := 'CN_QUOTAS';
200: END IF;
201:
202: l_note_msg := fnd_message.get;
203: jtf_notes_pub.create_note

Line 1184: l_formula_type CN_QUOTAS.QUOTA_TYPE_CODE%TYPE ;

1180: l_api_version CONSTANT NUMBER := 1.0;
1181: l_counter NUMBER;
1182: l_name VARCHAR2 (1000);
1183: l_loading_status VARCHAR2 (240);
1184: l_formula_type CN_QUOTAS.QUOTA_TYPE_CODE%TYPE ;
1185: l_formula_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1186: l_rate_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
1187: BEGIN
1188: -- Standard Start of API savepoint

Line 1256: FROM cn_quotas

1252: ELSE
1253: BEGIN
1254: SELECT name, quota_type_code
1255: INTO l_name , l_formula_type
1256: FROM cn_quotas
1257: WHERE quota_id = p_rt_quota_asgn.quota_id;
1258: EXCEPTION
1259: WHEN OTHERS
1260: THEN