APPS.GMD_ERES_UTILS dependencies on GMD_ITEM_SUBSTITUTION_HDR_B

Line 482: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B

478: l_derive_end_date DATE;
479: BEGIN
480: IF p_signature_status = 'SUCCESS' THEN
481:
482: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B
483: SET substitution_status = p_to_status
484: WHERE substitution_id = p_substitution_id;
485: UPDATE GMD_FORMULA_SUBSTITUTION SET Associated_flag ='Y'
486: WHERE substitution_id = P_substitution_id;

Line 494: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B

490: ELSIF p_signature_status = 'PENDING' THEN
491: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
492: ,p_to_status => p_to_status);
493: IF l_pending_status IS NOT NULL THEN
494: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B
495: SET substitution_status = l_pending_status
496: WHERE substitution_id = p_substitution_id;
497: END IF;
498: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN

Line 502: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B

498: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
499: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
500: ,p_to_status => p_to_status);
501: IF l_rework_status IS NOT NULL THEN
502: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B
503: SET substitution_status = l_rework_status
504: WHERE substitution_id = p_substitution_id;
505: END IF;
506: END IF;

Line 2079: FROM gmd_item_substitution_hdr_b

2075: X_return_status := FND_API.g_ret_sts_success;
2076:
2077: SELECT 'x'
2078: INTO l_text
2079: FROM gmd_item_substitution_hdr_b
2080: WHERE substitution_id = p_substitution_id
2081: FOR UPDATE OF substitution_status nowait;
2082:
2083: UPDATE gmd_item_substitution_hdr_b

Line 2083: UPDATE gmd_item_substitution_hdr_b

2079: FROM gmd_item_substitution_hdr_b
2080: WHERE substitution_id = p_substitution_id
2081: FOR UPDATE OF substitution_status nowait;
2082:
2083: UPDATE gmd_item_substitution_hdr_b
2084: SET substitution_status = p_to_status,
2085: last_update_date = sysdate,
2086: last_updated_by = fnd_global.user_id
2087: WHERE substitution_id = p_substitution_id;

Line 2147: UPDATE gmd_item_substitution_hdr_b

2143: ,p_parameter_value7=>-1);
2144:
2145: IF l_esig_reqd THEN
2146: X_return_status := 'P';
2147: UPDATE gmd_item_substitution_hdr_b
2148: SET substitution_status = p_pending_status
2149: WHERE substitution_id = p_substitution_id;
2150:
2151: IF p_called_from_form = 'F' THEN

Line 2178: 'GMD_ITEM_SUBSTITUTION_HDR_B',

2174: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2175: END IF;
2176: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
2177: 'TABLE_NAME',
2178: 'GMD_ITEM_SUBSTITUTION_HDR_B',
2179: 'RECORD',
2180: 'SUBSTITUTION_ID = ',
2181: 'KEY',
2182: P_substitution_id