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 239: g_source_info xla_events_pub_pkg.t_event_source_info;

235:
236: g_ledger_status_tbl t_ledger_status_tbl;
237: -- for caching the value if event can be created
238:
239: g_source_info xla_events_pub_pkg.t_event_source_info;
240: g_entity_id PLS_INTEGER; -- Entity id
241: g_entity_type_code VARCHAR2(30); -- Entity code
242: g_valuation_method VARCHAR2(80); -- valuation method
243:

Line 316: (p_source_info IN xla_events_pub_pkg.t_event_source_info

312: (p_event_status_code IN VARCHAR2
313: ,p_process_status_code IN VARCHAR2);
314:
315: PROCEDURE validate_params
316: (p_source_info IN xla_events_pub_pkg.t_event_source_info
317: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
318: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
319: ,p_event_date IN DATE DEFAULT NULL
320: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 328: (p_source_info IN xla_events_pub_pkg.t_event_source_info

324: (p_ledger_id IN NUMBER
325: ,p_application_id IN NUMBER);
326:
327: PROCEDURE cache_entity_info
328: (p_source_info IN xla_events_pub_pkg.t_event_source_info
329: ,p_valuation_method IN VARCHAR2
330: ,p_event_id IN PLS_INTEGER);
331:
332: PROCEDURE update_entity_trx_number

Line 341: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info

337: PROCEDURE set_context
338: (p_context IN VARCHAR2);
339:
340: FUNCTION source_info_changed
341: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info
342: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info
343: ,p_valuation_method1 IN VARCHAR2
344: ,p_valuation_method2 IN VARCHAR2)
345: RETURN BOOLEAN;

Line 342: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info

338: (p_context IN VARCHAR2);
339:
340: FUNCTION source_info_changed
341: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info
342: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info
343: ,p_valuation_method1 IN VARCHAR2
344: ,p_valuation_method2 IN VARCHAR2)
345: RETURN BOOLEAN;
346:

Line 356: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

352: ,p_source_id_code_4 IN VARCHAR2)
353: RETURN VARCHAR2;
354:
355: FUNCTION create_entity_event
356: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
357: ,p_valuation_method IN VARCHAR2
358: ,p_event_type_code IN VARCHAR2
359: ,p_event_date IN DATE
360: ,p_event_status_code IN VARCHAR2

Line 364: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

360: ,p_event_status_code IN VARCHAR2
361: ,p_process_status_code IN VARCHAR2
362: ,p_event_number IN NUMBER
363: ,p_transaction_date IN DATE
364: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
365: DEFAULT NULL
366: ,p_budgetary_control_flag IN VARCHAR2)
367: RETURN INTEGER;
368:

Line 380: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

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

Line 473: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

469: --
470: --=============================================================================
471:
472: FUNCTION create_event
473: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
474: ,p_valuation_method IN VARCHAR2
475: ,p_event_type_code IN VARCHAR2
476: ,p_event_date IN DATE
477: ,p_event_status_code IN VARCHAR2

Line 480: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

476: ,p_event_date IN DATE
477: ,p_event_status_code IN VARCHAR2
478: ,p_event_number IN INTEGER DEFAULT NULL
479: ,p_transaction_date IN DATE DEFAULT NULL
480: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
481: DEFAULT NULL
482: ,p_budgetary_control_flag IN VARCHAR2)
483: RETURN INTEGER IS
484: l_event_date DATE;

Line 591: xla_events_pub_pkg.g_security.security_id_int_1

587: ,p_level => C_LEVEL_PROCEDURE
588: ,p_module =>l_log_module);
589: trace
590: (p_msg => 'security_id_int_1 = '||
591: xla_events_pub_pkg.g_security.security_id_int_1
592: ,p_level => C_LEVEL_PROCEDURE
593: ,p_module =>l_log_module);
594: trace
595: (p_msg => 'security_id_int_2 = '||

Line 596: xla_events_pub_pkg.g_security.security_id_int_2

592: ,p_level => C_LEVEL_PROCEDURE
593: ,p_module =>l_log_module);
594: trace
595: (p_msg => 'security_id_int_2 = '||
596: xla_events_pub_pkg.g_security.security_id_int_2
597: ,p_level => C_LEVEL_PROCEDURE
598: ,p_module =>l_log_module);
599: trace
600: (p_msg => 'security_id_int_3 = '||

Line 601: xla_events_pub_pkg.g_security.security_id_int_3

597: ,p_level => C_LEVEL_PROCEDURE
598: ,p_module =>l_log_module);
599: trace
600: (p_msg => 'security_id_int_3 = '||
601: xla_events_pub_pkg.g_security.security_id_int_3
602: ,p_level => C_LEVEL_PROCEDURE
603: ,p_module =>l_log_module);
604: trace
605: (p_msg => 'security_id_char_1 = '||

Line 606: xla_events_pub_pkg.g_security.security_id_char_1

602: ,p_level => C_LEVEL_PROCEDURE
603: ,p_module =>l_log_module);
604: trace
605: (p_msg => 'security_id_char_1 = '||
606: xla_events_pub_pkg.g_security.security_id_char_1
607: ,p_level => C_LEVEL_PROCEDURE
608: ,p_module =>l_log_module);
609: trace
610: (p_msg => 'security_id_char_2 = '||

Line 611: xla_events_pub_pkg.g_security.security_id_char_2

607: ,p_level => C_LEVEL_PROCEDURE
608: ,p_module =>l_log_module);
609: trace
610: (p_msg => 'security_id_char_2 = '||
611: xla_events_pub_pkg.g_security.security_id_char_2
612: ,p_level => C_LEVEL_PROCEDURE
613: ,p_module =>l_log_module);
614: trace
615: (p_msg => 'security_id_char_3 = '||

Line 616: xla_events_pub_pkg.g_security.security_id_char_3

612: ,p_level => C_LEVEL_PROCEDURE
613: ,p_module =>l_log_module);
614: trace
615: (p_msg => 'security_id_char_3 = '||
616: xla_events_pub_pkg.g_security.security_id_char_3
617: ,p_level => C_LEVEL_PROCEDURE
618: ,p_module =>l_log_module);
619: trace
620: (p_msg => 'valuation_method = '||p_valuation_method

Line 811: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

807: --
808: --=============================================================================
809:
810: FUNCTION create_manual_event
811: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
812: ,p_event_type_code IN VARCHAR2
813: ,p_event_date IN DATE
814: ,p_event_status_code IN VARCHAR2
815: ,p_process_status_code IN VARCHAR2

Line 818: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL

814: ,p_event_status_code IN VARCHAR2
815: ,p_process_status_code IN VARCHAR2
816: ,p_event_number IN INTEGER DEFAULT NULL
817: ,p_transaction_date IN DATE DEFAULT NULL
818: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info DEFAULT NULL
819: ,p_budgetary_control_flag IN VARCHAR2)
820: RETURN INTEGER IS
821: l_event_date DATE;
822: L_CONSTANT CONSTANT VARCHAR2(30) := '##UNDEFINED##'; --chr(12);

Line 928: xla_events_pub_pkg.g_security.security_id_int_1

924: ,p_level => C_LEVEL_PROCEDURE
925: ,p_module =>l_log_module);
926: trace
927: (p_msg => 'security_id_int_1 = '||
928: xla_events_pub_pkg.g_security.security_id_int_1
929: ,p_level => C_LEVEL_PROCEDURE
930: ,p_module =>l_log_module);
931: trace
932: (p_msg => 'security_id_int_2 = '||

Line 933: xla_events_pub_pkg.g_security.security_id_int_2

929: ,p_level => C_LEVEL_PROCEDURE
930: ,p_module =>l_log_module);
931: trace
932: (p_msg => 'security_id_int_2 = '||
933: xla_events_pub_pkg.g_security.security_id_int_2
934: ,p_level => C_LEVEL_PROCEDURE
935: ,p_module =>l_log_module);
936: trace
937: (p_msg => 'security_id_int_3 = '||

Line 938: xla_events_pub_pkg.g_security.security_id_int_3

934: ,p_level => C_LEVEL_PROCEDURE
935: ,p_module =>l_log_module);
936: trace
937: (p_msg => 'security_id_int_3 = '||
938: xla_events_pub_pkg.g_security.security_id_int_3
939: ,p_level => C_LEVEL_PROCEDURE
940: ,p_module =>l_log_module);
941: trace
942: (p_msg => 'security_id_char_1 = '||

Line 943: xla_events_pub_pkg.g_security.security_id_char_1

939: ,p_level => C_LEVEL_PROCEDURE
940: ,p_module =>l_log_module);
941: trace
942: (p_msg => 'security_id_char_1 = '||
943: xla_events_pub_pkg.g_security.security_id_char_1
944: ,p_level => C_LEVEL_PROCEDURE
945: ,p_module =>l_log_module);
946: trace
947: (p_msg => 'security_id_char_2 = '||

Line 948: xla_events_pub_pkg.g_security.security_id_char_2

944: ,p_level => C_LEVEL_PROCEDURE
945: ,p_module =>l_log_module);
946: trace
947: (p_msg => 'security_id_char_2 = '||
948: xla_events_pub_pkg.g_security.security_id_char_2
949: ,p_level => C_LEVEL_PROCEDURE
950: ,p_module =>l_log_module);
951: trace
952: (p_msg => 'security_id_char_3 = '||

Line 953: xla_events_pub_pkg.g_security.security_id_char_3

949: ,p_level => C_LEVEL_PROCEDURE
950: ,p_module =>l_log_module);
951: trace
952: (p_msg => 'security_id_char_3 = '||
953: xla_events_pub_pkg.g_security.security_id_char_3
954: ,p_level => C_LEVEL_PROCEDURE
955: ,p_module =>l_log_module);
956: END IF;
957:

Line 1131: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

1127: --
1128: --=============================================================================
1129:
1130: PROCEDURE update_event_status
1131: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
1132: ,p_valuation_method IN VARCHAR2
1133: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
1134: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
1135: ,p_event_date IN DATE DEFAULT NULL

