APPS.CSC_PROFILE_CHECK_RULES_PVT dependencies on DBMS_SQL

Line 960: cursor_id := dbms_sql.open_cursor;

956: BEGIN
957: -- Initialize API return status to SUCCESS
958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959:
960: cursor_id := dbms_sql.open_cursor;
961: dbms_sql.parse(cursor_id,p_Sql_Stmnt,dbms_Sql.native);
962: dbms_sql.close_cursor(cursor_id);
963: EXCEPTION
964: WHEN OTHERS THEN

Line 961: dbms_sql.parse(cursor_id,p_Sql_Stmnt,dbms_Sql.native);

957: -- Initialize API return status to SUCCESS
958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959:
960: cursor_id := dbms_sql.open_cursor;
961: dbms_sql.parse(cursor_id,p_Sql_Stmnt,dbms_Sql.native);
962: dbms_sql.close_cursor(cursor_id);
963: EXCEPTION
964: WHEN OTHERS THEN
965: IF (dbms_sql.is_open(cursor_id)) THEN

Line 962: dbms_sql.close_cursor(cursor_id);

958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959:
960: cursor_id := dbms_sql.open_cursor;
961: dbms_sql.parse(cursor_id,p_Sql_Stmnt,dbms_Sql.native);
962: dbms_sql.close_cursor(cursor_id);
963: EXCEPTION
964: WHEN OTHERS THEN
965: IF (dbms_sql.is_open(cursor_id)) THEN
966: dbms_sql.close_cursor(cursor_id);

Line 965: IF (dbms_sql.is_open(cursor_id)) THEN

961: dbms_sql.parse(cursor_id,p_Sql_Stmnt,dbms_Sql.native);
962: dbms_sql.close_cursor(cursor_id);
963: EXCEPTION
964: WHEN OTHERS THEN
965: IF (dbms_sql.is_open(cursor_id)) THEN
966: dbms_sql.close_cursor(cursor_id);
967: END IF;
968: x_return_status := FND_API.G_RET_STS_SUCCESS;
969: END;

Line 966: dbms_sql.close_cursor(cursor_id);

962: dbms_sql.close_cursor(cursor_id);
963: EXCEPTION
964: WHEN OTHERS THEN
965: IF (dbms_sql.is_open(cursor_id)) THEN
966: dbms_sql.close_cursor(cursor_id);
967: END IF;
968: x_return_status := FND_API.G_RET_STS_SUCCESS;
969: END;
970: