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.AP_WEB_AUDIT_LIST_VAL_PVT dependencies on DBMS_SQL

Line 252: cur_hdl := dbms_sql.open_cursor;

248: *===================================================================================*/
249: l_query_stmt := 'select distinct(person_id) from PER_ALL_PEOPLE_F '||l_where_clause;
250:
251: -- open cursor
252: cur_hdl := dbms_sql.open_cursor;
253:
254: -- parse cursor
255: dbms_sql.parse(cur_hdl, l_query_stmt,dbms_sql.native);
256:

Line 255: dbms_sql.parse(cur_hdl, l_query_stmt,dbms_sql.native);

251: -- open cursor
252: cur_hdl := dbms_sql.open_cursor;
253:
254: -- parse cursor
255: dbms_sql.parse(cur_hdl, l_query_stmt,dbms_sql.native);
256:
257: dbms_sql.bind_variable(cur_hdl, ':business_group_id', p_emp_rec.business_group_id);
258:
259: IF p_emp_rec.person_id IS NOT NULL THEN

Line 257: dbms_sql.bind_variable(cur_hdl, ':business_group_id', p_emp_rec.business_group_id);

253:
254: -- parse cursor
255: dbms_sql.parse(cur_hdl, l_query_stmt,dbms_sql.native);
256:
257: dbms_sql.bind_variable(cur_hdl, ':business_group_id', p_emp_rec.business_group_id);
258:
259: IF p_emp_rec.person_id IS NOT NULL THEN
260: dbms_sql.bind_variable(cur_hdl, ':person_id', p_emp_rec.person_id);
261: END IF;

Line 260: dbms_sql.bind_variable(cur_hdl, ':person_id', p_emp_rec.person_id);

256:
257: dbms_sql.bind_variable(cur_hdl, ':business_group_id', p_emp_rec.business_group_id);
258:
259: IF p_emp_rec.person_id IS NOT NULL THEN
260: dbms_sql.bind_variable(cur_hdl, ':person_id', p_emp_rec.person_id);
261: END IF;
262:
263: IF p_emp_rec.employee_number IS NOT NULL THEN
264: dbms_sql.bind_variable(cur_hdl, ':employee_number', p_emp_rec.employee_number);

Line 264: dbms_sql.bind_variable(cur_hdl, ':employee_number', p_emp_rec.employee_number);

260: dbms_sql.bind_variable(cur_hdl, ':person_id', p_emp_rec.person_id);
261: END IF;
262:
263: IF p_emp_rec.employee_number IS NOT NULL THEN
264: dbms_sql.bind_variable(cur_hdl, ':employee_number', p_emp_rec.employee_number);
265: END IF;
266:
267: IF p_emp_rec.national_identifier IS NOT NULL THEN
268: dbms_sql.bind_variable(cur_hdl, ':national_identifier', p_emp_rec.national_identifier);

Line 268: dbms_sql.bind_variable(cur_hdl, ':national_identifier', p_emp_rec.national_identifier);

264: dbms_sql.bind_variable(cur_hdl, ':employee_number', p_emp_rec.employee_number);
265: END IF;
266:
267: IF p_emp_rec.national_identifier IS NOT NULL THEN
268: dbms_sql.bind_variable(cur_hdl, ':national_identifier', p_emp_rec.national_identifier);
269: END IF;
270:
271: IF p_emp_rec.email_address IS NOT NULL THEN
272: dbms_sql.bind_variable(cur_hdl, ':email_address', p_emp_rec.email_address);

Line 272: dbms_sql.bind_variable(cur_hdl, ':email_address', p_emp_rec.email_address);

268: dbms_sql.bind_variable(cur_hdl, ':national_identifier', p_emp_rec.national_identifier);
269: END IF;
270:
271: IF p_emp_rec.email_address IS NOT NULL THEN
272: dbms_sql.bind_variable(cur_hdl, ':email_address', p_emp_rec.email_address);
273: END IF;
274:
275: dbms_sql.define_column(cur_hdl, 1, l_person_id);
276:

Line 275: dbms_sql.define_column(cur_hdl, 1, l_person_id);

271: IF p_emp_rec.email_address IS NOT NULL THEN
272: dbms_sql.bind_variable(cur_hdl, ':email_address', p_emp_rec.email_address);
273: END IF;
274:
275: dbms_sql.define_column(cur_hdl, 1, l_person_id);
276:
277: -- execute cursor
278: rows_processed := dbms_sql.execute(cur_hdl);
279:

Line 278: rows_processed := dbms_sql.execute(cur_hdl);

274:
275: dbms_sql.define_column(cur_hdl, 1, l_person_id);
276:
277: -- execute cursor
278: rows_processed := dbms_sql.execute(cur_hdl);
279:
280:
281: /*==========================================================================*
282: | Loop through the results to find out whether multiple matches were found.|

Line 286: IF dbms_sql.fetch_rows(cur_hdl) > 0 then

282: | Loop through the results to find out whether multiple matches were found.|
283: *==========================================================================*/
284: LOOP
285: -- fetch a row
286: IF dbms_sql.fetch_rows(cur_hdl) > 0 then
287:
288: -- fetch columns from the row
289: dbms_sql.column_value(cur_hdl, 1, l_person_id);
290:

Line 289: dbms_sql.column_value(cur_hdl, 1, l_person_id);

285: -- fetch a row
286: IF dbms_sql.fetch_rows(cur_hdl) > 0 then
287:
288: -- fetch columns from the row
289: dbms_sql.column_value(cur_hdl, 1, l_person_id);
290:
291: l_counter := l_counter+1;
292:
293: IF l_counter >= 2 THEN

Line 304: dbms_sql.close_cursor(cur_hdl);

300:
301: END LOOP;
302:
303: -- close cursor
304: dbms_sql.close_cursor(cur_hdl);
305:
306: IF l_counter >= 2 THEN
307: /*======================================================================*
308: | Employee must be uniquelly identified, several matches were found. |