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

Line 694: fnd_dsql.set_cursor (l_cursor_id);

690: IF l_sql_stmt IS NOT NULL THEN
691: --Included last two system letter codes as a part of bug 2376434
692:
693: l_cursor_id := DBMS_SQL.open_cursor;
694: fnd_dsql.set_cursor (l_cursor_id);
695: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);
696: fnd_dsql.do_binds;
697:
698: IF l_sys_ltr_code IN ('ADRESID',

Line 696: fnd_dsql.do_binds;

692:
693: l_cursor_id := DBMS_SQL.open_cursor;
694: fnd_dsql.set_cursor (l_cursor_id);
695: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);
696: fnd_dsql.do_binds;
697:
698: IF l_sys_ltr_code IN ('ADRESID',
699: 'FAADHOC',
700: 'ADADHOC',

Line 787: l_dsql_debug := fnd_dsql.get_text(TRUE);

783:
784: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);
785:
786: /*This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
787: l_dsql_debug := fnd_dsql.get_text(TRUE);
788: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
789: */
790: LOOP
791: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN

Line 1254: fnd_dsql.set_cursor (l_cursor_id);

1250: -- executing Dynamic SQL. Either received from build_sql_stmt procedure (for Admissions) or Pre_Process (for FAM related letters)
1251: IF l_sql_stmt IS NOT NULL THEN
1252: --Included last two system letter codes as a part of bug 2376434
1253: l_cursor_id := DBMS_SQL.open_cursor;
1254: fnd_dsql.set_cursor (l_cursor_id);
1255: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);
1256: fnd_dsql.do_binds;
1257:
1258: IF l_sys_ltr_code IN ('ADRESID',

Line 1256: fnd_dsql.do_binds;

1252: --Included last two system letter codes as a part of bug 2376434
1253: l_cursor_id := DBMS_SQL.open_cursor;
1254: fnd_dsql.set_cursor (l_cursor_id);
1255: DBMS_SQL.parse (l_cursor_id, l_sql_stmt, DBMS_SQL.native);
1256: fnd_dsql.do_binds;
1257:
1258: IF l_sys_ltr_code IN ('ADRESID',
1259: 'FAADHOC',
1260: 'ADADHOC',

Line 1347: l_dsql_debug := fnd_dsql.get_text(TRUE);

1343:
1344: l_num_of_rows := DBMS_SQL.EXECUTE (l_cursor_id);
1345:
1346: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
1347: l_dsql_debug := fnd_dsql.get_text(TRUE);
1348: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
1349: */
1350: LOOP
1351: IF DBMS_SQL.fetch_rows (l_cursor_id) > 0 THEN