APPS.OKS_CONTRACT_SLL_PUB dependencies on OKC_API

Line 49: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_sllv_tbl IN sllv_tbl_type,
48: x_sllv_tbl OUT NOCOPY sllv_tbl_type,
49: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
50: p_validate_yn IN VARCHAR2) IS
51: BEGIN
52: x_return_status := G_RET_STS_SUCCESS;
53: IF p_validate_yn = 'Y' THEN

Line 160: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_sllv_tbl IN sllv_tbl_type,
159: x_sllv_tbl OUT NOCOPY sllv_tbl_type,
160: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
161: p_validate_yn IN VARCHAR2) IS
162: BEGIN
163: x_return_status := G_RET_STS_SUCCESS;
164: IF p_validate_yn = 'Y' THEN

Line 253: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,
252: p_sllv_tbl IN sllv_tbl_type,
253: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
254: BEGIN
255: oks_sll_pvt.lock_row
256: (
257: p_api_version => p_api_version,

Line 312: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_sllv_tbl IN sllv_tbl_type,
312: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
313: BEGIN
314: oks_sll_pvt.delete_row
315: (
316: p_api_version => p_api_version,

Line 363: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_sllv_tbl IN sllv_tbl_type,
363: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
364: BEGIN
365: x_return_status := G_RET_STS_SUCCESS;
366: END validate_sll;
367:

Line 412: x_return_status := OKC_API.G_RET_STS_SUCCESS;

408: i number;
409: j number;
410: Begin
411: -- Initialize return status
412: x_return_status := OKC_API.G_RET_STS_SUCCESS;
413:
414: i := p_sllv_tbl.FIRST;
415: j:=0;
416:

Line 508: OKC_API.SET_MESSAGE(

504: EXCEPTION
505: WHEN OTHERS THEN
506:
507: -- store SQL error message on message stack
508: OKC_API.SET_MESSAGE(
509: p_app_name => G_APP_NAME,
510: p_msg_name => G_UNEXPECTED_ERROR,
511: p_token1 => G_SQLCODE_TOKEN,
512: p_token1_value => SQLCODE,

Line 516: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

512: p_token1_value => SQLCODE,
513: p_token2 => G_SQLERRM_TOKEN,
514: p_token2_value => SQLERRM);
515: -- notify caller of an error as UNEXPETED error
516: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
517:
518: END INSERT_ROW_UPG;
519:
520: END oks_contract_sll_pub;