Line 1239: xla_events_pub_pkg.g_security.security_id_int_1

1235: ,p_level => C_LEVEL_PROCEDURE
1236: ,p_module =>l_log_module);
1237: trace
1238: (p_msg => 'security_id_int_1 = '||
1239: xla_events_pub_pkg.g_security.security_id_int_1
1240: ,p_level => C_LEVEL_PROCEDURE
1241: ,p_module =>l_log_module);
1242: trace
1243: (p_msg => 'security_id_int_2 = '||

Line 1244: xla_events_pub_pkg.g_security.security_id_int_2

1240: ,p_level => C_LEVEL_PROCEDURE
1241: ,p_module =>l_log_module);
1242: trace
1243: (p_msg => 'security_id_int_2 = '||
1244: xla_events_pub_pkg.g_security.security_id_int_2
1245: ,p_level => C_LEVEL_PROCEDURE
1246: ,p_module =>l_log_module);
1247: trace
1248: (p_msg => 'security_id_int_3 = '||

Line 1249: xla_events_pub_pkg.g_security.security_id_int_3

1245: ,p_level => C_LEVEL_PROCEDURE
1246: ,p_module =>l_log_module);
1247: trace
1248: (p_msg => 'security_id_int_3 = '||
1249: xla_events_pub_pkg.g_security.security_id_int_3
1250: ,p_level => C_LEVEL_PROCEDURE
1251: ,p_module =>l_log_module);
1252: trace
1253: (p_msg => 'security_id_char_1 = '||

Line 1254: xla_events_pub_pkg.g_security.security_id_char_1

1250: ,p_level => C_LEVEL_PROCEDURE
1251: ,p_module =>l_log_module);
1252: trace
1253: (p_msg => 'security_id_char_1 = '||
1254: xla_events_pub_pkg.g_security.security_id_char_1
1255: ,p_level => C_LEVEL_PROCEDURE
1256: ,p_module =>l_log_module);
1257: trace
1258: (p_msg => 'security_id_char_2 = '||

Line 1259: xla_events_pub_pkg.g_security.security_id_char_2

1255: ,p_level => C_LEVEL_PROCEDURE
1256: ,p_module =>l_log_module);
1257: trace
1258: (p_msg => 'security_id_char_2 = '||
1259: xla_events_pub_pkg.g_security.security_id_char_2
1260: ,p_level => C_LEVEL_PROCEDURE
1261: ,p_module =>l_log_module);
1262: trace
1263: (p_msg => 'security_id_char_3 = '||

Line 1264: xla_events_pub_pkg.g_security.security_id_char_3

1260: ,p_level => C_LEVEL_PROCEDURE
1261: ,p_module =>l_log_module);
1262: trace
1263: (p_msg => 'security_id_char_3 = '||
1264: xla_events_pub_pkg.g_security.security_id_char_3
1265: ,p_level => C_LEVEL_PROCEDURE
1266: ,p_module =>l_log_module);
1267: trace
1268: (p_msg => 'valuation_method = '||p_valuation_method

Line 1366: WHERE event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

1362: if(g_gapless_flag='N') then
1363: SELECT event_id BULK COLLECT
1364: INTO l_array_events
1365: FROM xla_events
1366: WHERE event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
1367: AND event_date = NVL(l_event_date, event_date)
1368: AND event_type_code = NVL(p_event_type_code, event_type_code)
1369: AND entity_id = g_entity_id
1370: AND event_type_code IN

Line 1387: WHERE event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

1383: l_array_event_status,
1384: l_array_on_hold_flag,
1385: l_array_event_number
1386: FROM xla_events
1387: WHERE event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
1388: AND event_date = NVL(l_event_date, event_date)
1389: AND event_type_code = NVL(p_event_type_code, event_type_code)
1390: AND entity_id = g_entity_id
1391: AND event_type_code IN

Line 1535: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

1531: --
1532: --=============================================================================
1533:
1534: PROCEDURE update_event
1535: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
1536: ,p_valuation_method IN VARCHAR2
1537: ,p_event_id IN INTEGER
1538: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
1539: ,p_event_date IN DATE DEFAULT NULL

Line 1543: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

1539: ,p_event_date IN DATE DEFAULT NULL
1540: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
1541: ,p_transaction_date IN DATE DEFAULT NULL
1542: ,p_event_number IN INTEGER DEFAULT NULL
1543: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
1544: DEFAULT NULL
1545: ,p_overwrite_event_num IN VARCHAR2 DEFAULT 'N'
1546: ,p_overwrite_ref_info IN VARCHAR2 DEFAULT 'N') IS
1547: l_event_date DATE;

Line 1663: xla_events_pub_pkg.g_security.security_id_int_1

1659: ,p_level => C_LEVEL_PROCEDURE
1660: ,p_module =>l_log_module);
1661: trace
1662: (p_msg => 'security_id_int_1 = '||
1663: xla_events_pub_pkg.g_security.security_id_int_1
1664: ,p_level => C_LEVEL_PROCEDURE
1665: ,p_module =>l_log_module);
1666: trace
1667: (p_msg => 'security_id_int_2 = '||

Line 1668: xla_events_pub_pkg.g_security.security_id_int_2

1664: ,p_level => C_LEVEL_PROCEDURE
1665: ,p_module =>l_log_module);
1666: trace
1667: (p_msg => 'security_id_int_2 = '||
1668: xla_events_pub_pkg.g_security.security_id_int_2
1669: ,p_level => C_LEVEL_PROCEDURE
1670: ,p_module =>l_log_module);
1671: trace
1672: (p_msg => 'security_id_int_3 = '||

Line 1673: xla_events_pub_pkg.g_security.security_id_int_3

1669: ,p_level => C_LEVEL_PROCEDURE
1670: ,p_module =>l_log_module);
1671: trace
1672: (p_msg => 'security_id_int_3 = '||
1673: xla_events_pub_pkg.g_security.security_id_int_3
1674: ,p_level => C_LEVEL_PROCEDURE
1675: ,p_module =>l_log_module);
1676: trace
1677: (p_msg => 'security_id_char_1 = '||

Line 1678: xla_events_pub_pkg.g_security.security_id_char_1

1674: ,p_level => C_LEVEL_PROCEDURE
1675: ,p_module =>l_log_module);
1676: trace
1677: (p_msg => 'security_id_char_1 = '||
1678: xla_events_pub_pkg.g_security.security_id_char_1
1679: ,p_level => C_LEVEL_PROCEDURE
1680: ,p_module =>l_log_module);
1681: trace
1682: (p_msg => 'security_id_char_2 = '||

Line 1683: xla_events_pub_pkg.g_security.security_id_char_2

1679: ,p_level => C_LEVEL_PROCEDURE
1680: ,p_module =>l_log_module);
1681: trace
1682: (p_msg => 'security_id_char_2 = '||
1683: xla_events_pub_pkg.g_security.security_id_char_2
1684: ,p_level => C_LEVEL_PROCEDURE
1685: ,p_module =>l_log_module);
1686: trace
1687: (p_msg => 'security_id_char_3 = '||

Line 1688: xla_events_pub_pkg.g_security.security_id_char_3

1684: ,p_level => C_LEVEL_PROCEDURE
1685: ,p_module =>l_log_module);
1686: trace
1687: (p_msg => 'security_id_char_3 = '||
1688: xla_events_pub_pkg.g_security.security_id_char_3
1689: ,p_level => C_LEVEL_PROCEDURE
1690: ,p_module =>l_log_module);
1691: trace
1692: (p_msg => 'valuation_method = '||p_valuation_method

Line 1838: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;

1834: into l_old_event_status_code, l_old_on_hold_flag, l_old_event_number
1835: from xla_events
1836: WHERE event_id = p_event_id
1837: AND entity_id = g_entity_id
1838: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
1839: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1840: trace
1841: (p_msg => 'l_old_event_status_code:'||l_old_event_status_code
1842: ,p_level => C_LEVEL_STATEMENT

Line 1908: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;

1904: ,program_id = xla_environment_pkg.g_prog_id
1905: ,request_id = xla_environment_pkg.g_Req_Id
1906: WHERE event_id = p_event_id
1907: AND entity_id = g_entity_id
1908: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
1909:
1910: IF SQL%ROWCOUNT <> 1 THEN
1911: xla_exceptions_pkg.raise_message
1912: (p_appli_s_name => 'XLA'

Line 1940: and event_status_code<> xla_events_pub_pkg.C_EVENT_PROCESSED

1936: if(l_old_event_status_code<>'I') then
1937: update xla_events
1938: set on_hold_flag='Y'
1939: where entity_id=g_entity_id
1940: and event_status_code<> xla_events_pub_pkg.C_EVENT_PROCESSED
1941: and event_number>l_old_event_number;
1942: else
1943: update xla_events
1944: set on_hold_flag='Y'

Line 2069: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

2065: --
2066: --=============================================================================
2067:
2068: PROCEDURE update_manual_event
2069: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
2070: ,p_event_id IN INTEGER
2071: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
2072: ,p_event_date IN DATE DEFAULT NULL
2073: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 2076: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

2072: ,p_event_date IN DATE DEFAULT NULL
2073: ,p_event_status_code IN VARCHAR2 DEFAULT NULL
2074: ,p_process_status_code IN VARCHAR2 DEFAULT NULL
2075: ,p_event_number IN INTEGER DEFAULT NULL
2076: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
2077: DEFAULT NULL
2078: ,p_overwrite_event_num IN VARCHAR2 DEFAULT 'N'
2079: ,p_overwrite_ref_info IN VARCHAR2 DEFAULT 'N') IS
2080: l_event_date DATE;

Line 2194: xla_events_pub_pkg.g_security.security_id_int_1

2190: ,p_level => C_LEVEL_PROCEDURE
2191: ,p_module =>l_log_module);
2192: trace
2193: (p_msg => 'security_id_int_1 = '||
2194: xla_events_pub_pkg.g_security.security_id_int_1
2195: ,p_level => C_LEVEL_PROCEDURE
2196: ,p_module =>l_log_module);
2197: trace
2198: (p_msg => 'security_id_int_2 = '||

Line 2199: xla_events_pub_pkg.g_security.security_id_int_2

2195: ,p_level => C_LEVEL_PROCEDURE
2196: ,p_module =>l_log_module);
2197: trace
2198: (p_msg => 'security_id_int_2 = '||
2199: xla_events_pub_pkg.g_security.security_id_int_2
2200: ,p_level => C_LEVEL_PROCEDURE
2201: ,p_module =>l_log_module);
2202: trace
2203: (p_msg => 'security_id_int_3 = '||

Line 2204: xla_events_pub_pkg.g_security.security_id_int_3

2200: ,p_level => C_LEVEL_PROCEDURE
2201: ,p_module =>l_log_module);
2202: trace
2203: (p_msg => 'security_id_int_3 = '||
2204: xla_events_pub_pkg.g_security.security_id_int_3
2205: ,p_level => C_LEVEL_PROCEDURE
2206: ,p_module =>l_log_module);
2207: trace
2208: (p_msg => 'security_id_char_1 = '||

Line 2209: xla_events_pub_pkg.g_security.security_id_char_1

2205: ,p_level => C_LEVEL_PROCEDURE
2206: ,p_module =>l_log_module);
2207: trace
2208: (p_msg => 'security_id_char_1 = '||
2209: xla_events_pub_pkg.g_security.security_id_char_1
2210: ,p_level => C_LEVEL_PROCEDURE
2211: ,p_module =>l_log_module);
2212: trace
2213: (p_msg => 'security_id_char_2 = '||

Line 2214: xla_events_pub_pkg.g_security.security_id_char_2

2210: ,p_level => C_LEVEL_PROCEDURE
2211: ,p_module =>l_log_module);
2212: trace
2213: (p_msg => 'security_id_char_2 = '||
2214: xla_events_pub_pkg.g_security.security_id_char_2
2215: ,p_level => C_LEVEL_PROCEDURE
2216: ,p_module =>l_log_module);
2217: trace
2218: (p_msg => 'security_id_char_3 = '||

Line 2219: xla_events_pub_pkg.g_security.security_id_char_3

2215: ,p_level => C_LEVEL_PROCEDURE
2216: ,p_module =>l_log_module);
2217: trace
2218: (p_msg => 'security_id_char_3 = '||
2219: xla_events_pub_pkg.g_security.security_id_char_3
2220: ,p_level => C_LEVEL_PROCEDURE
2221: ,p_module =>l_log_module);
2222: END IF;
2223:

Line 2365: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;

2361: ,program_id = xla_environment_pkg.g_prog_id
2362: ,request_id = xla_environment_pkg.g_Req_Id
2363: WHERE event_id = p_event_id
2364: AND entity_id = g_entity_id
2365: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
2366:
2367: l_rowcount := SQL%ROWCOUNT;
2368:
2369: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2414: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

2410: --
2411: --=============================================================================
2412:
2413: PROCEDURE delete_event
2414: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
2415: ,p_valuation_method IN VARCHAR2
2416: ,p_event_id IN INTEGER) IS
2417: l_on_hold_flag xla_events.on_hold_flag%type;
2418: l_event_status_code xla_events.event_status_code%type;

Line 2505: xla_events_pub_pkg.g_security.security_id_int_1

2501: ,p_level => C_LEVEL_PROCEDURE
2502: ,p_module =>l_log_module);
2503: trace
2504: (p_msg => 'security_id_int_1 = '||
2505: xla_events_pub_pkg.g_security.security_id_int_1
2506: ,p_level => C_LEVEL_PROCEDURE
2507: ,p_module =>l_log_module);
2508: trace
2509: (p_msg => 'security_id_int_2 = '||

Line 2510: xla_events_pub_pkg.g_security.security_id_int_2

2506: ,p_level => C_LEVEL_PROCEDURE
2507: ,p_module =>l_log_module);
2508: trace
2509: (p_msg => 'security_id_int_2 = '||
2510: xla_events_pub_pkg.g_security.security_id_int_2
2511: ,p_level => C_LEVEL_PROCEDURE
2512: ,p_module =>l_log_module);
2513: trace
2514: (p_msg => 'security_id_int_3 = '||

Line 2515: xla_events_pub_pkg.g_security.security_id_int_3

2511: ,p_level => C_LEVEL_PROCEDURE
2512: ,p_module =>l_log_module);
2513: trace
2514: (p_msg => 'security_id_int_3 = '||
2515: xla_events_pub_pkg.g_security.security_id_int_3
2516: ,p_level => C_LEVEL_PROCEDURE
2517: ,p_module =>l_log_module);
2518: trace
2519: (p_msg => 'security_id_char_1 = '||

Line 2520: xla_events_pub_pkg.g_security.security_id_char_1

2516: ,p_level => C_LEVEL_PROCEDURE
2517: ,p_module =>l_log_module);
2518: trace
2519: (p_msg => 'security_id_char_1 = '||
2520: xla_events_pub_pkg.g_security.security_id_char_1
2521: ,p_level => C_LEVEL_PROCEDURE
2522: ,p_module =>l_log_module);
2523: trace
2524: (p_msg => 'security_id_char_2 = '||

Line 2525: xla_events_pub_pkg.g_security.security_id_char_2

2521: ,p_level => C_LEVEL_PROCEDURE
2522: ,p_module =>l_log_module);
2523: trace
2524: (p_msg => 'security_id_char_2 = '||
2525: xla_events_pub_pkg.g_security.security_id_char_2
2526: ,p_level => C_LEVEL_PROCEDURE
2527: ,p_module =>l_log_module);
2528: trace
2529: (p_msg => 'security_id_char_3 = '||

Line 2530: xla_events_pub_pkg.g_security.security_id_char_3

2526: ,p_level => C_LEVEL_PROCEDURE
2527: ,p_module =>l_log_module);
2528: trace
2529: (p_msg => 'security_id_char_3 = '||
2530: xla_events_pub_pkg.g_security.security_id_char_3
2531: ,p_level => C_LEVEL_PROCEDURE
2532: ,p_module =>l_log_module);
2533: trace
2534: (p_msg => 'valuation_method = '||p_valuation_method

Line 2620: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;

2616: into l_on_hold_flag, l_event_status_code, l_event_number
2617: from xla_events
2618: WHERE event_id = p_event_id
2619: AND entity_id = g_entity_id
2620: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
2621: exception when others then
2622: xla_exceptions_pkg.raise_message
2623: (p_appli_s_name => 'XLA'
2624: ,p_msg_name => 'XLA_COMMON_ERROR'

Line 2640: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;

2636: ----------------------------------------------------------------------------
2637: DELETE xla_events
2638: WHERE event_id = p_event_id
2639: AND entity_id = g_entity_id
2640: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED;
2641:
2642: l_rowcount := SQL%ROWCOUNT;
2643:
2644: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2722: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

2718: --
2719: --=============================================================================
2720:
2721: PROCEDURE delete_processed_event
2722: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
2723: ,p_event_id IN INTEGER) IS
2724: l_log_module VARCHAR2(240);
2725: l_rowcount NUMBER;
2726: BEGIN

Line 2809: xla_events_pub_pkg.g_security.security_id_int_1

2805: ,p_level => C_LEVEL_PROCEDURE
2806: ,p_module =>l_log_module);
2807: trace
2808: (p_msg => 'security_id_int_1 = '||
2809: xla_events_pub_pkg.g_security.security_id_int_1
2810: ,p_level => C_LEVEL_PROCEDURE
2811: ,p_module =>l_log_module);
2812: trace
2813: (p_msg => 'security_id_int_2 = '||

Line 2814: xla_events_pub_pkg.g_security.security_id_int_2

2810: ,p_level => C_LEVEL_PROCEDURE
2811: ,p_module =>l_log_module);
2812: trace
2813: (p_msg => 'security_id_int_2 = '||
2814: xla_events_pub_pkg.g_security.security_id_int_2
2815: ,p_level => C_LEVEL_PROCEDURE
2816: ,p_module =>l_log_module);
2817: trace
2818: (p_msg => 'security_id_int_3 = '||

Line 2819: xla_events_pub_pkg.g_security.security_id_int_3

2815: ,p_level => C_LEVEL_PROCEDURE
2816: ,p_module =>l_log_module);
2817: trace
2818: (p_msg => 'security_id_int_3 = '||
2819: xla_events_pub_pkg.g_security.security_id_int_3
2820: ,p_level => C_LEVEL_PROCEDURE
2821: ,p_module =>l_log_module);
2822: trace
2823: (p_msg => 'security_id_char_1 = '||

Line 2824: xla_events_pub_pkg.g_security.security_id_char_1

2820: ,p_level => C_LEVEL_PROCEDURE
2821: ,p_module =>l_log_module);
2822: trace
2823: (p_msg => 'security_id_char_1 = '||
2824: xla_events_pub_pkg.g_security.security_id_char_1
2825: ,p_level => C_LEVEL_PROCEDURE
2826: ,p_module =>l_log_module);
2827: trace
2828: (p_msg => 'security_id_char_2 = '||

Line 2829: xla_events_pub_pkg.g_security.security_id_char_2

2825: ,p_level => C_LEVEL_PROCEDURE
2826: ,p_module =>l_log_module);
2827: trace
2828: (p_msg => 'security_id_char_2 = '||
2829: xla_events_pub_pkg.g_security.security_id_char_2
2830: ,p_level => C_LEVEL_PROCEDURE
2831: ,p_module =>l_log_module);
2832: trace
2833: (p_msg => 'security_id_char_3 = '||

Line 2834: xla_events_pub_pkg.g_security.security_id_char_3

2830: ,p_level => C_LEVEL_PROCEDURE
2831: ,p_module =>l_log_module);
2832: trace
2833: (p_msg => 'security_id_char_3 = '||
2834: xla_events_pub_pkg.g_security.security_id_char_3
2835: ,p_level => C_LEVEL_PROCEDURE
2836: ,p_module =>l_log_module);
2837: END IF;
2838:

