APPS.AP_PMT_CALLOUT_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 724: update ap_payment_schedules_all

720: calling_app_doc_unique_ref3
721: from iby_fd_docs_payable_v
722: where rejected_docs_group_id = p_rejected_docs_group_id);
723:
724: update ap_payment_schedules_all
725: set checkrun_id = null
726: where checkrun_id = l_checkrun_id
727: /* Bug 6950891. Added TO_CHAR */
728: /* Bug 12679356. Removed to_char */

Line 932: FROM ap_payment_schedules_all ps,

928: si.withholding_amount,
929: Null,
930: ps.invoice_id,
931: ps.payment_num
932: FROM ap_payment_schedules_all ps,
933: ap_invoices_all inv,
934: ap_selected_invoices_all si,
935: /*iby_fd_payments_v ibypmts, Commented for Bug#9459810 */
936: iby_fd_docs_payable_v ibydocs

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

1513: p_org_id => l_current_org_id);
1514:
1515:
1516:
1517: l_debug_info := 'INSERT INTO ap_payment_schedules_all';
1518: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1519: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1521: END IF;

Line 1523: INSERT INTO ap_payment_schedules_all(

1519: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1521: END IF;
1522:
1523: INSERT INTO ap_payment_schedules_all(
1524: invoice_id,
1525: payment_num,
1526: last_update_date,
1527: last_updated_by,

Line 2053: l_debug_info := 'UPDATE ap_payment_schedules_all';

2049: invoice_id_ps_l,
2050: payment_num_ps_l
2051: LIMIT 1000;
2052:
2053: l_debug_info := 'UPDATE ap_payment_schedules_all';
2054: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2055: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2056: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2057: END IF;

Line 2062: UPDATE ap_payment_schedules_all

2058:
2059:
2060: FORALL i IN 1..invoice_id_ps_l.COUNT
2061:
2062: UPDATE ap_payment_schedules_all
2063: SET last_update_date = last_update_date_ps_l(i)
2064: ,last_updated_by = last_updated_by_ps_l(i)
2065: -- Modified by epajaril, need to consider the AWT
2066: --Bug8477014: Undoing changes done for bug6836199

Line 2323: ap_payment_schedules_all PS,

2319: iby_fd_payments_v ibypmts,
2320: iby_fd_docs_payable_v ibydocs,
2321: ap_selected_invoices_all SI,
2322: fnd_currencies FORE,
2323: ap_payment_schedules_all PS,
2324: ap_invoices_all AI,
2325: ap_checks_all ac,
2326: --ap_supplier_sites_all aps, -- bug 7673570 --Removed by bug 9074840
2327: --ce_bank_acct_uses_all ceu, --Removed by bug 9074840

Line 2457: l_debug_info := 'UPDATE ap_payment_schedules_all';

2453: invoice_id_ps_l,
2454: payment_num_ps_l
2455: LIMIT 1000;
2456:
2457: l_debug_info := 'UPDATE ap_payment_schedules_all';
2458: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2460: END IF;
2461:

Line 2463: UPDATE ap_payment_schedules_all

2459: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2460: END IF;
2461:
2462: FORALL i IN 1..invoice_id_ps_l.COUNT
2463: UPDATE ap_payment_schedules_all
2464: SET last_update_date = last_update_date_ps_l(i)
2465: ,last_updated_by = last_updated_by_ps_l(i)
2466: ,amount_remaining = amount_remaining_ps_l(i)
2467: ,discount_amount_remaining = discount_remaining_ps_l(i)

Line 2520: /* UPDATE ap_payment_schedules_all ps1

2516: END LOOP;
2517:
2518: CLOSE c_invoice_amounts; Bug5733731 */
2519:
2520: /* UPDATE ap_payment_schedules_all ps1
2521: SET (last_update_date,
2522: last_updated_by,
2523: amount_remaining,
2524: discount_amount_remaining,