APPS.OKC_CONDITIONS_PVT dependencies on DBMS_SQL

Line 1488: l_cursor := DBMS_SQL.open_cursor;

1484: --return Y/N
1485:
1486: ------------------------------------------
1487: ------------------------------------------
1488: l_cursor := DBMS_SQL.open_cursor;
1489: ------------------------------------------
1490: ------------------------------------------
1491:
1492: OPEN cnl_cur;

Line 1498: DBMS_SQL.parse (l_cursor,l_string,DBMS_SQL.native);

1494: FETCH cnl_cur INTO cnl_rec;
1495: IF cnl_cur%NOTFOUND THEN
1496: IF line_found THEN
1497: -- open cursor and parse the string
1498: DBMS_SQL.parse (l_cursor,l_string,DBMS_SQL.native);
1499: DBMS_SQL.close_cursor(l_cursor);
1500: x_valid_flag := 'Y';
1501: EXIT;
1502: ELSE

Line 1499: DBMS_SQL.close_cursor(l_cursor);

1495: IF cnl_cur%NOTFOUND THEN
1496: IF line_found THEN
1497: -- open cursor and parse the string
1498: DBMS_SQL.parse (l_cursor,l_string,DBMS_SQL.native);
1499: DBMS_SQL.close_cursor(l_cursor);
1500: x_valid_flag := 'Y';
1501: EXIT;
1502: ELSE
1503: -- if there are no lines then set the flag to Y

Line 1526: DBMS_SQL.close_cursor(l_cursor);

1522: CLOSE cnl_cur;
1523:
1524: EXCEPTION
1525: WHEN OTHERS THEN
1526: DBMS_SQL.close_cursor(l_cursor);
1527: -- if the string is not valid then set the flag to N
1528: l_valid_flag := 'N';
1529: x_valid_flag := l_valid_flag;
1530: END valid_condition_lines;