APPS.PAY_PYUCSLIS_PKG dependencies on DBMS_SQL

Line 1189: l_cursor_id := dbms_sql.open_cursor;

1185: j number(10):=1;
1186: i number(10):=50;
1187: BEGIN
1188: hr_utility.set_location('Entering execute_statement',10);
1189: l_cursor_id := dbms_sql.open_cursor;
1190: fnd_dsql.set_cursor(l_cursor_id);
1191:
1192: l_dsql_text := fnd_dsql.get_text(FALSE);
1193: l_num := length(l_dsql_text);

Line 1204: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);

1200: -- dbms_output.put_line(substr(l_dsql_text,i));
1201: j := j+50;
1202: end loop;
1203: */
1204: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
1205: hr_utility.set_location('after parse',10);
1206: fnd_dsql.do_binds;
1207: hr_utility.set_location('after bind',10);
1208: l_num_of_rows := dbms_sql.execute(l_cursor_id);

Line 1208: l_num_of_rows := dbms_sql.execute(l_cursor_id);

1204: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
1205: hr_utility.set_location('after parse',10);
1206: fnd_dsql.do_binds;
1207: hr_utility.set_location('after bind',10);
1208: l_num_of_rows := dbms_sql.execute(l_cursor_id);
1209: hr_utility.set_location('after execuate ',10);
1210: dbms_sql.close_cursor(l_cursor_id);
1211: hr_utility.set_location('Leaveing execute_statement',10);
1212: END execute_statement;

Line 1210: dbms_sql.close_cursor(l_cursor_id);

1206: fnd_dsql.do_binds;
1207: hr_utility.set_location('after bind',10);
1208: l_num_of_rows := dbms_sql.execute(l_cursor_id);
1209: hr_utility.set_location('after execuate ',10);
1210: dbms_sql.close_cursor(l_cursor_id);
1211: hr_utility.set_location('Leaveing execute_statement',10);
1212: END execute_statement;
1213:
1214: /*-- for the bug 5214715 --*/