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_EVENTS_PKG dependencies on XLA_EVENTS_PUB_PKG

Line 257: g_source_info xla_events_pub_pkg.t_event_source_info;

253:
254: g_ledger_status_tbl t_ledger_status_tbl;
255: -- for caching the value if event can be created
256:
257: g_source_info xla_events_pub_pkg.t_event_source_info;
258: g_entity_id NUMBER; -- Entity id 8761772
259: g_entity_type_code VARCHAR2(30); -- Entity code
260: g_valuation_method VARCHAR2(80); -- valuation method
261:

Line 334: (p_source_info IN xla_events_pub_pkg.t_event_source_info

330: (p_event_status_code IN VARCHAR2
331: ,p_process_status_code IN VARCHAR2);
332:
333: PROCEDURE validate_params
334: (p_source_info IN xla_events_pub_pkg.t_event_source_info
335: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
336: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
337: ,p_event_date IN DATE DEFAULT NULL
338: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 346: (p_source_info IN xla_events_pub_pkg.t_event_source_info

342: (p_ledger_id IN NUMBER
343: ,p_application_id IN NUMBER);
344:
345: PROCEDURE cache_entity_info
346: (p_source_info IN xla_events_pub_pkg.t_event_source_info
347: ,p_valuation_method IN VARCHAR2
348: ,p_event_id IN NUMBER); -- 8761772
349:
350: PROCEDURE update_entity_trx_number

Line 359: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info

355: PROCEDURE set_context
356: (p_context IN VARCHAR2);
357:
358: FUNCTION source_info_changed
359: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info
360: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info
361: ,p_valuation_method1 IN VARCHAR2
362: ,p_valuation_method2 IN VARCHAR2)
363: RETURN BOOLEAN;

Line 360: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info

356: (p_context IN VARCHAR2);
357:
358: FUNCTION source_info_changed
359: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info
360: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info
361: ,p_valuation_method1 IN VARCHAR2
362: ,p_valuation_method2 IN VARCHAR2)
363: RETURN BOOLEAN;
364:

Line 374: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

370: ,p_source_id_code_4 IN VARCHAR2)
371: RETURN VARCHAR2;
372:
373: FUNCTION create_entity_event
374: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
375: ,p_valuation_method IN VARCHAR2
376: ,p_event_type_code IN VARCHAR2
377: ,p_event_date IN DATE
378: ,p_event_status_code IN VARCHAR2

Line 382: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

378: ,p_event_status_code IN VARCHAR2
379: ,p_process_status_code IN VARCHAR2
380: ,p_event_number IN NUMBER
381: ,p_transaction_date IN DATE
382: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
383: DEFAULT NULL
384: ,p_budgetary_control_flag IN VARCHAR2)
385: RETURN INTEGER;
386:

Line 398: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

394: ,p_event_status_code IN VARCHAR2
395: ,p_process_status_code IN VARCHAR2
396: ,p_event_number IN NUMBER
397: ,p_transaction_date IN DATE
398: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
399: DEFAULT NULL
400: ,p_budgetary_control_flag IN VARCHAR2)
401: RETURN INTEGER;
402:

Line 491: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

487: --
488: --=============================================================================
489:
490: FUNCTION create_event
491: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
492: ,p_valuation_method IN VARCHAR2
493: ,p_event_type_code IN VARCHAR2
494: ,p_event_date IN DATE
495: ,p_event_status_code IN VARCHAR2

Line 498: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

494: ,p_event_date IN DATE
495: ,p_event_status_code IN VARCHAR2
496: ,p_event_number IN INTEGER DEFAULT NULL
497: ,p_transaction_date IN DATE DEFAULT NULL
498: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
499: DEFAULT NULL
500: ,p_budgetary_control_flag IN VARCHAR2)
501: RETURN INTEGER IS
502: l_event_date DATE;

Line 609: xla_events_pub_pkg.g_security.security_id_int_1

605: ,p_level => C_LEVEL_PROCEDURE
606: ,p_module =>l_log_module);
607: trace
608: (p_msg => 'security_id_int_1 = '||
609: xla_events_pub_pkg.g_security.security_id_int_1
610: ,p_level => C_LEVEL_PROCEDURE
611: ,p_module =>l_log_module);
612: trace
613: (p_msg => 'security_id_int_2 = '||

Line 614: xla_events_pub_pkg.g_security.security_id_int_2

610: ,p_level => C_LEVEL_PROCEDURE
611: ,p_module =>l_log_module);
612: trace
613: (p_msg => 'security_id_int_2 = '||
614: xla_events_pub_pkg.g_security.security_id_int_2
615: ,p_level => C_LEVEL_PROCEDURE
616: ,p_module =>l_log_module);
617: trace
618: (p_msg => 'security_id_int_3 = '||

Line 619: xla_events_pub_pkg.g_security.security_id_int_3

615: ,p_level => C_LEVEL_PROCEDURE
616: ,p_module =>l_log_module);
617: trace
618: (p_msg => 'security_id_int_3 = '||
619: xla_events_pub_pkg.g_security.security_id_int_3
620: ,p_level => C_LEVEL_PROCEDURE
621: ,p_module =>l_log_module);
622: trace
623: (p_msg => 'security_id_char_1 = '||

Line 624: xla_events_pub_pkg.g_security.security_id_char_1

620: ,p_level => C_LEVEL_PROCEDURE
621: ,p_module =>l_log_module);
622: trace
623: (p_msg => 'security_id_char_1 = '||
624: xla_events_pub_pkg.g_security.security_id_char_1
625: ,p_level => C_LEVEL_PROCEDURE
626: ,p_module =>l_log_module);
627: trace
628: (p_msg => 'security_id_char_2 = '||

Line 629: xla_events_pub_pkg.g_security.security_id_char_2

625: ,p_level => C_LEVEL_PROCEDURE
626: ,p_module =>l_log_module);
627: trace
628: (p_msg => 'security_id_char_2 = '||
629: xla_events_pub_pkg.g_security.security_id_char_2
630: ,p_level => C_LEVEL_PROCEDURE
631: ,p_module =>l_log_module);
632: trace
633: (p_msg => 'security_id_char_3 = '||

Line 634: xla_events_pub_pkg.g_security.security_id_char_3

630: ,p_level => C_LEVEL_PROCEDURE
631: ,p_module =>l_log_module);
632: trace
633: (p_msg => 'security_id_char_3 = '||
634: xla_events_pub_pkg.g_security.security_id_char_3
635: ,p_level => C_LEVEL_PROCEDURE
636: ,p_module =>l_log_module);
637: trace
638: (p_msg => 'valuation_method = '||p_valuation_method

Line 829: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

825: --
826: --=============================================================================
827:
828: FUNCTION create_manual_event
829: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
830: ,p_event_type_code IN VARCHAR2
831: ,p_event_date IN DATE
832: ,p_event_status_code IN VARCHAR2
833: ,p_process_status_code IN VARCHAR2

Line 836: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL

832: ,p_event_status_code IN VARCHAR2
833: ,p_process_status_code IN VARCHAR2
834: ,p_event_number IN INTEGER DEFAULT NULL
835: ,p_transaction_date IN DATE DEFAULT NULL
836: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
837: ,p_budgetary_control_flag IN VARCHAR2)
838: RETURN INTEGER IS
839: l_event_date DATE;
840: L_CONSTANT CONSTANT VARCHAR2(30) := '##UNDEFINED##'; --chr(12);

Line 946: xla_events_pub_pkg.g_security.security_id_int_1

942: ,p_level => C_LEVEL_PROCEDURE
943: ,p_module =>l_log_module);
944: trace
945: (p_msg => 'security_id_int_1 = '||
946: xla_events_pub_pkg.g_security.security_id_int_1
947: ,p_level => C_LEVEL_PROCEDURE
948: ,p_module =>l_log_module);
949: trace
950: (p_msg => 'security_id_int_2 = '||

Line 951: xla_events_pub_pkg.g_security.security_id_int_2

947: ,p_level => C_LEVEL_PROCEDURE
948: ,p_module =>l_log_module);
949: trace
950: (p_msg => 'security_id_int_2 = '||
951: xla_events_pub_pkg.g_security.security_id_int_2
952: ,p_level => C_LEVEL_PROCEDURE
953: ,p_module =>l_log_module);
954: trace
955: (p_msg => 'security_id_int_3 = '||

Line 956: xla_events_pub_pkg.g_security.security_id_int_3

952: ,p_level => C_LEVEL_PROCEDURE
953: ,p_module =>l_log_module);
954: trace
955: (p_msg => 'security_id_int_3 = '||
956: xla_events_pub_pkg.g_security.security_id_int_3
957: ,p_level => C_LEVEL_PROCEDURE
958: ,p_module =>l_log_module);
959: trace
960: (p_msg => 'security_id_char_1 = '||

Line 961: xla_events_pub_pkg.g_security.security_id_char_1

957: ,p_level => C_LEVEL_PROCEDURE
958: ,p_module =>l_log_module);
959: trace
960: (p_msg => 'security_id_char_1 = '||
961: xla_events_pub_pkg.g_security.security_id_char_1
962: ,p_level => C_LEVEL_PROCEDURE
963: ,p_module =>l_log_module);
964: trace
965: (p_msg => 'security_id_char_2 = '||

Line 966: xla_events_pub_pkg.g_security.security_id_char_2

962: ,p_level => C_LEVEL_PROCEDURE
963: ,p_module =>l_log_module);
964: trace
965: (p_msg => 'security_id_char_2 = '||
966: xla_events_pub_pkg.g_security.security_id_char_2
967: ,p_level => C_LEVEL_PROCEDURE
968: ,p_module =>l_log_module);
969: trace
970: (p_msg => 'security_id_char_3 = '||

Line 971: xla_events_pub_pkg.g_security.security_id_char_3

967: ,p_level => C_LEVEL_PROCEDURE
968: ,p_module =>l_log_module);
969: trace
970: (p_msg => 'security_id_char_3 = '||
971: xla_events_pub_pkg.g_security.security_id_char_3
972: ,p_level => C_LEVEL_PROCEDURE
973: ,p_module =>l_log_module);
974: END IF;
975:

Line 1149: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

1145: --
1146: --=============================================================================
1147:
1148: PROCEDURE update_event_status
1149: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
1150: ,p_valuation_method IN VARCHAR2
1151: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
1152: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
1153: ,p_event_date IN DATE DEFAULT NULL

Line 1257: xla_events_pub_pkg.g_security.security_id_int_1

