DBA Data[Home] [Help]

APPS.OKL_STREAMS_UTIL dependencies on OKL_API

Line 13: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

9: ---------------------------------------------------------------------------
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
13: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STREAMS_UTIL';
15:
16:
17: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;

Line 17: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;

13: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STREAMS_UTIL';
15:
16:
17: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;

Line 18: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;

14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STREAMS_UTIL';
15:
16:
17: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
22:

Line 19: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;

15:
16:
17: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';

Line 20: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;

16:
17: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';

Line 21: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;

17: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
18: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
19: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';

19: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
20: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';

20: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
21: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;
28:

Line 25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

21: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;
28:
29: G_EXCEPTION_HALT_PROCESSING EXCEPTION;

Line 26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;

22:
23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;
28:
29: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
30: G_EXCEPTION_ERROR EXCEPTION;

Line 27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;

23: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
24: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
25: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;
28:
29: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
30: G_EXCEPTION_ERROR EXCEPTION;
31: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

165: -- History : BAKUCHIB 31-JUL-2003 - 2835092 created
166: -- End of Commnets
167: --------------------------------------------------------------------------------
168: FUNCTION Round_Streams_Amount(p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_chr_id IN okc_k_headers_b.id%TYPE,
173: p_selv_tbl IN Okl_Streams_Pub.selv_tbl_type,

Line 342: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

338: -- End of Commnets
339: --------------------------------------------------------------------------------
340: --Bug 4196515 - Start of Changes
341: FUNCTION round_streams_amount_esg(p_api_version IN NUMBER,
342: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
343: x_msg_count OUT NOCOPY NUMBER,
344: x_msg_data OUT NOCOPY VARCHAR2,
345: p_chr_id IN okc_k_headers_b.id%TYPE,
346: p_selv_tbl IN okl_streams_pub.selv_tbl_type,