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

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

Line: 89


       SELECT ams_imp_doc_content_s.NEXTVAL
       FROM dual;

Line: 93


       SELECT 1
       FROM ams_imp_doc_content
       WHERE imp_doc_content_id = l_id;

Line: 195


       AMS_IMP_DOC_CON_PKG.Insert_Row(
           px_imp_doc_content_id  => l_imp_document_id,
           p_last_updated_by  => FND_GLOBAL.USER_ID,
           px_object_version_number  => l_object_version_number,
           p_created_by  => FND_GLOBAL.USER_ID,
           p_last_update_login  => FND_GLOBAL.conc_login_id,
           p_last_update_date  => SYSDATE,
           p_creation_date  => SYSDATE,
           p_import_list_header_id  => p_imp_doc_rec.import_list_header_id,
           p_file_id => p_imp_doc_rec.file_id,
           p_file_name => p_imp_doc_rec.file_name
 );

Line: 310


 PROCEDURE Update_Imp_Doc_Con(
     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_imp_doc_rec               IN    imp_doccon_rec_type,
     x_object_version_number      OUT NOCOPY  NUMBER
     )

  IS


 CURSOR c_get_imp_doc(imp_doc_content_id NUMBER) IS
     SELECT *
     FROM  ams_imp_doc_content
     WHERE  imp_doc_content_id = p_imp_doc_rec.imp_doc_content_id;

Line: 334


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

Line: 345


       SAVEPOINT update_imp_doc_pvt;

Line: 379


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

Line: 387


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

Line: 404


  p_token_value  => 'Last_Update_Date') ;

Line: 429


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

Line: 444


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

Line: 448


       AMS_IMP_DOC_CON_PKG.Update_Row(
           p_imp_doc_content_id  => p_imp_doc_rec.imp_doc_content_id,
           p_last_updated_by  => FND_GLOBAL.USER_ID,
           px_object_version_number  => l_object_version_number,
           p_last_update_login  => FND_GLOBAL.conc_login_id,
           p_last_update_date  => SYSDATE,
           p_import_list_header_id  => p_imp_doc_rec.import_list_header_id,
           p_file_id  => p_imp_doc_rec.file_id,
           p_file_name  => p_imp_doc_rec.file_name
		);

Line: 488


      ROLLBACK TO UPDATE_Imp_Doc_PVT;

Line: 498


      ROLLBACK TO UPDATE_Imp_Doc_PVT;

Line: 508


      ROLLBACK TO UPDATE_Imp_Doc_PVT;

Line: 520


 End Update_Imp_Doc_Con;

Line: 557


 PROCEDURE Delete_Imp_Doc_Con(
     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_imp_doccontent_id          IN  NUMBER,
     p_object_version_number      IN   NUMBER
     )

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

Line: 576


       SAVEPOINT delete_imp_doc_pvt;

Line: 613


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

Line: 617


       AMS_IMP_DOC_CON_PKG.Delete_Row(
           p_imp_doc_content_id  => p_imp_doccontent_id,
           p_object_version_number => p_object_version_number     );

Line: 650


      ROLLBACK TO DELETE_Imp_Doc_PVT;

Line: 660


      ROLLBACK TO DELETE_Imp_Doc_PVT;

Line: 670


      ROLLBACK TO DELETE_Imp_Doc_PVT;

Line: 682


 End Delete_Imp_Doc_Con;

Line: 739


    SELECT imp_doc_content_id
    FROM ams_imp_doc_content
    WHERE imp_doc_content_id = p_imp_doccontent_id
    AND object_version_number = p_object_version
    FOR UPDATE NOWAIT;

Line: 919


       IF p_imp_doc_rec.last_updated_by = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_updated_by IS NULL THEN
                AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');

Line: 921


                FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATED_BY' );

Line: 933


       IF p_imp_doc_rec.last_update_login = FND_API.G_MISS_NUM OR p_imp_doc_rec.last_update_login IS NULL THEN
                AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');

Line: 935


                FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_LOGIN' );

Line: 940


       IF p_imp_doc_rec.last_update_date = FND_API.G_MISS_DATE OR p_imp_doc_rec.last_update_date IS NULL THEN
                AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');

Line: 942


                FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_DATE' );

Line: 972


       IF p_imp_doc_rec.last_updated_by = FND_API.G_MISS_NUM THEN
                AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');

Line: 974


                FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATED_BY' );

Line: 988


       IF p_imp_doc_rec.last_update_login = FND_API.G_MISS_NUM THEN
                AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');

Line: 990


                FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_LOGIN' );

Line: 996


       IF p_imp_doc_rec.last_update_date = FND_API.G_MISS_DATE THEN
                AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD');

Line: 998


                FND_MESSAGE.set_token('MISS_FIELD', 'LAST_UPDATE_DATE' );

Line: 1109


       SELECT *
       FROM ams_imp_doc_content
       WHERE imp_doc_content_id = p_imp_doc_rec.imp_doc_content_id;

Line: 1132


    IF p_imp_doc_rec.last_updated_by IS NULL THEN
       x_complete_rec.last_updated_by := l_imp_doc_rec.last_updated_by;

Line: 1137


    IF p_imp_doc_rec.last_update_date IS NULL THEN
       x_complete_rec.last_update_date := l_imp_doc_rec.last_update_date;

Line: 1162


    IF p_imp_doc_rec.last_update_login IS NULL THEN
       x_complete_rec.last_update_login := l_imp_doc_rec.last_update_login;

Line: 1172


    IF p_imp_doc_rec.last_update_date IS NULL THEN
       x_complete_rec.last_update_date := l_imp_doc_rec.last_update_date;

Line: 1177


    IF p_imp_doc_rec.last_update_login IS NULL THEN
       x_complete_rec.last_update_login := l_imp_doc_rec.last_update_login;

Line: 1212


    IF p_imp_doc_rec.last_updated_by IS NULL THEN
       x_complete_rec.last_updated_by := l_imp_doc_rec.last_updated_by;