APPS.GMD_ERES_UTILS dependencies on GMD_ROUTINGS_B

Line 213: FROM gmd_routings_b

209: --===================================================================== */
210: PROCEDURE get_routing_no(P_routing_id IN NUMBER, P_routing_no OUT NOCOPY VARCHAR2) IS
211: CURSOR Cur_get_routing IS
212: SELECT routing_no
213: FROM gmd_routings_b
214: WHERE routing_id = P_routing_id;
215: BEGIN
216: OPEN Cur_get_routing;
217: FETCH Cur_get_routing INTO P_routing_no;

Line 238: FROM gmd_routings_b

234: --===================================================================== */
235: PROCEDURE get_routing_vers (P_routing_id IN NUMBER,P_routing_vers OUT NOCOPY NUMBER) IS
236: CURSOR Cur_get_routing IS
237: SELECT routing_vers
238: FROM gmd_routings_b
239: WHERE routing_id = P_routing_id;
240: BEGIN
241: OPEN Cur_get_routing;
242: FETCH Cur_get_routing INTO P_routing_vers;

Line 623: UPDATE gmd_routings_b

619: l_pending_status gmd_status.status_code%TYPE;
620: l_rework_status gmd_status.status_code%TYPE;
621: BEGIN
622: IF p_signature_status = 'SUCCESS' THEN
623: UPDATE gmd_routings_b
624: SET routing_status = p_to_status
625: WHERE routing_id = p_routing_id;
626: ELSIF p_signature_status = 'PENDING' THEN
627: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

Line 630: UPDATE gmd_routings_b

626: ELSIF p_signature_status = 'PENDING' THEN
627: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
628: ,p_to_status => p_to_status);
629: IF l_pending_status IS NOT NULL THEN
630: UPDATE gmd_routings_b
631: SET routing_status = l_pending_status
632: WHERE routing_id = p_routing_id;
633: END IF;
634: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN

Line 638: UPDATE gmd_routings_b

634: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
635: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
636: ,p_to_status => p_to_status);
637: IF l_rework_status IS NOT NULL THEN
638: UPDATE gmd_routings_b
639: SET routing_status = l_rework_status
640: WHERE routing_id = p_routing_id;
641: END IF;
642: END IF;

Line 1397: FROM gmd_routings_b

1393: l_object_type := FND_MESSAGE.GET;
1394:
1395: SELECT 'x'
1396: INTO l_text
1397: FROM gmd_routings_b
1398: WHERE routing_id = p_routing_id
1399: FOR UPDATE OF routing_status nowait;
1400:
1401: UPDATE gmd_routings_b

Line 1401: UPDATE gmd_routings_b

1397: FROM gmd_routings_b
1398: WHERE routing_id = p_routing_id
1399: FOR UPDATE OF routing_status nowait;
1400:
1401: UPDATE gmd_routings_b
1402: SET routing_status = p_to_status,
1403: last_update_date = sysdate,
1404: last_updated_by = l_user_id
1405: WHERE routing_id = p_routing_id;

Line 1461: UPDATE gmd_routings_b

1457: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
1458: ,p_parameter_value7=>-1);
1459: IF l_esig_reqd THEN
1460: X_return_status := 'P';
1461: UPDATE gmd_routings_b
1462: SET routing_status = p_pending_status
1463: WHERE routing_id = p_routing_id;
1464: IF p_called_from_form = 'F' THEN
1465: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');

Line 1501: 'GMD_ROUTINGS_B',

1497: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1498: END IF;
1499: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1500: 'TABLE_NAME',
1501: 'GMD_ROUTINGS_B',
1502: 'RECORD',
1503: 'ROUTING_NO : ROUTING_VERS = ',
1504: 'KEY',
1505: p_object_name||':'||p_object_version