APPS.PO_INVOICES_SV2 dependencies on DUAL

Line 787: from sys.dual;

783: /* End bug 7512542 */
784:
785: select ap_invoices_interface_s.nextval
786: into x_curr_invoice_id
787: from sys.dual;
788:
789: x_group_id := substr('ERS-'||TO_CHAR(X_rcv_txns.transaction_id),1,80);
790:
791:

Line 1431: FROM dual;

1427: X_batch_name := fnd_message.get;
1428:
1429: SELECT ap_batches_s.nextval
1430: INTO X_tmp_batch_id
1431: FROM dual;
1432:
1433: /* need to commit before we submit another conc request, since
1434: the request in another session */
1435:

Line 1604: from sys.dual;

1600: X_progress := '080';
1601:
1602: select ap_invoices_interface_s.nextval
1603: into x_curr_invoice_id
1604: from sys.dual;
1605:
1606: X_curr_invoice_amount := 0;
1607: X_curr_vendor_id := X_new_vendor_id;
1608: X_curr_pay_site_id := X_new_pay_site_id;

Line 1751: FROM SYS.DUAL;

1747: x_progress := '010';
1748:
1749: SELECT po_invoice_num_segment_s.NEXTVAL
1750: INTO x_tmp_sequence_id
1751: FROM SYS.DUAL;
1752:
1753: x_progress := '020';
1754:
1755: /* */

Line 2389: from sys.dual;

2385: WHERE invoice_id = x_invoice_id;
2386:
2387: select ap_invoice_lines_interface_s.nextval
2388: into x_invoice_line_id
2389: from sys.dual;
2390:
2391: /* Bug 1374789: We should not pass project_id and task_id
2392: ** to AP bas for some reason the AP import program fails
2393: ** with inconsistent distribution info error.

Line 2769: FROM sys.dual;

2765:
2766: -- get group id
2767: SELECT 'USE-' || ap_interface_groups_s.nextval
2768: INTO l_group_id
2769: FROM sys.dual;
2770:
2771: IF (g_asn_debug = 'Y') THEN
2772: ASN_DEBUG.put_line('group_id = ' || l_group_id);
2773: END IF;

Line 3053: FROM sys.dual;

3049: END IF;
3050:
3051: SELECT ap_batches_s.nextval
3052: INTO l_tmp_batch_id
3053: FROM sys.dual;
3054:
3055: FND_MESSAGE.set_name('PO', 'PO_INV_CR_USE_BATCH_DESC');
3056: l_batch_name := FND_MESSAGE.get || '/' || TO_CHAR(sysdate) ||
3057: '/' || TO_CHAR(l_tmp_batch_id);

Line 3282: FROM SYS.DUAL;

3278: x_curr.invoice_amount := 0;
3279:
3280: SELECT AP_INVOICES_INTERFACE_S.NEXTVAL
3281: INTO x_curr.invoice_id
3282: FROM SYS.DUAL;
3283:
3284: x_curr.vendor_id := p_next_consump.vendor_id(p_index);
3285: x_curr.pay_site_id := p_next_consump.default_pay_site_id(p_index);
3286: x_curr.inv_summary_code :=

Line 3405: sys.dual;

3401: p_ap_inv_header.terms_id(i),
3402: p_ap_inv_header.group_id(i),
3403: p_ap_inv_header.org_id(i)
3404: FROM
3405: sys.dual;
3406:
3407: EXCEPTION
3408: WHEN OTHERS THEN
3409: ROLLBACK TO create_invoice_hdr_sp;