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 1695: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

1691: --
1692: --
1693: -- If caller pass the following parameters with data,
1694: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
1695: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
1696: -- then system assume caller is intend to create non-stream based (without stream element)
1697: -- internal billing transactions.
1698: --
1699: -- In this scenario, p_tilv_tbl(n).TXL_AR_LINE_NUMBER is not a required attribute.

Line 1723: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

1719: ,x_return_status OUT NOCOPY VARCHAR2
1720: ,x_msg_count OUT NOCOPY NUMBER
1721: ,x_msg_data OUT NOCOPY VARCHAR2
1722: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
1723: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
1724: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
1725: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
1726: -- start: cklee -- fixed return parameters issues 4/6/07
1727: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type

Line 1725: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type

1721: ,x_msg_data OUT NOCOPY VARCHAR2
1722: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
1723: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
1724: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
1725: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
1726: -- start: cklee -- fixed return parameters issues 4/6/07
1727: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
1728: -- end: cklee -- fixed return parameters issues 4/6/07
1729: )

Line 1737: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;

1733: l_til_loop_cnt NUMBER;
1734: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1735: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
1736: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
1737: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
1738: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
1739: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1740: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1741: l_taiv_id NUMBER;

Line 1738: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

1734: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1735: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
1736: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
1737: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
1738: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
1739: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1740: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1741: l_taiv_id NUMBER;
1742: lx_tilv_rec okl_til_pvt.tilv_rec_type;

Line 1742: lx_tilv_rec okl_til_pvt.tilv_rec_type;

1738: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
1739: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1740: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1741: l_taiv_id NUMBER;
1742: lx_tilv_rec okl_til_pvt.tilv_rec_type;
1743: l_tld_loop_cnt NUMBER;
1744: l_til_ln_number NUMBER;
1745: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
1746: l_til_id NUMBER;

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

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

Line 2236: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2232: -- Business Rules :
2233: --
2234: -- If caller pass the following parameters with data,
2235: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2236: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2237: -- ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2238: -- then system assume caller is intend to create stream based (with stream element)
2239: -- internal billing transactions.
2240: --

Line 2273: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2269: ,x_return_status OUT NOCOPY VARCHAR2
2270: ,x_msg_count OUT NOCOPY NUMBER
2271: ,x_msg_data OUT NOCOPY VARCHAR2
2272: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2273: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2274: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2275: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
2276: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
2277: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type

Line 2276: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type

2272: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2273: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2274: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2275: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
2276: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
2277: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
2278: )
2279: is
2280: l_api_name CONSTANT VARCHAR2(30) := 'create_sel_billing_trx';

Line 2286: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;

2282: l_til_loop_cnt NUMBER;
2283: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2284: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
2285: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
2286: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
2287: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2288: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
2289: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2290: l_taiv_id NUMBER;

Line 2287: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

2283: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2284: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
2285: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
2286: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
2287: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2288: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
2289: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2290: l_taiv_id NUMBER;
2291: lx_tilv_rec okl_til_pvt.tilv_rec_type;

Line 2291: lx_tilv_rec okl_til_pvt.tilv_rec_type;

2287: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2288: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
2289: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2290: l_taiv_id NUMBER;
2291: lx_tilv_rec okl_til_pvt.tilv_rec_type;
2292: l_tld_loop_cnt NUMBER;
2293: l_til_ln_number NUMBER;
2294: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
2295: l_til_id NUMBER;

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

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

Line 2772: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2768: -- -----------------------------------------
2769: --
2770: -- If caller pass the following parameters with data,
2771: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2772: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2773: -- ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2774: -- then system assume caller is intend to create stream based (with stream element)
2775: -- internal billing transactions.
2776: --

Line 2798: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2794: -- -----------------------------------------
2795: --
2796: -- If caller pass the following parameters with data,
2797: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2798: -- ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2799: -- then system assume caller is intend to create non-stream based (without stream element)
2800: -- internal billing transactions.
2801: --
2802: -- In this scenario, p_tilv_tbl(n).TXL_AR_LINE_NUMBER is not a required attribute.

Line 2830: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

2826: ,x_return_status OUT NOCOPY VARCHAR2
2827: ,x_msg_count OUT NOCOPY NUMBER
2828: ,x_msg_data OUT NOCOPY VARCHAR2
2829: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2830: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2831: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2832: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
2833: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
2834: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type

Line 2833: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type

2829: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
2830: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
2831: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
2832: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
2833: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
2834: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
2835: )
2836: is
2837: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_BILLING_TRX';

Line 2843: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;

2839: l_til_loop_cnt NUMBER;
2840: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2841: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
2842: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
2843: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
2844: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2845: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
2846: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2847: l_taiv_id NUMBER;

Line 2844: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

2840: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2841: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
2842: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
2843: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
2844: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2845: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
2846: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2847: l_taiv_id NUMBER;
2848: lx_tilv_rec okl_til_pvt.tilv_rec_type;

