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_SLA_PROCESSING_PKG dependencies on AP_PAYMENT_HISTORY

Line 16: -- ap_payment_history_all ap_invoice_lines_all

12: -- | |
13: -- | |
14: -- | |
15: -- /|\ /|\
16: -- ap_payment_history_all ap_invoice_lines_all
17: -- | |
18: -- | |
19: -- | |
20: -- | /|\

Line 155: UPDATE ap_payment_history_All APH

151: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
152: ---------------------------------------------------------------------
153:
154: FORALL i IN 1 .. p_event_ids.count
155: UPDATE ap_payment_history_All APH
156: SET POSTED_FLAG = 'S'
157: WHERE APH.accounting_event_id = p_event_ids(i);
158:
159: ---------------------------------------------------------------------

Line 509: l_matched_flag AP_PAYMENT_HISTORY_ALL.matched_flag%type;

505: TYPE checkStatusType IS TABLE OF
506: ap_checks_all.status_lookup_code%type INDEX BY PLS_INTEGER;
507:
508: l_Status AP_CHECKS_ALL.status_lookup_code%type;
509: l_matched_flag AP_PAYMENT_HISTORY_ALL.matched_flag%type;
510: l_debug_info VARCHAR2(240);
511: l_procedure_name CONSTANT VARCHAR2(30):='POSTPROCESSING_PROC';
512: l_curr_calling_sequence VARCHAR2(2000);
513:

Line 695: FROM AP_Payment_History_all APH, AP_CHECKS_all AC

691: -----------------------------------------------------------------------
692:
693: SELECT APH.matched_flag, AC.status_lookup_code
694: INTO l_matched_flag, l_status
695: FROM AP_Payment_History_all APH, AP_CHECKS_all AC
696: WHERE AC.check_id = APH.check_id
697: AND APH.accounting_Event_id = l_event_rec.event_id;
698:
699: IF l_status in ('RECONCILED UNACCOUNTED',

Line 1291: UPDATE ap_payment_history_all APH

1287: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1288: -----------------------------------------------------------------------
1289:
1290: FORALL num in 1 .. l_event_list.COUNT
1291: UPDATE ap_payment_history_all APH
1292: SET APH.posted_flag = 'Y'
1293: WHERE APH.accounting_event_id = l_event_list(num);
1294:
1295: -----------------------------------------------------------------------

Line 1316: AND not exists (select 1 from ap_payment_history

1312: FORALL num in 1 .. l_check_id_list.COUNT
1313: UPDATE AP_Checks_All
1314: SET status_lookup_code = l_check_status_list(num)
1315: WHERE check_id = l_check_id_list(num)
1316: AND not exists (select 1 from ap_payment_history
1317: where check_id=l_check_id_list(num)
1318: and posted_flag<>'Y');
1319:
1320: -----------------------------------------------------------------------

Line 1480: UPDATE ap_payment_history_All APH

1476: l_debug_info := 'clean up and set back posted flag value to N';
1477: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1478: ---------------------------------------------------------------------
1479: /* -- need to make the following autonmous commit
1480: UPDATE ap_payment_history_All APH
1481: SET POSTED_FLAG = 'N'
1482: WHERE APH.accounting_event_id in
1483: ( select event_id from xla_events_gt);
1484:

Line 1839: -- UPDATE ap_payment_history_all APH

1835: -- posted_flag to 'Y' for payment create and maturity event after
1836: -- Create Accounting program
1837:
1838: -- FORALL i IN 1 .. l_event_ids.count
1839: -- UPDATE ap_payment_history_all APH
1840: -- SET APH.posted_flag = 'N'
1841: -- WHERE APH.accounting_event_id = l_event_ids(i);
1842:
1843: -- Bug 7374984. Updating the posted flag to 'Y' if the events

Line 1846: UPDATE ap_payment_history_all APH

1842:
1843: -- Bug 7374984. Updating the posted flag to 'Y' if the events
1844: -- are set to no action.
1845: FORALL i IN 1 .. l_event_ids.count
1846: UPDATE ap_payment_history_all APH
1847: SET APH.POSTED_FLAG = CASE WHEN l_event_status(i) = 'U'
1848: AND EXISTS(SELECT 1
1849: FROM ap_system_parameters asp
1850: WHERE asp.when_to_account_pmt = 'CLEARING ONLY'

Line 1893: FROM ap_system_parameters asp, ap_payment_history_all aph

1889: FORALL i IN 1 .. l_event_ids.count
1890: UPDATE ap_invoice_payments_all AIP
1891: SET AIP.POSTED_FLAG = CASE WHEN l_event_status(i) = 'U'
1892: AND EXISTS(SELECT 1
1893: FROM ap_system_parameters asp, ap_payment_history_all aph
1894: WHERE asp.when_to_account_pmt = 'CLEARING ONLY'
1895: --AND asp.org_id = l_org_id(i)
1896: AND asp.org_id = aph.org_id
1897: AND aph.accounting_event_id = l_event_ids(i)

Line 2039: FROM AP_Payment_History_All APH

2035:
2036: BEGIN
2037: SELECT APH.Transaction_Type
2038: INTO l_transaction_type
2039: FROM AP_Payment_History_All APH
2040: WHERE APH.Accounting_Event_ID = P_Event_ID;
2041: EXCEPTION
2042: WHEN others THEN
2043: l_transaction_type := 'PAYMENT CREATED';

Line 2054: AP_Payment_History_All APH

2050: /* Getting the sum of dist amount for the given distribution */
2051: SELECT SUM(APHD.Invoice_Dist_Amount)
2052: INTO l_paid_acctd_amt
2053: FROM AP_Payment_Hist_Dists APHD,
2054: AP_Payment_History_All APH
2055: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
2056: AND APH.Posted_Flag = 'Y'
2057: AND APH.Payment_History_ID = APHD.Payment_History_ID
2058: AND APH.Transaction_Type IN ('PAYMENT CLEARING', 'PAYMENT UNCLEARING',

Line 2068: AP_Payment_History_All APH

2064: /* Getting the sum of dist amount for the given distribution */
2065: SELECT SUM(APHD.Invoice_Dist_Amount)
2066: INTO l_paid_acctd_amt
2067: FROM AP_Payment_Hist_Dists APHD,
2068: AP_Payment_History_All APH
2069: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
2070: AND APH.Posted_Flag = 'Y'
2071: AND APH.Payment_History_ID = APHD.Payment_History_ID
2072: AND APH.Transaction_Type IN ('PAYMENT MATURITY', 'PAYMENT MATURITY REVERSED',

Line 2081: AP_Payment_History_All APH

2077: /* Getting the sum of dist amount for the given distribution */
2078: SELECT SUM(APHD.Invoice_Dist_Amount)
2079: INTO l_paid_acctd_amt
2080: FROM AP_Payment_Hist_Dists APHD,
2081: AP_Payment_History_All APH
2082: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
2083: AND APH.Posted_Flag = 'Y'
2084: AND APH.Payment_History_ID = APHD.Payment_History_ID
2085: AND APH.Transaction_Type IN ('PAYMENT CREATED', 'PAYMENT CANCELLED', 'PAYMENT ADJUSTED',