DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on FND_SEQNUM

Line 1578: l_gen_seq := fnd_seqnum.get_next_sequence

1574:
1575: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 102');
1576: l_gen_seq := NULL;
1577:
1578: l_gen_seq := fnd_seqnum.get_next_sequence
1579: (appid => l_okl_application_id,
1580: cat_code => l_document_category,
1581: sobid => l_cnsld_invs(i).cin_rec.set_of_books_id,
1582: met_code => 'A',

Line 2139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 4 fnd_seqnum.get_next_sequence: r_invoice.sob_id' || r_invoice.sob_id );

2135: -- l_cin_rec.vendor_invoice_number := r_invoice.vendor_invoice_number;
2136: -- l_cin_rec.invoice_number := r_invoice.invoice_number;
2137: -- ELSE -- 1 header and multiple lines case
2138: l_gen_seq := NULL;
2139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 4 fnd_seqnum.get_next_sequence: r_invoice.sob_id' || r_invoice.sob_id );
2140:
2141: FOR v_cnt In 1..2 LOOP
2142: l_gen_seq := fnd_seqnum.get_next_sequence
2143: (appid => l_okl_application_id,

Line 2142: l_gen_seq := fnd_seqnum.get_next_sequence

2138: l_gen_seq := NULL;
2139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 4 fnd_seqnum.get_next_sequence: r_invoice.sob_id' || r_invoice.sob_id );
2140:
2141: FOR v_cnt In 1..2 LOOP
2142: l_gen_seq := fnd_seqnum.get_next_sequence
2143: (appid => l_okl_application_id,
2144: cat_code => l_document_category,
2145: sobid => r_invoice.sob_id,
2146: met_code => 'A',

Line 2152: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.vendor_invoice_number- AP invoice number)' || l_gen_seq );

2148: dbseqnm => lx_dbseqnm,
2149: dbseqid => lx_dbseqid);
2150:
2151: IF v_cnt = 1 THEN
2152: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.vendor_invoice_number- AP invoice number)' || l_gen_seq );
2153: l_cin_rec.vendor_invoice_number := l_gen_seq;
2154: ELSE
2155: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.invoice_number- AP voucher number)' || l_gen_seq );
2156: l_cin_rec.invoice_number := l_gen_seq;

Line 2155: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.invoice_number- AP voucher number)' || l_gen_seq );

2151: IF v_cnt = 1 THEN
2152: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.vendor_invoice_number- AP invoice number)' || l_gen_seq );
2153: l_cin_rec.vendor_invoice_number := l_gen_seq;
2154: ELSE
2155: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.invoice_number- AP voucher number)' || l_gen_seq );
2156: l_cin_rec.invoice_number := l_gen_seq;
2157: END IF;
2158: END LOOP;
2159:

Line 3304: l_gen_seq := fnd_seqnum.get_next_sequence

3300: ------------------------------------------------------------
3301: l_gen_seq := NULL;
3302: IF r_invoice.invoice_number IS NULL THEN
3303: BEGIN
3304: l_gen_seq := fnd_seqnum.get_next_sequence
3305: (appid => l_okl_application_id,
3306: cat_code => l_document_category,
3307: sobid => r_invoice.sob_id,
3308: met_code => 'A',

Line 3748: l_gen_seq := fnd_seqnum.get_next_sequence

3744: ------------------------------------------------------------
3745: l_gen_seq := NULL;
3746: IF fund_rec.invoice_number IS NULL THEN
3747: BEGIN
3748: l_gen_seq := fnd_seqnum.get_next_sequence
3749: (appid => l_okl_application_id,
3750: cat_code => l_document_category,
3751: sobid => fund_rec.sob_id,
3752: met_code => 'A',