APPS.IBE_DSP_SECTION_GRP dependencies on DBMS_SQL

Line 56: l_cursor := DBMS_SQL.open_cursor;

52: l_api_name CONSTANT VARCHAR2(30) := 'Is_SQL_Valid';
53: l_cursor NUMBER;
54: BEGIN
55:
56: l_cursor := DBMS_SQL.open_cursor;
57: BEGIN
58: DBMS_SQL.parse(l_cursor, p_sql_stmt, DBMS_SQL.NATIVE);
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: DBMS_SQL.close_cursor(l_cursor);

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

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

Line 60: DBMS_SQL.close_cursor(l_cursor);

56: l_cursor := DBMS_SQL.open_cursor;
57: BEGIN
58: DBMS_SQL.parse(l_cursor, p_sql_stmt, DBMS_SQL.NATIVE);
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: DBMS_SQL.close_cursor(l_cursor);
61: EXCEPTION
62: WHEN OTHERS THEN
63: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
64: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

Line 70: DBMS_SQL.close_cursor(l_cursor);

66: FND_MESSAGE.Set_Token('REASON', SQLERRM);
67: FND_MSG_PUB.Add;
68:
69: x_return_status := FND_API.G_RET_STS_ERROR;
70: DBMS_SQL.close_cursor(l_cursor);
71: END;
72:
73: END Is_SQL_Valid;
74: