[Home] [Help]
1: PACKAGE BODY xla_conditions_pkg AS
2: /* $Header: xlaamcon.pkb 120.26 2011/12/27 06:35:51 sgullape ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |
5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_conditions_pkg |
10: | |
11: | DESCRIPTION |
12: | XLA Conditions Package |
13: | |
8: | PACKAGE NAME |
9: | xla_conditions_pkg |
10: | |
11: | DESCRIPTION |
12: | XLA Conditions Package |
13: | |
14: | HISTORY |
15: | 01-May-01 Dimple Shah Created |
16: | |
24: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
25: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
26: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
27: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
28: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_conditions_pkg';
29:
30:
31: -- Global variables for debugging
32: g_log_level PLS_INTEGER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
110:
111: IF p_context = 'A' THEN
112:
113: DELETE
114: FROM xla_conditions
115: WHERE application_id = p_application_id
116: AND amb_context_code = p_amb_context_code
117: AND entity_code = p_entity_code
118: AND event_class_code = p_event_class_code
121:
122: ELSIF p_context = 'S' THEN
123:
124: DELETE
125: FROM xla_conditions
126: WHERE segment_rule_detail_id = p_segment_rule_detail_id;
127:
128: ELSIF p_context = 'D' THEN
129:
127:
128: ELSIF p_context = 'D' THEN
129:
130: DELETE
131: FROM xla_conditions
132: WHERE description_prio_id = p_description_prio_id;
133: END IF;
134:
135: trace('delete_condition.End',C_LEVEL_PROCEDURE,l_log_module);
138: WHEN xla_exceptions_pkg.application_exception THEN
139: RAISE;
140: WHEN OTHERS THEN
141: xla_exceptions_pkg.raise_message
142: (p_location => 'xla_conditions_pkg.delete_condition');
143:
144: END delete_condition;
145:
146: /*======================================================================+
175: flexfield_segment_code, value_flexfield_segment_code,
176: value_source_application_id, value_source_type_code,
177: value_source_code, value_constant, line_operator_code,
178: logical_operator_code, independent_value_constant
179: FROM xla_conditions
180: WHERE segment_rule_detail_id = p_segment_rule_detail_id
181: AND p_context = 'S'
182: UNION
183: SELECT user_sequence, bracket_left_code, bracket_right_code, value_type_code,
185: flexfield_segment_code, value_flexfield_segment_code,
186: value_source_application_id, value_source_type_code,
187: value_source_code, value_constant, line_operator_code,
188: logical_operator_code, independent_value_constant
189: FROM xla_conditions
190: WHERE application_id = p_application_id
191: AND amb_context_code = p_amb_context_code
192: AND entity_code = p_entity_code
193: AND event_class_code = p_event_class_code
200: flexfield_segment_code, value_flexfield_segment_code,
201: value_source_application_id, value_source_type_code,
202: value_source_code, value_constant, line_operator_code,
203: logical_operator_code, independent_value_constant
204: FROM xla_conditions
205: WHERE description_prio_id = p_description_prio_id
206: AND p_context = 'D'
207: ORDER BY user_sequence;
208:
543: xla_exceptions_pkg.raise_message
544: ('XLA'
545: ,'XLA_AB_COND_TOO_LONG'
546: ,'PROCEDURE'
547: ,'xla_conditions_pkg.display_condition'
548: ,'ERROR'
549: ,sqlerrm
550: );
551: END;
579: IF c_value_source_name%ISOPEN THEN
580: CLOSE c_value_source_name;
581: END IF;
582: xla_exceptions_pkg.raise_message
583: (p_location => 'xla_conditions_pkg.display_condition');
584:
585: END display_condition;
586:
587: /*======================================================================+
665:
666: EXCEPTION
667: WHEN OTHERS THEN
668: xla_exceptions_pkg.raise_message
669: (p_location => 'xla_conditions_pkg.display_condition_substr');
670: END display_condition_substr;
671:
672: /*======================================================================+
673: | |
711: AND d.amb_context_code = p_amb_context_code
712: AND d.description_type_code = p_description_type_code
713: AND d.description_code = p_description_code
714: AND exists(SELECT count(1)
715: FROM xla_conditions c
716: WHERE c.description_prio_id = d.description_prio_id
717: AND c.bracket_left_code is not null
718: MINUS
719: SELECT count(1)
716: WHERE c.description_prio_id = d.description_prio_id
717: AND c.bracket_left_code is not null
718: MINUS
719: SELECT count(1)
720: FROM xla_conditions c1
721: WHERE c1.description_prio_id = d.description_prio_id
722: AND c1.bracket_right_code is not null);
723:
724:
730: AND d.amb_context_code = p_amb_context_code
731: AND d.description_type_code = p_description_type_code
732: AND d.description_code = p_description_code
733: AND exists (SELECT 'y'
734: FROM xla_conditions c
735: WHERE c.description_prio_id = d.description_prio_id);
736:
737: CURSOR c_desc_max_left_seq(p_description_prio_id NUMBER)
738: IS
736:
737: CURSOR c_desc_max_left_seq(p_description_prio_id NUMBER)
738: IS
739: SELECT max(user_sequence)
740: FROM xla_conditions c
741: WHERE c.description_prio_id = p_description_prio_id
742: AND c.bracket_left_code is not null;
743:
744: CURSOR c_desc_max_right_seq(p_description_prio_id NUMBER)
743:
744: CURSOR c_desc_max_right_seq(p_description_prio_id NUMBER)
745: IS
746: SELECT max(user_sequence)
747: FROM xla_conditions c
748: WHERE c.description_prio_id = p_description_prio_id
749: AND c.bracket_right_code is not null;
750:
751: CURSOR c_desc_min_left_seq(p_description_prio_id NUMBER)
750:
751: CURSOR c_desc_min_left_seq(p_description_prio_id NUMBER)
752: IS
753: SELECT min(user_sequence)
754: FROM xla_conditions c
755: WHERE c.description_prio_id = p_description_prio_id
756: AND c.bracket_left_code is not null;
757:
758: CURSOR c_desc_min_right_seq(p_description_prio_id NUMBER)
757:
758: CURSOR c_desc_min_right_seq(p_description_prio_id NUMBER)
759: IS
760: SELECT min(user_sequence)
761: FROM xla_conditions c
762: WHERE c.description_prio_id = p_description_prio_id
763: AND c.bracket_right_code is not null;
764:
765: -- Check if any empty rows exist with just the sequence number
765: -- Check if any empty rows exist with just the sequence number
766: CURSOR c_source(p_description_prio_id NUMBER)
767: IS
768: SELECT 'x'
769: FROM xla_conditions c
770: WHERE c.description_prio_id = p_description_prio_id
771: AND c.bracket_left_code is null
772: AND c.bracket_right_code is null
773: AND c.source_code is null;
775: -- Check if any rows exist with just left and right bracket
776: CURSOR c_left_right_bracket(p_description_prio_id NUMBER)
777: IS
778: SELECT 'x'
779: FROM xla_conditions c
780: WHERE c.description_prio_id = p_description_prio_id
781: AND c.bracket_left_code is not null
782: AND c.bracket_right_code is not null
783: AND c.source_code is null;
785: -- Get the sequence for the last row
786: CURSOR c_desc_sequence(p_description_prio_id NUMBER)
787: IS
788: SELECT max(user_sequence)
789: FROM xla_conditions c
790: WHERE c.description_prio_id = p_description_prio_id;
791:
792: -- Check if last row has logical operator
793: CURSOR c_desc_last_operator(p_description_prio_id NUMBER)
792: -- Check if last row has logical operator
793: CURSOR c_desc_last_operator(p_description_prio_id NUMBER)
794: IS
795: SELECT 'x'
796: FROM xla_conditions c
797: WHERE c.description_prio_id = p_description_prio_id
798: AND c.user_sequence = l_desc_user_sequence
799: AND c.logical_operator_code is not null;
800:
801: -- Check if any rows exist with just left bracket and logical operator
802: CURSOR c_left_bracket_operator(p_description_prio_id NUMBER)
803: IS
804: SELECT 'x'
805: FROM xla_conditions c
806: WHERE c.description_prio_id = p_description_prio_id
807: AND c.bracket_left_code is not null
808: AND c.source_code is null
809: AND c.logical_operator_code is not null;
812: -- and have no logical operator
813: CURSOR c_no_logical_operator(p_description_prio_id NUMBER)
814: IS
815: SELECT user_sequence
816: FROM xla_conditions c
817: WHERE c.description_prio_id = p_description_prio_id
818: AND (c.source_code is not null
819: OR c.bracket_right_code is not null)
820: AND c.logical_operator_code is null
826: -- and have no logical operator
827: CURSOR c_only_right_bracket(p_description_prio_id NUMBER)
828: IS
829: SELECT 'x'
830: FROM xla_conditions c
831: WHERE c.description_prio_id = p_description_prio_id
832: AND c.source_code is null
833: AND c.bracket_right_code is not null
834: AND c.user_sequence = l_no_logical_operator.user_sequence + 1;
836: -- Get all rows which have just left bracket and no source
837: CURSOR c_no_source_bracket(p_description_prio_id NUMBER)
838: IS
839: SELECT user_sequence
840: FROM xla_conditions c
841: WHERE c.description_prio_id = p_description_prio_id
842: AND c.source_code is null
843: AND c.bracket_left_code is not null;
844:
847: -- Check if next row has only left bracket
848: CURSOR c_only_left_bracket(p_description_prio_id NUMBER)
849: IS
850: SELECT 'x'
851: FROM xla_conditions c
852: WHERE c.description_prio_id = p_description_prio_id
853: AND c.bracket_left_code is not null
854: AND c.user_sequence = l_no_source_bracket.user_sequence + 1;
855:
856: -- Get all rows with logical operator not null
857: CURSOR c_log_op_not_null(p_description_prio_id NUMBER)
858: IS
859: SELECT user_sequence
860: FROM xla_conditions c
861: WHERE c.description_prio_id = p_description_prio_id
862: AND c.logical_operator_code is not null;
863:
864: l_log_op_not_null c_log_op_not_null%rowtype;
866: -- Check if next row has only right bracket
867: CURSOR c_right_bracket(p_description_prio_id NUMBER)
868: IS
869: SELECT 'x'
870: FROM xla_conditions c
871: WHERE c.description_prio_id = p_description_prio_id
872: AND c.source_code is null
873: AND c.bracket_right_code is not null
874: AND c.user_sequence = l_log_op_not_null.user_sequence + 1;
1168: CLOSE c_desc_min_right_seq;
1169: END IF;
1170:
1171: xla_exceptions_pkg.raise_message
1172: (p_location => 'xla_conditions_pkg.desc_condition_is_invalid');
1173:
1174: END desc_condition_is_invalid;
1175:
1176: /*======================================================================+
1218: AND d.amb_context_code = p_amb_context_code
1219: AND d.segment_rule_type_code = p_segment_rule_type_code
1220: AND d.segment_rule_code = p_segment_rule_code
1221: AND exists(SELECT count(1)
1222: FROM xla_conditions c
1223: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
1224: AND c.bracket_left_code is not null
1225: MINUS
1226: SELECT count(1)
1223: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
1224: AND c.bracket_left_code is not null
1225: MINUS
1226: SELECT count(1)
1227: FROM xla_conditions c1
1228: WHERE c1.segment_rule_detail_id = d.segment_rule_detail_id
1229: AND c1.bracket_right_code is not null);
1230:
1231: CURSOR c_segment_rule_detail_id
1236: AND d.amb_context_code = p_amb_context_code
1237: AND d.segment_rule_type_code = p_segment_rule_type_code
1238: AND d.segment_rule_code = p_segment_rule_code
1239: AND exists (SELECT 'y'
1240: FROM xla_conditions c
1241: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id);
1242:
1243: CURSOR c_seg_max_left_seq(p_segment_rule_detail_id NUMBER)
1244: IS
1242:
1243: CURSOR c_seg_max_left_seq(p_segment_rule_detail_id NUMBER)
1244: IS
1245: SELECT max(user_sequence)
1246: FROM xla_conditions c
1247: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1248: AND c.bracket_left_code is not null;
1249:
1250: CURSOR c_seg_max_right_seq(p_segment_rule_detail_id NUMBER)
1249:
1250: CURSOR c_seg_max_right_seq(p_segment_rule_detail_id NUMBER)
1251: IS
1252: SELECT max(user_sequence)
1253: FROM xla_conditions c
1254: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1255: AND c.bracket_right_code is not null;
1256:
1257: CURSOR c_seg_min_left_seq(p_segment_rule_detail_id NUMBER)
1256:
1257: CURSOR c_seg_min_left_seq(p_segment_rule_detail_id NUMBER)
1258: IS
1259: SELECT min(user_sequence)
1260: FROM xla_conditions c
1261: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1262: AND c.bracket_left_code is not null;
1263:
1264: CURSOR c_seg_min_right_seq(p_segment_rule_detail_id NUMBER)
1263:
1264: CURSOR c_seg_min_right_seq(p_segment_rule_detail_id NUMBER)
1265: IS
1266: SELECT min(user_sequence)
1267: FROM xla_conditions c
1268: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1269: AND c.bracket_right_code is not null;
1270:
1271: -- Check if any empty rows exist with just the sequence number
1271: -- Check if any empty rows exist with just the sequence number
1272: CURSOR c_source(p_segment_rule_detail_id NUMBER)
1273: IS
1274: SELECT 'x'
1275: FROM xla_conditions c
1276: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1277: AND c.bracket_left_code is null
1278: AND c.bracket_right_code is null
1279: AND c.source_code is null;
1281: -- Check if any rows exist with just left and right bracket
1282: CURSOR c_left_right_bracket(p_segment_rule_detail_id NUMBER)
1283: IS
1284: SELECT 'x'
1285: FROM xla_conditions c
1286: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1287: AND c.bracket_left_code is not null
1288: AND c.bracket_right_code is not null
1289: AND c.source_code is null;
1291: -- Get the sequence for the last row
1292: CURSOR c_seg_sequence(p_segment_rule_detail_id NUMBER)
1293: IS
1294: SELECT max(user_sequence)
1295: FROM xla_conditions c
1296: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id;
1297:
1298: -- Check if last row has logical operator
1299: CURSOR c_seg_last_operator(p_segment_rule_detail_id NUMBER)
1298: -- Check if last row has logical operator
1299: CURSOR c_seg_last_operator(p_segment_rule_detail_id NUMBER)
1300: IS
1301: SELECT 'x'
1302: FROM xla_conditions c
1303: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1304: AND c.user_sequence = l_seg_user_sequence
1305: AND c.logical_operator_code is not null;
1306:
1307: -- Check if any rows exist with just left bracket and logical operator
1308: CURSOR c_left_bracket_operator(p_segment_rule_detail_id NUMBER)
1309: IS
1310: SELECT 'x'
1311: FROM xla_conditions c
1312: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1313: AND c.bracket_left_code is not null
1314: AND c.source_code is null
1315: AND c.logical_operator_code is not null;
1318: -- and have no logical operator
1319: CURSOR c_no_logical_operator(p_segment_rule_detail_id NUMBER)
1320: IS
1321: SELECT user_sequence
1322: FROM xla_conditions c
1323: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1324: AND (c.source_code is not null
1325: OR c.bracket_right_code is not null)
1326: AND c.logical_operator_code is null
1332: -- and have no logical operator
1333: CURSOR c_only_right_bracket(p_segment_rule_detail_id NUMBER)
1334: IS
1335: SELECT 'x'
1336: FROM xla_conditions c
1337: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1338: AND c.source_code is null
1339: AND c.bracket_right_code is not null
1340: AND c.user_sequence = l_no_logical_operator.user_sequence + 1;
1342: -- Get all rows which have just left bracket and no source
1343: CURSOR c_no_source_bracket(p_segment_rule_detail_id NUMBER)
1344: IS
1345: SELECT user_sequence
1346: FROM xla_conditions c
1347: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1348: AND c.source_code is null
1349: AND c.bracket_left_code is not null;
1350:
1353: -- Check if next row has only left bracket
1354: CURSOR c_only_left_bracket(p_segment_rule_detail_id NUMBER)
1355: IS
1356: SELECT 'x'
1357: FROM xla_conditions c
1358: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1359: AND c.bracket_left_code is not null
1360: AND c.user_sequence = l_no_source_bracket.user_sequence + 1;
1361:
1362: -- Get all rows with logical operator not null
1363: CURSOR c_log_op_not_null(p_segment_rule_detail_id NUMBER)
1364: IS
1365: SELECT user_sequence
1366: FROM xla_conditions c
1367: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1368: AND c.logical_operator_code is not null;
1369:
1370: l_log_op_not_null c_log_op_not_null%rowtype;
1372: -- Check if next row has only right bracket
1373: CURSOR c_right_bracket(p_segment_rule_detail_id NUMBER)
1374: IS
1375: SELECT 'x'
1376: FROM xla_conditions c
1377: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1378: AND c.source_code is null
1379: AND c.bracket_right_code is not null
1380: AND c.user_sequence = l_log_op_not_null.user_sequence + 1;
1379: AND c.bracket_right_code is not null
1380: AND c.user_sequence = l_log_op_not_null.user_sequence + 1;
1381:
1382: BEGIN
1383: trace('> xla_conditions_pkg.seg_condition_is_invalid' , C_LEVEL_PROCEDURE,l_log_module);
1384:
1385: trace('application_id = '||p_application_id , C_LEVEL_STATEMENT,l_log_module);
1386: trace('segment_rule_type_code = '||p_segment_rule_type_code , C_LEVEL_STATEMENT,l_log_module);
1387: trace('segment_rule_code = '||p_segment_rule_code , C_LEVEL_STATEMENT,l_log_module);
1621: CLOSE c_segment_rule_detail_id;
1622: END IF;
1623:
1624: trace('p_message_name = '||p_message_name , C_LEVEL_STATEMENT,l_log_module);
1625: trace('< xla_conditions_pkg.seg_condition_is_invalid' , C_LEVEL_PROCEDURE,l_log_module);
1626:
1627: RETURN l_return;
1628:
1629: EXCEPTION
1677: CLOSE c_seg_min_right_seq;
1678: END IF;
1679:
1680: xla_exceptions_pkg.raise_message
1681: (p_location => 'xla_conditions_pkg.seg_condition_is_invalid');
1682:
1683: END seg_condition_is_invalid;
1684:
1685: /*======================================================================+
1725: --
1726: CURSOR c_condition_exist
1727: IS
1728: SELECT 'x'
1729: FROM xla_conditions c
1730: WHERE c.application_id = p_application_id
1731: AND c.amb_context_code = p_amb_context_code
1732: AND c.entity_code = p_entity_code
1733: AND c.event_class_code = p_event_class_code
1744: AND d.event_class_code = p_event_class_code
1745: AND d.accounting_line_type_code = p_accounting_line_type_code
1746: AND d.accounting_line_code = p_accounting_line_code
1747: AND exists(SELECT count(1)
1748: FROM xla_conditions c
1749: WHERE c.application_id = d.application_id
1750: AND c.amb_context_code = d.amb_context_code
1751: AND c.entity_code = d.entity_code
1752: AND c.event_class_code = d.event_class_code
1754: AND c.accounting_line_code = d.accounting_line_code
1755: AND c.bracket_left_code is not null
1756: MINUS
1757: SELECT count(1)
1758: FROM xla_conditions c1
1759: WHERE c1.application_id = d.application_id
1760: AND c1.amb_context_code = d.amb_context_code
1761: AND c1.entity_code = d.entity_code
1762: AND c1.event_class_code = d.event_class_code
1766:
1767: CURSOR c_acct_max_left_seq
1768: IS
1769: SELECT max(user_sequence)
1770: FROM xla_conditions c
1771: WHERE c.application_id = p_application_id
1772: AND c.amb_context_code = p_amb_context_code
1773: AND c.entity_code = p_entity_code
1774: AND c.event_class_code = p_event_class_code
1778:
1779: CURSOR c_acct_max_right_seq
1780: IS
1781: SELECT max(user_sequence)
1782: FROM xla_conditions c
1783: WHERE c.application_id = p_application_id
1784: AND c.amb_context_code = p_amb_context_code
1785: AND c.entity_code = p_entity_code
1786: AND c.event_class_code = p_event_class_code
1790:
1791: CURSOR c_acct_min_left_seq
1792: IS
1793: SELECT min(user_sequence)
1794: FROM xla_conditions c
1795: WHERE c.application_id = p_application_id
1796: AND c.amb_context_code = p_amb_context_code
1797: AND c.entity_code = p_entity_code
1798: AND c.event_class_code = p_event_class_code
1802:
1803: CURSOR c_acct_min_right_seq
1804: IS
1805: SELECT min(user_sequence)
1806: FROM xla_conditions c
1807: WHERE c.application_id = p_application_id
1808: AND c.amb_context_code = p_amb_context_code
1809: AND c.entity_code = p_entity_code
1810: AND c.event_class_code = p_event_class_code
1815: -- Check if any empty rows exist with just the sequence number
1816: CURSOR c_source
1817: IS
1818: SELECT 'x'
1819: FROM xla_conditions c
1820: WHERE c.application_id = p_application_id
1821: AND c.amb_context_code = p_amb_context_code
1822: AND c.entity_code = p_entity_code
1823: AND c.event_class_code = p_event_class_code
1830: -- Check if any rows exist with just left and right bracket
1831: CURSOR c_left_right_bracket
1832: IS
1833: SELECT 'x'
1834: FROM xla_conditions c
1835: WHERE c.application_id = p_application_id
1836: AND c.amb_context_code = p_amb_context_code
1837: AND c.entity_code = p_entity_code
1838: AND c.event_class_code = p_event_class_code
1845: -- Get the sequence for the last row
1846: CURSOR c_acct_sequence
1847: IS
1848: SELECT max(user_sequence)
1849: FROM xla_conditions c
1850: WHERE c.application_id = p_application_id
1851: AND c.amb_context_code = p_amb_context_code
1852: AND c.entity_code = p_entity_code
1853: AND c.event_class_code = p_event_class_code
1857: -- Check if last row has logical operator
1858: CURSOR c_acct_last_operator
1859: IS
1860: SELECT 'x'
1861: FROM xla_conditions c
1862: WHERE c.application_id = p_application_id
1863: AND c.amb_context_code = p_amb_context_code
1864: AND c.entity_code = p_entity_code
1865: AND c.event_class_code = p_event_class_code
1871: -- Check if any rows exist with just left bracket and logical operator
1872: CURSOR c_left_bracket_operator
1873: IS
1874: SELECT 'x'
1875: FROM xla_conditions c
1876: WHERE c.application_id = p_application_id
1877: AND c.amb_context_code = p_amb_context_code
1878: AND c.entity_code = p_entity_code
1879: AND c.event_class_code = p_event_class_code
1887: -- and have no logical operator
1888: CURSOR c_no_logical_operator
1889: IS
1890: SELECT user_sequence
1891: FROM xla_conditions c
1892: WHERE c.application_id = p_application_id
1893: AND c.amb_context_code = p_amb_context_code
1894: AND c.entity_code = p_entity_code
1895: AND c.event_class_code = p_event_class_code
1906: -- and have no logical operator
1907: CURSOR c_only_right_bracket
1908: IS
1909: SELECT 'x'
1910: FROM xla_conditions c
1911: WHERE c.application_id = p_application_id
1912: AND c.amb_context_code = p_amb_context_code
1913: AND c.entity_code = p_entity_code
1914: AND c.event_class_code = p_event_class_code
1921: -- Get all rows which have just left bracket and no source
1922: CURSOR c_no_source_bracket
1923: IS
1924: SELECT user_sequence
1925: FROM xla_conditions c
1926: WHERE c.application_id = p_application_id
1927: AND c.amb_context_code = p_amb_context_code
1928: AND c.entity_code = p_entity_code
1929: AND c.event_class_code = p_event_class_code
1937: -- Check if next row has only left bracket
1938: CURSOR c_only_left_bracket
1939: IS
1940: SELECT 'x'
1941: FROM xla_conditions c
1942: WHERE c.application_id = p_application_id
1943: AND c.amb_context_code = p_amb_context_code
1944: AND c.entity_code = p_entity_code
1945: AND c.event_class_code = p_event_class_code
1951: -- Get all rows with logical operator not null
1952: CURSOR c_log_op_not_null
1953: IS
1954: SELECT user_sequence
1955: FROM xla_conditions c
1956: WHERE c.application_id = p_application_id
1957: AND c.amb_context_code = p_amb_context_code
1958: AND c.entity_code = p_entity_code
1959: AND c.event_class_code = p_event_class_code
1966: -- Check if next row has only right bracket
1967: CURSOR c_right_bracket
1968: IS
1969: SELECT 'x'
1970: FROM xla_conditions c
1971: WHERE c.application_id = p_application_id
1972: AND c.amb_context_code = p_amb_context_code
1973: AND c.entity_code = p_entity_code
1974: AND c.event_class_code = p_event_class_code
2311: CLOSE c_acct_min_right_seq;
2312: END IF;
2313:
2314: xla_exceptions_pkg.raise_message
2315: (p_location => 'xla_conditions_pkg.acct_condition_is_invalid');
2316:
2317: END acct_condition_is_invalid;
2318:
2319: BEGIN
2325:
2326: IF NOT g_log_enabled THEN
2327: g_log_level := C_LEVEL_LOG_DISABLED;
2328: END IF;
2329: END xla_conditions_pkg;