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 812: -- Create entry in the xla_ae_headers table

808: ,p_msg_mode => p_msg_mode);
809: END IF;
810:
811: --
812: -- Create entry in the xla_ae_headers table
813: --
814: INSERT INTO xla_ae_headers
815: (ae_header_id
816: ,application_id

Line 814: INSERT INTO xla_ae_headers

810:
811: --
812: -- Create entry in the xla_ae_headers table
813: --
814: INSERT INTO xla_ae_headers
815: (ae_header_id
816: ,application_id
817: ,ledger_id
818: ,entity_id

Line 855: (xla_ae_headers_s.NEXTVAL

851: ,last_update_login
852: ,accrual_reversal_flag -- 4262811
853: )
854: values
855: (xla_ae_headers_s.NEXTVAL
856: ,p_application_id
857: ,p_ledger_id
858: ,l_entity_id
859: ,p_event_id

Line 1068: -- Update xla_ae_headers with modified information

1064: --
1065: undo_draft_entry(l_info);
1066:
1067: --
1068: -- Update xla_ae_headers with modified information
1069: --
1070: UPDATE xla_ae_headers
1071: SET reference_date = p_reference_date
1072: ,budget_version_id = l_budget_version_id

Line 1070: UPDATE xla_ae_headers

1066:
1067: --
1068: -- Update xla_ae_headers with modified information
1069: --
1070: UPDATE xla_ae_headers
1071: SET reference_date = p_reference_date
1072: ,budget_version_id = l_budget_version_id
1073: ,accounting_entry_type_code = p_accounting_entry_type_code
1074: ,accounting_entry_status_code = l_status_code

Line 1214: FROM xla_ae_headers h

1210: ,h.accounting_entry_type_code type_code
1211: ,h.funds_status_code funds_status_code
1212: ,h.packet_id packet_id
1213: ,h.entity_id entity_id
1214: FROM xla_ae_headers h
1215: ,xla_transaction_entities e
1216: WHERE e.application_id = p_application_id
1217: AND e.entity_id = h.entity_id
1218: AND h.application_id = p_application_id

Line 1224: FROM xla_ae_headers h

1220: FOR UPDATE NOWAIT;
1221:
1222: CURSOR c_period IS
1223: SELECT 'exist'
1224: FROM xla_ae_headers h
1225: ,gl_period_statuses p
1226: WHERE p.application_id(+) = C_GL_APPLICATION_ID
1227: AND p.ledger_id(+) = h.ledger_id
1228: AND p.adjustment_period_flag(+) = 'N'

Line 1323: FROM xla_ae_headers

1319:
1320: DELETE FROM xla_distribution_links
1321: WHERE application_id = p_application_id
1322: AND ae_header_id IN (SELECT ae_header_id
1323: FROM xla_ae_headers
1324: WHERE application_id = p_application_id
1325: AND event_id = p_event_id);
1326:
1327: IF (l_entry.ae_header_id IS NOT NULL) THEN

Line 1369: DELETE xla_ae_headers

1365: WHERE application_id = p_application_id
1366: AND ae_header_id = l_ae_header_ids(k);
1367:
1368: FORALL k in 1..j
1369: DELETE xla_ae_headers
1370: WHERE application_id = p_application_id
1371: AND ae_header_id = l_ae_header_ids(k);
1372:
1373: END IF;

Line 1753: update xla_ae_headers

1749: ,p_ref_event_id => NULL
1750: ,p_ref_temp_line_num => NULL);
1751:
1752: IF (l_info.status_code <> l_status_code) THEN
1753: update xla_ae_headers
1754: set accounting_entry_status_code = l_status_code
1755: WHERE ae_header_id = p_ae_header_id
1756: AND application_id = p_application_id;
1757: END IF;

Line 2070: UPDATE xla_ae_headers

2066: END IF;
2067: END IF;
2068:
2069: IF (l_info.status_code <> l_status_code) THEN
2070: UPDATE xla_ae_headers
2071: set accounting_entry_status_code = l_status_code
2072: WHERE ae_header_id = p_ae_header_id
2073: AND application_id = l_info.application_id;
2074: END IF;

Line 2145: UPDATE xla_ae_headers

2141: --
2142: undo_draft_entry(l_info);
2143:
2144: IF (l_info.status_code <> l_status_code) THEN
2145: UPDATE xla_ae_headers
2146: set accounting_entry_status_code = l_status_code
2147: WHERE ae_header_id = p_ae_header_id
2148: AND application_id = p_application_id;
2149: END IF;

Line 2587: UPDATE xla_ae_headers

2583: END IF;
2584:
2585:
2586: FORALL i IN 1 .. l_ae_header_ids.COUNT
2587: UPDATE xla_ae_headers
2588: SET accounting_entry_status_code = l_status_codes(i)
2589: ,funds_status_code = p_funds_status_code
2590: ,completion_acct_seq_value = DECODE(l_seq_values(i),-1,NULL,l_seq_values(i))
2591: ,completion_acct_seq_version_id = DECODE(l_seq_version_ids(i),-1,NULL,l_seq_version_ids(i))

Line 3142: FROM xla_ae_headers xah

3138: ,xah.attribute12
3139: ,xah.attribute13
3140: ,xah.attribute14
3141: ,xah.attribute15
3142: FROM xla_ae_headers xah
3143: ,xla_events xe
3144: ,xla_transaction_entities xte
3145: WHERE xte.entity_id = xah.entity_id
3146: AND xte.application_id = xah.application_id

Line 4045: FROM xla_ae_headers xah

4041: ------------------------------------------------------------------------------
4042: /*
4043: CURSOR c_mrc_headers IS
4044: SELECT xah.*
4045: FROM xla_ae_headers xah
4046: , xla_alt_curr_ledgers_v l
4047: WHERE xah.application_id = p_info.application_id
4048: AND xah.event_id = p_orig_event_id
4049: AND xah.ledger_id = l.ledger_id

Line 4055: FROM xla_ae_headers xah

4051: AND l.enabled_flag = 'Y';
4052: */
4053: CURSOR c_mrc_headers IS
4054: SELECT xah.*
4055: FROM xla_ae_headers xah
4056: , xla_ledger_relationships_v l
4057: WHERE xah.application_id = p_info.application_id
4058: AND xah.event_id = p_orig_event_id
4059: AND xah.ledger_id = l.ledger_id

Line 4100: INSERT INTO xla_ae_headers

4096:
4097: --
4098: -- Create a new journal entry header
4099: --
4100: INSERT INTO xla_ae_headers
4101: (ae_header_id
4102: ,application_id
4103: ,ledger_id
4104: ,entity_id

Line 4125: (xla_ae_headers_s.NEXTVAL

4121: ,last_updated_by
4122: ,last_update_login
4123: ,accrual_reversal_flag) -- 5109240
4124: values
4125: (xla_ae_headers_s.NEXTVAL
4126: ,l_mrc_header.application_id
4127: ,l_mrc_header.ledger_id
4128: ,p_info.entity_id
4129: ,p_info.event_id

Line 4452: INSERT INTO xla_ae_headers

4448: --
4449: -- Create a new journal entry header
4450: --
4451:
4452: INSERT INTO xla_ae_headers
4453: (ae_header_id
4454: ,application_id
4455: ,ledger_id
4456: ,entity_id

Line 4476: (xla_ae_headers_s.NEXTVAL

4472: ,last_updated_by
4473: ,last_update_login
4474: ,accrual_reversal_flag) -- 4262811
4475: values
4476: (xla_ae_headers_s.NEXTVAL
4477: ,p_info.application_id
4478: ,p_info.ledger_id
4479: ,l_entity_id
4480: ,p_rev_event_id

Line 4942: p_table_name => 'XLA_AE_HEADERS',

4938: fun_seq.get_sequence_number(
4939: p_context_type => 'LEDGER_AND_CURRENCY',
4940: p_context_value => to_char(p_ledger_id),
4941: p_application_Id => C_XLA_APPLICATION_ID,
4942: p_table_name => 'XLA_AE_HEADERS',
4943: p_event_code => 'COMPLETION',
4944: p_control_attribute_rec => l_control_attributes,
4945: p_control_date_tbl => l_control_dates,
4946: p_suppress_error => 'N',

Line 5270: INSERT INTO xla_ae_headers

5266: p_module => l_log_module,
5267: p_level => C_LEVEL_STATEMENT);
5268: END IF;
5269:
5270: INSERT INTO xla_ae_headers
5271: (ae_header_id
5272: ,application_id
5273: ,amb_context_code
5274: ,ledger_id

Line 5323: values( xla_ae_headers_s.NEXTVAL

5319: ,last_update_date
5320: ,last_updated_by
5321: ,last_update_login
5322: ,accrual_reversal_flag) -- 4262811
5323: values( xla_ae_headers_s.NEXTVAL
5324: ,p_info.application_id
5325: ,p_info.amb_context_code
5326: ,l_mrc_ledger.ledger_id
5327: ,p_info.entity_id

Line 5849: FROM xla_ae_headers h

5845: ,p_ledger_id IN INTEGER)
5846: IS
5847: CURSOR c_entries IS
5848: SELECT h.ae_header_id
5849: FROM xla_ae_headers h
5850: WHERE h.event_id = p_event_id
5851: AND h.application_id = p_application_id
5852: AND h.ledger_id <> p_ledger_id;
5853:

Line 5927: DELETE xla_ae_headers

5923: WHERE ae_header_id = l_header_ids(j)
5924: AND application_id = p_application_id;
5925:
5926: FORALL j in 1..i
5927: DELETE xla_ae_headers
5928: WHERE ae_header_id = l_header_ids(j)
5929: AND application_id = p_application_id;
5930:
5931: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 7809: FROM xla_ae_headers

7805: -- check that entry exists
7806: -------------------------------------------
7807: SELECT MIN(entity_id), MAX(gl_transfer_status_code)
7808: INTO l_entity_id, l_gl_status
7809: FROM xla_ae_headers
7810: WHERE application_id = p_application_id
7811: AND ae_header_id = p_ae_header_id
7812: AND accounting_entry_status_code = 'F';
7813:

Line 7930: Update XLA_AE_HEADERS

7926: p_level => C_LEVEL_STATEMENT);
7927: END IF;
7928: IF p_item_name in (C_ITEM_HEADER_DESCRIPTION, C_ITEM_REFERENCE_DATE, C_ITEM_GL_DATE) THEN
7929:
7930: Update XLA_AE_HEADERS
7931: SET DESCRIPTION = DECODE(p_item_name, C_ITEM_HEADER_DESCRIPTION, p_value_varchar2, DESCRIPTION)
7932: ,ACCOUNTING_DATE = DECODE(p_item_name, C_ITEM_GL_DATE, p_value_date, ACCOUNTING_DATE)
7933: ,REFERENCE_DATE = DECODE(p_item_name, C_ITEM_REFERENCE_DATE, p_value_date, REFERENCE_DATE)
7934: WHERE application_id = p_application_id

Line 8162: FROM xla_ae_headers xah

8158: ,xal.unrounded_entered_dr
8159: ,xal.unrounded_entered_cr
8160: ,xal.unrounded_accounted_dr
8161: ,xal.unrounded_accounted_cr
8162: FROM xla_ae_headers xah
8163: ,xla_ae_lines xal
8164: WHERE xah.application_id = p_application_id
8165: AND xah.ae_header_id = p_ae_header_id
8166: AND xal.application_id = xah.application_id

Line 8390: FROM xla_ae_headers

8386: -- Called from create_reversal_entry
8387: --
8388: SELECT event_id
8389: INTO l_ref_event_id
8390: FROM xla_ae_headers
8391: WHERE application_id = p_application_id
8392: AND ae_header_id = p_ref_ae_header_id;
8393:
8394: END IF;

Line 8431: FROM xla_ae_headers xah

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