APPS.GMD_ERES_UTILS dependencies on GMD_ITEM_SUBSTITUTION_HDR_B

Line 480: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B

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

Line 492: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B

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

Line 500: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B

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

Line 2077: FROM gmd_item_substitution_hdr_b

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

Line 2081: UPDATE gmd_item_substitution_hdr_b

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

Line 2145: UPDATE gmd_item_substitution_hdr_b

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

Line 2176: 'GMD_ITEM_SUBSTITUTION_HDR_B',

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