DBA Data[Home] [Help]

APPS.OKS_BSD_PRINT_PREVIEW_PVT dependencies on OKC_UTIL

Line 385: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'

381: RAISE G_EXCEPTION_HALT_VALIDATION;
382: END IF;
383:
384: -- Verify the value fits the length of the column in the database
385: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'
386: ,p_col_name => 'id'
387: ,p_col_value => p_id
388: ,x_return_status => x_return_status);
389: -- verify that length is within allowed limits

Line 423: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'

419: RAISE G_EXCEPTION_HALT_VALIDATION;
420: END IF;
421:
422: -- Verify the value fits the length of the column in the database
423: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'
424: ,p_col_name => 'bsl_id'
425: ,p_col_value => p_bsl_id
426: ,x_return_status => x_return_status);
427: -- verify that length is within allowed limits

Line 461: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'

457: RAISE G_EXCEPTION_HALT_VALIDATION;
458: END IF;
459:
460: -- Verify the value fits the length of the column in the database
461: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'
462: ,p_col_name => 'bsl_id_averaged'
463: ,p_col_value => p_bsl_id_averaged
464: ,x_return_status => x_return_status);
465: -- verify that length is within allowed limits

Line 499: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'

495: RAISE G_EXCEPTION_HALT_VALIDATION;
496: END IF;
497:
498: -- Verify the value fits the length of the column in the database
499: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'
500: ,p_col_name => 'unit_of_measure'
501: ,p_col_value => p_unit_of_measure
502: ,x_return_status => x_return_status);
503: -- verify that length is within allowed limits

Line 537: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'

533: RAISE G_EXCEPTION_HALT_VALIDATION;
534: END IF;
535:
536: -- Verify the value fits the length of the column in the database
537: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'
538: ,p_col_name => 'amcv_yn'
539: ,p_col_value => p_amcv_yn
540: ,x_return_status => x_return_status);
541: -- verify that length is within allowed limits

Line 575: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'

571: RAISE G_EXCEPTION_HALT_VALIDATION;
572: END IF;
573:
574: -- Verify the value fits the length of the column in the database
575: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'
576: ,p_col_name => 'result'
577: ,p_col_value => p_result
578: ,x_return_status => x_return_status);
579: -- verify that length is within allowed limits

Line 613: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'

609: RAISE G_EXCEPTION_HALT_VALIDATION;
610: END IF;
611:
612: -- Verify the value fits the length of the column in the database
613: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'
614: ,p_col_name => 'amount'
615: ,p_col_value => p_amount
616: ,x_return_status => x_return_status);
617: -- verify that length is within allowed limits

Line 651: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'

647: RAISE G_EXCEPTION_HALT_VALIDATION;
648: END IF;
649:
650: -- Verify the value fits the length of the column in the database
651: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BSD_PR'
652: ,p_col_name => 'object_version_number'
653: ,p_col_value => p_object_version_number
654: ,x_return_status => x_return_status);
655: -- verify that length is within allowed limits

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

680: ) RETURN VARCHAR2 IS
681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
682: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
683: BEGIN
684: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
685: OKC_UTIL.ADD_VIEW('OKS_BSD_PR', x_return_status);
686: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
687: l_return_status := x_return_status;
688: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 685: OKC_UTIL.ADD_VIEW('OKS_BSD_PR', x_return_status);

681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
682: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
683: BEGIN
684: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
685: OKC_UTIL.ADD_VIEW('OKS_BSD_PR', x_return_status);
686: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
687: l_return_status := x_return_status;
688: RAISE G_EXCEPTION_HALT_VALIDATION;
689: END IF;