APPS.AST_CAMP_RESULT_PVT SQL Statements

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

Line: 46

  SELECT source_code_id, source_code, arc_source_code_for, source_code_for_id
  FROM ams_source_codes
  WHERE arc_source_code_for = 'CAMP'
  AND source_code = l_camp_result_Rec.source_code
  AND source_code_for_id = l_camp_result_Rec.object_id;

Line: 107

      INSERT INTO jtf_ih_campaigns_results
         (result_id
         ,object_id
         ,object_version_number
         ,created_by
         ,creation_date
         ,last_updated_by
         ,last_update_date
         ,last_update_login
         ,object_type
         ,source_code_id
         ,source_code)
      VALUES
         (l_camp_result_Rec.result_id
         ,l_camp_result_Rec.object_id
         ,l_camp_result_Rec.object_version_number
         ,l_camp_result_Rec.created_by
         ,l_camp_result_Rec.creation_date
         ,l_camp_result_Rec.last_updated_by
         ,l_camp_result_Rec.last_update_date
         ,l_camp_result_Rec.last_update_login
         ,l_camp_result_Rec.object_type
         ,l_camp_result_Rec.source_code_id
         ,l_camp_result_Rec.source_code
         );

Line: 188

PROCEDURE Delete_camp_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,
    P_camp_result_Rec            IN   camp_result_Rec_Type,
    X_Return_Status              OUT  VARCHAR2,
    X_Msg_Count                  OUT  NUMBER,
    X_Msg_Data                   OUT  VARCHAR2
    )

IS
 l_api_name                CONSTANT VARCHAR2(30) := 'Delete_camp_result';

Line: 205

      SAVEPOINT DELETE_camp_result_PVT;

Line: 236

      DELETE FROM jtf_ih_campaigns_results
      WHERE result_id = l_camp_result_Rec.result_id
      AND source_code = l_camp_result_Rec.source_code
      AND object_id = l_camp_result_Rec.object_id;

Line: 289

End Delete_camp_result;