DBA Data[Home] [Help]

APPS.OKC_CLS_UTIL dependencies on OKC_CLS_REST_CALLS_LOGS

Line 851: l_req_seq_id := OKC_CLS_REST_CALLS_LOGS_S.NEXTVAL;

847: l_api_name||': Error.' || x_err_msg);
848: END IF;
849: END IF;
850:
851: l_req_seq_id := OKC_CLS_REST_CALLS_LOGS_S.NEXTVAL;
852:
853: INSERT INTO OKC_CLS_REST_CALLS_LOGS(
854: ID,
855: REQUEST_METHOD,

Line 853: INSERT INTO OKC_CLS_REST_CALLS_LOGS(

849: END IF;
850:
851: l_req_seq_id := OKC_CLS_REST_CALLS_LOGS_S.NEXTVAL;
852:
853: INSERT INTO OKC_CLS_REST_CALLS_LOGS(
854: ID,
855: REQUEST_METHOD,
856: URL,
857: URI,

Line 958: UPDATE OKC_CLS_REST_CALLS_LOGS

954: ELSE
955: l_transaction_status := 'E';
956: END IF;
957:
958: UPDATE OKC_CLS_REST_CALLS_LOGS
959: SET RESPONSE_STATUS_CODE = p_response_status_code,
960: TRANSACTION_STATUS = l_transaction_status,
961: RESPONSE = p_response,
962: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,