[Home] [Help]
34: l_so_header_id NUMBER := 0;
35: l_order_number VARCHAR2(40);
36: l_project_id NUMBER := 0;
37: l_task_id NUMBER := 0;
38: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
39: l_transaction_action_id NUMBER := 0;
40: l_transaction_source_type_id NUMBER := 0;
41: l_transaction_type_id NUMBER := 0;
42: l_acct_period_id NUMBER := 0;
1226:
1227: )
1228: IS
1229: -- p_mtl_trx_tbl(i) inv_logical_transaction_global.mtl_trx_tbl_type := p_mtl_trx_tbl;
1230: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
1231: l_api_version_number CONSTANT NUMBER := 1.0;
1232: l_api_name CONSTANT VARCHAR2(30) := 'Inv_Mmt_Insert';
1233: l_logical_transaction NUMBER := 1;
1234: l_quantity_adjusted NUMBER := 0;
1522: , p_trx_source_type_id IN NUMBER
1523: , p_revision IN VARCHAR2
1524: )
1525: IS
1526: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
1527: l_api_version_number CONSTANT NUMBER := 1.0;
1528: l_api_name CONSTANT VARCHAR2(30) := 'Inv_Mmt_Insert';
1529: l_serial_number_tbl VARCHAR30_TBL;
1530: l_return_status VARCHAR2(1);
2167: , p_qty IN NUMBER
2168: , p_revision IN VARCHAR2
2169: )
2170: IS
2171: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
2172: l_start_ser VARCHAR2(30);
2173: l_end_ser VARCHAR2(30);
2174: l_ser_prefix VARCHAR2(30);
2175: l_from_ser_num VARCHAR2(30);
2308: , p_trx_source_type_id IN NUMBER
2309: , p_receipt_issue_type IN NUMBER
2310: )
2311: IS
2312: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
2313: l_index NUMBER := 0;
2314: cursor mut_cur(p_transaction_id NUMBER) IS
2315: SELECT SERIAL_NUMBER,
2316: INVENTORY_ITEM_ID,
2634: , p_organization_id IN NUMBER
2635: , p_inventory_item_id IN NUMBER
2636: )
2637: IS
2638: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
2639: BEGIN
2640: IF (l_debug = 1) THEN
2641: debug_print('Enter update_serial_numbers', 9);
2642: debug_print('p_organization_id = ' || p_organization_id, 9);