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_JOURNAL_ENTRIES_PKG dependencies on XLA_AE_HEADERS

Line 816: -- Create entry in the xla_ae_headers table

812: ,p_msg_mode => p_msg_mode);
813: END IF;
814:
815: --
816: -- Create entry in the xla_ae_headers table
817: --
818: INSERT INTO xla_ae_headers
819: (ae_header_id
820: ,application_id

Line 818: INSERT INTO xla_ae_headers

814:
815: --
816: -- Create entry in the xla_ae_headers table
817: --
818: INSERT INTO xla_ae_headers
819: (ae_header_id
820: ,application_id
821: ,ledger_id
822: ,entity_id

Line 859: (xla_ae_headers_s.NEXTVAL

855: ,last_update_login
856: ,accrual_reversal_flag -- 4262811
857: )
858: values
859: (xla_ae_headers_s.NEXTVAL
860: ,p_application_id
861: ,p_ledger_id
862: ,l_entity_id
863: ,p_event_id

Line 1088: -- Update xla_ae_headers with modified information

1084: IF l_sla_manual = 0 THEN
1085: undo_draft_entry(l_info);
1086: END IF;
1087: --
1088: -- Update xla_ae_headers with modified information
1089: --
1090: UPDATE xla_ae_headers
1091: SET reference_date = p_reference_date
1092: ,budget_version_id = l_budget_version_id

Line 1090: UPDATE xla_ae_headers

1086: END IF;
1087: --
1088: -- Update xla_ae_headers with modified information
1089: --
1090: UPDATE xla_ae_headers
1091: SET reference_date = p_reference_date
1092: ,budget_version_id = l_budget_version_id
1093: ,accounting_entry_type_code = p_accounting_entry_type_code
1094: ,accounting_entry_status_code = l_status_code

Line 1234: FROM xla_ae_headers h

1230: ,h.accounting_entry_type_code type_code
1231: ,h.funds_status_code funds_status_code
1232: ,h.packet_id packet_id
1233: ,h.entity_id entity_id
1234: FROM xla_ae_headers h
1235: ,xla_transaction_entities e
1236: WHERE e.application_id = p_application_id
1237: AND e.entity_id = h.entity_id
1238: AND h.application_id = p_application_id

Line 1244: FROM xla_ae_headers h

1240: FOR UPDATE NOWAIT;
1241:
1242: CURSOR c_period IS
1243: SELECT 'exist'
1244: FROM xla_ae_headers h
1245: ,gl_period_statuses p
1246: WHERE p.application_id(+) = C_GL_APPLICATION_ID
1247: AND p.ledger_id(+) = h.ledger_id
1248: AND p.adjustment_period_flag(+) = 'N'

Line 1343: FROM xla_ae_headers

1339:
1340: DELETE FROM xla_distribution_links
1341: WHERE application_id = p_application_id
1342: AND ae_header_id IN (SELECT ae_header_id
1343: FROM xla_ae_headers
1344: WHERE application_id = p_application_id
1345: AND event_id = p_event_id);
1346:
1347: IF (l_entry.ae_header_id IS NOT NULL) THEN

Line 1389: DELETE xla_ae_headers

1385: WHERE application_id = p_application_id
1386: AND ae_header_id = l_ae_header_ids(k);
1387:
1388: FORALL k in 1..j
1389: DELETE xla_ae_headers
1390: WHERE application_id = p_application_id
1391: AND ae_header_id = l_ae_header_ids(k);
1392:
1393: END IF;

Line 1773: update xla_ae_headers

1769: ,p_ref_event_id => NULL
1770: ,p_ref_temp_line_num => NULL);
1771:
1772: IF (l_info.status_code <> l_status_code) THEN
1773: update xla_ae_headers
1774: set accounting_entry_status_code = l_status_code
1775: WHERE ae_header_id = p_ae_header_id
1776: AND application_id = p_application_id;
1777: END IF;

Line 2090: UPDATE xla_ae_headers

2086: END IF;
2087: END IF;
2088:
2089: IF (l_info.status_code <> l_status_code) THEN
2090: UPDATE xla_ae_headers
2091: set accounting_entry_status_code = l_status_code
2092: WHERE ae_header_id = p_ae_header_id
2093: AND application_id = l_info.application_id;
2094: END IF;

Line 2165: UPDATE xla_ae_headers

2161: --
2162: undo_draft_entry(l_info);
2163:
2164: IF (l_info.status_code <> l_status_code) THEN
2165: UPDATE xla_ae_headers
2166: set accounting_entry_status_code = l_status_code
2167: WHERE ae_header_id = p_ae_header_id
2168: AND application_id = p_application_id;
2169: END IF;

Line 2646: UPDATE xla_ae_headers

2642: END IF;
2643:
2644:
2645: FORALL i IN 1 .. l_ae_header_ids.COUNT
2646: UPDATE xla_ae_headers
2647: SET accounting_entry_status_code = l_status_codes(i)
2648: ,funds_status_code = p_funds_status_code
2649: ,completion_acct_seq_value = DECODE(l_seq_values(i),-1,NULL,l_seq_values(i))
2650: ,completion_acct_seq_version_id = DECODE(l_seq_version_ids(i),-1,NULL,l_seq_version_ids(i))

Line 3243: FROM xla_ae_headers xah

3239: ,xah.attribute12
3240: ,xah.attribute13
3241: ,xah.attribute14
3242: ,xah.attribute15
3243: FROM xla_ae_headers xah
3244: ,xla_events xe
3245: ,xla_transaction_entities xte
3246: WHERE xte.entity_id = xah.entity_id
3247: AND xte.application_id = xah.application_id

Line 4169: FROM xla_ae_headers xah

4165: ------------------------------------------------------------------------------
4166: /*
4167: CURSOR c_mrc_headers IS
4168: SELECT xah.*
4169: FROM xla_ae_headers xah
4170: , xla_alt_curr_ledgers_v l
4171: WHERE xah.application_id = p_info.application_id
4172: AND xah.event_id = p_orig_event_id
4173: AND xah.ledger_id = l.ledger_id

Line 4179: FROM xla_ae_headers xah

4175: AND l.enabled_flag = 'Y';
4176: */
4177: CURSOR c_mrc_headers IS
4178: SELECT xah.*
4179: FROM xla_ae_headers xah
4180: , xla_ledger_relationships_v l
4181: WHERE xah.application_id = p_info.application_id
4182: AND xah.event_id = p_orig_event_id
4183: AND xah.ledger_id = l.ledger_id

Line 4190: l_accounting_date xla_ae_headers.accounting_date%TYPE;

4186: OR (l.LEDGER_CATEGORY_CODE= 'PRIMARY' AND xah.parent_ae_header_id IS NOT NULL));
4187:
4188: l_log_module VARCHAR2(240);
4189:
4190: l_accounting_date xla_ae_headers.accounting_date%TYPE;
4191:
4192:
4193: BEGIN
4194: IF g_log_enabled THEN

Line 4252: INSERT INTO xla_ae_headers

4248:
4249: --
4250: -- Create a new journal entry header
4251: --
4252: INSERT INTO xla_ae_headers
4253: (ae_header_id
4254: ,application_id
4255: ,ledger_id
4256: ,entity_id

Line 4279: (xla_ae_headers_s.NEXTVAL

4275: ,accrual_reversal_flag -- 5109240
4276: ,parent_ae_header_id
4277: )
4278: values
4279: (xla_ae_headers_s.NEXTVAL
4280: ,l_mrc_header.application_id
4281: ,l_mrc_header.ledger_id
4282: ,p_info.entity_id
4283: ,p_info.event_id

Line 4616: INSERT INTO xla_ae_headers

4612: --
4613: -- Create a new journal entry header
4614: --
4615:
4616: INSERT INTO xla_ae_headers
4617: (ae_header_id
4618: ,application_id
4619: ,ledger_id
4620: ,entity_id

Line 4656: (xla_ae_headers_s.NEXTVAL

4652: ,attribute13
4653: ,attribute14
4654: ,attribute15 )
4655: values
4656: (xla_ae_headers_s.NEXTVAL
4657: ,p_info.application_id
4658: ,p_info.ledger_id
4659: ,l_entity_id
4660: ,p_rev_event_id

Line 5138: p_table_name => 'XLA_AE_HEADERS',

5134: fun_seq.get_sequence_number(
5135: p_context_type => 'LEDGER_AND_CURRENCY',
5136: p_context_value => to_char(p_ledger_id),
5137: p_application_Id => C_XLA_APPLICATION_ID,
5138: p_table_name => 'XLA_AE_HEADERS',
5139: p_event_code => 'COMPLETION',
5140: p_control_attribute_rec => l_control_attributes,
5141: p_control_date_tbl => l_control_dates,
5142: p_suppress_error => 'N',

Line 5484: INSERT INTO xla_ae_headers

5480: p_module => l_log_module,
5481: p_level => C_LEVEL_STATEMENT);
5482: END IF;
5483:
5484: INSERT INTO xla_ae_headers
5485: (ae_header_id
5486: ,application_id
5487: ,amb_context_code
5488: ,ledger_id

Line 5537: values( xla_ae_headers_s.NEXTVAL

5533: ,last_update_date
5534: ,last_updated_by
5535: ,last_update_login
5536: ,accrual_reversal_flag) -- 4262811
5537: values( xla_ae_headers_s.NEXTVAL
5538: ,p_info.application_id
5539: ,p_info.amb_context_code
5540: ,l_mrc_ledger.ledger_id
5541: ,p_info.entity_id

Line 6064: FROM xla_ae_headers h

6060: IS
6061:
6062: CURSOR c_entries IS
6063: SELECT h.ae_header_id
6064: FROM xla_ae_headers h
6065: , xla_ledger_relationships_v l
6066: WHERE h.event_id = p_event_id
6067: AND h.application_id = p_application_id
6068: AND h.ledger_id = l.ledger_id

Line 6146: DELETE xla_ae_headers

6142: WHERE ae_header_id = l_header_ids(j)
6143: AND application_id = p_application_id;
6144:
6145: FORALL j in 1..i
6146: DELETE xla_ae_headers
6147: WHERE ae_header_id = l_header_ids(j)
6148: AND application_id = p_application_id;
6149:
6150: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 8039: FROM xla_ae_headers

8035: -- check that entry exists
8036: -------------------------------------------
8037: SELECT MIN(entity_id), MAX(gl_transfer_status_code)
8038: INTO l_entity_id, l_gl_status
8039: FROM xla_ae_headers
8040: WHERE application_id = p_application_id
8041: AND ae_header_id = p_ae_header_id
8042: AND accounting_entry_status_code = 'F';
8043:

Line 8181: Update XLA_AE_HEADERS

8177: p_level => C_LEVEL_STATEMENT);
8178: END IF;
8179: IF p_item_name in (C_ITEM_HEADER_DESCRIPTION, C_ITEM_REFERENCE_DATE, C_ITEM_GL_DATE) THEN
8180:
8181: Update XLA_AE_HEADERS
8182: SET DESCRIPTION = DECODE(p_item_name, C_ITEM_HEADER_DESCRIPTION, p_value_varchar2, DESCRIPTION)
8183: ,ACCOUNTING_DATE = DECODE(p_item_name, C_ITEM_GL_DATE, p_value_date, ACCOUNTING_DATE)
8184: ,REFERENCE_DATE = DECODE(p_item_name, C_ITEM_REFERENCE_DATE, p_value_date, REFERENCE_DATE)
8185: WHERE application_id = p_application_id

Line 8429: FROM xla_ae_headers xah

8425: ,xal.unrounded_entered_dr
8426: ,xal.unrounded_entered_cr
8427: ,xal.unrounded_accounted_dr
8428: ,xal.unrounded_accounted_cr
8429: FROM xla_ae_headers xah
8430: ,xla_ae_lines xal
8431: WHERE xah.application_id = p_application_id
8432: AND xah.ae_header_id = p_ae_header_id
8433: AND xal.application_id = xah.application_id

Line 8657: FROM xla_ae_headers

8653: -- Called from create_reversal_entry
8654: --
8655: SELECT event_id
8656: INTO l_ref_event_id
8657: FROM xla_ae_headers
8658: WHERE application_id = p_application_id
8659: AND ae_header_id = p_ref_ae_header_id;
8660:
8661: END IF;

Line 8698: FROM xla_ae_headers xah

8694: ,xal.unrounded_entered_dr
8695: ,xal.unrounded_entered_cr
8696: ,xal.unrounded_accounted_dr
8697: ,xal.unrounded_accounted_cr
8698: FROM xla_ae_headers xah
8699: ,xla_ae_lines xal
8700: WHERE xah.application_id = p_application_id
8701: AND xah.ae_header_id = p_ae_header_id
8702: AND xal.application_id = xah.application_id