Line 2926: AND event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED;

2922: ----------------------------------------------------------------------------
2923: DELETE xla_events
2924: WHERE event_id = p_event_id
2925: AND entity_id = g_entity_id
2926: AND event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED;
2927:
2928: l_rowcount := SQL%ROWCOUNT;
2929:
2930: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2997: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

2993: --
2994: --=============================================================================
2995:
2996: FUNCTION delete_events
2997: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
2998: ,p_valuation_method IN VARCHAR2
2999: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
3000: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
3001: ,p_event_date IN DATE DEFAULT NULL)

Line 3098: xla_events_pub_pkg.g_security.security_id_int_1

3094: ,p_level => C_LEVEL_PROCEDURE
3095: ,p_module =>l_log_module);
3096: trace
3097: (p_msg => 'security_id_int_1 = '||
3098: xla_events_pub_pkg.g_security.security_id_int_1
3099: ,p_level => C_LEVEL_PROCEDURE
3100: ,p_module =>l_log_module);
3101: trace
3102: (p_msg => 'security_id_int_2 = '||

Line 3103: xla_events_pub_pkg.g_security.security_id_int_2

3099: ,p_level => C_LEVEL_PROCEDURE
3100: ,p_module =>l_log_module);
3101: trace
3102: (p_msg => 'security_id_int_2 = '||
3103: xla_events_pub_pkg.g_security.security_id_int_2
3104: ,p_level => C_LEVEL_PROCEDURE
3105: ,p_module =>l_log_module);
3106: trace
3107: (p_msg => 'security_id_int_3 = '||

Line 3108: xla_events_pub_pkg.g_security.security_id_int_3

3104: ,p_level => C_LEVEL_PROCEDURE
3105: ,p_module =>l_log_module);
3106: trace
3107: (p_msg => 'security_id_int_3 = '||
3108: xla_events_pub_pkg.g_security.security_id_int_3
3109: ,p_level => C_LEVEL_PROCEDURE
3110: ,p_module =>l_log_module);
3111: trace
3112: (p_msg => 'security_id_char_1 = '||

Line 3113: xla_events_pub_pkg.g_security.security_id_char_1

3109: ,p_level => C_LEVEL_PROCEDURE
3110: ,p_module =>l_log_module);
3111: trace
3112: (p_msg => 'security_id_char_1 = '||
3113: xla_events_pub_pkg.g_security.security_id_char_1
3114: ,p_level => C_LEVEL_PROCEDURE
3115: ,p_module =>l_log_module);
3116: trace
3117: (p_msg => 'security_id_char_2 = '||

Line 3118: xla_events_pub_pkg.g_security.security_id_char_2

3114: ,p_level => C_LEVEL_PROCEDURE
3115: ,p_module =>l_log_module);
3116: trace
3117: (p_msg => 'security_id_char_2 = '||
3118: xla_events_pub_pkg.g_security.security_id_char_2
3119: ,p_level => C_LEVEL_PROCEDURE
3120: ,p_module =>l_log_module);
3121: trace
3122: (p_msg => 'security_id_char_3 = '||

Line 3123: xla_events_pub_pkg.g_security.security_id_char_3

3119: ,p_level => C_LEVEL_PROCEDURE
3120: ,p_module =>l_log_module);
3121: trace
3122: (p_msg => 'security_id_char_3 = '||
3123: xla_events_pub_pkg.g_security.security_id_char_3
3124: ,p_level => C_LEVEL_PROCEDURE
3125: ,p_module =>l_log_module);
3126: trace
3127: (p_msg => 'valuation_method = '||p_valuation_method

Line 3207: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

3203: SELECT event_id BULK COLLECT
3204: INTO l_array_events
3205: FROM xla_events
3206: WHERE event_date = NVL(l_event_date, event_date)
3207: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
3208: AND event_type_code = NVL(p_event_type_code, event_type_code)
3209: AND entity_id = g_entity_id
3210: AND event_type_code IN
3211: (SELECT event_type_code

Line 3222: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED

3218: SELECT event_id, event_number BULK COLLECT
3219: INTO l_array_events, g_gapless_event_number
3220: FROM xla_events
3221: WHERE event_date = NVL(l_event_date, event_date)
3222: AND event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED
3223: AND event_type_code = NVL(p_event_type_code, event_type_code)
3224: AND entity_id = g_entity_id
3225: AND event_type_code IN
3226: (SELECT event_type_code

Line 3310: (p_source_info IN xla_events_pub_pkg.t_event_source_info

3306: --
3307: --============================================================================
3308:
3309: FUNCTION delete_entity
3310: (p_source_info IN xla_events_pub_pkg.t_event_source_info
3311: ,p_valuation_method IN VARCHAR2)
3312: RETURN INTEGER IS
3313:
3314: l_log_module VARCHAR2(240);

Line 3390: xla_events_pub_pkg.g_security.security_id_int_1

3386: ,p_level => C_LEVEL_PROCEDURE
3387: ,p_module =>l_log_module);
3388: trace
3389: (p_msg => 'security_id_int_1 = '||
3390: xla_events_pub_pkg.g_security.security_id_int_1
3391: ,p_level => C_LEVEL_PROCEDURE
3392: ,p_module =>l_log_module);
3393: trace
3394: (p_msg => 'security_id_int_2 = '||

Line 3395: xla_events_pub_pkg.g_security.security_id_int_2

3391: ,p_level => C_LEVEL_PROCEDURE
3392: ,p_module =>l_log_module);
3393: trace
3394: (p_msg => 'security_id_int_2 = '||
3395: xla_events_pub_pkg.g_security.security_id_int_2
3396: ,p_level => C_LEVEL_PROCEDURE
3397: ,p_module =>l_log_module);
3398: trace
3399: (p_msg => 'security_id_int_3 = '||

Line 3400: xla_events_pub_pkg.g_security.security_id_int_3

3396: ,p_level => C_LEVEL_PROCEDURE
3397: ,p_module =>l_log_module);
3398: trace
3399: (p_msg => 'security_id_int_3 = '||
3400: xla_events_pub_pkg.g_security.security_id_int_3
3401: ,p_level => C_LEVEL_PROCEDURE
3402: ,p_module =>l_log_module);
3403: trace
3404: (p_msg => 'security_id_char_1 = '||

Line 3405: xla_events_pub_pkg.g_security.security_id_char_1

3401: ,p_level => C_LEVEL_PROCEDURE
3402: ,p_module =>l_log_module);
3403: trace
3404: (p_msg => 'security_id_char_1 = '||
3405: xla_events_pub_pkg.g_security.security_id_char_1
3406: ,p_level => C_LEVEL_PROCEDURE
3407: ,p_module =>l_log_module);
3408: trace
3409: (p_msg => 'security_id_char_2 = '||

Line 3410: xla_events_pub_pkg.g_security.security_id_char_2

3406: ,p_level => C_LEVEL_PROCEDURE
3407: ,p_module =>l_log_module);
3408: trace
3409: (p_msg => 'security_id_char_2 = '||
3410: xla_events_pub_pkg.g_security.security_id_char_2
3411: ,p_level => C_LEVEL_PROCEDURE
3412: ,p_module =>l_log_module);
3413: trace
3414: (p_msg => 'security_id_char_3 = '||

Line 3415: xla_events_pub_pkg.g_security.security_id_char_3

3411: ,p_level => C_LEVEL_PROCEDURE
3412: ,p_module =>l_log_module);
3413: trace
3414: (p_msg => 'security_id_char_3 = '||
3415: xla_events_pub_pkg.g_security.security_id_char_3
3416: ,p_level => C_LEVEL_PROCEDURE
3417: ,p_module =>l_log_module);
3418: trace
3419: (p_msg => 'valuation_method = '||p_valuation_method

Line 3464: NVL(xla_events_pub_pkg.g_security.security_id_int_1,C_NUM)

3460: NVL(p_source_info.source_id_char_4,C_CHAR)
3461: AND NVL(a.valuation_method,C_CHAR) =
3462: NVL(p_valuation_method,C_CHAR)
3463: AND NVL(a.security_id_int_1,C_NUM) =
3464: NVL(xla_events_pub_pkg.g_security.security_id_int_1,C_NUM)
3465: AND NVL(a.security_id_int_2,C_NUM) =
3466: NVL(xla_events_pub_pkg.g_security.security_id_int_2,C_NUM)
3467: AND NVL(a.security_id_int_3,C_NUM) =
3468: NVL(xla_events_pub_pkg.g_security.security_id_int_3,C_NUM)

Line 3466: NVL(xla_events_pub_pkg.g_security.security_id_int_2,C_NUM)

3462: NVL(p_valuation_method,C_CHAR)
3463: AND NVL(a.security_id_int_1,C_NUM) =
3464: NVL(xla_events_pub_pkg.g_security.security_id_int_1,C_NUM)
3465: AND NVL(a.security_id_int_2,C_NUM) =
3466: NVL(xla_events_pub_pkg.g_security.security_id_int_2,C_NUM)
3467: AND NVL(a.security_id_int_3,C_NUM) =
3468: NVL(xla_events_pub_pkg.g_security.security_id_int_3,C_NUM)
3469: AND NVL(a.security_id_char_1,C_CHAR) =
3470: NVL(xla_events_pub_pkg.g_security.security_id_char_1,C_CHAR)

Line 3468: NVL(xla_events_pub_pkg.g_security.security_id_int_3,C_NUM)

3464: NVL(xla_events_pub_pkg.g_security.security_id_int_1,C_NUM)
3465: AND NVL(a.security_id_int_2,C_NUM) =
3466: NVL(xla_events_pub_pkg.g_security.security_id_int_2,C_NUM)
3467: AND NVL(a.security_id_int_3,C_NUM) =
3468: NVL(xla_events_pub_pkg.g_security.security_id_int_3,C_NUM)
3469: AND NVL(a.security_id_char_1,C_CHAR) =
3470: NVL(xla_events_pub_pkg.g_security.security_id_char_1,C_CHAR)
3471: AND NVL(a.security_id_char_2,C_CHAR) =
3472: NVL(xla_events_pub_pkg.g_security.security_id_char_2,C_CHAR)

Line 3470: NVL(xla_events_pub_pkg.g_security.security_id_char_1,C_CHAR)

3466: NVL(xla_events_pub_pkg.g_security.security_id_int_2,C_NUM)
3467: AND NVL(a.security_id_int_3,C_NUM) =
3468: NVL(xla_events_pub_pkg.g_security.security_id_int_3,C_NUM)
3469: AND NVL(a.security_id_char_1,C_CHAR) =
3470: NVL(xla_events_pub_pkg.g_security.security_id_char_1,C_CHAR)
3471: AND NVL(a.security_id_char_2,C_CHAR) =
3472: NVL(xla_events_pub_pkg.g_security.security_id_char_2,C_CHAR)
3473: AND NVL(a.security_id_char_3,C_CHAR) =
3474: NVL(xla_events_pub_pkg.g_security.security_id_char_3,C_CHAR);

Line 3472: NVL(xla_events_pub_pkg.g_security.security_id_char_2,C_CHAR)

3468: NVL(xla_events_pub_pkg.g_security.security_id_int_3,C_NUM)
3469: AND NVL(a.security_id_char_1,C_CHAR) =
3470: NVL(xla_events_pub_pkg.g_security.security_id_char_1,C_CHAR)
3471: AND NVL(a.security_id_char_2,C_CHAR) =
3472: NVL(xla_events_pub_pkg.g_security.security_id_char_2,C_CHAR)
3473: AND NVL(a.security_id_char_3,C_CHAR) =
3474: NVL(xla_events_pub_pkg.g_security.security_id_char_3,C_CHAR);
3475: EXCEPTION when others then
3476: xla_exceptions_pkg.raise_message

Line 3474: NVL(xla_events_pub_pkg.g_security.security_id_char_3,C_CHAR);

3470: NVL(xla_events_pub_pkg.g_security.security_id_char_1,C_CHAR)
3471: AND NVL(a.security_id_char_2,C_CHAR) =
3472: NVL(xla_events_pub_pkg.g_security.security_id_char_2,C_CHAR)
3473: AND NVL(a.security_id_char_3,C_CHAR) =
3474: NVL(xla_events_pub_pkg.g_security.security_id_char_3,C_CHAR);
3475: EXCEPTION when others then
3476: xla_exceptions_pkg.raise_message
3477: (p_appli_s_name => 'XLA'
3478: ,p_msg_name => 'XLA_COMMON_ERROR'

Line 3545: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info) IS

3541: --
3542: --=============================================================================
3543:
3544: PROCEDURE purge_entity
3545: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info) IS
3546: BEGIN
3547: trace('> xla_events_pkg.delete_entity' , 20);
3548:
3549: SAVEPOINT before_entity_delete;

Line 3606: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

3602: --
3603: --=============================================================================
3604:
3605: FUNCTION get_event_info
3606: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
3607: ,p_valuation_method IN VARCHAR2
3608: ,p_event_id IN INTEGER)
3609: RETURN xla_events_pub_pkg.t_event_info IS
3610:

Line 3609: RETURN xla_events_pub_pkg.t_event_info IS

3605: FUNCTION get_event_info
3606: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
3607: ,p_valuation_method IN VARCHAR2
3608: ,p_event_id IN INTEGER)
3609: RETURN xla_events_pub_pkg.t_event_info IS
3610:
3611: l_event_info xla_events_pub_pkg.t_event_info;
3612: l_log_module VARCHAR2(240);
3613:

Line 3611: l_event_info xla_events_pub_pkg.t_event_info;

3607: ,p_valuation_method IN VARCHAR2
3608: ,p_event_id IN INTEGER)
3609: RETURN xla_events_pub_pkg.t_event_info IS
3610:
3611: l_event_info xla_events_pub_pkg.t_event_info;
3612: l_log_module VARCHAR2(240);
3613:
3614: BEGIN
3615: IF g_log_enabled THEN

Line 3697: xla_events_pub_pkg.g_security.security_id_int_1

3693: ,p_level => C_LEVEL_PROCEDURE
3694: ,p_module =>l_log_module);
3695: trace
3696: (p_msg => 'security_id_int_1 = '||
3697: xla_events_pub_pkg.g_security.security_id_int_1
3698: ,p_level => C_LEVEL_PROCEDURE
3699: ,p_module =>l_log_module);
3700: trace
3701: (p_msg => 'security_id_int_2 = '||

Line 3702: xla_events_pub_pkg.g_security.security_id_int_2

3698: ,p_level => C_LEVEL_PROCEDURE
3699: ,p_module =>l_log_module);
3700: trace
3701: (p_msg => 'security_id_int_2 = '||
3702: xla_events_pub_pkg.g_security.security_id_int_2
3703: ,p_level => C_LEVEL_PROCEDURE
3704: ,p_module =>l_log_module);
3705: trace
3706: (p_msg => 'security_id_int_3 = '||

Line 3707: xla_events_pub_pkg.g_security.security_id_int_3

3703: ,p_level => C_LEVEL_PROCEDURE
3704: ,p_module =>l_log_module);
3705: trace
3706: (p_msg => 'security_id_int_3 = '||
3707: xla_events_pub_pkg.g_security.security_id_int_3
3708: ,p_level => C_LEVEL_PROCEDURE
3709: ,p_module =>l_log_module);
3710: trace
3711: (p_msg => 'security_id_char_1 = '||

Line 3712: xla_events_pub_pkg.g_security.security_id_char_1

3708: ,p_level => C_LEVEL_PROCEDURE
3709: ,p_module =>l_log_module);
3710: trace
3711: (p_msg => 'security_id_char_1 = '||
3712: xla_events_pub_pkg.g_security.security_id_char_1
3713: ,p_level => C_LEVEL_PROCEDURE
3714: ,p_module =>l_log_module);
3715: trace
3716: (p_msg => 'security_id_char_2 = '||

Line 3717: xla_events_pub_pkg.g_security.security_id_char_2

3713: ,p_level => C_LEVEL_PROCEDURE
3714: ,p_module =>l_log_module);
3715: trace
3716: (p_msg => 'security_id_char_2 = '||
3717: xla_events_pub_pkg.g_security.security_id_char_2
3718: ,p_level => C_LEVEL_PROCEDURE
3719: ,p_module =>l_log_module);
3720: trace
3721: (p_msg => 'security_id_char_3 = '||

Line 3722: xla_events_pub_pkg.g_security.security_id_char_3

3718: ,p_level => C_LEVEL_PROCEDURE
3719: ,p_module =>l_log_module);
3720: trace
3721: (p_msg => 'security_id_char_3 = '||
3722: xla_events_pub_pkg.g_security.security_id_char_3
3723: ,p_level => C_LEVEL_PROCEDURE
3724: ,p_module =>l_log_module);
3725: trace
3726: (p_msg => 'valuation_method = '||p_valuation_method

Line 3870: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

3866: --
3867: --=============================================================================
3868:
3869: FUNCTION get_event_status
3870: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
3871: ,p_valuation_method IN VARCHAR2
3872: ,p_event_id IN INTEGER)
3873: RETURN VARCHAR2 IS
3874:

Line 3875: l_event_info xla_events_pub_pkg.t_event_info;

3871: ,p_valuation_method IN VARCHAR2
3872: ,p_event_id IN INTEGER)
3873: RETURN VARCHAR2 IS
3874:
3875: l_event_info xla_events_pub_pkg.t_event_info;
3876: l_log_module VARCHAR2(240);
3877: BEGIN
3878: IF g_log_enabled THEN
3879: l_log_module := C_DEFAULT_MODULE||'.get_event_status';

Line 3960: xla_events_pub_pkg.g_security.security_id_int_1

3956: ,p_level => C_LEVEL_PROCEDURE
3957: ,p_module =>l_log_module);
3958: trace
3959: (p_msg => 'security_id_int_1 = '||
3960: xla_events_pub_pkg.g_security.security_id_int_1
3961: ,p_level => C_LEVEL_PROCEDURE
3962: ,p_module =>l_log_module);
3963: trace
3964: (p_msg => 'security_id_int_2 = '||

Line 3965: xla_events_pub_pkg.g_security.security_id_int_2

3961: ,p_level => C_LEVEL_PROCEDURE
3962: ,p_module =>l_log_module);
3963: trace
3964: (p_msg => 'security_id_int_2 = '||
3965: xla_events_pub_pkg.g_security.security_id_int_2
3966: ,p_level => C_LEVEL_PROCEDURE
3967: ,p_module =>l_log_module);
3968: trace
3969: (p_msg => 'security_id_int_3 = '||

Line 3970: xla_events_pub_pkg.g_security.security_id_int_3

3966: ,p_level => C_LEVEL_PROCEDURE
3967: ,p_module =>l_log_module);
3968: trace
3969: (p_msg => 'security_id_int_3 = '||
3970: xla_events_pub_pkg.g_security.security_id_int_3
3971: ,p_level => C_LEVEL_PROCEDURE
3972: ,p_module =>l_log_module);
3973: trace
3974: (p_msg => 'security_id_char_1 = '||

Line 3975: xla_events_pub_pkg.g_security.security_id_char_1

3971: ,p_level => C_LEVEL_PROCEDURE
3972: ,p_module =>l_log_module);
3973: trace
3974: (p_msg => 'security_id_char_1 = '||
3975: xla_events_pub_pkg.g_security.security_id_char_1
3976: ,p_level => C_LEVEL_PROCEDURE
3977: ,p_module =>l_log_module);
3978: trace
3979: (p_msg => 'security_id_char_2 = '||

Line 3980: xla_events_pub_pkg.g_security.security_id_char_2

3976: ,p_level => C_LEVEL_PROCEDURE
3977: ,p_module =>l_log_module);
3978: trace
3979: (p_msg => 'security_id_char_2 = '||
3980: xla_events_pub_pkg.g_security.security_id_char_2
3981: ,p_level => C_LEVEL_PROCEDURE
3982: ,p_module =>l_log_module);
3983: trace
3984: (p_msg => 'security_id_char_3 = '||

Line 3985: xla_events_pub_pkg.g_security.security_id_char_3

3981: ,p_level => C_LEVEL_PROCEDURE
3982: ,p_module =>l_log_module);
3983: trace
3984: (p_msg => 'security_id_char_3 = '||
3985: xla_events_pub_pkg.g_security.security_id_char_3
3986: ,p_level => C_LEVEL_PROCEDURE
3987: ,p_module =>l_log_module);
3988: trace
3989: (p_msg => 'valuation_method = '||p_valuation_method

Line 4028: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

4024: --
4025: --=============================================================================
4026:
4027: FUNCTION event_exists
4028: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
4029: ,p_valuation_method IN VARCHAR2
4030: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
4031: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
4032: ,p_event_date IN DATE DEFAULT NULL

Line 4160: xla_events_pub_pkg.g_security.security_id_int_1

4156: ,p_level => C_LEVEL_PROCEDURE
4157: ,p_module =>l_log_module);
4158: trace
4159: (p_msg => 'security_id_int_1 = '||
4160: xla_events_pub_pkg.g_security.security_id_int_1
4161: ,p_level => C_LEVEL_PROCEDURE
4162: ,p_module =>l_log_module);
4163: trace
4164: (p_msg => 'security_id_int_2 = '||

Line 4165: xla_events_pub_pkg.g_security.security_id_int_2

4161: ,p_level => C_LEVEL_PROCEDURE
4162: ,p_module =>l_log_module);
4163: trace
4164: (p_msg => 'security_id_int_2 = '||
4165: xla_events_pub_pkg.g_security.security_id_int_2
4166: ,p_level => C_LEVEL_PROCEDURE
4167: ,p_module =>l_log_module);
4168: trace
4169: (p_msg => 'security_id_int_3 = '||

Line 4170: xla_events_pub_pkg.g_security.security_id_int_3

4166: ,p_level => C_LEVEL_PROCEDURE
4167: ,p_module =>l_log_module);
4168: trace
4169: (p_msg => 'security_id_int_3 = '||
4170: xla_events_pub_pkg.g_security.security_id_int_3
4171: ,p_level => C_LEVEL_PROCEDURE
4172: ,p_module =>l_log_module);
4173: trace
4174: (p_msg => 'security_id_char_1 = '||

Line 4175: xla_events_pub_pkg.g_security.security_id_char_1

4171: ,p_level => C_LEVEL_PROCEDURE
4172: ,p_module =>l_log_module);
4173: trace
4174: (p_msg => 'security_id_char_1 = '||
4175: xla_events_pub_pkg.g_security.security_id_char_1
4176: ,p_level => C_LEVEL_PROCEDURE
4177: ,p_module =>l_log_module);
4178: trace
4179: (p_msg => 'security_id_char_2 = '||

Line 4180: xla_events_pub_pkg.g_security.security_id_char_2

4176: ,p_level => C_LEVEL_PROCEDURE
4177: ,p_module =>l_log_module);
4178: trace
4179: (p_msg => 'security_id_char_2 = '||
4180: xla_events_pub_pkg.g_security.security_id_char_2
4181: ,p_level => C_LEVEL_PROCEDURE
4182: ,p_module =>l_log_module);
4183: trace
4184: (p_msg => 'security_id_char_3 = '||

Line 4185: xla_events_pub_pkg.g_security.security_id_char_3

4181: ,p_level => C_LEVEL_PROCEDURE
4182: ,p_module =>l_log_module);
4183: trace
4184: (p_msg => 'security_id_char_3 = '||
4185: xla_events_pub_pkg.g_security.security_id_char_3
4186: ,p_level => C_LEVEL_PROCEDURE
4187: ,p_module =>l_log_module);
4188: trace
4189: (p_msg => 'valuation_method = '||p_valuation_method

Line 4340: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

4336: --
4337: --=============================================================================
4338:
4339: PROCEDURE update_transaction_number
4340: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
4341: ,p_valuation_method IN VARCHAR2
4342: ,p_transaction_number IN VARCHAR2
4343: ,p_event_id IN PLS_INTEGER DEFAULT NULL) IS
4344: l_log_module VARCHAR2(240);

Line 4432: xla_events_pub_pkg.g_security.security_id_int_1

4428: ,p_level => C_LEVEL_PROCEDURE
4429: ,p_module =>l_log_module);
4430: trace
4431: (p_msg => 'security_id_int_1 = '||
4432: xla_events_pub_pkg.g_security.security_id_int_1
4433: ,p_level => C_LEVEL_PROCEDURE
4434: ,p_module =>l_log_module);
4435: trace
4436: (p_msg => 'security_id_int_2 = '||

Line 4437: xla_events_pub_pkg.g_security.security_id_int_2

4433: ,p_level => C_LEVEL_PROCEDURE
4434: ,p_module =>l_log_module);
4435: trace
4436: (p_msg => 'security_id_int_2 = '||
4437: xla_events_pub_pkg.g_security.security_id_int_2
4438: ,p_level => C_LEVEL_PROCEDURE
4439: ,p_module =>l_log_module);
4440: trace
4441: (p_msg => 'security_id_int_3 = '||

Line 4442: xla_events_pub_pkg.g_security.security_id_int_3

4438: ,p_level => C_LEVEL_PROCEDURE
4439: ,p_module =>l_log_module);
4440: trace
4441: (p_msg => 'security_id_int_3 = '||
4442: xla_events_pub_pkg.g_security.security_id_int_3
4443: ,p_level => C_LEVEL_PROCEDURE
4444: ,p_module =>l_log_module);
4445: trace
4446: (p_msg => 'security_id_char_1 = '||

Line 4447: xla_events_pub_pkg.g_security.security_id_char_1

4443: ,p_level => C_LEVEL_PROCEDURE
4444: ,p_module =>l_log_module);
4445: trace
4446: (p_msg => 'security_id_char_1 = '||
4447: xla_events_pub_pkg.g_security.security_id_char_1
4448: ,p_level => C_LEVEL_PROCEDURE
4449: ,p_module =>l_log_module);
4450: trace
4451: (p_msg => 'security_id_char_2 = '||

Line 4452: xla_events_pub_pkg.g_security.security_id_char_2

4448: ,p_level => C_LEVEL_PROCEDURE
4449: ,p_module =>l_log_module);
4450: trace
4451: (p_msg => 'security_id_char_2 = '||
4452: xla_events_pub_pkg.g_security.security_id_char_2
4453: ,p_level => C_LEVEL_PROCEDURE
4454: ,p_module =>l_log_module);
4455: trace
4456: (p_msg => 'security_id_char_3 = '||

Line 4457: xla_events_pub_pkg.g_security.security_id_char_3

4453: ,p_level => C_LEVEL_PROCEDURE
4454: ,p_module =>l_log_module);
4455: trace
4456: (p_msg => 'security_id_char_3 = '||
4457: xla_events_pub_pkg.g_security.security_id_char_3
4458: ,p_level => C_LEVEL_PROCEDURE
4459: ,p_module =>l_log_module);
4460: trace
4461: (p_msg => 'valuation_method = '||p_valuation_method

Line 4555: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

4551: --
4552: --=============================================================================
4553:
4554: FUNCTION get_entity_id
4555: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
4556: ,p_valuation_method IN VARCHAR2
4557: ,p_event_id IN PLS_INTEGER DEFAULT NULL)
4558: RETURN INTEGER IS
4559: l_log_module VARCHAR2(240);

Line 4643: xla_events_pub_pkg.g_security.security_id_int_1

4639: ,p_level => C_LEVEL_PROCEDURE
4640: ,p_module =>l_log_module);
4641: trace
4642: (p_msg => 'security_id_int_1 = '||
4643: xla_events_pub_pkg.g_security.security_id_int_1
4644: ,p_level => C_LEVEL_PROCEDURE
4645: ,p_module =>l_log_module);
4646: trace
4647: (p_msg => 'security_id_int_2 = '||

Line 4648: xla_events_pub_pkg.g_security.security_id_int_2

4644: ,p_level => C_LEVEL_PROCEDURE
4645: ,p_module =>l_log_module);
4646: trace
4647: (p_msg => 'security_id_int_2 = '||
4648: xla_events_pub_pkg.g_security.security_id_int_2
4649: ,p_level => C_LEVEL_PROCEDURE
4650: ,p_module =>l_log_module);
4651: trace
4652: (p_msg => 'security_id_int_3 = '||

Line 4653: xla_events_pub_pkg.g_security.security_id_int_3

4649: ,p_level => C_LEVEL_PROCEDURE
4650: ,p_module =>l_log_module);
4651: trace
4652: (p_msg => 'security_id_int_3 = '||
4653: xla_events_pub_pkg.g_security.security_id_int_3
4654: ,p_level => C_LEVEL_PROCEDURE
4655: ,p_module =>l_log_module);
4656: trace
4657: (p_msg => 'security_id_char_1 = '||

Line 4658: xla_events_pub_pkg.g_security.security_id_char_1

4654: ,p_level => C_LEVEL_PROCEDURE
4655: ,p_module =>l_log_module);
4656: trace
4657: (p_msg => 'security_id_char_1 = '||
4658: xla_events_pub_pkg.g_security.security_id_char_1
4659: ,p_level => C_LEVEL_PROCEDURE
4660: ,p_module =>l_log_module);
4661: trace
4662: (p_msg => 'security_id_char_2 = '||

Line 4663: xla_events_pub_pkg.g_security.security_id_char_2

4659: ,p_level => C_LEVEL_PROCEDURE
4660: ,p_module =>l_log_module);
4661: trace
4662: (p_msg => 'security_id_char_2 = '||
4663: xla_events_pub_pkg.g_security.security_id_char_2
4664: ,p_level => C_LEVEL_PROCEDURE
4665: ,p_module =>l_log_module);
4666: trace
4667: (p_msg => 'security_id_char_3 = '||

Line 4668: xla_events_pub_pkg.g_security.security_id_char_3

4664: ,p_level => C_LEVEL_PROCEDURE
4665: ,p_module =>l_log_module);
4666: trace
4667: (p_msg => 'security_id_char_3 = '||
4668: xla_events_pub_pkg.g_security.security_id_char_3
4669: ,p_level => C_LEVEL_PROCEDURE
4670: ,p_module =>l_log_module);
4671: trace
4672: (p_msg => 'valuation_method = '||p_valuation_method

Line 4822: l_array_event_number xla_events_pub_pkg.t_array_event_number;

4818:
4819: l_array_entity_id t_array_number;
4820: l_array_event_id t_array_number;
4821:
4822: l_array_event_number xla_events_pub_pkg.t_array_event_number;
4823: l_array_event_date xla_events_pub_pkg.t_array_event_date;
4824: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;
4825: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
4826: l_last PLS_INTEGER;

Line 4823: l_array_event_date xla_events_pub_pkg.t_array_event_date;

4819: l_array_entity_id t_array_number;
4820: l_array_event_id t_array_number;
4821:
4822: l_array_event_number xla_events_pub_pkg.t_array_event_number;
4823: l_array_event_date xla_events_pub_pkg.t_array_event_date;
4824: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;
4825: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
4826: l_last PLS_INTEGER;
4827: l_entity_id PLS_INTEGER;

Line 4824: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;

4820: l_array_event_id t_array_number;
4821:
4822: l_array_event_number xla_events_pub_pkg.t_array_event_number;
4823: l_array_event_date xla_events_pub_pkg.t_array_event_date;
4824: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;
4825: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
4826: l_last PLS_INTEGER;
4827: l_entity_id PLS_INTEGER;
4828: l_current_entity_id PLS_INTEGER;

Line 4825: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;

4821:
4822: l_array_event_number xla_events_pub_pkg.t_array_event_number;
4823: l_array_event_date xla_events_pub_pkg.t_array_event_date;
4824: l_array_transaction_date xla_events_pub_pkg.t_array_event_date;
4825: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
4826: l_last PLS_INTEGER;
4827: l_entity_id PLS_INTEGER;
4828: l_current_entity_id PLS_INTEGER;
4829: l_current_event_number NUMBER;

Line 5496: l_array_event_number xla_events_pub_pkg.t_array_event_number;

5492: TYPE t_array_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5493:
5494: l_array_entity_id t_array_number;
5495: l_array_event_id t_array_number;
5496: l_array_event_number xla_events_pub_pkg.t_array_event_number;
5497: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
5498:
5499: l_array_on_hold_flag t_on_hold_flag_tbl;
5500:

Line 5497: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;

5493:
5494: l_array_entity_id t_array_number;
5495: l_array_event_id t_array_number;
5496: l_array_event_number xla_events_pub_pkg.t_array_event_number;
5497: l_array_event_status_code xla_events_pub_pkg.t_array_event_status_code;
5498:
5499: l_array_on_hold_flag t_on_hold_flag_tbl;
5500:
5501: l_log_module VARCHAR2(240);

Line 6177: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

6173: --
6174: --=============================================================================
6175:
6176: FUNCTION get_array_event_info
6177: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
6178: ,p_valuation_method IN VARCHAR2
6179: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
6180: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
6181: ,p_event_date IN DATE DEFAULT NULL

Line 6183: RETURN xla_events_pub_pkg.t_array_event_info IS

6179: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
6180: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
6181: ,p_event_date IN DATE DEFAULT NULL
6182: ,p_event_status_code IN VARCHAR2 DEFAULT NULL)
6183: RETURN xla_events_pub_pkg.t_array_event_info IS
6184:
6185: l_array_event_info xla_events_pub_pkg.t_array_event_info;
6186: l_count INTEGER := 0;
6187: l_event_date DATE;

Line 6185: l_array_event_info xla_events_pub_pkg.t_array_event_info;

6181: ,p_event_date IN DATE DEFAULT NULL
6182: ,p_event_status_code IN VARCHAR2 DEFAULT NULL)
6183: RETURN xla_events_pub_pkg.t_array_event_info IS
6184:
6185: l_array_event_info xla_events_pub_pkg.t_array_event_info;
6186: l_count INTEGER := 0;
6187: l_event_date DATE;
6188:
6189: CURSOR c1 IS

Line 6315: xla_events_pub_pkg.g_security.security_id_int_1

6311: ,p_level => C_LEVEL_PROCEDURE
6312: ,p_module =>l_log_module);
6313: trace
6314: (p_msg => 'security_id_int_1 = '||
6315: xla_events_pub_pkg.g_security.security_id_int_1
6316: ,p_level => C_LEVEL_PROCEDURE
6317: ,p_module =>l_log_module);
6318: trace
6319: (p_msg => 'security_id_int_2 = '||

Line 6320: xla_events_pub_pkg.g_security.security_id_int_2

6316: ,p_level => C_LEVEL_PROCEDURE
6317: ,p_module =>l_log_module);
6318: trace
6319: (p_msg => 'security_id_int_2 = '||
6320: xla_events_pub_pkg.g_security.security_id_int_2
6321: ,p_level => C_LEVEL_PROCEDURE
6322: ,p_module =>l_log_module);
6323: trace
6324: (p_msg => 'security_id_int_3 = '||

Line 6325: xla_events_pub_pkg.g_security.security_id_int_3

6321: ,p_level => C_LEVEL_PROCEDURE
6322: ,p_module =>l_log_module);
6323: trace
6324: (p_msg => 'security_id_int_3 = '||
6325: xla_events_pub_pkg.g_security.security_id_int_3
6326: ,p_level => C_LEVEL_PROCEDURE
6327: ,p_module =>l_log_module);
6328: trace
6329: (p_msg => 'security_id_char_1 = '||

Line 6330: xla_events_pub_pkg.g_security.security_id_char_1

6326: ,p_level => C_LEVEL_PROCEDURE
6327: ,p_module =>l_log_module);
6328: trace
6329: (p_msg => 'security_id_char_1 = '||
6330: xla_events_pub_pkg.g_security.security_id_char_1
6331: ,p_level => C_LEVEL_PROCEDURE
6332: ,p_module =>l_log_module);
6333: trace
6334: (p_msg => 'security_id_char_2 = '||

Line 6335: xla_events_pub_pkg.g_security.security_id_char_2

6331: ,p_level => C_LEVEL_PROCEDURE
6332: ,p_module =>l_log_module);
6333: trace
6334: (p_msg => 'security_id_char_2 = '||
6335: xla_events_pub_pkg.g_security.security_id_char_2
6336: ,p_level => C_LEVEL_PROCEDURE
6337: ,p_module =>l_log_module);
6338: trace
6339: (p_msg => 'security_id_char_3 = '||

Line 6340: xla_events_pub_pkg.g_security.security_id_char_3

6336: ,p_level => C_LEVEL_PROCEDURE
6337: ,p_module =>l_log_module);
6338: trace
6339: (p_msg => 'security_id_char_3 = '||
6340: xla_events_pub_pkg.g_security.security_id_char_3
6341: ,p_level => C_LEVEL_PROCEDURE
6342: ,p_module =>l_log_module);
6343: trace
6344: (p_msg => 'valuation_method = '||p_valuation_method

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

6503:
6504: ----------------------------------------------------------------------------
6505: -- cache event status code
6506: ----------------------------------------------------------------------------
6507: g_event_status_code_tbl(1) := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
6508: g_event_status_code_tbl(2) := xla_events_pub_pkg.C_EVENT_INCOMPLETE;
6509: g_event_status_code_tbl(3) := xla_events_pub_pkg.C_EVENT_NOACTION;
6510: g_event_status_code_tbl(4) := xla_events_pub_pkg.C_EVENT_PROCESSED;
6511:

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

6504: ----------------------------------------------------------------------------
6505: -- cache event status code
6506: ----------------------------------------------------------------------------
6507: g_event_status_code_tbl(1) := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
6508: g_event_status_code_tbl(2) := xla_events_pub_pkg.C_EVENT_INCOMPLETE;
6509: g_event_status_code_tbl(3) := xla_events_pub_pkg.C_EVENT_NOACTION;
6510: g_event_status_code_tbl(4) := xla_events_pub_pkg.C_EVENT_PROCESSED;
6511:
6512: ----------------------------------------------------------------------------

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

6505: -- cache event status code
6506: ----------------------------------------------------------------------------
6507: g_event_status_code_tbl(1) := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
6508: g_event_status_code_tbl(2) := xla_events_pub_pkg.C_EVENT_INCOMPLETE;
6509: g_event_status_code_tbl(3) := xla_events_pub_pkg.C_EVENT_NOACTION;
6510: g_event_status_code_tbl(4) := xla_events_pub_pkg.C_EVENT_PROCESSED;
6511:
6512: ----------------------------------------------------------------------------
6513: -- cache process status code

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

6506: ----------------------------------------------------------------------------
6507: g_event_status_code_tbl(1) := xla_events_pub_pkg.C_EVENT_UNPROCESSED;
6508: g_event_status_code_tbl(2) := xla_events_pub_pkg.C_EVENT_INCOMPLETE;
6509: g_event_status_code_tbl(3) := xla_events_pub_pkg.C_EVENT_NOACTION;
6510: g_event_status_code_tbl(4) := xla_events_pub_pkg.C_EVENT_PROCESSED;
6511:
6512: ----------------------------------------------------------------------------
6513: -- cache process status code
6514: ----------------------------------------------------------------------------

Line 6593: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info

6589: --
6590: --=============================================================================
6591:
6592: FUNCTION source_info_changed
6593: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info
6594: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info
6595: ,p_valuation_method1 IN VARCHAR2
6596: ,p_valuation_method2 IN VARCHAR2)
6597: RETURN BOOLEAN IS

