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_EVENTS

Line 729: l_event_source_info xla_events_pub_pkg.t_event_source_info;

725: ,p_retcode OUT NOCOPY INTEGER
726: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
727: IS
728:
729: l_event_source_info xla_events_pub_pkg.t_event_source_info;
730: l_entity_id INTEGER;
731: l_closing_status VARCHAR2(30);
732: l_status_code VARCHAR2(30) := C_AE_STATUS_INCOMPLETE;
733: l_result2 INTEGER := 0;

Line 780: p_event_id := xla_events_pkg.create_manual_event

776: l_event_source_info.legal_entity_id := p_legal_entity_id;
777: l_event_source_info.ledger_id := p_ledger_id;
778: l_event_source_info.entity_type_code := C_ENTITY_TYPE_CODE_MANUAL;
779:
780: p_event_id := xla_events_pkg.create_manual_event
781: (p_event_source_info => l_event_source_info
782: ,p_event_type_code => C_EVENT_TYPE_CODE_MANUAL
783: ,p_event_date => p_gl_date
784: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED

Line 784: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED

780: p_event_id := xla_events_pkg.create_manual_event
781: (p_event_source_info => l_event_source_info
782: ,p_event_type_code => C_EVENT_TYPE_CODE_MANUAL
783: ,p_event_date => p_gl_date
784: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
785: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
786: ,p_event_number => 1
787: ,p_budgetary_control_flag => p_budgetary_control_flag
788: );

Line 785: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED

781: (p_event_source_info => l_event_source_info
782: ,p_event_type_code => C_EVENT_TYPE_CODE_MANUAL
783: ,p_event_date => p_gl_date
784: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
785: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
786: ,p_event_number => 1
787: ,p_budgetary_control_flag => p_budgetary_control_flag
788: );
789:

Line 792: FROM xla_events

788: );
789:
790: SELECT entity_id
791: INTO l_entity_id
792: FROM xla_events
793: WHERE event_id = p_event_id;
794:
795: --
796: -- Retrieve period name

Line 980: l_event_source_info xla_events_pub_pkg.t_event_source_info;

976: l_period_type VARCHAR2(30);
977:
978: l_budget_version_id INTEGER;
979:
980: l_event_source_info xla_events_pub_pkg.t_event_source_info;
981:
982: l_log_module VARCHAR2(240);
983: BEGIN
984: IF g_log_enabled THEN

Line 1048: -- Update xla_events if gl date is updated

1044: AND entity_id = l_info.entity_id;
1045: END IF;
1046:
1047: --
1048: -- Update xla_events if gl date is updated
1049: --
1050: IF (l_info.gl_date <> p_gl_date) THEN
1051: UPDATE xla_events
1052: SET event_date = p_gl_date

Line 1051: UPDATE xla_events

1047: --
1048: -- Update xla_events if gl date is updated
1049: --
1050: IF (l_info.gl_date <> p_gl_date) THEN
1051: UPDATE xla_events
1052: SET event_date = p_gl_date
1053: WHERE application_id = p_application_id
1054: AND event_id = l_info.event_id;
1055:

Line 1137: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1133: ,p_application_id IN INTEGER
1134: ,p_mode IN VARCHAR2 DEFAULT C_DELETE_NORMAL_MODE
1135: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
1136: IS
1137: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1138: l_info t_je_info;
1139: l_log_module VARCHAR2(240);
1140: BEGIN
1141: IF g_log_enabled THEN

Line 1165: XLA_EVENTS_PKG.delete_processed_event

1161: l_event_source_info.ledger_id := l_info.ledger_id;
1162: l_event_source_info.entity_type_code := C_ENTITY_TYPE_CODE_MANUAL;
1163:
1164: IF (l_info.status_code = C_AE_STATUS_FINAL) THEN
1165: XLA_EVENTS_PKG.delete_processed_event
1166: (p_event_source_info => l_event_source_info
1167: ,p_event_id => l_info.event_id);
1168: ELSE
1169: XLA_EVENTS_PKG.delete_event

Line 1169: XLA_EVENTS_PKG.delete_event

1165: XLA_EVENTS_PKG.delete_processed_event
1166: (p_event_source_info => l_event_source_info
1167: ,p_event_id => l_info.event_id);
1168: ELSE
1169: XLA_EVENTS_PKG.delete_event
1170: (p_event_source_info => l_event_source_info
1171: ,p_valuation_method => NULL
1172: ,p_event_id => l_info.event_id);
1173: END IF;

Line 1482: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1478: WHERE application_id = p_application_id
1479: AND ae_header_id = p_ae_header_id;
1480:
1481: l_rounding_rule_code VARCHAR2(30);
1482: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1483: l_log_module VARCHAR2(240);
1484:
1485: CURSOR cur_enc IS -- 5522973
1486: SELECT enabled_flag, encumbrance_type

Line 1866: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1862: l_result2 INTEGER;
1863: l_date DATE;
1864: l_rounding_rule_code VARCHAR2(30);
1865:
1866: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1867: l_ref_ae_header_id INTEGER;
1868: l_temp_line_num INTEGER;
1869: l_dummy INTEGER;
1870: l_log_module VARCHAR2(240);

Line 2115: l_event_source_info xla_events_pub_pkg.t_event_source_info;

2111: l_info t_je_info;
2112: l_bal_seg INTEGER;
2113: l_mgt_seg INTEGER;
2114: l_status_code VARCHAR2(30) := C_AE_STATUS_INCOMPLETE;
2115: l_event_source_info xla_events_pub_pkg.t_event_source_info;
2116:
2117: l_log_module VARCHAR2(240);
2118: BEGIN
2119: IF g_log_enabled THEN

Line 2708: FROM xla_events

2704: IF g_rev_event_id IS NOT NULL THEN
2705:
2706: SELECT event_status_code
2707: INTO l_status_code
2708: FROM xla_events
2709: WHERE event_id = g_rev_event_id
2710: AND application_id = p_application_id;
2711:
2712: IF l_status_code <>'P' THEN

Line 3143: ,xla_events xe

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
3147: AND xe.event_id = xah.event_id

Line 3866: l_event_source_info xla_events_pub_pkg.t_event_source_info;

3862: --=============================================================================
3863: PROCEDURE undo_draft_entry
3864: (p_info IN t_je_info)
3865: IS
3866: l_event_source_info xla_events_pub_pkg.t_event_source_info;
3867: l_log_module VARCHAR2(240);
3868: BEGIN
3869: IF g_log_enabled THEN
3870: l_log_module := C_DEFAULT_MODULE||'.undo_draft_entry';

Line 3921: xla_events_pkg.update_manual_event

3917: l_event_source_info.legal_entity_id := p_info.legal_entity_id;
3918: l_event_source_info.ledger_id := p_info.ledger_id;
3919: l_event_source_info.entity_type_code := C_ENTITY_TYPE_CODE_MANUAL;
3920:
3921: xla_events_pkg.update_manual_event
3922: (p_event_source_info => l_event_source_info
3923: ,p_event_id => p_info.event_id
3924: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
3925: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED);

Line 3924: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED

3920:
3921: xla_events_pkg.update_manual_event
3922: (p_event_source_info => l_event_source_info
3923: ,p_event_id => p_info.event_id
3924: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
3925: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED);
3926: END IF;
3927:
3928: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 3925: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED);

3921: xla_events_pkg.update_manual_event
3922: (p_event_source_info => l_event_source_info
3923: ,p_event_id => p_info.event_id
3924: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
3925: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED);
3926: END IF;
3927:
3928: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3929: trace(p_msg => 'END of procedure undo_draft_entry',

Line 4024: l_event_source_info xla_events_pub_pkg.t_event_source_info;

4020: ,p_ledger_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4021: ,p_rev_ae_header_ids IN OUT NOCOPY xla_je_validation_pkg.t_array_int
4022: ,p_rev_status_codes IN OUT NOCOPY xla_je_validation_pkg.t_array_varchar)
4023: IS
4024: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4025: l_entity_id INTEGER;
4026: l_period_name VARCHAR2(30);
4027: l_closing_status VARCHAR2(30);
4028: l_validate_period INTEGER;

Line 4366: l_event_source_info xla_events_pub_pkg.t_event_source_info;

4362: ,p_msg_mode IN VARCHAR2
4363: ,p_rev_header_id OUT NOCOPY INTEGER
4364: ,p_rev_event_id OUT NOCOPY INTEGER)
4365: IS
4366: l_event_source_info xla_events_pub_pkg.t_event_source_info;
4367: l_entity_id INTEGER;
4368: l_period_name VARCHAR2(30);
4369: l_closing_status VARCHAR2(30);
4370: l_validate_period INTEGER;

Line 4416: p_rev_event_id := xla_events_pkg.create_manual_event

4412: - Checking that g_rev_event_id is not NULL to create event */
4413:
4414: IF g_rev_event_id IS NULL THEN
4415:
4416: p_rev_event_id := xla_events_pkg.create_manual_event
4417: (p_event_source_info => l_event_source_info
4418: ,p_event_type_code => C_EVENT_TYPE_CODE_MANUAL
4419: ,p_event_date => p_gl_date
4420: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED

Line 4420: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED

4416: p_rev_event_id := xla_events_pkg.create_manual_event
4417: (p_event_source_info => l_event_source_info
4418: ,p_event_type_code => C_EVENT_TYPE_CODE_MANUAL
4419: ,p_event_date => p_gl_date
4420: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
4421: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
4422: ,p_event_number => 1
4423: ,p_budgetary_control_flag => p_info.budgetary_control_flag
4424: );

Line 4421: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED

4417: (p_event_source_info => l_event_source_info
4418: ,p_event_type_code => C_EVENT_TYPE_CODE_MANUAL
4419: ,p_event_date => p_gl_date
4420: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
4421: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
4422: ,p_event_number => 1
4423: ,p_budgetary_control_flag => p_info.budgetary_control_flag
4424: );
4425: g_rev_event_id := p_rev_event_id;

Line 4429: FROM xla_events

4425: g_rev_event_id := p_rev_event_id;
4426:
4427: SELECT entity_id
4428: INTO g_entity_id
4429: FROM xla_events
4430: WHERE event_id = p_rev_event_id;
4431:
4432: l_entity_id := g_entity_id;
4433:

Line 5970: l_event_source_info xla_events_pub_pkg.t_event_source_info;

5966: IS
5967: l_accounting_batch_id INTEGER;
5968: l_transfer_errbuf VARCHAR2(30);
5969: l_transfer_retcode NUMBER;
5970: l_event_source_info xla_events_pub_pkg.t_event_source_info;
5971:
5972: l_log_module VARCHAR2(240);
5973: BEGIN
5974: IF g_log_enabled THEN

Line 6049: l_event_source_info xla_events_pub_pkg.t_event_source_info;

6045: PROCEDURE update_event_status
6046: (p_info IN t_je_info
6047: ,p_completion_option IN VARCHAR2)
6048: IS
6049: l_event_source_info xla_events_pub_pkg.t_event_source_info;
6050: l_event_status VARCHAR2(30);
6051: l_process_status VARCHAR2(30);
6052:
6053: l_log_module VARCHAR2(240);

Line 6074: l_event_status := xla_events_pub_pkg.C_EVENT_UNPROCESSED;

6070: l_event_source_info.ledger_id := p_info.ledger_id;
6071: l_event_source_info.entity_type_code := C_ENTITY_TYPE_CODE_MANUAL;
6072:
6073: IF (p_completion_option = C_COMPLETION_OPTION_DRAFT) THEN
6074: l_event_status := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
6075: l_process_status := xla_events_pkg.C_INTERNAL_DRAFT;
6076: ELSE
6077: l_event_status := xla_events_pub_pkg.C_EVENT_PROCESSED;
6078: l_process_status := xla_events_pkg.C_INTERNAL_FINAL;

Line 6075: l_process_status := xla_events_pkg.C_INTERNAL_DRAFT;

6071: l_event_source_info.entity_type_code := C_ENTITY_TYPE_CODE_MANUAL;
6072:
6073: IF (p_completion_option = C_COMPLETION_OPTION_DRAFT) THEN
6074: l_event_status := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
6075: l_process_status := xla_events_pkg.C_INTERNAL_DRAFT;
6076: ELSE
6077: l_event_status := xla_events_pub_pkg.C_EVENT_PROCESSED;
6078: l_process_status := xla_events_pkg.C_INTERNAL_FINAL;
6079: END IF;

Line 6077: l_event_status := xla_events_pub_pkg.C_EVENT_PROCESSED;

6073: IF (p_completion_option = C_COMPLETION_OPTION_DRAFT) THEN
6074: l_event_status := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
6075: l_process_status := xla_events_pkg.C_INTERNAL_DRAFT;
6076: ELSE
6077: l_event_status := xla_events_pub_pkg.C_EVENT_PROCESSED;
6078: l_process_status := xla_events_pkg.C_INTERNAL_FINAL;
6079: END IF;
6080:
6081: xla_events_pkg.update_manual_event

Line 6078: l_process_status := xla_events_pkg.C_INTERNAL_FINAL;

6074: l_event_status := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
6075: l_process_status := xla_events_pkg.C_INTERNAL_DRAFT;
6076: ELSE
6077: l_event_status := xla_events_pub_pkg.C_EVENT_PROCESSED;
6078: l_process_status := xla_events_pkg.C_INTERNAL_FINAL;
6079: END IF;
6080:
6081: xla_events_pkg.update_manual_event
6082: (p_event_source_info => l_event_source_info

Line 6081: xla_events_pkg.update_manual_event

6077: l_event_status := xla_events_pub_pkg.C_EVENT_PROCESSED;
6078: l_process_status := xla_events_pkg.C_INTERNAL_FINAL;
6079: END IF;
6080:
6081: xla_events_pkg.update_manual_event
6082: (p_event_source_info => l_event_source_info
6083: ,p_event_id => p_info.event_id
6084: ,p_event_status_code => l_event_status
6085: ,p_process_status_code => l_process_status);