APPS.AMV_CONTENT_TYPE_PVT SQL Statements

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

Line: 21

Select
    content_type_id
From   amv_i_content_types_tl
Where  content_type_name = p_name
And    language IN
    (
       Select L.language_code
       From  fnd_languages L
       Where L.installed_flag in ('I', 'B')
    )
;

Line: 34

Select
     content_type_id
From  amv_i_content_types_tl
Where content_type_name = p_name
And   language = userenv('lang');

Line: 73

select
      AMV_I_CONTENT_TYPES_B_S.nextval, sysdate
from dual;

Line: 159

    AMV_I_CONTENT_TYPES_PKG.INSERT_ROW
       (
        X_ROWID => l_rowid,
        X_CONTENT_TYPE_ID => l_content_type_id,
        X_OBJECT_VERSION_NUMBER => 1,
        X_CONTENT_TYPE_NAME => p_content_type_name,
        X_DESCRIPTION => l_description,
        X_CREATION_DATE => l_current_date,
        X_CREATED_BY => l_current_user_id,
        X_LAST_UPDATE_DATE => l_current_date,
        X_LAST_UPDATED_BY => l_current_user_id,
        X_LAST_UPDATE_LOGIN => l_current_login_id
       );

Line: 216

PROCEDURE Delete_ContentType
(
    p_api_version        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_check_login_user   IN  VARCHAR2 := FND_API.G_TRUE,
    p_content_type_id    IN  NUMBER   := FND_API.G_MISS_NUM,
    p_content_type_name  IN  VARCHAR2 := FND_API.G_MISS_CHAR
) IS
l_api_name             CONSTANT VARCHAR2(30) := 'Delete_ContentType';

Line: 241

Select
    item_id
From jtf_amv_items_b
Where content_type_id = p_ContentType_id;

Line: 248

    SAVEPOINT  Delete_ContentType_Pvt;

Line: 354

    Delete from amv_c_content_types
    where content_type_id = l_content_type_id;

Line: 357

    AMV_I_CONTENT_TYPES_PKG.DELETE_ROW
    (
       X_CONTENT_TYPE_ID => l_content_type_id
    );

Line: 373

       ROLLBACK TO  Delete_ContentType_Pvt;

Line: 382

       ROLLBACK TO  Delete_ContentType_Pvt;

Line: 391

       ROLLBACK TO  Delete_ContentType_Pvt;

Line: 403

END Delete_ContentType;

Line: 405

PROCEDURE Update_ContentType
(
    p_api_version            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_check_login_user       IN  VARCHAR2 := FND_API.G_TRUE,
    p_content_type_id        IN  NUMBER   := FND_API.G_MISS_NUM,
    p_content_type_name      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
    p_content_type_new_name  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
    p_cnt_type_description   IN  VARCHAR2 := FND_API.G_MISS_CHAR
) IS
l_api_name             CONSTANT VARCHAR2(30) := 'Update_ContentType';

Line: 432

Select
   object_version_number
from  Amv_i_content_types_b
where content_type_id = p_ctype_id;

Line: 440

    SAVEPOINT  Update_ContentType_Pvt;

Line: 555

    AMV_I_CONTENT_TYPES_PKG.UPDATE_ROW
        (
           X_CONTENT_TYPE_ID =>l_content_type_id,
           X_OBJECT_VERSION_NUMBER => l_object_version + 1,
           X_CONTENT_TYPE_NAME => p_content_type_new_name,
           X_DESCRIPTION       => p_cnt_type_description,
           X_LAST_UPDATE_DATE  => sysdate,
           X_LAST_UPDATED_BY   => l_current_user_id,
           X_LAST_UPDATE_LOGIN => l_current_login_id
        );

Line: 577

       ROLLBACK TO  Update_ContentType_Pvt;

Line: 586

       ROLLBACK TO  Update_ContentType_Pvt;

Line: 595

       ROLLBACK TO  Update_ContentType_Pvt;

Line: 606

END Update_ContentType;

Line: 632

Select
    B.CONTENT_TYPE_ID,
    B.OBJECT_VERSION_NUMBER,
    T.CONTENT_TYPE_NAME,
    T.DESCRIPTION,
    T.LANGUAGE,
    T.SOURCE_LANG,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN
From   AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B
Where  B.CONTENT_TYPE_ID = T.CONTENT_TYPE_ID
And    T.LANGUAGE = userenv('LANG')
And    B.CONTENT_TYPE_ID = p_ID;

Line: 744

        x_content_type_obj.last_update_date := l_content_type_rec.last_update_date;

Line: 745

        x_content_type_obj.last_updated_by := l_content_type_rec.last_updated_by;

Line: 746

        x_content_type_obj.last_update_login := l_content_type_rec.last_update_login;

Line: 758

              l_content_type_rec.last_update_date,
              l_content_type_rec.last_updated_by,
              l_content_type_rec.last_update_login
           );

Line: 842

l_last_update_date   DATE;

Line: 843

l_last_updated_by    NUMBER;

Line: 844

l_last_update_login  NUMBER;

Line: 886

       'Select ' ||
           'B.CONTENT_TYPE_ID, ' ||
           'B.OBJECT_VERSION_NUMBER, ' ||
           'T.CONTENT_TYPE_NAME, ' ||
           'T.DESCRIPTION, ' ||
           'T.LANGUAGE, ' ||
           'T.SOURCE_LANG, ' ||
           'B.CREATION_DATE, ' ||
           'B.CREATED_BY, ' ||
           'B.LAST_UPDATE_DATE, ' ||
           'B.LAST_UPDATED_BY, ' ||
           'B.LAST_UPDATE_LOGIN ' ||
       'From   AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B ';

Line: 900

       'Select count(*) ' ||
       'From   AMV_I_CONTENT_TYPES_TL T, AMV_I_CONTENT_TYPES_B B ';

Line: 951

         l_last_update_date,
         l_last_updated_by,
         l_last_update_login;

Line: 967

         x_content_type_obj_varray(l_fetch_count).last_update_date := l_last_update_date;

Line: 968

         x_content_type_obj_varray(l_fetch_count).last_updated_by := l_last_updated_by;

Line: 969

         x_content_type_obj_varray(l_fetch_count).last_update_login := l_last_update_login;

Line: 982

              l_last_update_date,
              l_last_updated_by,
              l_last_update_login
           );