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 167: FROM xla_ae_headers b

163: CURSOR c_xla_errors IS
164: SELECT 'Y'
165: FROM PSA_BC_XLA_EVENTS_GT a
166: WHERE not exists (SELECT 'x'
167: FROM xla_ae_headers b
168: WHERE b.event_id = a.event_id);
169:
170: -- Cursor c_get_bc_xla_events_gt is used to print data from psa_bc_xla_Events_gt
171: -- as entered by product teams. This is useful for debugging.

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 709: xla_ae_headers xah,

705: cp_source_dist_type VARCHAR2,
706: cp_source_dist_id_num_1 NUMBER) IS
707: SELECT '1'
708: FROM xla_transaction_entities xte,
709: xla_ae_headers xah,
710: xla_distribution_links xdl,
711: xla_events xe
712: WHERE xte.application_id = cp_appl_id
713: AND xte.entity_code = cp_entity_code

Line 729: xla_ae_headers xah,

725: cp_source_id_int_1 NUMBER,
726: cp_r12_live_date DATE) IS
727: SELECT xal.entered_cr, xal.accounted_cr
728: FROM xla_transaction_entities xte,
729: xla_ae_headers xah,
730: xla_ae_lines xal,
731: xla_events xe
732: WHERE xte.application_id = cp_appl_id
733: AND xte.entity_code = cp_entity_code

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);