APPS.PSA_FUNDS_CHECKER_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 9408: xla_distribution_links IN xla_distribution_links_table) IS

9404: PROCEDURE debug_xla_insert ( xla_events IN xla_events_table ,
9405: xla_validation_lines IN xla_validation_lines_table ,
9406: xla_ae_lines IN xla_ae_lines_table ,
9407: xla_ae_headers IN xla_ae_headers_table ,
9408: xla_distribution_links IN xla_distribution_links_table) IS
9409:
9410: PRAGMA autonomous_transaction;
9411: i NUMBER;
9412:

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

9428: INSERT INTO psa_xla_ae_headers_logs
9429: VALUES xla_ae_headers(i);
9430:
9431:
9432: FORALL i IN 1 .. xla_distribution_links.count
9433: INSERT INTO psa_xla_dist_links_logs
9434: VALUES xla_distribution_links(i);
9435: COMMIT;
9436:

Line 9434: VALUES xla_distribution_links(i);

9430:
9431:
9432: FORALL i IN 1 .. xla_distribution_links.count
9433: INSERT INTO psa_xla_dist_links_logs
9434: VALUES xla_distribution_links(i);
9435: COMMIT;
9436:
9437: END debug_xla_insert ;
9438:

Line 9454: l_xla_distribution_links xla_distribution_links_table;

9450: l_xla_events xla_events_table;
9451: l_xla_validation_lines xla_validation_lines_table;
9452: l_xla_ae_lines xla_ae_lines_table;
9453: l_xla_ae_headers xla_ae_headers_table;
9454: l_xla_distribution_links xla_distribution_links_table;
9455:
9456: BEGIN
9457:
9458: IF g_xla_debug THEN

Line 9646: BULK COLLECT INTO l_xla_distribution_links

9642: applied_to_dist_id_char_4,
9643: applied_to_dist_id_char_5,
9644: phase,
9645: sysdate
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)

Line 9647: FROM xla_distribution_links d

9643: applied_to_dist_id_char_5,
9644: phase,
9645: sysdate
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)

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

9652: and application_id = psa_bc_xla_pvt.g_application_id;
9653:
9654:
9655:
9656: DEBUG_XLA_INSERT ( l_xla_events, l_xla_validation_lines, l_xla_ae_lines, l_xla_ae_headers , l_xla_distribution_links);
9657:
9658: ELSE
9659: return;
9660: