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_TLD_PVT

Line 10: subtype tldv_rec_type is okl_tld_pvt.tldv_rec_type;

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: ----------------------------------------------------------------------------
14: -- Variables For Debugging and Logging

Line 11: subtype tldv_tbl_type is okl_tld_pvt.tldv_tbl_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: ----------------------------------------------------------------------------
14: -- Variables For Debugging and Logging
15: ----------------------------------------------------------------------------

Line 55: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type

51: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
52: ,x_return_status OUT NOCOPY VARCHAR2
53: ,x_msg_count OUT NOCOPY NUMBER
54: ,x_msg_data OUT NOCOPY VARCHAR2
55: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type
56: ,p_tai_id IN OKL_TRX_AR_INVOICES_B.ID%TYPE
57: )
58: IS
59: l_api_name CONSTANT VARCHAR2(30) := 'create_accounting_dist';

Line 63: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;

59: l_api_name CONSTANT VARCHAR2(30) := 'create_accounting_dist';
60: l_api_version CONSTANT NUMBER := 1.0;
61: l_til_loop_cnt NUMBER;
62: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
63: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
64: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
65: l_tld_loop_cnt NUMBER;
66: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
67: l_til_id NUMBER;

Line 64: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;

60: l_api_version CONSTANT NUMBER := 1.0;
61: l_til_loop_cnt NUMBER;
62: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
63: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
64: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
65: l_tld_loop_cnt NUMBER;
66: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
67: l_til_id NUMBER;
68: l_trx_header_id OKL_TRX_AR_INVOICES_B.ID%TYPE;

Line 66: lx_tldv_rec okl_tld_pvt.tldv_rec_type;

62: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
63: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;
64: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
65: l_tld_loop_cnt NUMBER;
66: lx_tldv_rec okl_tld_pvt.tldv_rec_type;
67: l_til_id NUMBER;
68: l_trx_header_id OKL_TRX_AR_INVOICES_B.ID%TYPE;
69: l_til_debug_cnt NUMBER;
70: l_tld_debug_cnt NUMBER;

Line 1727: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_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: )
1730: is
1731: l_api_name CONSTANT VARCHAR2(30) := 'create_non_sel_billing_trx';

Line 1739: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;

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;
1743: l_tld_loop_cnt NUMBER;

Line 1740: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;

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;
1743: l_tld_loop_cnt NUMBER;
1744: l_til_ln_number NUMBER;

Line 1745: lx_tldv_rec okl_tld_pvt.tldv_rec_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;
1747: l_til_debug_cnt NUMBER;
1748: l_tld_debug_cnt NUMBER;
1749: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;

Line 1934: -- to TLD pl/sql record and call okl_tld_pvt.insert_row() to create TLD.

1930:
1931: /***
1932: -- Developer Note:
1933: -- 1. For each TIL record, copy STY_ID, AMOUNT, ORG_ID, INVENTORY_ORG_ID, INVENTORY_ITEM_ID
1934: -- to TLD pl/sql record and call okl_tld_pvt.insert_row() to create TLD.
1935: -- 2. lx_tilv_rec.TXL_AR_LINE_NUMBER is not required for this procesdure
1936: --
1937: ***/
1938: lp_tldv_tbl(l_til_loop_cnt).TIL_ID_DETAILS := l_til_id;

