APPS.PSA_AP_BC_PVT dependencies on PSA_BC_XLA_EVENTS_GT

Line 309: DELETE from psa_bc_xla_events_gt;

305:
306: ----------------------------------------------------------------------
307: -- Bug 5160179: clear the temporary gt table before inserting any rows
308: ----------------------------------------------------------------------
309: DELETE from psa_bc_xla_events_gt;
310: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
311: DELETE from xla_acct_prog_events_gt;
312: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
313: DELETE from xla_ae_headers_gt;

Line 310: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

306: ----------------------------------------------------------------------
307: -- Bug 5160179: clear the temporary gt table before inserting any rows
308: ----------------------------------------------------------------------
309: DELETE from psa_bc_xla_events_gt;
310: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
311: DELETE from xla_acct_prog_events_gt;
312: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
313: DELETE from xla_ae_headers_gt;
314: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_ae_headers_gt: ' || SQL%ROWCOUNT);

Line 670: INSERT into psa_bc_xla_events_gt(event_id,result_code)

666:
667: FOR i IN 1..l_bc_event_count LOOP
668:
669: psa_utils.debug_other_string(g_state_level,l_api_name,'Loop Index i = '||i||' Event id = '||l_bc_event_tab(i).event_id);
670: INSERT into psa_bc_xla_events_gt(event_id,result_code)
671: VALUES (l_bc_event_tab(i).event_id,'XLA_UNPROCESSED');
672: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows inserted in psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
673: END LOOP;
674:

Line 672: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows inserted in psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

668:
669: psa_utils.debug_other_string(g_state_level,l_api_name,'Loop Index i = '||i||' Event id = '||l_bc_event_tab(i).event_id);
670: INSERT into psa_bc_xla_events_gt(event_id,result_code)
671: VALUES (l_bc_event_tab(i).event_id,'XLA_UNPROCESSED');
672: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows inserted in psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
673: END LOOP;
674:
675: -- Checking for if prepay and non-prepay distributions are sharing the same bc event BEGIN
676: -- AP poupulates the distributions for only one invoice at a time

Line 773: FROM psa_bc_xla_events_gt e,

769: SELECT decode(min(p.status_code),'A', 'S', 'F'),
770: min(p.status_code)
771: INTO p_tab_fc_dist(i).result_code,
772: p_tab_fc_dist(i).status_code
773: FROM psa_bc_xla_events_gt e,
774: gl_bc_packets p,
775: xla_distribution_links xdl,
776: ap_prepay_app_dists apad
777: WHERE xdl.event_id = e.event_id

Line 796: FROM psa_bc_xla_events_gt e,

792: SELECT decode(min(p.status_code),'A', 'S', 'F'),
793: min(p.status_code)
794: INTO p_tab_fc_dist(i).result_code,
795: p_tab_fc_dist(i).status_code
796: FROM psa_bc_xla_events_gt e,
797: gl_bc_packets p,
798: xla_distribution_links xdl
799: WHERE xdl.event_id = e.event_id
800: AND xdl.source_distribution_id_num_1 = p_tab_fc_dist(i).inv_distribution_id

Line 937: psa_bc_xla_events_gt e

933: FROM gl_lookups l
934: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
935: AND EXISTS ( SELECT 'x'
936: FROM gl_bc_packets bc,
937: psa_bc_xla_events_gt e
938: WHERE bc.event_id = e.event_id
939: AND bc.result_code like 'F%'
940: AND bc.result_code = l.lookup_code
941: )