APPS.GMO_OPER_CERT_PUB dependencies on GMO_OPERATOR_CERT_TRANS

Line 362: update GMO_OPERATOR_CERT_TRANS

358: l_EVENT_NAME := p_EVENT_NAME ;
359:
360: IF l_operator_certificate_id IS NOT NULL THEN
361:
362: update GMO_OPERATOR_CERT_TRANS
363: set erecord_id = p_erecord_id
364: where operator_certificate_id = l_operator_certificate_id
365: AND erecord_id IS NULL ;
366:

Line 407: FROM GMO_OPERATOR_CERT_TRANS

403: ,x_return_status OUT NOCOPY VARCHAR2) IS
404: CURSOR CUR_GET_CERT_RECORD IS
405: SELECT EVENT_NAME,EVENT_KEY,USER_KEY_LABEL_TOKEN,USER_KEY_VALUE,ERECORD_ID,
406: Operator_certificate_id,TRANSACTION_ID
407: FROM GMO_OPERATOR_CERT_TRANS
408: WHERE operator_certificate_id = p_Operator_certificate_id;
409: BEGIN
410: x_return_status := fnd_api.g_ret_sts_success;
411: FOR get_rec IN CUR_GET_CERT_RECORD LOOP

Line 412: update GMO_OPERATOR_CERT_TRANS

408: WHERE operator_certificate_id = p_Operator_certificate_id;
409: BEGIN
410: x_return_status := fnd_api.g_ret_sts_success;
411: FOR get_rec IN CUR_GET_CERT_RECORD LOOP
412: update GMO_OPERATOR_CERT_TRANS
413: set EVENT_NAME = nvl(p_EVENT_NAME,get_rec.EVENT_NAME)
414: , EVENT_KEY = nvl(p_EVENT_KEY,get_rec.EVENT_KEY)
415: , USER_KEY_LABEL_TOKEN = nvl(p_user_key_label_token,get_rec.USER_KEY_LABEL_TOKEN)
416: , USER_KEY_VALUE = nvl(p_user_key_value,get_rec.USER_KEY_VALUE)