APPS.GMD_ERES_UTILS dependencies on GMD_OPERATIONS

Line 37: FROM gmd_operations

33: --===================================================================== */
34: PROCEDURE get_operation_no(P_oprn_id IN NUMBER, P_oprn_no OUT NOCOPY VARCHAR2) IS
35: CURSOR Cur_get_operation IS
36: SELECT oprn_no
37: FROM gmd_operations
38: WHERE oprn_id = P_oprn_id;
39: BEGIN
40: OPEN Cur_get_operation;
41: FETCH Cur_get_operation INTO P_oprn_no;

Line 62: FROM gmd_operations

58: --===================================================================== */
59: PROCEDURE get_operation_vers(P_oprn_id IN NUMBER,P_oprn_vers OUT NOCOPY NUMBER) IS
60: CURSOR Cur_get_operation IS
61: SELECT oprn_vers
62: FROM gmd_operations
63: WHERE oprn_id = P_oprn_id;
64: BEGIN
65: OPEN Cur_get_operation;
66: FETCH Cur_get_operation INTO P_oprn_vers;

Line 316: FROM gmd_operations

312: --===================================================================== */
313: PROCEDURE get_process_qty_um(P_oprn_id IN NUMBER,P_prc_qty_um OUT NOCOPY VARCHAR2) IS
314: CURSOR Cur_get_qty_um IS
315: SELECT process_qty_uom
316: FROM gmd_operations
317: WHERE oprn_id = P_oprn_id;
318: BEGIN
319: OPEN Cur_get_qty_um;
320: FETCH Cur_get_qty_um INTO P_prc_qty_um;

Line 575: UPDATE gmd_operations_b

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

Line 582: UPDATE gmd_operations_b

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

Line 590: UPDATE gmd_operations_b

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

Line 1205: FROM gmd_operations_b

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

Line 1209: UPDATE gmd_operations_b

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

Line 1272: UPDATE gmd_operations_b

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

Line 1313: 'GMD_OPERATIONS_B',

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