APPS.PO_INVOICES_SV2 dependencies on DUAL

Line 838: from sys.dual;

834: /* End bug 7512542 */
835:
836: select ap_invoices_interface_s.nextval
837: into x_curr_invoice_id
838: from sys.dual;
839:
840: x_group_id := substr('ERS-'||TO_CHAR(X_rcv_txns.transaction_id),1,80);
841:
842:

Line 1495: FROM dual;

1491: X_batch_name := fnd_message.get;
1492:
1493: SELECT ap_batches_s.nextval
1494: INTO X_tmp_batch_id
1495: FROM dual;
1496:
1497: /* need to commit before we submit another conc request, since
1498: the request in another session */
1499:

Line 1668: from sys.dual;

1664: X_progress := '080';
1665:
1666: select ap_invoices_interface_s.nextval
1667: into x_curr_invoice_id
1668: from sys.dual;
1669:
1670: X_curr_invoice_amount := 0;
1671: X_curr_vendor_id := X_new_vendor_id;
1672: X_curr_pay_site_id := X_new_pay_site_id;

Line 1815: FROM SYS.DUAL;

1811: x_progress := '010';
1812:
1813: SELECT po_invoice_num_segment_s.NEXTVAL
1814: INTO x_tmp_sequence_id
1815: FROM SYS.DUAL;
1816:
1817: x_progress := '020';
1818:
1819: /* */

Line 2514: from sys.dual;

2510: WHERE invoice_id = x_invoice_id;
2511:
2512: select ap_invoice_lines_interface_s.nextval
2513: into x_invoice_line_id
2514: from sys.dual;
2515:
2516: /* Bug 1374789: We should not pass project_id and task_id
2517: ** to AP bas for some reason the AP import program fails
2518: ** with inconsistent distribution info error.

Line 2923: FROM sys.dual;

2919:
2920: -- get group id
2921: SELECT 'USE-' || ap_interface_groups_s.nextval
2922: INTO l_group_id
2923: FROM sys.dual;
2924:
2925: IF (g_asn_debug = 'Y') THEN
2926: ASN_DEBUG.put_line('group_id = ' || l_group_id);
2927: END IF;

Line 3207: FROM sys.dual;

3203: END IF;
3204:
3205: SELECT ap_batches_s.nextval
3206: INTO l_tmp_batch_id
3207: FROM sys.dual;
3208:
3209: FND_MESSAGE.set_name('PO', 'PO_INV_CR_USE_BATCH_DESC');
3210: l_batch_name := FND_MESSAGE.get || '/' || TO_CHAR(sysdate) ||
3211: '/' || TO_CHAR(l_tmp_batch_id);

Line 3436: FROM SYS.DUAL;

3432: x_curr.invoice_amount := 0;
3433:
3434: SELECT AP_INVOICES_INTERFACE_S.NEXTVAL
3435: INTO x_curr.invoice_id
3436: FROM SYS.DUAL;
3437:
3438: x_curr.vendor_id := p_next_consump.vendor_id(p_index);
3439: x_curr.pay_site_id := p_next_consump.default_pay_site_id(p_index);
3440: x_curr.inv_summary_code :=

Line 3563: sys.dual;

3559: p_ap_inv_header.org_id(i),
3560: 'Y', --bug 13555007
3561: 'Y' --bug 13555007
3562: FROM
3563: sys.dual;
3564:
3565: EXCEPTION
3566: WHEN OTHERS THEN
3567: ROLLBACK TO create_invoice_hdr_sp;