APPS.AP_SLA_PROCESSING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 21: -- | ap_invoice_distributions_all

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

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

28: --
29: -- Each record in the AP_INVOICE_PAYMENTS_ALL table relates a portion of a
30: -- payment to an invoice.
31: --
32: -- Each record in the AP_INVOICE_DISTRIBUTIONS_ALL table relates a portion of
33: -- the cost of an invoice to an accounting cost object.
34: --
35: -- Each record in the AP_PAYMENT_HIST_DISTS table relates a payment
36: -- distribution to a distribution.

Line 186: UPDATE ap_invoice_distributions_all AID

182: -- POSTED_FLAG of 'N' or 'S' will their POSTED_FLAGs update to 'S'.
183: ---------------------------------------------------------------------
184:
185: FORALL i IN 1 .. p_event_ids.count
186: UPDATE ap_invoice_distributions_all AID
187: SET AID.posted_flag = 'S'
188: WHERE AID.accounting_event_id = p_event_ids(i);
189:
190: -- bug fix 6975868

Line 737: UPDATE AP_Invoice_Distributions_all

733: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
734: WHERE Accounting_Event_ID = l_accrual_event_ids(num);
735:
736: FORALL num in 1 .. l_accrual_event_ids.COUNT
737: UPDATE AP_Invoice_Distributions_all
738: SET Posted_Flag = 'Y', Accrual_Posted_Flag = 'Y'
739: WHERE Accounting_Event_ID = l_accrual_event_ids(num)
740: RETURNING invoice_distribution_id,detail_tax_dist_id
741: BULK COLLECT INTO l_dbi_key_value_list1,

Line 824: UPDATE AP_Invoice_Distributions_ALL AID

820: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
821: -----------------------------------------------------------------------
822:
823: FORALL num in 1 .. l_prepay_event_list.COUNT
824: UPDATE AP_Invoice_Distributions_ALL AID
825: SET AID.Posted_Flag = 'Y',
826: AID.Accrual_Posted_Flag = 'N',
827: AID.Cash_Posted_Flag = 'Y'
828: WHERE AID.Accounting_Event_ID = l_prepay_event_list(num)

Line 961: UPDATE AP_Invoice_Distributions_all AID

957: l_prepay_event_list.COUNT;
958: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
959: -----------------------------------------------------------------------
960: FORALL num in 1 .. l_prepay_event_list.COUNT
961: UPDATE AP_Invoice_Distributions_all AID
962: SET AID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
963: l_prepay_event_list(num),
964: AID.Invoice_Distribution_ID,
965: AID.Amount,

Line 1063: UPDATE AP_Invoice_Distributions_all AID --Bug 4659793

1059: l_payclear_event_list.COUNT;
1060: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1061: -----------------------------------------------------------------------
1062: FORALL num in 1 .. l_payclear_event_list.COUNT
1063: UPDATE AP_Invoice_Distributions_all AID --Bug 4659793
1064: SET AID.Posted_Flag = 'Y', AID.Accrual_Posted_Flag = 'N' ,
1065: AID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1066: l_payclear_event_list(num),
1067: AID.Invoice_Distribution_ID,

Line 1181: UPDATE AP_Invoice_Distributions_all AID --Bug 4659793

1177: l_other_event_list.COUNT;
1178: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1179: -----------------------------------------------------------------------
1180: FORALL num in 1 .. l_other_event_list.COUNT
1181: UPDATE AP_Invoice_Distributions_all AID --Bug 4659793
1182: SET AID.Posted_Flag = 'Y', AID.Accrual_Posted_Flag = 'N' ,
1183: AID.Cash_Posted_Flag = Derive_Cash_Posted_Flag (
1184: l_other_event_list(num),
1185: AID.Invoice_Distribution_ID,

Line 1485: UPDATE ap_invoice_distributions_All AID

1481: SET POSTED_FLAG = 'N'
1482: WHERE APH.accounting_event_id in
1483: ( select event_id from xla_events_gt);
1484:
1485: UPDATE ap_invoice_distributions_All AID
1486: SET POSTED_FLAG = 'N'
1487: WHERE AID.accounting_event_id in
1488: ( select event_id from xla_events_gt);
1489:

Line 1912: UPDATE ap_invoice_distributions_all AID

1908: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1909: ---------------------------------------------------------------------
1910:
1911: FORALL i IN 1 .. l_event_ids.count
1912: UPDATE ap_invoice_distributions_all AID
1913: SET AID.posted_flag = 'N'
1914: WHERE AID.accounting_event_id = l_event_ids(i);
1915:
1916: FORALL i IN 1 .. l_event_ids.count