APPS.OKS_BCL_PRINT_PREVIEW_PVT dependencies on OKC_UTIL

Line 335: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

331: RAISE G_EXCEPTION_HALT_VALIDATION;
332: END IF;
333:
334: -- Verify the value fits the length of the column in the database
335: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
336: ,p_col_name => 'id'
337: ,p_col_value => p_id
338: ,x_return_status => x_return_status);
339: -- verify that length is within allowed limits

Line 373: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

369: RAISE G_EXCEPTION_HALT_VALIDATION;
370: END IF;
371:
372: -- Verify the value fits the length of the column in the database
373: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
374: ,p_col_name => 'cle_id'
375: ,p_col_value => p_cle_id
376: ,x_return_status => x_return_status);
377: -- verify that length is within allowed limits

Line 411: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

407: RAISE G_EXCEPTION_HALT_VALIDATION;
408: END IF;
409:
410: -- Verify the value fits the length of the column in the database
411: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
412: ,p_col_name => 'date_billed_from'
413: ,p_col_value => p_date_billed_from
414: ,x_return_status => x_return_status);
415: -- verify that length is within allowed limits

Line 449: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

445: RAISE G_EXCEPTION_HALT_VALIDATION;
446: END IF;
447:
448: -- Verify the value fits the length of the column in the database
449: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
450: ,p_col_name => 'date_billed_to'
451: ,p_col_value => p_date_billed_to
452: ,x_return_status => x_return_status);
453: -- verify that length is within allowed limits

Line 487: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

483: RAISE G_EXCEPTION_HALT_VALIDATION;
484: END IF;
485:
486: -- Verify the value fits the length of the column in the database
487: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
488: ,p_col_name => 'sent_yn'
489: ,p_col_value => p_sent_yn
490: ,x_return_status => x_return_status);
491: -- verify that length is within allowed limits

Line 525: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'

521: RAISE G_EXCEPTION_HALT_VALIDATION;
522: END IF;
523:
524: -- Verify the value fits the length of the column in the database
525: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKS_BCL_PR'
526: ,p_col_name => 'object_version_number'
527: ,p_col_value => p_object_version_number
528: ,x_return_status => x_return_status);
529: -- verify that length is within allowed limits

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

554: ) RETURN VARCHAR2 IS
555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
556: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
557: BEGIN
558: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
559: OKC_UTIL.ADD_VIEW('OKS_BCL_PR', x_return_status);
560: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
561: l_return_status := x_return_status;
562: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 559: OKC_UTIL.ADD_VIEW('OKS_BCL_PR', x_return_status);

555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
556: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
557: BEGIN
558: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
559: OKC_UTIL.ADD_VIEW('OKS_BCL_PR', x_return_status);
560: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
561: l_return_status := x_return_status;
562: RAISE G_EXCEPTION_HALT_VALIDATION;
563: END IF;