APPS.PSA_BC_XLA_PVT dependencies on XLA_ACCT_PROG_EVENTS_GT

Line 757: -- clear the XLA_ACCT_PROG_EVENTS_GT table before inserting any rows

753:
754:
755:
756: ----------------------------------------------------------------------
757: -- clear the XLA_ACCT_PROG_EVENTS_GT table before inserting any rows
758: ----------------------------------------------------------------------
759:
760: psa_cleanup_gt;
761:

Line 763: DELETE from XLA_ACCT_PROG_EVENTS_GT;

759:
760: psa_cleanup_gt;
761:
762: /* ---- 7460759 ---------------------------------------------------------------------------
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;

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

760: psa_cleanup_gt;
761:
762: /* ---- 7460759 ---------------------------------------------------------------------------
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);

Line 783: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)

779:
780: -- Insert rows to XLA Events GT table and Call Accounting Engine
781: -----------------------------------------------------------------
782:
783: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
784: SELECT event_id FROM psa_bc_xla_events_gt;
785: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in inserted into XLA_ACCT_PROG_EVENTS_GT table: ' || SQL%ROWCOUNT );
786:
787: l_accounting_events := TRUE;

Line 785: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in inserted into XLA_ACCT_PROG_EVENTS_GT table: ' || SQL%ROWCOUNT );

781: -----------------------------------------------------------------
782:
783: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
784: SELECT event_id FROM psa_bc_xla_events_gt;
785: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in inserted into XLA_ACCT_PROG_EVENTS_GT table: ' || SQL%ROWCOUNT );
786:
787: l_accounting_events := TRUE;
788: l_accounting_batch_id := NULL;
789: l_errbuf := NULL;

Line 1521: DELETE FROM XLA_ACCT_PROG_EVENTS_GT; psa_utils.debug_other_string(g_state_level,l_path_name, '24 XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1517: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1518: psa_utils.debug_other_string(g_state_level,l_path_name, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1519: DELETE FROM XLA_TRIAL_BALANCES_GT;
1520: psa_utils.debug_other_string(g_state_level,l_path_name, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1521: DELETE FROM XLA_ACCT_PROG_EVENTS_GT; psa_utils.debug_other_string(g_state_level,l_path_name, '24 XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1522: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1523: psa_utils.debug_other_string(g_state_level,l_path_name, '25 XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1524: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1525: psa_utils.debug_other_string(g_state_level,l_path_name, '26 XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);