APPS.IGS_PE_DUP_PERSON dependencies on FND_DSQL

Line 136: fnd_dsql.set_cursor(l_ext_cursor);

132: lv_Do_Partial := 'Y';
133: IF l_Select_Clause IS NOT NULL AND l_Select_Clause <> 'PARTIAL_MATCH' THEN
134: BEGIN
135: l_ext_cursor := DBMS_SQL.OPEN_CURSOR;
136: fnd_dsql.set_cursor(l_ext_cursor);
137:
138: DBMS_SQL.PARSE (l_ext_cursor, l_Select_Clause, DBMS_SQL.V7);
139: fnd_dsql.do_binds;
140:

Line 139: fnd_dsql.do_binds;

135: l_ext_cursor := DBMS_SQL.OPEN_CURSOR;
136: fnd_dsql.set_cursor(l_ext_cursor);
137:
138: DBMS_SQL.PARSE (l_ext_cursor, l_Select_Clause, DBMS_SQL.V7);
139: fnd_dsql.do_binds;
140:
141: dbms_sql.define_column(l_ext_cursor, 1, l_person_id);
142:
143: lnRows := DBMS_SQL.EXECUTE (l_ext_cursor);

Line 208: fnd_dsql.set_cursor(l_ext_cursor);

204: -- Run the select statement using dynamic SQL to find the partial duplicate records.
205: IF l_Select_Clause IS NOT NULL THEN
206: BEGIN
207: l_Ext_Cursor := DBMS_SQL.OPEN_CURSOR;
208: fnd_dsql.set_cursor(l_ext_cursor);
209:
210: DBMS_SQL.PARSE (l_Ext_Cursor, l_Select_Clause, DBMS_SQL.V7);
211: fnd_dsql.do_binds;
212:

Line 211: fnd_dsql.do_binds;

207: l_Ext_Cursor := DBMS_SQL.OPEN_CURSOR;
208: fnd_dsql.set_cursor(l_ext_cursor);
209:
210: DBMS_SQL.PARSE (l_Ext_Cursor, l_Select_Clause, DBMS_SQL.V7);
211: fnd_dsql.do_binds;
212:
213: dbms_sql.define_column(l_ext_cursor, 1, l_person_id);
214:
215: lnRows := DBMS_SQL.EXECUTE (l_Ext_Cursor);