DBA Data[Home] [Help]

APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_AE_HEADERS

Line 1522: INSERT INTO xla_ae_headers

1518: trace( p_msg => 'BEGIN - ' || v_function
1519: , p_level => C_LEVEL_PROCEDURE
1520: , p_module => v_module);
1521: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
1522: INSERT INTO xla_ae_headers
1523: (
1524: ae_header_id
1525: , application_id
1526: , ledger_id

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 2499: FROM xla_ae_headers aeh

2495: p_request_id
2496: ,ae_header_id
2497: ,p_event_id
2498: ,'B'
2499: FROM xla_ae_headers aeh
2500: WHERE aeh.BALANCE_TYPE_CODE = 'A'
2501: AND aeh.LEDGER_ID = p_array_ledger_id(i)
2502: AND aeh.ACCOUNTING_DATE <= p_merge_date
2503: AND aeh.ACCOUNTING_ENTRY_STATUS_CODE IN ('F','N')

Line 2541: FROM xla_ae_headers aeh

2537: p_request_id
2538: ,ae_header_id
2539: ,p_event_id
2540: ,'R'
2541: FROM xla_ae_headers aeh
2542: WHERE aeh.BALANCE_TYPE_CODE = 'A'
2543: AND aeh.APPLICATION_ID = p_application_id
2544: AND aeh.LEDGER_ID = p_array_ledger_id(i)
2545: AND aeh.ACCOUNTING_DATE > p_merge_date

Line 2582: FROM xla_ae_headers aeh

2578: p_request_id
2579: ,ae_header_id
2580: ,p_event_id
2581: ,'B'
2582: FROM xla_ae_headers aeh
2583: WHERE aeh.BALANCE_TYPE_CODE = 'A'
2584: AND aeh.APPLICATION_ID = p_application_id
2585: AND aeh.LEDGER_ID = p_array_ledger_id(i)
2586: AND aeh.ACCOUNTING_DATE <= p_merge_date

Line 2620: FROM xla_ae_headers aeh

2616: p_request_id
2617: ,ae_header_id
2618: ,p_event_id
2619: ,'R'
2620: FROM xla_ae_headers aeh
2621: WHERE aeh.BALANCE_TYPE_CODE = 'A'
2622: AND aeh.APPLICATION_ID = p_application_id
2623: AND aeh.LEDGER_ID = p_array_ledger_id(i)
2624: AND aeh.ACCOUNTING_DATE > p_merge_date

Line 2814: ,xla_ae_headers aeh

2810: ,decode(ael.control_balance_flag, 'Y', 'P', 'P', 'P', null)
2811: ,ael.encumbrance_type_id
2812: FROM
2813: xla_ae_lines ael
2814: ,xla_ae_headers aeh
2815: ,xla_distribution_links xdl
2816: ,fnd_currencies fcu
2817: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2818: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)

Line 2980: ,xla_ae_headers aeh

2976: ,decode(ael.control_balance_flag, 'Y', 'P', 'P', 'P', null)
2977: ,ael.encumbrance_type_id
2978: FROM
2979: xla_ae_lines ael
2980: ,xla_ae_headers aeh
2981: ,xla_distribution_links xdl
2982: ,fnd_currencies fcu
2983: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2984: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)

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 3081: select xla_ae_headers_s.nextval

3077: , amb_context_code
3078: , gl_transfer_status_code
3079: , je_category_name
3080: )
3081: select xla_ae_headers_s.nextval
3082: ,decode(p_accounting_mode, 'D', 'D', v_gl_entry_status(i))
3083: ,'MERGE'
3084: ,p_array_ledger_id(i)
3085: ,p_entity_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 3308: ,xla_ae_headers aeh

3304: ,decode(ael.control_balance_flag, 'Y', 'P', 'P', 'P', null)
3305: ,ael.encumbrance_type_id
3306: FROM
3307: xla_ae_lines ael
3308: ,xla_ae_headers aeh
3309: ,xla_distribution_links xdl
3310: ,fnd_currencies fcu
3311: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3312: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)

Line 3494: ,xla_ae_headers aeh

3490: ,decode(ael.control_balance_flag, 'Y', 'P', 'P', 'P', null)
3491: ,ael.encumbrance_type_id
3492: FROM
3493: xla_ae_lines ael
3494: ,xla_ae_headers aeh
3495: ,xla_distribution_links xdl
3496: ,fnd_currencies fcu
3497: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3498: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)

Line 3751: ,xla_ae_headers xah

