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.31.12020000.3 2012/11/21 11:43:29 venkatho ship $ */
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 1845: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

Line 1873: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

Line 1875: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type

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

Line 1887: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;

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

Line 1888: lx_taiv_rec okl_tai_pvt.taiv_rec_type;

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

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

1969:
1970: /*** Begin API body ****************************************************/
1971:
1972:
1973: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;
1974:
1975: -- start: cklee -- add additional columns 3/19/07
1976: validate_tai_values(
1977: p_taiv_rec => lp_taiv_rec,

Line 2015: okl_tai_pvt.insert_row(

2011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2012: END IF;
2013: -- end: cklee -- add additional columns 3/19/07
2014:
2015: okl_tai_pvt.insert_row(
2016: p_api_version => p_api_version,
2017: p_init_msg_list => p_init_msg_list,
2018: x_return_status => l_return_status,
2019: x_msg_count => x_msg_count,

Line 2404: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

Line 2441: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

Line 2444: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type

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
2447: )
2448: is

Line 2453: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;

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

Line 2454: lx_taiv_rec okl_tai_pvt.taiv_rec_type;

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

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

2535: /*** Begin API body ****************************************************/
2536:
2537: --
2538:
2539: -- 2. Create okl_trx_ar_invoices_b record: okl_tai_pvt.insert_row;
2540:
2541: -- start: cklee -- add additional columns 3/19/07
2542:
2543: validate_tai_values(

Line 2572: okl_tai_pvt.insert_row(

2568: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2569: END IF;
2570: -- end: cklee -- add additional columns 3/19/07
2571:
2572: okl_tai_pvt.insert_row(
2573: p_api_version => p_api_version,
2574: p_init_msg_list => p_init_msg_list,
2575: x_return_status => l_return_status,
2576: x_msg_count => x_msg_count,

Line 2940: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

Line 2966: -- ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

Line 2998: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

Line 3001: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type

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
3004: ,p_cpl_id IN NUMBER DEFAULT NULL
3005: )

Line 3011: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;

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

Line 3012: lx_taiv_rec okl_tai_pvt.taiv_rec_type;

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

Line 3437: ,p_taiv_rec IN okl_tai_pvt.taiv_rec_type

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

Line 3439: ,x_taiv_rec OUT NOCOPY okl_tai_pvt.taiv_rec_type

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

Line 3449: lp_taiv_rec okl_tai_pvt.taiv_rec_type := p_taiv_rec;

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

Line 3450: lx_taiv_rec okl_tai_pvt.taiv_rec_type;

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

Line 3504: okl_tai_pvt.update_row(

3500: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3501: RAISE OKL_API.G_EXCEPTION_ERROR;
3502: END IF;
3503: --Updating the TAI table.
3504: okl_tai_pvt.update_row(
3505: p_api_version => p_api_version,
3506: p_init_msg_list => p_init_msg_list,
3507: x_return_status => l_return_status,
3508: x_msg_count => x_msg_count,

Line 3860: l_taiv_rec okl_tai_pvt.taiv_rec_type;

3856: lp_til_id OKL_TXL_AR_INV_LNS_B.ID%TYPE :=p_tilv_id;
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

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

3937:
3938: END LOOP;--End loop for TIL.
3939: --Delete a TAI Record.
3940: l_taiv_rec.id := lp_tai_id;
3941: OKL_TAI_PVT.delete_row(p_api_version => p_api_version,
3942: p_init_msg_list => p_init_msg_list,
3943: x_return_status => l_return_status,
3944: x_msg_count => x_msg_count,
3945: x_msg_data => x_msg_data,