[Home] [Help]
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:
1485: UPDATE ap_invoice_distributions_All AID
1486: SET POSTED_FLAG = 'N'
1487: WHERE AID.accounting_event_id in
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:
1490: UPDATE ap_self_assessed_tax_dist_all AID
1491: SET POSTED_FLAG = 'N'
1492: WHERE AID.accounting_event_id in
1489:
1490: UPDATE ap_self_assessed_tax_dist_all AID
1491: SET POSTED_FLAG = 'N'
1492: WHERE AID.accounting_event_id in
1493: ( select event_id from xla_events_gt);
1494:
1495: UPDATE ap_invoice_payments_all AIP
1496: SET POSTED_FLAG = 'N'
1497: WHERE AIP.accounting_event_id in
1494:
1495: UPDATE ap_invoice_payments_all AIP
1496: SET POSTED_FLAG = 'N'
1497: WHERE AIP.accounting_event_id in
1498: ( select event_id from xla_events_gt);
1499:
1500: UPDATE ap_prepay_history_all APPH
1501: SET APPH.posted_flag = 'N'
1502: WHERE APPH.accounting_event_id in
1499:
1500: UPDATE ap_prepay_history_all APPH
1501: SET APPH.posted_flag = 'N'
1502: WHERE APPH.accounting_event_id in
1503: ( select event_id from xla_events_gt);
1504: -- */
1505:
1506:
1507: IF (SQLCODE <> -20001) THEN
1566: IS
1567:
1568: CURSOR l_events_cur IS
1569: SELECT XEG.event_id
1570: FROM xla_events_gt XEG
1571: WHERE XEG.application_id = 200;
1572:
1573: l_event_ids l_event_ids_typ;
1574: l_debug_info VARCHAR2(240);
1618:
1619: -------------------------------------------------------------------------
1620: -- The call below will populate the prepayment distributions table
1621: -- and the payment distributions table for the events that are
1622: -- in xla_events_gt
1623: -------------------------------------------------------------------------
1624:
1625: AP_ACCOUNTING_PAY_PKG.Do_Pay_Accounting(l_curr_calling_sequence);
1626: