9218: PROCEDURE debug_xla_insert ( xla_events IN xla_events_table ,
9219: xla_validation_lines IN xla_validation_lines_table ,
9220: xla_ae_lines IN xla_ae_lines_table ,
9221: xla_ae_headers IN xla_ae_headers_table ,
9222: xla_distribution_links IN xla_distribution_links_table) IS
9223:
9224: PRAGMA autonomous_transaction;
9225: i NUMBER;
9226:
9242: INSERT INTO psa_xla_ae_headers_logs
9243: VALUES xla_ae_headers(i);
9244:
9245:
9246: FORALL i IN 1 .. xla_distribution_links.count
9247: INSERT INTO psa_xla_dist_links_logs
9248: VALUES xla_distribution_links(i);
9249: COMMIT;
9250:
9244:
9245:
9246: FORALL i IN 1 .. xla_distribution_links.count
9247: INSERT INTO psa_xla_dist_links_logs
9248: VALUES xla_distribution_links(i);
9249: COMMIT;
9250:
9251: END debug_xla_insert ;
9252:
9264: l_xla_events xla_events_table;
9265: l_xla_validation_lines xla_validation_lines_table;
9266: l_xla_ae_lines xla_ae_lines_table;
9267: l_xla_ae_headers xla_ae_headers_table;
9268: l_xla_distribution_links xla_distribution_links_table;
9269:
9270: BEGIN
9271:
9272: IF g_xla_debug THEN
9456: applied_to_dist_id_char_4,
9457: applied_to_dist_id_char_5,
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:
9457: applied_to_dist_id_char_5,
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:
9463: and application_id = psa_bc_xla_pvt.g_application_id;
9464:
9465:
9466:
9467: DEBUG_XLA_INSERT ( l_xla_events, l_xla_validation_lines, l_xla_ae_lines, l_xla_ae_headers , l_xla_distribution_links);
9468:
9469: ELSE
9470: return;
9471: