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 621: UPDATE gmd_routings_b

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

Line 628: UPDATE gmd_routings_b

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

Line 636: UPDATE gmd_routings_b

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

Line 1395: FROM gmd_routings_b

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

Line 1399: UPDATE gmd_routings_b

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

Line 1459: UPDATE gmd_routings_b

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

Line 1499: 'GMD_ROUTINGS_B',

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