DBA Data[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on INV_TRX_UTIL_PUB

Line 3701: -- copied the logic from INV_TRX_UTIL_PUB.INSERT_SER_TRX

3697:
3698: x_return_status := l_g_ret_sts_success;
3699: l_progress := '110';
3700:
3701: -- copied the logic from INV_TRX_UTIL_PUB.INSERT_SER_TRX
3702: l_real_serial_prefix := RTRIM(p_serial_number, '0123456789');
3703: l_serial_numeric_frm := TO_NUMBER(SUBSTR(p_serial_number, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
3704: l_serial_numeric_to := TO_NUMBER(SUBSTR(p_serial_number, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
3705: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;

Line 5378: inv_trx_util_pub.delete_transaction(

5374: FOR rec_mmtt_to_del IN c_mmtt_to_del (
5375: p_mo_line_id => rec_cancelled_MOLs.line_id)
5376: LOOP
5377: -- it adjusts the bulk parent too
5378: inv_trx_util_pub.delete_transaction(
5379: x_return_status => x_return_status
5380: , x_msg_data => x_msg_data
5381: , x_msg_count => x_msg_count
5382: , p_transaction_temp_id => rec_mmtt_to_del.transaction_temp_id);

Line 12009: l_return := inv_trx_util_pub.insert_ser_trx(

12005:
12006: END IF;
12007:
12008: l_progress := '60';
12009: l_return := inv_trx_util_pub.insert_ser_trx(
12010: p_trx_tmp_id => p_serial_transaction_temp_id,
12011: p_user_id => p_created_by,
12012: p_fm_ser_num => p_from_serial,
12013: p_to_ser_num => p_to_serial,