DBA Data[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_SUPP_INVOICE_DTLS_PVT

Line 5684: l_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;

5680: AND line.dnz_chr_id = parent_cle.dnz_chr_id
5681: --Bug# 8766336
5682: AND line.sts_code <> 'ABANDONED';
5683:
5684: l_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5685: x_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5686: l_sidv_temp_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5687:
5688: CURSOR supp_invoice_dtls_csr(p_cle_id OKC_K_LINES_B.ID%TYPE) IS

Line 5685: x_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;

5681: --Bug# 8766336
5682: AND line.sts_code <> 'ABANDONED';
5683:
5684: l_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5685: x_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5686: l_sidv_temp_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5687:
5688: CURSOR supp_invoice_dtls_csr(p_cle_id OKC_K_LINES_B.ID%TYPE) IS
5689: SELECT id,

Line 5686: l_sidv_temp_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;

5682: AND line.sts_code <> 'ABANDONED';
5683:
5684: l_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5685: x_sidv_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5686: l_sidv_temp_rec OKL_SUPP_INVOICE_DTLS_PVT.sidv_rec_type;
5687:
5688: CURSOR supp_invoice_dtls_csr(p_cle_id OKC_K_LINES_B.ID%TYPE) IS
5689: SELECT id,
5690: cle_id,

Line 5934: OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls(

5930: l_sidv_rec.shipping_address_id1 := l_supp_invoice_new_rec.shipping_address_id1;
5931: l_sidv_rec.shipping_address_id2 := l_supp_invoice_new_rec.shipping_address_id2;
5932: l_sidv_rec.shipping_address_code := l_supp_invoice_new_rec.shipping_address_code;
5933:
5934: OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls(
5935: p_api_version => 1.0,
5936: p_init_msg_list => OKL_API.G_FALSE,
5937: x_return_status => x_return_status,
5938: x_msg_count => x_msg_count,

Line 5945: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls failed ');

5941: x_sidv_rec => x_sidv_rec);
5942:
5943: -- check return status
5944: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5945: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls failed ');
5946: RAISE sync_failed;
5947: END IF;
5948:
5949: ELSIF ( NVL(l_supp_invoice_old_rec.invoice_number,OKL_API.G_MISS_CHAR) <> NVL(l_supp_invoice_new_rec.invoice_number,OKL_API.G_MISS_CHAR)

Line 5964: OKL_SUPP_INVOICE_DTLS_PVT.update_sup_inv_dtls(

5960: l_sidv_rec.shipping_address_id1 := l_supp_invoice_new_rec.shipping_address_id1;
5961: l_sidv_rec.shipping_address_id2 := l_supp_invoice_new_rec.shipping_address_id2;
5962: l_sidv_rec.shipping_address_code := l_supp_invoice_new_rec.shipping_address_code;
5963:
5964: OKL_SUPP_INVOICE_DTLS_PVT.update_sup_inv_dtls(
5965: p_api_version => 1.0,
5966: p_init_msg_list => OKL_API.G_FALSE,
5967: x_return_status => x_return_status,
5968: x_msg_count => x_msg_count,

Line 5975: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.update_sup_inv_dtls failed ');

5971: x_sidv_rec => x_sidv_rec);
5972:
5973: -- check return status
5974: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5975: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.update_sup_inv_dtls failed ');
5976: RAISE sync_failed;
5977: END IF;
5978:
5979: END IF;

Line 6227: OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls(

6223: l_sidv_rec.shipping_address_id1 := l_supp_invoice_new_rec.shipping_address_id1;
6224: l_sidv_rec.shipping_address_id2 := l_supp_invoice_new_rec.shipping_address_id2;
6225: l_sidv_rec.shipping_address_code := l_supp_invoice_new_rec.shipping_address_code;
6226:
6227: OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls(
6228: p_api_version => 1.0,
6229: p_init_msg_list => OKL_API.G_FALSE,
6230: x_return_status => x_return_status,
6231: x_msg_count => x_msg_count,

Line 6238: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls failed ');

6234: x_sidv_rec => x_sidv_rec);
6235:
6236: -- check return status
6237: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6238: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls failed ');
6239: RAISE sync_failed;
6240: END IF;
6241: END IF;
6242: