5: ---------------------------------------------------------------------------
6: -- GLOBAL VARIABLES
7: ---------------------------------------------------------------------------
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_SLL_PUB';
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
6: -- GLOBAL VARIABLES
7: ---------------------------------------------------------------------------
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_SLL_PUB';
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
7: ---------------------------------------------------------------------------
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_SLL_PUB';
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_SLL_PUB';
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;
18: ---------------------------------------------------------------------------
19:
20: PROCEDURE create_sll(
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;
18: ---------------------------------------------------------------------------
19:
20: PROCEDURE create_sll(
21: p_api_version IN NUMBER,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_sllv_tbl IN sllv_tbl_type,
36: x_sllv_tbl OUT NOCOPY sllv_tbl_type,
37: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
38: p_validate_yn IN VARCHAR2);
39: PROCEDURE create_sll(
40: p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61: p_sllv_tbl IN sllv_tbl_type,
62: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
63: PROCEDURE lock_sll(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2,
66: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_sllv_tbl IN sllv_tbl_type,
86: x_sllv_tbl OUT NOCOPY sllv_tbl_type,
87: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
88: p_validate_yn IN VARCHAR2);
89: PROCEDURE update_sll(
90: p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_sllv_tbl IN sllv_tbl_type,
112: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
113: PROCEDURE delete_sll(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2,
116: x_return_status OUT NOCOPY VARCHAR2,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_sllv_tbl IN sllv_tbl_type,
134: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
135: PROCEDURE validate_sll(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2,
138: x_return_status OUT NOCOPY VARCHAR2,