DBA Data[Home] [Help]

APPS.OKS_CONTRACT_SLL_PUB dependencies on OKC_API

Line 9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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';

Line 10: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;

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';

Line 11: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;

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';

Line 12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;

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;

Line 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(

Line 17: G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;

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,

Line 37: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

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,

Line 62: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

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,

Line 87: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

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,

Line 112: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

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,

Line 134: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

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,