DBA Data[Home] [Help]

APPS.OKS_BSL_PRINT_PREVIEW_PVT dependencies on OKC_UTIL

Line 325: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'

321: RAISE G_EXCEPTION_HALT_VALIDATION;
322: END IF;
323:
324: -- Verify the value fits the length of the column in the database
325: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'
326: ,p_col_name => 'id'
327: ,p_col_value => p_id
328: ,x_return_status => x_return_status);
329: -- verify that length is within allowed limits

Line 363: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'

359: RAISE G_EXCEPTION_HALT_VALIDATION;
360: END IF;
361:
362: -- Verify the value fits the length of the column in the database
363: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'
364: ,p_col_name => 'bcl_id'
365: ,p_col_value => p_bcl_id
366: ,x_return_status => x_return_status);
367: -- verify that length is within allowed limits

Line 401: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'

397: RAISE G_EXCEPTION_HALT_VALIDATION;
398: END IF;
399:
400: -- Verify the value fits the length of the column in the database
401: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'
402: ,p_col_name => 'cle_id'
403: ,p_col_value => p_cle_id
404: ,x_return_status => x_return_status);
405: -- verify that length is within allowed limits

Line 439: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'

435: RAISE G_EXCEPTION_HALT_VALIDATION;
436: END IF;
437:
438: -- Verify the value fits the length of the column in the database
439: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'
440: ,p_col_name => 'object_version_number'
441: ,p_col_value => p_object_version_number
442: ,x_return_status => x_return_status);
443: -- verify that length is within allowed limits

Line 477: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'

473: RAISE G_EXCEPTION_HALT_VALIDATION;
474: END IF;
475:
476: -- Verify the value fits the length of the column in the database
477: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'
478: ,p_col_name => 'date_billed_from'
479: ,p_col_value => p_date_billed_from
480: ,x_return_status => x_return_status);
481: -- verify that length is within allowed limits

Line 515: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'

511: RAISE G_EXCEPTION_HALT_VALIDATION;
512: END IF;
513:
514: -- Verify the value fits the length of the column in the database
515: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSL_PR'
516: ,p_col_name => 'date_billed_to'
517: ,p_col_value => p_date_billed_to
518: ,x_return_status => x_return_status);
519: -- verify that length is within allowed limits

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

544: ) RETURN VARCHAR2 IS
545: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
546: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
547: BEGIN
548: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
549: OKC_UTIL.ADD_VIEW('OKS_BSL_PR', x_return_status);
550: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
551: l_return_status := x_return_status;
552: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 549: OKC_UTIL.ADD_VIEW('OKS_BSL_PR', x_return_status);

545: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
546: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
547: BEGIN
548: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
549: OKC_UTIL.ADD_VIEW('OKS_BSL_PR', x_return_status);
550: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
551: l_return_status := x_return_status;
552: RAISE G_EXCEPTION_HALT_VALIDATION;
553: END IF;