DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKL_PARTY_PAYMENTS_PVT

Line 7367: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;

7363: FROM OKL_PARTY_PAYMENT_HDR pyh
7364: WHERE pyh.cle_id = p_kle_id;
7365:
7366: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
7367: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;
7368:
7369: --cursor to get party payment details for line
7370: CURSOR l_get_pyd_csr (p_kle_id IN NUMBER) is
7371: Select pyd.id

Line 7642: OKL_PARTY_PAYMENTS_PVT.DELETE_PARTY_PAYMENT_HDR

7638: End Loop;
7639: close l_get_pyh_csr;
7640:
7641: If l_pphv_tbl.COUNT > 0 then
7642: OKL_PARTY_PAYMENTS_PVT.DELETE_PARTY_PAYMENT_HDR
7643: (p_api_version => p_api_version,
7644: p_init_msg_list => p_init_msg_list,
7645: x_return_status => x_return_status,
7646: x_msg_count => x_msg_count,

Line 8240: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;

8236: FROM OKL_PARTY_PAYMENT_HDR pyh
8237: WHERE pyh.cle_id = p_kle_id;
8238:
8239: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
8240: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;
8241:
8242: --Bug# 4558486
8243: CURSOR l_kpl_csr(p_kle_id IN NUMBER,
8244: p_khr_id IN NUMBER) is

Line 8610: OKL_PARTY_PAYMENTS_PVT.DELETE_PARTY_PAYMENT_HDR

8606: End Loop;
8607: close l_get_pyh_csr;
8608:
8609: If l_pphv_tbl.COUNT > 0 then
8610: OKL_PARTY_PAYMENTS_PVT.DELETE_PARTY_PAYMENT_HDR
8611: (p_api_version => p_api_version,
8612: p_init_msg_list => p_init_msg_list,
8613: x_return_status => x_return_status,
8614: x_msg_count => x_msg_count,