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_BILLING_UTIL_PVT dependencies on OKL_API

Line 7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

3: ----------------------------------------------------------------------------
4: -- GLOBAL VARIABLES
5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BILLING_UTIL_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

Line 9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BILLING_UTIL_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;

Line 10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BILLING_UTIL_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:

Line 11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';

Line 26: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;

22: G_OKL_LLA_INVALID_DATE_FORMAT CONSTANT VARCHAR2(30) := 'OKL_LLA_INVALID_DATE_FORMAT';
23: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
24: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
25: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
26: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
28:
29: TYPE contract_invoice_rec IS RECORD (
30: khr_id NUMBER := Okl_Api.G_MISS_NUM,

Line 27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;

23: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
24: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
25: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
26: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
28:
29: TYPE contract_invoice_rec IS RECORD (
30: khr_id NUMBER := Okl_Api.G_MISS_NUM,
31: AMOUNT NUMBER := Okl_Api.G_MISS_NUM

Line 30: khr_id NUMBER := Okl_Api.G_MISS_NUM,

26: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
28:
29: TYPE contract_invoice_rec IS RECORD (
30: khr_id NUMBER := Okl_Api.G_MISS_NUM,
31: AMOUNT NUMBER := Okl_Api.G_MISS_NUM
32: );
33:
34: TYPE contract_invoice_tbl IS TABLE OF contract_invoice_rec INDEX BY BINARY_INTEGER;

Line 31: AMOUNT NUMBER := Okl_Api.G_MISS_NUM

27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
28:
29: TYPE contract_invoice_rec IS RECORD (
30: khr_id NUMBER := Okl_Api.G_MISS_NUM,
31: AMOUNT NUMBER := Okl_Api.G_MISS_NUM
32: );
33:
34: TYPE contract_invoice_tbl IS TABLE OF contract_invoice_rec INDEX BY BINARY_INTEGER;
35: ----------------------------------------------------------------------------

Line 71: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

67: --)
68: -------------------------------------------------------------------------------
69: PROCEDURE LAST_INVOICE_DATE(
70: p_api_version IN NUMBER
71: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
72: ,x_return_status OUT NOCOPY VARCHAR2
73: ,x_msg_count OUT NOCOPY NUMBER
74: ,x_msg_data OUT NOCOPY VARCHAR2
75: ,p_contract_id IN NUMBER

Line 105: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

101: --group by id;
102: -------------------------------------------------------------------------------
103: PROCEDURE INVOICE_AMOUNT_FOR_STREAM(
104: p_api_version IN NUMBER
105: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
106: ,x_return_status OUT NOCOPY VARCHAR2
107: ,x_msg_count OUT NOCOPY NUMBER
108: ,x_msg_data OUT NOCOPY VARCHAR2
109: ,p_stream_purpose IN VARCHAR2

Line 157: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

153: FUNCTION get_tld_amount_remaining( p_tld_id IN NUMBER ) RETURN NUMBER;
154:
155: PROCEDURE get_tld_balance(
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
158: ,p_tld_id IN NUMBER
159: ,x_return_status OUT NOCOPY VARCHAR2
160: ,x_msg_count OUT NOCOPY NUMBER
161: ,x_msg_data OUT NOCOPY VARCHAR2

Line 171: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

167: );
168:
169: PROCEDURE get_contract_invoice_balance(
170: p_api_version IN NUMBER
171: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
172: ,p_contract_number IN VARCHAR2
173: ,p_trx_number IN VARCHAR2
174: ,x_return_status OUT NOCOPY VARCHAR2
175: ,x_msg_count OUT NOCOPY NUMBER

Line 263: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

259:
260: --Added by bkatraga for bug 12378106
261: PROCEDURE CR_INVOICE_AMOUNT_FOR_STREAM(
262: p_api_version IN NUMBER
263: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
264: ,x_return_status OUT NOCOPY VARCHAR2
265: ,x_msg_count OUT NOCOPY NUMBER
266: ,x_msg_data OUT NOCOPY VARCHAR2
267: ,p_stream_purpose IN VARCHAR2