eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKL_TIL_PVT

Line 8: subtype tilv_rec_type is okl_til_pvt.tilv_rec_type;

4: -- Data Structures
5: ----------------------------------------------------------------------------
6: subtype taiv_rec_type is okl_tai_pvt.taiv_rec_type;
7: subtype taiv_tbl_type is okl_tai_pvt.taiv_tbl_type;
8: subtype tilv_rec_type is okl_til_pvt.tilv_rec_type;
9: subtype tilv_tbl_type is okl_til_pvt.tilv_tbl_type;
10: subtype tldv_rec_type is okl_tld_pvt.tldv_rec_type;
11: subtype tldv_tbl_type is okl_tld_pvt.tldv_tbl_type;
12:

Line 9: subtype tilv_tbl_type is okl_til_pvt.tilv_tbl_type;

5: ----------------------------------------------------------------------------
6: subtype taiv_rec_type is okl_tai_pvt.taiv_rec_type;
7: subtype taiv_tbl_type is okl_tai_pvt.taiv_tbl_type;
8: subtype tilv_rec_type is okl_til_pvt.tilv_rec_type;
9: subtype tilv_tbl_type is okl_til_pvt.tilv_tbl_type;
10: subtype tldv_rec_type is okl_tld_pvt.tldv_rec_type;
11: subtype tldv_tbl_type is okl_tld_pvt.tldv_tbl_type;
12:
13: ----------------------------------------------------------------------------

Line 1846: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

1842: --
1843: --
1844: -- If caller pass the following parameters with data,
1845: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
1846: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
1847: -- then system assume caller is intend to create non-stream based (without stream element)
1848: -- internal billing transactions.
1849: --
1850: -- In this scenario, p_tilv_tbl(n).TXL_AR_LINE_NUMBER is not a required attribute.

Line 1874: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

1870: ,x_return_status OUT NOCOPY VARCHAR2
1871: ,x_msg_count OUT NOCOPY NUMBER
1872: ,x_msg_data OUT NOCOPY VARCHAR2
1873: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
1874: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
1875: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
1876: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
1877: -- start: cklee -- fixed return parameters issues 4/6/07
1878: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type

Line 1876: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type

1872: ,x_msg_data OUT NOCOPY VARCHAR2
1873: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
1874: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
1875: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
1876: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
1877: -- start: cklee -- fixed return parameters issues 4/6/07
1878: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
1879: -- end: cklee -- fixed return parameters issues 4/6/07
1880: ,p_cpl_id IN NUMBER DEFAULT NULL

Line 1889: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;

1885: l_til_loop_cnt NUMBER;
1886: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1887: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
1888: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
1889: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
1890: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
1891: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1892: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1893: l_taiv_id NUMBER;

Line 1890: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

1886: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1887: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
1888: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
1889: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
1890: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
1891: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1892: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1893: l_taiv_id NUMBER;
1894: lx_tilv_rec okl_til_pvt.tilv_rec_type;

Line 1894: lx_tilv_rec okl_til_pvt.tilv_rec_type;

1890: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
1891: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1892: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1893: l_taiv_id NUMBER;
1894: lx_tilv_rec okl_til_pvt.tilv_rec_type;
1895: l_tld_loop_cnt NUMBER;
1896: l_til_ln_number NUMBER;
1897: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
1898: l_til_id NUMBER;

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 2071: okl_til_pvt.insert_row(

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,
2075: x_msg_count => x_msg_count,

Line 2405: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2401: -- Business Rules :
2402: --
2403: -- If caller pass the following parameters with data,
2404: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2405: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2406: -- ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2407: -- then system assume caller is intend to create stream based (with stream element)
2408: -- internal billing transactions.
2409: --

Line 2442: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2438: ,x_return_status OUT NOCOPY VARCHAR2
2439: ,x_msg_count OUT NOCOPY NUMBER
2440: ,x_msg_data OUT NOCOPY VARCHAR2
2441: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2442: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2443: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2444: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
2445: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
2446: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type

Line 2445: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type

2441: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2442: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2443: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2444: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
2445: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
2446: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
2447: )
2448: is
2449: l_api_name CONSTANT VARCHAR2(30) := 'create_sel_billing_trx';

Line 2455: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;

2451: l_til_loop_cnt NUMBER;
2452: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2453: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
2454: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
2455: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
2456: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2457: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
2458: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2459: l_taiv_id NUMBER;

Line 2456: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

2452: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2453: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
2454: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
2455: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
2456: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2457: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
2458: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2459: l_taiv_id NUMBER;
2460: lx_tilv_rec okl_til_pvt.tilv_rec_type;

Line 2460: lx_tilv_rec okl_til_pvt.tilv_rec_type;

2456: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2457: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
2458: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2459: l_taiv_id NUMBER;
2460: lx_tilv_rec okl_til_pvt.tilv_rec_type;
2461: l_tld_loop_cnt NUMBER;
2462: l_til_ln_number NUMBER;
2463: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
2464: l_til_id NUMBER;

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 2626: okl_til_pvt.insert_row(

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,
2630: x_msg_count => x_msg_count,

Line 2941: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2937: -- -----------------------------------------
2938: --
2939: -- If caller pass the following parameters with data,
2940: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2941: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2942: -- ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2943: -- then system assume caller is intend to create stream based (with stream element)
2944: -- internal billing transactions.
2945: --

Line 2967: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2963: -- -----------------------------------------
2964: --
2965: -- If caller pass the following parameters with data,
2966: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2967: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2968: -- then system assume caller is intend to create non-stream based (without stream element)
2969: -- internal billing transactions.
2970: --
2971: -- In this scenario, p_tilv_tbl(n).TXL_AR_LINE_NUMBER is not a required attribute.

Line 2999: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2995: ,x_return_status OUT NOCOPY VARCHAR2
2996: ,x_msg_count OUT NOCOPY NUMBER
2997: ,x_msg_data OUT NOCOPY VARCHAR2
2998: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2999: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
3000: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
3001: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
3002: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
3003: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type

Line 3002: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type

2998: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2999: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
3000: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
3001: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
3002: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
3003: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
3004: ,p_cpl_id IN NUMBER DEFAULT NULL
3005: )
3006: is

