eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_XLA_PKG dependencies on XLA_EVENTS_INT_GT

Line 115: l_entity_type_code xla_events_int_gt.entity_code%TYPE;

111: RETURN NUMBER
112: IS
113:
114: l_procedure_name CONSTANT VARCHAR2(100) := G_MODULE_NAME || 'CREATE_EVENT';
115: l_entity_type_code xla_events_int_gt.entity_code%TYPE;
116:
117: n_rows_inserted NUMBER; /* into xla_events_int_gt table */
118:
119: l_curr_calling_sequence VARCHAR2(4000);

Line 117: n_rows_inserted NUMBER; /* into xla_events_int_gt table */

113:
114: l_procedure_name CONSTANT VARCHAR2(100) := G_MODULE_NAME || 'CREATE_EVENT';
115: l_entity_type_code xla_events_int_gt.entity_code%TYPE;
116:
117: n_rows_inserted NUMBER; /* into xla_events_int_gt table */
118:
119: l_curr_calling_sequence VARCHAR2(4000);
120: n_hdrs number; -- xxxremove
121: n_lines number; -- xxxremove

Line 191: -- Insert into xla_events_int_gt table. Create_Bulk_Events procedure

187: update_extract_gt('SET_ENTITY_CODES', NULL);
188:
189:
190: ------------------------------------------------------------------------
191: -- Insert into xla_events_int_gt table. Create_Bulk_Events procedure
192: -- of SLA will pickup txn from here and create events. It will
193: -- also update event_id column in this table.
194: -- We'll stamp this event id on gmf_xla_extract_headers.event_id.
195: --

Line 344: DELETE FROM xla_events_int_gt; -- Cleanup for next run

340: update_extract_gt('SET_EVENT_IDS', i.entity_code);
341:
342: END IF;
343:
344: DELETE FROM xla_events_int_gt; -- Cleanup for next run
345:
346: END LOOP; -- Loop for each Entity (i.e., Source/Process Category)
347: /* Bug 5668308 */
348:

Line 406: -- Now delete from xla_events_int_gt table. This table should not contain

402:
403: ---------------------------------------------------------------------
404: -- Clean-up...
405: --
406: -- Now delete from xla_events_int_gt table. This table should not contain
407: -- any rows for next time around. SLA expects this table to contain
408: -- only rows for which events has to be created.
409: -- Verify GT table definitions to decide whether to keep following
410: -- stmt or not.

Line 412: g_log_msg := 'Events creation complete. Deleting ALL rows from table xla_events_int_gt';

408: -- only rows for which events has to be created.
409: -- Verify GT table definitions to decide whether to keep following
410: -- stmt or not.
411: ---------------------------------------------------------------------
412: g_log_msg := 'Events creation complete. Deleting ALL rows from table xla_events_int_gt';
413:
414: print_debug(g_log_msg);
415: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
416: THEN

Line 424: DELETE FROM xla_events_int_gt;

420: message => g_log_msg
421: );
422: END IF;
423:
424: DELETE FROM xla_events_int_gt;
425:
426:
427: ---------------------------------------------------------------------
428: -- Clean-up...

Line 684: FROM xla_events_int_gt egt

