APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_AE_HEADERS_GT

Line 1605: FROM xla_ae_headers_gt hed;

1601: , hed.parent_header_id -- 4262811
1602: , hed.parent_ae_line_num -- 4262811
1603: , hed.accrual_reversal_flag -- 4262811
1604: , p_event_id
1605: FROM xla_ae_headers_gt hed;
1606:
1607: IF (C_LEVEL_PROCEDURE >= g_log_level)
1608: THEN
1609: trace( p_msg => 'END - ' || v_function

Line 3064: INSERT INTO xla_ae_headers_gt

3060: , p_module => v_module);
3061: END IF;
3062:
3063: FORALL i in 1 .. p_array_ledger_id.count
3064: INSERT INTO xla_ae_headers_gt
3065: ( ae_header_id
3066: , accounting_entry_status_code
3067: , accounting_entry_type_code
3068: , ledger_id

Line 3111: from xla_ae_headers_gt xah

3107:
3108: UPDATE xla_ae_lines_gt xal
3109: set (ae_header_id, accounting_date) =(
3110: select ae_header_id, accounting_date
3111: from xla_ae_headers_gt xah
3112: where xah.ledger_id = xal.ledger_id);
3113: END IF;
3114:
3115: -- this is not needed since it is called in the caller procedure.

Line 5058: INSERT INTO xla_ae_headers_gt

5054: , p_level => C_LEVEL_PROCEDURE
5055: , p_module => v_module);
5056: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
5057:
5058: INSERT INTO xla_ae_headers_gt
5059: ( ae_header_id
5060: , accounting_entry_status_code
5061: , accounting_entry_type_code
5062: , GL_TRANSFER_STATUS_CODE

Line 5120: UPDATE xla_ae_headers_gt xah

5116: , p_level => C_LEVEL_STATEMENT
5117: , p_module => v_module);
5118: END IF;
5119:
5120: UPDATE xla_ae_headers_gt xah
5121: SET (accounting_date, period_name) =
5122: (SELECT start_date, period_name
5123: FROM gl_period_statuses
5124: WHERE ledger_id = xah.ledger_id

Line 5154: FROM xla_ae_headers_gt xah

5150:
5151: UPDATE xla_ae_lines_gt xal
5152: SET (ae_header_id, accounting_date) =
5153: (SELECT ae_header_id, accounting_date
5154: FROM xla_ae_headers_gt xah
5155: WHERE xal.event_id = xah.event_id
5156: AND xal.ledger_id = xah.ledger_id
5157: -- 5103972
5158: -- Without the following line, this SQL fails as one event_id