DBA Data[Home] [Help]

APPS.AMV_PERSPECTIVE_PVT SQL Statements

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

Line: 19

Select
    perspective_id
From   amv_i_perspectives_tl
Where  perspective_name = p_name
And    language IN
    (
       Select L.language_code
       From  fnd_languages L
       Where L.installed_flag in ('I', 'B')
    )
;
Line: 32

Select
     perspective_id
From   amv_i_perspectives_tl
Where perspective_name = p_name
And   language = userenv('lang');
Line: 71

select
      AMV_I_PERSPECTIVES_B_S.nextval, sysdate
from dual;
Line: 159

    AMV_I_PERSPECTIVES_PKG.INSERT_ROW
       (
        X_ROWID => l_rowid,
        X_PERSPECTIVE_ID => l_perspective_id,
        X_OBJECT_VERSION_NUMBER => 1,
        X_PERSPECTIVE_NAME => p_perspective_name,
        X_DESCRIPTION => l_persp_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: 221

PROCEDURE Delete_Perspective
(
    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_perspective_id    IN  NUMBER   := FND_API.G_MISS_NUM,
    p_perspective_name  IN  VARCHAR2 := FND_API.G_MISS_CHAR
) IS
l_api_name             CONSTANT VARCHAR2(30) := 'Delete_Perspective';
Line: 247

    SAVEPOINT  Delete_Perspective_Pvt;
Line: 339

    Delete from amv_c_chl_perspectives
    where perspective_id = l_perspective_id;
Line: 342

    Delete from amv_i_item_perspectives
    where perspective_id = l_perspective_id;
Line: 345

    AMV_I_PERSPECTIVES_PKG.DELETE_ROW
    (
       X_PERSPECTIVE_ID => l_perspective_id
    );
Line: 361

       ROLLBACK TO  Delete_Perspective_Pvt;
Line: 370

       ROLLBACK TO  Delete_Perspective_Pvt;
Line: 379

       ROLLBACK TO  Delete_Perspective_Pvt;
Line: 391

END Delete_Perspective;
Line: 393

PROCEDURE Update_Perspective
(
    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_perspective_id        IN  NUMBER   := FND_API.G_MISS_NUM,
    p_perspective_name      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
    p_perspective_new_name  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
    p_persp_description     IN  VARCHAR2 := FND_API.G_MISS_CHAR
) IS
l_api_name             CONSTANT VARCHAR2(30) := 'Update_Perspective';
Line: 420

Select
   object_version_number
from  Amv_i_perspectives_b
where perspective_id = p_persp_id;
Line: 428

    SAVEPOINT  Update_Perspective_Pvt;
Line: 538

    AMV_I_PERSPECTIVES_PKG.UPDATE_ROW
        (
           X_PERSPECTIVE_ID    => l_perspective_id,
           X_OBJECT_VERSION_NUMBER => l_object_version + 1,
           X_PERSPECTIVE_NAME  => p_perspective_new_name,
           X_DESCRIPTION       => p_persp_description,
           X_LAST_UPDATE_DATE  => sysdate,
           X_LAST_UPDATED_BY   => l_current_user_id,
           X_LAST_UPDATE_LOGIN => l_current_login_id
        );
Line: 554

        FND_MESSAGE.Set_name('AMV','PVT Update Persp. API: End');
Line: 566

       ROLLBACK TO  Update_Perspective_Pvt;
Line: 575

       ROLLBACK TO  Update_Perspective_Pvt;
Line: 584

       ROLLBACK TO  Update_Perspective_Pvt;
Line: 595

END Update_Perspective;
Line: 621

Select
    B.PERSPECTIVE_ID,
    B.OBJECT_VERSION_NUMBER,
    T.PERSPECTIVE_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_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B
Where  B.PERSPECTIVE_ID = T.PERSPECTIVE_ID
And    T.LANGUAGE = userenv('LANG')
And    B.PERSPECTIVE_ID = p_ID;
Line: 739

        x_perspective_obj.last_update_date := l_perspective_rec.last_update_date;
Line: 740

        x_perspective_obj.last_updated_by := l_perspective_rec.last_updated_by;
Line: 741

        x_perspective_obj.last_update_login := l_perspective_rec.last_update_login;
Line: 753

              l_perspective_rec.last_update_date,
              l_perspective_rec.last_updated_by,
              l_perspective_rec.last_update_login
           );
Line: 836

l_last_update_date   DATE;
Line: 837

l_last_updated_by    NUMBER;
Line: 838

l_last_update_login  NUMBER;
Line: 880

       'Select ' ||
           'B.PERSPECTIVE_ID, ' ||
           'B.OBJECT_VERSION_NUMBER, ' ||
           'T.PERSPECTIVE_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_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B ';
Line: 894

       'Select count(*) ' ||
       'From   AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B ';
Line: 946

         l_last_update_date,
         l_last_updated_by,
         l_last_update_login;
Line: 962

         x_perspective_obj_varray(l_fetch_count).last_update_date := l_last_update_date;
Line: 963

         x_perspective_obj_varray(l_fetch_count).last_updated_by := l_last_updated_by;
Line: 964

         x_perspective_obj_varray(l_fetch_count).last_update_login := l_last_update_login;
Line: 976

              l_last_update_date,
              l_last_updated_by,
              l_last_update_login
           );
Line: 1065

