DBA Data[Home] [Help]

APPS.PSA_BC_XLA_PVT dependencies on XLA_AE_LINES_GT

Line 767: DELETE from xla_ae_lines_gt;

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

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

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);
771: DELETE from xla_evt_class_orders_gt;
772: 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 1477: DELETE FROM XLA_AE_LINES_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);
1481: DELETE FROM XLA_VALIDATION_LINES_GT;

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

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