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.AMS_APPR_HIST_PKG dependencies on FND_DSQL

Line 201: FND_DSQL.init;

197: l_lines_csr NUMBER := NULL;
198: l_lines_sql VARCHAR2(10000) := NULL;
199: l_ignore NUMBER;
200: BEGIN
201: FND_DSQL.init;
202: FND_DSQL.add_text('DELETE /*+ index(AMS_APPROVAL_HISTORY,AMS_APPROVAL_HISTORY_N1) */ FROM ams_approval_history WHERE 1 = 1');
203:
204: if p_object_id is not null then
205: FND_DSQL.add_text(' AND object_id = ');

Line 202: FND_DSQL.add_text('DELETE /+ index(AMS_APPROVAL_HISTORY,AMS_APPROVAL_HISTORY_N1) / FROM ams_approval_history WHERE 1 = 1');

198: l_lines_sql VARCHAR2(10000) := NULL;
199: l_ignore NUMBER;
200: BEGIN
201: FND_DSQL.init;
202: FND_DSQL.add_text('DELETE /*+ index(AMS_APPROVAL_HISTORY,AMS_APPROVAL_HISTORY_N1) */ FROM ams_approval_history WHERE 1 = 1');
203:
204: if p_object_id is not null then
205: FND_DSQL.add_text(' AND object_id = ');
206: FND_DSQL.add_bind(p_object_id);

Line 205: FND_DSQL.add_text(' AND object_id = ');

201: FND_DSQL.init;
202: FND_DSQL.add_text('DELETE /*+ index(AMS_APPROVAL_HISTORY,AMS_APPROVAL_HISTORY_N1) */ FROM ams_approval_history WHERE 1 = 1');
203:
204: if p_object_id is not null then
205: FND_DSQL.add_text(' AND object_id = ');
206: FND_DSQL.add_bind(p_object_id);
207: elsif p_object_id = FND_API.G_MISS_NUM then
208: FND_DSQL.add_text(' AND object_id is null ');
209: else

Line 206: FND_DSQL.add_bind(p_object_id);

202: FND_DSQL.add_text('DELETE /*+ index(AMS_APPROVAL_HISTORY,AMS_APPROVAL_HISTORY_N1) */ FROM ams_approval_history WHERE 1 = 1');
203:
204: if p_object_id is not null then
205: FND_DSQL.add_text(' AND object_id = ');
206: FND_DSQL.add_bind(p_object_id);
207: elsif p_object_id = FND_API.G_MISS_NUM then
208: FND_DSQL.add_text(' AND object_id is null ');
209: else
210: Null;

Line 208: FND_DSQL.add_text(' AND object_id is null ');

204: if p_object_id is not null then
205: FND_DSQL.add_text(' AND object_id = ');
206: FND_DSQL.add_bind(p_object_id);
207: elsif p_object_id = FND_API.G_MISS_NUM then
208: FND_DSQL.add_text(' AND object_id is null ');
209: else
210: Null;
211: end if;
212:

Line 214: FND_DSQL.add_text(' AND object_type_code = ');

210: Null;
211: end if;
212:
213: if p_object_type_code is not null then
214: FND_DSQL.add_text(' AND object_type_code = ');
215: FND_DSQL.add_bind(p_object_type_code);
216: elsif p_object_type_code = FND_API.g_miss_char then
217: FND_DSQL.add_text(' AND object_type_code is null');
218: else

Line 215: FND_DSQL.add_bind(p_object_type_code);

211: end if;
212:
213: if p_object_type_code is not null then
214: FND_DSQL.add_text(' AND object_type_code = ');
215: FND_DSQL.add_bind(p_object_type_code);
216: elsif p_object_type_code = FND_API.g_miss_char then
217: FND_DSQL.add_text(' AND object_type_code is null');
218: else
219: Null;

Line 217: FND_DSQL.add_text(' AND object_type_code is null');

213: if p_object_type_code is not null then
214: FND_DSQL.add_text(' AND object_type_code = ');
215: FND_DSQL.add_bind(p_object_type_code);
216: elsif p_object_type_code = FND_API.g_miss_char then
217: FND_DSQL.add_text(' AND object_type_code is null');
218: else
219: Null;
220: end if;
221:

Line 223: FND_DSQL.add_text(' AND approval_type = ');

219: Null;
220: end if;
221:
222: if p_approval_type is not null then
223: FND_DSQL.add_text(' AND approval_type = ');
224: FND_DSQL.add_bind(p_approval_type);
225: elsif p_approval_type = FND_API.g_miss_char then
226: FND_DSQL.add_text(' AND approval_type is null');
227: else

Line 224: FND_DSQL.add_bind(p_approval_type);

220: end if;
221:
222: if p_approval_type is not null then
223: FND_DSQL.add_text(' AND approval_type = ');
224: FND_DSQL.add_bind(p_approval_type);
225: elsif p_approval_type = FND_API.g_miss_char then
226: FND_DSQL.add_text(' AND approval_type is null');
227: else
228: Null;