Select
     perspective_id
From amv_i_item_perspectives
Where item_id = p_item_id
And   perspective_id = p_perspectiv_id;
Line: 1072

Select amv_i_item_perspectives_s.nextval, sysdate
From  Dual;
Line: 1165

               Insert Into amv_i_item_perspectives
                 (
                    ITEM_PERSPECTIVE_ID,
                    OBJECT_VERSION_NUMBER,
                    LAST_UPDATE_DATE,
                    LAST_UPDATED_BY,
                    CREATION_DATE,
                    CREATED_BY,
                    LAST_UPDATE_LOGIN,
                    ITEM_ID,
                    PERSPECTIVE_ID
                 ) VALUES
                 (
                    l_temp_number,
                    1,
                    l_date,
                    l_current_user_id,
                    l_date,
                    l_current_user_id,
                    l_current_login_id,
                    p_item_id,
                    l_perspective_id
                 );
Line: 1269

Select
     perspective_id
From amv_i_item_perspectives
Where item_id = p_item_id
And   perspective_id = p_perspective_id;
Line: 1276

Select amv_i_item_perspectives_s.nextval, sysdate
From  Dual;
Line: 1373

       Insert Into amv_i_item_perspectives
         (
            ITEM_PERSPECTIVE_ID,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_LOGIN,
            ITEM_ID,
            PERSPECTIVE_ID
         ) VALUES
         (
            l_item_persp,
            l_date,
            l_current_user_id,
            l_date,
            l_current_user_id,
            l_current_login_id,
            p_item_id,
            p_perspective_id
         );
Line: 1439

PROCEDURE Delete_ItemPersps
(
    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_item_id           IN  NUMBER,
    p_perspective_array IN  AMV_NUMBER_VARRAY_TYPE
)  IS
l_api_name             CONSTANT VARCHAR2(30) := 'Delete_ItemPersps';
Line: 1467

Select
     perspective_id
From amv_i_item_perspectives
Where item_id = p_item_id
And   perspective_id = p_perspectiv_id;
Line: 1475

    SAVEPOINT  Delete_ItemPersps_Pvt;
Line: 1558

           Delete from amv_i_item_perspectives
           Where  item_id = p_item_id
           And    perspective_id = l_perspective_id;
Line: 1575

       ROLLBACK TO  Delete_ItemPersps_Pvt;
Line: 1584

       ROLLBACK TO  Delete_ItemPersps_Pvt;
Line: 1593

       ROLLBACK TO  Delete_ItemPersps_Pvt;
Line: 1605

end Delete_ItemPersps;
Line: 1608

PROCEDURE Delete_ItemPersps
(
    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_item_id           IN  NUMBER,
    p_perspective_id    IN  NUMBER   := FND_API.G_MISS_NUM
)  IS
l_api_name             CONSTANT VARCHAR2(30) := 'Delete_ItemPersps';
Line: 1632

Select
     perspective_id
From amv_i_item_perspectives
Where item_id = p_item_id
And   perspective_id = p_perspective_id;
Line: 1640

    SAVEPOINT  Delete_ItemPersps_Pvt;
Line: 1721

           Delete from amv_i_item_perspectives
           Where  item_id = p_item_id
           And    perspective_id = p_perspective_id;
Line: 1728

        Delete from amv_i_item_perspectives
        Where  item_id = p_item_id;
Line: 1743

       ROLLBACK TO  Delete_ItemPersps_Pvt;
Line: 1752

       ROLLBACK TO  Delete_ItemPersps_Pvt;
Line: 1761

       ROLLBACK TO  Delete_ItemPersps_Pvt;
Line: 1773

end Delete_ItemPersps;
Line: 1776

PROCEDURE Update_ItemPersps
(
    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_item_id           IN  NUMBER,
    p_perspective_array IN  AMV_NUMBER_VARRAY_TYPE
) is
begin
   Delete_ItemPersps
   (
      p_api_version       => p_api_version,
      p_init_msg_list     => p_init_msg_list,
  --  p_commit            => p_commit,
      p_validation_level  => p_validation_level,
      x_return_status     => x_return_status,
      x_msg_count         => x_msg_count,
      x_msg_data          => x_msg_data,
      p_check_login_user  => p_check_login_user,
      p_item_id           => p_item_id
   );
Line: 1817

end Update_ItemPersps;
Line: 1840

Select
    B.PERSPECTIVE_ID,
    B.OBJECT_VERSION_NUMBER,
    T.PERSPECTIVE_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_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B,
       AMV_I_ITEM_PERSPECTIVES I
Where  B.PERSPECTIVE_ID = I.PERSPECTIVE_ID
And    T.PERSPECTIVE_ID = I.PERSPECTIVE_ID
And    T.LANGUAGE = userenv('LANG')
And    I.ITEM_ID = p_item_id
Order BY T.PERSPECTIVE_NAME;
Line: 1924

         x_perspective_obj_varray(l_fetch_count).last_update_date := psp_rec.last_update_date;
Line: 1925

         x_perspective_obj_varray(l_fetch_count).last_updated_by := psp_rec.last_updated_by;
Line: 1926

         x_perspective_obj_varray(l_fetch_count).last_update_login := psp_rec.last_update_login;
Line: 1938

              psp_rec.last_update_date,
              psp_rec.last_updated_by,
              psp_rec.last_update_login
           );