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_RESERVATIONS_PVT dependencies on GME_MATERIAL_DETAILS

Line 97: l_mtl_dtl_rec gme_material_details%ROWTYPE;

93: ,x_return_status OUT NOCOPY VARCHAR2)
94: IS
95: l_api_name CONSTANT VARCHAR2 (30) := 'create_batch_reservations';
96: l_return_status VARCHAR2 (1);
97: l_mtl_dtl_rec gme_material_details%ROWTYPE;
98: l_resv_qty NUMBER DEFAULT NULL;
99: line_resvn_err EXCEPTION;
100: get_open_qty_err EXCEPTION;
101:

Line 105: FROM gme_material_details d, mtl_system_items i

101:
102: CURSOR cur_reservable_ings
103: IS
104: SELECT d.*
105: FROM gme_material_details d, mtl_system_items i
106: WHERE d.batch_id = p_batch_id
107: AND d.line_type = -1
108: AND d.line_type = -1
109: AND ( NVL (p_timefence, 0) = 0

Line 198: p_matl_dtl_rec IN gme_material_details%ROWTYPE

194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: END create_batch_reservations;
196:
197: PROCEDURE create_material_reservation (
198: p_matl_dtl_rec IN gme_material_details%ROWTYPE
199: ,p_resv_qty IN NUMBER DEFAULT NULL
200: ,p_sec_resv_qty IN NUMBER DEFAULT NULL
201: ,p_resv_um IN VARCHAR2 DEFAULT NULL
202: ,p_subinventory IN VARCHAR2 DEFAULT NULL

Line 508: ,p_material_dtl_rec IN gme_material_details%ROWTYPE

504: END reservation_fully_specified;
505:
506: PROCEDURE convert_partial_to_dlr (
507: p_reservation_rec IN mtl_reservations%ROWTYPE
508: ,p_material_dtl_rec IN gme_material_details%ROWTYPE
509: ,p_item_rec IN mtl_system_items%ROWTYPE
510: ,p_qty_check IN VARCHAR2 := fnd_api.g_false
511: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE
512: ,x_return_status OUT NOCOPY VARCHAR2)

Line 595: FROM gme_material_details d, mtl_system_items_b i

591:
592: CURSOR cur_batch_materials
593: IS
594: SELECT d.material_detail_id, d.batch_id, d.organization_id
595: FROM gme_material_details d, mtl_system_items_b i
596: WHERE d.organization_id = p_organization_id
597: AND d.batch_id = p_batch_id
598: AND d.line_type = gme_common_pvt.g_line_type_ing
599: AND i.organization_id = d.organization_id

Line 852: p_mtl_dtl_rec IN gme_material_details%ROWTYPE

848: x_return_status := fnd_api.g_ret_sts_unexp_error;
849: END get_reservation_dtl_qty;
850:
851: PROCEDURE get_reserved_qty (
852: p_mtl_dtl_rec IN gme_material_details%ROWTYPE
853: ,p_supply_sub_only IN VARCHAR2 DEFAULT 'F'
854: ,x_reserved_qty OUT NOCOPY NUMBER
855: ,x_return_status OUT NOCOPY VARCHAR2)
856: IS

Line 858: l_mtl_dtl_rec gme_material_details%ROWTYPE;

854: ,x_reserved_qty OUT NOCOPY NUMBER
855: ,x_return_status OUT NOCOPY VARCHAR2)
856: IS
857: l_api_name CONSTANT VARCHAR2 (30) := 'get_reserved_qty';
858: l_mtl_dtl_rec gme_material_details%ROWTYPE;
859: l_resv_tbl gme_common_pvt.reservations_tab;
860: l_temp_qty NUMBER;
861: l_return_status VARCHAR2 (1);
862:

Line 891: IF (NOT (gme_material_details_dbl.fetch_row (p_mtl_dtl_rec

887: IF (p_mtl_dtl_rec.inventory_item_id IS NULL
888: OR p_mtl_dtl_rec.dtl_um IS NULL
889: OR p_mtl_dtl_rec.batch_id IS NULL
890: OR (p_supply_sub_only = fnd_api.g_true AND p_mtl_dtl_rec.subinventory IS NULL)) THEN
891: IF (NOT (gme_material_details_dbl.fetch_row (p_mtl_dtl_rec
892: ,l_mtl_dtl_rec) ) ) THEN
893: RAISE matl_fetch_error;
894: END IF;
895: ELSE

Line 1294: ,p_material_details_rec IN gme_material_details%ROWTYPE

1290: END pending_reservations_exist;
1291:
1292: PROCEDURE convert_dtl_reservation (
1293: p_reservation_rec IN mtl_reservations%ROWTYPE
1294: ,p_material_details_rec IN gme_material_details%ROWTYPE
1295: ,p_qty_convert IN NUMBER := NULL
1296: ,x_message_count OUT NOCOPY NUMBER
1297: ,x_message_list OUT NOCOPY VARCHAR2
1298: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1415: /* but this must be expressed in terms of gme_material_details.dtl_um */

1411:
1412: /* Next phase is to create the inventory transaction and relieve the reservation */
1413: l_actual_qty := NVL (p_material_details_rec.actual_qty, 0);
1414: /* If p_qty_convert is null, need to pass in the full reservation_qty */
1415: /* but this must be expressed in terms of gme_material_details.dtl_um */
1416: l_qty_convert := p_qty_convert;
1417:
1418: IF l_qty_convert IS NULL THEN
1419: IF g_debug <= gme_debug.g_log_statement THEN

Line 1535: p_material_details_rec IN gme_material_details%ROWTYPE

1531: ,x_data => x_message_list);
1532: END convert_dtl_reservation;
1533:
1534: PROCEDURE auto_detail_line (
1535: p_material_details_rec IN gme_material_details%ROWTYPE
1536: ,x_return_status OUT NOCOPY VARCHAR2)
1537: IS
1538: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1539: l_item_rec mtl_system_items_b%ROWTYPE;

Line 2029: FROM gme_material_details d,mtl_system_items_b i

2025: /* Retrieve Ingredient rows */
2026: CURSOR cur_get_reservable_ings
2027: IS
2028: SELECT d.*
2029: FROM gme_material_details d,mtl_system_items_b i
2030: WHERE d.batch_id = p_batch_rec.batch_id
2031: AND d.line_type = -1
2032: AND d.material_requirement_date < SYSDATE + NVL(gme_common_pvt.g_rule_based_resv_horizon,p_timefence)
2033: AND i. inventory_item_id = d.inventory_item_id

Line 2108: p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE,

2104: END auto_detail_batch;
2105:
2106: --Bug#4604943 created the following procedure
2107: PROCEDURE validate_mtl_for_reservation(
2108: p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE,
2109: x_return_status OUT NOCOPY VARCHAR2) IS
2110:
2111: l_api_name VARCHAR2(30) := 'VALIDATE_MTL_FOR_RESERVATION';
2112: l_batch_header_rec gme_batch_header%ROWTYPE;