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.FUN_NET_ARAP_PKG dependencies on AP_CHECKS

Line 3260: l_check_id ap_checks.check_id%TYPE;

3256: x_return_status OUT NOCOPY VARCHAR2)
3257: IS
3258: l_vendor_name po_vendors.vendor_name%TYPE;
3259: l_vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE;
3260: l_check_id ap_checks.check_id%TYPE;
3261: l_old_invoice ap_invoices.invoice_id%TYPE;
3262: amt_remaining ap_payment_schedules.amount_remaining%TYPE;
3263: l_bank_num ce_banks_v.bank_number%TYPE;
3264: -- Bug: 8537760

Line 3274: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;

3270: l_gl_date date; -- Bug: 7639863
3271: TYPE vendor_type IS TABLE OF po_vendors.vendor_id%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE vendor_site_type IS TABLE OF po_vendor_sites_all.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE ap_invoice_type IS TABLE OF ap_invoices.invoice_id%TYPE INDEX BY BINARY_INTEGER;
3276: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;
3277: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;
3278: ap_check_amt_list ap_check_amt_type;

Line 3288: ap_check_rec ap_checks_all%ROWTYPE;

3284: ap_invoice ap_invoice_type;
3285: party_list party_type;
3286: party_site_list party_site_type;
3287: ap_payment_info_tab AP_PAYMENT_PUBLIC_PKG.Invoice_Payment_Info_Tab;
3288: ap_check_rec ap_checks_all%ROWTYPE;
3289: p_schd_tab pymt_sch_tab;
3290: BEGIN
3291: -- Group Invoices by Vendor , Vendor Site and Payment Currency .
3292: x_return_status := FND_API.G_TRUE;

Line 3341: SELECT fun.fun_net_ap_checks_s.nextval

3337: ap_check_rec.vendor_site_code);
3338: ap_check_rec.vendor_id := vendor_list(i);
3339: ap_check_rec.vendor_site_id := vendor_site_list(i);
3340: /* Get Check Number from Sequence */
3341: SELECT fun.fun_net_ap_checks_s.nextval
3342: INTO ap_check_rec.check_number
3343: FROM DUAL;
3344: ap_check_rec.CHECK_DATE := g_batch_details.settlement_date;
3345: l_gl_date := nvl(g_batch_details.gl_date, g_batch_details.settlement_date); /* 7639863 */