APPS.HR_DM_DOWNLOAD dependencies on DBMS_SQL

Line 196: l_cursor := dbms_sql.open_cursor;

192:
193: hr_dm_utility.message('INFO','Call to TDS ' || l_string , 6);
194: -- bind variables
195:
196: l_cursor := dbms_sql.open_cursor;
197: hr_dm_utility.message('INFO','Open dynamic cursor ' , 7);
198:
199: dbms_sql.parse(l_cursor, l_string, dbms_sql.native);
200:

Line 199: dbms_sql.parse(l_cursor, l_string, dbms_sql.native);

195:
196: l_cursor := dbms_sql.open_cursor;
197: hr_dm_utility.message('INFO','Open dynamic cursor ' , 7);
198:
199: dbms_sql.parse(l_cursor, l_string, dbms_sql.native);
200:
201: hr_dm_utility.message('INFO','Bind dynamic var ' , 8);
202: -- bind the out variable of the download procedure.
203: dbms_sql.bind_variable(l_cursor,':l_no_of_rec_downloaded',20);

Line 203: dbms_sql.bind_variable(l_cursor,':l_no_of_rec_downloaded',20);

199: dbms_sql.parse(l_cursor, l_string, dbms_sql.native);
200:
201: hr_dm_utility.message('INFO','Bind dynamic var ' , 8);
202: -- bind the out variable of the download procedure.
203: dbms_sql.bind_variable(l_cursor,':l_no_of_rec_downloaded',20);
204:
205: hr_dm_utility.message('INFO','Get return value ' , 9);
206: l_return_value := dbms_sql.execute(l_cursor);
207:

Line 206: l_return_value := dbms_sql.execute(l_cursor);

202: -- bind the out variable of the download procedure.
203: dbms_sql.bind_variable(l_cursor,':l_no_of_rec_downloaded',20);
204:
205: hr_dm_utility.message('INFO','Get return value ' , 9);
206: l_return_value := dbms_sql.execute(l_cursor);
207:
208: hr_dm_utility.message('INFO','Get variable value ' , 10);
209: -- get the value of the download procedure.
210: dbms_sql.variable_value(l_cursor,

Line 210: dbms_sql.variable_value(l_cursor,

206: l_return_value := dbms_sql.execute(l_cursor);
207:
208: hr_dm_utility.message('INFO','Get variable value ' , 10);
209: -- get the value of the download procedure.
210: dbms_sql.variable_value(l_cursor,
211: ':l_no_of_rec_downloaded',
212: l_no_of_rec_downloaded);
213:
214: hr_dm_utility.message('INFO','Close dynamic variable ' , 10);

Line 216: dbms_sql.close_cursor(l_cursor);

212: l_no_of_rec_downloaded);
213:
214: hr_dm_utility.message('INFO','Close dynamic variable ' , 10);
215: -- close the cursor.
216: dbms_sql.close_cursor(l_cursor);
217:
218: -- update the no of records downloaded for the range.
219: update hr_dm_migration_ranges
220: set row_count = l_no_of_rec_downloaded