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.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on GME_MATERIAL_DETAILS

Line 62: ,p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE

58: ========================================================================================================*/
59:
60: PROCEDURE incremental_backflush
61: (p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
62: ,p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE
63: ,p_qty IN NUMBER
64: ,p_qty_type IN NUMBER
65: ,p_trans_date IN DATE
66: ,p_backflush_rsrc_usg_ind IN NUMBER

Line 74: FROM gme_material_details

70: l_api_name CONSTANT VARCHAR2(30) := 'incremental_backflush';
71:
72: CURSOR Cur_fetch_incr_mat_dtl(v_batch_id NUMBER, v_matl_dtl_id NUMBER) IS
73: SELECT *
74: FROM gme_material_details
75: WHERE batch_id = v_batch_id
76: AND (release_type = gme_common_pvt.g_mtl_incremental_release
77: OR
78: (release_type = gme_common_pvt.g_mtl_manual_release AND material_detail_id = v_matl_dtl_id)

Line 109: l_material_detail_rec gme_material_details%ROWTYPE;

105: l_item_rec mtl_system_items%ROWTYPE;
106:
107: l_phantom_batch_rec gme_batch_header%ROWTYPE;
108: l_batch_header_rec gme_batch_header%ROWTYPE;
109: l_material_detail_rec gme_material_details%ROWTYPE;
110: l_in_material_detail_rec gme_material_details%ROWTYPE;
111: l_phantom_material_rec gme_material_details%ROWTYPE;
112: l_material_detail_tbl gme_common_pvt.material_details_tab;
113:

Line 110: l_in_material_detail_rec gme_material_details%ROWTYPE;

106:
107: l_phantom_batch_rec gme_batch_header%ROWTYPE;
108: l_batch_header_rec gme_batch_header%ROWTYPE;
109: l_material_detail_rec gme_material_details%ROWTYPE;
110: l_in_material_detail_rec gme_material_details%ROWTYPE;
111: l_phantom_material_rec gme_material_details%ROWTYPE;
112: l_material_detail_tbl gme_common_pvt.material_details_tab;
113:
114: l_batch_step_rec gme_batch_steps%ROWTYPE;

Line 111: l_phantom_material_rec gme_material_details%ROWTYPE;

107: l_phantom_batch_rec gme_batch_header%ROWTYPE;
108: l_batch_header_rec gme_batch_header%ROWTYPE;
109: l_material_detail_rec gme_material_details%ROWTYPE;
110: l_in_material_detail_rec gme_material_details%ROWTYPE;
111: l_phantom_material_rec gme_material_details%ROWTYPE;
112: l_material_detail_tbl gme_common_pvt.material_details_tab;
113:
114: l_batch_step_rec gme_batch_steps%ROWTYPE;
115: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

Line 369: IF NOT gme_material_details_dbl.fetch_row(l_phantom_material_rec, l_phantom_material_rec) THEN

365: END IF;
366:
367: l_phantom_material_rec.material_detail_id := l_material_detail_rec.phantom_line_id;
368:
369: IF NOT gme_material_details_dbl.fetch_row(l_phantom_material_rec, l_phantom_material_rec) THEN
370: RAISE error_fetch_matl;
371: END IF;
372:
373: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 501: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN

497: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
498: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling update material actual qty= '||l_material_detail_rec.actual_qty);
499: END IF;
500:
501: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN
502: RAISE error_update_row;
503: END IF;
504: END IF; -- IF l_upd_material THEN
505: ELSE -- lab batches or non transactable materials

Line 512: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN

508: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
509: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling update material actual qty= '||l_material_detail_rec.actual_qty);
510: END IF;
511:
512: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN
513: RAISE error_update_row;
514: END IF;
515: END IF; -- IF l_material_detail_rec.phantom_id IS NOT NULL THEN
516: END LOOP; -- FOR i IN 1 .. l_material_detail_tbl.COUNT LOOP

Line 597: (p_material_detail_rec IN gme_material_details%ROWTYPE

593:
594:
595: /*FPBug#4667093 Code added to consider new gme parameter for calculating factor */
596: PROCEDURE derive_factor
597: (p_material_detail_rec IN gme_material_details%ROWTYPE
598: ,p_qty IN NUMBER
599: ,p_qty_type IN NUMBER
600: ,p_gme_ib_factor IN NUMBER DEFAULT 0
601: ,x_pct_plan OUT NOCOPY NUMBER

Line 807: (p_material_detail_rec IN gme_material_details%ROWTYPE

803: x_return_status := FND_API.g_ret_sts_unexp_error;
804: END update_dependent_steps;
805:
806: PROCEDURE revert_material_partial
807: (p_material_detail_rec IN gme_material_details%ROWTYPE
808: ,p_qty IN NUMBER
809: ,p_lot_control_code IN NUMBER -- 1 = not lot control; 2 = lot control
810: ,p_create_resv_pend_lots IN NUMBER
811: ,p_lot_divisible_flag IN VARCHAR2

Line 1445: PROCEDURE validate_material_for_IB(p_material_detail_rec IN gme_material_details%ROWTYPE

1441: END IF;
1442: x_return_status := FND_API.g_ret_sts_unexp_error;
1443: END revert_material_partial;
1444:
1445: PROCEDURE validate_material_for_IB(p_material_detail_rec IN gme_material_details%ROWTYPE
1446: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1447: ,p_adjust_cmplt IN VARCHAR2
1448: ,x_return_status OUT NOCOPY VARCHAR2) IS
1449: