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 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