DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_APIS dependencies on INV_VALIDATE

Line 1541: inv_validate.number_from_sequence(l_fm_serial_number, l_serial_prefix, l_from_ser_number);

1537: l_msni_rec_tbl(1).attribute14 := p_attribute14;
1538: l_msni_rec_tbl(1).attribute15 := p_attribute15;
1539: ELSE --fetch the serial info and attributes from MSN
1540: --Get the numeric part of the from and to serial numbers
1541: inv_validate.number_from_sequence(l_fm_serial_number, l_serial_prefix, l_from_ser_number);
1542:
1543: inv_validate.number_from_sequence(l_to_serial_number, l_serial_prefix, l_to_ser_number);
1544:
1545: --Get the no. of serials in the range, prefix length and numeric part

Line 1543: inv_validate.number_from_sequence(l_to_serial_number, l_serial_prefix, l_to_ser_number);

1539: ELSE --fetch the serial info and attributes from MSN
1540: --Get the numeric part of the from and to serial numbers
1541: inv_validate.number_from_sequence(l_fm_serial_number, l_serial_prefix, l_from_ser_number);
1542:
1543: inv_validate.number_from_sequence(l_to_serial_number, l_serial_prefix, l_to_ser_number);
1544:
1545: --Get the no. of serials in the range, prefix length and numeric part
1546: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
1547: l_ser_num_length := LENGTH(l_fm_serial_number);

Line 2346: inv_validate.number_from_sequence(p_fm_serial_number, l_serial_prefix, l_from_ser_number);

2342: RETURN FALSE;
2343: END IF; --END IF p_to_serial_number IS NULL
2344:
2345: --Now check for the existence of all the serials in the range
2346: inv_validate.number_from_sequence(p_fm_serial_number, l_serial_prefix, l_from_ser_number);
2347: inv_validate.number_from_sequence(p_to_serial_number, l_serial_prefix, l_to_ser_number);
2348: --Get the no. of serials in the range, prefix length and numeric part
2349: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
2350: l_ser_num_length := LENGTH(p_fm_serial_number);

Line 2347: inv_validate.number_from_sequence(p_to_serial_number, l_serial_prefix, l_to_ser_number);

2343: END IF; --END IF p_to_serial_number IS NULL
2344:
2345: --Now check for the existence of all the serials in the range
2346: inv_validate.number_from_sequence(p_fm_serial_number, l_serial_prefix, l_from_ser_number);
2347: inv_validate.number_from_sequence(p_to_serial_number, l_serial_prefix, l_to_ser_number);
2348: --Get the no. of serials in the range, prefix length and numeric part
2349: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
2350: l_ser_num_length := LENGTH(p_fm_serial_number);
2351: l_prefix_length := LENGTH(l_serial_prefix);