Line 226: FND_DSQL.add_text(' AND approval_type is null');

222: if p_approval_type is not null then
223: FND_DSQL.add_text(' AND approval_type = ');
224: FND_DSQL.add_bind(p_approval_type);
225: elsif p_approval_type = FND_API.g_miss_char then
226: FND_DSQL.add_text(' AND approval_type is null');
227: else
228: Null;
229: end if;
230:

Line 232: FND_DSQL.add_text(' AND sequence_num = ');

228: Null;
229: end if;
230:
231: if p_sequence_num is not null then
232: FND_DSQL.add_text(' AND sequence_num = ');
233: FND_DSQL.add_bind(p_sequence_num);
234: elsif p_sequence_num = FND_API.G_MISS_NUM then
235: FND_DSQL.add_text(' AND sequence_num is null');
236: else

Line 233: FND_DSQL.add_bind(p_sequence_num);

229: end if;
230:
231: if p_sequence_num is not null then
232: FND_DSQL.add_text(' AND sequence_num = ');
233: FND_DSQL.add_bind(p_sequence_num);
234: elsif p_sequence_num = FND_API.G_MISS_NUM then
235: FND_DSQL.add_text(' AND sequence_num is null');
236: else
237: Null;

Line 235: FND_DSQL.add_text(' AND sequence_num is null');

231: if p_sequence_num is not null then
232: FND_DSQL.add_text(' AND sequence_num = ');
233: FND_DSQL.add_bind(p_sequence_num);
234: elsif p_sequence_num = FND_API.G_MISS_NUM then
235: FND_DSQL.add_text(' AND sequence_num is null');
236: else
237: Null;
238: end if;
239:

Line 241: FND_DSQL.add_text(' AND object_version_num = ');

237: Null;
238: end if;
239:
240: if p_object_version_num is not null then
241: FND_DSQL.add_text(' AND object_version_num = ');
242: FND_DSQL.add_bind(p_object_version_num);
243: elsif p_object_version_num = FND_API.G_MISS_NUM then
244: FND_DSQL.add_text(' AND object_version_num is null');
245: else

Line 242: FND_DSQL.add_bind(p_object_version_num);

238: end if;
239:
240: if p_object_version_num is not null then
241: FND_DSQL.add_text(' AND object_version_num = ');
242: FND_DSQL.add_bind(p_object_version_num);
243: elsif p_object_version_num = FND_API.G_MISS_NUM then
244: FND_DSQL.add_text(' AND object_version_num is null');
245: else
246: Null;

Line 244: FND_DSQL.add_text(' AND object_version_num is null');

240: if p_object_version_num is not null then
241: FND_DSQL.add_text(' AND object_version_num = ');
242: FND_DSQL.add_bind(p_object_version_num);
243: elsif p_object_version_num = FND_API.G_MISS_NUM then
244: FND_DSQL.add_text(' AND object_version_num is null');
245: else
246: Null;
247: end if;
248:

Line 250: FND_DSQL.add_text(' AND action_code = ');

246: Null;
247: end if;
248:
249: if p_action_code is not null then
250: FND_DSQL.add_text(' AND action_code = ');
251: FND_DSQL.add_bind(p_action_code);
252: elsif p_action_code = FND_API.g_miss_char then
253: FND_DSQL.add_text(' AND action_code is null');
254: else

Line 251: FND_DSQL.add_bind(p_action_code);

247: end if;
248:
249: if p_action_code is not null then
250: FND_DSQL.add_text(' AND action_code = ');
251: FND_DSQL.add_bind(p_action_code);
252: elsif p_action_code = FND_API.g_miss_char then
253: FND_DSQL.add_text(' AND action_code is null');
254: else
255: Null;

Line 253: FND_DSQL.add_text(' AND action_code is null');

249: if p_action_code is not null then
250: FND_DSQL.add_text(' AND action_code = ');
251: FND_DSQL.add_bind(p_action_code);
252: elsif p_action_code = FND_API.g_miss_char then
253: FND_DSQL.add_text(' AND action_code is null');
254: else
255: Null;
256: end if;
257:

Line 259: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above

255: Null;
256: end if;
257:
258: l_lines_csr := DBMS_SQL.open_cursor;
259: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above
260:
261: FND_DSQL.set_cursor(l_lines_csr);
262: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
263:

Line 261: FND_DSQL.set_cursor(l_lines_csr);

257:
258: l_lines_csr := DBMS_SQL.open_cursor;
259: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above
260:
261: FND_DSQL.set_cursor(l_lines_csr);
262: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
263:
264: FND_DSQL.do_binds;
265:

Line 264: FND_DSQL.do_binds;

260:
261: FND_DSQL.set_cursor(l_lines_csr);
262: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
263:
264: FND_DSQL.do_binds;
265:
266: l_ignore := DBMS_SQL.execute(l_lines_csr);
267:
268: DBMS_SQL.CLOSE_CURSOR(l_lines_csr);