APPS.OKL_CONTRACT_PVT dependencies on OKL_SUPP_INVOICE_DTLS

Line 7352: FROM OKL_SUPP_INVOICE_DTLS

7348: --Bug# 3143522 : delete supplier invoice details is line is deleted
7349: --cursor to ger supplier invoice details
7350: CURSOR l_get_sid_csr (p_kle_id IN NUMBER) is
7351: Select id
7352: FROM OKL_SUPP_INVOICE_DTLS
7353: where cle_id = p_kle_id;
7354:
7355: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;
7356:

Line 7355: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;

7351: Select id
7352: FROM OKL_SUPP_INVOICE_DTLS
7353: where cle_id = p_kle_id;
7354:
7355: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;
7356:
7357: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;
7358:
7359: --cursor to get party payment header for line

Line 7357: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;

7353: where cle_id = p_kle_id;
7354:
7355: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;
7356:
7357: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;
7358:
7359: --cursor to get party payment header for line
7360: -- Passthru, Bug 4350255
7361: CURSOR l_get_pyh_csr (p_kle_id IN NUMBER) is

Line 7837: OKL_SUPP_INVOICE_DTLS_PUB.delete_sup_inv_dtls

7833: End Loop;
7834: close l_get_sid_csr;
7835:
7836: If l_sidv_tbl.COUNT > 0 then
7837: OKL_SUPP_INVOICE_DTLS_PUB.delete_sup_inv_dtls
7838: (p_api_version => p_api_version,
7839: p_init_msg_list => p_init_msg_list,
7840: x_return_status => x_return_status,
7841: x_msg_count => x_msg_count,

Line 8211: FROM OKL_SUPP_INVOICE_DTLS

8207: --Bug# 3143522 : delete supplier invoice details is line is deleted
8208: --cursor to ger supplier invoice details
8209: CURSOR l_get_sid_csr (p_kle_id IN NUMBER) is
8210: Select id
8211: FROM OKL_SUPP_INVOICE_DTLS
8212: where cle_id = p_kle_id;
8213:
8214: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;
8215:

Line 8214: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;

8210: Select id
8211: FROM OKL_SUPP_INVOICE_DTLS
8212: where cle_id = p_kle_id;
8213:
8214: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;
8215:
8216: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;
8217:
8218: --cursor to get party payment details for line

Line 8216: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;

8212: where cle_id = p_kle_id;
8213:
8214: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;
8215:
8216: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;
8217:
8218: --cursor to get party payment details for line
8219: CURSOR l_get_pyd_csr (p_kle_id IN NUMBER) is
8220: Select pyd.id

Line 8804: OKL_SUPP_INVOICE_DTLS_PUB.delete_sup_inv_dtls

8800: End Loop;
8801: close l_get_sid_csr;
8802:
8803: If l_sidv_tbl.COUNT > 0 then
8804: OKL_SUPP_INVOICE_DTLS_PUB.delete_sup_inv_dtls
8805: (p_api_version => p_api_version,
8806: p_init_msg_list => p_init_msg_list,
8807: x_return_status => x_return_status,
8808: x_msg_count => x_msg_count,