APPS.IGS_PE_IDENTIFY_DUPS dependencies on DBMS_SQL

Line 869: l_cursor_id := dbms_sql.open_cursor;

865:
866: END IF;
867:
868: l_stmt := fnd_dsql.get_text(FALSE);
869: l_cursor_id := dbms_sql.open_cursor;
870: fnd_dsql.set_cursor(l_cursor_id);
871: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.native);
872: fnd_dsql.do_binds;
873:

Line 871: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.native);

867:
868: l_stmt := fnd_dsql.get_text(FALSE);
869: l_cursor_id := dbms_sql.open_cursor;
870: fnd_dsql.set_cursor(l_cursor_id);
871: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.native);
872: fnd_dsql.do_binds;
873:
874: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
875:

Line 874: dbms_sql.define_column(l_cursor_id, 1, l_person_id);

870: fnd_dsql.set_cursor(l_cursor_id);
871: dbms_sql.parse(l_cursor_id, l_stmt, dbms_sql.native);
872: fnd_dsql.do_binds;
873:
874: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
875:
876: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
877:
878: LOOP

Line 876: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

872: fnd_dsql.do_binds;
873:
874: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
875:
876: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
877:
878: LOOP
879:
880: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN

Line 880: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN

876: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
877:
878: LOOP
879:
880: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN
881: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
882: ELSE
883: EXIT;
884: END IF;

Line 881: dbms_sql.column_value(l_cursor_id, 1, l_person_id);

877:
878: LOOP
879:
880: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN
881: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
882: ELSE
883: EXIT;
884: END IF;
885: l_count := l_count + 1;