APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 846: -- OKL_TXL_AR_INV_LNS_B

842: -- Start of comments
843: --
844: -- Procedure Name : additional_txl_attr
845: -- Description : Internal procedure to add additional columns for
846: -- OKL_TXL_AR_INV_LNS_B
847: -- Business Rules :
848: -- Parameters :
849: --
850: -- Version : 1.0

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

1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: END IF;
1899: -- end: cklee -- add additional columns 3/19/07
1900:
1901: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;
1902: okl_til_pvt.insert_row(
1903: p_api_version => p_api_version,
1904: p_init_msg_list => p_init_msg_list,
1905: x_return_status => l_return_status,

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

2452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2453: END IF;
2454: -- end: cklee -- add additional columns 3/19/07
2455:
2456: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;
2457: okl_til_pvt.insert_row(
2458: p_api_version => p_api_version,
2459: p_init_msg_list => p_init_msg_list,
2460: x_return_status => l_return_status,

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

3177: -- Parameters :
3178: -- IN : p_api_version - Standard input parameter
3179: -- p_init_msg_list - Standard input parameter
3180: -- p_taiv_rec - Record type for OKL_TRX_AR_INVOICES_B.
3181: -- p_tilv_tbl -- Table type for OKL_TXL_AR_INV_LNS_B.
3182: -- Version : 1.0
3183: -- History : gkhuntet created.
3184: -- End of comments
3185:

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

3409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3410: END IF;
3411:
3412:
3413: -- Create okl_TXL_AR_INV_LNS_B record: okl_til_pvt.insert_row;
3414: okl_til_pvt.insert_row(
3415: p_api_version => p_api_version,
3416: p_init_msg_list => p_init_msg_list,
3417: x_return_status => l_return_status,

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

3586: -- Parameters :
3587: -- IN : p_api_version - Standard input parameter
3588: -- p_init_msg_list - Standard input parameter
3589: -- p_taiv_id - ID of OKL_TRX_AR_INVOICES_B.
3590: -- p_tilv_id -- ID of OKL_TXL_AR_INV_LNS_B.
3591: -- Version : 1.0
3592: -- History : gkhuntet created.
3593: -- End of comments
3594:

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

3607: l_api_version CONSTANT NUMBER := 1.0;
3608: l_til_loop_cnt NUMBER;
3609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3610: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;
3611: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
3612: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
3613: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;
3614: l_til_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE ;
3615: l_taiv_rec okl_tai_pvt.taiv_rec_type;

Line 3613: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;

3609: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3610: lp_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE :=p_taiv_id;
3611: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
3612: l_tai_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
3613: l_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE ;
3614: l_til_id OKL_TXD_AR_LN_DTLS_B.ID%TYPE ;
3615: l_taiv_rec okl_tai_pvt.taiv_rec_type;
3616: l_tilv_rec okl_til_pvt.tilv_rec_type;
3617: l_tldv_rec okl_tld_pvt.tldv_rec_type;

Line 3621: FROM OKL_TXL_AR_INV_LNS_B

3617: l_tldv_rec okl_tld_pvt.tldv_rec_type;
3618:
3619: CURSOR get_til_dtl_csr IS
3620: SELECT ID til_id
3621: FROM OKL_TXL_AR_INV_LNS_B
3622: WHERE TAI_ID = p_taiv_id;
3623:
3624: get_til_dtl_rec get_til_dtl_csr%rowtype;
3625:

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

3622: WHERE TAI_ID = p_taiv_id;
3623:
3624: get_til_dtl_rec get_til_dtl_csr%rowtype;
3625:
3626: CURSOR get_tld_dtl_csr (g_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE) IS
3627: SELECT ID tld_id
3628: FROM OKL_TXD_AR_LN_DTLS_B
3629: WHERE TIL_ID_DETAILS = g_til_id;
3630: