APPS.GMF_XLA_PKG dependencies on GMF_XLA_EXTRACT_HEADERS_GT

Line 143: select count(*) into n_hdrs from gmf_xla_extract_headers_gt; -- xxxremove

139: END IF;
140:
141: -- umxla_extract_gt; /* xxxremove */
142:
143: select count(*) into n_hdrs from gmf_xla_extract_headers_gt; -- xxxremove
144: select count(*) into n_lines from gmf_xla_extract_lines_gt; -- xxxremove
145:
146: g_log_msg := n_hdrs || ' rows in hdrs_gt and ' || n_lines || ' rows in lines_gt';
147:

Line 199: FROM gmf_xla_extract_headers_gt

195: -- mapped to Inventory Entity in SLA.
196: --
197: FOR i in (
198: SELECT distinct entity_code
199: FROM gmf_xla_extract_headers_gt
200: )
201: LOOP
202: g_log_msg := 'Calling function GMF_XLA_PKG.insert_into_xla_events_gt for entity ' || i.entity_code ||
203: ' (if entity is Inventory when process was submitted for PUR/OM, then we have some' ||

Line 264: FROM gmf_xla_extract_headers_gt

260: * Following SQL was causing incorrect entity being set on
261: * SLA event and hence unable to query the event.
262: SELECT entity_code
263: INTO l_entity_type_code
264: FROM gmf_xla_extract_headers_gt
265: WHERE rownum = 1
266: ;
267: */
268:

Line 300: -- Update gmf_xla_extract_headers_gt to set event_id

296: END IF;
297:
298:
299: ---------------------------------------------------------------------
300: -- Update gmf_xla_extract_headers_gt to set event_id
301: -- generated by above call. No need to update if n_rows_inserted = 0
302: ---------------------------------------------------------------------
303: IF n_rows_inserted = 0
304: THEN

Line 437: DELETE FROM gmf_xla_extract_headers_gt;

433: message => g_log_msg
434: );
435: END IF;
436:
437: DELETE FROM gmf_xla_extract_headers_gt;
438: DELETE FROM gmf_xla_extract_lines_gt;
439:
440: ---------------------------------------------------------------------
441: -- All done!

Line 545: update gmf_xla_extract_headers_gt ehgt

541: );
542: END IF;
543:
544:
545: update gmf_xla_extract_headers_gt ehgt
546: set (entity_code, event_class_code, event_type_code) =
547: (SELECT entity_code, event_class_code, event_type_code
548: FROM gmf_xla_event_model em
549: WHERE

Line 602: FROM gmf_xla_extract_headers_gt

598: nvl(transfer_type, 'x') as transfer_type,
599: nvl(transfer_price_flag, 'x') as transfer_price_flag,
600: nvl(fob_point, 99) as fob_point,
601: nvl(transaction_type, 'x') as transaction_type
602: FROM gmf_xla_extract_headers_gt
603: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL
604: )
605: LOOP
606:

Line 629: FROM gmf_xla_extract_headers_gt

625: END LOOP;
626:
627: DELETE FROM gmf_xla_extract_lines_gt
628: where header_id in (SELECT header_id
629: FROM gmf_xla_extract_headers_gt
630: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL)
631: ;
632: DELETE FROM gmf_xla_extract_headers_gt
633: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL

Line 632: DELETE FROM gmf_xla_extract_headers_gt

628: where header_id in (SELECT header_id
629: FROM gmf_xla_extract_headers_gt
630: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL)
631: ;
632: DELETE FROM gmf_xla_extract_headers_gt
633: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL
634: ;
635:
636: EXCEPTION

Line 662: UPDATE gmf_xla_extract_headers_gt ehgt

658: message => g_log_msg
659: );
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

Line 830: gmf_xla_extract_headers_gt ehgt

826: , NULL -- SECURITY_ID_CHAR_3
827: , NULL
828: , transaction_date
829: FROM
830: gmf_xla_extract_headers_gt ehgt
831: WHERE
832: entity_code = p_entity_code
833: AND
834: not exists (SELECT 'txns for which events created'

Line 972: FROM gmf_xla_extract_headers_gt) ehgt

968: , accounted_flag
969: , actual_posting_date
970: , invoiced_flag
971: , shipment_costed
972: FROM gmf_xla_extract_headers_gt) ehgt
973: ON ( eh.transaction_id = ehgt.transaction_id
974: AND eh.ledger_id = ehgt.ledger_id
975: AND eh.valuation_cost_type_id = ehgt.valuation_cost_type_id
976: /* AND eh.transaction_source_type_id = ehgt.transaction_source_type_id INVCONV */

Line 1198: gmf_xla_extract_headers_gt ehgt,

1194: SET (header_id, event_id) =
1195: (SELECT
1196: eh.header_id, eh.event_id
1197: FROM
1198: gmf_xla_extract_headers_gt ehgt,
1199: gmf_xla_extract_headers eh
1200: WHERE
1201: ehgt.header_id = elgt.header_id
1202: AND eh.legal_entity_id = ehgt.legal_entity_id