APPS.AP_SLA_PROCESSING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 22: -- | ap_invoice_distributions_all

18: -- | |
19: -- | |
20: -- | |
21: -- | /|\
22: -- | ap_invoice_distributions_all
23: -- | | |
24: -- | +---------------------------------------------+ |
25: -- | | |
26: -- /|\ /|\ /|\

Line 33: -- Each record in the AP_INVOICE_DISTRIBUTIONS_ALL table relates a portion of

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.
35: --
36: -- Each record in the AP_PAYMENT_HIST_DISTS table relates a payment
37: -- distribution to a distribution.

Line 203: UPDATE ap_invoice_distributions_all AID

199: -- POSTED_FLAG of 'N' or 'S' will their POSTED_FLAGs update to 'S'.
200: ---------------------------------------------------------------------
201:
202: FORALL i IN 1 .. p_event_ids.count
203: UPDATE ap_invoice_distributions_all AID
204: SET AID.posted_flag = 'S'
205: -- bug 10101613
206: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
207: ,LAST_UPDATE_DATE = SYSDATE

Line 789: UPDATE AP_Invoice_Distributions_all

785: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
786: WHERE Accounting_Event_ID = l_accrual_event_ids(num);
787:
788: FORALL num in 1 .. l_accrual_event_ids.COUNT
789: UPDATE AP_Invoice_Distributions_all
790: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
791: -- bug 10101613
792: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
793: ,LAST_UPDATE_DATE = SYSDATE

Line 888: UPDATE AP_Invoice_Distributions_ALL AID

884: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
885: -----------------------------------------------------------------------
886:
887: FORALL num in 1 .. l_prepay_event_list.COUNT
888: UPDATE AP_Invoice_Distributions_ALL AID
889: SET AID.Posted_Flag = 'Y',
890: AID.Accrual_Posted_Flag = 'N',
891: AID.Cash_Posted_Flag = 'Y'
892: -- bug 10101613

Line 1090: UPDATE AP_Invoice_Distributions_all AID

1086: l_prepay_event_list.COUNT;
1087: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1088: -----------------------------------------------------------------------
1089: FORALL num in 1 .. l_prepay_event_list.COUNT
1090: UPDATE AP_Invoice_Distributions_all AID
1091: SET AID.Posted_Flag = 'Y', AID.Accrual_Posted_Flag = 'N' , --9698155
1092: AID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1093: l_prepay_event_list(num),
1094: AID.Invoice_Distribution_ID,

Line 1202: UPDATE AP_Invoice_Distributions_all AID --Bug 4659793

1198: l_payclear_event_list.COUNT;
1199: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1200: -----------------------------------------------------------------------
1201: FORALL num in 1 .. l_payclear_event_list.COUNT
1202: UPDATE AP_Invoice_Distributions_all AID --Bug 4659793
1203: SET AID.Posted_Flag = 'Y', AID.Accrual_Posted_Flag = 'N' ,
1204: AID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1205: l_payclear_event_list(num),
1206: AID.Invoice_Distribution_ID,

Line 1332: UPDATE AP_Invoice_Distributions_all AID --Bug 4659793

1328: l_other_event_list.COUNT;
1329: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1330: -----------------------------------------------------------------------
1331: FORALL num in 1 .. l_other_event_list.COUNT
1332: UPDATE AP_Invoice_Distributions_all AID --Bug 4659793
1333: SET AID.Posted_Flag = 'Y', AID.Accrual_Posted_Flag = 'N' ,
1334: AID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1335: l_other_event_list(num),
1336: AID.Invoice_Distribution_ID,

Line 1445: UPDATE AP_Invoice_Distributions_all AID

1441: -- bug fix 6975868 end
1442: /*Bug 12560872 start */
1443:
1444: FORALL num in 1 .. l_cash_inv_event_list.COUNT
1445: UPDATE AP_Invoice_Distributions_all AID
1446: SET AID.Posted_Flag = 'N',
1447: AID.Accrual_Posted_Flag = 'N' ,
1448: AID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1449: l_cash_inv_event_list(num),

Line 1760: UPDATE ap_invoice_distributions_All AID

1756: SET POSTED_FLAG = 'N'
1757: WHERE APH.accounting_event_id in
1758: ( select event_id from xla_events_gt);
1759:
1760: UPDATE ap_invoice_distributions_All AID
1761: SET POSTED_FLAG = 'N'
1762: WHERE AID.accounting_event_id in
1763: ( select event_id from xla_events_gt);
1764:

Line 2208: UPDATE ap_invoice_distributions_all AID

2204: -- bug9444952 : Setting posted flags to appropriate statuses
2205: -- in case the Event_Status_Code is 'N'
2206: --
2207: FORALL i IN 1 .. l_event_ids.count
2208: UPDATE ap_invoice_distributions_all AID
2209: SET AID.posted_flag = CASE
2210: WHEN l_event_status(i) = 'N' THEN 'Y'
2211: ELSE 'N'
2212: END,