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

Line 14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;

10: G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
11: G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
14: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
15:
16: G_OKL_ST_STRM_ONE_PRI_PURPOSE CONSTANT VARCHAR2(30) := 'OKL_ST_STRM_ONE_PRI_PURPOSE';
17: G_OKL_ST_MANDATORY_PRI_PURPOSE CONSTANT VARCHAR2(30) := 'OKL_ST_MANDATORY_PRI_PURPOSE';
18: G_OKL_ST_ALL_INS_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_ST_ALL_INS_PURPOSES';

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

27:
28:
29: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
30:
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PVT';
33:
34: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
35: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;

Line 34: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;

30:
31: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PVT';
33:
34: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
35: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
36: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
37: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
38: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;

Line 35: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;

31: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PVT';
33:
34: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
35: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
36: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
37: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
38: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
39:

Line 36: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;

32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_STRM_GEN_TEMPLATE_PVT';
33:
34: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
35: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
36: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
37: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
38: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
39:
40: G_OKL_INV_PRIMARY_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_INV_PRIMARY_PURPOSES';

Line 37: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;

33:
34: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
35: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
36: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
37: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
38: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
39:
40: G_OKL_INV_PRIMARY_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_INV_PRIMARY_PURPOSES';
41: G_OKL_FIN_PRIMARY_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_FIN_PRIMARY_PURPOSES';

Line 38: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;

34: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
35: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
36: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
37: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
38: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
39:
40: G_OKL_INV_PRIMARY_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_INV_PRIMARY_PURPOSES';
41: G_OKL_FIN_PRIMARY_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_FIN_PRIMARY_PURPOSES';
42: G_OKL_FIN_DEPENDENT_PURPOSES CONSTANT VARCHAR2(30) := 'OKL_FIN_DEPENDENT_PURPOSES';

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

68: G_TYPE_ERROR CONSTANT VARCHAR2(12) := 'E';
69: G_TYPE_WARNING CONSTANT VARCHAR2(12) := 'W';
70: G_CP_SET_OUTCOME CONSTANT VARCHAR2(30) := 'CP_SET_OUTCOME';
71:
72: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
73: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
74: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
75: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
76: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

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

69: G_TYPE_WARNING CONSTANT VARCHAR2(12) := 'W';
70: G_CP_SET_OUTCOME CONSTANT VARCHAR2(30) := 'CP_SET_OUTCOME';
71:
72: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
73: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
74: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
75: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
76: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
77:

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

70: G_CP_SET_OUTCOME CONSTANT VARCHAR2(30) := 'CP_SET_OUTCOME';
71:
72: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
73: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
74: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
75: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
76: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
77:
78: G_EXCEPTION_HALT_PROCESSING EXCEPTION;

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

71:
72: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
73: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
74: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
75: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
76: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
77:
78: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
79: G_EXCEPTION_ERROR EXCEPTION;

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

72: G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
73: G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
74: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
75: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
76: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
77:
78: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
79: G_EXCEPTION_ERROR EXCEPTION;
80: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;

Line 99: error_message VARCHAR2(2500) DEFAULT OKL_API.G_MISS_CHAR

95: SUBTYPE gtlv_rec_type IS okl_gtl_pvt.gtlv_rec_type;
96: SUBTYPE gtlv_tbl_type IS okl_gtl_pvt.gtlv_tbl_type;
97:
98: TYPE error_msg_rec IS RECORD (
99: error_message VARCHAR2(2500) DEFAULT OKL_API.G_MISS_CHAR
100: ,error_type_code VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR
101: ,error_type_meaning VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR
102: );
103: TYPE error_msgs_tbl_type IS TABLE OF error_msg_rec

Line 100: ,error_type_code VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR

96: SUBTYPE gtlv_tbl_type IS okl_gtl_pvt.gtlv_tbl_type;
97:
98: TYPE error_msg_rec IS RECORD (
99: error_message VARCHAR2(2500) DEFAULT OKL_API.G_MISS_CHAR
100: ,error_type_code VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR
101: ,error_type_meaning VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR
102: );
103: TYPE error_msgs_tbl_type IS TABLE OF error_msg_rec
104: INDEX BY BINARY_INTEGER;

Line 101: ,error_type_meaning VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR

97:
98: TYPE error_msg_rec IS RECORD (
99: error_message VARCHAR2(2500) DEFAULT OKL_API.G_MISS_CHAR
100: ,error_type_code VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR
101: ,error_type_meaning VARCHAR2(30) DEFAULT OKL_API.G_MISS_CHAR
102: );
103: TYPE error_msgs_tbl_type IS TABLE OF error_msg_rec
104: INDEX BY BINARY_INTEGER;
105: