DBA Data[Home] [Help]

APPS.OKS_BTN_PVT dependencies on OKC_UTIL

Line 300: OKC_UTIL.CHECK_LENGTH

296: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
297: Begin
298: -- call column length utility
299: /*
300: OKC_UTIL.CHECK_LENGTH
301: (
302: p_view_name => 'OKS_BILL_TRANSACTIONS_V'
303: ,p_col_name => 'TRX_NUMBER'
304: ,p_col_value => P_Trx_Number

Line 351: OKC_UTIL.CHECK_LENGTH

347: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
348: Begin
349: -- call column length utility
350: /*
351: OKC_UTIL.CHECK_LENGTH
352: (
353: p_view_name => 'OKS_BILL_TRANSACTIONS_V'
354: ,p_col_name => 'TRX_AMOUNT'
355: ,p_col_value => P_Trx_Amount

Line 405: OKC_UTIL.CHECK_LENGTH

401:
402: -- call column length utility
403:
404: /*
405: OKC_UTIL.CHECK_LENGTH
406: (
407: p_view_name => 'OKS_BILL_TRANSACTIONS_V'
408: ,p_col_name => 'TRX_CLASS'
409: ,p_col_value => P_Trx_Class

Line 470: OKC_UTIL.CHECK_LENGTH

466:
467: -- call column length utility
468:
469: /*
470: OKC_UTIL.CHECK_LENGTH
471: (
472: p_view_name => 'OKS_BILL_TRANSACTIONS_V'
473: ,p_col_name => 'CURRENCY_CODE'
474: ,p_col_value => P_Currency_Code

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

519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
520: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
521:
522: Begin
523: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
524:
525: OKC_UTIL.ADD_VIEW('OKS_BILL_TRANSACTIONS_V',x_return_status);
526:
527: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 525: OKC_UTIL.ADD_VIEW('OKS_BILL_TRANSACTIONS_V',x_return_status);

521:
522: Begin
523: -- call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
524:
525: OKC_UTIL.ADD_VIEW('OKS_BILL_TRANSACTIONS_V',x_return_status);
526:
527: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
528: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
529: -- need to leave