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);
424: */
425: DELETE from psa_option_details_gt;
426: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);
427: DELETE from psa_bc_alloc_gt;
428: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_bc_alloc_gt table before insertion: ' || SQL%ROWCOUNT);
429: ------------------------------------------------------------------------------------- *
430:
431: -- Insert rows to XLA Events GT table and Call Accounting Engine
424: */
425: DELETE from psa_option_details_gt;
426: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);
427: DELETE from psa_bc_alloc_gt;
428: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_bc_alloc_gt table before insertion: ' || SQL%ROWCOUNT);
429: ------------------------------------------------------------------------------------- *
430:
431: -- Insert rows to XLA Events GT table and Call Accounting Engine
432: -----------------------------------------------------------------