APPS.PSA_FUNDS_CHECKER_PKG dependencies on PSA_BC_XLA_EVENTS_GT

Line 9650: where h.event_id IN (SELECT event_id from psa_bc_xla_events_gt)

9646: BULK COLLECT INTO l_xla_distribution_links
9647: FROM xla_distribution_links d
9648: where exists (select 1
9649: from xla_ae_headers h
9650: where h.event_id IN (SELECT event_id from psa_bc_xla_events_gt)
9651: and h.ae_header_id = d.ae_header_id)
9652: and application_id = psa_bc_xla_pvt.g_application_id;
9653:
9654:

Line 10781: -- Update PSA_BC_XLA_EVENTS_GT table with result_code

10777: END LOOP;
10778:
10779: -- Bug 5397349 .. End
10780:
10781: -- Update PSA_BC_XLA_EVENTS_GT table with result_code
10782:
10783: -- ====== FND LOG ======
10784: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update result_code '||
10785: 'of psa_bc_xla_events_gt');

Line 10785: 'of psa_bc_xla_events_gt');

10781: -- Update PSA_BC_XLA_EVENTS_GT table with result_code
10782:
10783: -- ====== FND LOG ======
10784: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update result_code '||
10785: 'of psa_bc_xla_events_gt');
10786: -- ====== FND LOG ======
10787:
10788: -- this update will ensure that only valid xla events
10789: -- provided for FUNDS CHECK (meant xla_ae_headers rows updated with funds_status_code)

Line 10791: UPDATE psa_bc_xla_events_gt eg

10787:
10788: -- this update will ensure that only valid xla events
10789: -- provided for FUNDS CHECK (meant xla_ae_headers rows updated with funds_status_code)
10790: -- are updated with appropiate status. Events NOT picked by funds checker will be updated with XLA_ERROR.
10791: UPDATE psa_bc_xla_events_gt eg
10792: SET result_code = (SELECT decode(min(funds_status_code),
10793: 'T', 'FATAL',
10794: 'S', 'SUCCESS',
10795: 'A', 'ADVISORY',

Line 11118: FROM psa_bc_xla_events_gt

11114: CURSOR c_success_evt_exists IS
11115: SELECT 'Successful event exists in the current packet'
11116: FROM gl_bc_packets
11117: WHERE event_id IN (SELECT event_id
11118: FROM psa_bc_xla_events_gt
11119: )
11120: AND application_id = PSA_BC_XLA_PVT.g_application_id
11121: AND status_code = 'A';
11122:

Line 11189: UPDATE psa_bc_xla_events_gt

11185: -- back to the calling transaction.
11186:
11187: IF (l_f81_cnt <> 0 OR l_f82_cnt <> 0) THEN
11188: FORALL k IN 1..p_failed_evnt_array.COUNT
11189: UPDATE psa_bc_xla_events_gt
11190: SET result_code = 'XLA_ERROR'
11191: WHERE event_id = p_failed_evnt_array(k)
11192: AND result_code <> 'XLA_ERROR';
11193:

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

11191: WHERE event_id = p_failed_evnt_array(k)
11192: AND result_code <> 'XLA_ERROR';
11193:
11194: -- ====== FND LOG ======
11195: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated PSA_BC_XLA_EVENTS_GT '||sql%rowcount||
11196: ' rows to XLA_ERROR status.');
11197: -- ====== FND LOG ======
11198:
11199: END IF;

Line 11219: FROM psa_bc_xla_events_gt

11215: WHERE affect_funds_flag = 'Y'
11216: AND packet_id IN ( SELECT packet_id
11217: FROM gl_bc_packets bc
11218: WHERE event_id IN ( SELECT event_id
11219: FROM psa_bc_xla_events_gt
11220: )
11221: AND application_id = PSA_BC_XLA_PVT.g_application_id
11222: AND result_code IN ('F81', 'F82')
11223: ) ;