APPS.AMS_IMP_DOC_CON_PKG SQL Statements

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

Line: 42

PROCEDURE Insert_Row(
           px_imp_doc_content_id   IN OUT NOCOPY NUMBER,
           p_last_updated_by    NUMBER,
           px_object_version_number   IN OUT NOCOPY NUMBER,
           p_created_by    NUMBER,
           p_last_update_login    NUMBER,
           p_last_update_date    DATE,
           p_creation_date    DATE,
           p_import_list_header_id    NUMBER,
           p_file_id NUMBER,
           p_file_name VARCHAR2
 )

  IS
    x_rowid    VARCHAR2(30);

Line: 65

    INSERT INTO ams_imp_doc_content (
            imp_doc_content_id,
            last_updated_by,
            object_version_number,
            created_by,
            last_update_login,
            last_update_date,
            creation_date,
            import_list_header_id,
				file_id,
				file_name
    ) VALUES (
            DECODE( px_imp_doc_content_id, FND_API.G_MISS_NUM, NULL, px_imp_doc_content_id),
            DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
            DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
            DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
            DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
            DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
            DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
            DECODE( p_import_list_header_id, FND_API.G_MISS_NUM, NULL, p_import_list_header_id),
            DECODE( p_file_id, FND_API.g_miss_num, NULL, p_file_id),
            DECODE( p_file_name, FND_API.G_MISS_CHAR, NULL, p_file_name));

Line: 88

 END Insert_Row;

Line: 105

 PROCEDURE Update_Row(
           p_imp_doc_content_id    NUMBER,
           p_last_updated_by    NUMBER,
           px_object_version_number   IN OUT NOCOPY NUMBER,
           p_last_update_login    NUMBER,
           p_last_update_date    DATE,
           p_import_list_header_id    NUMBER,
           p_file_id NUMBER,
           p_file_name VARCHAR2
 )

  IS
  BEGIN
     Update ams_imp_doc_content
     SET
               imp_doc_content_id = DECODE( p_imp_doc_content_id, null, imp_doc_content_id, FND_API.G_MISS_NUM, null, p_imp_doc_content_id),
               last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
               last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
               last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
               import_list_header_id = DECODE( p_import_list_header_id, null, import_list_header_id, FND_API.G_MISS_NUM, null, p_import_list_header_id),
               file_id = DECODE( p_file_id, null, file_id, FND_API.g_miss_num, null, p_file_id),
               file_name = DECODE( p_file_name, null, file_name, FND_API.G_MISS_CHAR, null, p_file_name)
    WHERE imp_doc_content_id = p_imp_doc_content_id
    AND   object_version_number = px_object_version_number;

Line: 137

 END Update_Row;

Line: 154

 PROCEDURE Delete_Row(
     p_imp_doc_content_id  NUMBER,
     p_object_version_number  NUMBER)
  IS
  BEGIN
    DELETE FROM ams_imp_doc_content
     WHERE imp_doc_content_id = p_imp_doc_content_id
     AND object_version_number = p_object_version_number;

Line: 165

  END Delete_Row ;

Line: 187

         SELECT *
          FROM ams_imp_doc_content
         WHERE imp_doc_content_id =  p_imp_doc_content_id
         FOR UPDATE OF imp_doc_content_id NOWAIT;

Line: 197

         FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');