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

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 209: g_log_msg := 'Calling function GMF_XLA_PKG.insert_into_xla_events_gt for entity ' || i.entity_code ||

205: SELECT distinct entity_code
206: FROM gmf_xla_extract_headers_gt
207: )
208: LOOP
209: g_log_msg := 'Calling function GMF_XLA_PKG.insert_into_xla_events_gt for entity ' || i.entity_code ||
210: ' (if entity is Inventory when process was submitted for PUR/OM, then we have some' ||
211: ' internal order transfers)';
212:
213: print_debug(g_log_msg);

Line 224: n_rows_inserted := insert_into_xla_events_gt(i.entity_code);

220: );
221: END IF;
222:
223: -- Bug 5668308: sending entity_code as parameter
224: n_rows_inserted := insert_into_xla_events_gt(i.entity_code);
225:
226: ---------------------------------------------------------------------
227: -- Now create events by calling xla_events_pkg.create_bulk_events
228: -- only when there are any events to create.

Line 227: -- Now create events by calling xla_events_pkg.create_bulk_events

223: -- Bug 5668308: sending entity_code as parameter
224: n_rows_inserted := insert_into_xla_events_gt(i.entity_code);
225:
226: ---------------------------------------------------------------------
227: -- Now create events by calling xla_events_pkg.create_bulk_events
228: -- only when there are any events to create.
229: ---------------------------------------------------------------------
230: IF n_rows_inserted = 0
231: THEN

Line 251: g_log_msg := 'Calling proc XLA_EVENTS_PKG.create_bulk_events for entity ' || i.entity_code;

247: --
248: -- We've events to create
249: --
250:
251: g_log_msg := 'Calling proc XLA_EVENTS_PKG.create_bulk_events for entity ' || i.entity_code;
252:
253: print_debug(g_log_msg);
254: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
255: THEN

Line 277: xla_events_pub_pkg.create_bulk_events

273: ;
274: */
275:
276:
277: xla_events_pub_pkg.create_bulk_events
278: (
279: p_source_application_id => NULL
280: , p_application_id => 555
281: , p_legal_entity_id => p_legal_entity_id

Line 288: select count(*) into n_events from xla_events

284: , p_entity_type_code => i.entity_code
285: );
286:
287: /*Bug 12931836 - Commented this (for performance improvement)
288: select count(*) into n_events from xla_events
289: where application_id = 555
290: and reference_num_1 = p_reference_no; -- xxxremove
291: */
292:

Line 327: g_log_msg := 'Calling proc XLA_EVENTS_PKG.update_extract_gt to set event ids for entity ' || i.entity_code;

323: );
324: END IF;
325:
326: ELSE
327: g_log_msg := 'Calling proc XLA_EVENTS_PKG.update_extract_gt to set event ids for entity ' || i.entity_code;
328:
329: print_debug(g_log_msg);
330: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
331: THEN

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 370: g_log_msg := 'Calling proc XLA_EVENTS_PKG.update_extract_lines';

366:
367: ---------------------------------------------------------------------
368: -- Now insert/update gmf_xla_extract_headers to set event_id
369: ---------------------------------------------------------------------
370: g_log_msg := 'Calling proc XLA_EVENTS_PKG.update_extract_lines';
371:
372: print_debug(g_log_msg);
373: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
374: THEN

Line 388: g_log_msg := 'Calling proc XLA_EVENTS_PKG.merge_into_gtv';

384:
385: ---------------------------------------------------------------------
386: -- Now merge rows into gmf_transaction_valuation table.
387: ---------------------------------------------------------------------
388: g_log_msg := 'Calling proc XLA_EVENTS_PKG.merge_into_gtv';
389:
390: print_debug(g_log_msg);
391: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
392: THEN

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 728: FUNCTION insert_into_xla_events_gt (p_entity_code IN VARCHAR2)

724:
725: END update_extract_gt;
726:
727: /* Bug 5668308: Added p_entity_code parameter */
728: FUNCTION insert_into_xla_events_gt (p_entity_code IN VARCHAR2)
729: RETURN NUMBER
730: IS
731:
732: l_procedure_name CONSTANT VARCHAR2(100) := g_module_name || 'INSERT_INTO_XLA_EVENTS_GT';

Line 732: l_procedure_name CONSTANT VARCHAR2(100) := g_module_name || 'INSERT_INTO_XLA_EVENTS_GT';

728: FUNCTION insert_into_xla_events_gt (p_entity_code IN VARCHAR2)
729: RETURN NUMBER
730: IS
731:
732: l_procedure_name CONSTANT VARCHAR2(100) := g_module_name || 'INSERT_INTO_XLA_EVENTS_GT';
733: n_rows_inserted NUMBER;
734:
735: BEGIN
736:

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 837: , xla_events_pub_pkg.C_EVENT_UNPROCESSED -- event_status_code

833: , event_class_code
834: , event_type_code
835: , NULL -- event_number
836: , transaction_date -- event_date
837: , xla_events_pub_pkg.C_EVENT_UNPROCESSED -- event_status_code
838: , NULL -- process_status_code
839: , reference_no -- REFERENCE_NUM_1
840: , NULL -- REFERENCE_NUM_2
841: , NULL -- REFERENCE_NUM_3

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 906: END insert_into_xla_events_gt;

902: END IF;
903:
904: RETURN n_rows_inserted;
905:
906: END insert_into_xla_events_gt;
907:
908: PROCEDURE update_extract_headers_table
909: IS
910:

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 4611: FROM xla_events xe, xla_ae_headers xah

4607: ,xah.ledger_id
4608: ,'PURCHASING'
4609: ,xe.event_status_code
4610: ,xe.event_id
4611: FROM xla_events xe, xla_ae_headers xah
4612: WHERE xe.application_id = 555
4613: AND xah.application_id = 555
4614: AND xe.event_id not in ( select event_id from gmf_xla_extract_headers where EVENT_TYPE_CODE in ('INVOICE_IPV_ADJ' , 'INVOICE_ERV_ADJ' ) )
4615: AND xe.event_type_code in ('INVOICE_IPV_ADJ' , 'INVOICE_ERV_ADJ' )

Line 4628: FROM xla_events xe, xla_ae_headers xah

4624: ,xah.ledger_id
4625: ,'REVALUATION'
4626: ,xe.event_status_code
4627: ,xe.event_id
4628: FROM xla_events xe, xla_ae_headers xah
4629: WHERE xe.application_id = 555
4630: AND xah.application_id = 555
4631: AND xe.event_type_code = 'ACTCOSTADJ'
4632: AND xe.event_status_code = 'N'

Line 4648: FROM xla_events xe, xla_ae_headers xah

4644: ,xah.ledger_id
4645: ,'REVALUATION'
4646: ,xe.event_status_code
4647: ,xe.event_id
4648: FROM xla_events xe, xla_ae_headers xah
4649: WHERE xe.application_id = 555
4650: AND xah.application_id = 555
4651: AND xe.event_type_code = 'COSTREVAL'
4652: AND xe.event_status_code = 'N'

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 4678: xla_events_pkg.delete_bulk_events( p_application_id => 555);

4674: );
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 ' ;

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 4771: FROM xla_events xe

4767: ,p_ledger_id
4768: ,'REVALUATION'
4769: ,xe.event_status_code
4770: ,xe.event_id
4771: FROM xla_events xe
4772: WHERE xe.application_id = 555
4773: AND xe.event_id = l_event.event_id
4774: AND xe.event_type_code = 'LOTCOSTADJ';
4775:

Line 4802: xla_events_pkg.delete_bulk_events( p_application_id => 555);

4798:
4799: g_log_msg := 'deleting orphan Lot cost adjustment events event count = '||l_event_count;
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;

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