eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSA_BC_XLA_PVT dependencies on XLA_AE_HEADERS

Line 478: FROM xla_ae_headers b

474: CURSOR c_xla_errors IS
475: SELECT 'Y'
476: FROM PSA_BC_XLA_EVENTS_GT a
477: WHERE not exists (SELECT 'x'
478: FROM xla_ae_headers b
479: WHERE b.event_id = a.event_id);
480:
481: -- Cursor c_get_bc_xla_events_gt is used to print data from psa_bc_xla_Events_gt
482: -- as entered by product teams. This is useful for debugging.

Line 765: DELETE from xla_ae_headers_gt;

761:
762: /* ---- 7460759 ---------------------------------------------------------------------------
763: DELETE from XLA_ACCT_PROG_EVENTS_GT;
764: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );
765: DELETE from xla_ae_headers_gt;
766: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
767: DELETE from xla_ae_lines_gt;
768: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
769: DELETE from xla_validation_lines_gt;

Line 766: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);

762: /* ---- 7460759 ---------------------------------------------------------------------------
763: DELETE from XLA_ACCT_PROG_EVENTS_GT;
764: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );
765: DELETE from xla_ae_headers_gt;
766: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
767: DELETE from xla_ae_lines_gt;
768: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
769: DELETE from xla_validation_lines_gt;
770: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);

Line 1099: xla_ae_headers xah,

1095: cp_source_dist_type VARCHAR2,
1096: cp_source_dist_id_num_1 NUMBER) IS
1097: SELECT '1'
1098: FROM xla_transaction_entities xte,
1099: xla_ae_headers xah,
1100: xla_distribution_links xdl,
1101: xla_events xe
1102: WHERE xte.application_id = cp_appl_id
1103: AND xte.entity_code = cp_entity_code

Line 1121: xla_ae_headers xah,

1117: cp_source_dist_id_num_1 NUMBER) IS
1118: SELECT NVL(xdl.unrounded_accounted_dr, 0), NVL(xdl.unrounded_accounted_cr, 0),
1119: xe.event_type_code
1120: FROM xla_transaction_entities xte,
1121: xla_ae_headers xah,
1122: xla_events xe,
1123: xla_distribution_links xdl
1124: WHERE xte.application_id = cp_appl_id
1125: AND xte.entity_code = cp_entity_code

Line 1475: DELETE FROM XLA_AE_HEADERS_GT;

1471: BEGIN
1472: l_path_name := g_path_name || '.psa_cleanup_gt';
1473:
1474: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1475: DELETE FROM XLA_AE_HEADERS_GT;
1476: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1477: DELETE FROM XLA_AE_LINES_GT;
1478: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1479: DELETE FROM XLA_VALIDATION_HDRS_GT;

Line 1476: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1472: l_path_name := g_path_name || '.psa_cleanup_gt';
1473:
1474: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1475: DELETE FROM XLA_AE_HEADERS_GT;
1476: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1477: DELETE FROM XLA_AE_LINES_GT;
1478: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1479: DELETE FROM XLA_VALIDATION_HDRS_GT;
1480: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);