DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_APIS dependencies on INV_VALIDATE

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

1521: l_msni_rec_tbl(1).attribute14 := p_attribute14;
1522: l_msni_rec_tbl(1).attribute15 := p_attribute15;
1523: ELSE --fetch the serial info and attributes from MSN
1524: --Get the numeric part of the from and to serial numbers
1525: inv_validate.number_from_sequence(l_fm_serial_number, l_serial_prefix, l_from_ser_number);
1526:
1527: inv_validate.number_from_sequence(l_to_serial_number, l_serial_prefix, l_to_ser_number);
1528:
1529: --Get the no. of serials in the range, prefix length and numeric part

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

1523: ELSE --fetch the serial info and attributes from MSN
1524: --Get the numeric part of the from and to serial numbers
1525: inv_validate.number_from_sequence(l_fm_serial_number, l_serial_prefix, l_from_ser_number);
1526:
1527: inv_validate.number_from_sequence(l_to_serial_number, l_serial_prefix, l_to_ser_number);
1528:
1529: --Get the no. of serials in the range, prefix length and numeric part
1530: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
1531: l_ser_num_length := LENGTH(l_fm_serial_number);

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

2324: RETURN FALSE;
2325: END IF; --END IF p_to_serial_number IS NULL
2326:
2327: --Now check for the existence of all the serials in the range
2328: inv_validate.number_from_sequence(p_fm_serial_number, l_serial_prefix, l_from_ser_number);
2329: inv_validate.number_from_sequence(p_to_serial_number, l_serial_prefix, l_to_ser_number);
2330: --Get the no. of serials in the range, prefix length and numeric part
2331: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
2332: l_ser_num_length := LENGTH(p_fm_serial_number);

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

2325: END IF; --END IF p_to_serial_number IS NULL
2326:
2327: --Now check for the existence of all the serials in the range
2328: inv_validate.number_from_sequence(p_fm_serial_number, l_serial_prefix, l_from_ser_number);
2329: inv_validate.number_from_sequence(p_to_serial_number, l_serial_prefix, l_to_ser_number);
2330: --Get the no. of serials in the range, prefix length and numeric part
2331: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
2332: l_ser_num_length := LENGTH(p_fm_serial_number);
2333: l_prefix_length := LENGTH(l_serial_prefix);