eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPREADSHEET_UPDATE dependencies on GME_BATCH_HEADER

Line 159: FROM gme_batch_header

155:
156: PROCEDURE lock_batch_hdr (P_batch_id IN NUMBER, P_last_update_date IN DATE, X_return_status OUT NOCOPY VARCHAR2) IS
157: CURSOR Cur_lock_header IS
158: SELECT last_update_date
159: FROM gme_batch_header
160: WHERE batch_id = P_batch_id
161: FOR UPDATE OF LAST_UPDATE_DATE NOWAIT;
162: X_last_update_date DATE;
163: BEGIN

Line 170: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_BATCH_HEADER');

166: FETCH Cur_lock_header INTO X_last_update_date;
167: CLOSE Cur_lock_header;
168: IF X_last_update_date <> P_last_update_date THEN
169: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_CHANGED');
170: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_BATCH_HEADER');
171: FND_MSG_PUB.ADD;
172: X_return_status := FND_API.g_ret_sts_error;
173: END IF;
174: EXCEPTION

Line 180: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_BATCH_HEADER');

176: IF Cur_lock_header%ISOPEN THEN
177: CLOSE Cur_lock_header;
178: END IF;
179: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_LOCKED');
180: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_BATCH_HEADER');
181: FND_MESSAGE.SET_TOKEN('RECORD', 'BATCH_ID');
182: FND_MESSAGE.SET_TOKEN('KEY', P_batch_id);
183: FND_MSG_PUB.ADD;
184: X_return_status := FND_API.g_ret_sts_error;

Line 310: FROM gme_batch_header

306: PROCEDURE update_batch (P_batch_id IN NUMBER, X_return_status OUT NOCOPY VARCHAR2) IS
307:
308: CURSOR Cur_get_batch IS
309: SELECT *
310: FROM gme_batch_header
311: WHERE batch_id = P_batch_id;
312:
313: CURSOR Cur_get_del_material IS
314: SELECT material_detail_id

Line 373: l_batch_row GME_BATCH_HEADER%ROWTYPE;

369: SELECT material_detail_id,text_code,orginal_text_code
370: FROM gmd_material_details_gtmp
371: WHERE text_code <> NVL(orginal_text_code,0);
372:
373: l_batch_row GME_BATCH_HEADER%ROWTYPE;
374: l_batch_rec GME_BATCH_HEADER%ROWTYPE;
375: l_batch_step GME_BATCH_STEPS%ROWTYPE;
376: l_material_detail GME_MATERIAL_DETAILS%ROWTYPE;
377: P_material GME_MATERIAL_DETAILS%ROWTYPE;

Line 374: l_batch_rec GME_BATCH_HEADER%ROWTYPE;

370: FROM gmd_material_details_gtmp
371: WHERE text_code <> NVL(orginal_text_code,0);
372:
373: l_batch_row GME_BATCH_HEADER%ROWTYPE;
374: l_batch_rec GME_BATCH_HEADER%ROWTYPE;
375: l_batch_step GME_BATCH_STEPS%ROWTYPE;
376: l_material_detail GME_MATERIAL_DETAILS%ROWTYPE;
377: P_material GME_MATERIAL_DETAILS%ROWTYPE;
378: X_material GME_MATERIAL_DETAILS%ROWTYPE;