Line 6594: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info

6590: --=============================================================================
6591:
6592: FUNCTION source_info_changed
6593: (p_event_source_info1 IN xla_events_pub_pkg.t_event_source_info
6594: ,p_event_source_info2 IN xla_events_pub_pkg.t_event_source_info
6595: ,p_valuation_method1 IN VARCHAR2
6596: ,p_valuation_method2 IN VARCHAR2)
6597: RETURN BOOLEAN IS
6598: l_log_module VARCHAR2(240);

Line 7717: IF p_event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED THEN

7713: ,p_token_2 => 'LOCATION'
7714: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7715: END IF;
7716:
7717: IF p_event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED THEN
7718: xla_exceptions_pkg.raise_message
7719: (p_appli_s_name => 'XLA'
7720: ,p_msg_name => 'XLA_COMMON_ERROR'
7721: ,p_token_1 => 'ERROR'

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

7730: -- for manual events
7731: -------------------------------------------------------------------------
7732:
7733: IF (p_process_status_code = C_INTERNAL_FINAL) THEN
7734: IF (p_event_status_code <> xla_events_pub_pkg.C_EVENT_PROCESSED) THEN
7735: xla_exceptions_pkg.raise_message
7736: (p_appli_s_name => 'XLA'
7737: ,p_msg_name => 'XLA_COMMON_ERROR'
7738: ,p_token_1 => 'ERROR'

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

7743: ,p_token_2 => 'LOCATION'
7744: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7745: END IF;
7746: ELSIF (p_process_status_code = C_INTERNAL_DRAFT) THEN
7747: IF (p_event_status_code <> xla_events_pub_pkg.C_EVENT_UNPROCESSED) THEN
7748: xla_exceptions_pkg.raise_message
7749: (p_appli_s_name => 'XLA'
7750: ,p_msg_name => 'XLA_COMMON_ERROR'
7751: ,p_token_1 => 'ERROR'

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

7756: ,p_token_2 => 'LOCATION'
7757: ,p_value_2 => 'xla_events_pkg.validate_status_code');
7758: END IF;
7759: ELSIF (p_process_status_code = C_INTERNAL_UNPROCESSED) THEN
7760: IF (p_event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED) THEN
7761: xla_exceptions_pkg.raise_message
7762: (p_appli_s_name => 'XLA'
7763: ,p_msg_name => 'XLA_COMMON_ERROR'
7764: ,p_token_1 => 'ERROR'

Line 7809: (p_source_info IN xla_events_pub_pkg.t_event_source_info

7805: --
7806: --=============================================================================
7807:
7808: PROCEDURE validate_params
7809: (p_source_info IN xla_events_pub_pkg.t_event_source_info
7810: ,p_event_class_code IN VARCHAR2 DEFAULT NULL
7811: ,p_event_type_code IN VARCHAR2 DEFAULT NULL
7812: ,p_event_date IN DATE DEFAULT NULL
7813: ,p_event_status_code IN VARCHAR2 DEFAULT NULL

Line 8005: (p_source_info IN xla_events_pub_pkg.t_event_source_info

8001: --
8002: --=============================================================================
8003:
8004: PROCEDURE cache_entity_info
8005: (p_source_info IN xla_events_pub_pkg.t_event_source_info
8006: ,p_valuation_method IN VARCHAR2
8007: ,p_event_id IN PLS_INTEGER) IS
8008:
8009: l_source_info xla_events_pub_pkg.t_event_source_info;

Line 8009: l_source_info xla_events_pub_pkg.t_event_source_info;

8005: (p_source_info IN xla_events_pub_pkg.t_event_source_info
8006: ,p_valuation_method IN VARCHAR2
8007: ,p_event_id IN PLS_INTEGER) IS
8008:
8009: l_source_info xla_events_pub_pkg.t_event_source_info;
8010:
8011: -------------------------------------------------------------------------------
8012: -- Following three cursors have been modified to remove the 'for update'.
8013: -- The cursors c1 and c2 have also been modified to include 'group by' rather

Line 8313: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info

8309: --
8310: --=============================================================================
8311:
8312: FUNCTION create_entity_event
8313: (p_event_source_info IN xla_events_pub_pkg.t_event_source_info
8314: ,p_valuation_method IN VARCHAR2
8315: ,p_event_type_code IN VARCHAR2
8316: ,p_event_date IN DATE
8317: ,p_event_status_code IN VARCHAR2

Line 8321: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

8317: ,p_event_status_code IN VARCHAR2
8318: ,p_process_status_code IN VARCHAR2
8319: ,p_event_number IN NUMBER
8320: ,p_transaction_date IN DATE
8321: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
8322: DEFAULT NULL
8323: ,p_budgetary_control_flag IN VARCHAR2)
8324: RETURN INTEGER IS
8325:

Line 8383: ,xla_events_pub_pkg.g_security.security_id_int_1

8379: ,sysdate
8380: ,xla_environment_pkg.g_usr_id
8381: ,xla_environment_pkg.g_login_id
8382: ,p_valuation_method
8383: ,xla_events_pub_pkg.g_security.security_id_int_1
8384: ,xla_events_pub_pkg.g_security.security_id_int_2
8385: ,xla_events_pub_pkg.g_security.security_id_int_3
8386: ,xla_events_pub_pkg.g_security.security_id_char_1
8387: ,xla_events_pub_pkg.g_security.security_id_char_2

Line 8384: ,xla_events_pub_pkg.g_security.security_id_int_2

8380: ,xla_environment_pkg.g_usr_id
8381: ,xla_environment_pkg.g_login_id
8382: ,p_valuation_method
8383: ,xla_events_pub_pkg.g_security.security_id_int_1
8384: ,xla_events_pub_pkg.g_security.security_id_int_2
8385: ,xla_events_pub_pkg.g_security.security_id_int_3
8386: ,xla_events_pub_pkg.g_security.security_id_char_1
8387: ,xla_events_pub_pkg.g_security.security_id_char_2
8388: ,xla_events_pub_pkg.g_security.security_id_char_3

Line 8385: ,xla_events_pub_pkg.g_security.security_id_int_3

8381: ,xla_environment_pkg.g_login_id
8382: ,p_valuation_method
8383: ,xla_events_pub_pkg.g_security.security_id_int_1
8384: ,xla_events_pub_pkg.g_security.security_id_int_2
8385: ,xla_events_pub_pkg.g_security.security_id_int_3
8386: ,xla_events_pub_pkg.g_security.security_id_char_1
8387: ,xla_events_pub_pkg.g_security.security_id_char_2
8388: ,xla_events_pub_pkg.g_security.security_id_char_3
8389: ,p_event_source_info.source_id_int_1

Line 8386: ,xla_events_pub_pkg.g_security.security_id_char_1

8382: ,p_valuation_method
8383: ,xla_events_pub_pkg.g_security.security_id_int_1
8384: ,xla_events_pub_pkg.g_security.security_id_int_2
8385: ,xla_events_pub_pkg.g_security.security_id_int_3
8386: ,xla_events_pub_pkg.g_security.security_id_char_1
8387: ,xla_events_pub_pkg.g_security.security_id_char_2
8388: ,xla_events_pub_pkg.g_security.security_id_char_3
8389: ,p_event_source_info.source_id_int_1
8390: ,p_event_source_info.source_id_int_2

Line 8387: ,xla_events_pub_pkg.g_security.security_id_char_2

8383: ,xla_events_pub_pkg.g_security.security_id_int_1
8384: ,xla_events_pub_pkg.g_security.security_id_int_2
8385: ,xla_events_pub_pkg.g_security.security_id_int_3
8386: ,xla_events_pub_pkg.g_security.security_id_char_1
8387: ,xla_events_pub_pkg.g_security.security_id_char_2
8388: ,xla_events_pub_pkg.g_security.security_id_char_3
8389: ,p_event_source_info.source_id_int_1
8390: ,p_event_source_info.source_id_int_2
8391: ,p_event_source_info.source_id_int_3

Line 8388: ,xla_events_pub_pkg.g_security.security_id_char_3

8384: ,xla_events_pub_pkg.g_security.security_id_int_2
8385: ,xla_events_pub_pkg.g_security.security_id_int_3
8386: ,xla_events_pub_pkg.g_security.security_id_char_1
8387: ,xla_events_pub_pkg.g_security.security_id_char_2
8388: ,xla_events_pub_pkg.g_security.security_id_char_3
8389: ,p_event_source_info.source_id_int_1
8390: ,p_event_source_info.source_id_int_2
8391: ,p_event_source_info.source_id_int_3
8392: ,p_event_source_info.source_id_int_4

Line 8497: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info

8493: ,p_event_status_code IN VARCHAR2
8494: ,p_process_status_code IN VARCHAR2
8495: ,p_event_number IN NUMBER
8496: ,p_transaction_date IN DATE
8497: ,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
8498: DEFAULT NULL
8499: ,p_budgetary_control_flag IN VARCHAR2)
8500: RETURN INTEGER IS
8501: l_event_id INTEGER;

Line 8665: l_source_info xla_events_pub_pkg.t_event_source_info;

8661: l_dummy_class_tbl t_array_event_class;
8662: l_dummy_type_tbl t_array_event_type;
8663: l_dummy_entity_tbl t_array_entity_type;
8664: l_dummy_tbl t_parameter_tbl;
8665: l_source_info xla_events_pub_pkg.t_event_source_info;
8666: l_log_module VARCHAR2(240);
8667: BEGIN
8668: IF g_log_enabled THEN
8669: l_log_module := C_DEFAULT_MODULE||'.reset_cache';