DBA Data[Home] [Help]

APPS.GME_RESERVATIONS_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 1551: l_trolin_rec mtl_txn_request_lines%ROWTYPE;

1547: l_count NUMBER := 1;
1548: l_return_status VARCHAR2 (1);
1549: l_suggestion_list_rec_type wms_rule_extn_pvt.g_suggestion_list_rec_type;
1550: l_trolin_rec_type inv_move_order_pub.trolin_rec_type;
1551: l_trolin_rec mtl_txn_request_lines%ROWTYPE;
1552: reservable_type_error EXCEPTION;
1553: retrieve_res_fail EXCEPTION;
1554: item_fetch_fail EXCEPTION;
1555: fetch_error EXCEPTION;

Line 1575: FROM mtl_txn_request_lines

1571:
1572: CURSOR cur_get_mo_rec (v_move_order_line_id NUMBER)
1573: IS
1574: SELECT *
1575: FROM mtl_txn_request_lines
1576: WHERE line_id = v_move_order_line_id;
1577: BEGIN
1578: IF g_debug <= gme_debug.g_log_procedure THEN
1579: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1776: gme_common_pvt.log_message ('GME_NO_DATA_FOUND','TABLE_NAME','MTL_TXN_REQUEST_LINES');

1772:
1773: IF cur_get_mo_rec%NOTFOUND THEN
1774: CLOSE cur_get_mo_rec;
1775:
1776: gme_common_pvt.log_message ('GME_NO_DATA_FOUND','TABLE_NAME','MTL_TXN_REQUEST_LINES');
1777:
1778: IF g_debug <= gme_debug.g_log_statement THEN
1779: gme_debug.put_line ( g_pkg_name
1780: || '.'