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_MATERIAL_DETAILS

Line 203: FROM gme_material_details

199: PROCEDURE lock_batch_dtl (P_material_detail_id IN NUMBER, P_last_update_date IN DATE,
200: X_return_status OUT NOCOPY VARCHAR2) IS
201: CURSOR Cur_lock_details IS
202: SELECT last_update_date
203: FROM gme_material_details
204: WHERE material_detail_id = P_material_detail_id
205: FOR UPDATE OF LAST_UPDATE_DATE NOWAIT;
206: X_last_update_date DATE;
207: BEGIN

Line 215: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_MATERIAL_DETAILS');

211: CLOSE Cur_lock_details;
212:
213: IF X_last_update_date <> P_last_update_date THEN
214: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_CHANGED');
215: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_MATERIAL_DETAILS');
216: FND_MSG_PUB.ADD;
217: X_return_status := FND_API.g_ret_sts_error;
218: END IF;
219: EXCEPTION

Line 225: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_MATERIAL_DETAILS');

221: IF Cur_lock_details%ISOPEN THEN
222: CLOSE Cur_lock_details;
223: END IF;
224: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_LOCKED');
225: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_MATERIAL_DETAILS');
226: FND_MESSAGE.SET_TOKEN('RECORD', 'MATERIAL_DETAIL_ID');
227: FND_MESSAGE.SET_TOKEN('KEY', P_material_detail_id);
228: FND_MSG_PUB.ADD;
229: X_return_status := FND_API.g_ret_sts_error;

Line 315: FROM gme_material_details e

311: WHERE batch_id = P_batch_id;
312:
313: CURSOR Cur_get_del_material IS
314: SELECT material_detail_id
315: FROM gme_material_details e
316: WHERE batch_id = P_batch_id
317: AND line_type <> 1
318: AND NOT EXISTS (SELECT 1
319: FROM gmd_material_details_gtmp g

Line 331: FROM gme_material_details

327: ORDER BY line_type, line_no;
328:
329: CURSOR Cur_get_detail_id(V_material_detail_id NUMBER) IS
330: SELECT 1
331: FROM gme_material_details
332: WHERE batch_id = P_batch_id
333: AND material_detail_id = V_material_detail_id;
334:
335: -- Bug# 3927768 Kapil M

Line 376: l_material_detail GME_MATERIAL_DETAILS%ROWTYPE;

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;
379: l_material_det GME_MATERIAL_DETAILS%ROWTYPE;
380: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;

Line 377: P_material GME_MATERIAL_DETAILS%ROWTYPE;

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;
379: l_material_det GME_MATERIAL_DETAILS%ROWTYPE;
380: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;
381: l_material_rec GME_MATERIAL_DETAILS%ROWTYPE;

Line 378: X_material GME_MATERIAL_DETAILS%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;
379: l_material_det GME_MATERIAL_DETAILS%ROWTYPE;
380: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;
381: l_material_rec GME_MATERIAL_DETAILS%ROWTYPE;
382: x_def_tran_row GME_INVENTORY_TXNS_GTMP%ROWTYPE;

Line 379: l_material_det GME_MATERIAL_DETAILS%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;
379: l_material_det GME_MATERIAL_DETAILS%ROWTYPE;
380: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;
381: l_material_rec GME_MATERIAL_DETAILS%ROWTYPE;
382: x_def_tran_row GME_INVENTORY_TXNS_GTMP%ROWTYPE;
383: x_material_row GME_MATERIAL_DETAILS%ROWTYPE;

Line 380: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;

376: l_material_detail GME_MATERIAL_DETAILS%ROWTYPE;
377: P_material GME_MATERIAL_DETAILS%ROWTYPE;
378: X_material GME_MATERIAL_DETAILS%ROWTYPE;
379: l_material_det GME_MATERIAL_DETAILS%ROWTYPE;
380: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;
381: l_material_rec GME_MATERIAL_DETAILS%ROWTYPE;
382: x_def_tran_row GME_INVENTORY_TXNS_GTMP%ROWTYPE;
383: x_material_row GME_MATERIAL_DETAILS%ROWTYPE;
384: l_pending_in_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;

Line 381: l_material_rec GME_MATERIAL_DETAILS%ROWTYPE;

377: P_material GME_MATERIAL_DETAILS%ROWTYPE;
378: X_material GME_MATERIAL_DETAILS%ROWTYPE;
379: l_material_det GME_MATERIAL_DETAILS%ROWTYPE;
380: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;
381: l_material_rec GME_MATERIAL_DETAILS%ROWTYPE;
382: x_def_tran_row GME_INVENTORY_TXNS_GTMP%ROWTYPE;
383: x_material_row GME_MATERIAL_DETAILS%ROWTYPE;
384: l_pending_in_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
385: l_pending_out_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;

Line 383: x_material_row GME_MATERIAL_DETAILS%ROWTYPE;

379: l_material_det GME_MATERIAL_DETAILS%ROWTYPE;
380: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;
381: l_material_rec GME_MATERIAL_DETAILS%ROWTYPE;
382: x_def_tran_row GME_INVENTORY_TXNS_GTMP%ROWTYPE;
383: x_material_row GME_MATERIAL_DETAILS%ROWTYPE;
384: l_pending_in_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
385: l_pending_out_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
386: l_labrec Cur_get_lablot%ROWTYPE;
387: type text_table is table of NUMBER(10) index by binary_integer;

Line 502: IF (GME_MATERIAL_DETAILS_DBL.FETCH_ROW (P_material, X_material)) THEN

498: WHERE parent_line_id = l_matl_rec.parent_line_id;
499: END IF;
500: ELSE
501: P_material.material_detail_id := l_matl_rec.material_detail_id;
502: IF (GME_MATERIAL_DETAILS_DBL.FETCH_ROW (P_material, X_material)) THEN
503: X_material.dtl_um := l_matl_rec.detail_uom;
504: IF (l_batch_row.batch_status = 1) THEN
505: X_material.plan_qty := l_matl_rec.qty;
506: ELSIF (l_batch_row.batch_status = 2) THEN

Line 627: UPDATE gme_material_details

623: IF l_rec.material_detail_id IS NOT NULL THEN
624: IF l_rec.text_code IS NOT NULL THEN
625: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(l_rec.text_code,'FM_TEXT_TBL_TL','GME_TEXT_TABLE_TL');
626:
627: UPDATE gme_material_details
628: SET text_code = l_text_code
629: WHERE material_detail_id = l_rec.material_detail_id;
630: END IF;
631: END IF;

Line 640: FROM gme_material_details

636: END LOOP;
637:
638: update gmd_material_details_gtmp a
639: set last_update_date = (select last_update_date
640: FROM gme_material_details
641: WHERE material_detail_id = a.material_detail_id);
642: EXCEPTION
643: WHEN error_setup THEN
644: ROLLBACK TO SAVEPOINT update_batch;

Line 716: FROM gme_material_details

712: WHERE reservation_id = V_reservation_id;
713:
714: CURSOR Cur_req_date IS
715: SELECT material_requirement_date
716: FROM gme_material_details
717: WHERE material_detail_id = P_material_detail_id;
718:
719: CURSOR Cur_get_new_qty IS
720: SELECT qty,transaction_id,lot_number

Line 731: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;

727: FROM mtl_transaction_lot_numbers
728: WHERE transaction_id = V_transaction_id
729: AND lot_number = V_lot_number;
730:
731: l_material_out GME_MATERIAL_DETAILS%ROWTYPE;
732:
733: l_return_status VARCHAR2(10);
734: l_reservation_qty NUMBER;
735: l_requirement_date DATE;