APPS.AP_SLA_PROCESSING_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 7: -- ap_invoice_payments_all

3:
4:
5: -------------------------------------------------------------------------------
6: --
7: -- ap_invoice_payments_all
8: -- \|/ \|/
9: -- | |
10: -- +-----------------------+ +------------------------+
11: -- | |

Line 30: -- Each record in the AP_INVOICE_PAYMENTS_ALL table relates a portion of a

26: -- /|\ /|\ /|\
27: -- ap_payment_hist_dists ap_prepay_app_dists
28: --
29: --
30: -- Each record in the AP_INVOICE_PAYMENTS_ALL table relates a portion of a
31: -- payment to an invoice.
32: --
33: -- Each record in the AP_INVOICE_DISTRIBUTIONS_ALL table relates a portion of
34: -- the cost of an invoice to an accounting cost object.

Line 179: UPDATE ap_invoice_payments_all AIP

175: -- or 'S' will their POSTED_FLAGs update to 'S'.
176: ---------------------------------------------------------------------
177:
178: FORALL i IN 1 .. p_event_ids.count
179: UPDATE ap_invoice_payments_all AIP
180: SET AIP.posted_flag = 'S'
181: -- bug 10101613
182: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
183: ,LAST_UPDATE_DATE = SYSDATE

Line 780: UPDATE AP_Invoice_Payments_all

776: -----------------------------------------------------------------------
777:
778:
779: FORALL num in 1 .. l_accrual_event_ids.COUNT
780: UPDATE AP_Invoice_Payments_all
781: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
782: -- bug 10101613
783: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
784: ,LAST_UPDATE_DATE = SYSDATE

Line 870: UPDATE AP_Invoice_Payments_all

866: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
867: -----------------------------------------------------------------------
868:
869: FORALL num in 1 .. l_cash_event_ids.COUNT
870: UPDATE AP_Invoice_Payments_all
871: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'N', Cash_Posted_Flag = 'Y'
872: -- bug 10101613
873: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
874: ,LAST_UPDATE_DATE = SYSDATE

Line 1220: FROM Ap_Invoice_Payments_All AIP,

1216: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
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))

Line 1291: FROM Ap_Invoice_Payments_All AIP,

1287: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
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))

Line 1344: FROM Ap_Invoice_Payments_All AIP

1340: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1341: ,LAST_UPDATE_DATE = SYSDATE
1342: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1343: WHERE AID.Invoice_ID IN (SELECT AIP.invoice_id
1344: FROM Ap_Invoice_Payments_All AIP
1345: WHERE AIP.Accounting_Event_ID
1346: = l_other_event_list(num))
1347: AND AID.Prepay_Distribution_ID IS NULL
1348: AND AID.prepay_tax_parent_id IS NULL

Line 1413: FROM Ap_Invoice_Payments_All AIP

1409: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1410: ,LAST_UPDATE_DATE = SYSDATE
1411: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1412: WHERE STID.Invoice_ID IN (SELECT AIP.invoice_id
1413: FROM Ap_Invoice_Payments_All AIP
1414: WHERE AIP.Accounting_Event_ID
1415: = l_other_event_list(num))
1416: AND STID.Prepay_Distribution_ID IS NULL
1417: AND nvl(STID.cancellation_flag,'N') <> 'Y'

Line 1671: UPDATE ap_invoice_payments_all AIP

1667: l_debug_info := 'Mark the payments posted_flag';
1668: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1669: ---------------------------------------------------------------------
1670: FORALL i IN 1 .. l_event_ids.count
1671: UPDATE ap_invoice_payments_all AIP
1672: SET AIP.posted_flag = 'N'
1673: -- bug 10101613
1674: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
1675: ,LAST_UPDATE_DATE = SYSDATE

Line 1770: UPDATE ap_invoice_payments_all AIP

1766: SET POSTED_FLAG = 'N'
1767: WHERE AID.accounting_event_id in
1768: ( select event_id from xla_events_gt);
1769:
1770: UPDATE ap_invoice_payments_all AIP
1771: SET POSTED_FLAG = 'N'
1772: WHERE AIP.accounting_event_id in
1773: ( select event_id from xla_events_gt);
1774:

Line 2177: UPDATE ap_invoice_payments_all AIP

2173: -- Bug 7374984. Updating the posted flag to 'Y' if the events
2174: -- are set to no action.
2175:
2176: FORALL i IN 1 .. l_event_ids.count
2177: UPDATE ap_invoice_payments_all AIP
2178: SET AIP.Posted_flag = CASE
2179: WHEN l_event_status(i) = 'N' THEN 'Y'
2180: ELSE 'N'
2181: END,