APPS.GME_SUPPLY_RES_PVT dependencies on GME_MATERIAL_DETAILS

Line 89: From gme_material_details

85: Cursor get_batch_line (p_batch_id IN NUMBER) IS
86: Select material_detail_id
87: , inventory_item_id
88: , plan_qty
89: From gme_material_details
90: where batch_id = p_batch_id
91: and line_type <> -1 -- not ingredient
92: ;
93:

Line 120: From gme_material_details

116: Cursor get_new_batch_line (p_batch_id IN NUMBER
117: , p_item_id IN NUMBER) is
118: Select material_detail_id
119: , plan_qty
120: From gme_material_details
121: Where batch_id = p_batch_id
122: and inventory_item_id = p_item_id
123: and line_type <> -1
124: ;

Line 398: FROM gme_material_details gl,

394: and reservation_quantity <> 0;
395:
396: CURSOR get_batch_id_for_line(p_batch_line_id IN NUMBER) Is
397: SELECT gl.batch_id,gh.batch_type
398: FROM gme_material_details gl,
399: gme_batch_header gh
400: WHERE gl.material_detail_id = p_batch_line_id
401: and gl.batch_id = gh.batch_id;
402:

Line 445: FROM mtl_reservations mr, gme_material_details gmd

441: Cursor check_mul_line_id2 (p_user_id IN number
442: , p_batch_id IN NUMBER
443: , p_batch_line_id IN NUMBER) IS
444: SELECT DISTINCT orig_demand_source_line_id
445: FROM mtl_reservations mr, gme_material_details gmd
446: WHERE mr.created_by = p_user_id
447: AND mr.orig_supply_source_header_id = p_batch_id
448: AND mr.orig_supply_source_line_id = p_batch_line_id
449: AND mr.inventory_item_id = gmd.inventory_item_id

Line 780: p_matl_dtl_rec IN gme_material_details%ROWTYPE

776: END notify_CSR;
777:
778:
779: PROCEDURE transfer_reservation_to_inv (
780: p_matl_dtl_rec IN gme_material_details%ROWTYPE
781: ,p_transaction_id IN NUMBER
782: ,x_message_count OUT NOCOPY NUMBER
783: ,x_message_list OUT NOCOPY VARCHAR2
784: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1274: p_matl_dtl_rec IN gme_material_details%ROWTYPE

1270:
1271: END transfer_reservation_to_inv;
1272:
1273: PROCEDURE query_prod_supply_reservations(
1274: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1275: ,x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1276: ,x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1277: ,x_msg_count OUT NOCOPY NUMBER
1278: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1402: p_matl_dtl_rec IN gme_material_details%ROWTYPE

1398:
1399: END query_prod_supply_reservations;
1400:
1401: PROCEDURE relieve_prod_supply_resv (
1402: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1403: ,x_msg_count OUT NOCOPY NUMBER
1404: ,x_msg_data OUT NOCOPY VARCHAR2
1405: ,x_return_status OUT NOCOPY VARCHAR2)
1406: IS

Line 1706: p_matl_dtl_rec IN gme_material_details%ROWTYPE

1702:
1703: END relieve_prod_supply_resv;
1704:
1705: PROCEDURE delete_prod_supply_resv (
1706: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1707: ,x_msg_count OUT NOCOPY NUMBER
1708: ,x_msg_data OUT NOCOPY VARCHAR2
1709: ,x_return_status OUT NOCOPY VARCHAR2)
1710: IS

Line 1714: l_matl_dtl_rec gme_material_details%ROWTYPE;

1710: IS
1711: l_api_name CONSTANT VARCHAR2 (30) := 'delete_prod_supply_resv';
1712: l_rsv_count NUMBER;
1713:
1714: l_matl_dtl_rec gme_material_details%ROWTYPE;
1715: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1716: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1717: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1718: -- ======================================================================

Line 1738: IF (NOT (gme_material_details_dbl.fetch_row (p_matl_dtl_rec

1734:
1735: -- The line may not have been fully populated so retrieve it if necessary
1736: -- ======================================================================
1737: IF p_matl_dtl_rec.line_type is NULL THEN
1738: IF (NOT (gme_material_details_dbl.fetch_row (p_matl_dtl_rec
1739: ,l_matl_dtl_rec) ) ) THEN
1740: RAISE matl_fetch_error;
1741: END IF;
1742: ELSE

Line 1902: l_matl_dtl_rec gme_material_details%ROWTYPE;

1898: IS
1899: l_api_name CONSTANT VARCHAR2 (30) := 'delete_prod_supply_resv';
1900: l_rsv_count NUMBER;
1901:
1902: l_matl_dtl_rec gme_material_details%ROWTYPE;
1903: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1904: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1905: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1906: -- ======================================================================