APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_BC_XLA_EVENTS_GT

Line 9462: where event_id IN (SELECT event_id from psa_bc_xla_events_gt)

9458: phase,
9459: sysdate
9460: BULK COLLECT INTO l_xla_distribution_links
9461: FROM xla_distribution_links
9462: where event_id IN (SELECT event_id from psa_bc_xla_events_gt)
9463: and application_id = psa_bc_xla_pvt.g_application_id;
9464:
9465:
9466:

Line 10479: -- Update PSA_BC_XLA_EVENTS_GT table with result_code

10475: END LOOP;
10476:
10477: -- Bug 5397349 .. End
10478:
10479: -- Update PSA_BC_XLA_EVENTS_GT table with result_code
10480:
10481: -- ====== FND LOG ======
10482: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update result_code '||
10483: 'of psa_bc_xla_events_gt');

Line 10483: 'of psa_bc_xla_events_gt');

10479: -- Update PSA_BC_XLA_EVENTS_GT table with result_code
10480:
10481: -- ====== FND LOG ======
10482: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update result_code '||
10483: 'of psa_bc_xla_events_gt');
10484: -- ====== FND LOG ======
10485:
10486: -- this update will ensure that only valid xla events
10487: -- provided for FUNDS CHECK (meant xla_ae_headers rows updated with funds_status_code)

Line 10489: UPDATE psa_bc_xla_events_gt eg

10485:
10486: -- this update will ensure that only valid xla events
10487: -- provided for FUNDS CHECK (meant xla_ae_headers rows updated with funds_status_code)
10488: -- are updated with appropiate status. Events NOT picked by funds checker will be updated with XLA_ERROR.
10489: UPDATE psa_bc_xla_events_gt eg
10490: SET result_code = (SELECT decode(min(funds_status_code),
10491: 'T', 'FATAL',
10492: 'S', 'SUCCESS',
10493: 'A', 'ADVISORY',

Line 10816: FROM psa_bc_xla_events_gt

10812: CURSOR c_success_evt_exists IS
10813: SELECT 'Successful event exists in the current packet'
10814: FROM gl_bc_packets
10815: WHERE event_id IN (SELECT event_id
10816: FROM psa_bc_xla_events_gt
10817: )
10818: AND application_id = PSA_BC_XLA_PVT.g_application_id
10819: AND status_code = 'A';
10820:

Line 10887: UPDATE psa_bc_xla_events_gt

10883: -- back to the calling transaction.
10884:
10885: IF (l_f81_cnt <> 0 OR l_f82_cnt <> 0) THEN
10886: FORALL k IN 1..p_failed_evnt_array.COUNT
10887: UPDATE psa_bc_xla_events_gt
10888: SET result_code = 'XLA_ERROR'
10889: WHERE event_id = p_failed_evnt_array(k)
10890: AND result_code <> 'XLA_ERROR';
10891:

Line 10893: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated PSA_BC_XLA_EVENTS_GT '||sql%rowcount||

10889: WHERE event_id = p_failed_evnt_array(k)
10890: AND result_code <> 'XLA_ERROR';
10891:
10892: -- ====== FND LOG ======
10893: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated PSA_BC_XLA_EVENTS_GT '||sql%rowcount||
10894: ' rows to XLA_ERROR status.');
10895: -- ====== FND LOG ======
10896:
10897: END IF;

Line 10917: FROM psa_bc_xla_events_gt

10913: WHERE affect_funds_flag = 'Y'
10914: AND packet_id IN ( SELECT packet_id
10915: FROM gl_bc_packets bc
10916: WHERE event_id IN ( SELECT event_id
10917: FROM psa_bc_xla_events_gt
10918: )
10919: AND application_id = PSA_BC_XLA_PVT.g_application_id
10920: AND result_code IN ('F81', 'F82')
10921: ) ;