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_AD_IMP_009 dependencies on FND_DSQL

Line 151: fnd_dsql.set_cursor(l_cursor_id);

147: IF x_lvcExactSelectClause <> 'PARTIAL_MATCH' THEN
148: -- Open the Dynamic Cursor with the select statement returned for Exact Match
149:
150: l_cursor_id := dbms_sql.open_cursor;
151: fnd_dsql.set_cursor(l_cursor_id);
152:
153: dbms_sql.parse(l_cursor_id, x_lvcExactSelectClause, dbms_sql.native);
154: fnd_dsql.do_binds;
155:

Line 154: fnd_dsql.do_binds;

150: l_cursor_id := dbms_sql.open_cursor;
151: fnd_dsql.set_cursor(l_cursor_id);
152:
153: dbms_sql.parse(l_cursor_id, x_lvcExactSelectClause, dbms_sql.native);
154: fnd_dsql.do_binds;
155:
156: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
157:
158: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

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

157:
158: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
159:
160: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.*/
161: l_dsql_debug := fnd_dsql.get_text(TRUE);
162:
163: LOOP
164: -- fetch a row
165: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN

Line 241: fnd_dsql.set_cursor(l_cursor_id1);

237: IF x_lvcPartialSelectClause IS NOT NULL THEN
238:
239: -- Execute the Dynamic SQL
240: l_cursor_id1 := dbms_sql.open_cursor;
241: fnd_dsql.set_cursor(l_cursor_id1);
242:
243: dbms_sql.parse(l_cursor_id1, x_lvcPartialSelectClause, dbms_sql.native);
244: fnd_dsql.do_binds;
245:

Line 244: fnd_dsql.do_binds;

240: l_cursor_id1 := dbms_sql.open_cursor;
241: fnd_dsql.set_cursor(l_cursor_id1);
242:
243: dbms_sql.parse(l_cursor_id1, x_lvcPartialSelectClause, dbms_sql.native);
244: fnd_dsql.do_binds;
245:
246: dbms_sql.define_column(l_cursor_id1, 1, l_person_id);
247:
248: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);

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

247:
248: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);
249:
250: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.*/
251: l_dsql_debug := fnd_dsql.get_text(TRUE);
252:
253: LOOP
254: -- fetch a row
255: IF dbms_sql.fetch_rows(l_cursor_id1) > 0 THEN

Line 418: fnd_dsql.set_cursor(l_cursor_id);

414:
415: IF x_lvcExactSelectClause <> 'PARTIAL_MATCH' THEN
416:
417: l_cursor_id := dbms_sql.open_cursor;
418: fnd_dsql.set_cursor(l_cursor_id);
419:
420: dbms_sql.parse(l_cursor_id, x_lvcExactSelectClause, dbms_sql.native);
421: fnd_dsql.do_binds;
422:

Line 421: fnd_dsql.do_binds;

417: l_cursor_id := dbms_sql.open_cursor;
418: fnd_dsql.set_cursor(l_cursor_id);
419:
420: dbms_sql.parse(l_cursor_id, x_lvcExactSelectClause, dbms_sql.native);
421: fnd_dsql.do_binds;
422:
423: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
424:
425: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

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

423: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
424:
425: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
426: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
427: l_dsql_debug := fnd_dsql.get_text(TRUE);
428: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
429: */
430: LOOP
431: -- fetch a row

Line 504: fnd_dsql.set_cursor(l_cursor_id1);

500: IF x_lvcPartialSelectClause IS NOT NULL THEN
501:
502: /* Exceute the Partial Select Clause */
503: l_cursor_id1 := dbms_sql.open_cursor;
504: fnd_dsql.set_cursor(l_cursor_id1);
505:
506: dbms_sql.parse(l_cursor_id1, x_lvcPartialSelectClause, dbms_sql.native);
507: fnd_dsql.do_binds;
508:

Line 507: fnd_dsql.do_binds;

503: l_cursor_id1 := dbms_sql.open_cursor;
504: fnd_dsql.set_cursor(l_cursor_id1);
505:
506: dbms_sql.parse(l_cursor_id1, x_lvcPartialSelectClause, dbms_sql.native);
507: fnd_dsql.do_binds;
508:
509: dbms_sql.define_column(l_cursor_id1, 1, l_person_id);
510:
511: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);

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

510:
511: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);
512:
513: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
514: l_dsql_debug := fnd_dsql.get_text(TRUE);
515: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
516: */
517:
518: LOOP

Line 731: fnd_dsql.set_cursor(l_cursor_id);

727: );
728:
729: IF x_lvcExactSelectClause <> 'PARTIAL_MATCH' THEN
730: l_cursor_id := dbms_sql.open_cursor;
731: fnd_dsql.set_cursor(l_cursor_id);
732:
733: dbms_sql.parse(l_cursor_id, x_lvcExactSelectClause, dbms_sql.native);
734: fnd_dsql.do_binds;
735:

Line 734: fnd_dsql.do_binds;

730: l_cursor_id := dbms_sql.open_cursor;
731: fnd_dsql.set_cursor(l_cursor_id);
732:
733: dbms_sql.parse(l_cursor_id, x_lvcExactSelectClause, dbms_sql.native);
734: fnd_dsql.do_binds;
735:
736: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
737:
738: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

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

736: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
737:
738: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
739: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
740: l_dsql_debug := fnd_dsql.get_text(TRUE);
741: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
742: */
743: LOOP
744: -- fetch a row

Line 842: fnd_dsql.set_cursor(l_cursor_id1);

838: IF x_lvcPartialSelectClause IS NOT NULL THEN
839:
840: /* Execute the Partial Select Clause */
841: l_cursor_id1 := dbms_sql.open_cursor;
842: fnd_dsql.set_cursor(l_cursor_id1);
843:
844: dbms_sql.parse(l_cursor_id1, x_lvcPartialSelectClause, dbms_sql.native);
845: fnd_dsql.do_binds;
846:

Line 845: fnd_dsql.do_binds;

841: l_cursor_id1 := dbms_sql.open_cursor;
842: fnd_dsql.set_cursor(l_cursor_id1);
843:
844: dbms_sql.parse(l_cursor_id1, x_lvcPartialSelectClause, dbms_sql.native);
845: fnd_dsql.do_binds;
846:
847: dbms_sql.define_column(l_cursor_id1, 1, l_person_id);
848:
849: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);

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

848:
849: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);
850:
851: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
852: l_dsql_debug := fnd_dsql.get_text(TRUE);
853: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
854: */
855: LOOP
856: -- fetch a row

Line 1091: fnd_dsql.set_cursor(l_cursor_id);

1087: );
1088:
1089: IF x_lvcExactSelectClause <> 'PARTIAL_MATCH' THEN
1090: l_cursor_id := dbms_sql.open_cursor;
1091: fnd_dsql.set_cursor(l_cursor_id);
1092:
1093: dbms_sql.parse(l_cursor_id, x_lvcExactSelectClause, dbms_sql.native);
1094: fnd_dsql.do_binds;
1095:

Line 1094: fnd_dsql.do_binds;

1090: l_cursor_id := dbms_sql.open_cursor;
1091: fnd_dsql.set_cursor(l_cursor_id);
1092:
1093: dbms_sql.parse(l_cursor_id, x_lvcExactSelectClause, dbms_sql.native);
1094: fnd_dsql.do_binds;
1095:
1096: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1097:
1098: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

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

1096: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1097:
1098: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1099: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
1100: l_dsql_debug := fnd_dsql.get_text(TRUE);
1101: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
1102: */
1103: LOOP
1104: -- fetch a row

Line 1206: fnd_dsql.set_cursor(l_cursor_id1);

1202:
1203: IF x_lvcPartialSelectClause IS NOT NULL THEN
1204: /* Exceute the Partial Select Clause */
1205: l_cursor_id1 := dbms_sql.open_cursor;
1206: fnd_dsql.set_cursor(l_cursor_id1);
1207:
1208: dbms_sql.parse(l_cursor_id1, x_lvcPartialSelectClause, dbms_sql.native);
1209: fnd_dsql.do_binds;
1210:

Line 1209: fnd_dsql.do_binds;

1205: l_cursor_id1 := dbms_sql.open_cursor;
1206: fnd_dsql.set_cursor(l_cursor_id1);
1207:
1208: dbms_sql.parse(l_cursor_id1, x_lvcPartialSelectClause, dbms_sql.native);
1209: fnd_dsql.do_binds;
1210:
1211: dbms_sql.define_column(l_cursor_id1, 1, l_person_id);
1212:
1213: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);

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

1212:
1213: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);
1214:
1215: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
1216: l_dsql_debug := fnd_dsql.get_text(TRUE);
1217: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
1218: */
1219: LOOP
1220: -- fetch a row