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_INTEREST_INVOICE_PKG dependencies on AP_INVOICES

Line 38: PROCEDURE ap_int_inv_insert_ap_invoices(

34: P_party_id OUT NOCOPY NUMBER, --4746599
35: P_party_site_id OUT NOCOPY NUMBER, --4959918
36: P_payment_priority OUT NOCOPY NUMBER); -- Bug 5139574
37:
38: PROCEDURE ap_int_inv_insert_ap_invoices(
39: P_int_invoice_id IN NUMBER,
40: P_check_date IN DATE,
41: P_vendor_id IN NUMBER,
42: P_vendor_site_id IN NUMBER,

Line 161: * Step 2. Create interest ap_invoices line

157:
158: /*========================================================================
159: * Main Procedure: Create Interest Invoice and pay it
160: * Step 1. Call ap_int_inv_get_info to get some required fields
161: * Step 2. Create interest ap_invoices line
162: * Step 3. Create ap_invoice_relationships line
163: * Step 4. Create ap_invoice_lines line
164: * Step 5. Create ap_invoice_distributions line
165: * Step 6. Create ap_payment_schedules line

Line 175: | Step 2: | Call ap_int_inv_insert_ap_invoices | PAY |

171: +==========+====================================================+=============+
172: | Step 1: | Call ap_int_inv_get_info to get some parameters | PAY |
173: | |
174: +----------+----------------------------------------------------+-------------+
175: | Step 2: | Call ap_int_inv_insert_ap_invoices | PAY |
176: | |
177: +----------+----------------------------------------------------+-------------+
178: | Step 3: | Call ap_int_inv_insert_ap_inv_rel | PAY |
179: | |

Line 342: -- Call ap_int_inv_insert_ap_invoices: Insert AP_INVOICES

338: c_party_site_id,
339: C_payment_priority); --4959918
340: ---------------------------------------------------------------------------
341: -- Step 2: Case for Pay : for Pay interest invoice only
342: -- Call ap_int_inv_insert_ap_invoices: Insert AP_INVOICES
343: ---------------------------------------------------------------------------
344:
345: AP_INTEREST_INVOICE_PKG.ap_int_inv_insert_ap_invoices(
346: P_int_invoice_id,

Line 345: AP_INTEREST_INVOICE_PKG.ap_int_inv_insert_ap_invoices(

341: -- Step 2: Case for Pay : for Pay interest invoice only
342: -- Call ap_int_inv_insert_ap_invoices: Insert AP_INVOICES
343: ---------------------------------------------------------------------------
344:
345: AP_INTEREST_INVOICE_PKG.ap_int_inv_insert_ap_invoices(
346: P_int_invoice_id,
347: P_accounting_date,
348: P_vendor_id,
349: P_vendor_site_id,

Line 628: -- The other from ap_invoices. SELECT type_1099, income_tax_region,

624: -- P_base_currency_code
625: -- P_type_1099
626: -- P_income_tax_region
627: -- Merge the existing SELECTs into two. One SELECT from ap_system_parameters.
628: -- The other from ap_invoices. SELECT type_1099, income_tax_region,
629: -- and base currency and pass them back to ap_create_interest_invoice_pkg.
630:
631: -- Remove expense interest account. Not need to select it
632:

Line 661: -- get some required information from ap_invoices

657: AND pvs.vendor_site_id = P_vendor_site_id
658: AND NVL(pvs.org_id, -999) = NVL(asp.org_id, -999);
659:
660: ----------------------------------------------------------------------------
661: -- get some required information from ap_invoices
662: ----------------------------------------------------------------------------
663:
664: debug_info := 'get some required field from ap_invoices';
665:

Line 664: debug_info := 'get some required field from ap_invoices';

660: ----------------------------------------------------------------------------
661: -- get some required information from ap_invoices
662: ----------------------------------------------------------------------------
663:
664: debug_info := 'get some required field from ap_invoices';
665:
666: SELECT ai.pay_group_lookup_code,
667: ai.invoice_currency_code,
668: ai.payment_currency_code,

Line 700: FROM ap_invoices ai,

696: P_Legal_Entity_ID,
697: P_party_id,
698: P_party_site_id,
699: P_payment_priority
700: FROM ap_invoices ai,
701: ap_payment_schedules ps
702: WHERE ai.invoice_id = P_invoice_id
703: AND ps.invoice_id = P_invoice_id
704: AND ps.payment_num = P_payment_num;

Line 737: Insert AP_INVOICES

733: END ap_int_inv_get_info;
734:
735:
736: /*==========================================================================
737: Insert AP_INVOICES
738: *==========================================================================*/
739:
740: PROCEDURE ap_int_inv_insert_ap_invoices(
741: P_int_invoice_id IN NUMBER,

Line 740: PROCEDURE ap_int_inv_insert_ap_invoices(

736: /*==========================================================================
737: Insert AP_INVOICES
738: *==========================================================================*/
739:
740: PROCEDURE ap_int_inv_insert_ap_invoices(
741: P_int_invoice_id IN NUMBER,
742: P_check_date IN DATE,
743: P_vendor_id IN NUMBER,
744: P_vendor_site_id IN NUMBER,

Line 783: l_remit_party_id AP_INVOICES_ALL.party_id%TYPE; -- bug 8557334

779: debug_info VARCHAR2(100);
780: current_calling_sequence VARCHAR2(2000);
781:
782: --Start of 8249618
783: l_remit_party_id AP_INVOICES_ALL.party_id%TYPE; -- bug 8557334
784: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
785: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
786: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
787: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;

Line 784: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;

780: current_calling_sequence VARCHAR2(2000);
781:
782: --Start of 8249618
783: l_remit_party_id AP_INVOICES_ALL.party_id%TYPE; -- bug 8557334
784: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
785: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
786: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
787: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
788: l_relationship_id AP_INVOICES.relationship_id%TYPE;

Line 785: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;

781:
782: --Start of 8249618
783: l_remit_party_id AP_INVOICES_ALL.party_id%TYPE; -- bug 8557334
784: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
785: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
786: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
787: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
788: l_relationship_id AP_INVOICES.relationship_id%TYPE;
789: --End of 8249618

Line 786: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;

782: --Start of 8249618
783: l_remit_party_id AP_INVOICES_ALL.party_id%TYPE; -- bug 8557334
784: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
785: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
786: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
787: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
788: l_relationship_id AP_INVOICES.relationship_id%TYPE;
789: --End of 8249618
790:

Line 787: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;

783: l_remit_party_id AP_INVOICES_ALL.party_id%TYPE; -- bug 8557334
784: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
785: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
786: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
787: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
788: l_relationship_id AP_INVOICES.relationship_id%TYPE;
789: --End of 8249618
790:
791: BEGIN

Line 788: l_relationship_id AP_INVOICES.relationship_id%TYPE;

784: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
785: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
786: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
787: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
788: l_relationship_id AP_INVOICES.relationship_id%TYPE;
789: --End of 8249618
790:
791: BEGIN
792:

Line 800: current_calling_sequence := 'ap_int_inv_insert_ap_invoices<-'||

796: -- P_last_update_login
797: -- Pass C_int_payment_base_amount for P_interest_base_amount
798: -- instead of recalculating it.
799:
800: current_calling_sequence := 'ap_int_inv_insert_ap_invoices<-'||
801: P_calling_sequence;
802:
803: IF (P_payment_mode = 'PAY') THEN
804:

Line 814: FROM AP_INVOICES_ALL

810: relationship_id
811: INTO l_remit_to_supplier_name, l_remit_to_supplier_id,
812: l_remit_to_supplier_site, l_remit_to_supplier_site_id,
813: l_relationship_id
814: FROM AP_INVOICES_ALL
815: WHERE INVOICE_ID = P_Invoice_id;*/
816:
817: IBY_EXT_PAYEE_RELSHIPS_PKG.default_Ext_Payee_Relationship (
818: p_party_id => p_party_id,

Line 851: debug_info := 'Insert into ap_invoices';

847: END;
848:
849: -- modified code as per bug 8557344 ends
850:
851: debug_info := 'Insert into ap_invoices';
852:
853: INSERT INTO AP_INVOICES(
854: INVOICE_ID,
855: LAST_UPDATE_DATE,

Line 853: INSERT INTO AP_INVOICES(

849: -- modified code as per bug 8557344 ends
850:
851: debug_info := 'Insert into ap_invoices';
852:
853: INSERT INTO AP_INVOICES(
854: INVOICE_ID,
855: LAST_UPDATE_DATE,
856: LAST_UPDATED_BY,
857: VENDOR_ID,

Line 967: (p_table_name => 'AP_INVOICES',

963: l_relationship_id
964: --End 8249618
965: );
966: AP_DBI_PKG.Maintain_DBI_Summary
967: (p_table_name => 'AP_INVOICES',
968: p_operation => 'I',
969: p_key_value1 => P_Int_Invoice_id,
970: p_calling_sequence => current_calling_sequence);
971:

Line 1015: END ap_int_inv_insert_ap_invoices;

1011: END IF;
1012:
1013: APP_EXCEPTION.RAISE_EXCEPTION;
1014:
1015: END ap_int_inv_insert_ap_invoices;
1016:
1017:
1018: /*==========================================================================
1019: Insert AP_INVOICE_RELATIONSHIPS

Line 1657: -- and base_amount of ap_invoices table

1653: END IF ;
1654:
1655: -- Make sure that the total of amount and base amount in
1656: -- ap_invoice_distributions is equal to the invoice_amount
1657: -- and base_amount of ap_invoices table
1658:
1659: IF (p_interest_amount <> l_distribution_total OR
1660: p_interest_base_amount <> l_distribution_base_total ) THEN
1661:

Line 1779: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;

1775: debug_info VARCHAR2(100);
1776: current_calling_sequence VARCHAR2(2000);
1777:
1778: --Start of 8557334
1779: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
1780: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
1781: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
1782: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
1783: l_relationship_id AP_INVOICES.relationship_id%TYPE;

Line 1780: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;

1776: current_calling_sequence VARCHAR2(2000);
1777:
1778: --Start of 8557334
1779: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
1780: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
1781: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
1782: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
1783: l_relationship_id AP_INVOICES.relationship_id%TYPE;
1784: --End of 8557334

Line 1781: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;

1777:
1778: --Start of 8557334
1779: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
1780: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
1781: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
1782: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
1783: l_relationship_id AP_INVOICES.relationship_id%TYPE;
1784: --End of 8557334
1785:

Line 1782: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;

1778: --Start of 8557334
1779: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
1780: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
1781: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
1782: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
1783: l_relationship_id AP_INVOICES.relationship_id%TYPE;
1784: --End of 8557334
1785:
1786: BEGIN

Line 1783: l_relationship_id AP_INVOICES.relationship_id%TYPE;

1779: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
1780: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
1781: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
1782: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
1783: l_relationship_id AP_INVOICES.relationship_id%TYPE;
1784: --End of 8557334
1785:
1786: BEGIN
1787:

Line 1807: FROM AP_INVOICES_ALL

1803: relationship_id
1804: INTO l_remit_to_supplier_name, l_remit_to_supplier_id,
1805: l_remit_to_supplier_site, l_remit_to_supplier_site_id,
1806: l_relationship_id
1807: FROM AP_INVOICES_ALL
1808: WHERE INVOICE_ID = P_int_invoice_id;
1809:
1810:
1811: INSERT INTO AP_PAYMENT_SCHEDULES(

Line 2029: UPDATE ap_invoices_all AI

2025: l_Debug_Info := 'Zero related invoice';
2026:
2027: --Bug 4539462 DBI logging
2028: --Bug 5056061 Modified the update to prevent FTS
2029: UPDATE ap_invoices_all AI
2030: SET AI.description='VOID '||AI.description,
2031: AI.invoice_amount = 0,
2032: AI.pay_curr_invoice_amount = 0,
2033: AI.amount_paid = 0,

Line 2045: (p_table_name => 'AP_INVOICES',

2041: RETURNING invoice_id
2042: BULK COLLECT INTO l_dbi_key_value_list2;
2043:
2044: AP_DBI_PKG.Maintain_DBI_Summary
2045: (p_table_name => 'AP_INVOICES',
2046: p_operation => 'U',
2047: p_key_value_list => l_dbi_key_value_list2,
2048: p_calling_sequence => l_curr_calling_sequence);
2049:

Line 2302: ap_invoices_all ai

2298:
2299: SELECT nvl(interest_tolerance_amount,0)
2300: INTO C_interest_tolerance_amount
2301: FROM ap_system_parameters_all asp,
2302: ap_invoices_all ai
2303: WHERE ai.org_id = asp.org_id
2304: AND ai.invoice_id = p_invoice_id;
2305:
2306: ----------------------------------------------------------

Line 2339: FROM ap_invoices

2335:
2336: SELECT invoice_num|| '-INT' ||
2337: to_char(nvl(C_int_inv_num_ext, 0) + nvl(C_int_inv_num_ext2, 0) + 1)
2338: INTO P_interest_invoice_num
2339: FROM ap_invoices
2340: WHERE invoice_id = P_invoice_id;
2341:
2342: ---------------------------
2343: -- Get the due date

Line 2684: ap_invoices_s.NEXTVAL,

2680: org_id,
2681: last_update_login)
2682: VALUES (
2683: P_checkrun_name,
2684: ap_invoices_s.NEXTVAL,
2685: P_vendor_id,
2686: P_vendor_site_id,
2687: P_vendor_num,
2688: P_vendor_name,

Line 2809: ap_invoices_all orig,

2805: orig.invoice_id P_invoice_id,
2806: orig.invoice_currency_code P_invoice_currency_code,
2807: orig.org_id P_org_id
2808: FROM po_vendors pv,
2809: ap_invoices_all orig,
2810: ap_selected_invoices_all new,
2811: fnd_currencies base,
2812: fnd_currencies fcinv,
2813: iby_fd_docs_payable_v ibydocs