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 159: * Step 2. Create interest ap_invoices line

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

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

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

Line 340: -- Call ap_int_inv_insert_ap_invoices: Insert AP_INVOICES

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

Line 343: AP_INTEREST_INVOICE_PKG.ap_int_inv_insert_ap_invoices(

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

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

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

Line 657: -- get some required information from ap_invoices

653: AND pvs.vendor_site_id = P_vendor_site_id
654: AND NVL(pvs.org_id, -999) = NVL(asp.org_id, -999);
655:
656: ----------------------------------------------------------------------------
657: -- get some required information from ap_invoices
658: ----------------------------------------------------------------------------
659:
660: debug_info := 'get some required field from ap_invoices';
661:

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

656: ----------------------------------------------------------------------------
657: -- get some required information from ap_invoices
658: ----------------------------------------------------------------------------
659:
660: debug_info := 'get some required field from ap_invoices';
661:
662: SELECT ai.pay_group_lookup_code,
663: ai.invoice_currency_code,
664: ai.payment_currency_code,

Line 696: FROM ap_invoices ai,

692: P_Legal_Entity_ID,
693: P_party_id,
694: P_party_site_id,
695: P_payment_priority
696: FROM ap_invoices ai,
697: ap_payment_schedules ps
698: WHERE ai.invoice_id = P_invoice_id
699: AND ps.invoice_id = P_invoice_id
700: AND ps.payment_num = P_payment_num;

Line 733: Insert AP_INVOICES

729: END ap_int_inv_get_info;
730:
731:
732: /*==========================================================================
733: Insert AP_INVOICES
734: *==========================================================================*/
735:
736: PROCEDURE ap_int_inv_insert_ap_invoices(
737: P_int_invoice_id IN NUMBER,

Line 736: PROCEDURE ap_int_inv_insert_ap_invoices(

732: /*==========================================================================
733: Insert AP_INVOICES
734: *==========================================================================*/
735:
736: PROCEDURE ap_int_inv_insert_ap_invoices(
737: P_int_invoice_id IN NUMBER,
738: P_check_date IN DATE,
739: P_vendor_id IN NUMBER,
740: P_vendor_site_id IN NUMBER,

Line 777: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;

773: debug_info VARCHAR2(100);
774: current_calling_sequence VARCHAR2(2000);
775:
776: --Start of 8249618
777: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
778: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
779: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
780: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
781: l_relationship_id AP_INVOICES.relationship_id%TYPE;

Line 778: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;

774: current_calling_sequence VARCHAR2(2000);
775:
776: --Start of 8249618
777: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
778: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
779: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
780: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
781: l_relationship_id AP_INVOICES.relationship_id%TYPE;
782: --End of 8249618

Line 779: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;

775:
776: --Start of 8249618
777: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
778: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
779: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
780: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
781: l_relationship_id AP_INVOICES.relationship_id%TYPE;
782: --End of 8249618
783:

Line 780: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;

776: --Start of 8249618
777: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
778: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
779: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
780: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
781: l_relationship_id AP_INVOICES.relationship_id%TYPE;
782: --End of 8249618
783:
784: BEGIN

Line 781: l_relationship_id AP_INVOICES.relationship_id%TYPE;

777: l_remit_to_supplier_name AP_INVOICES.remit_to_supplier_name%TYPE;
778: l_remit_to_supplier_id AP_INVOICES.remit_to_supplier_id%TYPE;
779: l_remit_to_supplier_site AP_INVOICES.remit_to_supplier_site%TYPE;
780: l_remit_to_supplier_site_id AP_INVOICES.remit_to_supplier_site_id%TYPE;
781: l_relationship_id AP_INVOICES.relationship_id%TYPE;
782: --End of 8249618
783:
784: BEGIN
785:

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

789: -- P_last_update_login
790: -- Pass C_int_payment_base_amount for P_interest_base_amount
791: -- instead of recalculating it.
792:
793: current_calling_sequence := 'ap_int_inv_insert_ap_invoices<-'||
794: P_calling_sequence;
795:
796: IF (P_payment_mode = 'PAY') THEN
797:

Line 806: FROM AP_INVOICES_ALL

802: relationship_id
803: INTO l_remit_to_supplier_name, l_remit_to_supplier_id,
804: l_remit_to_supplier_site, l_remit_to_supplier_site_id,
805: l_relationship_id
806: FROM AP_INVOICES_ALL
807: WHERE INVOICE_ID = P_Invoice_id;
808:
809: debug_info := 'Insert into ap_invoices';
810:

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

805: l_relationship_id
806: FROM AP_INVOICES_ALL
807: WHERE INVOICE_ID = P_Invoice_id;
808:
809: debug_info := 'Insert into ap_invoices';
810:
811: INSERT INTO AP_INVOICES(
812: INVOICE_ID,
813: LAST_UPDATE_DATE,

Line 811: INSERT INTO AP_INVOICES(

807: WHERE INVOICE_ID = P_Invoice_id;
808:
809: debug_info := 'Insert into ap_invoices';
810:
811: INSERT INTO AP_INVOICES(
812: INVOICE_ID,
813: LAST_UPDATE_DATE,
814: LAST_UPDATED_BY,
815: VENDOR_ID,

Line 925: (p_table_name => 'AP_INVOICES',

921: l_relationship_id
922: --End 8249618
923: );
924: AP_DBI_PKG.Maintain_DBI_Summary
925: (p_table_name => 'AP_INVOICES',
926: p_operation => 'I',
927: p_key_value1 => P_Int_Invoice_id,
928: p_calling_sequence => current_calling_sequence);
929:

Line 973: END ap_int_inv_insert_ap_invoices;

969: END IF;
970:
971: APP_EXCEPTION.RAISE_EXCEPTION;
972:
973: END ap_int_inv_insert_ap_invoices;
974:
975:
976: /*==========================================================================
977: Insert AP_INVOICE_RELATIONSHIPS

Line 1605: -- and base_amount of ap_invoices table

1601: END IF ;
1602:
1603: -- Make sure that the total of amount and base amount in
1604: -- ap_invoice_distributions is equal to the invoice_amount
1605: -- and base_amount of ap_invoices table
1606:
1607: IF (p_interest_amount <> l_distribution_total OR
1608: p_interest_base_amount <> l_distribution_base_total ) THEN
1609:

Line 1933: UPDATE ap_invoices_all AI

1929: l_Debug_Info := 'Zero related invoice';
1930:
1931: --Bug 4539462 DBI logging
1932: --Bug 5056061 Modified the update to prevent FTS
1933: UPDATE ap_invoices_all AI
1934: SET AI.description='VOID '||AI.description,
1935: AI.invoice_amount = 0,
1936: AI.pay_curr_invoice_amount = 0,
1937: AI.amount_paid = 0,

Line 1949: (p_table_name => 'AP_INVOICES',

1945: RETURNING invoice_id
1946: BULK COLLECT INTO l_dbi_key_value_list2;
1947:
1948: AP_DBI_PKG.Maintain_DBI_Summary
1949: (p_table_name => 'AP_INVOICES',
1950: p_operation => 'U',
1951: p_key_value_list => l_dbi_key_value_list2,
1952: p_calling_sequence => l_curr_calling_sequence);
1953:

Line 2206: ap_invoices_all ai

2202:
2203: SELECT nvl(interest_tolerance_amount,0)
2204: INTO C_interest_tolerance_amount
2205: FROM ap_system_parameters_all asp,
2206: ap_invoices_all ai
2207: WHERE ai.org_id = asp.org_id
2208: AND ai.invoice_id = p_invoice_id;
2209:
2210: ----------------------------------------------------------

Line 2243: FROM ap_invoices

2239:
2240: SELECT invoice_num|| '-INT' ||
2241: to_char(nvl(C_int_inv_num_ext, 0) + nvl(C_int_inv_num_ext2, 0) + 1)
2242: INTO P_interest_invoice_num
2243: FROM ap_invoices
2244: WHERE invoice_id = P_invoice_id;
2245:
2246: ---------------------------
2247: -- Get the due date

Line 2570: ap_invoices_s.NEXTVAL,

2566: org_id,
2567: last_update_login)
2568: VALUES (
2569: P_checkrun_name,
2570: ap_invoices_s.NEXTVAL,
2571: P_vendor_id,
2572: P_vendor_site_id,
2573: P_vendor_num,
2574: P_vendor_name,

Line 2691: ap_invoices_all orig,

2687: orig.invoice_id P_invoice_id,
2688: orig.invoice_currency_code P_invoice_currency_code,
2689: orig.org_id P_org_id
2690: FROM po_vendors pv,
2691: ap_invoices_all orig,
2692: ap_selected_invoices_all new,
2693: fnd_currencies base,
2694: fnd_currencies fcinv,
2695: iby_fd_docs_payable_v ibydocs