APPS.WMS_TASK_LOAD dependencies on INV_TRX_UTIL_PUB

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

4781:
4782: x_return_status := l_g_ret_sts_success;
4783: l_progress := '110';
4784:
4785: -- copied the logic from INV_TRX_UTIL_PUB.INSERT_SER_TRX
4786: l_real_serial_prefix := RTRIM(p_serial_number, '0123456789');
4787: l_serial_numeric_frm := TO_NUMBER(SUBSTR(p_serial_number, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
4788: l_serial_numeric_to := TO_NUMBER(SUBSTR(p_serial_number, NVL(LENGTH(l_real_serial_prefix), 0) + 1));
4789: l_serial_prefix := (l_serial_numeric_to - l_serial_numeric_frm) + 1;

Line 6615: inv_trx_util_pub.delete_transaction(

6611: FOR rec_mmtt_to_del IN c_mmtt_to_del (
6612: p_mo_line_id => rec_cancelled_MOLs.line_id)
6613: LOOP
6614: -- it adjusts the bulk parent too
6615: inv_trx_util_pub.delete_transaction(
6616: x_return_status => x_return_status
6617: , x_msg_data => x_msg_data
6618: , x_msg_count => x_msg_count
6619: , p_transaction_temp_id => rec_mmtt_to_del.transaction_temp_id);

Line 14324: l_return := inv_trx_util_pub.insert_ser_trx(

14320:
14321: END IF;
14322:
14323: l_progress := '60';
14324: l_return := inv_trx_util_pub.insert_ser_trx(
14325: p_trx_tmp_id => p_serial_transaction_temp_id,
14326: p_user_id => p_created_by,
14327: p_fm_ser_num => p_from_serial,
14328: p_to_ser_num => p_to_serial,