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_TAI_PVT

Line 6: subtype taiv_rec_type is okl_tai_pvt.taiv_rec_type;

2: /* $Header: OKLRIARB.pls 120.24 2008/06/17 04:14:35 asahoo noship $ */
3: ----------------------------------------------------------------------------
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;

Line 7: subtype taiv_tbl_type is okl_tai_pvt.taiv_tbl_type;

3: ----------------------------------------------------------------------------
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;

Line 1694: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

1690: -- Usage:
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: --

Line 1722: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

1718: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
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

Line 1724: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type

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
1728: -- end: cklee -- fixed return parameters issues 4/6/07

Line 1735: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;

1731: l_api_name CONSTANT VARCHAR2(30) := 'create_non_sel_billing_trx';
1732: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 1736: lx_taiv_rec okl_tai_pvt.taiv_rec_type;

1732: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 1814: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;

1810:
1811: /*** Begin API body ****************************************************/
1812:
1813:
1814: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;
1815:
1816: -- start: cklee -- add additional columns 3/19/07
1817: validate_tai_values(
1818: p_taiv_rec => lp_taiv_rec,

Line 1846: okl_tai_pvt.insert_row(

1842: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1843: END IF;
1844: -- end: cklee -- add additional columns 3/19/07
1845:
1846: okl_tai_pvt.insert_row(
1847: p_api_version => p_api_version,
1848: p_init_msg_list => p_init_msg_list,
1849: x_return_status => l_return_status,
1850: x_msg_count => x_msg_count,

Line 2235: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

2231: -- Description : wrapper api to create internal billing transactions
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.

Line 2272: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

2268: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
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

Line 2275: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type

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: )
2279: is

Line 2284: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;

2280: l_api_name CONSTANT VARCHAR2(30) := 'create_sel_billing_trx';
2281: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 2285: lx_taiv_rec okl_tai_pvt.taiv_rec_type;

2281: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 2370: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;

2366: /*** Begin API body ****************************************************/
2367:
2368: --
2369:
2370: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;
2371:
2372: -- start: cklee -- add additional columns 3/19/07
2373:
2374: validate_tai_values(

Line 2403: okl_tai_pvt.insert_row(

2399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2400: END IF;
2401: -- end: cklee -- add additional columns 3/19/07
2402:
2403: okl_tai_pvt.insert_row(
2404: p_api_version => p_api_version,
2405: p_init_msg_list => p_init_msg_list,
2406: x_return_status => l_return_status,
2407: x_msg_count => x_msg_count,

Line 2771: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

2767: -- (1) Caller pass 3 layers of billing data:
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.

Line 2797: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

2793: -- (2) Caller pass 2 layers of billing data:
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: --

Line 2829: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

2825: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
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

Line 2832: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type

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: )
2836: is

Line 2841: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;

2837: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_BILLING_TRX';
2838: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 2842: lx_taiv_rec okl_tai_pvt.taiv_rec_type;

2838: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 3192: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

3188: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
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

Line 3194: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type

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: )
3198: IS

Line 3204: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;

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

Line 3205: lx_taiv_rec okl_tai_pvt.taiv_rec_type;

3201: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 3259: okl_tai_pvt.update_row(

3255: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3256: RAISE OKL_API.G_EXCEPTION_ERROR;
3257: END IF;
3258: --Updating the TAI table.
3259: okl_tai_pvt.update_row(
3260: p_api_version => p_api_version,
3261: p_init_msg_list => p_init_msg_list,
3262: x_return_status => l_return_status,
3263: x_msg_count => x_msg_count,

Line 3615: l_taiv_rec okl_tai_pvt.taiv_rec_type;

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;
3618:
3619: CURSOR get_til_dtl_csr IS

Line 3696: OKL_TAI_PVT.delete_row(p_api_version => p_api_version,

3692:
3693: END LOOP;--End loop for TIL.
3694: --Delete a TAI Record.
3695: l_taiv_rec.id := lp_tai_id;
3696: OKL_TAI_PVT.delete_row(p_api_version => p_api_version,
3697: p_init_msg_list => p_init_msg_list,
3698: x_return_status => l_return_status,
3699: x_msg_count => x_msg_count,
3700: x_msg_data => x_msg_data,