1253: ,p_level => C_LEVEL_PROCEDURE
1254: ,p_module =>l_log_module);
1255: trace
1256: (p_msg => 'security_id_int_1 = '||
1257: xla_events_pub_pkg.g_security.security_id_int_1
1258: ,p_level => C_LEVEL_PROCEDURE
1259: ,p_module =>l_log_module);
1260: trace
1261: (p_msg => 'security_id_int_2 = '||

Line 1262: xla_events_pub_pkg.g_security.security_id_int_2

1258: ,p_level => C_LEVEL_PROCEDURE
1259: ,p_module =>l_log_module);
1260: trace
1261: (p_msg => 'security_id_int_2 = '||
1262: xla_events_pub_pkg.g_security.security_id_int_2
1263: ,p_level => C_LEVEL_PROCEDURE
1264: ,p_module =>l_log_module);
1265: trace
1266: (p_msg => 'security_id_int_3 = '||

Line 1267: xla_events_pub_pkg.g_security.security_id_int_3

1263: ,p_level => C_LEVEL_PROCEDURE
1264: ,p_module =>l_log_module);
1265: trace
1266: (p_msg => 'security_id_int_3 = '||
1267: xla_events_pub_pkg.g_security.security_id_int_3
1268: ,p_level => C_LEVEL_PROCEDURE
1269: ,p_module =>l_log_module);
1270: trace
1271: (p_msg => 'security_id_char_1 = '||

Line 1272: xla_events_pub_pkg.g_security.security_id_char_1

1268: ,p_level => C_LEVEL_PROCEDURE
1269: ,p_module =>l_log_module);
1270: trace
1271: (p_msg => 'security_id_char_1 = '||
1272: xla_events_pub_pkg.g_security.security_id_char_1
1273: ,p_level => C_LEVEL_PROCEDURE
1274: ,p_module =>l_log_module);
1275: trace
1276: (p_msg => 'security_id_char_2 = '||

Line 1277: xla_events_pub_pkg.g_security.security_id_char_2

1273: ,p_level => C_LEVEL_PROCEDURE
1274: ,p_module =>l_log_module);
1275: trace
1276: (p_msg => 'security_id_char_2 = '||
1277: xla_events_pub_pkg.g_security.security_id_char_2
1278: ,p_level => C_LEVEL_PROCEDURE
1279: ,p_module =>l_log_module);
1280: trace
1281: (p_msg => 'security_id_char_3 = '||

Line 1282: xla_events_pub_pkg.g_security.security_id_char_3

1278: ,p_level => C_LEVEL_PROCEDURE
1279: ,p_module =>l_log_module);
1280: trace
1281: (p_msg => 'security_id_char_3 = '||
1282: xla_events_pub_pkg.g_security.security_id_char_3
1283: ,p_level => C_LEVEL_PROCEDURE
1284: ,p_module =>l_log_module);
1285: trace
1286: (p_msg => 'valuation_method = '||p_valuation_method

Line 1384: WHERE event_status_code NOT IN (xla_events_pub_pkg.C_EVENT_PROCESSED,

1380: if(g_gapless_flag='N') then
1381: SELECT event_id BULK COLLECT
1382: INTO l_array_events
1383: FROM xla_events
1384: WHERE event_status_code NOT IN (xla_events_pub_pkg.C_EVENT_PROCESSED,
1385: xla_events_pub_pkg.C_EVENT_NOACTION) -- Bug 9197871
1386: AND event_date = NVL(l_event_date, event_date)
1387: AND event_type_code = NVL(p_event_type_code, event_type_code)
1388: AND entity_id = g_entity_id

Line 1385: xla_events_pub_pkg.C_EVENT_NOACTION) -- Bug 9197871

1381: SELECT event_id BULK COLLECT
1382: INTO l_array_events
1383: FROM xla_events
1384: WHERE event_status_code NOT IN (xla_events_pub_pkg.C_EVENT_PROCESSED,
1385: xla_events_pub_pkg.C_EVENT_NOACTION) -- Bug 9197871
1386: AND event_date = NVL(l_event_date, event_date)
1387: AND event_type_code = NVL(p_event_type_code, event_type_code)
1388: AND entity_id = g_entity_id
1389: AND application_id = g_application_id -- 8967771

Line 1407: WHERE event_status_code NOT IN (xla_events_pub_pkg.C_EVENT_PROCESSED,

1403: l_array_event_status,
1404: l_array_on_hold_flag,
1405: l_array_event_number
1406: FROM xla_events
1407: WHERE event_status_code NOT IN (xla_events_pub_pkg.C_EVENT_PROCESSED,
1408: xla_events_pub_pkg.C_EVENT_NOACTION) -- Bug 9197871
1409: AND event_date = NVL(l_event_date, event_date)
1410: AND event_type_code = NVL(p_event_type_code, event_type_code)
1411: AND entity_id = g_entity_id

Line 1408: xla_events_pub_pkg.C_EVENT_NOACTION) -- Bug 9197871

1404: l_array_on_hold_flag,
1405: l_array_event_number
1406: FROM xla_events
1407: WHERE event_status_code NOT IN (xla_events_pub_pkg.C_EVENT_PROCESSED,
1408: xla_events_pub_pkg.C_EVENT_NOACTION) -- Bug 9197871
1409: AND event_date = NVL(l_event_date, event_date)
1410: AND event_type_code = NVL(p_event_type_code, event_type_code)
1411: AND entity_id = g_entity_id
1412: AND application_id = g_application_id -- 8967771

Line 1564: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

1560: --
1561: --=============================================================================
1562:
1563: PROCEDURE update_event
1564: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
1565: ,p_valuation_method IN VARCHAR2
1566: ,p_event_id IN INTEGER
1567: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
1568: ,p_event_date IN DATE DEFAULT NULL

Line 1572: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

1568: ,p_event_date IN DATE DEFAULT NULL
1569: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
1570: ,p_transaction_date IN DATE DEFAULT NULL
1571: ,p_event_number IN INTEGER DEFAULT NULL
1572: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
1573: DEFAULT NULL
1574: ,p_overwrite_event_num IN VARCHAR2 DEFAULT 'N'
1575: ,p_overwrite_ref_info IN VARCHAR2 DEFAULT 'N') IS
1576: l_event_date DATE;

Line 1692: xla_events_pub_pkg.g_security.security_id_int_1

1688: ,p_level => C_LEVEL_PROCEDURE
1689: ,p_module =>l_log_module);
1690: trace
1691: (p_msg => 'security_id_int_1 = '||
1692: xla_events_pub_pkg.g_security.security_id_int_1
1693: ,p_level => C_LEVEL_PROCEDURE
1694: ,p_module =>l_log_module);
1695: trace
1696: (p_msg => 'security_id_int_2 = '||

Line 1697: xla_events_pub_pkg.g_security.security_id_int_2

1693: ,p_level => C_LEVEL_PROCEDURE
1694: ,p_module =>l_log_module);
1695: trace
1696: (p_msg => 'security_id_int_2 = '||
1697: xla_events_pub_pkg.g_security.security_id_int_2
1698: ,p_level => C_LEVEL_PROCEDURE
1699: ,p_module =>l_log_module);
1700: trace
1701: (p_msg => 'security_id_int_3 = '||

Line 1702: xla_events_pub_pkg.g_security.security_id_int_3

1698: ,p_level => C_LEVEL_PROCEDURE
1699: ,p_module =>l_log_module);
1700: trace
1701: (p_msg => 'security_id_int_3 = '||
1702: xla_events_pub_pkg.g_security.security_id_int_3
1703: ,p_level => C_LEVEL_PROCEDURE
1704: ,p_module =>l_log_module);
1705: trace
1706: (p_msg => 'security_id_char_1 = '||

Line 1707: xla_events_pub_pkg.g_security.security_id_char_1

1703: ,p_level => C_LEVEL_PROCEDURE
1704: ,p_module =>l_log_module);
1705: trace
1706: (p_msg => 'security_id_char_1 = '||
1707: xla_events_pub_pkg.g_security.security_id_char_1
1708: ,p_level => C_LEVEL_PROCEDURE
1709: ,p_module =>l_log_module);
1710: trace
1711: (p_msg => 'security_id_char_2 = '||

Line 1712: xla_events_pub_pkg.g_security.security_id_char_2

1708: ,p_level => C_LEVEL_PROCEDURE
1709: ,p_module =>l_log_module);
1710: trace
1711: (p_msg => 'security_id_char_2 = '||
1712: xla_events_pub_pkg.g_security.security_id_char_2
1713: ,p_level => C_LEVEL_PROCEDURE
1714: ,p_module =>l_log_module);
1715: trace
1716: (p_msg => 'security_id_char_3 = '||

Line 1717: xla_events_pub_pkg.g_security.security_id_char_3

1713: ,p_level => C_LEVEL_PROCEDURE
1714: ,p_module =>l_log_module);
1715: trace
1716: (p_msg => 'security_id_char_3 = '||
1717: xla_events_pub_pkg.g_security.security_id_char_3
1718: ,p_level => C_LEVEL_PROCEDURE
1719: ,p_module =>l_log_module);
1720: trace
1721: (p_msg => 'valuation_method = '||p_valuation_method

Line 1867: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

1863: into l_old_event_status_code, l_old_on_hold_flag, l_old_event_number
1864: from xla_events
1865: WHERE event_id = p_event_id
1866: AND entity_id = g_entity_id
1867: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
1868: AND application_id = g_application_id -- 8967771
1869: ;
1870: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1871: trace

Line 1939: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

1935: ,program_id = xla_environment_pkg.g_prog_id
1936: ,request_id = xla_environment_pkg.g_Req_Id
1937: WHERE event_id = p_event_id
1938: AND entity_id = g_entity_id
1939: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
1940: AND application_id = g_application_id -- 8967771
1941: ;
1942:
1943: IF SQL%ROWCOUNT <> 1 THEN

Line 1973: and event_status_code<> xla_events_pub_pkg.C_EVENT_PROCESSED

1969: if(l_old_event_status_code<>'I') then
1970: update xla_events
1971: set on_hold_flag='Y'
1972: where entity_id=g_entity_id
1973: and event_status_code<> xla_events_pub_pkg.C_EVENT_PROCESSED
1974: and event_number>l_old_event_number
1975: AND application_id = g_application_id -- 8967771
1976: ;
1977: else

Line 2118: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

2114: --
2115: --=============================================================================
2116:
2117: PROCEDURE update_manual_event
2118: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
2119: ,p_event_id IN INTEGER
2120: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
2121: ,p_event_date IN DATE DEFAULT NULL
2122: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 2125: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

2121: ,p_event_date IN DATE DEFAULT NULL
2122: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
2123: ,p_process_status_code IN VARCHAR2 DEFAULT NULL
2124: ,p_event_number IN INTEGER DEFAULT NULL
2125: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
2126: DEFAULT NULL
2127: ,p_overwrite_event_num IN VARCHAR2 DEFAULT 'N'
2128: ,p_overwrite_ref_info IN VARCHAR2 DEFAULT 'N') IS
2129: l_event_date DATE;

