eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_AUTO_DM_CREATION_PKG dependencies on AP_INVOICES

Line 237: l_invoice_id ap_invoices.invoice_id%TYPE;

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;
239: l_terms_date DATE;
240: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
241: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;

Line 238: l_amount ap_invoices.invoice_amount%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;
239: l_terms_date DATE;
240: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
241: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
242: l_item_description po_lines.item_description%TYPE;

Line 240: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%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;
239: l_terms_date DATE;
240: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
241: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
242: l_item_description po_lines.item_description%TYPE;
243:
244: debug_info VARCHAR2(2000);

Line 241: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;

237: l_invoice_id ap_invoices.invoice_id%TYPE;
238: l_amount ap_invoices.invoice_amount%TYPE;
239: l_terms_date DATE;
240: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
241: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
242: l_item_description po_lines.item_description%TYPE;
243:
244: debug_info VARCHAR2(2000);
245: curr_calling_sequence VARCHAR2(2000);

Line 264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

260: l_po_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
261: l_dist_tab AP_MATCHING_PKG.DIST_TAB_TYPE;
262: l_error_code VARCHAR2(4000);
263: l_success BOOLEAN;
264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;

Line 266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980

262: l_error_code VARCHAR2(4000);
263: l_success BOOLEAN;
264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;

Line 267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;

263: l_success BOOLEAN;
264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;

Line 268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;

264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980

Line 269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;

265: l_po_ccid NUMBER; --bugfix:5395955
266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980
273: Begin

Line 270: l_relationship_id ap_invoices_all.relationship_id%TYPE;

266: l_remit_to_supplier_name ap_invoices_all.remit_to_supplier_name%TYPE; --Start 7758980
267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980
273: Begin
274:

Line 271: l_remit_party_id ap_invoices_all.party_id%TYPE;

267: l_remit_to_supplier_id ap_invoices_all.remit_to_supplier_id%TYPE;
268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980
273: Begin
274:
275: curr_calling_sequence := p_calling_sequence ||' <- Create_DM';

Line 272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980

268: l_remit_to_supplier_site ap_invoices_all.remit_to_supplier_site%TYPE;
269: l_remit_to_supplier_site_id ap_invoices_all.remit_to_supplier_site_id%TYPE;
270: l_relationship_id ap_invoices_all.relationship_id%TYPE;
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980
273: Begin
274:
275: curr_calling_sequence := p_calling_sequence ||' <- Create_DM';
276: l_invoice_exists := 'N';

