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.OKL_XLA_EVENTS_PVT dependencies on XLA_EVENTS_PUB_PKG

Line 162: l_event_source_info xla_events_pub_pkg.t_event_source_info;

158: WHERE id = p_tcn_id;
159:
160: get_tcn_rec get_tcn_csr%ROWTYPE;
161:
162: l_event_source_info xla_events_pub_pkg.t_event_source_info;
163: l_security_context xla_events_pub_pkg.t_security;
164:
165: l_transaction_date DATE;
166: l_event_id NUMBER;

Line 163: l_security_context xla_events_pub_pkg.t_security;

159:
160: get_tcn_rec get_tcn_csr%ROWTYPE;
161:
162: l_event_source_info xla_events_pub_pkg.t_event_source_info;
163: l_security_context xla_events_pub_pkg.t_security;
164:
165: l_transaction_date DATE;
166: l_event_id NUMBER;
167: l_entity_type_code VARCHAR2(30);

Line 268: xla_events_pub_pkg.create_event(p_event_source_info => l_event_source_info

264:
265: BEGIN
266: l_sla_api_name := 'CREATE_EVENT';
267: l_event_id :=
268: xla_events_pub_pkg.create_event(p_event_source_info => l_event_source_info
269: ,p_event_type_code => l_event_type_code
270: ,p_event_date => p_gl_date
271: ,p_event_status_code => 'U'
272: ,p_event_number => NULL

Line 376: l_event_source_info xla_events_pub_pkg.t_event_source_info;

372: WHERE id = p_tcn_id;
373:
374: get_tcn_rec get_tcn_csr%ROWTYPE;
375:
376: l_event_source_info xla_events_pub_pkg.t_event_source_info;
377: l_security_context xla_events_pub_pkg.t_security;
378:
379: l_transaction_date DATE;
380: l_event_id NUMBER;

Line 377: l_security_context xla_events_pub_pkg.t_security;

373:
374: get_tcn_rec get_tcn_csr%ROWTYPE;
375:
376: l_event_source_info xla_events_pub_pkg.t_event_source_info;
377: l_security_context xla_events_pub_pkg.t_security;
378:
379: l_transaction_date DATE;
380: l_event_id NUMBER;
381: l_entity_type_code VARCHAR2(30);

Line 475: xla_events_pub_pkg.update_event_status(p_event_source_info => l_event_source_info

471: END IF;
472:
473: BEGIN
474: l_sla_api_name := 'UPDATE_EVENT_STATUS';
475: xla_events_pub_pkg.update_event_status(p_event_source_info => l_event_source_info
476: ,p_event_class_code => l_event_class_code
477: ,p_event_type_code => l_event_type_code
478: ,p_event_date => p_gl_date
479: ,p_event_status_code => p_event_status_code

Line 564: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

560: ,p_event_type_code IN VARCHAR2
561: ,p_event_status_code IN VARCHAR2
562: ,p_event_number IN NUMBER
563: ,p_update_ref_info IN VARCHAR2
564: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
565: ,p_representation_code IN VARCHAR2) IS
566:
567: CURSOR get_tcn_csr is
568: SELECT set_of_books_id,

Line 579: l_event_source_info xla_events_pub_pkg.t_event_source_info;

575: WHERE id = p_tcn_id;
576:
577: get_tcn_rec get_tcn_csr%ROWTYPE;
578:
579: l_event_source_info xla_events_pub_pkg.t_event_source_info;
580: l_security_context xla_events_pub_pkg.t_security;
581:
582: l_transaction_date DATE;
583: l_event_id NUMBER;

Line 580: l_security_context xla_events_pub_pkg.t_security;

576:
577: get_tcn_rec get_tcn_csr%ROWTYPE;
578:
579: l_event_source_info xla_events_pub_pkg.t_event_source_info;
580: l_security_context xla_events_pub_pkg.t_security;
581:
582: l_transaction_date DATE;
583: l_event_id NUMBER;
584: l_entity_type_code VARCHAR2(30);

Line 684: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

680: BEGIN
681: IF NVL(p_update_ref_info, 'N') = 'N' AND p_event_number IS NULL THEN
682: l_sla_api_name := 'UPDATE_EVENT';
683: -- update one of event type, event status, event date
684: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info
685: ,p_event_id => p_event_id
686: ,p_event_type_code => p_event_type_code
687: ,p_event_date => p_gl_date
688: ,p_event_status_code => p_event_status_code

Line 696: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

692:
693: ELSIF NVL(p_update_ref_info, 'N') = 'N' AND p_event_number IS NOT NULL THEN
694: l_sla_api_name := 'UPDATE_EVENT FOR EVENT NUMBER';
695: -- update one of event type, event status, event date and event number
696: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info
697: ,p_event_id => p_event_id
698: ,p_event_type_code => p_event_type_code
699: ,p_event_date => p_gl_date
700: ,p_event_status_code => p_event_status_code

Line 709: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

705:
706: ELSIF NVL(p_update_ref_info, 'N') = 'Y' AND p_event_number IS NULL THEN
707: l_sla_api_name := 'UPDATE_EVENT FOR REF INFO';
708: -- update one of event type, event status, event date and reference info
709: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info
710: ,p_event_id => p_event_id
711: ,p_event_type_code => p_event_type_code
712: ,p_event_date => p_gl_date
713: ,p_event_status_code => p_event_status_code

Line 722: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

718:
719: ELSIF NVL(p_update_ref_info, 'N') = 'Y' AND p_event_number IS NOT NULL THEN
720: l_sla_api_name := 'UPDATE_EVENT FOR EVENT NUMBER AND REF INFO';
721: -- update one of event type, event status, event date, reference info and event number
722: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info
723: ,p_event_id => p_event_id
724: ,p_event_type_code => p_event_type_code
725: ,p_event_date => p_gl_date
726: ,p_event_status_code => p_event_status_code

Line 825: l_event_source_info xla_events_pub_pkg.t_event_source_info;

821: WHERE id = p_tcn_id;
822:
823: get_tcn_rec get_tcn_csr%ROWTYPE;
824:
825: l_event_source_info xla_events_pub_pkg.t_event_source_info;
826: l_security_context xla_events_pub_pkg.t_security;
827:
828: l_transaction_date DATE;
829: l_event_id NUMBER;

Line 826: l_security_context xla_events_pub_pkg.t_security;

822:
823: get_tcn_rec get_tcn_csr%ROWTYPE;
824:
825: l_event_source_info xla_events_pub_pkg.t_event_source_info;
826: l_security_context xla_events_pub_pkg.t_security;
827:
828: l_transaction_date DATE;
829: l_event_id NUMBER;
830: l_entity_type_code VARCHAR2(30);

Line 917: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

913: l_event_source_info.source_id_int_1);
914:
915: BEGIN
916:
917: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info
918: ,p_event_id => p_event_id
919: ,p_event_date => p_gl_date
920: ,p_valuation_method => get_tcn_rec.representation_code
921: ,p_security_context => l_security_context);

Line 1083: XLA_EVENTS_PUB_PKG.update_bulk_event_statuses(p_application_id => g_application_id);

1079: AND xe.event_type_code = NVL(l_event_type_code, xe.event_type_code);
1080:
1081: BEGIN
1082: l_sla_api_name := 'UPDATE_BULK_EVENT_STATUSES';
1083: XLA_EVENTS_PUB_PKG.update_bulk_event_statuses(p_application_id => g_application_id);
1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1087: p_msg_name => g_unexpected_error,

Line 1162: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1158: WHERE id = p_tcn_id;
1159:
1160: get_tcn_rec get_tcn_csr%ROWTYPE;
1161:
1162: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1163: l_security_context xla_events_pub_pkg.t_security;
1164:
1165: l_transaction_date DATE;
1166: l_event_id NUMBER;

Line 1163: l_security_context xla_events_pub_pkg.t_security;

1159:
1160: get_tcn_rec get_tcn_csr%ROWTYPE;
1161:
1162: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1163: l_security_context xla_events_pub_pkg.t_security;
1164:
1165: l_transaction_date DATE;
1166: l_event_id NUMBER;
1167: l_entity_type_code VARCHAR2(30);

Line 1253: xla_events_pub_pkg.delete_event(p_event_source_info => l_event_source_info

1249: l_event_source_info.source_id_int_1);
1250:
1251: BEGIN
1252:
1253: xla_events_pub_pkg.delete_event(p_event_source_info => l_event_source_info
1254: ,p_event_id => p_event_id
1255: ,p_valuation_method => p_representation_code
1256: ,p_security_context => l_security_context);
1257: EXCEPTION

Line 1348: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1344: WHERE id = p_tcn_id;
1345:
1346: get_tcn_rec get_tcn_csr%ROWTYPE;
1347:
1348: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1349: l_security_context xla_events_pub_pkg.t_security;
1350:
1351: l_transaction_date DATE;
1352: l_event_id NUMBER;

Line 1349: l_security_context xla_events_pub_pkg.t_security;

1345:
1346: get_tcn_rec get_tcn_csr%ROWTYPE;
1347:
1348: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1349: l_security_context xla_events_pub_pkg.t_security;
1350:
1351: l_transaction_date DATE;
1352: l_event_id NUMBER;
1353: l_entity_type_code VARCHAR2(30);

Line 1447: xla_events_pub_pkg.delete_events(p_event_source_info => l_event_source_info

1443: END IF;
1444:
1445: BEGIN
1446: l_events_deleted :=
1447: xla_events_pub_pkg.delete_events(p_event_source_info => l_event_source_info
1448: ,p_event_class_code => l_event_class_code
1449: ,p_event_type_code => l_event_type_code
1450: ,p_event_date => p_gl_date
1451: ,p_valuation_method => p_representation_code

Line 1534: RETURN xla_events_pub_pkg.t_event_info IS

1530: ,x_msg_data OUT NOCOPY VARCHAR2
1531: ,p_tcn_id IN NUMBER
1532: ,p_event_id IN NUMBER
1533: ,p_representation_code IN VARCHAR2)
1534: RETURN xla_events_pub_pkg.t_event_info IS
1535:
1536: CURSOR get_tcn_csr IS
1537: SELECT set_of_books_id,
1538: legal_entity_id,

Line 1548: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1544: WHERE id = p_tcn_id;
1545:
1546: get_tcn_rec get_tcn_csr%ROWTYPE;
1547:
1548: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1549: l_security_context xla_events_pub_pkg.t_security;
1550: l_event_info xla_events_pub_pkg.t_event_info;
1551:
1552: l_entity_type_code VARCHAR2(30);

Line 1549: l_security_context xla_events_pub_pkg.t_security;

1545:
1546: get_tcn_rec get_tcn_csr%ROWTYPE;
1547:
1548: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1549: l_security_context xla_events_pub_pkg.t_security;
1550: l_event_info xla_events_pub_pkg.t_event_info;
1551:
1552: l_entity_type_code VARCHAR2(30);
1553: l_event_class_code VARCHAR2(30);

Line 1550: l_event_info xla_events_pub_pkg.t_event_info;

1546: get_tcn_rec get_tcn_csr%ROWTYPE;
1547:
1548: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1549: l_security_context xla_events_pub_pkg.t_security;
1550: l_event_info xla_events_pub_pkg.t_event_info;
1551:
1552: l_entity_type_code VARCHAR2(30);
1553: l_event_class_code VARCHAR2(30);
1554: l_event_type_code VARCHAR2(30);

Line 1641: xla_events_pub_pkg.get_event_info(p_event_source_info => l_event_source_info

1637: l_event_source_info.source_id_int_1);
1638:
1639: BEGIN
1640: l_event_info :=
1641: xla_events_pub_pkg.get_event_info(p_event_source_info => l_event_source_info
1642: ,p_event_id => p_event_id
1643: ,p_valuation_method => p_representation_code
1644: ,p_security_context => l_security_context);
1645: EXCEPTION

Line 1732: RETURN xla_events_pub_pkg.t_array_event_info IS

1728: ,p_action_type IN VARCHAR2
1729: ,p_gl_date IN DATE
1730: ,p_event_status_code IN VARCHAR2
1731: ,p_representation_code IN VARCHAR2)
1732: RETURN xla_events_pub_pkg.t_array_event_info IS
1733:
1734: CURSOR get_tcn_csr is
1735: SELECT set_of_books_id,
1736: legal_entity_id,

Line 1746: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1742: WHERE id = p_tcn_id;
1743:
1744: get_tcn_rec get_tcn_csr%ROWTYPE;
1745:
1746: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1747: l_security_context xla_events_pub_pkg.t_security;
1748: l_array_event_info xla_events_pub_pkg.t_array_event_info;
1749: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;
1750:

Line 1747: l_security_context xla_events_pub_pkg.t_security;

1743:
1744: get_tcn_rec get_tcn_csr%ROWTYPE;
1745:
1746: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1747: l_security_context xla_events_pub_pkg.t_security;
1748: l_array_event_info xla_events_pub_pkg.t_array_event_info;
1749: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;
1750:
1751: l_entity_type_code VARCHAR2(30);

Line 1748: l_array_event_info xla_events_pub_pkg.t_array_event_info;

1744: get_tcn_rec get_tcn_csr%ROWTYPE;
1745:
1746: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1747: l_security_context xla_events_pub_pkg.t_security;
1748: l_array_event_info xla_events_pub_pkg.t_array_event_info;
1749: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;
1750:
1751: l_entity_type_code VARCHAR2(30);
1752: l_event_class_code VARCHAR2(30);

Line 1749: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;

1745:
1746: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1747: l_security_context xla_events_pub_pkg.t_security;
1748: l_array_event_info xla_events_pub_pkg.t_array_event_info;
1749: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;
1750:
1751: l_entity_type_code VARCHAR2(30);
1752: l_event_class_code VARCHAR2(30);
1753: l_event_type_code VARCHAR2(30);

Line 1845: xla_events_pub_pkg.get_array_event_info(p_event_source_info => l_event_source_info

1841: l_event_source_info.source_id_int_1);
1842:
1843: BEGIN
1844: l_array_event_info :=
1845: xla_events_pub_pkg.get_array_event_info(p_event_source_info => l_event_source_info
1846: ,p_event_class_code => l_event_class_code
1847: ,p_event_type_code => l_event_type_code
1848: ,p_event_date => p_gl_date
1849: ,p_event_status_code => p_event_status_code

Line 1943: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1939: WHERE id = p_tcn_id;
1940:
1941: get_tcn_rec get_tcn_csr%ROWTYPE;
1942:
1943: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1944: l_security_context xla_events_pub_pkg.t_security;
1945:
1946: l_entity_type_code VARCHAR2(30);
1947: l_event_class_code VARCHAR2(30);

Line 1944: l_security_context xla_events_pub_pkg.t_security;

1940:
1941: get_tcn_rec get_tcn_csr%ROWTYPE;
1942:
1943: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1944: l_security_context xla_events_pub_pkg.t_security;
1945:
1946: l_entity_type_code VARCHAR2(30);
1947: l_event_class_code VARCHAR2(30);
1948: l_event_type_code VARCHAR2(30);

Line 2037: xla_events_pub_pkg.get_event_status(p_event_source_info => l_event_source_info

2033: l_event_source_info.source_id_int_1);
2034:
2035: BEGIN
2036: l_event_status_code :=
2037: xla_events_pub_pkg.get_event_status(p_event_source_info => l_event_source_info
2038: ,p_event_id => p_event_id
2039: ,p_valuation_method => p_representation_code
2040: ,p_security_context => l_security_context);
2041: EXCEPTION