APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 949: -- OKL_TXL_AR_INV_LNS_B

945: -- Start of comments
946: --
947: -- Procedure Name : additional_txl_attr
948: -- Description : Internal procedure to add additional columns for
949: -- OKL_TXL_AR_INV_LNS_B
950: -- Business Rules :
951: -- Parameters :
952: --
953: -- Version : 1.0

Line 2070: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;

2066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2067: END IF;
2068: -- end: cklee -- add additional columns 3/19/07
2069:
2070: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;
2071: okl_til_pvt.insert_row(
2072: p_api_version => p_api_version,
2073: p_init_msg_list => p_init_msg_list,
2074: x_return_status => l_return_status,

Line 2625: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;

2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2622: END IF;
2623: -- end: cklee -- add additional columns 3/19/07
2624:
2625: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;
2626: okl_til_pvt.insert_row(
2627: p_api_version => p_api_version,
2628: p_init_msg_list => p_init_msg_list,
2629: x_return_status => l_return_status,

Line 3426: -- p_tilv_tbl -- Table type for OKL_TXL_AR_INV_LNS_B.

3422: -- Parameters :
3423: -- IN : p_api_version - Standard input parameter
3424: -- p_init_msg_list - Standard input parameter
3425: -- p_taiv_rec - Record type for OKL_TRX_AR_INVOICES_B.
3426: -- p_tilv_tbl -- Table type for OKL_TXL_AR_INV_LNS_B.
3427: -- Version : 1.0
3428: -- History : gkhuntet created.
3429: -- End of comments
3430:

Line 3658: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;

3654: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3655: END IF;
3656:
3657:
3658: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;
3659: okl_til_pvt.insert_row(
3660: p_api_version => p_api_version,
3661: p_init_msg_list => p_init_msg_list,
3662: x_return_status => l_return_status,

Line 3835: -- p_tilv_id -- ID of OKL_TXL_AR_INV_LNS_B.

3831: -- Parameters :
3832: -- IN : p_api_version - Standard input parameter
3833: -- p_init_msg_list - Standard input parameter
3834: -- p_taiv_id - ID of OKL_TRX_AR_INVOICES_B.
3835: -- p_tilv_id -- ID of OKL_TXL_AR_INV_LNS_B.
3836: -- Version : 1.0
3837: -- History : gkhuntet created.
3838: -- End of comments
3839:

Line 3856: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;

3852: l_api_version CONSTANT NUMBER := 1.0;
3853: l_til_loop_cnt NUMBER;
3854: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3855: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;
3856: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
3857: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
3858: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;
3859: l_til_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE ;
3860: l_taiv_rec okl_tai_pvt.taiv_rec_type;

Line 3858: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;

3854: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3855: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;
3856: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
3857: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
3858: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;
3859: l_til_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE ;
3860: l_taiv_rec okl_tai_pvt.taiv_rec_type;
3861: l_tilv_rec okl_til_pvt.tilv_rec_type;
3862: l_tldv_rec okl_tld_pvt.tldv_rec_type;

Line 3866: FROM OKL_TXL_AR_INV_LNS_B

3862: l_tldv_rec okl_tld_pvt.tldv_rec_type;
3863:
3864: CURSOR get_til_dtl_csr IS
3865: SELECT ID til_id
3866: FROM OKL_TXL_AR_INV_LNS_B
3867: WHERE TAI_ID = p_taiv_id;
3868:
3869: get_til_dtl_rec get_til_dtl_csr%rowtype;
3870:

Line 3871: CURSOR get_tld_dtl_csr (g_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE) IS

3867: WHERE TAI_ID = p_taiv_id;
3868:
3869: get_til_dtl_rec get_til_dtl_csr%rowtype;
3870:
3871: CURSOR get_tld_dtl_csr (g_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE) IS
3872: SELECT ID tld_id
3873: FROM OKL_TXD_AR_LN_DTLS_B
3874: WHERE TIL_ID_DETAILS = g_til_id;
3875: