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_ST_ASSOC_PVT SQL Statements

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

Line: 49


      SELECT AMS_LIST_SRC_TYPE_ASSOCS_s.NEXTVAL
      FROM dual;

Line: 53


      SELECT 1
      FROM AMS_LIST_SRC_TYPE_ASSOCS
      WHERE LIST_SOURCE_TYPE_ASSOC_ID = l_id;

Line: 141


      AMS_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row(
          px_list_source_type_assoc_id  => l_list_source_type_assoc_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_master_source_type_id  => p_st_assoc_rec.master_source_type_id,
          p_sub_source_type_id  => p_st_assoc_rec.sub_source_type_id,
          p_sub_source_type_pk_column  => p_st_assoc_rec.sub_source_type_pk_column,
          p_enabled_flag  => p_st_assoc_rec.enabled_flag,
          p_description  => p_st_assoc_rec.description,
          p_master_source_type_pk_column  =>
                p_st_assoc_rec.master_source_type_pk_column);

Line: 226


PROCEDURE Update_St_Assoc(
    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_st_assoc_rec               IN    st_assoc_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS

CURSOR c_get_st_assoc(list_source_type_assoc_id NUMBER) IS
    SELECT *
    FROM  AMS_LIST_SRC_TYPE_ASSOCS;

Line: 247


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

Line: 258


      SAVEPOINT UPDATE_St_Assoc_PVT;

Line: 288


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

Line: 297


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

Line: 315


 p_token_value  => 'Last_Update_Date') ;

Line: 356


      AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row(
          p_list_source_type_assoc_id  =>
                     p_st_assoc_rec.list_source_type_assoc_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,
          p_object_version_number  => p_st_assoc_rec.object_version_number,
          p_master_source_type_id  => p_st_assoc_rec.master_source_type_id,
          p_sub_source_type_id  => p_st_assoc_rec.sub_source_type_id,
          p_sub_source_type_pk_column  =>
                  p_st_assoc_rec.sub_source_type_pk_column,
          p_enabled_flag  => p_st_assoc_rec.enabled_flag,
          p_description  => p_st_assoc_rec.description,
          p_master_source_type_pk_column  =>
                  p_st_assoc_rec.master_source_type_pk_column  );

Line: 402


     ROLLBACK TO UPDATE_St_Assoc_PVT;

Line: 412


     ROLLBACK TO UPDATE_St_Assoc_PVT;

Line: 422


     ROLLBACK TO UPDATE_St_Assoc_PVT;

Line: 434


End Update_St_Assoc;

Line: 437


PROCEDURE Delete_St_Assoc(
    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_list_source_type_assoc_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_St_Assoc';

Line: 456


      SAVEPOINT DELETE_St_Assoc_PVT;

Line: 489


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

Line: 493


      AMS_LIST_SRC_TYPE_ASSOCS_PKG.Delete_Row(
          p_LIST_SOURCE_TYPE_ASSOC_ID  => p_LIST_SOURCE_TYPE_ASSOC_ID);

Line: 524


     ROLLBACK TO DELETE_St_Assoc_PVT;

Line: 534


     ROLLBACK TO DELETE_St_Assoc_PVT;

Line: 544


     ROLLBACK TO DELETE_St_Assoc_PVT;

Line: 556


End Delete_St_Assoc;

Line: 580


   SELECT LIST_SOURCE_TYPE_ASSOC_ID
   FROM AMS_LIST_SRC_TYPE_ASSOCS
   WHERE LIST_SOURCE_TYPE_ASSOC_ID = p_LIST_SOURCE_TYPE_ASSOC_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 741


      IF p_st_assoc_rec.last_update_date = FND_API.g_miss_date OR p_st_assoc_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_update_date');

Line: 747


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

Line: 801


      IF p_st_assoc_rec.last_update_date IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_update_date');

Line: 808


      IF p_st_assoc_rec.last_updated_by IS NULL THEN
 AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_updated_by');

Line: 951


   x_stassoc_rec.LAST_UPDATE_DATE                  := FND_API.g_miss_date;

Line: 952


   x_stassoc_rec.LAST_UPDATED_BY                   := FND_API.g_miss_num;

Line: 955


   x_stassoc_rec.LAST_UPDATE_LOGIN                 := FND_API.g_miss_num;

Line: 973


      SELECT *
      FROM ams_list_src_type_assocs
      WHERE list_source_type_assoc_id = p_st_assoc_rec.list_source_type_assoc_id;

Line: 991


   IF p_st_assoc_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := l_st_assoc_rec.last_update_date;

Line: 996


   IF p_st_assoc_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := l_st_assoc_rec.last_updated_by;

Line: 1011


   IF p_st_assoc_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := l_st_assoc_rec.last_update_login;

Line: 1090


                 p_validation_mode   => JTF_PLSQL_API.g_update,
                 x_return_status     => x_return_status
              );