APPS.AST_SEARCH_RESULT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 86

      glb_search_result_tbl(x).last_updated_by := P_search_result_Rec.last_updated_by;

Line: 87

      glb_search_result_tbl(x).last_update_date := P_search_result_Rec.last_update_date;

Line: 88

      glb_search_result_tbl(x).last_update_login := P_search_result_Rec.last_update_login;

Line: 196

      x_search_result_Rec.last_updated_by := glb_search_result_tbl(p_count).last_updated_by;

Line: 197

      x_search_result_Rec.last_update_date := glb_search_result_tbl(p_count).last_update_date;

Line: 198

      x_search_result_Rec.last_update_login := glb_search_result_tbl(p_count).last_update_login;

Line: 202

      glb_search_result_tbl.delete(p_count);

Line: 256

PROCEDURE DELETE_SEARCH_RESULT(
    P_Api_Version_Number       IN   NUMBER,
    P_Init_Msg_List            IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                   IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level         IN   NUMBER
                               := FND_API.G_VALID_LEVEL_FULL,
    X_Return_Status            OUT  VARCHAR2,
    X_Msg_Count                OUT  NUMBER,
    X_Msg_Data                 OUT  VARCHAR2
    )
 IS
  l_api_name                CONSTANT VARCHAR2(30) := 'Get_search_result';

Line: 305

          glb_search_result_tbl.delete(i);

Line: 521

    glb_party_id_tbl.DELETE(i);