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 578: x_return_status := OKC_API.G_RET_STS_SUCCESS;

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

Line 903: OKC_API.SET_MESSAGE(

899: EXCEPTION
900: WHEN OTHERS THEN
901:
902: -- store SQL error message on message stack
903: OKC_API.SET_MESSAGE(
904: p_app_name => G_APP_NAME,
905: p_msg_name => G_UNEXPECTED_ERROR,
906: p_token1 => G_SQLCODE_TOKEN,
907: p_token1_value => SQLCODE,

Line 911: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

907: p_token1_value => SQLCODE,
908: p_token2 => G_SQLERRM_TOKEN,
909: p_token2_value => SQLERRM);
910: -- notify caller of an error as UNEXPETED error
911: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
912: --RAISE;
913: END INSERT_ROW_UPG;
914:
915: -------------------------------------------------------------------

Line 1024: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1020: j number;
1021:
1022:
1023: Begin
1024: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1025:
1026: i := p_klnhv_tbl.FIRST;
1027: j:=0;
1028:

Line 1354: OKC_API.SET_MESSAGE(

1350:
1351: EXCEPTION
1352: WHEN OTHERS THEN
1353: -- store SQL error message on message stack
1354: OKC_API.SET_MESSAGE(
1355: p_app_name => G_APP_NAME,
1356: p_msg_name => G_UNEXPECTED_ERROR,
1357: p_token1 => G_SQLCODE_TOKEN,
1358: p_token1_value => SQLCODE,

Line 1362: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1358: p_token1_value => SQLCODE,
1359: p_token2 => G_SQLERRM_TOKEN,
1360: p_token2_value => SQLERRM);
1361: -- notify caller of an error as UNEXPETED error
1362: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1363:
1364: End CREATE_LINE_VERSION_UPG;
1365:
1366: