APPS.OKL_SUPP_INVOICE_DTLS_PVT SQL Statements

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

Line: 8

   G_WF_EVT_ASSET_SUP_INV_UPTD CONSTANT VARCHAR2(65)   := 'oracle.apps.okl.la.lease_contract.asset_supplier_invoice_updated';

Line: 87

     SELECT dnz_chr_id, cle_id
       FROM okc_k_lines_b
      WHERE id = p_cle_id;

Line: 95

     SELECT object1_id1 vendor_id
       FROM okc_k_party_roles_b
      WHERE dnz_chr_id = p_chr_id
        AND cle_id = p_cle_id
	AND rle_code = 'OKL_VENDOR';

Line: 124

     OKL_SID_PVT.insert_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_sidv_rec,
                            x_sidv_rec);

Line: 220

    OKL_SID_PVT.insert_row(p_api_version,
                           p_init_msg_list,
                           x_return_status,
                           x_msg_count,
                           x_msg_data,
                           p_sidv_tbl,
                           x_sidv_tbl);

Line: 374

   PROCEDURE update_sup_inv_dtls(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_sidv_rec                     IN sidv_rec_type,
     x_sidv_rec                     OUT NOCOPY sidv_rec_type)
     IS
     l_api_name          CONSTANT VARCHAR2(30) := 'UPDATE_SUP_INV_DTLS';

Line: 390

     SELECT a.dnz_chr_id, a.cle_id, b.cle_id
       FROM okc_k_lines_b a,
            okl_supp_invoice_dtls b
      WHERE a.id = b.cle_id
        AND b.id = p_cle_id;

Line: 400

     SELECT object1_id1 vendor_id
       FROM okc_k_party_roles_b
      WHERE dnz_chr_id = p_chr_id
        AND cle_id = p_cle_id
	AND rle_code = 'OKL_VENDOR';

Line: 430

     OKL_SID_PVT.update_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_sidv_rec,
                            x_sidv_rec);

Line: 498

   END update_sup_inv_dtls;

Line: 500

   PROCEDURE update_sup_inv_dtls(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_sidv_tbl                     IN sidv_tbl_type,
     x_sidv_tbl                     OUT NOCOPY sidv_tbl_type)
     IS
     l_api_name          CONSTANT VARCHAR2(30) := 'UPDATE_SUP_INV_DTLS';

Line: 527

     OKL_SID_PVT.update_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_sidv_tbl,
                            x_sidv_tbl);

Line: 560

   END update_sup_inv_dtls;

Line: 562

   PROCEDURE delete_sup_inv_dtls(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_sidv_rec                     IN sidv_rec_type)
     IS
     l_api_name          CONSTANT VARCHAR2(30) := 'DELETE_SUP_INV_DTLS';

Line: 587

     OKL_SID_PVT.delete_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_sidv_rec);

Line: 619

   END delete_sup_inv_dtls;

Line: 621

   PROCEDURE delete_sup_inv_dtls(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_sidv_tbl                     IN sidv_tbl_type)
     IS
     l_api_name          CONSTANT VARCHAR2(30) := 'DELETE_SUP_INV_DTLS';

Line: 646

     OKL_SID_PVT.delete_row(p_api_version,
                            p_init_msg_list,
                            x_return_status,
                            x_msg_count,
                            x_msg_data,
                            p_sidv_tbl);

Line: 678

   END delete_sup_inv_dtls;