[Home] [Help]
109: RETURN NUMBER
110: IS
111:
112: l_procedure_name CONSTANT VARCHAR2(100) := G_MODULE_NAME || 'CREATE_EVENT';
113: l_entity_type_code xla_events_int_gt.entity_code%TYPE;
114:
115: n_rows_inserted NUMBER; /* into xla_events_int_gt table */
116:
117: l_curr_calling_sequence VARCHAR2(4000);
111:
112: l_procedure_name CONSTANT VARCHAR2(100) := G_MODULE_NAME || 'CREATE_EVENT';
113: l_entity_type_code xla_events_int_gt.entity_code%TYPE;
114:
115: n_rows_inserted NUMBER; /* into xla_events_int_gt table */
116:
117: l_curr_calling_sequence VARCHAR2(4000);
118: n_hdrs number; -- xxxremove
119: n_lines number; -- xxxremove
180: update_extract_gt('SET_ENTITY_CODES', NULL);
181:
182:
183: ------------------------------------------------------------------------
184: -- Insert into xla_events_int_gt table. Create_Bulk_Events procedure
185: -- of SLA will pickup txn from here and create events. It will
186: -- also update event_id column in this table.
187: -- We'll stamp this event id on gmf_xla_extract_headers.event_id.
188: --
331: update_extract_gt('SET_EVENT_IDS', i.entity_code);
332:
333: END IF;
334:
335: DELETE FROM xla_events_int_gt; -- Cleanup for next run
336:
337: END LOOP; -- Loop for each Entity (i.e., Source/Process Category)
338: /* Bug 5668308 */
339:
393:
394: ---------------------------------------------------------------------
395: -- Clean-up...
396: --
397: -- Now delete from xla_events_int_gt table. This table should not contain
398: -- any rows for next time around. SLA expects this table to contain
399: -- only rows for which events has to be created.
400: -- Verify GT table definitions to decide whether to keep following
401: -- stmt or not.
399: -- only rows for which events has to be created.
400: -- Verify GT table definitions to decide whether to keep following
401: -- stmt or not.
402: ---------------------------------------------------------------------
403: g_log_msg := 'Events creation complete. Deleting ALL rows from table xla_events_int_gt';
404:
405: print_debug(g_log_msg);
406: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
407: THEN
411: message => g_log_msg
412: );
413: END IF;
414:
415: DELETE FROM xla_events_int_gt;
416:
417:
418: ---------------------------------------------------------------------
419: -- Clean-up...
660: END IF;
661:
662: UPDATE gmf_xla_extract_headers_gt ehgt
663: SET event_id = (SELECT event_id
664: FROM xla_events_int_gt egt
665: WHERE egt.source_id_int_1 = ehgt.transaction_id
666: AND egt.source_id_int_2 = ehgt.ledger_id
667: AND egt.source_id_int_3 = ehgt.valuation_cost_type_id
668: /* AND egt.source_id_int_4 = ehgt.transaction_source_type_id INVCONV */
727: END IF;
728:
729: --
730: -- Bug 5052850
731: -- SLA created new table xla_events_int_gt for performance improvements.
732: -- So, changed xla_events_int_gt table to xla_events_int_gt table.
733: -- Prereq SLA patch: 4777706
734: --
735: -- RS Bug 5059076 - line_number and event_created_by columns
728:
729: --
730: -- Bug 5052850
731: -- SLA created new table xla_events_int_gt for performance improvements.
732: -- So, changed xla_events_int_gt table to xla_events_int_gt table.
733: -- Prereq SLA patch: 4777706
734: --
735: -- RS Bug 5059076 - line_number and event_created_by columns
736: -- are not there present in the new _int_gt table
734: --
735: -- RS Bug 5059076 - line_number and event_created_by columns
736: -- are not there present in the new _int_gt table
737: -- Both columns were set to Null before
738: INSERT INTO xla_events_int_gt
739: (
740: entity_id
741: , application_id
742: , ledger_id
845:
846:
847: n_rows_inserted := sql%rowcount;
848:
849: g_log_msg := n_rows_inserted || ' rows inserted into xla_events_int_gt';
850:
851: print_debug(g_log_msg);
852: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
853: THEN