APPS.GMD_ERES_UTILS dependencies on GMD_OPERATIONS_B

Line 577: UPDATE gmd_operations_b

573: l_pending_status gmd_status.status_code%TYPE;
574: l_rework_status gmd_status.status_code%TYPE;
575: BEGIN
576: IF p_signature_status = 'SUCCESS' THEN
577: UPDATE gmd_operations_b
578: SET operation_status = p_to_status
579: WHERE oprn_id = p_oprn_id;
580: ELSIF p_signature_status = 'PENDING' THEN
581: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

Line 584: UPDATE gmd_operations_b

580: ELSIF p_signature_status = 'PENDING' THEN
581: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
582: ,p_to_status => p_to_status);
583: IF l_pending_status IS NOT NULL THEN
584: UPDATE gmd_operations_b
585: SET operation_status = l_pending_status
586: WHERE oprn_id = p_oprn_id;
587: END IF;
588: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN

Line 592: UPDATE gmd_operations_b

588: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
589: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
590: ,p_to_status => p_to_status);
591: IF l_rework_status IS NOT NULL THEN
592: UPDATE gmd_operations_b
593: SET operation_status = l_rework_status
594: WHERE oprn_id = p_oprn_id;
595: END IF;
596: END IF;

Line 1207: FROM gmd_operations_b

1203: l_object_type := FND_MESSAGE.GET;
1204:
1205: SELECT 'x'
1206: INTO l_text
1207: FROM gmd_operations_b
1208: WHERE oprn_id = p_oprn_id
1209: FOR UPDATE OF operation_status nowait;
1210:
1211: UPDATE gmd_operations_b

Line 1211: UPDATE gmd_operations_b

1207: FROM gmd_operations_b
1208: WHERE oprn_id = p_oprn_id
1209: FOR UPDATE OF operation_status nowait;
1210:
1211: UPDATE gmd_operations_b
1212: SET operation_status = p_to_status,
1213: last_update_date = sysdate,
1214: last_updated_by = l_user_id
1215: WHERE oprn_id = p_oprn_id;

Line 1274: UPDATE gmd_operations_b

1270:
1271: IF l_esig_reqd THEN
1272: X_return_status := 'P';
1273:
1274: UPDATE gmd_operations_b
1275: SET operation_status = p_pending_status
1276: WHERE oprn_id = p_oprn_id;
1277:
1278: IF p_called_from_form = 'F' THEN

Line 1315: 'GMD_OPERATIONS_B',

1311: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1312: END IF;
1313: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1314: 'TABLE_NAME',
1315: 'GMD_OPERATIONS_B',
1316: 'RECORD',
1317: 'OPRN_NO : OPRN_VERS = ',
1318: 'KEY',
1319: p_object_name||':'||p_object_version