Line 2243: xla_events_pub_pkg.g_security.security_id_int_1

2239: ,p_level => C_LEVEL_PROCEDURE
2240: ,p_module =>l_log_module);
2241: trace
2242: (p_msg => 'security_id_int_1 = '||
2243: xla_events_pub_pkg.g_security.security_id_int_1
2244: ,p_level => C_LEVEL_PROCEDURE
2245: ,p_module =>l_log_module);
2246: trace
2247: (p_msg => 'security_id_int_2 = '||

Line 2248: xla_events_pub_pkg.g_security.security_id_int_2

2244: ,p_level => C_LEVEL_PROCEDURE
2245: ,p_module =>l_log_module);
2246: trace
2247: (p_msg => 'security_id_int_2 = '||
2248: xla_events_pub_pkg.g_security.security_id_int_2
2249: ,p_level => C_LEVEL_PROCEDURE
2250: ,p_module =>l_log_module);
2251: trace
2252: (p_msg => 'security_id_int_3 = '||

Line 2253: xla_events_pub_pkg.g_security.security_id_int_3

2249: ,p_level => C_LEVEL_PROCEDURE
2250: ,p_module =>l_log_module);
2251: trace
2252: (p_msg => 'security_id_int_3 = '||
2253: xla_events_pub_pkg.g_security.security_id_int_3
2254: ,p_level => C_LEVEL_PROCEDURE
2255: ,p_module =>l_log_module);
2256: trace
2257: (p_msg => 'security_id_char_1 = '||

Line 2258: xla_events_pub_pkg.g_security.security_id_char_1

2254: ,p_level => C_LEVEL_PROCEDURE
2255: ,p_module =>l_log_module);
2256: trace
2257: (p_msg => 'security_id_char_1 = '||
2258: xla_events_pub_pkg.g_security.security_id_char_1
2259: ,p_level => C_LEVEL_PROCEDURE
2260: ,p_module =>l_log_module);
2261: trace
2262: (p_msg => 'security_id_char_2 = '||

Line 2263: xla_events_pub_pkg.g_security.security_id_char_2

2259: ,p_level => C_LEVEL_PROCEDURE
2260: ,p_module =>l_log_module);
2261: trace
2262: (p_msg => 'security_id_char_2 = '||
2263: xla_events_pub_pkg.g_security.security_id_char_2
2264: ,p_level => C_LEVEL_PROCEDURE
2265: ,p_module =>l_log_module);
2266: trace
2267: (p_msg => 'security_id_char_3 = '||

Line 2268: xla_events_pub_pkg.g_security.security_id_char_3

2264: ,p_level => C_LEVEL_PROCEDURE
2265: ,p_module =>l_log_module);
2266: trace
2267: (p_msg => 'security_id_char_3 = '||
2268: xla_events_pub_pkg.g_security.security_id_char_3
2269: ,p_level => C_LEVEL_PROCEDURE
2270: ,p_module =>l_log_module);
2271: END IF;
2272:

Line 2414: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

2410: ,program_id = xla_environment_pkg.g_prog_id
2411: ,request_id = xla_environment_pkg.g_Req_Id
2412: WHERE event_id = p_event_id
2413: AND entity_id = g_entity_id
2414: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
2415: AND application_id = g_application_id -- 8967771
2416: ;
2417:
2418: l_rowcount := SQL%ROWCOUNT;

Line 2465: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

2461: --
2462: --=============================================================================
2463:
2464: PROCEDURE delete_event
2465: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
2466: ,p_valuation_method IN VARCHAR2
2467: ,p_event_id IN INTEGER) IS
2468: l_on_hold_flag xla_events.on_hold_flag%type;
2469: l_event_status_code xla_events.event_status_code%type;

Line 2556: xla_events_pub_pkg.g_security.security_id_int_1

2552: ,p_level => C_LEVEL_PROCEDURE
2553: ,p_module =>l_log_module);
2554: trace
2555: (p_msg => 'security_id_int_1 = '||
2556: xla_events_pub_pkg.g_security.security_id_int_1
2557: ,p_level => C_LEVEL_PROCEDURE
2558: ,p_module =>l_log_module);
2559: trace
2560: (p_msg => 'security_id_int_2 = '||

Line 2561: xla_events_pub_pkg.g_security.security_id_int_2

2557: ,p_level => C_LEVEL_PROCEDURE
2558: ,p_module =>l_log_module);
2559: trace
2560: (p_msg => 'security_id_int_2 = '||
2561: xla_events_pub_pkg.g_security.security_id_int_2
2562: ,p_level => C_LEVEL_PROCEDURE
2563: ,p_module =>l_log_module);
2564: trace
2565: (p_msg => 'security_id_int_3 = '||

Line 2566: xla_events_pub_pkg.g_security.security_id_int_3

2562: ,p_level => C_LEVEL_PROCEDURE
2563: ,p_module =>l_log_module);
2564: trace
2565: (p_msg => 'security_id_int_3 = '||
2566: xla_events_pub_pkg.g_security.security_id_int_3
2567: ,p_level => C_LEVEL_PROCEDURE
2568: ,p_module =>l_log_module);
2569: trace
2570: (p_msg => 'security_id_char_1 = '||

Line 2571: xla_events_pub_pkg.g_security.security_id_char_1

2567: ,p_level => C_LEVEL_PROCEDURE
2568: ,p_module =>l_log_module);
2569: trace
2570: (p_msg => 'security_id_char_1 = '||
2571: xla_events_pub_pkg.g_security.security_id_char_1
2572: ,p_level => C_LEVEL_PROCEDURE
2573: ,p_module =>l_log_module);
2574: trace
2575: (p_msg => 'security_id_char_2 = '||

Line 2576: xla_events_pub_pkg.g_security.security_id_char_2

2572: ,p_level => C_LEVEL_PROCEDURE
2573: ,p_module =>l_log_module);
2574: trace
2575: (p_msg => 'security_id_char_2 = '||
2576: xla_events_pub_pkg.g_security.security_id_char_2
2577: ,p_level => C_LEVEL_PROCEDURE
2578: ,p_module =>l_log_module);
2579: trace
2580: (p_msg => 'security_id_char_3 = '||

Line 2581: xla_events_pub_pkg.g_security.security_id_char_3

2577: ,p_level => C_LEVEL_PROCEDURE
2578: ,p_module =>l_log_module);
2579: trace
2580: (p_msg => 'security_id_char_3 = '||
2581: xla_events_pub_pkg.g_security.security_id_char_3
2582: ,p_level => C_LEVEL_PROCEDURE
2583: ,p_module =>l_log_module);
2584: trace
2585: (p_msg => 'valuation_method = '||p_valuation_method

Line 2671: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

2667: into l_on_hold_flag, l_event_status_code, l_event_number
2668: from xla_events
2669: WHERE event_id = p_event_id
2670: AND entity_id = g_entity_id
2671: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
2672: AND application_id = g_application_id -- 8967771
2673: ;
2674: exception when others then
2675: xla_exceptions_pkg.raise_message

Line 2693: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

2689: ----------------------------------------------------------------------------
2690: DELETE xla_events
2691: WHERE event_id = p_event_id
2692: AND entity_id = g_entity_id
2693: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
2694: AND application_id = g_application_id -- 8967771
2695: ;
2696:
2697: l_rowcount := SQL%ROWCOUNT;

Line 2779: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

2775: --
2776: --=============================================================================
2777:
2778: PROCEDURE delete_processed_event
2779: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
2780: ,p_event_id IN INTEGER) IS
2781: l_log_module VARCHAR2(240);
2782: l_rowcount NUMBER;
2783: BEGIN

Line 2866: xla_events_pub_pkg.g_security.security_id_int_1

2862: ,p_level => C_LEVEL_PROCEDURE
2863: ,p_module =>l_log_module);
2864: trace
2865: (p_msg => 'security_id_int_1 = '||
2866: xla_events_pub_pkg.g_security.security_id_int_1
2867: ,p_level => C_LEVEL_PROCEDURE
2868: ,p_module =>l_log_module);
2869: trace
2870: (p_msg => 'security_id_int_2 = '||

Line 2871: xla_events_pub_pkg.g_security.security_id_int_2

2867: ,p_level => C_LEVEL_PROCEDURE
2868: ,p_module =>l_log_module);
2869: trace
2870: (p_msg => 'security_id_int_2 = '||
2871: xla_events_pub_pkg.g_security.security_id_int_2
2872: ,p_level => C_LEVEL_PROCEDURE
2873: ,p_module =>l_log_module);
2874: trace
2875: (p_msg => 'security_id_int_3 = '||

Line 2876: xla_events_pub_pkg.g_security.security_id_int_3

2872: ,p_level => C_LEVEL_PROCEDURE
2873: ,p_module =>l_log_module);
2874: trace
2875: (p_msg => 'security_id_int_3 = '||
2876: xla_events_pub_pkg.g_security.security_id_int_3
2877: ,p_level => C_LEVEL_PROCEDURE
2878: ,p_module =>l_log_module);
2879: trace
2880: (p_msg => 'security_id_char_1 = '||

Line 2881: xla_events_pub_pkg.g_security.security_id_char_1

2877: ,p_level => C_LEVEL_PROCEDURE
2878: ,p_module =>l_log_module);
2879: trace
2880: (p_msg => 'security_id_char_1 = '||
2881: xla_events_pub_pkg.g_security.security_id_char_1
2882: ,p_level => C_LEVEL_PROCEDURE
2883: ,p_module =>l_log_module);
2884: trace
2885: (p_msg => 'security_id_char_2 = '||

Line 2886: xla_events_pub_pkg.g_security.security_id_char_2

2882: ,p_level => C_LEVEL_PROCEDURE
2883: ,p_module =>l_log_module);
2884: trace
2885: (p_msg => 'security_id_char_2 = '||
2886: xla_events_pub_pkg.g_security.security_id_char_2
2887: ,p_level => C_LEVEL_PROCEDURE
2888: ,p_module =>l_log_module);
2889: trace
2890: (p_msg => 'security_id_char_3 = '||

Line 2891: xla_events_pub_pkg.g_security.security_id_char_3

2887: ,p_level => C_LEVEL_PROCEDURE
2888: ,p_module =>l_log_module);
2889: trace
2890: (p_msg => 'security_id_char_3 = '||
2891: xla_events_pub_pkg.g_security.security_id_char_3
2892: ,p_level => C_LEVEL_PROCEDURE
2893: ,p_module =>l_log_module);
2894: END IF;
2895:

Line 2983: AND event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED

2979: ----------------------------------------------------------------------------
2980: DELETE xla_events
2981: WHERE event_id = p_event_id
2982: AND entity_id = g_entity_id
2983: AND event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
2984: AND application_id = g_application_id -- 8967771
2985: ;
2986:
2987: l_rowcount := SQL%ROWCOUNT;

Line 3056: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

3052: --
3053: --=============================================================================
3054:
3055: FUNCTION delete_events
3056: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
3057: ,p_valuation_method IN VARCHAR2
3058: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
3059: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
3060: ,p_event_date IN DATE DEFAULT NULL)

Line 3157: xla_events_pub_pkg.g_security.security_id_int_1

3153: ,p_level => C_LEVEL_PROCEDURE
3154: ,p_module =>l_log_module);
3155: trace
3156: (p_msg => 'security_id_int_1 = '||
3157: xla_events_pub_pkg.g_security.security_id_int_1
3158: ,p_level => C_LEVEL_PROCEDURE
3159: ,p_module =>l_log_module);
3160: trace
3161: (p_msg => 'security_id_int_2 = '||

Line 3162: xla_events_pub_pkg.g_security.security_id_int_2

3158: ,p_level => C_LEVEL_PROCEDURE
3159: ,p_module =>l_log_module);
3160: trace
3161: (p_msg => 'security_id_int_2 = '||
3162: xla_events_pub_pkg.g_security.security_id_int_2
3163: ,p_level => C_LEVEL_PROCEDURE
3164: ,p_module =>l_log_module);
3165: trace
3166: (p_msg => 'security_id_int_3 = '||

Line 3167: xla_events_pub_pkg.g_security.security_id_int_3

3163: ,p_level => C_LEVEL_PROCEDURE
3164: ,p_module =>l_log_module);
3165: trace
3166: (p_msg => 'security_id_int_3 = '||
3167: xla_events_pub_pkg.g_security.security_id_int_3
3168: ,p_level => C_LEVEL_PROCEDURE
3169: ,p_module =>l_log_module);
3170: trace
3171: (p_msg => 'security_id_char_1 = '||

Line 3172: xla_events_pub_pkg.g_security.security_id_char_1

3168: ,p_level => C_LEVEL_PROCEDURE
3169: ,p_module =>l_log_module);
3170: trace
3171: (p_msg => 'security_id_char_1 = '||
3172: xla_events_pub_pkg.g_security.security_id_char_1
3173: ,p_level => C_LEVEL_PROCEDURE
3174: ,p_module =>l_log_module);
3175: trace
3176: (p_msg => 'security_id_char_2 = '||

Line 3177: xla_events_pub_pkg.g_security.security_id_char_2

3173: ,p_level => C_LEVEL_PROCEDURE
3174: ,p_module =>l_log_module);
3175: trace
3176: (p_msg => 'security_id_char_2 = '||
3177: xla_events_pub_pkg.g_security.security_id_char_2
3178: ,p_level => C_LEVEL_PROCEDURE
3179: ,p_module =>l_log_module);
3180: trace
3181: (p_msg => 'security_id_char_3 = '||

Line 3182: xla_events_pub_pkg.g_security.security_id_char_3

3178: ,p_level => C_LEVEL_PROCEDURE
3179: ,p_module =>l_log_module);
3180: trace
3181: (p_msg => 'security_id_char_3 = '||
3182: xla_events_pub_pkg.g_security.security_id_char_3
3183: ,p_level => C_LEVEL_PROCEDURE
3184: ,p_module =>l_log_module);
3185: trace
3186: (p_msg => 'valuation_method = '||p_valuation_method

Line 3266: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

3262: SELECT event_id BULK COLLECT
3263: INTO l_array_events
3264: FROM xla_events
3265: WHERE event_date = NVL(l_event_date, event_date)
3266: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
3267: AND event_type_code = NVL(p_event_type_code, event_type_code)
3268: AND entity_id = g_entity_id
3269: AND application_id = g_application_id -- 8967771
3270: AND event_type_code IN

Line 3282: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

3278: SELECT event_id, event_number BULK COLLECT
3279: INTO l_array_events, g_gapless_event_number
3280: FROM xla_events
3281: WHERE event_date = NVL(l_event_date, event_date)
3282: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
3283: AND event_type_code = NVL(p_event_type_code, event_type_code)
3284: AND entity_id = g_entity_id
3285: AND application_id = g_application_id -- 8967771
3286: AND event_type_code IN

Line 3375: (p_source_info IN xla_events_pub_pkg.t_event_source_info

3371: --
3372: --============================================================================
3373:
3374: FUNCTION delete_entity
3375: (p_source_info IN xla_events_pub_pkg.t_event_source_info
3376: ,p_valuation_method IN VARCHAR2)
3377: RETURN INTEGER IS
3378:
3379: l_log_module VARCHAR2(240);

Line 3455: xla_events_pub_pkg.g_security.security_id_int_1

3451: ,p_level => C_LEVEL_PROCEDURE
3452: ,p_module =>l_log_module);
3453: trace
3454: (p_msg => 'security_id_int_1 = '||
3455: xla_events_pub_pkg.g_security.security_id_int_1
3456: ,p_level => C_LEVEL_PROCEDURE
3457: ,p_module =>l_log_module);
3458: trace
3459: (p_msg => 'security_id_int_2 = '||

Line 3460: xla_events_pub_pkg.g_security.security_id_int_2

3456: ,p_level => C_LEVEL_PROCEDURE
3457: ,p_module =>l_log_module);
3458: trace
3459: (p_msg => 'security_id_int_2 = '||
3460: xla_events_pub_pkg.g_security.security_id_int_2
3461: ,p_level => C_LEVEL_PROCEDURE
3462: ,p_module =>l_log_module);
3463: trace
3464: (p_msg => 'security_id_int_3 = '||

Line 3465: xla_events_pub_pkg.g_security.security_id_int_3

3461: ,p_level => C_LEVEL_PROCEDURE
3462: ,p_module =>l_log_module);
3463: trace
3464: (p_msg => 'security_id_int_3 = '||
3465: xla_events_pub_pkg.g_security.security_id_int_3
3466: ,p_level => C_LEVEL_PROCEDURE
3467: ,p_module =>l_log_module);
3468: trace
3469: (p_msg => 'security_id_char_1 = '||

Line 3470: xla_events_pub_pkg.g_security.security_id_char_1

3466: ,p_level => C_LEVEL_PROCEDURE
3467: ,p_module =>l_log_module);
3468: trace
3469: (p_msg => 'security_id_char_1 = '||
3470: xla_events_pub_pkg.g_security.security_id_char_1
3471: ,p_level => C_LEVEL_PROCEDURE
3472: ,p_module =>l_log_module);
3473: trace
3474: (p_msg => 'security_id_char_2 = '||

Line 3475: xla_events_pub_pkg.g_security.security_id_char_2

3471: ,p_level => C_LEVEL_PROCEDURE
3472: ,p_module =>l_log_module);
3473: trace
3474: (p_msg => 'security_id_char_2 = '||
3475: xla_events_pub_pkg.g_security.security_id_char_2
3476: ,p_level => C_LEVEL_PROCEDURE
3477: ,p_module =>l_log_module);
3478: trace
3479: (p_msg => 'security_id_char_3 = '||

Line 3480: xla_events_pub_pkg.g_security.security_id_char_3

3476: ,p_level => C_LEVEL_PROCEDURE
3477: ,p_module =>l_log_module);
3478: trace
3479: (p_msg => 'security_id_char_3 = '||
3480: xla_events_pub_pkg.g_security.security_id_char_3
3481: ,p_level => C_LEVEL_PROCEDURE
3482: ,p_module =>l_log_module);
3483: trace
3484: (p_msg => 'valuation_method = '||p_valuation_method

Line 3529: NVL(xla_events_pub_pkg.g_security.security_id_int_1,-99)

3525: NVL(p_source_info.source_id_char_4,' ')
3526: AND NVL(a.valuation_method,C_CHAR) =
3527: NVL(p_valuation_method,C_CHAR)
3528: AND NVL(a.security_id_int_1,-99) =
3529: NVL(xla_events_pub_pkg.g_security.security_id_int_1,-99)
3530: AND NVL(a.security_id_int_2,-99) =
3531: NVL(xla_events_pub_pkg.g_security.security_id_int_2,-99)
3532: AND NVL(a.security_id_int_3,-99) =
3533: NVL(xla_events_pub_pkg.g_security.security_id_int_3,-99)

Line 3531: NVL(xla_events_pub_pkg.g_security.security_id_int_2,-99)

3527: NVL(p_valuation_method,C_CHAR)
3528: AND NVL(a.security_id_int_1,-99) =
3529: NVL(xla_events_pub_pkg.g_security.security_id_int_1,-99)
3530: AND NVL(a.security_id_int_2,-99) =
3531: NVL(xla_events_pub_pkg.g_security.security_id_int_2,-99)
3532: AND NVL(a.security_id_int_3,-99) =
3533: NVL(xla_events_pub_pkg.g_security.security_id_int_3,-99)
3534: AND NVL(a.security_id_char_1,' ') =
3535: NVL(xla_events_pub_pkg.g_security.security_id_char_1,' ')

Line 3533: NVL(xla_events_pub_pkg.g_security.security_id_int_3,-99)

3529: NVL(xla_events_pub_pkg.g_security.security_id_int_1,-99)
3530: AND NVL(a.security_id_int_2,-99) =
3531: NVL(xla_events_pub_pkg.g_security.security_id_int_2,-99)
3532: AND NVL(a.security_id_int_3,-99) =
3533: NVL(xla_events_pub_pkg.g_security.security_id_int_3,-99)
3534: AND NVL(a.security_id_char_1,' ') =
3535: NVL(xla_events_pub_pkg.g_security.security_id_char_1,' ')
3536: AND NVL(a.security_id_char_2,' ') =
3537: NVL(xla_events_pub_pkg.g_security.security_id_char_2,' ')

Line 3535: NVL(xla_events_pub_pkg.g_security.security_id_char_1,' ')

3531: NVL(xla_events_pub_pkg.g_security.security_id_int_2,-99)
3532: AND NVL(a.security_id_int_3,-99) =
3533: NVL(xla_events_pub_pkg.g_security.security_id_int_3,-99)
3534: AND NVL(a.security_id_char_1,' ') =
3535: NVL(xla_events_pub_pkg.g_security.security_id_char_1,' ')
3536: AND NVL(a.security_id_char_2,' ') =
3537: NVL(xla_events_pub_pkg.g_security.security_id_char_2,' ')
3538: AND NVL(a.security_id_char_3,' ') =
3539: NVL(xla_events_pub_pkg.g_security.security_id_char_3,' ');

Line 3537: NVL(xla_events_pub_pkg.g_security.security_id_char_2,' ')

3533: NVL(xla_events_pub_pkg.g_security.security_id_int_3,-99)
3534: AND NVL(a.security_id_char_1,' ') =
3535: NVL(xla_events_pub_pkg.g_security.security_id_char_1,' ')
3536: AND NVL(a.security_id_char_2,' ') =
3537: NVL(xla_events_pub_pkg.g_security.security_id_char_2,' ')
3538: AND NVL(a.security_id_char_3,' ') =
3539: NVL(xla_events_pub_pkg.g_security.security_id_char_3,' ');
3540: EXCEPTION when others then
3541: xla_exceptions_pkg.raise_message

Line 3539: NVL(xla_events_pub_pkg.g_security.security_id_char_3,' ');

3535: NVL(xla_events_pub_pkg.g_security.security_id_char_1,' ')
3536: AND NVL(a.security_id_char_2,' ') =
3537: NVL(xla_events_pub_pkg.g_security.security_id_char_2,' ')
3538: AND NVL(a.security_id_char_3,' ') =
3539: NVL(xla_events_pub_pkg.g_security.security_id_char_3,' ');
3540: EXCEPTION when others then
3541: xla_exceptions_pkg.raise_message
3542: (p_appli_s_name => 'XLA'
3543: ,p_msg_name => 'XLA_COMMON_ERROR'

Line 3610: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info) IS

3606: --
3607: --=============================================================================
3608:
3609: PROCEDURE purge_entity
3610: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info) IS
3611: BEGIN
3612: trace('> xla_events_pkg.delete_entity' , 20);
3613:
3614: SAVEPOINT before_entity_delete;

Line 3671: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

3667: --
3668: --=============================================================================
3669:
3670: FUNCTION get_event_info
3671: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
3672: ,p_valuation_method IN VARCHAR2
3673: ,p_event_id IN INTEGER)
3674: RETURN xla_events_pub_pkg.t_event_info IS
3675:

Line 3674: RETURN xla_events_pub_pkg.t_event_info IS

3670: FUNCTION get_event_info
3671: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
3672: ,p_valuation_method IN VARCHAR2
3673: ,p_event_id IN INTEGER)
3674: RETURN xla_events_pub_pkg.t_event_info IS
3675:
3676: l_event_info xla_events_pub_pkg.t_event_info;
3677: l_log_module VARCHAR2(240);
3678:

Line 3676: l_event_info xla_events_pub_pkg.t_event_info;

3672: ,p_valuation_method IN VARCHAR2
3673: ,p_event_id IN INTEGER)
3674: RETURN xla_events_pub_pkg.t_event_info IS
3675:
3676: l_event_info xla_events_pub_pkg.t_event_info;
3677: l_log_module VARCHAR2(240);
3678:
3679: BEGIN
3680: IF g_log_enabled THEN

Line 3762: xla_events_pub_pkg.g_security.security_id_int_1

3758: ,p_level => C_LEVEL_PROCEDURE
3759: ,p_module =>l_log_module);
3760: trace
3761: (p_msg => 'security_id_int_1 = '||
3762: xla_events_pub_pkg.g_security.security_id_int_1
3763: ,p_level => C_LEVEL_PROCEDURE
3764: ,p_module =>l_log_module);
3765: trace
3766: (p_msg => 'security_id_int_2 = '||

Line 3767: xla_events_pub_pkg.g_security.security_id_int_2

3763: ,p_level => C_LEVEL_PROCEDURE
3764: ,p_module =>l_log_module);
3765: trace
3766: (p_msg => 'security_id_int_2 = '||
3767: xla_events_pub_pkg.g_security.security_id_int_2
3768: ,p_level => C_LEVEL_PROCEDURE
3769: ,p_module =>l_log_module);
3770: trace
3771: (p_msg => 'security_id_int_3 = '||

Line 3772: xla_events_pub_pkg.g_security.security_id_int_3

3768: ,p_level => C_LEVEL_PROCEDURE
3769: ,p_module =>l_log_module);
3770: trace
3771: (p_msg => 'security_id_int_3 = '||
3772: xla_events_pub_pkg.g_security.security_id_int_3
3773: ,p_level => C_LEVEL_PROCEDURE
3774: ,p_module =>l_log_module);
3775: trace
3776: (p_msg => 'security_id_char_1 = '||

Line 3777: xla_events_pub_pkg.g_security.security_id_char_1

3773: ,p_level => C_LEVEL_PROCEDURE
3774: ,p_module =>l_log_module);
3775: trace
3776: (p_msg => 'security_id_char_1 = '||
3777: xla_events_pub_pkg.g_security.security_id_char_1
3778: ,p_level => C_LEVEL_PROCEDURE
3779: ,p_module =>l_log_module);
3780: trace
3781: (p_msg => 'security_id_char_2 = '||

Line 3782: xla_events_pub_pkg.g_security.security_id_char_2

3778: ,p_level => C_LEVEL_PROCEDURE
3779: ,p_module =>l_log_module);
3780: trace
3781: (p_msg => 'security_id_char_2 = '||
3782: xla_events_pub_pkg.g_security.security_id_char_2
3783: ,p_level => C_LEVEL_PROCEDURE
3784: ,p_module =>l_log_module);
3785: trace
3786: (p_msg => 'security_id_char_3 = '||

Line 3787: xla_events_pub_pkg.g_security.security_id_char_3

3783: ,p_level => C_LEVEL_PROCEDURE
3784: ,p_module =>l_log_module);
3785: trace
3786: (p_msg => 'security_id_char_3 = '||
3787: xla_events_pub_pkg.g_security.security_id_char_3
3788: ,p_level => C_LEVEL_PROCEDURE
3789: ,p_module =>l_log_module);
3790: trace
3791: (p_msg => 'valuation_method = '||p_valuation_method

Line 3937: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

3933: --
3934: --=============================================================================
3935:
3936: FUNCTION get_event_status
3937: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
3938: ,p_valuation_method IN VARCHAR2
3939: ,p_event_id IN INTEGER)
3940: RETURN VARCHAR2 IS
3941:

Line 3942: l_event_info xla_events_pub_pkg.t_event_info;

3938: ,p_valuation_method IN VARCHAR2
3939: ,p_event_id IN INTEGER)
3940: RETURN VARCHAR2 IS
3941:
3942: l_event_info xla_events_pub_pkg.t_event_info;
3943: l_log_module VARCHAR2(240);
3944: BEGIN
3945: IF g_log_enabled THEN
3946: l_log_module := C_DEFAULT_MODULE||'.get_event_status';

Line 4027: xla_events_pub_pkg.g_security.security_id_int_1

4023: ,p_level => C_LEVEL_PROCEDURE
4024: ,p_module =>l_log_module);
4025: trace
4026: (p_msg => 'security_id_int_1 = '||
4027: xla_events_pub_pkg.g_security.security_id_int_1
4028: ,p_level => C_LEVEL_PROCEDURE
4029: ,p_module =>l_log_module);
4030: trace
4031: (p_msg => 'security_id_int_2 = '||

Line 4032: xla_events_pub_pkg.g_security.security_id_int_2

4028: ,p_level => C_LEVEL_PROCEDURE
4029: ,p_module =>l_log_module);
4030: trace
4031: (p_msg => 'security_id_int_2 = '||
4032: xla_events_pub_pkg.g_security.security_id_int_2
4033: ,p_level => C_LEVEL_PROCEDURE
4034: ,p_module =>l_log_module);
4035: trace
4036: (p_msg => 'security_id_int_3 = '||

Line 4037: xla_events_pub_pkg.g_security.security_id_int_3

4033: ,p_level => C_LEVEL_PROCEDURE
4034: ,p_module =>l_log_module);
4035: trace
4036: (p_msg => 'security_id_int_3 = '||
4037: xla_events_pub_pkg.g_security.security_id_int_3
4038: ,p_level => C_LEVEL_PROCEDURE
4039: ,p_module =>l_log_module);
4040: trace
4041: (p_msg => 'security_id_char_1 = '||

Line 4042: xla_events_pub_pkg.g_security.security_id_char_1

4038: ,p_level => C_LEVEL_PROCEDURE
4039: ,p_module =>l_log_module);
4040: trace
4041: (p_msg => 'security_id_char_1 = '||
4042: xla_events_pub_pkg.g_security.security_id_char_1
4043: ,p_level => C_LEVEL_PROCEDURE
4044: ,p_module =>l_log_module);
4045: trace
4046: (p_msg => 'security_id_char_2 = '||

Line 4047: xla_events_pub_pkg.g_security.security_id_char_2

4043: ,p_level => C_LEVEL_PROCEDURE
4044: ,p_module =>l_log_module);
4045: trace
4046: (p_msg => 'security_id_char_2 = '||
4047: xla_events_pub_pkg.g_security.security_id_char_2
4048: ,p_level => C_LEVEL_PROCEDURE
4049: ,p_module =>l_log_module);
4050: trace
4051: (p_msg => 'security_id_char_3 = '||

Line 4052: xla_events_pub_pkg.g_security.security_id_char_3

4048: ,p_level => C_LEVEL_PROCEDURE
4049: ,p_module =>l_log_module);
4050: trace
4051: (p_msg => 'security_id_char_3 = '||
4052: xla_events_pub_pkg.g_security.security_id_char_3
4053: ,p_level => C_LEVEL_PROCEDURE
4054: ,p_module =>l_log_module);
4055: trace
4056: (p_msg => 'valuation_method = '||p_valuation_method

Line 4095: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

4091: --
4092: --=============================================================================
4093:
4094: FUNCTION event_exists
4095: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
4096: ,p_valuation_method IN VARCHAR2
4097: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
4098: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
4099: ,p_event_date IN DATE DEFAULT NULL

Line 4243: xla_events_pub_pkg.g_security.security_id_int_1

4239: ,p_level => C_LEVEL_PROCEDURE
4240: ,p_module =>l_log_module);
4241: trace
4242: (p_msg => 'security_id_int_1 = '||
4243: xla_events_pub_pkg.g_security.security_id_int_1
4244: ,p_level => C_LEVEL_PROCEDURE
4245: ,p_module =>l_log_module);
4246: trace
4247: (p_msg => 'security_id_int_2 = '||

Line 4248: xla_events_pub_pkg.g_security.security_id_int_2

4244: ,p_level => C_LEVEL_PROCEDURE
4245: ,p_module =>l_log_module);
4246: trace
4247: (p_msg => 'security_id_int_2 = '||
4248: xla_events_pub_pkg.g_security.security_id_int_2
4249: ,p_level => C_LEVEL_PROCEDURE
4250: ,p_module =>l_log_module);
4251: trace
4252: (p_msg => 'security_id_int_3 = '||

Line 4253: xla_events_pub_pkg.g_security.security_id_int_3

4249: ,p_level => C_LEVEL_PROCEDURE
4250: ,p_module =>l_log_module);
4251: trace
4252: (p_msg => 'security_id_int_3 = '||
4253: xla_events_pub_pkg.g_security.security_id_int_3
4254: ,p_level => C_LEVEL_PROCEDURE
4255: ,p_module =>l_log_module);
4256: trace
4257: (p_msg => 'security_id_char_1 = '||

Line 4258: xla_events_pub_pkg.g_security.security_id_char_1

4254: ,p_level => C_LEVEL_PROCEDURE
4255: ,p_module =>l_log_module);
4256: trace
4257: (p_msg => 'security_id_char_1 = '||
4258: xla_events_pub_pkg.g_security.security_id_char_1
4259: ,p_level => C_LEVEL_PROCEDURE
4260: ,p_module =>l_log_module);
4261: trace
4262: (p_msg => 'security_id_char_2 = '||

Line 4263: xla_events_pub_pkg.g_security.security_id_char_2

4259: ,p_level => C_LEVEL_PROCEDURE
4260: ,p_module =>l_log_module);
4261: trace
4262: (p_msg => 'security_id_char_2 = '||
4263: xla_events_pub_pkg.g_security.security_id_char_2
4264: ,p_level => C_LEVEL_PROCEDURE
4265: ,p_module =>l_log_module);
4266: trace
4267: (p_msg => 'security_id_char_3 = '||

Line 4268: xla_events_pub_pkg.g_security.security_id_char_3

4264: ,p_level => C_LEVEL_PROCEDURE
4265: ,p_module =>l_log_module);
4266: trace
4267: (p_msg => 'security_id_char_3 = '||
4268: xla_events_pub_pkg.g_security.security_id_char_3
4269: ,p_level => C_LEVEL_PROCEDURE
4270: ,p_module =>l_log_module);
4271: trace
4272: (p_msg => 'valuation_method = '||p_valuation_method

Line 4585: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

4581: --
4582: --=============================================================================
4583:
4584: PROCEDURE update_transaction_number
4585: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
4586: ,p_valuation_method IN VARCHAR2
4587: ,p_transaction_number IN VARCHAR2
4588: ,p_event_id IN NUMBER DEFAULT NULL) IS -- 8761772
4589: l_log_module VARCHAR2(240);

