APPS.PAY_PYUCSLIS_PKG dependencies on DBMS_SQL

Line 989: l_cursor_id := dbms_sql.open_cursor;

985: j number(10):=1;
986: i number(10):=50;
987: BEGIN
988: hr_utility.set_location('Entering execute_statement',10);
989: l_cursor_id := dbms_sql.open_cursor;
990: fnd_dsql.set_cursor(l_cursor_id);
991:
992: l_dsql_text := fnd_dsql.get_text(FALSE);
993: l_num := length(l_dsql_text);

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

1000: -- dbms_output.put_line(substr(l_dsql_text,i));
1001: j := j+50;
1002: end loop;
1003: */
1004: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
1005: hr_utility.set_location('after parse',10);
1006: fnd_dsql.do_binds;
1007: hr_utility.set_location('after bind',10);
1008: l_num_of_rows := dbms_sql.execute(l_cursor_id);

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

1004: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
1005: hr_utility.set_location('after parse',10);
1006: fnd_dsql.do_binds;
1007: hr_utility.set_location('after bind',10);
1008: l_num_of_rows := dbms_sql.execute(l_cursor_id);
1009: hr_utility.set_location('after execuate ',10);
1010: dbms_sql.close_cursor(l_cursor_id);
1011: hr_utility.set_location('Leaveing execute_statement',10);
1012: END execute_statement;

Line 1010: dbms_sql.close_cursor(l_cursor_id);

1006: fnd_dsql.do_binds;
1007: hr_utility.set_location('after bind',10);
1008: l_num_of_rows := dbms_sql.execute(l_cursor_id);
1009: hr_utility.set_location('after execuate ',10);
1010: dbms_sql.close_cursor(l_cursor_id);
1011: hr_utility.set_location('Leaveing execute_statement',10);
1012: END execute_statement;
1013:
1014: /*-- for the bug 5214715 --*/