APPS.OKL_IRK_PVT dependencies on OKC_UTIL

Line 418: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

414: RAISE G_EXCEPTION_HALT_VALIDATION;
415: END IF;
416:
417: -- Verify the value fits the length of the column in the database
418: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
419: ,p_col_name => 'id'
420: ,p_col_value => p_id
421: ,x_return_status => x_return_status);
422: -- verify that length is within allowed limits

Line 456: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

452: RAISE G_EXCEPTION_HALT_VALIDATION;
453: END IF;
454:
455: -- Verify the value fits the length of the column in the database
456: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
457: ,p_col_name => 'ranking_seq'
458: ,p_col_value => p_ranking_seq
459: ,x_return_status => x_return_status);
460: -- verify that length is within allowed limits

Line 494: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

490: RAISE G_EXCEPTION_HALT_VALIDATION;
491: END IF;
492:
493: -- Verify the value fits the length of the column in the database
494: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
495: ,p_col_name => 'object_version_number'
496: ,p_col_value => p_object_version_number
497: ,x_return_status => x_return_status);
498: -- verify that length is within allowed limits

Line 583: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

579: RAISE G_EXCEPTION_HALT_VALIDATION;
580: END IF;
581:
582: -- Verify the value fits the length of the column in the database
583: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
584: ,p_col_name => 'isu_id'
585: ,p_col_value => p_isu_id
586: ,x_return_status => x_return_status);
587: -- verify that length is within allowed limits

Line 623: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'

619:
620: /*
621:
622: -- Verify the value fits the length of the column in the database
623: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_INSURER_RANKINGS_V'
624: ,p_col_name => 'ic_code'
625: ,p_col_value => p_ic_code
626: ,x_return_status => x_return_status);
627: -- verify that length is within allowed limits

Line 658: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view

654: ) RETURN VARCHAR2 IS
655: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
656: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
657: BEGIN
658: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
659: OKC_UTIL.ADD_VIEW('OKL_INSURER_RANKINGS_V', x_return_status);
660: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
661: l_return_status := x_return_status;
662: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 659: OKC_UTIL.ADD_VIEW('OKL_INSURER_RANKINGS_V', x_return_status);

655: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
656: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
657: BEGIN
658: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
659: OKC_UTIL.ADD_VIEW('OKL_INSURER_RANKINGS_V', x_return_status);
660: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
661: l_return_status := x_return_status;
662: RAISE G_EXCEPTION_HALT_VALIDATION;
663: END IF;