APPS.IGW_PROPOSAL_APPROVAL dependencies on DBMS_SQL

Line 1031: l_cursor_name := dbms_sql.open_cursor;

1027: l_dummy_one number(1);
1028:
1029: begin
1030:
1031: l_cursor_name := dbms_sql.open_cursor;
1032: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1033: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1034: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1035: dbms_sql.close_cursor(l_cursor_name);

Line 1032: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);

1028:
1029: begin
1030:
1031: l_cursor_name := dbms_sql.open_cursor;
1032: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1033: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1034: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1035: dbms_sql.close_cursor(l_cursor_name);
1036: if l_rows_fetched = 0 then

Line 1033: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);

1029: begin
1030:
1031: l_cursor_name := dbms_sql.open_cursor;
1032: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1033: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1034: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1035: dbms_sql.close_cursor(l_cursor_name);
1036: if l_rows_fetched = 0 then
1037: return '1=2';

Line 1034: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);

1030:
1031: l_cursor_name := dbms_sql.open_cursor;
1032: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1033: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1034: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1035: dbms_sql.close_cursor(l_cursor_name);
1036: if l_rows_fetched = 0 then
1037: return '1=2';
1038: else

Line 1035: dbms_sql.close_cursor(l_cursor_name);

1031: l_cursor_name := dbms_sql.open_cursor;
1032: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1033: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1034: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1035: dbms_sql.close_cursor(l_cursor_name);
1036: if l_rows_fetched = 0 then
1037: return '1=2';
1038: else
1039: return '1=1';