DBA Data[Home] [Help]

APPS.GMD_SPREADSHEET_UPDATE dependencies on FM_MATL_DTL

Line 61: FROM fm_matl_dtl

57: PROCEDURE lock_formula_dtl (P_formulaline_id IN NUMBER, P_last_update_date IN DATE,
58: X_return_status OUT NOCOPY VARCHAR2) IS
59: CURSOR Cur_lock_details IS
60: SELECT last_update_date
61: FROM fm_matl_dtl
62: WHERE formulaline_id = P_formulaline_id
63: FOR UPDATE OF LAST_UPDATE_DATE NOWAIT;
64: X_last_update_date DATE;
65: BEGIN

Line 72: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_MATL_DTL');

68: FETCH Cur_lock_details INTO X_last_update_date;
69: CLOSE Cur_lock_details;
70: IF X_last_update_date <> P_last_update_date THEN
71: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_CHANGED');
72: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_MATL_DTL');
73: FND_MSG_PUB.ADD;
74: X_return_status := FND_API.g_ret_sts_error;
75: END IF;
76: EXCEPTION

Line 82: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_MATL_DTL');

78: IF Cur_lock_details%ISOPEN THEN
79: CLOSE Cur_lock_details;
80: END IF;
81: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_LOCK');
82: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_MATL_DTL');
83: FND_MESSAGE.SET_TOKEN('RECORD', 'FORMULALINE_ID');
84: FND_MESSAGE.SET_TOKEN('KEY', P_formulaline_id);
85: FND_MSG_PUB.ADD;
86: X_return_status := FND_API.g_ret_sts_error;