[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;
1208:
1209: )
1210: IS
1211: -- p_mtl_trx_tbl(i) inv_logical_transaction_global.mtl_trx_tbl_type := p_mtl_trx_tbl;
1212: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
1213: l_api_version_number CONSTANT NUMBER := 1.0;
1214: l_api_name CONSTANT VARCHAR2(30) := 'Inv_Mmt_Insert';
1215: l_logical_transaction NUMBER := 1;
1216: l_quantity_adjusted NUMBER := 0;
1504: , p_trx_source_type_id IN NUMBER
1505: , p_revision IN VARCHAR2
1506: )
1507: IS
1508: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
1509: l_api_version_number CONSTANT NUMBER := 1.0;
1510: l_api_name CONSTANT VARCHAR2(30) := 'Inv_Mmt_Insert';
1511: l_serial_number_tbl VARCHAR30_TBL;
1512: l_return_status VARCHAR2(1);
2115: , p_qty IN NUMBER
2116: , p_revision IN VARCHAR2
2117: )
2118: IS
2119: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
2120: l_start_ser VARCHAR2(30);
2121: l_end_ser VARCHAR2(30);
2122: l_ser_prefix VARCHAR2(30);
2123: l_from_ser_num VARCHAR2(30);
2256: , p_trx_source_type_id IN NUMBER
2257: , p_receipt_issue_type IN NUMBER
2258: )
2259: IS
2260: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
2261: l_index NUMBER := 0;
2262: cursor mut_cur(p_transaction_id NUMBER) IS
2263: SELECT SERIAL_NUMBER,
2264: INVENTORY_ITEM_ID,
2582: , p_organization_id IN NUMBER
2583: , p_inventory_item_id IN NUMBER
2584: )
2585: IS
2586: l_debug NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),0);
2587: BEGIN
2588: IF (l_debug = 1) THEN
2589: debug_print('Enter update_serial_numbers', 9);
2590: debug_print('p_organization_id = ' || p_organization_id, 9);