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.XLA_THIRD_PARTY_MERGE dependencies on XLA_AE_HEADERS

Line 1508: INSERT INTO xla_ae_headers

1504: trace( p_msg => 'BEGIN - ' || v_function
1505: , p_level => C_LEVEL_PROCEDURE
1506: , p_module => v_module);
1507: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
1508: INSERT INTO xla_ae_headers
1509: (
1510: ae_header_id
1511: , application_id
1512: , ledger_id

Line 1591: FROM xla_ae_headers_gt hed;

1587: , hed.parent_header_id -- 4262811
1588: , hed.parent_ae_line_num -- 4262811
1589: , hed.accrual_reversal_flag -- 4262811
1590: , p_event_id
1591: FROM xla_ae_headers_gt hed;
1592:
1593: IF (C_LEVEL_PROCEDURE >= g_log_level)
1594: THEN
1595: trace( p_msg => 'END - ' || v_function

Line 2481: FROM xla_ae_headers aeh

2477: p_request_id
2478: ,ae_header_id
2479: ,p_event_id
2480: ,'B'
2481: FROM xla_ae_headers aeh
2482: WHERE aeh.BALANCE_TYPE_CODE = 'A'
2483: AND aeh.LEDGER_ID = p_array_ledger_id(i)
2484: AND aeh.ACCOUNTING_DATE <= p_merge_date
2485: AND aeh.ACCOUNTING_ENTRY_STATUS_CODE IN ('F','N')

Line 2523: FROM xla_ae_headers aeh

2519: p_request_id
2520: ,ae_header_id
2521: ,p_event_id
2522: ,'R'
2523: FROM xla_ae_headers aeh
2524: WHERE aeh.BALANCE_TYPE_CODE = 'A'
2525: AND aeh.APPLICATION_ID = p_application_id
2526: AND aeh.LEDGER_ID = p_array_ledger_id(i)
2527: AND aeh.ACCOUNTING_DATE > p_merge_date

Line 2564: FROM xla_ae_headers aeh

2560: p_request_id
2561: ,ae_header_id
2562: ,p_event_id
2563: ,'B'
2564: FROM xla_ae_headers aeh
2565: WHERE aeh.BALANCE_TYPE_CODE = 'A'
2566: AND aeh.APPLICATION_ID = p_application_id
2567: AND aeh.LEDGER_ID = p_array_ledger_id(i)
2568: AND aeh.ACCOUNTING_DATE <= p_merge_date

Line 2602: FROM xla_ae_headers aeh

2598: p_request_id
2599: ,ae_header_id
2600: ,p_event_id
2601: ,'R'
2602: FROM xla_ae_headers aeh
2603: WHERE aeh.BALANCE_TYPE_CODE = 'A'
2604: AND aeh.APPLICATION_ID = p_application_id
2605: AND aeh.LEDGER_ID = p_array_ledger_id(i)
2606: AND aeh.ACCOUNTING_DATE > p_merge_date

Line 2796: ,xla_ae_headers aeh

2792: ,decode(ael.control_balance_flag, 'Y', 'P', 'P', 'P', null)
2793: ,ael.encumbrance_type_id
2794: FROM
2795: xla_ae_lines ael
2796: ,xla_ae_headers aeh
2797: ,xla_distribution_links xdl
2798: ,fnd_currencies fcu
2799: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2800: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)

Line 2962: ,xla_ae_headers aeh

2958: ,decode(ael.control_balance_flag, 'Y', 'P', 'P', 'P', null)
2959: ,ael.encumbrance_type_id
2960: FROM
2961: xla_ae_lines ael
2962: ,xla_ae_headers aeh
2963: ,xla_distribution_links xdl
2964: ,fnd_currencies fcu
2965: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2966: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)

Line 3046: INSERT INTO xla_ae_headers_gt

3042: , p_module => v_module);
3043: END IF;
3044:
3045: FORALL i in 1 .. p_array_ledger_id.count
3046: INSERT INTO xla_ae_headers_gt
3047: ( ae_header_id
3048: , accounting_entry_status_code
3049: , accounting_entry_type_code
3050: , ledger_id

Line 3063: select xla_ae_headers_s.nextval

3059: , amb_context_code
3060: , gl_transfer_status_code
3061: , je_category_name
3062: )
3063: select xla_ae_headers_s.nextval
3064: ,decode(p_accounting_mode, 'D', 'D', v_gl_entry_status(i))
3065: ,'MERGE'
3066: ,p_array_ledger_id(i)
3067: ,p_entity_id

Line 3093: from xla_ae_headers_gt xah

3089:
3090: UPDATE xla_ae_lines_gt xal
3091: set (ae_header_id, accounting_date) =(
3092: select ae_header_id, accounting_date
3093: from xla_ae_headers_gt xah
3094: where xah.ledger_id = xal.ledger_id);
3095: END IF;
3096:
3097: -- this is not needed since it is called in the caller procedure.

Line 3290: ,xla_ae_headers aeh

3286: ,decode(ael.control_balance_flag, 'Y', 'P', 'P', 'P', null)
3287: ,ael.encumbrance_type_id
3288: FROM
3289: xla_ae_lines ael
3290: ,xla_ae_headers aeh
3291: ,xla_distribution_links xdl
3292: ,fnd_currencies fcu
3293: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3294: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)

Line 3476: ,xla_ae_headers aeh

3472: ,decode(ael.control_balance_flag, 'Y', 'P', 'P', 'P', null)
3473: ,ael.encumbrance_type_id
3474: FROM
3475: xla_ae_lines ael
3476: ,xla_ae_headers aeh
3477: ,xla_distribution_links xdl
3478: ,fnd_currencies fcu
3479: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3480: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)

Line 3733: ,xla_ae_headers xah