Line 1988: okl_tld_pvt.insert_row(

1984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1985: END IF;
1986: -- end: cklee -- add additional columns 3/19/07
1987:
1988: okl_tld_pvt.insert_row(
1989: p_api_version => p_api_version,
1990: p_init_msg_list => p_init_msg_list,
1991: x_return_status => l_return_status,
1992: x_msg_count => x_msg_count,

Line 2021: -- Create okl_TXD_AR_LN_DTLS_B record: okl_tld_pvt.insert_row;

2017:
2018: If lp_tldv_tbl(l_tld_loop_cnt).TXL_AR_LINE_NUMBER = l_til_ln_number then
2019: -- Assign lx_til_rec.ID to lp_tld_rec.TIL_ID_DETAILS;
2020: lp_tldv_tbl(l_tld_loop_cnt).TIL_ID_DETAILS := l_til_id;
2021: -- Create okl_TXD_AR_LN_DTLS_B record: okl_tld_pvt.insert_row;
2022: okl_tld_pvt.insert_row(
2023: p_api_version => p_api_version,
2024: p_init_msg_list => p_init_msg_list,
2025: x_return_status => l_return_status,

Line 2022: okl_tld_pvt.insert_row(

2018: If lp_tldv_tbl(l_tld_loop_cnt).TXL_AR_LINE_NUMBER = l_til_ln_number then
2019: -- Assign lx_til_rec.ID to lp_tld_rec.TIL_ID_DETAILS;
2020: lp_tldv_tbl(l_tld_loop_cnt).TIL_ID_DETAILS := l_til_id;
2021: -- Create okl_TXD_AR_LN_DTLS_B record: okl_tld_pvt.insert_row;
2022: okl_tld_pvt.insert_row(
2023: p_api_version => p_api_version,
2024: p_init_msg_list => p_init_msg_list,
2025: x_return_status => l_return_status,
2026: x_msg_count => x_msg_count,

Line 2237: -- ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type

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: --
2241: -- In this scenario, the following rules applied:

Line 2274: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type

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
2278: )

Line 2277: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_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';
2281: l_api_version CONSTANT NUMBER := 1.0;

Line 2288: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;

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;
2292: l_tld_loop_cnt NUMBER;

Line 2289: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;

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;
2292: l_tld_loop_cnt NUMBER;
2293: l_til_ln_number NUMBER;

Line 2294: lx_tldv_rec okl_tld_pvt.tldv_rec_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;
2296: l_til_debug_cnt NUMBER;
2297: l_tld_debug_cnt NUMBER;
2298: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;

Line 2513: -- Create okl_TXD_AR_LN_DTLS_B record: okl_tld_pvt.insert_row;

2509: lp_tldv_tbl(l_tld_loop_cnt).TIL_ID_DETAILS := l_til_id;
2510: lp_tldv_tbl(l_til_loop_cnt).LINE_DETAIL_NUMBER := l_til_loop_cnt;
2511: lp_tldv_tbl(l_tld_loop_cnt).KHR_ID := lp_taiv_rec.KHR_ID;
2512: lp_tldv_tbl(l_til_loop_cnt).KLE_ID := lp_tilv_tbl(l_til_loop_cnt).KLE_ID;
2513: -- Create okl_TXD_AR_LN_DTLS_B record: okl_tld_pvt.insert_row;
2514:
2515: -- rmunjulu R12 Fixes -- Added the below to populate the tld columns
2516: -- lp_tldv_tbl(l_til_loop_cnt).STY_ID := lx_tilv_rec.STY_ID;
2517: -- start: cklee til.amount may not be the same as tld amount, so commented the following code

Line 2562: okl_tld_pvt.insert_row(

2558: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2559: END IF;
2560: -- end: cklee -- add additional columns 3/19/07
2561:
2562: okl_tld_pvt.insert_row(
2563: p_api_version => p_api_version,
2564: p_init_msg_list => p_init_msg_list,
2565: x_return_status => l_return_status,
2566: x_msg_count => x_msg_count,

Line 2773: -- ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type

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: --
2777: -- In this scenario, the following rules applied:

Line 2831: ,p_tldv_tbl IN okl_tld_pvt.tldv_tbl_type

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
2835: )

Line 2834: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_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';
2838: l_api_version CONSTANT NUMBER := 1.0;

Line 2845: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type := p_tldv_tbl;

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;
2849: l_tld_loop_cnt NUMBER;

Line 2846: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;

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;
2849: l_tld_loop_cnt NUMBER;
2850: l_til_ln_number NUMBER;

Line 2851: lx_tldv_rec okl_tld_pvt.tldv_rec_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;
2853: l_til_debug_cnt NUMBER;
2854: l_tld_debug_cnt NUMBER;
2855: p_bpd_acc_rec Okl_Acc_Call_Pub.bpd_acc_rec_type;

Line 3196: ,x_tldv_tbl OUT NOCOPY okl_tld_pvt.tldv_tbl_type

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:
3200: l_api_name CONSTANT VARCHAR2(30) := 'update_manual_invoice';

Line 3208: lp_tldv_tbl okl_tld_pvt.tldv_tbl_type;

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;
3212: l_tld_loop_cnt NUMBER;

Line 3209: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;

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;
3212: l_tld_loop_cnt NUMBER;
3213: l_til_ln_number NUMBER;

Line 3214: lx_tldv_rec okl_tld_pvt.tldv_rec_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;
3216: til_id NUMBER;
3217: i NUMBER DEFAULT 0;
3218: crt_count NUMBER := 0;

Line 3322: -- to TLD pl/sql record and call okl_tld_pvt.insert_row() to create TLD.

3318:
3319: /***
3320: -- Developer Note:
3321: -- 1. For each TIL record, copy STY_ID, AMOUNT, ORG_ID, INVENTORY_ORG_ID, INVENTORY_ITEM_ID
3322: -- to TLD pl/sql record and call okl_tld_pvt.insert_row() to create TLD.
3323: -- 2. lx_tilv_rec.TXL_AR_LINE_NUMBER is not required for this procesdure
3324: ***/
3325: lp_tldv_tbl(i).ID := til_id;
3326: lp_tldv_tbl(i).STY_ID := lx_tilv_rec.STY_ID;

Line 3335: okl_tld_pvt.update_row(

3331: --lp_tldv_tbl(i).LINE_DETAIL_NUMBER := l_til_loop_cnt;
3332: lp_tldv_tbl(i).KHR_ID := lp_taiv_rec.KHR_ID;
3333: lp_tldv_tbl(i).KLE_ID := lx_tilv_rec.KLE_ID;
3334:
3335: okl_tld_pvt.update_row(
3336: p_api_version => p_api_version,
3337: p_init_msg_list => p_init_msg_list,
3338: x_return_status => l_return_status,
3339: x_msg_count => x_msg_count,

Line 3438: -- to TLD pl/sql record and call okl_tld_pvt.insert_row() to create TLD.

3434: l_til_id := lx_tilv_rec.id;
3435: /***
3436: -- Developer Note:
3437: -- 1. For each TIL record, copy STY_ID, AMOUNT, ORG_ID, INVENTORY_ORG_ID, INVENTORY_ITEM_ID
3438: -- to TLD pl/sql record and call okl_tld_pvt.insert_row() to create TLD.
3439: -- 2. lx_tilv_rec.TXL_AR_LINE_NUMBER is not required for this procesdure
3440: --
3441: ***/
3442: lp_tldv_tbl(i).TIL_ID_DETAILS := l_til_id;

Line 3487: okl_tld_pvt.insert_row(

3483: END IF;
3484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3485: END IF;
3486:
3487: okl_tld_pvt.insert_row(
3488: p_api_version => p_api_version,
3489: p_init_msg_list => p_init_msg_list,
3490: x_return_status => l_return_status,
3491: x_msg_count => x_msg_count,

Line 3617: l_tldv_rec okl_tld_pvt.tldv_rec_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
3621: FROM OKL_TXL_AR_INV_LNS_B

Line 3663: OKL_TLD_PVT.delete_row(p_api_version => p_api_version,

3659: FOR get_tld_dtl_rec in get_tld_dtl_csr(l_tilv_rec.id )
3660: LOOP
3661: l_tldv_rec.id := get_tld_dtl_rec.tld_id;
3662: --Delete a TLD Record.
3663: OKL_TLD_PVT.delete_row(p_api_version => p_api_version,
3664: p_init_msg_list => p_init_msg_list,
3665: x_return_status => l_return_status,
3666: x_msg_count => x_msg_count,
3667: x_msg_data => x_msg_data,

Line 3714: OKL_TLD_PVT.delete_row(p_api_version => p_api_version,

3710: FOR get_tld_dtl_rec in get_tld_dtl_csr(lp_til_id)
3711: LOOP
3712: l_tldv_rec.id := get_tld_dtl_rec.tld_id;
3713: --Delete a TLD Record.
3714: OKL_TLD_PVT.delete_row(p_api_version => p_api_version,
3715: p_init_msg_list => p_init_msg_list,
3716: x_return_status => l_return_status,
3717: x_msg_count => x_msg_count,
3718: x_msg_data => x_msg_data,