Line 3013: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;

3009: l_til_loop_cnt NUMBER;
3010: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3011: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
3012: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
3013: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
3014: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
3015: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
3016: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3017: l_taiv_id NUMBER;

Line 3014: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

3010: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3011: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
3012: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
3013: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
3014: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
3015: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
3016: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3017: l_taiv_id NUMBER;
3018: lx_tilv_rec okl_til_pvt.tilv_rec_type;

Line 3018: lx_tilv_rec okl_til_pvt.tilv_rec_type;

3014: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
3015: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
3016: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3017: l_taiv_id NUMBER;
3018: lx_tilv_rec okl_til_pvt.tilv_rec_type;
3019: l_tld_loop_cnt NUMBER;
3020: l_til_ln_number NUMBER;
3021: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
3022: l_til_id NUMBER;

Line 3438: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

3434: ,x_return_status OUT NOCOPY VARCHAR2
3435: ,x_msg_count OUT NOCOPY NUMBER
3436: ,x_msg_data OUT NOCOPY VARCHAR2
3437: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
3438: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
3439: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
3440: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
3441: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
3442: )

Line 3440: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type

3436: ,x_msg_data OUT NOCOPY VARCHAR2
3437: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
3438: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
3439: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
3440: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
3441: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
3442: )
3443: IS
3444:

Line 3451: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;

3447: l_til_loop_cnt NUMBER;
3448: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3449: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
3450: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
3451: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
3452: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
3453: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3454: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3455: l_taiv_id NUMBER;

Line 3452: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

3448: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3449: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
3450: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
3451: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
3452: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
3453: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3454: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3455: l_taiv_id NUMBER;
3456: lx_tilv_rec okl_til_pvt.tilv_rec_type;

Line 3456: lx_tilv_rec okl_til_pvt.tilv_rec_type;

3452: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
3453: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3454: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3455: l_taiv_id NUMBER;
3456: lx_tilv_rec okl_til_pvt.tilv_rec_type;
3457: l_tld_loop_cnt NUMBER;
3458: l_til_ln_number NUMBER;
3459: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
3460: l_til_id NUMBER;

Line 3465: l_tilv_Updt_tbl okl_til_pvt.tilv_tbl_type;

3461: til_id NUMBER;
3462: i NUMBER DEFAULT 0;
3463: crt_count NUMBER := 0;
3464: updt_count NUMBER := 0;
3465: l_tilv_Updt_tbl okl_til_pvt.tilv_tbl_type;
3466: l_tilv_Crt_tbl okl_til_pvt.tilv_tbl_type;
3467: l_flag_acc_call VARCHAR2(5);
3468:
3469: CURSOR get_tld_csr(p_til_id_details okl_txd_ar_ln_dtls_b.TIL_ID_DETAILS%TYPE) IS

Line 3466: l_tilv_Crt_tbl okl_til_pvt.tilv_tbl_type;

3462: i NUMBER DEFAULT 0;
3463: crt_count NUMBER := 0;
3464: updt_count NUMBER := 0;
3465: l_tilv_Updt_tbl okl_til_pvt.tilv_tbl_type;
3466: l_tilv_Crt_tbl okl_til_pvt.tilv_tbl_type;
3467: l_flag_acc_call VARCHAR2(5);
3468:
3469: CURSOR get_tld_csr(p_til_id_details okl_txd_ar_ln_dtls_b.TIL_ID_DETAILS%TYPE) IS
3470: SELECT ID FROM OKL_TXD_AR_LN_DTLS_B

Line 3542: okl_til_pvt.update_row(

3538:
3539: /***** Update the TIL records and correspondingly its TLD record. *****/
3540: FOR i IN l_tilv_Updt_tbl.FIRST .. l_tilv_Updt_tbl.LAST LOOP
3541:
3542: okl_til_pvt.update_row(
3543: p_api_version => p_api_version ,
3544: p_init_msg_list => p_init_msg_list,
3545: x_return_status => l_return_status,
3546: x_msg_count => x_msg_count,

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 3659: okl_til_pvt.insert_row(

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,
3663: x_msg_count => x_msg_count,

Line 3861: l_tilv_rec okl_til_pvt.tilv_rec_type;

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;
3863:
3864: CURSOR get_til_dtl_csr IS
3865: SELECT ID til_id

Line 3924: OKL_TIL_PVT.delete_row(p_api_version => p_api_version,

3920: END IF;
3921:
3922: END LOOP; --End loop for TLD
3923: --Delete a TIL Record.
3924: OKL_TIL_PVT.delete_row(p_api_version => p_api_version,
3925: p_init_msg_list => p_init_msg_list,
3926: x_return_status => l_return_status,
3927: x_msg_count => x_msg_count,
3928: x_msg_data => x_msg_data,

Line 3976: OKL_TIL_PVT.delete_row(p_api_version => p_api_version,

3972:
3973: END LOOP; --End loop for TLD.
3974: l_tilv_rec.id := lp_til_id;
3975: --Delete a TIL Record.
3976: OKL_TIL_PVT.delete_row(p_api_version => p_api_version,
3977: p_init_msg_list => p_init_msg_list,
3978: x_return_status => l_return_status,
3979: x_msg_count => x_msg_count,
3980: x_msg_data => x_msg_data,