Line 2848: lx_tilv_rec okl_til_pvt.tilv_rec_type;

2844: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2845: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
2846: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2847: l_taiv_id NUMBER;
2848: lx_tilv_rec okl_til_pvt.tilv_rec_type;
2849: l_tld_loop_cnt NUMBER;
2850: l_til_ln_number NUMBER;
2851: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
2852: l_til_id NUMBER;

Line 3193: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type

3189: ,x_return_status OUT NOCOPY VARCHAR2
3190: ,x_msg_count OUT NOCOPY NUMBER
3191: ,x_msg_data OUT NOCOPY VARCHAR2
3192: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
3193: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
3194: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
3195: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
3196: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
3197: )

Line 3195: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type

3191: ,x_msg_data OUT NOCOPY VARCHAR2
3192: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type
3193: ,p_tilv_tbl IN okl_til_pvt.tilv_tbl_type
3194: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type
3195: ,x_tilv_tbl OUT NOCOPY okl_til_pvt.tilv_tbl_type
3196: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type
3197: )
3198: IS
3199:

Line 3206: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;

3202: l_til_loop_cnt NUMBER;
3203: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3204: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
3205: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
3206: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
3207: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
3208: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3209: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3210: l_taiv_id NUMBER;

Line 3207: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;

3203: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3204: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;
3205: lx_taiv_rec okl_tai_pvt.taiv_rec_type;
3206: lp_tilv_tbl okl_til_pvt.tilv_tbl_type := p_tilv_tbl;
3207: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
3208: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3209: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3210: l_taiv_id NUMBER;
3211: lx_tilv_rec okl_til_pvt.tilv_rec_type;

Line 3211: lx_tilv_rec okl_til_pvt.tilv_rec_type;

3207: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
3208: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3209: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3210: l_taiv_id NUMBER;
3211: lx_tilv_rec okl_til_pvt.tilv_rec_type;
3212: l_tld_loop_cnt NUMBER;
3213: l_til_ln_number NUMBER;
3214: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
3215: l_til_id NUMBER;

Line 3220: l_tilv_Updt_tbl okl_til_pvt.tilv_tbl_type;

3216: til_id NUMBER;
3217: i NUMBER DEFAULT 0;
3218: crt_count NUMBER := 0;
3219: updt_count NUMBER := 0;
3220: l_tilv_Updt_tbl okl_til_pvt.tilv_tbl_type;
3221: l_tilv_Crt_tbl okl_til_pvt.tilv_tbl_type;
3222: l_flag_acc_call VARCHAR2(5);
3223:
3224: CURSOR get_tld_csr(p_til_id_details okl_txd_ar_ln_dtls_b.TIL_ID_DETAILS%TYPE) IS

Line 3221: l_tilv_Crt_tbl okl_til_pvt.tilv_tbl_type;

3217: i NUMBER DEFAULT 0;
3218: crt_count NUMBER := 0;
3219: updt_count NUMBER := 0;
3220: l_tilv_Updt_tbl okl_til_pvt.tilv_tbl_type;
3221: l_tilv_Crt_tbl okl_til_pvt.tilv_tbl_type;
3222: l_flag_acc_call VARCHAR2(5);
3223:
3224: CURSOR get_tld_csr(p_til_id_details okl_txd_ar_ln_dtls_b.TIL_ID_DETAILS%TYPE) IS
3225: SELECT ID FROM OKL_TXD_AR_LN_DTLS_B

Line 3297: okl_til_pvt.update_row(

3293:
3294: /***** Update the TIL records and correspondingly its TLD record. *****/
3295: FOR i IN l_tilv_Updt_tbl.FIRST .. l_tilv_Updt_tbl.LAST LOOP
3296:
3297: okl_til_pvt.update_row(
3298: p_api_version => p_api_version ,
3299: p_init_msg_list => p_init_msg_list,
3300: x_return_status => l_return_status,
3301: x_msg_count => x_msg_count,

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

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

Line 3616: l_tilv_rec okl_til_pvt.tilv_rec_type;

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;
3618:
3619: CURSOR get_til_dtl_csr IS
3620: SELECT ID til_id

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

3675: END IF;
3676:
3677: END LOOP; --End loop for TLD
3678: --Delete a TIL Record.
3679: OKL_TIL_PVT.delete_row(p_api_version => p_api_version,
3680: p_init_msg_list => p_init_msg_list,
3681: x_return_status => l_return_status,
3682: x_msg_count => x_msg_count,
3683: x_msg_data => x_msg_data,

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

3727:
3728: END LOOP; --End loop for TLD.
3729: l_tilv_rec.id := lp_til_id;
3730: --Delete a TIL Record.
3731: OKL_TIL_PVT.delete_row(p_api_version => p_api_version,
3732: p_init_msg_list => p_init_msg_list,
3733: x_return_status => l_return_status,
3734: x_msg_count => x_msg_count,
3735: x_msg_data => x_msg_data,