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_GT

Line 416: DELETE from xla_ae_headers_gt;

412:
413: /* ---- 7460759 ---------------------------------------------------------------------------
414: DELETE from XLA_ACCT_PROG_EVENTS_GT;
415: 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 );
416: DELETE from xla_ae_headers_gt;
417: 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);
418: DELETE from xla_ae_lines_gt;
419: 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);
420: DELETE from xla_validation_lines_gt;

Line 417: 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);

413: /* ---- 7460759 ---------------------------------------------------------------------------
414: DELETE from XLA_ACCT_PROG_EVENTS_GT;
415: 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 );
416: DELETE from xla_ae_headers_gt;
417: 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);
418: DELETE from xla_ae_lines_gt;
419: 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);
420: DELETE from xla_validation_lines_gt;
421: 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 1073: DELETE FROM XLA_AE_HEADERS_GT;

1069: BEGIN
1070: l_path_name := g_path_name || '.psa_cleanup_gt';
1071:
1072: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1073: DELETE FROM XLA_AE_HEADERS_GT;
1074: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1075: DELETE FROM XLA_AE_LINES_GT;
1076: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1077: DELETE FROM XLA_VALIDATION_HDRS_GT;

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

1070: l_path_name := g_path_name || '.psa_cleanup_gt';
1071:
1072: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1073: DELETE FROM XLA_AE_HEADERS_GT;
1074: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1075: DELETE FROM XLA_AE_LINES_GT;
1076: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1077: DELETE FROM XLA_VALIDATION_HDRS_GT;
1078: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);