[Home] [Help]
631: ,Nvl(mtlt.primary_quantity, mmtt.primary_quantity)primary_quantity /* Changed in Bug No.9946085 */
632: ,mmtt.ITEM_primary_UOM_CODE
633: ,Nvl(mtlt.secondary_quantity, mmtt.secondary_transaction_quantity)secondary_quantity /* Changed in Bug No.9946085 */
634: ,mmtt.secondary_uom_code
635: FROM mtl_txn_request_lines l,
636: mtl_txn_request_headers h ,
637: mtl_material_transactions_temp mmtt ,
638: mtl_transaction_lots_temp mtlt
639: WHERE l.transaction_source_type_id =
1852: l_count NUMBER := 1;
1853: l_return_status VARCHAR2 (1);
1854: l_suggestion_list_rec_type wms_rule_extn_pvt.g_suggestion_list_rec_type;
1855: l_trolin_rec_type inv_move_order_pub.trolin_rec_type;
1856: l_trolin_rec mtl_txn_request_lines%ROWTYPE;
1857: reservable_type_error EXCEPTION;
1858: retrieve_res_fail EXCEPTION;
1859: item_fetch_fail EXCEPTION;
1860: fetch_error EXCEPTION;
1876:
1877: CURSOR cur_get_mo_rec (v_move_order_line_id NUMBER)
1878: IS
1879: SELECT *
1880: FROM mtl_txn_request_lines
1881: WHERE line_id = v_move_order_line_id;
1882: BEGIN
1883: IF g_debug <= gme_debug.g_log_procedure THEN
1884: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2115:
2116: IF cur_get_mo_rec%NOTFOUND THEN
2117: CLOSE cur_get_mo_rec;
2118:
2119: gme_common_pvt.log_message ('GME_NO_DATA_FOUND','TABLE_NAME','MTL_TXN_REQUEST_LINES');
2120:
2121: IF g_debug <= gme_debug.g_log_statement THEN
2122: gme_debug.put_line ( g_pkg_name
2123: || '.'
2424:
2425: -- bug 9852628 start
2426: l_msg_count NUMBER;
2427: l_msg_data VARCHAR2(200);
2428: l_mtrl_rec mtl_txn_request_lines%ROWTYPE;
2429: l_tree_id NUMBER;
2430: -- bug 9852628 end
2431:
2432: auto_detail_failure EXCEPTION;