DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 9222: xla_distribution_links IN xla_distribution_links_table) IS

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:

Line 9246: FORALL i IN 1 .. xla_distribution_links.count

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:

Line 9248: VALUES xla_distribution_links(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:
9251: END debug_xla_insert ;
9252:

Line 9268: l_xla_distribution_links xla_distribution_links_table;

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

Line 9460: BULK COLLECT INTO l_xla_distribution_links

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:

Line 9461: FROM xla_distribution_links

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:

Line 9467: DEBUG_XLA_INSERT ( l_xla_events, l_xla_validation_lines, l_xla_ae_lines, l_xla_ae_headers , l_xla_distribution_links);

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: