APPS.OKC_K_HISTORY_PVT dependencies on OKC_API

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

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL VARIABLES
8: ---------------------------------------------------------------------------
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

8: ---------------------------------------------------------------------------
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
17: G_EXCEPTION_HALT_VALIDATION exception;

Line 16: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

12: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
13: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
17: G_EXCEPTION_HALT_VALIDATION exception;
18: NO_CONTRACT_FOUND exception;
19: G_NO_UPDATE_ALLOWED_EXCEPTION exception;
20: G_NO_UPDATE_ALLOWED CONSTANT VARCHAR2(200) := 'OKC_NO_UPDATE_ALLOWED';

Line 37: x_return_status := OKC_API.G_RET_STS_SUCCESS;

33:
34: l_hstv_rec OKC_HST_PVT.hstv_rec_type := p_hstv_rec;
35: BEGIN
36: -- initialize return status
37: x_return_status := OKC_API.G_RET_STS_SUCCESS;
38:
39: OKC_HST_PVT.Insert_Row(
40: p_api_version => p_api_version,
41: p_init_msg_list => p_init_msg_list,

Line 91: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

87: p_hstv_rec => p_hstv_rec);
88: exception
89: when OTHERS then
90: -- store SQL error message on message stack
91: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
92: p_msg_name => g_unexpected_error,
93: p_token1 => g_sqlcode_token,
94: p_token1_value => sqlcode,
95: p_token2 => g_sqlerrm_token,

Line 99: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

95: p_token2 => g_sqlerrm_token,
96: p_token2_value => sqlerrm);
97:
98: -- notify caller of an UNEXPETED error
99: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
100: END delete_k_history;
101:
102: PROCEDURE delete_k_history(
103: p_api_version IN NUMBER,

Line 140: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

136: p_chr_id => p_chr_id);
137: exception
138: when OTHERS then
139: -- store SQL error message on message stack
140: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
141: p_msg_name => g_unexpected_error,
142: p_token1 => g_sqlcode_token,
143: p_token1_value => sqlcode,
144: p_token2 => g_sqlerrm_token,

Line 148: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

144: p_token2 => g_sqlerrm_token,
145: p_token2_value => sqlerrm);
146:
147: -- notify caller of an UNEXPETED error
148: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
149: END delete_all_rows;
150:
151: PROCEDURE validate_k_history(
152: p_api_version IN NUMBER,