APPS.GME_SUPPLY_RES_PVT dependencies on GME_MATERIAL_DETAILS

Line 105: From gme_material_details

101: Cursor get_batch_line (p_batch_id IN NUMBER) IS
102: Select material_detail_id
103: , inventory_item_id
104: , plan_qty
105: From gme_material_details
106: where batch_id = p_batch_id
107: and line_type <> -1 -- not ingredient
108: ;
109:

Line 136: From gme_material_details

132: Cursor get_new_batch_line (p_batch_id IN NUMBER
133: , p_item_id IN NUMBER) is
134: Select material_detail_id
135: , plan_qty
136: From gme_material_details
137: Where batch_id = p_batch_id
138: and inventory_item_id = p_item_id
139: and line_type <> -1
140: ;

Line 414: FROM gme_material_details gl,

410: and reservation_quantity <> 0;
411:
412: CURSOR get_batch_id_for_line(p_batch_line_id IN NUMBER) Is
413: SELECT gl.batch_id,gh.batch_type
414: FROM gme_material_details gl,
415: gme_batch_header gh
416: WHERE gl.material_detail_id = p_batch_line_id
417: and gl.batch_id = gh.batch_id;
418:

Line 461: FROM mtl_reservations mr, gme_material_details gmd

457: Cursor check_mul_line_id2 (p_user_id IN number
458: , p_batch_id IN NUMBER
459: , p_batch_line_id IN NUMBER) IS
460: SELECT DISTINCT orig_demand_source_line_id
461: FROM mtl_reservations mr, gme_material_details gmd
462: WHERE mr.created_by = p_user_id
463: AND mr.orig_supply_source_header_id = p_batch_id
464: AND mr.orig_supply_source_line_id = p_batch_line_id
465: AND mr.inventory_item_id = gmd.inventory_item_id

Line 796: p_matl_dtl_rec IN gme_material_details%ROWTYPE

792: END notify_CSR;
793:
794:
795: PROCEDURE transfer_reservation_to_inv (
796: p_matl_dtl_rec IN gme_material_details%ROWTYPE
797: ,p_transaction_id IN NUMBER
798: ,x_message_count OUT NOCOPY NUMBER
799: ,x_message_list OUT NOCOPY VARCHAR2
800: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1337: p_matl_dtl_rec IN gme_material_details%ROWTYPE

1333:
1334: END transfer_reservation_to_inv;
1335:
1336: PROCEDURE query_prod_supply_reservations(
1337: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1338: ,x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1339: ,x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1340: ,x_msg_count OUT NOCOPY NUMBER
1341: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1465: p_matl_dtl_rec IN gme_material_details%ROWTYPE

1461:
1462: END query_prod_supply_reservations;
1463:
1464: PROCEDURE relieve_prod_supply_resv (
1465: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1466: ,x_msg_count OUT NOCOPY NUMBER
1467: ,x_msg_data OUT NOCOPY VARCHAR2
1468: ,x_return_status OUT NOCOPY VARCHAR2)
1469: IS

Line 1769: p_matl_dtl_rec IN gme_material_details%ROWTYPE

1765:
1766: END relieve_prod_supply_resv;
1767:
1768: PROCEDURE delete_prod_supply_resv (
1769: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1770: ,x_msg_count OUT NOCOPY NUMBER
1771: ,x_msg_data OUT NOCOPY VARCHAR2
1772: ,x_return_status OUT NOCOPY VARCHAR2)
1773: IS

Line 1777: l_matl_dtl_rec gme_material_details%ROWTYPE;

1773: IS
1774: l_api_name CONSTANT VARCHAR2 (30) := 'delete_prod_supply_resv';
1775: l_rsv_count NUMBER;
1776:
1777: l_matl_dtl_rec gme_material_details%ROWTYPE;
1778: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1779: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1780: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1781: -- ======================================================================

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

1797:
1798: -- The line may not have been fully populated so retrieve it if necessary
1799: -- ======================================================================
1800: IF p_matl_dtl_rec.line_type is NULL THEN
1801: IF (NOT (gme_material_details_dbl.fetch_row (p_matl_dtl_rec
1802: ,l_matl_dtl_rec) ) ) THEN
1803: RAISE matl_fetch_error;
1804: END IF;
1805: ELSE

Line 1965: l_matl_dtl_rec gme_material_details%ROWTYPE;

1961: IS
1962: l_api_name CONSTANT VARCHAR2 (30) := 'delete_prod_supply_resv';
1963: l_rsv_count NUMBER;
1964:
1965: l_matl_dtl_rec gme_material_details%ROWTYPE;
1966: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1967: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1968: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1969: -- ======================================================================