APPS.RCV_GAPLESS_NUMBERING dependencies on RCV_GAPLESS_INVOICE_NUMBERS

Line 49: FROM rcv_gapless_invoice_numbers

45:
46: cursor get_next_sequence_number is
47: SELECT ROWID,
48: next_sequence_number
49: FROM rcv_gapless_invoice_numbers
50: WHERE (prefix = l_prefix OR (prefix IS NULL AND l_prefix IS NULL))
51: AND buying_company_code = l_buying_company_identifier
52: AND selling_company_code = l_selling_company_identifier
53: AND invoice_type = p_invoice_type

Line 253: INSERT INTO rcv_gapless_invoice_numbers (prefix,

249:
250: l_progress := '040';
251:
252: IF (l_next_sequence_number is null) THEN
253: INSERT INTO rcv_gapless_invoice_numbers (prefix,
254: buying_company_code,
255: selling_company_code,
256: invoice_type,
257: next_sequence_number

Line 312: UPDATE rcv_gapless_invoice_numbers

308:
309: x_invoice_num := l_invoice_string || l_next_sequence_number;
310: l_next_sequence_number := l_next_sequence_number + 1;
311:
312: UPDATE rcv_gapless_invoice_numbers
313: SET next_sequence_number = l_next_sequence_number
314: WHERE ROWID = l_rowid;
315:
316: l_progress := '100';