APPS.JTF_DSP_SECTION_GRP dependencies on DBMS_SQL

Line 55: l_cursor := DBMS_SQL.open_cursor;

51: IS
52: l_cursor NUMBER;
53: BEGIN
54:
55: l_cursor := DBMS_SQL.open_cursor;
56: BEGIN
57: DBMS_SQL.parse(l_cursor, p_sql_stmt, DBMS_SQL.NATIVE);
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: DBMS_SQL.close_cursor(l_cursor);

Line 57: DBMS_SQL.parse(l_cursor, p_sql_stmt, DBMS_SQL.NATIVE);

53: BEGIN
54:
55: l_cursor := DBMS_SQL.open_cursor;
56: BEGIN
57: DBMS_SQL.parse(l_cursor, p_sql_stmt, DBMS_SQL.NATIVE);
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: DBMS_SQL.close_cursor(l_cursor);
60: EXCEPTION
61: WHEN OTHERS THEN

Line 59: DBMS_SQL.close_cursor(l_cursor);

55: l_cursor := DBMS_SQL.open_cursor;
56: BEGIN
57: DBMS_SQL.parse(l_cursor, p_sql_stmt, DBMS_SQL.NATIVE);
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: DBMS_SQL.close_cursor(l_cursor);
60: EXCEPTION
61: WHEN OTHERS THEN
62: x_return_status := FND_API.G_RET_STS_ERROR;
63: DBMS_SQL.close_cursor(l_cursor);

Line 63: DBMS_SQL.close_cursor(l_cursor);

59: DBMS_SQL.close_cursor(l_cursor);
60: EXCEPTION
61: WHEN OTHERS THEN
62: x_return_status := FND_API.G_RET_STS_ERROR;
63: DBMS_SQL.close_cursor(l_cursor);
64: END;
65:
66: END Is_SQL_Valid;
67: