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 276: xla_events_pub_pkg.create_event(p_event_source_info => l_event_source_info

272: l_org_id := mo_global.get_current_org_id;
273: l_access_mode := mo_global.get_access_mode;
274:
275: l_event_id :=
276: xla_events_pub_pkg.create_event(p_event_source_info => l_event_source_info
277: ,p_event_type_code => l_event_type_code
278: ,p_event_date => p_gl_date
279: ,p_event_status_code => 'U'
280: ,p_event_number => NULL

Line 287: --Org context was getting lost in xla_events_pub_pkg.create_event randomly

283: ,p_valuation_method => p_representation_code
284: ,p_security_context => l_security_context
285: );
286: --Bug 8946667 by nikshah.
287: --Org context was getting lost in xla_events_pub_pkg.create_event randomly
288: --So below workaround was made to fix the issue.
289: IF mo_global.get_current_org_id <> l_org_id OR
290: mo_global.get_access_mode <> l_access_mode
291: THEN

Line 393: l_event_source_info xla_events_pub_pkg.t_event_source_info;

389: WHERE id = p_tcn_id;
390:
391: get_tcn_rec get_tcn_csr%ROWTYPE;
392:
393: l_event_source_info xla_events_pub_pkg.t_event_source_info;
394: l_security_context xla_events_pub_pkg.t_security;
395:
396: l_transaction_date DATE;
397: l_event_id NUMBER;

Line 394: l_security_context xla_events_pub_pkg.t_security;

390:
391: get_tcn_rec get_tcn_csr%ROWTYPE;
392:
393: l_event_source_info xla_events_pub_pkg.t_event_source_info;
394: l_security_context xla_events_pub_pkg.t_security;
395:
396: l_transaction_date DATE;
397: l_event_id NUMBER;
398: l_entity_type_code VARCHAR2(30);

Line 492: xla_events_pub_pkg.update_event_status(p_event_source_info => l_event_source_info

488: END IF;
489:
490: BEGIN
491: l_sla_api_name := 'UPDATE_EVENT_STATUS';
492: xla_events_pub_pkg.update_event_status(p_event_source_info => l_event_source_info
493: ,p_event_class_code => l_event_class_code
494: ,p_event_type_code => l_event_type_code
495: ,p_event_date => p_gl_date
496: ,p_event_status_code => p_event_status_code

Line 581: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

577: ,p_event_type_code IN VARCHAR2
578: ,p_event_status_code IN VARCHAR2
579: ,p_event_number IN NUMBER
580: ,p_update_ref_info IN VARCHAR2
581: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
582: ,p_representation_code IN VARCHAR2) IS
583:
584: CURSOR get_tcn_csr is
585: SELECT set_of_books_id,

Line 596: l_event_source_info xla_events_pub_pkg.t_event_source_info;

592: WHERE id = p_tcn_id;
593:
594: get_tcn_rec get_tcn_csr%ROWTYPE;
595:
596: l_event_source_info xla_events_pub_pkg.t_event_source_info;
597: l_security_context xla_events_pub_pkg.t_security;
598:
599: l_transaction_date DATE;
600: l_event_id NUMBER;

Line 597: l_security_context xla_events_pub_pkg.t_security;

593:
594: get_tcn_rec get_tcn_csr%ROWTYPE;
595:
596: l_event_source_info xla_events_pub_pkg.t_event_source_info;
597: l_security_context xla_events_pub_pkg.t_security;
598:
599: l_transaction_date DATE;
600: l_event_id NUMBER;
601: l_entity_type_code VARCHAR2(30);

Line 701: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

697: BEGIN
698: IF NVL(p_update_ref_info, 'N') = 'N' AND p_event_number IS NULL THEN
699: l_sla_api_name := 'UPDATE_EVENT';
700: -- update one of event type, event status, event date
701: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info
702: ,p_event_id => p_event_id
703: ,p_event_type_code => p_event_type_code
704: ,p_event_date => p_gl_date
705: ,p_event_status_code => p_event_status_code

Line 713: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

709:
710: ELSIF NVL(p_update_ref_info, 'N') = 'N' AND p_event_number IS NOT NULL THEN
711: l_sla_api_name := 'UPDATE_EVENT FOR EVENT NUMBER';
712: -- update one of event type, event status, event date and event number
713: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info
714: ,p_event_id => p_event_id
715: ,p_event_type_code => p_event_type_code
716: ,p_event_date => p_gl_date
717: ,p_event_status_code => p_event_status_code

Line 726: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

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

Line 739: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

735:
736: ELSIF NVL(p_update_ref_info, 'N') = 'Y' AND p_event_number IS NOT NULL THEN
737: l_sla_api_name := 'UPDATE_EVENT FOR EVENT NUMBER AND REF INFO';
738: -- update one of event type, event status, event date, reference info and event number
739: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info
740: ,p_event_id => p_event_id
741: ,p_event_type_code => p_event_type_code
742: ,p_event_date => p_gl_date
743: ,p_event_status_code => p_event_status_code

Line 842: l_event_source_info xla_events_pub_pkg.t_event_source_info;

838: WHERE id = p_tcn_id;
839:
840: get_tcn_rec get_tcn_csr%ROWTYPE;
841:
842: l_event_source_info xla_events_pub_pkg.t_event_source_info;
843: l_security_context xla_events_pub_pkg.t_security;
844:
845: l_transaction_date DATE;
846: l_event_id NUMBER;

Line 843: l_security_context xla_events_pub_pkg.t_security;

839:
840: get_tcn_rec get_tcn_csr%ROWTYPE;
841:
842: l_event_source_info xla_events_pub_pkg.t_event_source_info;
843: l_security_context xla_events_pub_pkg.t_security;
844:
845: l_transaction_date DATE;
846: l_event_id NUMBER;
847: l_entity_type_code VARCHAR2(30);

Line 934: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info

930: l_event_source_info.source_id_int_1);
931:
932: BEGIN
933:
934: xla_events_pub_pkg.update_event(p_event_source_info => l_event_source_info
935: ,p_event_id => p_event_id
936: ,p_event_date => p_gl_date
937: ,p_valuation_method => get_tcn_rec.representation_code
938: ,p_security_context => l_security_context);

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

1096: AND xe.event_type_code = NVL(l_event_type_code, xe.event_type_code);
1097:
1098: BEGIN
1099: l_sla_api_name := 'UPDATE_BULK_EVENT_STATUSES';
1100: XLA_EVENTS_PUB_PKG.update_bulk_event_statuses(p_application_id => g_application_id);
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1104: p_msg_name => g_unexpected_error,

Line 1179: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1175: WHERE id = p_tcn_id;
1176:
1177: get_tcn_rec get_tcn_csr%ROWTYPE;
1178:
1179: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1180: l_security_context xla_events_pub_pkg.t_security;
1181:
1182: l_transaction_date DATE;
1183: l_event_id NUMBER;

Line 1180: l_security_context xla_events_pub_pkg.t_security;

1176:
1177: get_tcn_rec get_tcn_csr%ROWTYPE;
1178:
1179: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1180: l_security_context xla_events_pub_pkg.t_security;
1181:
1182: l_transaction_date DATE;
1183: l_event_id NUMBER;
1184: l_entity_type_code VARCHAR2(30);

Line 1270: xla_events_pub_pkg.delete_event(p_event_source_info => l_event_source_info

1266: l_event_source_info.source_id_int_1);
1267:
1268: BEGIN
1269:
1270: xla_events_pub_pkg.delete_event(p_event_source_info => l_event_source_info
1271: ,p_event_id => p_event_id
1272: ,p_valuation_method => p_representation_code
1273: ,p_security_context => l_security_context);
1274: EXCEPTION

Line 1365: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1361: WHERE id = p_tcn_id;
1362:
1363: get_tcn_rec get_tcn_csr%ROWTYPE;
1364:
1365: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1366: l_security_context xla_events_pub_pkg.t_security;
1367:
1368: l_transaction_date DATE;
1369: l_event_id NUMBER;

Line 1366: l_security_context xla_events_pub_pkg.t_security;

1362:
1363: get_tcn_rec get_tcn_csr%ROWTYPE;
1364:
1365: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1366: l_security_context xla_events_pub_pkg.t_security;
1367:
1368: l_transaction_date DATE;
1369: l_event_id NUMBER;
1370: l_entity_type_code VARCHAR2(30);

Line 1464: xla_events_pub_pkg.delete_events(p_event_source_info => l_event_source_info

1460: END IF;
1461:
1462: BEGIN
1463: l_events_deleted :=
1464: xla_events_pub_pkg.delete_events(p_event_source_info => l_event_source_info
1465: ,p_event_class_code => l_event_class_code
1466: ,p_event_type_code => l_event_type_code
1467: ,p_event_date => p_gl_date
1468: ,p_valuation_method => p_representation_code

Line 1551: RETURN xla_events_pub_pkg.t_event_info IS

1547: ,x_msg_data OUT NOCOPY VARCHAR2
1548: ,p_tcn_id IN NUMBER
1549: ,p_event_id IN NUMBER
1550: ,p_representation_code IN VARCHAR2)
1551: RETURN xla_events_pub_pkg.t_event_info IS
1552:
1553: CURSOR get_tcn_csr IS
1554: SELECT set_of_books_id,
1555: legal_entity_id,

Line 1565: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1561: WHERE id = p_tcn_id;
1562:
1563: get_tcn_rec get_tcn_csr%ROWTYPE;
1564:
1565: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1566: l_security_context xla_events_pub_pkg.t_security;
1567: l_event_info xla_events_pub_pkg.t_event_info;
1568:
1569: l_entity_type_code VARCHAR2(30);

Line 1566: l_security_context xla_events_pub_pkg.t_security;

1562:
1563: get_tcn_rec get_tcn_csr%ROWTYPE;
1564:
1565: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1566: l_security_context xla_events_pub_pkg.t_security;
1567: l_event_info xla_events_pub_pkg.t_event_info;
1568:
1569: l_entity_type_code VARCHAR2(30);
1570: l_event_class_code VARCHAR2(30);

Line 1567: l_event_info xla_events_pub_pkg.t_event_info;

1563: get_tcn_rec get_tcn_csr%ROWTYPE;
1564:
1565: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1566: l_security_context xla_events_pub_pkg.t_security;
1567: l_event_info xla_events_pub_pkg.t_event_info;
1568:
1569: l_entity_type_code VARCHAR2(30);
1570: l_event_class_code VARCHAR2(30);
1571: l_event_type_code VARCHAR2(30);

Line 1658: xla_events_pub_pkg.get_event_info(p_event_source_info => l_event_source_info

1654: l_event_source_info.source_id_int_1);
1655:
1656: BEGIN
1657: l_event_info :=
1658: xla_events_pub_pkg.get_event_info(p_event_source_info => l_event_source_info
1659: ,p_event_id => p_event_id
1660: ,p_valuation_method => p_representation_code
1661: ,p_security_context => l_security_context);
1662: EXCEPTION

Line 1749: RETURN xla_events_pub_pkg.t_array_event_info IS

1745: ,p_action_type IN VARCHAR2
1746: ,p_gl_date IN DATE
1747: ,p_event_status_code IN VARCHAR2
1748: ,p_representation_code IN VARCHAR2)
1749: RETURN xla_events_pub_pkg.t_array_event_info IS
1750:
1751: CURSOR get_tcn_csr is
1752: SELECT set_of_books_id,
1753: legal_entity_id,

Line 1763: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1759: WHERE id = p_tcn_id;
1760:
1761: get_tcn_rec get_tcn_csr%ROWTYPE;
1762:
1763: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1764: l_security_context xla_events_pub_pkg.t_security;
1765: l_array_event_info xla_events_pub_pkg.t_array_event_info;
1766: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;
1767:

Line 1764: l_security_context xla_events_pub_pkg.t_security;

1760:
1761: get_tcn_rec get_tcn_csr%ROWTYPE;
1762:
1763: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1764: l_security_context xla_events_pub_pkg.t_security;
1765: l_array_event_info xla_events_pub_pkg.t_array_event_info;
1766: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;
1767:
1768: l_entity_type_code VARCHAR2(30);

Line 1765: l_array_event_info xla_events_pub_pkg.t_array_event_info;

1761: get_tcn_rec get_tcn_csr%ROWTYPE;
1762:
1763: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1764: l_security_context xla_events_pub_pkg.t_security;
1765: l_array_event_info xla_events_pub_pkg.t_array_event_info;
1766: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;
1767:
1768: l_entity_type_code VARCHAR2(30);
1769: l_event_class_code VARCHAR2(30);

Line 1766: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;

1762:
1763: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1764: l_security_context xla_events_pub_pkg.t_security;
1765: l_array_event_info xla_events_pub_pkg.t_array_event_info;
1766: l_array_event_info_null xla_events_pub_pkg.t_array_event_info;
1767:
1768: l_entity_type_code VARCHAR2(30);
1769: l_event_class_code VARCHAR2(30);
1770: l_event_type_code VARCHAR2(30);

Line 1862: xla_events_pub_pkg.get_array_event_info(p_event_source_info => l_event_source_info

1858: l_event_source_info.source_id_int_1);
1859:
1860: BEGIN
1861: l_array_event_info :=
1862: xla_events_pub_pkg.get_array_event_info(p_event_source_info => l_event_source_info
1863: ,p_event_class_code => l_event_class_code
1864: ,p_event_type_code => l_event_type_code
1865: ,p_event_date => p_gl_date
1866: ,p_event_status_code => p_event_status_code

Line 1960: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1956: WHERE id = p_tcn_id;
1957:
1958: get_tcn_rec get_tcn_csr%ROWTYPE;
1959:
1960: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1961: l_security_context xla_events_pub_pkg.t_security;
1962:
1963: l_entity_type_code VARCHAR2(30);
1964: l_event_class_code VARCHAR2(30);

Line 1961: l_security_context xla_events_pub_pkg.t_security;

1957:
1958: get_tcn_rec get_tcn_csr%ROWTYPE;
1959:
1960: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1961: l_security_context xla_events_pub_pkg.t_security;
1962:
1963: l_entity_type_code VARCHAR2(30);
1964: l_event_class_code VARCHAR2(30);
1965: l_event_type_code VARCHAR2(30);

Line 2054: xla_events_pub_pkg.get_event_status(p_event_source_info => l_event_source_info

2050: l_event_source_info.source_id_int_1);
2051:
2052: BEGIN
2053: l_event_status_code :=
2054: xla_events_pub_pkg.get_event_status(p_event_source_info => l_event_source_info
2055: ,p_event_id => p_event_id
2056: ,p_valuation_method => p_representation_code
2057: ,p_security_context => l_security_context);
2058: EXCEPTION