119: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
120: debug( '25 XLA_ACCT_PROG_DOCS_GT row count :'||SQL%ROWCOUNT);
121: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
122: debug( '26 XLA_MERGE_SEG_MAPS_GT row count :'||SQL%ROWCOUNT);
123: DELETE FROM XLA_EVENTS_INT_GT;
124: debug( '27 XLA_EVENTS_INT_GT row count :'||SQL%ROWCOUNT);
125: DELETE FROM XLA_REPORT_BALANCES_GT;
126: debug( '28 XLA_REPORT_BALANCES_GT row count :'||SQL%ROWCOUNT);
127: DELETE FROM XLA_TB_BALANCES_GT;
120: debug( '25 XLA_ACCT_PROG_DOCS_GT row count :'||SQL%ROWCOUNT);
121: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
122: debug( '26 XLA_MERGE_SEG_MAPS_GT row count :'||SQL%ROWCOUNT);
123: DELETE FROM XLA_EVENTS_INT_GT;
124: debug( '27 XLA_EVENTS_INT_GT row count :'||SQL%ROWCOUNT);
125: DELETE FROM XLA_REPORT_BALANCES_GT;
126: debug( '28 XLA_REPORT_BALANCES_GT row count :'||SQL%ROWCOUNT);
127: DELETE FROM XLA_TB_BALANCES_GT;
128: debug( '29 XLA_TB_BALANCES_GT row count :'||SQL%ROWCOUNT);
1714: WHERE ORGANIZATION_ID = p_organization_id;
1715:
1716: l_stmt_num := 20;
1717: /* Purge Temp Table */
1718: DELETE XLA_EVENTS_INT_GT;
1719: INSERT INTO xla_events_int_gt(
1720: application_id,
1721: ledger_id,
1722: entity_code,
1715:
1716: l_stmt_num := 20;
1717: /* Purge Temp Table */
1718: DELETE XLA_EVENTS_INT_GT;
1719: INSERT INTO xla_events_int_gt(
1720: application_id,
1721: ledger_id,
1722: entity_code,
1723: source_id_int_1,
1957:
1958: l_stmt_num := 20;
1959:
1960: /* Purge Temp Table */
1961: DELETE XLA_EVENTS_INT_GT;
1962:
1963:
1964: INSERT INTO xla_events_int_gt
1965: (
1960: /* Purge Temp Table */
1961: DELETE XLA_EVENTS_INT_GT;
1962:
1963:
1964: INSERT INTO xla_events_int_gt
1965: (
1966: application_id,
1967: ledger_id,
1968: entity_code,
2181:
2182: l_stmt_num := 20;
2183:
2184: /* Purge Temp Table */
2185: DELETE XLA_EVENTS_INT_GT;
2186:
2187: INSERT INTO xla_events_int_gt
2188: (
2189: application_id,
2183:
2184: /* Purge Temp Table */
2185: DELETE XLA_EVENTS_INT_GT;
2186:
2187: INSERT INTO xla_events_int_gt
2188: (
2189: application_id,
2190: ledger_id,
2191: entity_code,