Line 4677: xla_events_pub_pkg.g_security.security_id_int_1

4673: ,p_level => C_LEVEL_PROCEDURE
4674: ,p_module =>l_log_module);
4675: trace
4676: (p_msg => 'security_id_int_1 = '||
4677: xla_events_pub_pkg.g_security.security_id_int_1
4678: ,p_level => C_LEVEL_PROCEDURE
4679: ,p_module =>l_log_module);
4680: trace
4681: (p_msg => 'security_id_int_2 = '||

Line 4682: xla_events_pub_pkg.g_security.security_id_int_2

4678: ,p_level => C_LEVEL_PROCEDURE
4679: ,p_module =>l_log_module);
4680: trace
4681: (p_msg => 'security_id_int_2 = '||
4682: xla_events_pub_pkg.g_security.security_id_int_2
4683: ,p_level => C_LEVEL_PROCEDURE
4684: ,p_module =>l_log_module);
4685: trace
4686: (p_msg => 'security_id_int_3 = '||

Line 4687: xla_events_pub_pkg.g_security.security_id_int_3

4683: ,p_level => C_LEVEL_PROCEDURE
4684: ,p_module =>l_log_module);
4685: trace
4686: (p_msg => 'security_id_int_3 = '||
4687: xla_events_pub_pkg.g_security.security_id_int_3
4688: ,p_level => C_LEVEL_PROCEDURE
4689: ,p_module =>l_log_module);
4690: trace
4691: (p_msg => 'security_id_char_1 = '||

Line 4692: xla_events_pub_pkg.g_security.security_id_char_1

4688: ,p_level => C_LEVEL_PROCEDURE
4689: ,p_module =>l_log_module);
4690: trace
4691: (p_msg => 'security_id_char_1 = '||
4692: xla_events_pub_pkg.g_security.security_id_char_1
4693: ,p_level => C_LEVEL_PROCEDURE
4694: ,p_module =>l_log_module);
4695: trace
4696: (p_msg => 'security_id_char_2 = '||

Line 4697: xla_events_pub_pkg.g_security.security_id_char_2

4693: ,p_level => C_LEVEL_PROCEDURE
4694: ,p_module =>l_log_module);
4695: trace
4696: (p_msg => 'security_id_char_2 = '||
4697: xla_events_pub_pkg.g_security.security_id_char_2
4698: ,p_level => C_LEVEL_PROCEDURE
4699: ,p_module =>l_log_module);
4700: trace
4701: (p_msg => 'security_id_char_3 = '||

Line 4702: xla_events_pub_pkg.g_security.security_id_char_3

4698: ,p_level => C_LEVEL_PROCEDURE
4699: ,p_module =>l_log_module);
4700: trace
4701: (p_msg => 'security_id_char_3 = '||
4702: xla_events_pub_pkg.g_security.security_id_char_3
4703: ,p_level => C_LEVEL_PROCEDURE
4704: ,p_module =>l_log_module);
4705: trace
4706: (p_msg => 'valuation_method = '||p_valuation_method

Line 4799: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

4795: --
4796: --============================================================================
4797:
4798: FUNCTION allow_third_party_update
4799: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
4800: ,p_valuation_method IN VARCHAR2)
4801: RETURN BOOLEAN IS
4802: l_log_module VARCHAR2(240);
4803: l_count NUMBER;

Line 4883: xla_events_pub_pkg.g_security.security_id_int_1

4879: ,p_level => C_LEVEL_PROCEDURE
4880: ,p_module =>l_log_module);
4881: trace
4882: (p_msg => 'security_id_int_1 = '||
4883: xla_events_pub_pkg.g_security.security_id_int_1
4884: ,p_level => C_LEVEL_PROCEDURE
4885: ,p_module =>l_log_module);
4886: trace
4887: (p_msg => 'security_id_int_2 = '||

Line 4888: xla_events_pub_pkg.g_security.security_id_int_2

4884: ,p_level => C_LEVEL_PROCEDURE
4885: ,p_module =>l_log_module);
4886: trace
4887: (p_msg => 'security_id_int_2 = '||
4888: xla_events_pub_pkg.g_security.security_id_int_2
4889: ,p_level => C_LEVEL_PROCEDURE
4890: ,p_module =>l_log_module);
4891: trace
4892: (p_msg => 'security_id_int_3 = '||

Line 4893: xla_events_pub_pkg.g_security.security_id_int_3

4889: ,p_level => C_LEVEL_PROCEDURE
4890: ,p_module =>l_log_module);
4891: trace
4892: (p_msg => 'security_id_int_3 = '||
4893: xla_events_pub_pkg.g_security.security_id_int_3
4894: ,p_level => C_LEVEL_PROCEDURE
4895: ,p_module =>l_log_module);
4896: trace
4897: (p_msg => 'security_id_char_1 = '||

Line 4898: xla_events_pub_pkg.g_security.security_id_char_1

4894: ,p_level => C_LEVEL_PROCEDURE
4895: ,p_module =>l_log_module);
4896: trace
4897: (p_msg => 'security_id_char_1 = '||
4898: xla_events_pub_pkg.g_security.security_id_char_1
4899: ,p_level => C_LEVEL_PROCEDURE
4900: ,p_module =>l_log_module);
4901: trace
4902: (p_msg => 'security_id_char_2 = '||

Line 4903: xla_events_pub_pkg.g_security.security_id_char_2

4899: ,p_level => C_LEVEL_PROCEDURE
4900: ,p_module =>l_log_module);
4901: trace
4902: (p_msg => 'security_id_char_2 = '||
4903: xla_events_pub_pkg.g_security.security_id_char_2
4904: ,p_level => C_LEVEL_PROCEDURE
4905: ,p_module =>l_log_module);
4906: trace
4907: (p_msg => 'security_id_char_3 = '||

Line 4908: xla_events_pub_pkg.g_security.security_id_char_3

4904: ,p_level => C_LEVEL_PROCEDURE
4905: ,p_module =>l_log_module);
4906: trace
4907: (p_msg => 'security_id_char_3 = '||
4908: xla_events_pub_pkg.g_security.security_id_char_3
4909: ,p_level => C_LEVEL_PROCEDURE
4910: ,p_module =>l_log_module);
4911: trace
4912: (p_msg => 'valuation_method = '||p_valuation_method

Line 5016: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

5012: --
5013: --=============================================================================
5014:
5015: FUNCTION get_entity_id
5016: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
5017: ,p_valuation_method IN VARCHAR2
5018: ,p_event_id IN NUMBER DEFAULT NULL) -- 8761772
5019: RETURN INTEGER IS
5020: l_log_module VARCHAR2(240);

Line 5104: xla_events_pub_pkg.g_security.security_id_int_1

5100: ,p_level => C_LEVEL_PROCEDURE
5101: ,p_module =>l_log_module);
5102: trace
5103: (p_msg => 'security_id_int_1 = '||
5104: xla_events_pub_pkg.g_security.security_id_int_1
5105: ,p_level => C_LEVEL_PROCEDURE
5106: ,p_module =>l_log_module);
5107: trace
5108: (p_msg => 'security_id_int_2 = '||

Line 5109: xla_events_pub_pkg.g_security.security_id_int_2

5105: ,p_level => C_LEVEL_PROCEDURE
5106: ,p_module =>l_log_module);
5107: trace
5108: (p_msg => 'security_id_int_2 = '||
5109: xla_events_pub_pkg.g_security.security_id_int_2
5110: ,p_level => C_LEVEL_PROCEDURE
5111: ,p_module =>l_log_module);
5112: trace
5113: (p_msg => 'security_id_int_3 = '||

Line 5114: xla_events_pub_pkg.g_security.security_id_int_3

5110: ,p_level => C_LEVEL_PROCEDURE
5111: ,p_module =>l_log_module);
5112: trace
5113: (p_msg => 'security_id_int_3 = '||
5114: xla_events_pub_pkg.g_security.security_id_int_3
5115: ,p_level => C_LEVEL_PROCEDURE
5116: ,p_module =>l_log_module);
5117: trace
5118: (p_msg => 'security_id_char_1 = '||

Line 5119: xla_events_pub_pkg.g_security.security_id_char_1

5115: ,p_level => C_LEVEL_PROCEDURE
5116: ,p_module =>l_log_module);
5117: trace
5118: (p_msg => 'security_id_char_1 = '||
5119: xla_events_pub_pkg.g_security.security_id_char_1
5120: ,p_level => C_LEVEL_PROCEDURE
5121: ,p_module =>l_log_module);
5122: trace
5123: (p_msg => 'security_id_char_2 = '||

Line 5124: xla_events_pub_pkg.g_security.security_id_char_2

5120: ,p_level => C_LEVEL_PROCEDURE
5121: ,p_module =>l_log_module);
5122: trace
5123: (p_msg => 'security_id_char_2 = '||
5124: xla_events_pub_pkg.g_security.security_id_char_2
5125: ,p_level => C_LEVEL_PROCEDURE
5126: ,p_module =>l_log_module);
5127: trace
5128: (p_msg => 'security_id_char_3 = '||

Line 5129: xla_events_pub_pkg.g_security.security_id_char_3

5125: ,p_level => C_LEVEL_PROCEDURE
5126: ,p_module =>l_log_module);
5127: trace
5128: (p_msg => 'security_id_char_3 = '||
5129: xla_events_pub_pkg.g_security.security_id_char_3
5130: ,p_level => C_LEVEL_PROCEDURE
5131: ,p_module =>l_log_module);
5132: trace
5133: (p_msg => 'valuation_method = '||p_valuation_method

Line 5283: l_array_event_number xla_events_pub_pkg.t_array_event_number;

5279:
5280: l_array_entity_id t_array_number;
5281: l_array_event_id t_array_number;
5282:
5283: l_array_event_number xla_events_pub_pkg.t_array_event_number;
5284: l_array_event_date xla_events_pub_pkg.t_array_event_date;
5285: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;
5286: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
5287: l_last PLS_INTEGER;

Line 5284: l_array_event_date xla_events_pub_pkg.t_array_event_date;

5280: l_array_entity_id t_array_number;
5281: l_array_event_id t_array_number;
5282:
5283: l_array_event_number xla_events_pub_pkg.t_array_event_number;
5284: l_array_event_date xla_events_pub_pkg.t_array_event_date;
5285: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;
5286: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
5287: l_last PLS_INTEGER;
5288: l_entity_id NUMBER; -- 8761772

Line 5285: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;

5281: l_array_event_id t_array_number;
5282:
5283: l_array_event_number xla_events_pub_pkg.t_array_event_number;
5284: l_array_event_date xla_events_pub_pkg.t_array_event_date;
5285: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;
5286: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
5287: l_last PLS_INTEGER;
5288: l_entity_id NUMBER; -- 8761772
5289: l_current_entity_id NUMBER; -- 8761772

Line 5286: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;

5282:
5283: l_array_event_number xla_events_pub_pkg.t_array_event_number;
5284: l_array_event_date xla_events_pub_pkg.t_array_event_date;
5285: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;
5286: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
5287: l_last PLS_INTEGER;
5288: l_entity_id NUMBER; -- 8761772
5289: l_current_entity_id NUMBER; -- 8761772
5290: l_current_event_number NUMBER;

Line 6042: l_array_event_number xla_events_pub_pkg.t_array_event_number;

6038: TYPE t_array_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6039:
6040: l_array_entity_id t_array_number;
6041: l_array_event_id t_array_number;
6042: l_array_event_number xla_events_pub_pkg.t_array_event_number;
6043: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
6044:
6045: l_array_on_hold_flag t_on_hold_flag_tbl;
6046:

Line 6043: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;

6039:
6040: l_array_entity_id t_array_number;
6041: l_array_event_id t_array_number;
6042: l_array_event_number xla_events_pub_pkg.t_array_event_number;
6043: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
6044:
6045: l_array_on_hold_flag t_on_hold_flag_tbl;
6046:
6047: l_log_module VARCHAR2(240);

Line 6764: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

6760: --
6761: --=============================================================================
6762:
6763: FUNCTION get_array_event_info
6764: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
6765: ,p_valuation_method IN VARCHAR2
6766: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
6767: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
6768: ,p_event_date IN DATE DEFAULT NULL

Line 6770: RETURN xla_events_pub_pkg.t_array_event_info IS

6766: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
6767: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
6768: ,p_event_date IN DATE DEFAULT NULL
6769: ,p_event_status_code IN VARCHAR2 DEFAULT NULL)
6770: RETURN xla_events_pub_pkg.t_array_event_info IS
6771:
6772: l_array_event_info xla_events_pub_pkg.t_array_event_info;
6773: l_count INTEGER := 0;
6774: l_event_date DATE;

Line 6772: l_array_event_info xla_events_pub_pkg.t_array_event_info;

6768: ,p_event_date IN DATE DEFAULT NULL
6769: ,p_event_status_code IN VARCHAR2 DEFAULT NULL)
6770: RETURN xla_events_pub_pkg.t_array_event_info IS
6771:
6772: l_array_event_info xla_events_pub_pkg.t_array_event_info;
6773: l_count INTEGER := 0;
6774: l_event_date DATE;
6775:
6776: CURSOR c1 IS

Line 6903: xla_events_pub_pkg.g_security.security_id_int_1

6899: ,p_level => C_LEVEL_PROCEDURE
6900: ,p_module =>l_log_module);
6901: trace
6902: (p_msg => 'security_id_int_1 = '||
6903: xla_events_pub_pkg.g_security.security_id_int_1
6904: ,p_level => C_LEVEL_PROCEDURE
6905: ,p_module =>l_log_module);
6906: trace
6907: (p_msg => 'security_id_int_2 = '||

Line 6908: xla_events_pub_pkg.g_security.security_id_int_2

6904: ,p_level => C_LEVEL_PROCEDURE
6905: ,p_module =>l_log_module);
6906: trace
6907: (p_msg => 'security_id_int_2 = '||
6908: xla_events_pub_pkg.g_security.security_id_int_2
6909: ,p_level => C_LEVEL_PROCEDURE
6910: ,p_module =>l_log_module);
6911: trace
6912: (p_msg => 'security_id_int_3 = '||

Line 6913: xla_events_pub_pkg.g_security.security_id_int_3

6909: ,p_level => C_LEVEL_PROCEDURE
6910: ,p_module =>l_log_module);
6911: trace
6912: (p_msg => 'security_id_int_3 = '||
6913: xla_events_pub_pkg.g_security.security_id_int_3
6914: ,p_level => C_LEVEL_PROCEDURE
6915: ,p_module =>l_log_module);
6916: trace
6917: (p_msg => 'security_id_char_1 = '||

Line 6918: xla_events_pub_pkg.g_security.security_id_char_1

6914: ,p_level => C_LEVEL_PROCEDURE
6915: ,p_module =>l_log_module);
6916: trace
6917: (p_msg => 'security_id_char_1 = '||
6918: xla_events_pub_pkg.g_security.security_id_char_1
6919: ,p_level => C_LEVEL_PROCEDURE
6920: ,p_module =>l_log_module);
6921: trace
6922: (p_msg => 'security_id_char_2 = '||

Line 6923: xla_events_pub_pkg.g_security.security_id_char_2

6919: ,p_level => C_LEVEL_PROCEDURE
6920: ,p_module =>l_log_module);
6921: trace
6922: (p_msg => 'security_id_char_2 = '||
6923: xla_events_pub_pkg.g_security.security_id_char_2
6924: ,p_level => C_LEVEL_PROCEDURE
6925: ,p_module =>l_log_module);
6926: trace
6927: (p_msg => 'security_id_char_3 = '||

Line 6928: xla_events_pub_pkg.g_security.security_id_char_3

6924: ,p_level => C_LEVEL_PROCEDURE
6925: ,p_module =>l_log_module);
6926: trace
6927: (p_msg => 'security_id_char_3 = '||
6928: xla_events_pub_pkg.g_security.security_id_char_3
6929: ,p_level => C_LEVEL_PROCEDURE
6930: ,p_module =>l_log_module);
6931: trace
6932: (p_msg => 'valuation_method = '||p_valuation_method

Line 7095: g_event_status_code_tbl(1) := xla_events_pub_pkg.C_EVENT_UNPROCESSED;

7091:
7092: ----------------------------------------------------------------------------
7093: -- cache event status code
7094: ----------------------------------------------------------------------------
7095: g_event_status_code_tbl(1) := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
7096: g_event_status_code_tbl(2) := xla_events_pub_pkg.C_EVENT_INCOMPLETE;
7097: g_event_status_code_tbl(3) := xla_events_pub_pkg.C_EVENT_NOACTION;
7098: g_event_status_code_tbl(4) := xla_events_pub_pkg.C_EVENT_PROCESSED;
7099:

Line 7096: g_event_status_code_tbl(2) := xla_events_pub_pkg.C_EVENT_INCOMPLETE;

7092: ----------------------------------------------------------------------------
7093: -- cache event status code
7094: ----------------------------------------------------------------------------
7095: g_event_status_code_tbl(1) := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
7096: g_event_status_code_tbl(2) := xla_events_pub_pkg.C_EVENT_INCOMPLETE;
7097: g_event_status_code_tbl(3) := xla_events_pub_pkg.C_EVENT_NOACTION;
7098: g_event_status_code_tbl(4) := xla_events_pub_pkg.C_EVENT_PROCESSED;
7099:
7100: ----------------------------------------------------------------------------

Line 7097: g_event_status_code_tbl(3) := xla_events_pub_pkg.C_EVENT_NOACTION;

7093: -- cache event status code
7094: ----------------------------------------------------------------------------
7095: g_event_status_code_tbl(1) := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
7096: g_event_status_code_tbl(2) := xla_events_pub_pkg.C_EVENT_INCOMPLETE;
7097: g_event_status_code_tbl(3) := xla_events_pub_pkg.C_EVENT_NOACTION;
7098: g_event_status_code_tbl(4) := xla_events_pub_pkg.C_EVENT_PROCESSED;
7099:
7100: ----------------------------------------------------------------------------
7101: -- cache process status code

Line 7098: g_event_status_code_tbl(4) := xla_events_pub_pkg.C_EVENT_PROCESSED;

7094: ----------------------------------------------------------------------------
7095: g_event_status_code_tbl(1) := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
7096: g_event_status_code_tbl(2) := xla_events_pub_pkg.C_EVENT_INCOMPLETE;
7097: g_event_status_code_tbl(3) := xla_events_pub_pkg.C_EVENT_NOACTION;
7098: g_event_status_code_tbl(4) := xla_events_pub_pkg.C_EVENT_PROCESSED;
7099:
7100: ----------------------------------------------------------------------------
7101: -- cache process status code
7102: ----------------------------------------------------------------------------

Line 7181: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info

7177: --
7178: --=============================================================================
7179:
7180: FUNCTION source_info_changed
7181: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info
7182: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info
7183: ,p_valuation_method1 IN VARCHAR2
7184: ,p_valuation_method2 IN VARCHAR2)
7185: RETURN BOOLEAN IS

