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_API_PUB dependencies on MTL_RESERVATIONS

Line 6350: ,p_reservation_rec IN mtl_reservations%ROWTYPE

6346: ,p_commit IN VARCHAR2 := fnd_api.g_false
6347: ,x_message_count OUT NOCOPY NUMBER
6348: ,x_message_list OUT NOCOPY VARCHAR2
6349: ,x_return_status OUT NOCOPY VARCHAR2
6350: ,p_reservation_rec IN mtl_reservations%ROWTYPE
6351: ,p_qty_convert IN NUMBER := NULL)
6352: IS
6353: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_DTL_RESERVATION';
6354: l_material_details_rec gme_material_details%ROWTYPE;

Line 6355: l_reservation_rec mtl_reservations%ROWTYPE;

6351: ,p_qty_convert IN NUMBER := NULL)
6352: IS
6353: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_DTL_RESERVATION';
6354: l_material_details_rec gme_material_details%ROWTYPE;
6355: l_reservation_rec mtl_reservations%ROWTYPE;
6356: l_valid_status VARCHAR2(1);
6357:
6358: detail_reservation_error EXCEPTION;
6359:

Line 6363: FROM mtl_reservations

6359:
6360: CURSOR cur_fetch_reservation (v_reservation_id NUMBER)
6361: IS
6362: SELECT *
6363: FROM mtl_reservations
6364: WHERE reservation_id = v_reservation_id;
6365: BEGIN
6366: IF (g_debug <> -1) THEN
6367: gme_debug.log_initialize ('ConvertDtlReservation');

Line 6409: ,'MTL_RESERVATIONS');

6405: CLOSE cur_fetch_reservation;
6406:
6407: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
6408: ,'TABLE_NAME'
6409: ,'MTL_RESERVATIONS');
6410:
6411: IF g_debug <= gme_debug.g_log_statement THEN gme_debug.put_line (
6412: g_pkg_name || '.' || l_api_name || ' Retrieval failure against
6413: mtl_reservations using id of ' || p_reservation_rec.reservation_id);

Line 6413: mtl_reservations using id of ' || p_reservation_rec.reservation_id);

6409: ,'MTL_RESERVATIONS');
6410:
6411: IF g_debug <= gme_debug.g_log_statement THEN gme_debug.put_line (
6412: g_pkg_name || '.' || l_api_name || ' Retrieval failure against
6413: mtl_reservations using id of ' || p_reservation_rec.reservation_id);
6414: END IF;
6415:
6416: RAISE fnd_api.g_exc_error;
6417: END IF;

Line 7622: l_reservation_rec mtl_reservations%ROWTYPE;

7618: IS
7619: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
7620: l_material_details_rec gme_material_details%ROWTYPE;
7621: l_material_details_rec_out gme_material_details%ROWTYPE;
7622: l_reservation_rec mtl_reservations%ROWTYPE;
7623: l_batch_header_rec gme_batch_header%ROWTYPE;
7624: l_valid_status VARCHAR2(1);
7625:
7626: CURSOR cur_fetch_reservation (v_reservation_id NUMBER)

Line 7629: FROM mtl_reservations

7625:
7626: CURSOR cur_fetch_reservation (v_reservation_id NUMBER)
7627: IS
7628: SELECT *
7629: FROM mtl_reservations
7630: WHERE reservation_id = v_reservation_id;
7631:
7632: auto_detail_error EXCEPTION;
7633: BEGIN