3747: WHERE xal.application_id = p_application_id
3748: AND (ae_header_id, ae_line_num) in
3749: (select xlg.ref_ae_header_id, xlg.ref_ae_line_num
3750: from xla_ae_lines_gt xlg
3751: ,xla_ae_headers xah
3752: where xlg.reversal_code in ('REBOOKING', 'TRANSFER_BALANCE')
3753: -- Bug 5103972 MPA / Reversal of incomplete JE
3754: -- should not be stamped with merge party informtion
3755: AND xlg.ref_ae_header_id = xah.ae_header_id

Line 3917: UPDATE XLA_AE_HEADERS aeh

3913: , p_value_1 => p_merge_date);
3914:
3915: IF(p_merge_type = 'PARTIAL_MERGE') THEN
3916: FORALL i IN 1..p_array_ledger_id.count
3917: UPDATE XLA_AE_HEADERS aeh
3918: SET DESCRIPTION
3919: = DECODE(DESCRIPTION
3920: , NULL, v_aeh_desc
3921: , SUBSTRB(DESCRIPTION, 0,

Line 3963: UPDATE XLA_AE_HEADERS aeh

3959: AND pmt.MERGE_EVENT_ID = p_event_id
3960: AND pmt.ENTITY_ID = aeh.ENTITY_ID);
3961: ELSE
3962: FORALL i IN 1..p_array_ledger_id.count
3963: UPDATE XLA_AE_HEADERS aeh
3964: SET DESCRIPTION
3965: = DECODE(DESCRIPTION
3966: , NULL, v_aeh_desc
3967: , SUBSTRB(DESCRIPTION, 0,

Line 4062: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt

4058: OR ael.PARTY_SITE_ID = p_old_site_id)
4059: AND ael.PARTY_TYPE_CODE = p_party_type
4060: AND EXISTS
4061: (SELECT 'X'
4062: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4063: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4064: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4065: AND aeh.APPLICATION_ID = p_application_id
4066: AND aeh.accounting_entry_status_code = 'F'

Line 4077: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt

4073: --
4074: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4075: --
4076: SELECT 'X'
4077: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4078: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4079: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4080: AND aeh.APPLICATION_ID = p_application_id
4081: AND aeh.accounting_entry_status_code = 'N'

Line 4115: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt

4111: OR tb.PARTY_SITE_ID = p_old_site_id)
4112: AND tb.PARTY_TYPE_CODE = p_party_type
4113: AND EXISTS
4114: (SELECT 'X'
4115: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4116: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4117: AND aeh.APPLICATION_ID = p_application_id
4118: AND aeh.LEDGER_ID = p_array_ledger_id(i)
4119: AND aeh.accounting_entry_status_code = 'F'

Line 4129: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt

4125: --
4126: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4127: --
4128: SELECT 'X'
4129: FROM XLA_AE_HEADERS aeh, XLA_PARTIAL_MERGE_TXNS pmt
4130: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4131: AND aeh.APPLICATION_ID = p_application_id
4132: AND aeh.LEDGER_ID = p_array_ledger_id(i)
4133: AND aeh.parent_ae_header_id IS NOT NULL

Line 4171: FROM XLA_AE_HEADERS aeh

4167: OR ael.PARTY_SITE_ID = p_old_site_id)
4168: AND ael.PARTY_TYPE_CODE = p_party_type
4169: AND EXISTS
4170: (SELECT 'X'
4171: FROM XLA_AE_HEADERS aeh
4172: WHERE ael.APPLICATION_ID = aeh.APPLICATION_ID
4173: AND ael.AE_HEADER_ID = aeh.AE_HEADER_ID
4174: AND aeh.APPLICATION_ID = p_application_id
4175: AND aeh.accounting_entry_status_code = 'F'

Line 4183: FROM XLA_AE_HEADERS aeh

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

Line 4218: FROM XLA_AE_HEADERS aeh

4214: OR tb.PARTY_SITE_ID = p_old_site_id)
4215: AND tb.PARTY_TYPE_CODE = p_party_type
4216: AND EXISTS
4217: (SELECT 'X'
4218: FROM XLA_AE_HEADERS aeh
4219: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4220: AND aeh.APPLICATION_ID = p_application_id
4221: AND aeh.accounting_entry_status_code = 'F'
4222: AND aeh.LEDGER_ID = p_array_ledger_id(i)

Line 4229: FROM XLA_AE_HEADERS aeh

4225: --
4226: -- Incomplete lines from MPA / Accrual Reversal (5090223/5103972)
4227: --
4228: SELECT 'X'
4229: FROM XLA_AE_HEADERS aeh
4230: WHERE tb.AE_HEADER_ID = aeh.AE_HEADER_ID
4231: AND aeh.APPLICATION_ID = p_application_id
4232: AND aeh.accounting_entry_status_code = 'N'
4233: AND aeh.LEDGER_ID = p_array_ledger_id(i)

Line 4712: ,xla_ae_headers aeh

4708: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4709: FROM xla_merge_seg_maps map
4710: ,gl_code_combinations gcc
4711: ,xla_ae_lines ael
4712: ,xla_ae_headers aeh
4713: ,XLA_PARTIAL_MERGE_TXNS xpmt
4714: ,XLA_LEDGER_RELATIONSHIPS_V rs
4715: ,gl_ledgers gld
4716: WHERE ael.PARTY_ID = p_old_party_id

Line 4862: ,xla_ae_headers aeh

4858: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4859: FROM xla_merge_seg_maps map
4860: ,gl_code_combinations gcc
4861: ,xla_ae_lines ael
4862: ,xla_ae_headers aeh
4863: ,XLA_LEDGER_RELATIONSHIPS_V rs
4864: ,gl_ledgers gld
4865: WHERE ael.PARTY_ID = p_old_party_id
4866: AND (p_old_site_id IS NULL

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 5079: (select xla_ae_headers_s.nextval

5075: -- Used at the end of this procedure to find ae header ids
5076: -- to be stamped on xla_ae_lines_gt
5077: , parent_header_id
5078: )
5079: (select xla_ae_headers_s.nextval
5080: ,p_accounting_mode
5081: ,'MERGE'
5082: ,'N'
5083: ,ledger_id

Line 5107: from xla_ae_headers xah

5103: , xah.description
5104: , xah.balance_type_code
5105: , xal.ae_header_id
5106: , xal.ref_ae_header_id -- 5103972
5107: from xla_ae_headers xah
5108: ,xla_ae_lines_gt xal
5109: where xah.application_id = p_application_id
5110: and xah.ae_header_id =xal.ref_ae_header_id
5111: and xal.reversal_code = 'REBOOKING'));

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

Line 6142: (SELECT ae_header_id FROM xla_ae_headers

6138:
6139:
6140: DELETE FROM xla_distribution_links
6141: WHERE ae_header_id IN
6142: (SELECT ae_header_id FROM xla_ae_headers
6143: WHERE application_id = p_application_id
6144: AND merge_event_id = p_event_id);
6145:
6146: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 6156: (SELECT ae_header_id FROM xla_ae_headers

6152:
6153:
6154: DELETE FROM xla_ae_segment_values
6155: WHERE ae_header_id IN
6156: (SELECT ae_header_id FROM xla_ae_headers
6157: WHERE application_id = p_application_id
6158: AND merge_event_id = p_event_id);
6159:
6160: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 6170: (SELECT ae_header_id FROM xla_ae_headers

6166:
6167:
6168: DELETE FROM xla_ae_line_details
6169: WHERE ae_header_id IN
6170: (SELECT ae_header_id FROM xla_ae_headers
6171: WHERE application_id = p_application_id
6172: AND merge_event_id = p_event_id);
6173:
6174: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 6183: (SELECT ae_header_id FROM xla_ae_headers

6179: END IF;
6180:
6181: DELETE FROM xla_ae_header_details
6182: WHERE ae_header_id IN
6183: (SELECT ae_header_id FROM xla_ae_headers
6184: WHERE application_id = p_application_id
6185: AND merge_event_id = p_event_id);
6186:
6187: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 6197: (SELECT ae_header_id FROM xla_ae_headers

6193:
6194: DELETE FROM xla_ae_lines
6195: WHERE application_id = p_application_id
6196: AND ae_header_id IN
6197: (SELECT ae_header_id FROM xla_ae_headers
6198: WHERE application_id = p_application_id
6199: AND merge_event_id = p_event_id);
6200:
6201: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 6208: DELETE FROM xla_ae_headers

6204: ,p_level => C_LEVEL_STATEMENT
6205: ,p_module => l_log_module);
6206: END IF;
6207:
6208: DELETE FROM xla_ae_headers
6209: WHERE application_id = p_application_id
6210: AND merge_event_id = p_event_id;
6211:
6212: IF (C_LEVEL_STATEMENT >= g_log_level) THEN