APPS.WMS_PARAMETER_EXT dependencies on FND_PROFILE

Line 90: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

86: l_reference varchar2(50);
87: l_reference_id number;
88: l_move_order_line_id number;
89: l_transaction_source_type_id number;
90: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
91:
92: cursor get_mo_line_info is
93: select mtrl.reference, mtrl.reference_id, mtrl.line_id, mmtt.transaction_source_type_id
94: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

Line 236: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

232: l_reference varchar2(50);
233: l_reference_id number;
234: l_move_order_line_id number;
235: l_transaction_source_type_id number;
236: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
237:
238: cursor get_mo_line_info is
239: select mtrl.reference, mtrl.reference_id, mtrl.line_id, mmtt.transaction_source_type_id
240: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl

Line 381: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

377: )return number
378: is
379: l_primary_uom_code varchar2(10);
380: l_proc varchar2(72) := 'GetItemOnhandWrap :';
381: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
382: l_return_val_wrap number := -1;
383:
384: cursor get_item_primary_uom is
385: select primary_uom_code

Line 476: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

472: p_transaction_id in number
473: ) return number
474: is
475: l_proc varchar2(72) := 'GetNumOtherLotsWrap :';
476: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
477: l_return_val_wrap number := -1;
478:
479: l_organization_id number := -1;
480: l_inventory_item_id number := -1;

Line 563: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

559: l_return_value number:= 0;
560: l_primary_uom varchar2(3);
561: l_total_quantity number:= 0;
562: l_loop_counter number:=0;
563: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
564:
565:
566: -- @@@ Get the primary uom for the Item in question.
567: cursor c_get_prim_uom_code is

Line 689: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

685: l_return_value number:= 0;
686: l_primary_uom varchar2(3);
687: l_total_quantity number:= 0;
688: l_loop_counter number := 0;
689: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
690:
691: -- @@@ Get the primary uom for the Item in question.
692: cursor c_get_prim_uom_code is
693: select primary_uom_code