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.

[Home] [Help]

APPS.AMS_IMP_DOC_PVT SQL Statements

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

Line: 88


       SELECT ams_imp_documents_s.NEXTVAL
       FROM dual;

Line: 92


       SELECT 1
       FROM AMS_IMP_DOCUMENTS
       WHERE imp_document_id = l_id;

Line: 195


       Ams_Imp_Doc_Pkg.Insert_Row(
           px_imp_document_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_content_text  => p_imp_doc_rec.content_text,
           --p_dtd_text  => p_imp_doc_rec.dtd_text,
           p_file_type  => p_imp_doc_rec.file_type,
           --p_filter_content_text  => p_imp_doc_rec.filter_content_text,
           p_file_size  => p_imp_doc_rec.file_size
 );

Line: 313


 PROCEDURE Update_Imp_Doc(
     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_doc_rec_type,
     x_object_version_number      OUT NOCOPY  NUMBER
     )

  IS


 CURSOR c_get_imp_doc(imp_document_id NUMBER) IS
     SELECT *
     FROM  AMS_IMP_DOCUMENTS
     WHERE  imp_document_id = p_imp_doc_rec.imp_document_id;

Line: 337


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

Line: 348


       SAVEPOINT update_imp_doc_pvt;

Line: 382


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

Line: 390


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

Line: 407


  p_token_value  => 'Last_Update_Date') ;

Line: 432


             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: 447


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

Line: 451


       Ams_Imp_Doc_Pkg.Update_Row(
           p_imp_document_id  => p_imp_doc_rec.imp_document_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_content_text  => p_imp_doc_rec.content_text,
           --p_dtd_text  => p_imp_doc_rec.dtd_text,
           p_file_type  => p_imp_doc_rec.file_type,
           --p_filter_content_text  => p_imp_doc_rec.filter_content_text,
           p_file_size  => p_imp_doc_rec.file_size
 );

Line: 494


      ROLLBACK TO UPDATE_Imp_Doc_PVT;

Line: 504


      ROLLBACK TO UPDATE_Imp_Doc_PVT;

Line: 514


      ROLLBACK TO UPDATE_Imp_Doc_PVT;

Line: 526


 End Update_Imp_Doc;

Line: 563


 PROCEDURE Delete_Imp_Doc(
     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_document_id                   IN  NUMBER,
     p_object_version_number      IN   NUMBER
     )

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

Line: 582


       SAVEPOINT delete_imp_doc_pvt;

Line: 619


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

Line: 623


       Ams_Imp_Doc_Pkg.Delete_Row(
           p_imp_document_id  => p_imp_document_id,
           p_object_version_number => p_object_version_number     );

Line: 656


      ROLLBACK TO DELETE_Imp_Doc_PVT;

Line: 666


      ROLLBACK TO DELETE_Imp_Doc_PVT;

Line: 676


      ROLLBACK TO DELETE_Imp_Doc_PVT;

Line: 688


 End Delete_Imp_Doc;

Line: 745


    SELECT imp_document_id
    FROM ams_imp_documents
    WHERE imp_document_id = p_imp_document_id
    AND object_version_number = p_object_version
    FOR UPDATE NOWAIT;

Line: 925


       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: 927


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

Line: 939


       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: 941


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

Line: 946


       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: 948


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

Line: 978


       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: 980


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

Line: 994


       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: 996


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

Line: 1002


       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: 1004


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

Line: 1115


       SELECT *
       FROM ams_imp_documents
       WHERE imp_document_id = p_imp_doc_rec.imp_document_id;

Line: 1138


    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: 1143


    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: 1168


    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: 1178


    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: 1183


    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: 1258


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