eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_CNT_POINT_PVT SQL Statements

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

Line: 55


      SELECT AMS_ACT_CONTACT_POINTS_s.NEXTVAL
      FROM dual;

Line: 59


      SELECT 1 FROM dual
      WHERE EXISTS (SELECT 1 FROM AMS_ACT_CONTACT_POINTS
                    WHERE CONTACT_POINT_ID = l_id);

Line: 175


      AMS_ACT_CONTACT_POINTS_PKG.Insert_Row(
          px_contact_point_id       => l_contact_point_id,
          p_last_update_date        => SYSDATE,
          p_last_updated_by         => FND_GLOBAL.user_id,
          p_creation_date           => SYSDATE,
          p_created_by              => FND_GLOBAL.user_id,
          p_last_update_login       => FND_GLOBAL.conc_login_id,
          px_object_version_number  => l_object_version_number,
          p_arc_contact_used_by     => p_cnt_point_rec.arc_contact_used_by,
          p_act_contact_used_by_id  => p_cnt_point_rec.act_contact_used_by_id,
          p_contact_point_type      => p_cnt_point_rec.contact_point_type,
          p_contact_point_value     => p_cnt_point_rec.contact_point_value,
          p_city                    => p_cnt_point_rec.city,
          p_country                 => p_cnt_point_rec.country,
          p_zipcode                 => p_cnt_point_rec.zipcode,
          p_attribute_category      => p_cnt_point_rec.attribute_category,
          p_attribute1              => p_cnt_point_rec.attribute1,
          p_attribute2              => p_cnt_point_rec.attribute2,
          p_attribute3              => p_cnt_point_rec.attribute3,
          p_attribute4              => p_cnt_point_rec.attribute4,
          p_attribute5              => p_cnt_point_rec.attribute5,
          p_attribute6              => p_cnt_point_rec.attribute6,
          p_attribute7              => p_cnt_point_rec.attribute7,
          p_attribute8              => p_cnt_point_rec.attribute8,
          p_attribute9              => p_cnt_point_rec.attribute9,
          p_attribute10             => p_cnt_point_rec.attribute10,
          p_attribute11             => p_cnt_point_rec.attribute11,
          p_attribute12             => p_cnt_point_rec.attribute12,
          p_attribute13             => p_cnt_point_rec.attribute13,
          p_attribute14             => p_cnt_point_rec.attribute14,
          p_attribute15             => p_cnt_point_rec.attribute15,
         p_contact_point_value_id => p_cnt_point_rec.contact_point_value_id
          );

Line: 277


PROCEDURE Update_Cnt_Point(
    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 NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,

    p_cnt_point_rec               IN    cnt_point_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS

CURSOR c_get_cnt_point(contact_point_id NUMBER) IS
    SELECT *
    FROM  AMS_ACT_CONTACT_POINTS
    WHERE contact_point_id = p_cnt_point_rec.contact_point_id;

Line: 300


L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Cnt_Point';

Line: 312


      AMS_UTILITY_PVT.debug_message('Inside Update_cnt_point');

Line: 315


      SAVEPOINT UPDATE_Cnt_Point_PVT;

Line: 345


      AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 354


  AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
   p_token_name   => 'INFO',
 p_token_value  => 'Cnt_Point') ;

Line: 372


 p_token_value  => 'Last_Update_Date') ;

Line: 395


            p_validation_mode  => JTF_PLSQL_API.g_update,
            p_cnt_point_rec    =>  p_cnt_point_rec,
            x_return_status    => x_return_status,
            x_msg_count        => x_msg_count,
            x_msg_data         => x_msg_data);

Line: 410


      AMS_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');

Line: 414


      AMS_ACT_CONTACT_POINTS_PKG.Update_Row(
          p_contact_point_id  => p_cnt_point_rec.contact_point_id,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.user_id,
          p_last_update_login  => FND_GLOBAL.conc_login_id,
          p_object_version_number  => p_cnt_point_rec.object_version_number,
          p_arc_contact_used_by  => p_cnt_point_rec.arc_contact_used_by,
          p_act_contact_used_by_id  => p_cnt_point_rec.act_contact_used_by_id,
          p_contact_point_type  => p_cnt_point_rec.contact_point_type,
          p_contact_point_value  => p_cnt_point_rec.contact_point_value,
          p_city  => p_cnt_point_rec.city,
          p_country  => p_cnt_point_rec.country,
          p_zipcode  => p_cnt_point_rec.zipcode,
          p_attribute_category  => p_cnt_point_rec.attribute_category,
          p_attribute1  => p_cnt_point_rec.attribute1,
          p_attribute2  => p_cnt_point_rec.attribute2,
          p_attribute3  => p_cnt_point_rec.attribute3,
          p_attribute4  => p_cnt_point_rec.attribute4,
          p_attribute5  => p_cnt_point_rec.attribute5,
          p_attribute6  => p_cnt_point_rec.attribute6,
          p_attribute7  => p_cnt_point_rec.attribute7,
          p_attribute8  => p_cnt_point_rec.attribute8,
          p_attribute9  => p_cnt_point_rec.attribute9,
          p_attribute10  => p_cnt_point_rec.attribute10,
          p_attribute11  => p_cnt_point_rec.attribute11,
          p_attribute12  => p_cnt_point_rec.attribute12,
          p_attribute13  => p_cnt_point_rec.attribute13,
          p_attribute14  => p_cnt_point_rec.attribute14,
          p_attribute15  => p_cnt_point_rec.attribute15
         ,p_contact_point_value_id => p_cnt_point_rec.contact_point_value_id
          );

Line: 474


     ROLLBACK TO UPDATE_Cnt_Point_PVT;

Line: 484


     ROLLBACK TO UPDATE_Cnt_Point_PVT;

Line: 494


     ROLLBACK TO UPDATE_Cnt_Point_PVT;

Line: 506


End Update_Cnt_Point;

Line: 509


PROCEDURE Delete_Cnt_Point(
    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 NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_contact_point_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS

 CURSOR c_Cnt_Point IS
   SELECT CONTACT_POINT_ID
   FROM AMS_ACT_CONTACT_POINTS
   WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID
   AND object_version_number = p_object_version_number ;

Line: 529


L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Cnt_Point';

Line: 537


      AMS_UTILITY_PVT.debug_message('Inside Delete_cnt_point');

Line: 540


      SAVEPOINT DELETE_Cnt_Point_PVT;

Line: 585


      AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 589


      AMS_ACT_CONTACT_POINTS_PKG.Delete_Row(
          p_CONTACT_POINT_ID  => p_CONTACT_POINT_ID);

Line: 622


     ROLLBACK TO DELETE_Cnt_Point_PVT;

Line: 632


     ROLLBACK TO DELETE_Cnt_Point_PVT;

Line: 642


     ROLLBACK TO DELETE_Cnt_Point_PVT;

Line: 654


End Delete_Cnt_Point;

Line: 678


   SELECT CONTACT_POINT_ID
   FROM AMS_ACT_CONTACT_POINTS
   WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 901


      /*IF p_cnt_point_rec.last_update_date = FND_API.g_miss_date OR p_cnt_point_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_update_date');

Line: 908


      IF p_cnt_point_rec.last_updated_by = FND_API.g_miss_num OR p_cnt_point_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_updated_by');

Line: 972


      /*IF p_cnt_point_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_update_date');

Line: 979


      IF p_cnt_point_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_cnt_point_NO_last_updated_by');

Line: 1501


    SELECT contact_point_id
    FROM ams_act_contact_points
    WHERE arc_contact_used_by = p_cnt_point_rec.arc_contact_used_by
    AND   act_contact_used_by_id = p_cnt_point_rec.act_contact_used_by_id
    AND   contact_point_type = p_cnt_point_rec.contact_point_type
    AND   contact_point_value = p_cnt_point_rec.contact_point_value
    AND   contact_point_value_id  = p_cnt_point_rec.contact_point_value_id;

Line: 1510


    SELECT contact_point_id
    FROM ams_act_contact_points
    WHERE arc_contact_used_by = p_cnt_point_rec.arc_contact_used_by
    AND   act_contact_used_by_id = p_cnt_point_rec.act_contact_used_by_id
    AND   contact_point_type = p_cnt_point_rec.contact_point_type
    AND   contact_point_value = p_cnt_point_rec.contact_point_value
    AND contact_point_id <> p_cnt_point_rec.contact_point_id
    AND   contact_point_value_id  = p_cnt_point_rec.contact_point_value_id;

Line: 1537


      IF(p_validation_mode = JTF_PLSQL_API.g_update) THEN
       OPEN c_check_cnt_point_uk_rec_up ;