DBA Data[Home] [Help]

APPS.OKS_BTL_PRINT_PREVIEW_PVT dependencies on OKC_UTIL

Line 320: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'

316: RAISE G_EXCEPTION_HALT_VALIDATION;
317: END IF;
318:
319: -- Verify the value fits the length of the column in the database
320: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'
321: ,p_col_name => 'id'
322: ,p_col_value => p_id
323: ,x_return_status => x_return_status);
324: -- verify that length is within allowed limits

Line 358: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'

354: RAISE G_EXCEPTION_HALT_VALIDATION;
355: END IF;
356:
357: -- Verify the value fits the length of the column in the database
358: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'
359: ,p_col_name => 'btn_id'
360: ,p_col_value => p_btn_id
361: ,x_return_status => x_return_status);
362: -- verify that length is within allowed limits

Line 396: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'

392: RAISE G_EXCEPTION_HALT_VALIDATION;
393: END IF;
394:
395: -- Verify the value fits the length of the column in the database
396: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'
397: ,p_col_name => 'bsl_id'
398: ,p_col_value => p_bsl_id
399: ,x_return_status => x_return_status);
400: -- verify that length is within allowed limits

Line 434: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'

430: RAISE G_EXCEPTION_HALT_VALIDATION;
431: END IF;
432:
433: -- Verify the value fits the length of the column in the database
434: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'
435: ,p_col_name => 'bcl_id'
436: ,p_col_value => p_bcl_id
437: ,x_return_status => x_return_status);
438: -- verify that length is within allowed limits

Line 472: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'

468: RAISE G_EXCEPTION_HALT_VALIDATION;
469: END IF;
470:
471: -- Verify the value fits the length of the column in the database
472: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'
473: ,p_col_name => 'object_version_number'
474: ,p_col_value => p_object_version_number
475: ,x_return_status => x_return_status);
476: -- verify that length is within allowed limits

Line 510: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'

506: RAISE G_EXCEPTION_HALT_VALIDATION;
507: END IF;
508:
509: -- Verify the value fits the length of the column in the database
510: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BTL_PR'
511: ,p_col_name => 'bill_instance_number'
512: ,p_col_value => p_bill_instance_number
513: ,x_return_status => x_return_status);
514: -- verify that length is within allowed limits

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

539: ) RETURN VARCHAR2 IS
540: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
541: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
542: BEGIN
543: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
544: OKC_UTIL.ADD_VIEW('OKS_BTL_PR', x_return_status);
545: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
546: l_return_status := x_return_status;
547: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 544: OKC_UTIL.ADD_VIEW('OKS_BTL_PR', x_return_status);

540: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
541: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
542: BEGIN
543: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
544: OKC_UTIL.ADD_VIEW('OKS_BTL_PR', x_return_status);
545: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
546: l_return_status := x_return_status;
547: RAISE G_EXCEPTION_HALT_VALIDATION;
548: END IF;