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

Line 176: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;

172: l_last_line_flag BOOLEAN;
173: l_dummy VARCHAR2(200);
174: current_calling_sequence VARCHAR2(2000);
175: debug_info VARCHAR2(100);
176: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision_pay_curr fnd_currencies.precision%TYPE;
180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;

Line 177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;

173: l_dummy VARCHAR2(200);
174: current_calling_sequence VARCHAR2(2000);
175: debug_info VARCHAR2(100);
176: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
177: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
178: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;
179: l_precision_pay_curr fnd_currencies.precision%TYPE;
180: l_min_acc_unit_inv_curr fnd_currencies.minimum_accountable_unit%TYPE;
181: l_precision_inv_curr fnd_currencies.precision%TYPE;

Line 311: FROM ap_invoices

307: SELECT invoice_type_lookup_code,
308: vendor_site_id
309: INTO l_invoice_type,
310: l_vendor_site_id
311: FROM ap_invoices
312: WHERE invoice_id = P_Invoice_Id;
313:
314:
315: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 458: , ap_invoices ai

454: l_discount_amount, l_discount_amount_2, l_discount_amount_3
455:
456: FROM ap_terms
457: , ap_terms_lines
458: , ap_invoices ai
459: WHERE ap_terms.term_id = ap_terms_lines.term_id
460: AND ap_terms_lines.term_id = P_Terms_Id
461: AND ap_terms_lines.sequence_num = l_sequence_num
462: AND ai.Invoice_Id = P_Invoice_Id;

Line 669: , ap_invoices ai

665: T_REMIT_TO_SUPPLIER_SITE_ID(l_payment_schedule_index),
666: T_RELATIONSHIP_ID(l_payment_schedule_index)
667: FROM ap_terms
668: , ap_terms_lines
669: , ap_invoices ai
670: WHERE ap_terms.term_id = ap_terms_lines.term_id
671: AND ap_terms_lines.term_id = P_Terms_Id
672: AND ap_terms_lines.sequence_num = l_sequence_num
673: AND ai.Invoice_Id = P_Invoice_Id;

Line 804: ap_invoices ai

800: l_discount_amount, l_discount_amount_2, l_discount_amount_3
801:
802: FROM ap_terms,
803: ap_terms_lines,
804: ap_invoices ai
805: WHERE ap_terms.term_id = ap_terms_lines.term_id
806: AND ap_terms_lines.term_id = P_Terms_Id
807: AND ap_terms_lines.sequence_num = l_sequence_num
808: AND ai.invoice_id = P_Invoice_Id;

Line 1014: , ap_invoices ai

1010: T_REMIT_TO_SUPPLIER_SITE_ID(l_payment_schedule_index),
1011: T_RELATIONSHIP_ID(l_payment_schedule_index)
1012: FROM ap_terms
1013: , ap_terms_lines
1014: , ap_invoices ai
1015: WHERE ap_terms.term_id = ap_terms_lines.term_id
1016: AND ap_terms_lines.term_id = P_Terms_Id
1017: AND ap_terms_lines.sequence_num = l_sequence_num
1018: AND ai.invoice_id = P_Invoice_Id;

Line 1197: ap_invoices_pkg.validate_docs_payable(T_INVOICE_ID(j),

1193: p_calling_sequence => current_calling_sequence);
1194:
1195:
1196: FOR j IN 1..l_payment_schedule_index loop
1197: ap_invoices_pkg.validate_docs_payable(T_INVOICE_ID(j),
1198: T_PAYMENT_NUM(j),
1199: l_hold_flag); --not used
1200: end loop;
1201:

Line 1275: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;

1271: l_last_line_flag BOOLEAN;
1272: l_dummy VARCHAR2(200);
1273: current_calling_sequence VARCHAR2(2000);
1274: debug_info VARCHAR2(100);
1275: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
1276: l_orig_ext_bank_acct_id number; /*bug 1274099*/
1277: l_orig_ext_bank_exists varchar2(1);
1278: --bug 2143298 Included local variable to store invoice type
1279: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;

Line 1279: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;

1275: l_amount_for_discount ap_invoices.amount_applicable_to_discount%TYPE;
1276: l_orig_ext_bank_acct_id number; /*bug 1274099*/
1277: l_orig_ext_bank_exists varchar2(1);
1278: --bug 2143298 Included local variable to store invoice type
1279: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
1280: l_Payment_Priority NUMBER(15):=NULL; /*Bug fix:1635550*/
1281:
1282: -- Bug Fix: 1952122
1283: l_min_acc_unit_pay_curr fnd_currencies.minimum_accountable_unit%TYPE;

Line 1307: l_net_of_ret_flag ap_invoices.net_of_retainage_flag%TYPE; --bug 8991699

1303:
1304: l_api_name varchar(50); --bug 8991699
1305: l_debug_info varchar2(2000); --bug 8991699
1306: l_retained_amount number; --bug 8991699
1307: l_net_of_ret_flag ap_invoices.net_of_retainage_flag%TYPE; --bug 8991699
1308:
1309: CURSOR c_terms_percent IS
1310: SELECT 'Terms are percent type'
1311: FROM ap_terms_lines

Line 1357: ap_invoices ai,

1353:
1354: CURSOR c_orig_bank_acct_vendor IS --BUG 1274099, checks at the vendor level
1355: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7261556/7375488
1356: FROM ap_payment_schedules aps,
1357: ap_invoices ai,
1358: --iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1359: po_vendors pv
1360: WHERE ai.invoice_id = p_invoice_id
1361: AND ai.vendor_id = pv.vendor_id -- changed for bug 9531288

Line 1374: ap_invoices ai,

1370:
1371: CURSOR c_orig_bank_acct_vend_site IS
1372: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7437597
1373: FROM ap_payment_schedules aps,
1374: ap_invoices ai,
1375: iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1376: po_vendors pv
1377: WHERE ai.invoice_id = p_invoice_id
1378: AND ai.vendor_id = pv.vendor_id

Line 1486: FROM ap_invoices

1482: -- for credit/debit memo
1483:
1484: SELECT invoice_type_lookup_code
1485: INTO l_invoice_type
1486: FROM ap_invoices
1487: WHERE invoice_id = P_Invoice_Id;
1488:
1489:
1490: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1653: , ap_invoices ai

1649: l_discount_amount, l_discount_amount_2, l_discount_amount_3
1650:
1651: FROM ap_terms
1652: , ap_terms_lines
1653: , ap_invoices ai
1654: WHERE ap_terms.term_id = ap_terms_lines.term_id
1655: AND ap_terms_lines.term_id = P_Terms_Id
1656: AND ap_terms_lines.sequence_num = l_sequence_num
1657: AND ai.Invoice_Id = P_Invoice_Id;

Line 1869: ap_invoices ai,

1865: ,ai.remit_to_supplier_site_id
1866: ,ai.relationship_id
1867: FROM ap_terms,
1868: ap_terms_lines,
1869: ap_invoices ai,
1870: ap_recurring_payments arp --bug 5332569
1871: WHERE ap_terms.term_id = ap_terms_lines.term_id
1872: AND ap_terms_lines.term_id = P_Terms_Id
1873: AND ap_terms_lines.sequence_num = l_sequence_num

Line 1976: ap_invoices ai,

1972: l_discount_amount, l_discount_amount_2, l_discount_amount_3
1973:
1974: FROM ap_terms,
1975: ap_terms_lines,
1976: ap_invoices ai,
1977: ap_recurring_payments arp
1978: WHERE ap_terms.term_id = ap_terms_lines.term_id
1979: AND ap_terms_lines.term_id = P_Terms_Id
1980: AND ap_terms_lines.sequence_num = l_sequence_num

Line 2209: ap_invoices ai,

2205: ,ai.remit_to_supplier_site_id
2206: ,ai.relationship_id
2207: FROM ap_terms,
2208: ap_terms_lines,
2209: ap_invoices ai,
2210: ap_recurring_payments arp
2211: WHERE ap_terms.term_id = ap_terms_lines.term_id
2212: AND ap_terms_lines.term_id = P_Terms_Id
2213: AND ap_terms_lines.sequence_num = l_sequence_num

Line 2351: l_retained_amount := nvl(abs(ap_invoices_utility_pkg.get_retained_total

2347: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2348: END IF; --bug 8991699
2349:
2350: --bug 8991699 begins
2351: l_retained_amount := nvl(abs(ap_invoices_utility_pkg.get_retained_total
2352: (P_Invoice_Id,NULL)),0);
2353:
2354: Select nvl(net_of_retainage_flag,'N')
2355: into l_net_of_ret_flag

Line 2356: from ap_invoices

2352: (P_Invoice_Id,NULL)),0);
2353:
2354: Select nvl(net_of_retainage_flag,'N')
2355: into l_net_of_ret_flag
2356: from ap_invoices
2357: where invoice_id = P_Invoice_Id;
2358:
2359: --This procedure is called either during the time of recalculating
2360: --schedules or when invoice amount is updated as per fix 8891266.

Line 2388: ap_invoices_pkg.validate_docs_payable(p_INVOICE_ID,null,l_hold_flag);

2384: WHERE invoice_id = P_Invoice_Id);
2385: END IF;
2386:
2387:
2388: ap_invoices_pkg.validate_docs_payable(p_INVOICE_ID,null,l_hold_flag);
2389:
2390:
2391:
2392: EXCEPTION