APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_BATCHES

Line 234: l_batch_id ap_batches.batch_id%TYPE;

230: l_excl_freight_from_disc po_vendor_sites.exclude_freight_from_discount%TYPE;
231: l_payment_currency po_vendor_sites.payment_currency_code%TYPE;
232:
233: l_inv_payment_curr po_vendor_sites.payment_currency_code%TYPE;
234: l_batch_id ap_batches.batch_id%TYPE;
235: l_rts_txn_date rcv_transactions.transaction_date%TYPE;
236: l_rcv_quantity_billed rcv_transactions.quantity_billed%TYPE;
237: l_invoice_id ap_invoices.invoice_id%TYPE;
238: l_amount ap_invoices.invoice_amount%TYPE;

Line 984: debug_info := 'Insert into ap_batches';

980:
981: Begin
982: curr_calling_sequence := p_calling_sequence ||' <- Create_Invoice_batch';
983:
984: debug_info := 'Insert into ap_batches';
985:
986: SELECT ap_batches_s.nextval INTO p_batch_id FROM dual;
987:
988: --Bug fix:1858452

Line 986: SELECT ap_batches_s.nextval INTO p_batch_id FROM dual;

982: curr_calling_sequence := p_calling_sequence ||' <- Create_Invoice_batch';
983:
984: debug_info := 'Insert into ap_batches';
985:
986: SELECT ap_batches_s.nextval INTO p_batch_id FROM dual;
987:
988: --Bug fix:1858452
989: --Note: When matched to a PO , po_distribution_id is not populated
990: --in rcv_transactions, hence need to join using po_header_id...

Line 1018: INSERT INTO ap_batches_all (

1014:
1015:
1016: IF(l_invoice_exists = 'Y') THEN */
1017:
1018: INSERT INTO ap_batches_all (
1019: batch_id,
1020: batch_name,
1021: batch_date,
1022: invoice_currency_code,

Line 1032: p_receipt_num||'-'||ap_batches_s1.nextval,

1028: creation_date,
1029: last_update_login)
1030: VALUES (
1031: p_batch_id,
1032: p_receipt_num||'-'||ap_batches_s1.nextval,
1033: trunc(p_rts_txn_date), --Bug 3492081
1034: p_inv_curr,
1035: p_inv_payment_curr,
1036: 'DEBIT',