DBA Data[Home] [Help]

APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKL_API

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

1: PACKAGE OKL_STREAM_MIGRATION_PVT AS
2: /* $Header: OKLRSMGS.pls 120.2 2005/10/30 03:17:20 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_STREAM_MIGRATION_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
6: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
7: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
8:
9: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;

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

5: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
6: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
7: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
8:
9: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;

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

6: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
7: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
8:
9: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
14:

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

7: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
8:
9: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
14:
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

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

8:
9: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
14:
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;

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

9: G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
10: G_MISS_CHAR CONSTANT VARCHAR2(1) := Okl_Api.G_MISS_CHAR;
11: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
14:
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

11: G_MISS_DATE CONSTANT DATE := Okl_Api.G_MISS_DATE;
12: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
14:
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;
18: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19:

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

12: G_TRUE CONSTANT VARCHAR2(1) := Okl_Api.G_TRUE;
13: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
14:
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;
18: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19:
20: G_EXCEPTION_HALT_PROCESSING EXCEPTION;

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

13: G_FALSE CONSTANT VARCHAR2(1) := Okl_Api.G_FALSE;
14:
15: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_ERROR;
17: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := Okl_Api.G_RET_STS_UNEXP_ERROR;
18: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
19:
20: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
21: G_EXCEPTION_ERROR EXCEPTION;

Line 48: sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM,

44:
45: SUBTYPE error_msgs_tbl_type IS Okl_Strm_Gen_Template_Pvt.error_msgs_tbl_type;
46:
47: TYPE dep_sty_rec IS RECORD (
48: sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM,
49: sty_code okl_strm_type_b.code%TYPE DEFAULT Okl_Api.G_MISS_CHAR,
50: stream_type_purpose okl_strm_type_b.stream_type_purpose%TYPE DEFAULT Okl_Api.G_MISS_CHAR
51: );
52:

Line 49: sty_code okl_strm_type_b.code%TYPE DEFAULT Okl_Api.G_MISS_CHAR,

45: SUBTYPE error_msgs_tbl_type IS Okl_Strm_Gen_Template_Pvt.error_msgs_tbl_type;
46:
47: TYPE dep_sty_rec IS RECORD (
48: sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM,
49: sty_code okl_strm_type_b.code%TYPE DEFAULT Okl_Api.G_MISS_CHAR,
50: stream_type_purpose okl_strm_type_b.stream_type_purpose%TYPE DEFAULT Okl_Api.G_MISS_CHAR
51: );
52:
53: TYPE dep_sty_tbl IS TABLE OF dep_sty_rec INDEX BY BINARY_INTEGER;

Line 50: stream_type_purpose okl_strm_type_b.stream_type_purpose%TYPE DEFAULT Okl_Api.G_MISS_CHAR

46:
47: TYPE dep_sty_rec IS RECORD (
48: sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM,
49: sty_code okl_strm_type_b.code%TYPE DEFAULT Okl_Api.G_MISS_CHAR,
50: stream_type_purpose okl_strm_type_b.stream_type_purpose%TYPE DEFAULT Okl_Api.G_MISS_CHAR
51: );
52:
53: TYPE dep_sty_tbl IS TABLE OF dep_sty_rec INDEX BY BINARY_INTEGER;
54: