DBA Data[Home] [Help]

APPS.OKS_CONTRACT_LINE_PUB dependencies on OKC_API

Line 138: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_klnv_tbl IN klnv_tbl_type,
137: x_klnv_tbl OUT NOCOPY klnv_tbl_type,
138: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
139: p_validate_yn IN VARCHAR2) IS
140: BEGIN
141: x_return_status := G_RET_STS_SUCCESS;
142: IF p_validate_yn = 'Y' THEN

Line 249: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_klnv_tbl IN klnv_tbl_type,
248: x_klnv_tbl OUT NOCOPY klnv_tbl_type,
249: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
250: p_validate_yn IN VARCHAR2) IS
251: BEGIN
252: x_return_status := G_RET_STS_SUCCESS;
253: IF p_validate_yn = 'Y' THEN

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

338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_klnv_tbl IN klnv_tbl_type,
342: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
343: BEGIN
344: oks_kln_pvt.lock_row
345: (
346: p_api_version => p_api_version,

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

397: x_return_status OUT NOCOPY VARCHAR2,
398: x_msg_count OUT NOCOPY NUMBER,
399: x_msg_data OUT NOCOPY VARCHAR2,
400: p_klnv_tbl IN klnv_tbl_type,
401: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
402: BEGIN
403: oks_kln_pvt.delete_row
404: (
405: p_api_version => p_api_version,

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

448: x_return_status OUT NOCOPY VARCHAR2,
449: x_msg_count OUT NOCOPY NUMBER,
450: x_msg_data OUT NOCOPY VARCHAR2,
451: p_klnv_tbl IN klnv_tbl_type,
452: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
453: BEGIN
454: x_return_status := G_RET_STS_SUCCESS;
455: END validate_line;
456:

Line 580: x_return_status := OKC_API.G_RET_STS_SUCCESS;

576:
577:
578: BEGIN
579: -- Initialize return status
580: x_return_status := OKC_API.G_RET_STS_SUCCESS;
581:
582: i := p_klnv_tbl.FIRST;
583: j:=0;
584: while i is not null

Line 913: OKC_API.SET_MESSAGE(

909: EXCEPTION
910: WHEN OTHERS THEN
911:
912: -- store SQL error message on message stack
913: OKC_API.SET_MESSAGE(
914: p_app_name => G_APP_NAME,
915: p_msg_name => G_UNEXPECTED_ERROR,
916: p_token1 => G_SQLCODE_TOKEN,
917: p_token1_value => SQLCODE,

Line 921: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

917: p_token1_value => SQLCODE,
918: p_token2 => G_SQLERRM_TOKEN,
919: p_token2_value => SQLERRM);
920: -- notify caller of an error as UNEXPETED error
921: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
922: --RAISE;
923: END INSERT_ROW_UPG;
924:
925: -------------------------------------------------------------------

Line 1038: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1034: j number;
1035:
1036:
1037: Begin
1038: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1039:
1040: i := p_klnhv_tbl.FIRST;
1041: j:=0;
1042:

Line 1377: OKC_API.SET_MESSAGE(

1373:
1374: EXCEPTION
1375: WHEN OTHERS THEN
1376: -- store SQL error message on message stack
1377: OKC_API.SET_MESSAGE(
1378: p_app_name => G_APP_NAME,
1379: p_msg_name => G_UNEXPECTED_ERROR,
1380: p_token1 => G_SQLCODE_TOKEN,
1381: p_token1_value => SQLCODE,

Line 1385: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1381: p_token1_value => SQLCODE,
1382: p_token2 => G_SQLERRM_TOKEN,
1383: p_token2_value => SQLERRM);
1384: -- notify caller of an error as UNEXPETED error
1385: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1386:
1387: End CREATE_LINE_VERSION_UPG;
1388:
1389: