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_ALL

Line 17: -- ap_payment_history_all ap_invoice_lines_all

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

Line 160: UPDATE ap_payment_history_All APH

156: l_debug_info := 'Mark payment history posted_flag';
157: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
158: ---------------------------------------------------------------------
159: FORALL i IN 1 .. p_event_ids.count
160: UPDATE ap_payment_history_All APH
161: SET POSTED_FLAG = 'S'
162: -- bug 10101613
163: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
164: ,LAST_UPDATE_DATE = SYSDATE

Line 549: l_matched_flag AP_PAYMENT_HISTORY_ALL.matched_flag%type;

545: TYPE checkStatusType IS TABLE OF
546: ap_checks_all.status_lookup_code%type INDEX BY PLS_INTEGER;
547:
548: l_Status AP_CHECKS_ALL.status_lookup_code%type;
549: l_matched_flag AP_PAYMENT_HISTORY_ALL.matched_flag%type;
550: l_debug_info VARCHAR2(240);
551: l_procedure_name CONSTANT VARCHAR2(30):='POSTPROCESSING_PROC';
552: l_curr_calling_sequence VARCHAR2(2000);
553:

Line 743: FROM AP_Payment_History_all APH, AP_CHECKS_all AC

739: -----------------------------------------------------------------------
740:
741: SELECT APH.matched_flag, AC.status_lookup_code
742: INTO l_matched_flag, l_status
743: FROM AP_Payment_History_all APH, AP_CHECKS_all AC
744: WHERE AC.check_id = APH.check_id
745: AND APH.accounting_Event_id = l_event_rec.event_id;
746:
747: IF l_status in ('RECONCILED UNACCOUNTED',

Line 1033: UPDATE ap_payment_history_all APH

1029: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1030: -----------------------------------------------------------------------
1031:
1032: FORALL num in 1 .. l_event_list.COUNT
1033: UPDATE ap_payment_history_all APH
1034: SET APH.posted_flag = 'Y'
1035: -- bug 10101613
1036: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1037: ,LAST_UPDATE_DATE = SYSDATE

Line 1071: AND not exists (SELECT 1 FROM ap_payment_history_all aph,

1067: ,LAST_UPDATE_DATE = SYSDATE
1068: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1069: WHERE check_id = l_check_id_list(num)
1070: --Bug 8973135 Start
1071: AND not exists (SELECT 1 FROM ap_payment_history_all aph,
1072: ap_system_parameters_all asp
1073: WHERE aph.check_id=l_check_id_list(num)
1074: AND posted_flag<>'Y'
1075: AND aph.org_id = asp.org_id

Line 1221: Ap_Payment_History_All APH --bug 9151717

1217: ,LAST_UPDATE_DATE = SYSDATE
1218: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1219: WHERE AID.Invoice_ID IN (SELECT distinct AIP.invoice_id
1220: FROM Ap_Invoice_Payments_All AIP,
1221: Ap_Payment_History_All APH --bug 9151717
1222: WHERE AIP.check_id = APH.check_id
1223: AND APH.Accounting_Event_ID
1224: = l_payclear_event_list(num))
1225: AND AID.Prepay_Distribution_ID IS NULL

Line 1292: Ap_Payment_History_All APH --bug 9151717

1288: ,LAST_UPDATE_DATE = SYSDATE
1289: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1290: WHERE STID.Invoice_ID IN (SELECT distinct AIP.invoice_id
1291: FROM Ap_Invoice_Payments_All AIP,
1292: Ap_Payment_History_All APH --bug 9151717
1293: WHERE AIP.check_id = APH.check_id
1294: AND APH.Accounting_Event_ID
1295: = l_payclear_event_list(num))
1296: AND STID.Prepay_Distribution_ID IS NULL

Line 1657: UPDATE ap_payment_history_All APH

1653: l_debug_info := 'Mark payment history posted_flag';
1654: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1655: ---------------------------------------------------------------------
1656: FORALL i IN 1 .. l_event_ids.count
1657: UPDATE ap_payment_history_All APH
1658: SET POSTED_FLAG = 'N'
1659: -- bug 10101613
1660: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1661: ,LAST_UPDATE_DATE = SYSDATE

Line 1755: UPDATE ap_payment_history_All APH

1751: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1752: ---------------------------------------------------------------------
1753: */
1754: /* -- need to make the following autonmous commit
1755: UPDATE ap_payment_history_All APH
1756: SET POSTED_FLAG = 'N'
1757: WHERE APH.accounting_event_id in
1758: ( select event_id from xla_events_gt);
1759:

Line 2130: UPDATE ap_payment_history_all APH

2126: -- Bug 7374984. Updating the posted flag to 'Y' if the events
2127: -- are set to no action.
2128:
2129: FORALL i IN 1 .. l_event_ids.count
2130: UPDATE ap_payment_history_all APH
2131: SET APH.POSTED_FLAG = CASE
2132: WHEN l_event_status(i) = 'N' THEN 'Y'
2133: ELSE 'N'
2134: END

Line 2378: FROM AP_Payment_History_All APH

2374:
2375: BEGIN
2376: SELECT APH.Transaction_Type
2377: INTO l_transaction_type
2378: FROM AP_Payment_History_All APH
2379: WHERE APH.Accounting_Event_ID = P_Event_ID;
2380: EXCEPTION
2381: WHEN others THEN
2382: l_transaction_type := 'PAYMENT CREATED';

Line 2394: AP_Payment_History_All APH

2390: -- 9803363 , added code to get dist id and awt calculated on it
2391: SELECT SUM(APHD.Invoice_Dist_Amount)
2392: INTO l_paid_acctd_amt
2393: FROM AP_Payment_Hist_Dists APHD,
2394: AP_Payment_History_All APH
2395: WHERE APHD.Invoice_Distribution_ID in ( select p_invoice_distribution_id from dual
2396: union
2397: select distinct aphd_awt.invoice_distribution_id
2398: from ap_payment_hist_dists aphd_awt,

Line 2418: AP_Payment_History_All APH

2414: -- 9803363 , added code to get dist id and awt calculated on it
2415: SELECT SUM(APHD.Invoice_Dist_Amount)
2416: INTO l_paid_acctd_amt
2417: FROM AP_Payment_Hist_Dists APHD,
2418: AP_Payment_History_All APH
2419: WHERE APHD.Invoice_Distribution_ID in ( select p_invoice_distribution_id from dual
2420: union
2421: select distinct aphd_awt.invoice_distribution_id
2422: from ap_payment_hist_dists aphd_awt,

Line 2441: AP_Payment_History_All APH

2437: -- 9803363 , added code to get dist id and awt calculated on it
2438: SELECT SUM(APHD.Invoice_Dist_Amount)
2439: INTO l_paid_acctd_amt
2440: FROM AP_Payment_Hist_Dists APHD,
2441: AP_Payment_History_All APH
2442: WHERE APHD.Invoice_Distribution_ID in ( select p_invoice_distribution_id from dual
2443: union
2444: select distinct aphd_awt.invoice_distribution_id
2445: from ap_payment_hist_dists aphd_awt,