Line 7182: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info

7178: --=============================================================================
7179:
7180: FUNCTION source_info_changed
7181: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info
7182: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info
7183: ,p_valuation_method1 IN VARCHAR2
7184: ,p_valuation_method2 IN VARCHAR2)
7185: RETURN BOOLEAN IS
7186: l_log_module VARCHAR2(240);

Line 8305: IF p_event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED THEN

8301: ,p_token_2 => 'LOCATION'
8302: ,p_value_2 => 'xla_events_pkg.validate_status_code');
8303: END IF;
8304:
8305: IF p_event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED THEN
8306: xla_exceptions_pkg.raise_message
8307: (p_appli_s_name => 'XLA'
8308: ,p_msg_name => 'XLA_COMMON_ERROR'
8309: ,p_token_1 => 'ERROR'

Line 8322: IF (p_event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED) THEN

8318: -- for manual events
8319: -------------------------------------------------------------------------
8320:
8321: IF (p_process_status_code = C_INTERNAL_FINAL) THEN
8322: IF (p_event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED) THEN
8323: xla_exceptions_pkg.raise_message
8324: (p_appli_s_name => 'XLA'
8325: ,p_msg_name => 'XLA_COMMON_ERROR'
8326: ,p_token_1 => 'ERROR'

Line 8335: IF (p_event_status_code <> xla_events_pub_pkg.C_EVENT_UNPROCESSED) THEN

8331: ,p_token_2 => 'LOCATION'
8332: ,p_value_2 => 'xla_events_pkg.validate_status_code');
8333: END IF;
8334: ELSIF (p_process_status_code = C_INTERNAL_DRAFT) THEN
8335: IF (p_event_status_code <> xla_events_pub_pkg.C_EVENT_UNPROCESSED) THEN
8336: xla_exceptions_pkg.raise_message
8337: (p_appli_s_name => 'XLA'
8338: ,p_msg_name => 'XLA_COMMON_ERROR'
8339: ,p_token_1 => 'ERROR'

Line 8348: IF (p_event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED) THEN

8344: ,p_token_2 => 'LOCATION'
8345: ,p_value_2 => 'xla_events_pkg.validate_status_code');
8346: END IF;
8347: ELSIF (p_process_status_code = C_INTERNAL_UNPROCESSED) THEN
8348: IF (p_event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED) THEN
8349: xla_exceptions_pkg.raise_message
8350: (p_appli_s_name => 'XLA'
8351: ,p_msg_name => 'XLA_COMMON_ERROR'
8352: ,p_token_1 => 'ERROR'

Line 8397: (p_source_info IN xla_events_pub_pkg.t_event_source_info

8393: --
8394: --=============================================================================
8395:
8396: PROCEDURE validate_params
8397: (p_source_info IN xla_events_pub_pkg.t_event_source_info
8398: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
8399: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
8400: ,p_event_date IN DATE DEFAULT NULL
8401: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 8593: (p_source_info IN xla_events_pub_pkg.t_event_source_info

8589: --
8590: --=============================================================================
8591:
8592: PROCEDURE cache_entity_info
8593: (p_source_info IN xla_events_pub_pkg.t_event_source_info
8594: ,p_valuation_method IN VARCHAR2
8595: ,p_event_id IN NUMBER) IS -- 8761772
8596:
8597: l_source_info xla_events_pub_pkg.t_event_source_info;

Line 8597: l_source_info xla_events_pub_pkg.t_event_source_info;

8593: (p_source_info IN xla_events_pub_pkg.t_event_source_info
8594: ,p_valuation_method IN VARCHAR2
8595: ,p_event_id IN NUMBER) IS -- 8761772
8596:
8597: l_source_info xla_events_pub_pkg.t_event_source_info;
8598:
8599: -------------------------------------------------------------------------------
8600: -- Following three cursors have been modified to remove the 'for update'.
8601: -- The cursors c1 and c2 have also been modified to include 'group by' rather

Line 9042: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

9038: --
9039: --=============================================================================
9040:
9041: FUNCTION create_entity_event
9042: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
9043: ,p_valuation_method IN VARCHAR2
9044: ,p_event_type_code IN VARCHAR2
9045: ,p_event_date IN DATE
9046: ,p_event_status_code IN VARCHAR2

Line 9050: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

9046: ,p_event_status_code IN VARCHAR2
9047: ,p_process_status_code IN VARCHAR2
9048: ,p_event_number IN NUMBER
9049: ,p_transaction_date IN DATE
9050: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
9051: DEFAULT NULL
9052: ,p_budgetary_control_flag IN VARCHAR2)
9053: RETURN INTEGER IS
9054:

Line 9112: ,xla_events_pub_pkg.g_security.security_id_int_1

9108: ,sysdate
9109: ,xla_environment_pkg.g_usr_id
9110: ,xla_environment_pkg.g_login_id
9111: ,p_valuation_method
9112: ,xla_events_pub_pkg.g_security.security_id_int_1
9113: ,xla_events_pub_pkg.g_security.security_id_int_2
9114: ,xla_events_pub_pkg.g_security.security_id_int_3
9115: ,xla_events_pub_pkg.g_security.security_id_char_1
9116: ,xla_events_pub_pkg.g_security.security_id_char_2

Line 9113: ,xla_events_pub_pkg.g_security.security_id_int_2

9109: ,xla_environment_pkg.g_usr_id
9110: ,xla_environment_pkg.g_login_id
9111: ,p_valuation_method
9112: ,xla_events_pub_pkg.g_security.security_id_int_1
9113: ,xla_events_pub_pkg.g_security.security_id_int_2
9114: ,xla_events_pub_pkg.g_security.security_id_int_3
9115: ,xla_events_pub_pkg.g_security.security_id_char_1
9116: ,xla_events_pub_pkg.g_security.security_id_char_2
9117: ,xla_events_pub_pkg.g_security.security_id_char_3

Line 9114: ,xla_events_pub_pkg.g_security.security_id_int_3

9110: ,xla_environment_pkg.g_login_id
9111: ,p_valuation_method
9112: ,xla_events_pub_pkg.g_security.security_id_int_1
9113: ,xla_events_pub_pkg.g_security.security_id_int_2
9114: ,xla_events_pub_pkg.g_security.security_id_int_3
9115: ,xla_events_pub_pkg.g_security.security_id_char_1
9116: ,xla_events_pub_pkg.g_security.security_id_char_2
9117: ,xla_events_pub_pkg.g_security.security_id_char_3
9118: ,p_event_source_info.source_id_int_1

Line 9115: ,xla_events_pub_pkg.g_security.security_id_char_1

9111: ,p_valuation_method
9112: ,xla_events_pub_pkg.g_security.security_id_int_1
9113: ,xla_events_pub_pkg.g_security.security_id_int_2
9114: ,xla_events_pub_pkg.g_security.security_id_int_3
9115: ,xla_events_pub_pkg.g_security.security_id_char_1
9116: ,xla_events_pub_pkg.g_security.security_id_char_2
9117: ,xla_events_pub_pkg.g_security.security_id_char_3
9118: ,p_event_source_info.source_id_int_1
9119: ,p_event_source_info.source_id_int_2

Line 9116: ,xla_events_pub_pkg.g_security.security_id_char_2

9112: ,xla_events_pub_pkg.g_security.security_id_int_1
9113: ,xla_events_pub_pkg.g_security.security_id_int_2
9114: ,xla_events_pub_pkg.g_security.security_id_int_3
9115: ,xla_events_pub_pkg.g_security.security_id_char_1
9116: ,xla_events_pub_pkg.g_security.security_id_char_2
9117: ,xla_events_pub_pkg.g_security.security_id_char_3
9118: ,p_event_source_info.source_id_int_1
9119: ,p_event_source_info.source_id_int_2
9120: ,p_event_source_info.source_id_int_3

Line 9117: ,xla_events_pub_pkg.g_security.security_id_char_3

9113: ,xla_events_pub_pkg.g_security.security_id_int_2
9114: ,xla_events_pub_pkg.g_security.security_id_int_3
9115: ,xla_events_pub_pkg.g_security.security_id_char_1
9116: ,xla_events_pub_pkg.g_security.security_id_char_2
9117: ,xla_events_pub_pkg.g_security.security_id_char_3
9118: ,p_event_source_info.source_id_int_1
9119: ,p_event_source_info.source_id_int_2
9120: ,p_event_source_info.source_id_int_3
9121: ,p_event_source_info.source_id_int_4

Line 9226: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

9222: ,p_event_status_code IN VARCHAR2
9223: ,p_process_status_code IN VARCHAR2
9224: ,p_event_number IN NUMBER
9225: ,p_transaction_date IN DATE
9226: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
9227: DEFAULT NULL
9228: ,p_budgetary_control_flag IN VARCHAR2)
9229: RETURN INTEGER IS
9230: l_event_id INTEGER;

Line 9399: l_source_info xla_events_pub_pkg.t_event_source_info;

9395: l_dummy_class_tbl t_array_event_class;
9396: l_dummy_type_tbl t_array_event_type;
9397: l_dummy_entity_tbl t_array_entity_type;
9398: l_dummy_tbl t_parameter_tbl;
9399: l_source_info xla_events_pub_pkg.t_event_source_info;
9400: l_log_module VARCHAR2(240);
9401: BEGIN
9402: IF g_log_enabled THEN
9403: l_log_module := C_DEFAULT_MODULE||'.reset_cache';