APPS.GMF_XLA_PKG dependencies on GMF_XLA_EXTRACT_HEADERS_GT

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

146: END IF;
147:
148: -- umxla_extract_gt; /* xxxremove */
149:
150: select count(*) into n_hdrs from gmf_xla_extract_headers_gt; -- xxxremove
151: select count(*) into n_lines from gmf_xla_extract_lines_gt; -- xxxremove
152:
153: g_log_msg := n_hdrs || ' rows in hdrs_gt and ' || n_lines || ' rows in lines_gt';
154:

Line 206: FROM gmf_xla_extract_headers_gt

202: -- mapped to Inventory Entity in SLA.
203: --
204: FOR i in (
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' ||

Line 271: FROM gmf_xla_extract_headers_gt

267: * Following SQL was causing incorrect entity being set on
268: * SLA event and hence unable to query the event.
269: SELECT entity_code
270: INTO l_entity_type_code
271: FROM gmf_xla_extract_headers_gt
272: WHERE rownum = 1
273: ;
274: */
275:

Line 309: -- Update gmf_xla_extract_headers_gt to set event_id

305: END IF;
306:
307:
308: ---------------------------------------------------------------------
309: -- Update gmf_xla_extract_headers_gt to set event_id
310: -- generated by above call. No need to update if n_rows_inserted = 0
311: ---------------------------------------------------------------------
312: IF n_rows_inserted = 0
313: THEN

Line 450: DELETE FROM gmf_xla_extract_headers_gt;

446: /* Bug 12647482. Following delete statements commented because these are transaction persistent tables. The delete
447: happens automatically when the data is commited after processing every 1000 records (profile: GL$COMMIT_COUNT). */
448:
449: /*
450: DELETE FROM gmf_xla_extract_headers_gt;
451: DELETE FROM gmf_xla_extract_lines_gt;
452: */
453: ---------------------------------------------------------------------
454: -- All done!

Line 559: update gmf_xla_extract_headers_gt ehgt

555: );
556: END IF;
557:
558:
559: update gmf_xla_extract_headers_gt ehgt
560: set (entity_code, event_class_code, event_type_code) =
561: (SELECT entity_code, event_class_code, event_type_code
562: FROM gmf_xla_event_model em
563: WHERE

Line 603: FROM gmf_xla_extract_headers_gt

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

Line 648: FROM gmf_xla_extract_headers_gt

644:
645: IF l_cnt_hdr_msg < 0 THEN /* Bug 12647482 */
646: DELETE FROM gmf_xla_extract_lines_gt
647: where header_id in (SELECT header_id
648: FROM gmf_xla_extract_headers_gt
649: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL)
650: ;
651: DELETE FROM gmf_xla_extract_headers_gt
652: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL

Line 651: DELETE FROM gmf_xla_extract_headers_gt

647: where header_id in (SELECT header_id
648: FROM gmf_xla_extract_headers_gt
649: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL)
650: ;
651: DELETE FROM gmf_xla_extract_headers_gt
652: WHERE entity_code IS NULL or event_class_code IS NULL OR event_type_code IS NULL
653: ;
654: END IF;
655:

Line 682: UPDATE gmf_xla_extract_headers_gt ehgt

678: message => g_log_msg
679: );
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

Line 861: gmf_xla_extract_headers_gt ehgt

857: , NULL -- SECURITY_ID_CHAR_3
858: , NULL
859: , transaction_date
860: FROM
861: gmf_xla_extract_headers_gt ehgt
862: WHERE
863: entity_code = p_entity_code
864: AND
865: not exists (SELECT 'txns for which events created'

Line 1003: FROM gmf_xla_extract_headers_gt) ehgt

999: , accounted_flag
1000: , actual_posting_date
1001: , invoiced_flag
1002: , shipment_costed
1003: FROM gmf_xla_extract_headers_gt) ehgt
1004: ON ( eh.transaction_id = ehgt.transaction_id
1005: AND eh.ledger_id = ehgt.ledger_id
1006: AND eh.valuation_cost_type_id = ehgt.valuation_cost_type_id
1007: /* AND eh.transaction_source_type_id = ehgt.transaction_source_type_id INVCONV */

Line 1236: gmf_xla_extract_headers_gt ehgt,

1232: SET (header_id, event_id) =
1233: (SELECT
1234: eh.header_id, eh.event_id
1235: FROM
1236: gmf_xla_extract_headers_gt ehgt,
1237: gmf_xla_extract_headers eh
1238: WHERE
1239: ehgt.header_id = elgt.header_id
1240: AND eh.legal_entity_id = ehgt.legal_entity_id

Line 1441: from gmf_xla_extract_headers_gt

1437: DELETE FROM gmf_transaction_valuation
1438: WHERE (transaction_id, ledger_id, valuation_cost_type_id, event_class_code)
1439: IN (
1440: select transaction_id, ledger_id, valuation_cost_type_id, event_class_code
1441: from gmf_xla_extract_headers_gt
1442: );
1443:
1444: g_log_msg := sql%rowcount || ' previous rows deleted from GVT';
1445: