DBA Data[Home] [Help]

APPS.OKC_PRICE_ADJUSTMENT_PVT SQL Statements

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

Line: 18

 okc_pat_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_patv_rec,
	    x_patv_rec);
Line: 38

 okc_pat_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_patv_tbl,
	    x_patv_tbl);
Line: 50

 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_pat_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_patv_rec,
	    x_patv_rec);
Line: 69

 END update_price_adjustment;
Line: 71

 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
 BEGIN

 okc_pat_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_patv_tbl,
	    x_patv_tbl);
Line: 90

 END update_price_adjustment;
Line: 92

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

    l_patv_rec  okc_price_adjustment_PUB.patv_rec_type;  --for price adjustments
Line: 106

    SELECT A.id,A.chr_id,A.cle_id
    FROM OKC_PRICE_ADJUSTMENTS_V A,
         OKC_PRICE_ADJ_ASSOCS_V  B
    WHERE B.pat_id_from = p_patv_rec.id
    AND   A.ID          = B.PAT_ID
    AND  (A.chr_id    = p_patv_rec.chr_id
        OR  A.cle_id    = p_patv_rec.cle_id);
Line: 115

    SELECT id
    FROM OKC_PRICE_ADJ_ASSOCS_V
    WHERE  pat_id_from = p_patv_rec.id;
Line: 121

    SELECT id
    FROM OKC_PRICE_ADJ_ATTRIBS_V
    WHERE  pat_id = p_patv_rec.id;
Line: 129

   okc_pat_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_patv_rec );
Line: 145

              OKC_PRICE_ADJUSTMENT_PUB.delete_price_adjustment(
                                    p_api_version  => p_api_version,
                                    p_init_msg_list => p_init_msg_list,
                                    x_return_status => x_return_status,
                                    x_msg_count    => x_msg_count,
                                    x_msg_data      => x_msg_data,
                                    p_patv_rec      => l_patv_rec);
Line: 164

              OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_assoc(
                                p_api_version  => p_api_version,
                                p_init_msg_list => p_init_msg_list,
                                x_return_status => x_return_status,
                                x_msg_count    => x_msg_count,
                                x_msg_data      => x_msg_data,
                                p_pacv_rec      => l_pacv_rec );
Line: 183

              OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_attrib(
                        p_api_version  => p_api_version,
                          p_init_msg_list => p_init_msg_list,
                        x_return_status => x_return_status,
                        x_msg_count    => x_msg_count,
                        x_msg_data      => x_msg_data,
                        p_paav_rec      => l_pavv_rec);
Line: 195

END delete_price_adjustment;
Line: 197

 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
 BEGIN

   okc_pat_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_patv_tbl);
Line: 214

 END delete_price_adjustment;
Line: 306

 okc_pac_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pacv_rec,
	    x_pacv_rec);
Line: 326

 okc_pac_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pacv_tbl,
	    x_pacv_tbl);
Line: 338

 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_pac_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pacv_rec,
	    x_pacv_rec);
Line: 357

 END update_price_adj_assoc;
Line: 359

 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_pac_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pacv_tbl,
	    x_pacv_tbl);
Line: 378

 END update_price_adj_assoc;
Line: 381

 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_pac_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pacv_rec );
Line: 398

 END delete_price_adj_assoc;
Line: 400

 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_pac_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pacv_tbl);
Line: 417

 END delete_price_adj_assoc;
Line: 507

 okc_paa_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_paav_rec,
	    x_paav_rec);
Line: 527

 okc_paa_pvt.insert_row(
	    p_api_version ,
            p_init_msg_list ,
            x_return_status ,
            x_msg_count ,
            x_msg_data ,
            p_paav_tbl ,
            x_paav_tbl );
Line: 540

 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_paa_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_paav_rec,
	    x_paav_rec);
Line: 559

 END update_price_adj_attrib;
Line: 561

 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_paa_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_paav_tbl,
	    x_paav_tbl);
Line: 580

 END update_price_adj_attrib;
Line: 583

 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_paa_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_paav_rec );
Line: 600

 END delete_price_adj_attrib;
Line: 602

 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_paa_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_paav_tbl);
Line: 619

 END delete_price_adj_attrib;
Line: 709

 okc_pav_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pavv_rec,
	    x_pavv_rec);
Line: 729

 okc_pav_pvt.insert_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pavv_tbl,
	    x_pavv_tbl);
Line: 741

 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_pav_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pavv_rec,
	    x_pavv_rec);
Line: 760

 END update_price_att_value;
Line: 762

 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_pav_pvt.update_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pavv_tbl,
	    x_pavv_tbl);
Line: 781

 END update_price_att_value;
Line: 784

 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_pav_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pavv_rec );
Line: 801

 END delete_price_att_value;
Line: 803

 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_pav_pvt.delete_row(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_pavv_tbl);
Line: 820

 END delete_price_att_value;