DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKL_SUPP_INVOICE_DTLS_PUB

Line 7459: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;

7455: where cle_id = p_kle_id;
7456:
7457: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;
7458:
7459: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;
7460:
7461: --cursor to get party payment header for line
7462: -- Passthru, Bug 4350255
7463: CURSOR l_get_pyh_csr (p_kle_id IN NUMBER) is

Line 7939: OKL_SUPP_INVOICE_DTLS_PUB.delete_sup_inv_dtls

7935: End Loop;
7936: close l_get_sid_csr;
7937:
7938: If l_sidv_tbl.COUNT > 0 then
7939: OKL_SUPP_INVOICE_DTLS_PUB.delete_sup_inv_dtls
7940: (p_api_version => p_api_version,
7941: p_init_msg_list => p_init_msg_list,
7942: x_return_status => x_return_status,
7943: x_msg_count => x_msg_count,

Line 8318: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;

8314: where cle_id = p_kle_id;
8315:
8316: l_sid_id OKL_SUPP_INVOICE_DTLS.ID%TYPE;
8317:
8318: l_sidv_tbl OKL_SUPP_INVOICE_DTLS_PUB.sidv_tbl_type;
8319:
8320: --cursor to get party payment details for line
8321: CURSOR l_get_pyd_csr (p_kle_id IN NUMBER) is
8322: Select pyd.id

Line 8906: OKL_SUPP_INVOICE_DTLS_PUB.delete_sup_inv_dtls

8902: End Loop;
8903: close l_get_sid_csr;
8904:
8905: If l_sidv_tbl.COUNT > 0 then
8906: OKL_SUPP_INVOICE_DTLS_PUB.delete_sup_inv_dtls
8907: (p_api_version => p_api_version,
8908: p_init_msg_list => p_init_msg_list,
8909: x_return_status => x_return_status,
8910: x_msg_count => x_msg_count,