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
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
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
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
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
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