DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on INV_TRX_UTIL_PUB

Line 2285: l_update_parent BOOLEAN := FALSE ; -- No need to call update_parent_mmtt in INV_TRX_UTIL_PUB

2281: l_proc_name VARCHAR2(30) := 'CLEANUP_TASK';
2282: l_progress VARCHAR2(30) := '100';
2283: l_wf NUMBER := -1;
2284: l_calling_program VARCHAR2(30) := 'CLEANUP_TASK: QTY EXCEPTION';
2285: l_update_parent BOOLEAN := FALSE ; -- No need to call update_parent_mmtt in INV_TRX_UTIL_PUB
2286: l_parent_line_id NUMBER; --For checking bulk task
2287: l_kill_mo_profile NUMBER := NVL(FND_PROFILE.VALUE_WNPS('INV_KILL_MOVE_ORDER'),2);
2288: l_return_status VARCHAR2(1);
2289:

Line 2505: mdebug ('Calling INV_TRX_UTIL_PUB.delete_transaction ' );

2501: mdebug ('NO WDT TO DELETE' );
2502: -- could not find the task to delete.. do not worry
2503: null;
2504: END IF;
2505: mdebug ('Calling INV_TRX_UTIL_PUB.delete_transaction ' );
2506: INV_TRX_UTIL_PUB.delete_transaction(
2507: x_return_status => x_return_status
2508: , x_msg_data => x_msg_data
2509: , x_msg_count => x_msg_count

Line 2506: INV_TRX_UTIL_PUB.delete_transaction(

2502: -- could not find the task to delete.. do not worry
2503: null;
2504: END IF;
2505: mdebug ('Calling INV_TRX_UTIL_PUB.delete_transaction ' );
2506: INV_TRX_UTIL_PUB.delete_transaction(
2507: x_return_status => x_return_status
2508: , x_msg_data => x_msg_data
2509: , x_msg_count => x_msg_count
2510: , p_transaction_temp_id => l_txn_temp_id

Line 2727: INV_TRX_UTIL_PUB.delete_transaction(

2723: IF (l_debug = 1) THEN
2724: mdebug ('l_progress: ' || l_progress );
2725: END IF;
2726:
2727: INV_TRX_UTIL_PUB.delete_transaction(
2728: x_return_status => x_return_status
2729: , x_msg_data => x_msg_data
2730: , x_msg_count => x_msg_count
2731: , p_transaction_temp_id => l_txn_temp_id

Line 2803: INV_TRX_UTIL_PUB.delete_transaction(

2799: , last_update_date = SYSDATE
2800: , last_updated_by = p_user_id
2801: WHERE line_id = l_mo_line_id;
2802:
2803: INV_TRX_UTIL_PUB.delete_transaction(
2804: x_return_status => x_return_status
2805: , x_msg_data => x_msg_data
2806: , x_msg_count => x_msg_count
2807: , p_transaction_temp_id => l_txn_temp_id

Line 2902: INV_TRX_UTIL_PUB.delete_transaction(

2898:
2899: IF l_parent_line_id = p_temp_id
2900: THEN
2901: mdebug('Now calling delete transaction for parent line');
2902: INV_TRX_UTIL_PUB.delete_transaction(
2903: x_return_status => x_return_status
2904: , x_msg_data => x_msg_data
2905: , x_msg_count => x_msg_count
2906: , p_transaction_temp_id => l_parent_line_id