3729: WHERE xal.application_id = p_application_id
3730: AND (ae_header_id, ae_line_num) in
3731: (select xlg.ref_ae_header_id, xlg.ref_ae_line_num
3732: from xla_ae_lines_gt xlg
3733: ,xla_ae_headers xah
3734: where xlg.reversal_code in ('REBOOKING', 'TRANSFER_BALANCE')
3735: -- Bug 5103972 MPA / Reversal of incomplete JE
3736: -- should not be stamped with merge party informtion
3737: AND xlg.ref_ae_header_id = xah.ae_header_id

Line 3872: UPDATE XLA_AE_HEADERS aeh

3868: , p_value_1 => p_merge_date);
3869:
3870: IF(p_merge_type = 'PARTIAL_MERGE') THEN
3871: FORALL i IN 1..p_array_ledger_id.count
3872: UPDATE XLA_AE_HEADERS aeh
3873: SET DESCRIPTION
3874: = DECODE(DESCRIPTION
3875: , NULL, v_aeh_desc
3876: , SUBSTRB(DESCRIPTION, 0,

Line 3918: UPDATE XLA_AE_HEADERS aeh

3914: AND pmt.MERGE_EVENT_ID = p_event_id
3915: AND pmt.ENTITY_ID = aeh.ENTITY_ID);
3916: ELSE
3917: FORALL i IN 1..p_array_ledger_id.count
3918: UPDATE XLA_AE_HEADERS aeh
3919: SET DESCRIPTION
3920: = DECODE(DESCRIPTION
3921: , NULL, v_aeh_desc
3922: , SUBSTRB(DESCRIPTION, 0,

Line 4017: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt

4013: OR ael.PARTY_SITE_ID = p_old_site_id)
4014: AND ael.PARTY_TYPE_CODE = p_party_type
4015: AND EXISTS
4016: (SELECT 'X'
4017: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4018: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4019: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4020: AND aeh.APPLICATION_ID = p_application_id
4021: AND aeh.accounting_entry_status_code = 'F'

Line 4032: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt

4028: --
4029: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4030: --
4031: SELECT 'X'
4032: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4033: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4034: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4035: AND aeh.APPLICATION_ID = p_application_id
4036: AND aeh.accounting_entry_status_code = 'N'

Line 4070: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt

4066: OR tb.PARTY_SITE_ID = p_old_site_id)
4067: AND tb.PARTY_TYPE_CODE = p_party_type
4068: AND EXISTS
4069: (SELECT 'X'
4070: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4071: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4072: AND aeh.APPLICATION_ID = p_application_id
4073: AND aeh.LEDGER_ID = p_array_ledger_id(i)
4074: AND aeh.accounting_entry_status_code = 'F'

Line 4084: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt

4080: --
4081: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4082: --
4083: SELECT 'X'
4084: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4085: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4086: AND aeh.APPLICATION_ID = p_application_id
4087: AND aeh.LEDGER_ID = p_array_ledger_id(i)
4088: AND aeh.parent_ae_header_id IS NOT NULL

Line 4126: FROM XLA_AE_HEADERS aeh

4122: OR ael.PARTY_SITE_ID = p_old_site_id)
4123: AND ael.PARTY_TYPE_CODE = p_party_type
4124: AND EXISTS
4125: (SELECT 'X'
4126: FROM XLA_AE_HEADERS aeh
4127: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4128: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4129: AND aeh.APPLICATION_ID = p_application_id
4130: AND aeh.accounting_entry_status_code = 'F'

Line 4138: FROM XLA_AE_HEADERS aeh

4134: --
4135: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4136: --
4137: SELECT 'X'
4138: FROM XLA_AE_HEADERS aeh
4139: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4140: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4141: AND aeh.APPLICATION_ID = p_application_id
4142: AND aeh.LEDGER_ID = p_array_ledger_id(i)

Line 4173: FROM XLA_AE_HEADERS aeh

4169: OR tb.PARTY_SITE_ID = p_old_site_id)
4170: AND tb.PARTY_TYPE_CODE = p_party_type
4171: AND EXISTS
4172: (SELECT 'X'
4173: FROM XLA_AE_HEADERS aeh
4174: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4175: AND aeh.APPLICATION_ID = p_application_id
4176: AND aeh.accounting_entry_status_code = 'F'
4177: AND aeh.LEDGER_ID = p_array_ledger_id(i)

Line 4184: FROM XLA_AE_HEADERS aeh

4180: --
4181: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4182: --
4183: SELECT 'X'
4184: FROM XLA_AE_HEADERS aeh
4185: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4186: AND aeh.APPLICATION_ID = p_application_id
4187: AND aeh.accounting_entry_status_code = 'N'
4188: AND aeh.LEDGER_ID = p_array_ledger_id(i)

Line 4667: ,xla_ae_headers aeh

4663: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4664: FROM xla_merge_seg_maps map
4665: ,gl_code_combinations gcc
4666: ,xla_ae_lines ael
4667: ,xla_ae_headers aeh
4668: ,XLA_PARTIAL_MERGE_TXNS xpmt
4669: ,XLA_LEDGER_RELATIONSHIPS_V rs
4670: ,gl_ledgers gld
4671: WHERE ael.PARTY_ID = p_old_party_id

Line 4817: ,xla_ae_headers aeh

4813: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4814: FROM xla_merge_seg_maps map
4815: ,gl_code_combinations gcc
4816: ,xla_ae_lines ael
4817: ,xla_ae_headers aeh
4818: ,XLA_LEDGER_RELATIONSHIPS_V rs
4819: ,gl_ledgers gld
4820: WHERE ael.PARTY_ID = p_old_party_id
4821: AND (p_old_site_id IS NULL

Line 5013: INSERT INTO xla_ae_headers_gt

5009: , p_level => C_LEVEL_PROCEDURE
5010: , p_module => v_module);
5011: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
5012:
5013: INSERT INTO xla_ae_headers_gt
5014: ( ae_header_id
5015: , accounting_entry_status_code
5016: , accounting_entry_type_code
5017: , GL_TRANSFER_STATUS_CODE

Line 5034: (select xla_ae_headers_s.nextval

5030: -- Used at the end of this procedure to find ae header ids
5031: -- to be stamped on xla_ae_lines_gt
5032: , parent_header_id
5033: )
5034: (select xla_ae_headers_s.nextval
5035: ,p_accounting_mode
5036: ,'MERGE'
5037: ,'N'
5038: ,ledger_id

Line 5062: from xla_ae_headers xah

5058: , xah.description
5059: , xah.balance_type_code
5060: , xal.ae_header_id
5061: , xal.ref_ae_header_id -- 5103972
5062: from xla_ae_headers xah
5063: ,xla_ae_lines_gt xal
5064: where xah.application_id = p_application_id
5065: and xah.ae_header_id =xal.ref_ae_header_id
5066: and xal.reversal_code = 'REBOOKING'));

Line 5075: UPDATE xla_ae_headers_gt xah

5071: , p_level => C_LEVEL_STATEMENT
5072: , p_module => v_module);
5073: END IF;
5074:
5075: UPDATE xla_ae_headers_gt xah
5076: SET (accounting_date, period_name) =
5077: (SELECT start_date, period_name
5078: FROM gl_period_statuses
5079: WHERE ledger_id = xah.ledger_id

Line 5109: FROM xla_ae_headers_gt xah

5105:
5106: UPDATE xla_ae_lines_gt xal
5107: SET (ae_header_id, accounting_date) =
5108: (SELECT ae_header_id, accounting_date
5109: FROM xla_ae_headers_gt xah
5110: WHERE xal.event_id = xah.event_id
5111: AND xal.ledger_id = xah.ledger_id
5112: -- 5103972
5113: -- Without the following line, this SQL fails as one event_id

Line 5904: (SELECT ae_header_id FROM xla_ae_headers

5900:
5901:
5902: DELETE FROM xla_distribution_links
5903: WHERE ae_header_id IN
5904: (SELECT ae_header_id FROM xla_ae_headers
5905: WHERE application_id = p_application_id
5906: AND merge_event_id = p_event_id);
5907:
5908: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5918: (SELECT ae_header_id FROM xla_ae_headers

5914:
5915:
5916: DELETE FROM xla_ae_segment_values
5917: WHERE ae_header_id IN
5918: (SELECT ae_header_id FROM xla_ae_headers
5919: WHERE application_id = p_application_id
5920: AND merge_event_id = p_event_id);
5921:
5922: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5932: (SELECT ae_header_id FROM xla_ae_headers

5928:
5929:
5930: DELETE FROM xla_ae_line_details
5931: WHERE ae_header_id IN
5932: (SELECT ae_header_id FROM xla_ae_headers
5933: WHERE application_id = p_application_id
5934: AND merge_event_id = p_event_id);
5935:
5936: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5945: (SELECT ae_header_id FROM xla_ae_headers

5941: END IF;
5942:
5943: DELETE FROM xla_ae_header_details
5944: WHERE ae_header_id IN
5945: (SELECT ae_header_id FROM xla_ae_headers
5946: WHERE application_id = p_application_id
5947: AND merge_event_id = p_event_id);
5948:
5949: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5959: (SELECT ae_header_id FROM xla_ae_headers

5955:
5956: DELETE FROM xla_ae_lines
5957: WHERE application_id = p_application_id
5958: AND ae_header_id IN
5959: (SELECT ae_header_id FROM xla_ae_headers
5960: WHERE application_id = p_application_id
5961: AND merge_event_id = p_event_id);
5962:
5963: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5970: DELETE FROM xla_ae_headers

5966: ,p_level => C_LEVEL_STATEMENT
5967: ,p_module => l_log_module);
5968: END IF;
5969:
5970: DELETE FROM xla_ae_headers
5971: WHERE application_id = p_application_id
5972: AND merge_event_id = p_event_id;
5973:
5974: IF (C_LEVEL_STATEMENT >= g_log_level) THEN