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.

[Home] [Help]

APPS.GME_API_PUB dependencies on MTL_RESERVATIONS

Line 6765: ,p_reservation_rec IN mtl_reservations%ROWTYPE

6761: ,p_commit IN VARCHAR2 := fnd_api.g_false
6762: ,x_message_count OUT NOCOPY NUMBER
6763: ,x_message_list OUT NOCOPY VARCHAR2
6764: ,x_return_status OUT NOCOPY VARCHAR2
6765: ,p_reservation_rec IN mtl_reservations%ROWTYPE
6766: ,p_trans_date IN DATE DEFAULT NULL -- Bug 13532998
6767: ,p_qty_convert IN NUMBER := NULL)
6768: IS
6769: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_DTL_RESERVATION';

Line 6771: l_reservation_rec mtl_reservations%ROWTYPE;

6767: ,p_qty_convert IN NUMBER := NULL)
6768: IS
6769: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_DTL_RESERVATION';
6770: l_material_details_rec gme_material_details%ROWTYPE;
6771: l_reservation_rec mtl_reservations%ROWTYPE;
6772: l_valid_status VARCHAR2(1);
6773:
6774: l_batch_header_rec gme_batch_header%ROWTYPE; -- Bug 13532998
6775:

Line 6783: FROM mtl_reservations

6779:
6780: CURSOR cur_fetch_reservation (v_reservation_id NUMBER)
6781: IS
6782: SELECT *
6783: FROM mtl_reservations
6784: WHERE reservation_id = v_reservation_id;
6785: BEGIN
6786: IF (g_debug <> -1) THEN
6787: gme_debug.log_initialize ('ConvertDtlReservation');

Line 6829: ,'MTL_RESERVATIONS');

6825: CLOSE cur_fetch_reservation;
6826:
6827: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
6828: ,'TABLE_NAME'
6829: ,'MTL_RESERVATIONS');
6830:
6831: IF g_debug <= gme_debug.g_log_statement THEN gme_debug.put_line (
6832: g_pkg_name || '.' || l_api_name || ' Retrieval failure against
6833: mtl_reservations using id of ' || p_reservation_rec.reservation_id);

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

6829: ,'MTL_RESERVATIONS');
6830:
6831: IF g_debug <= gme_debug.g_log_statement THEN gme_debug.put_line (
6832: g_pkg_name || '.' || l_api_name || ' Retrieval failure against
6833: mtl_reservations using id of ' || p_reservation_rec.reservation_id);
6834: END IF;
6835:
6836: RAISE fnd_api.g_exc_error;
6837: END IF;

Line 8101: l_reservation_rec mtl_reservations%ROWTYPE;

8097: IS
8098: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
8099: l_material_details_rec gme_material_details%ROWTYPE;
8100: l_material_details_rec_out gme_material_details%ROWTYPE;
8101: l_reservation_rec mtl_reservations%ROWTYPE;
8102: l_batch_header_rec gme_batch_header%ROWTYPE;
8103: l_valid_status VARCHAR2(1);
8104:
8105: CURSOR cur_fetch_reservation (v_reservation_id NUMBER)

Line 8108: FROM mtl_reservations

8104:
8105: CURSOR cur_fetch_reservation (v_reservation_id NUMBER)
8106: IS
8107: SELECT *
8108: FROM mtl_reservations
8109: WHERE reservation_id = v_reservation_id;
8110:
8111: auto_detail_error EXCEPTION;
8112: BEGIN