680: END IF;
681:
682: UPDATE gmf_xla_extract_headers_gt ehgt
683: SET event_id = (SELECT event_id
684: FROM xla_events_int_gt egt
685: WHERE egt.source_id_int_1 = ehgt.transaction_id
686: AND egt.source_id_int_2 = ehgt.ledger_id
687: AND egt.source_id_int_3 = ehgt.valuation_cost_type_id
688: /* AND egt.source_id_int_4 = ehgt.transaction_source_type_id INVCONV */

Line 751: -- SLA created new table xla_events_int_gt for performance improvements.

747: END IF;
748:
749: --
750: -- Bug 5052850
751: -- SLA created new table xla_events_int_gt for performance improvements.
752: -- So, changed xla_events_int_gt table to xla_events_int_gt table.
753: -- Prereq SLA patch: 4777706
754: --
755: -- RS Bug 5059076 - line_number and event_created_by columns

Line 752: -- So, changed xla_events_int_gt table to xla_events_int_gt table.

748:
749: --
750: -- Bug 5052850
751: -- SLA created new table xla_events_int_gt for performance improvements.
752: -- So, changed xla_events_int_gt table to xla_events_int_gt table.
753: -- Prereq SLA patch: 4777706
754: --
755: -- RS Bug 5059076 - line_number and event_created_by columns
756: -- are not there present in the new _int_gt table

Line 762: INSERT INTO xla_events_int_gt

758: -- bug 11807826, added event type code in the where clause for Lc valuatuion transactions
759: --
760: -- Bug 13043283. Populating source_id_char_2 with source_line_id (rcv_transactions.transaction_id).
761: --
762: INSERT INTO xla_events_int_gt
763: (
764: entity_id
765: , application_id
766: , ledger_id

Line 880: g_log_msg := n_rows_inserted || ' rows inserted into xla_events_int_gt';

876:
877:
878: n_rows_inserted := sql%rowcount;
879:
880: g_log_msg := n_rows_inserted || ' rows inserted into xla_events_int_gt';
881:
882: print_debug(g_log_msg);
883: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
884: THEN

Line 2794: select count(*) into record_count from xla_events_int_gt ;

2790: /* Bug 15949925 No need to call this. Done in pre-processor.
2791:
2792: g_log_msg := 'Deleting Duplicate IPV/ERV xla entries';
2793:
2794: select count(*) into record_count from xla_events_int_gt ;
2795:
2796: g_log_msg := g_log_msg || 'Record count of xla_events_int_gt is ' || record_count ;
2797:
2798: print_debug(g_log_msg);

Line 2796: g_log_msg := g_log_msg || 'Record count of xla_events_int_gt is ' || record_count ;

2792: g_log_msg := 'Deleting Duplicate IPV/ERV xla entries';
2793:
2794: select count(*) into record_count from xla_events_int_gt ;
2795:
2796: g_log_msg := g_log_msg || 'Record count of xla_events_int_gt is ' || record_count ;
2797:
2798: print_debug(g_log_msg);
2799:
2800: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )

Line 4595: INSERT INTO xla_events_int_gt

4591: message => g_log_msg
4592: );
4593: END IF;
4594:
4595: INSERT INTO xla_events_int_gt
4596: (
4597: entity_id
4598: ,application_id
4599: ,ledger_id

Line 4663: select count(*) into record_count from xla_events_int_gt ;

4659: and EVENT_TYPE_CODE = 'COSTREVAL' )
4660: ;
4661:
4662:
4663: select count(*) into record_count from xla_events_int_gt ;
4664:
4665: g_log_msg := 'Record count of xla_events_int_gt is ' || record_count ;
4666:
4667: print_debug(g_log_msg);

Line 4665: g_log_msg := 'Record count of xla_events_int_gt is ' || record_count ;

4661:
4662:
4663: select count(*) into record_count from xla_events_int_gt ;
4664:
4665: g_log_msg := 'Record count of xla_events_int_gt is ' || record_count ;
4666:
4667: print_debug(g_log_msg);
4668: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL )
4669: THEN

Line 4679: delete from xla_events_int_gt ;

4675: END IF;
4676:
4677: IF record_count > 0 THEN
4678: xla_events_pkg.delete_bulk_events( p_application_id => 555);
4679: delete from xla_events_int_gt ;
4680: END IF;
4681:
4682: g_log_msg := 'End of procedure GMF_XLA_PKG.delete_IPV_ERV_DUP_RECORDS ' ;
4683: print_debug(g_log_msg);

Line 4756: INSERT INTO xla_events_int_gt

4752: FOR l_event IN chk_orphan_lot_cost_adj_events LOOP
4753:
4754: l_event_count := l_event_count + 1;
4755:
4756: INSERT INTO xla_events_int_gt
4757: (entity_id
4758: ,application_id
4759: ,ledger_id
4760: ,entity_code

Line 4804: delete from xla_events_int_gt ;

4800: print_debug(g_log_msg);
4801:
4802: xla_events_pkg.delete_bulk_events( p_application_id => 555);
4803:
4804: delete from xla_events_int_gt ;
4805:
4806: END IF;
4807: EXCEPTION
4808: WHEN OTHERS THEN