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 105: ,p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE

101: Do not update the actual quantity for non transactable material items.
102: ========================================================================================================*/
103: PROCEDURE incremental_backflush
104: (p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
105: ,p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE
106: ,p_qty IN NUMBER
107: ,p_qty_type IN NUMBER
108: ,p_trans_date IN DATE
109: ,p_backflush_rsrc_usg_ind IN NUMBER

Line 117: FROM gme_material_details

113: l_api_name CONSTANT VARCHAR2(30) := 'incremental_backflush';
114:
115: CURSOR Cur_fetch_incr_mat_dtl(v_batch_id NUMBER, v_matl_dtl_id NUMBER) IS
116: SELECT *
117: FROM gme_material_details
118: WHERE batch_id = v_batch_id
119: AND (release_type = gme_common_pvt.g_mtl_incremental_release
120: OR
121: (release_type = gme_common_pvt.g_mtl_manual_release AND material_detail_id = v_matl_dtl_id)

Line 152: l_material_detail_rec gme_material_details%ROWTYPE;

148: l_item_rec mtl_system_items%ROWTYPE;
149:
150: l_phantom_batch_rec gme_batch_header%ROWTYPE;
151: l_batch_header_rec gme_batch_header%ROWTYPE;
152: l_material_detail_rec gme_material_details%ROWTYPE;
153: l_in_material_detail_rec gme_material_details%ROWTYPE;
154: l_phantom_material_rec gme_material_details%ROWTYPE;
155: l_material_detail_tbl gme_common_pvt.material_details_tab;
156:

Line 153: l_in_material_detail_rec gme_material_details%ROWTYPE;

149:
150: l_phantom_batch_rec gme_batch_header%ROWTYPE;
151: l_batch_header_rec gme_batch_header%ROWTYPE;
152: l_material_detail_rec gme_material_details%ROWTYPE;
153: l_in_material_detail_rec gme_material_details%ROWTYPE;
154: l_phantom_material_rec gme_material_details%ROWTYPE;
155: l_material_detail_tbl gme_common_pvt.material_details_tab;
156:
157: l_batch_step_rec gme_batch_steps%ROWTYPE;

Line 154: l_phantom_material_rec gme_material_details%ROWTYPE;

150: l_phantom_batch_rec gme_batch_header%ROWTYPE;
151: l_batch_header_rec gme_batch_header%ROWTYPE;
152: l_material_detail_rec gme_material_details%ROWTYPE;
153: l_in_material_detail_rec gme_material_details%ROWTYPE;
154: l_phantom_material_rec gme_material_details%ROWTYPE;
155: l_material_detail_tbl gme_common_pvt.material_details_tab;
156:
157: l_batch_step_rec gme_batch_steps%ROWTYPE;
158: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

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

415: END IF;
416:
417: l_phantom_material_rec.material_detail_id := l_material_detail_rec.phantom_line_id;
418:
419: IF NOT gme_material_details_dbl.fetch_row(l_phantom_material_rec, l_phantom_material_rec) THEN
420: RAISE error_fetch_matl;
421: END IF;
422:
423: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

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

565: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
566: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling update material actual qty= '||l_material_detail_rec.actual_qty);
567: END IF;
568:
569: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN
570: RAISE error_update_row;
571: END IF;
572:
573: -- Bug 7709971 - When yielding or changing a phantom product then we must update the parent ingredient.

Line 583: UPDATE gme_material_details

579: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'Updating actual qty for parent ingred to '||l_actual_qty);
580: gme_debug.put_line ('parent line is '||l_batch_header_rec.parentline_id);
581: END IF;
582:
583: UPDATE gme_material_details
584: SET actual_qty = l_actual_qty,
585: last_updated_by = gme_common_pvt.g_user_ident,
586: last_update_date = gme_common_pvt.g_timestamp,
587: last_update_login = gme_common_pvt.g_login_id

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

597: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
598: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calling update material actual qty= '||l_material_detail_rec.actual_qty);
599: END IF;
600:
601: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN
602: RAISE error_update_row;
603: END IF;
604:
605: -- Bug 8516257 - Additional rework of bug Bug 7709971 and 7286054

Line 617: UPDATE gme_material_details

613: gme_debug.put_line ('parent line is '||l_batch_header_rec.parentline_id);
614: END IF;
615:
616: -- Bug 8508788 - Let's update the parent ingredient with the correct actual qty.
617: UPDATE gme_material_details
618: SET actual_qty = l_new_actual,
619: last_updated_by = gme_common_pvt.g_user_ident,
620: last_update_date = gme_common_pvt.g_timestamp,
621: last_update_login = gme_common_pvt.g_login_id

Line 747: (p_material_detail_rec IN gme_material_details%ROWTYPE

743:
744:
745: /*FPBug#4667093 Code added to consider new gme parameter for calculating factor */
746: PROCEDURE derive_factor
747: (p_material_detail_rec IN gme_material_details%ROWTYPE
748: ,p_qty IN NUMBER
749: ,p_qty_type IN NUMBER
750: ,p_gme_ib_factor IN NUMBER DEFAULT 0
751: ,x_pct_plan OUT NOCOPY NUMBER

Line 985: (p_material_detail_rec IN gme_material_details%ROWTYPE

981: x_return_status := FND_API.g_ret_sts_unexp_error;
982: END update_dependent_steps;
983:
984: PROCEDURE revert_material_partial
985: (p_material_detail_rec IN gme_material_details%ROWTYPE
986: ,p_qty IN NUMBER
987: ,p_lot_control_code IN NUMBER -- 1 = not lot control; 2 = lot control
988: ,p_create_resv_pend_lots IN NUMBER
989: ,p_lot_divisible_flag IN VARCHAR2

Line 1685: PROCEDURE validate_material_for_IB(p_material_detail_rec IN gme_material_details%ROWTYPE

1681: END IF;
1682: x_return_status := FND_API.g_ret_sts_unexp_error;
1683: END revert_material_partial;
1684:
1685: PROCEDURE validate_material_for_IB(p_material_detail_rec IN gme_material_details%ROWTYPE
1686: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1687: ,p_adjust_cmplt IN VARCHAR2
1688: ,x_return_status OUT NOCOPY VARCHAR2) IS
1689: