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_PMT_CALLOUT_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 649: update ap_payment_schedules_all

645: calling_app_doc_unique_ref3
646: from iby_fd_docs_payable_v
647: where rejected_docs_group_id = p_rejected_docs_group_id);
648:
649: update ap_payment_schedules_all
650: set checkrun_id = null
651: where checkrun_id = l_checkrun_id
652: /* Bug 6950891. Added TO_CHAR */
653: and (TO_CHAR(invoice_id), TO_CHAR(payment_num)) in

Line 833: FROM ap_payment_schedules_all ps,

829: si.withholding_amount,
830: Null,
831: ps.invoice_id,
832: ps.payment_num
833: FROM ap_payment_schedules_all ps,
834: ap_invoices_all inv,
835: ap_selected_invoices_all si,
836: iby_fd_payments_v ibypmts,
837: iby_fd_docs_payable_v ibydocs

Line 1346: l_debug_info := 'INSERT INTO ap_payment_schedules_all';

1342: p_org_id => l_current_org_id);
1343:
1344:
1345:
1346: l_debug_info := 'INSERT INTO ap_payment_schedules_all';
1347: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1349: END IF;
1350:

Line 1351: INSERT INTO ap_payment_schedules_all(

1347: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1349: END IF;
1350:
1351: INSERT INTO ap_payment_schedules_all(
1352: invoice_id,
1353: payment_num,
1354: last_update_date,
1355: last_updated_by,

Line 1859: l_debug_info := 'UPDATE ap_payment_schedules_all';

1855: invoice_id_ps_l,
1856: payment_num_ps_l
1857: LIMIT 1000;
1858:
1859: l_debug_info := 'UPDATE ap_payment_schedules_all';
1860: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1861: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1862: END IF;
1863:

Line 1865: UPDATE ap_payment_schedules_all

1861: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1862: END IF;
1863:
1864: FORALL i IN 1..invoice_id_ps_l.COUNT
1865: UPDATE ap_payment_schedules_all
1866: SET last_update_date = last_update_date_ps_l(i)
1867: ,last_updated_by = last_updated_by_ps_l(i)
1868: -- Modified by epajaril, need to consider the AWT
1869: -- ,amount_remaining = amount_remaining_ps_l(i)

Line 2130: ap_payment_schedules_all PS,

2126: iby_fd_payments_v ibypmts,
2127: iby_fd_docs_payable_v ibydocs,
2128: ap_selected_invoices_all SI,
2129: fnd_currencies FORE,
2130: ap_payment_schedules_all PS,
2131: ap_invoices_all AI,
2132: ap_checks_all ac,
2133: ap_supplier_sites_all aps, -- bug 7673570
2134: ce_bank_acct_uses_all ceu,

Line 2243: l_debug_info := 'UPDATE ap_payment_schedules_all';

2239: invoice_id_ps_l,
2240: payment_num_ps_l
2241: LIMIT 1000;
2242:
2243: l_debug_info := 'UPDATE ap_payment_schedules_all';
2244: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2246: END IF;
2247:

Line 2249: UPDATE ap_payment_schedules_all

2245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2246: END IF;
2247:
2248: FORALL i IN 1..invoice_id_ps_l.COUNT
2249: UPDATE ap_payment_schedules_all
2250: SET last_update_date = last_update_date_ps_l(i)
2251: ,last_updated_by = last_updated_by_ps_l(i)
2252: ,amount_remaining = amount_remaining_ps_l(i)
2253: ,discount_amount_remaining = discount_remaining_ps_l(i)

Line 2306: /* UPDATE ap_payment_schedules_all ps1

2302: END LOOP;
2303:
2304: CLOSE c_invoice_amounts; Bug5733731 */
2305:
2306: /* UPDATE ap_payment_schedules_all ps1
2307: SET (last_update_date,
2308: last_updated_by,
2309: amount_remaining,
2310: discount_amount_remaining,