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.OKC_PRICE_ADJUSTMENT_PUB SQL Statements

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

Line: 100


 PROCEDURE update_price_adjustment(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_patv_rec                     IN patv_rec_type,
    x_patv_rec                     OUT NOCOPY patv_rec_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.update_price_adjustment(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_patv_rec                     ,
    x_patv_rec                     );

Line: 128


 PROCEDURE update_price_adjustment(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_patv_tbl                     IN patv_tbl_type,
    x_patv_tbl                     OUT NOCOPY patv_tbl_type) is
    i                              NUMBER := 0;

Line: 144


       update_price_adjustment(
           p_api_version,
           p_init_msg_list,
           l_return_status,
           x_msg_count,
           x_msg_data,
           p_patv_tbl(i),
           x_patv_tbl(i));

Line: 175


END update_price_adjustment;

Line: 187


 PROCEDURE delete_price_adjustment(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_patv_rec                     IN patv_rec_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.delete_price_adjustment(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_patv_rec                     );

Line: 214


 PROCEDURE delete_price_adjustment(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_patv_tbl                     IN patv_tbl_type) is
    i                              NUMBER := 0;

Line: 229


       delete_price_adjustment(
           p_api_version,
           p_init_msg_list,
           l_return_status,
           x_msg_count,
           x_msg_data,
           p_patv_tbl(i));

Line: 259


END delete_price_adjustment;

Line: 498


 PROCEDURE update_price_adj_assoc(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pacv_rec                     IN pacv_rec_type,
    x_pacv_rec                     OUT NOCOPY pacv_rec_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.update_price_adj_assoc(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_pacv_rec                     ,
    x_pacv_rec                     );

Line: 527


 PROCEDURE update_price_adj_assoc(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pacv_tbl                     IN pacv_tbl_type,
    x_pacv_tbl                     OUT NOCOPY pacv_tbl_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.update_price_adj_assoc(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_pacv_tbl                     ,
    x_pacv_tbl                     );

Line: 556


 PROCEDURE delete_price_adj_assoc(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pacv_rec                     IN pacv_rec_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.delete_price_adj_assoc(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_pacv_rec                     );

Line: 582


 PROCEDURE delete_price_adj_assoc(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pacv_tbl                     IN pacv_tbl_type ) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.delete_price_adj_assoc(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_pacv_tbl                     );

Line: 770


 PROCEDURE update_price_att_value(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pavv_rec                     IN pavv_rec_type,
    x_pavv_rec                     OUT NOCOPY pavv_rec_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.update_price_att_value(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_pavv_rec                     ,
    x_pavv_rec                     );

Line: 798


 PROCEDURE update_price_att_value(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pavv_tbl                     IN pavv_tbl_type,
    x_pavv_tbl                     OUT NOCOPY pavv_tbl_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.update_price_att_value(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_pavv_tbl                     ,
    x_pavv_tbl                     );

Line: 826


 PROCEDURE delete_price_att_value(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pavv_rec                     IN pavv_rec_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.delete_price_att_value(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_pavv_rec                     );

Line: 852


 PROCEDURE delete_price_att_value(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pavv_tbl                     IN pavv_tbl_type ) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.delete_price_att_value(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_pavv_tbl                     );

Line: 1038


 PROCEDURE update_price_adj_attrib(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_paav_rec                     IN paav_rec_type,
    x_paav_rec                     OUT NOCOPY paav_rec_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.update_price_adj_attrib(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_paav_rec                     ,
    x_paav_rec                     );

Line: 1066


 PROCEDURE update_price_adj_attrib(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_paav_tbl                     IN paav_tbl_type,
    x_paav_tbl                     OUT NOCOPY paav_tbl_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.update_price_adj_attrib(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_paav_tbl                     ,
    x_paav_tbl                     );

Line: 1094


 PROCEDURE delete_price_adj_attrib(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_paav_rec                     IN paav_rec_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.delete_price_adj_attrib(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_paav_rec                     );

Line: 1120


 PROCEDURE delete_price_adj_attrib(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_paav_tbl                     IN paav_tbl_type) is
begin
  OKC_PRICE_ADJUSTMENT_PVT.delete_price_adj_attrib(
    p_api_version                  ,
    p_init_msg_list                ,
    x_return_status                ,
    x_msg_count                    ,
    x_msg_data                     ,
    p_paav_tbl                     );