Line 486: ap_invoices_pkg.get_payment_attributes(

482: from ap_supplier_sites_all
483: where vendor_site_id = l_remit_to_supplier_site_id;
484: end if; --End 7758980
485:
486: ap_invoices_pkg.get_payment_attributes(
487: p_le_id =>l_le_id,
488: p_org_id =>l_org_id,
489: p_payee_party_id =>l_remit_party_id, --Start 7758980
490: p_payee_party_site_id =>l_remit_party_site_id,

Line 675: FROM ap_invoices

671: debug_info := 'Recalculate pay curr inv amount ';
672:
673: SELECT invoice_amount
674: INTO l_invoice_amount
675: FROM ap_invoices
676: WHERE invoice_id = l_invoice_id;
677:
678: /* Procced in re-calculation only when tax is calculated.
679: where in the invoice amount would have changed.

Line 1117: l_invoice_num ap_invoices.invoice_num%TYPE;

1113: ) IS
1114: l_gl_period VARCHAR2(15);
1115: l_gl_date DATE;
1116: l_inv_gl_date DATE;
1117: l_invoice_num ap_invoices.invoice_num%TYPE;
1118: l_terms_date DATE;
1119: l_inv_desc ap_invoices.description%TYPE;
1120: l_seq_num_profile VARCHAR2(25);
1121: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;

Line 1119: l_inv_desc ap_invoices.description%TYPE;

1115: l_gl_date DATE;
1116: l_inv_gl_date DATE;
1117: l_invoice_num ap_invoices.invoice_num%TYPE;
1118: l_terms_date DATE;
1119: l_inv_desc ap_invoices.description%TYPE;
1120: l_seq_num_profile VARCHAR2(25);
1121: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;
1122: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;
1123: l_doc_seq_value NUMBER;

Line 1124: l_invoice_amount ap_invoices.invoice_amount%TYPE;

1120: l_seq_num_profile VARCHAR2(25);
1121: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;
1122: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;
1123: l_doc_seq_value NUMBER;
1124: l_invoice_amount ap_invoices.invoice_amount%TYPE;
1125: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
1126: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
1127: l_pay_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1128: l_pay_cross_rate_date DATE;

Line 1125: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;

1121: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;
1122: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;
1123: l_doc_seq_value NUMBER;
1124: l_invoice_amount ap_invoices.invoice_amount%TYPE;
1125: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
1126: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
1127: l_pay_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1128: l_pay_cross_rate_date DATE;
1129: l_valid_pay_site VARCHAR2(25);

Line 1126: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;

1122: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;
1123: l_doc_seq_value NUMBER;
1124: l_invoice_amount ap_invoices.invoice_amount%TYPE;
1125: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
1126: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
1127: l_pay_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1128: l_pay_cross_rate_date DATE;
1129: l_valid_pay_site VARCHAR2(25);
1130: l_inv_base_amt ap_invoices.base_amount%TYPE;

Line 1127: l_pay_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;

1123: l_doc_seq_value NUMBER;
1124: l_invoice_amount ap_invoices.invoice_amount%TYPE;
1125: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
1126: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
1127: l_pay_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1128: l_pay_cross_rate_date DATE;
1129: l_valid_pay_site VARCHAR2(25);
1130: l_inv_base_amt ap_invoices.base_amount%TYPE;
1131: l_invoice_id ap_invoices.invoice_id%TYPE;

Line 1130: l_inv_base_amt ap_invoices.base_amount%TYPE;

1126: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
1127: l_pay_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1128: l_pay_cross_rate_date DATE;
1129: l_valid_pay_site VARCHAR2(25);
1130: l_inv_base_amt ap_invoices.base_amount%TYPE;
1131: l_invoice_id ap_invoices.invoice_id%TYPE;
1132: l_alter_pay_site_id NUMBER;
1133: l_vendor_site_id NUMBER;
1134: l_rts_txn_le_date DATE; --Bug 3492081

Line 1131: l_invoice_id ap_invoices.invoice_id%TYPE;

1127: l_pay_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1128: l_pay_cross_rate_date DATE;
1129: l_valid_pay_site VARCHAR2(25);
1130: l_inv_base_amt ap_invoices.base_amount%TYPE;
1131: l_invoice_id ap_invoices.invoice_id%TYPE;
1132: l_alter_pay_site_id NUMBER;
1133: l_vendor_site_id NUMBER;
1134: l_rts_txn_le_date DATE; --Bug 3492081
1135: curr_calling_sequence VARCHAR2(2000);

Line 1141: l_org_id ap_invoices.org_id%TYPE;

1137:
1138: l_inv_le_date DATE;
1139: l_sys_le_date DATE;
1140:
1141: l_org_id ap_invoices.org_id%TYPE;
1142: l_api_name CONSTANT VARCHAR2(200) := 'Create_Invoice_Header';
1143:
1144:
1145:

Line 1277: SELECT p_receipt_num||'-'||AP_INVOICES_S1.nextval

1273:
1274: -- Bug 1330397
1275: -- Added a hyphen for the invoice number between receipt_num and the sequence
1276:
1277: SELECT p_receipt_num||'-'||AP_INVOICES_S1.nextval
1278: INTO l_invoice_num
1279: FROM dual;
1280:
1281: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1560: SELECT ap_invoices_s.nextval INTO l_invoice_id FROM dual;

1556: debug_info);
1557: END IF;
1558:
1559:
1560: SELECT ap_invoices_s.nextval INTO l_invoice_id FROM dual;
1561:
1562: debug_info := 'Inserting row in ap_invoices';
1563: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 1562: debug_info := 'Inserting row in ap_invoices';

1558:
1559:
1560: SELECT ap_invoices_s.nextval INTO l_invoice_id FROM dual;
1561:
1562: debug_info := 'Inserting row in ap_invoices';
1563: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1565: debug_info);
1566: END IF;

Line 1568: INSERT INTO ap_invoices_all (

1564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1565: debug_info);
1566: END IF;
1567:
1568: INSERT INTO ap_invoices_all (
1569: org_id,
1570: invoice_id,
1571: last_update_date,
1572: last_updated_by,

Line 1771: UPDATE ap_invoices

1767: WHERE invoice_id = p_invoice_id;
1768:
1769: IF (l_lines_total <> p_invoice_amount and nvl(l_lines_total,0) <> 0) THEN
1770:
1771: UPDATE ap_invoices
1772: SET invoice_amount = l_lines_total,
1773: base_amount = l_lines_total_base_amount
1774: WHERE invoice_id = p_invoice_id;
1775: