APPS.CN_RULEATTRIBUTE_PVT dependencies on DBMS_SQL

Line 1655: l_cursor_num := dbms_sql.open_cursor;

1651: l_select_stmt := 'Select ' || x_select ||
1652: ' from ' || x_from ||
1653: ' ' || x_where ;
1654:
1655: l_cursor_num := dbms_sql.open_cursor;
1656: dbms_sql.parse(l_cursor_num,l_select_stmt,2);
1657: l_ret := dbms_sql.execute(l_cursor_num);
1658: EXCEPTION
1659: WHEN OTHERS THEN

Line 1656: dbms_sql.parse(l_cursor_num,l_select_stmt,2);

1652: ' from ' || x_from ||
1653: ' ' || x_where ;
1654:
1655: l_cursor_num := dbms_sql.open_cursor;
1656: dbms_sql.parse(l_cursor_num,l_select_stmt,2);
1657: l_ret := dbms_sql.execute(l_cursor_num);
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: x_select := ' 1 column_id , 2 column_name ';

Line 1657: l_ret := dbms_sql.execute(l_cursor_num);

1653: ' ' || x_where ;
1654:
1655: l_cursor_num := dbms_sql.open_cursor;
1656: dbms_sql.parse(l_cursor_num,l_select_stmt,2);
1657: l_ret := dbms_sql.execute(l_cursor_num);
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: x_select := ' 1 column_id , 2 column_name ';
1661: x_from := ' dual ';

Line 1665: dbms_sql.close_cursor(l_cursor_num);

1661: x_from := ' dual ';
1662: x_where := ' 1 = 2 ';
1663:
1664: END ;
1665: dbms_sql.close_cursor(l_cursor_num);
1666:
1667: CLOSE c_get_valueset_id;
1668:
1669: ELSE