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_LINES

Line 418: DELETE from xla_ae_lines_gt;

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);
422: DELETE from xla_evt_class_orders_gt;

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

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);
422: DELETE from xla_evt_class_orders_gt;
423: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);

Line 730: xla_ae_lines xal,

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
734: AND xte.source_id_int_1 = cp_source_id_int_1

Line 1075: DELETE FROM XLA_AE_LINES_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);
1079: DELETE FROM XLA_VALIDATION_LINES_GT;

Line 1076: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

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);
1079: DELETE FROM XLA_VALIDATION_LINES_GT;
1080: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);