APPS.GMO_OPER_CERT_PUB dependencies on GMO_OPERATOR_CERT_TRANS

Line 365: update GMO_OPERATOR_CERT_TRANS

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

Line 410: FROM GMO_OPERATOR_CERT_TRANS

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

Line 415: update GMO_OPERATOR_CERT_TRANS

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