APPS.IGW_PROP_APPROVALS_PVT dependencies on DBMS_SQL

Line 1019: l_cursor_name := dbms_sql.open_cursor;

1015: l_dummy_one number(1);
1016:
1017: begin
1018:
1019: l_cursor_name := dbms_sql.open_cursor;
1020: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1021: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1022: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1023: dbms_sql.close_cursor(l_cursor_name);

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

1016:
1017: begin
1018:
1019: l_cursor_name := dbms_sql.open_cursor;
1020: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1021: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1022: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1023: dbms_sql.close_cursor(l_cursor_name);
1024: if l_rows_fetched = 0 then

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

1017: begin
1018:
1019: l_cursor_name := dbms_sql.open_cursor;
1020: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1021: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1022: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1023: dbms_sql.close_cursor(l_cursor_name);
1024: if l_rows_fetched = 0 then
1025: return '1=2';

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

1018:
1019: l_cursor_name := dbms_sql.open_cursor;
1020: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1021: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1022: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1023: dbms_sql.close_cursor(l_cursor_name);
1024: if l_rows_fetched = 0 then
1025: return '1=2';
1026: else

Line 1023: dbms_sql.close_cursor(l_cursor_name);

1019: l_cursor_name := dbms_sql.open_cursor;
1020: dbms_sql.parse(l_cursor_name,p_select_stmt,dbms_sql.v7);
1021: dbms_sql.define_column(l_cursor_name,1,l_dummy_one);
1022: l_rows_fetched := dbms_sql.execute_and_fetch(l_cursor_name);
1023: dbms_sql.close_cursor(l_cursor_name);
1024: if l_rows_fetched = 0 then
1025: return '1=2';
1026: else
1027: return '1=1';