DBA Data[Home] [Help]

APPS.GMD_SPREADSHEET_UPDATE dependencies on FM_FORM_MST

Line 17: FROM fm_form_mst

13:
14: PROCEDURE lock_formula_hdr (p_formula_id IN NUMBER, p_last_update_date IN DATE, X_return_status OUT NOCOPY VARCHAR2) IS
15: CURSOR Cur_lock_header IS
16: SELECT last_update_date
17: FROM fm_form_mst
18: WHERE formula_id = P_formula_id
19: FOR UPDATE OF LAST_UPDATE_DATE NOWAIT;
20: X_last_update_date DATE;
21: BEGIN

Line 28: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_FORM_MST');

24: FETCH Cur_lock_header INTO X_last_update_date;
25: CLOSE Cur_lock_header;
26: IF X_last_update_date <> P_last_update_date THEN
27: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_CHANGED');
28: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_FORM_MST');
29: FND_MSG_PUB.ADD;
30: X_return_status := FND_API.g_ret_sts_error;
31: END IF;
32: EXCEPTION

Line 38: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_FORM_MST');

34: IF Cur_lock_header%ISOPEN THEN
35: CLOSE Cur_lock_header;
36: END IF;
37: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_LOCK');
38: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_FORM_MST');
39: FND_MESSAGE.SET_TOKEN('RECORD', 'FORMULA_ID');
40: FND_MESSAGE.SET_TOKEN('KEY', P_formula_id);
41: FND_MSG_PUB.ADD;
42: X_return_status := FND_API.g_ret_sts_error;