[Home] [Help]
1: PACKAGE BODY xla_conditions_pkg AS
2: /* $Header: xlaamcon.pkb 120.21.12010000.2 2008/09/08 18:21:07 vdamerla 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;
97:
98: IF p_context = 'A' THEN
99:
100: DELETE
101: FROM xla_conditions
102: WHERE application_id = p_application_id
103: AND amb_context_code = p_amb_context_code
104: AND entity_code = p_entity_code
105: AND event_class_code = p_event_class_code
108:
109: ELSIF p_context = 'S' THEN
110:
111: DELETE
112: FROM xla_conditions
113: WHERE segment_rule_detail_id = p_segment_rule_detail_id;
114:
115: ELSIF p_context = 'D' THEN
116:
114:
115: ELSIF p_context = 'D' THEN
116:
117: DELETE
118: FROM xla_conditions
119: WHERE description_prio_id = p_description_prio_id;
120: END IF;
121:
122: trace('delete_condition.End',C_LEVEL_PROCEDURE,l_log_module);
125: WHEN xla_exceptions_pkg.application_exception THEN
126: RAISE;
127: WHEN OTHERS THEN
128: xla_exceptions_pkg.raise_message
129: (p_location => 'xla_conditions_pkg.delete_condition');
130:
131: END delete_condition;
132:
133: /*======================================================================+
162: flexfield_segment_code, value_flexfield_segment_code,
163: value_source_application_id, value_source_type_code,
164: value_source_code, value_constant, line_operator_code,
165: logical_operator_code, independent_value_constant
166: FROM xla_conditions
167: WHERE segment_rule_detail_id = p_segment_rule_detail_id
168: AND p_context = 'S'
169: UNION
170: SELECT user_sequence, bracket_left_code, bracket_right_code, value_type_code,
172: flexfield_segment_code, value_flexfield_segment_code,
173: value_source_application_id, value_source_type_code,
174: value_source_code, value_constant, line_operator_code,
175: logical_operator_code, independent_value_constant
176: FROM xla_conditions
177: WHERE application_id = p_application_id
178: AND amb_context_code = p_amb_context_code
179: AND entity_code = p_entity_code
180: AND event_class_code = p_event_class_code
187: flexfield_segment_code, value_flexfield_segment_code,
188: value_source_application_id, value_source_type_code,
189: value_source_code, value_constant, line_operator_code,
190: logical_operator_code, independent_value_constant
191: FROM xla_conditions
192: WHERE description_prio_id = p_description_prio_id
193: AND p_context = 'D'
194: ORDER BY user_sequence;
195:
530: xla_exceptions_pkg.raise_message
531: ('XLA'
532: ,'XLA_AB_COND_TOO_LONG'
533: ,'PROCEDURE'
534: ,'xla_conditions_pkg.display_condition'
535: ,'ERROR'
536: ,sqlerrm
537: );
538: END;
566: IF c_value_source_name%ISOPEN THEN
567: CLOSE c_value_source_name;
568: END IF;
569: xla_exceptions_pkg.raise_message
570: (p_location => 'xla_conditions_pkg.display_condition');
571:
572: END display_condition;
573:
574: /*======================================================================+
613: AND d.amb_context_code = p_amb_context_code
614: AND d.description_type_code = p_description_type_code
615: AND d.description_code = p_description_code
616: AND exists(SELECT count(1)
617: FROM xla_conditions c
618: WHERE c.description_prio_id = d.description_prio_id
619: AND c.bracket_left_code is not null
620: MINUS
621: SELECT count(1)
618: WHERE c.description_prio_id = d.description_prio_id
619: AND c.bracket_left_code is not null
620: MINUS
621: SELECT count(1)
622: FROM xla_conditions c1
623: WHERE c1.description_prio_id = d.description_prio_id
624: AND c1.bracket_right_code is not null);
625:
626:
632: AND d.amb_context_code = p_amb_context_code
633: AND d.description_type_code = p_description_type_code
634: AND d.description_code = p_description_code
635: AND exists (SELECT 'y'
636: FROM xla_conditions c
637: WHERE c.description_prio_id = d.description_prio_id);
638:
639: CURSOR c_desc_max_left_seq(p_description_prio_id NUMBER)
640: IS
638:
639: CURSOR c_desc_max_left_seq(p_description_prio_id NUMBER)
640: IS
641: SELECT max(user_sequence)
642: FROM xla_conditions c
643: WHERE c.description_prio_id = p_description_prio_id
644: AND c.bracket_left_code is not null;
645:
646: CURSOR c_desc_max_right_seq(p_description_prio_id NUMBER)
645:
646: CURSOR c_desc_max_right_seq(p_description_prio_id NUMBER)
647: IS
648: SELECT max(user_sequence)
649: FROM xla_conditions c
650: WHERE c.description_prio_id = p_description_prio_id
651: AND c.bracket_right_code is not null;
652:
653: CURSOR c_desc_min_left_seq(p_description_prio_id NUMBER)
652:
653: CURSOR c_desc_min_left_seq(p_description_prio_id NUMBER)
654: IS
655: SELECT min(user_sequence)
656: FROM xla_conditions c
657: WHERE c.description_prio_id = p_description_prio_id
658: AND c.bracket_left_code is not null;
659:
660: CURSOR c_desc_min_right_seq(p_description_prio_id NUMBER)
659:
660: CURSOR c_desc_min_right_seq(p_description_prio_id NUMBER)
661: IS
662: SELECT min(user_sequence)
663: FROM xla_conditions c
664: WHERE c.description_prio_id = p_description_prio_id
665: AND c.bracket_right_code is not null;
666:
667: -- Check if any empty rows exist with just the sequence number
667: -- Check if any empty rows exist with just the sequence number
668: CURSOR c_source(p_description_prio_id NUMBER)
669: IS
670: SELECT 'x'
671: FROM xla_conditions c
672: WHERE c.description_prio_id = p_description_prio_id
673: AND c.bracket_left_code is null
674: AND c.bracket_right_code is null
675: AND c.source_code is null;
677: -- Check if any rows exist with just left and right bracket
678: CURSOR c_left_right_bracket(p_description_prio_id NUMBER)
679: IS
680: SELECT 'x'
681: FROM xla_conditions c
682: WHERE c.description_prio_id = p_description_prio_id
683: AND c.bracket_left_code is not null
684: AND c.bracket_right_code is not null
685: AND c.source_code is null;
687: -- Get the sequence for the last row
688: CURSOR c_desc_sequence(p_description_prio_id NUMBER)
689: IS
690: SELECT max(user_sequence)
691: FROM xla_conditions c
692: WHERE c.description_prio_id = p_description_prio_id;
693:
694: -- Check if last row has logical operator
695: CURSOR c_desc_last_operator(p_description_prio_id NUMBER)
694: -- Check if last row has logical operator
695: CURSOR c_desc_last_operator(p_description_prio_id NUMBER)
696: IS
697: SELECT 'x'
698: FROM xla_conditions c
699: WHERE c.description_prio_id = p_description_prio_id
700: AND c.user_sequence = l_desc_user_sequence
701: AND c.logical_operator_code is not null;
702:
703: -- Check if any rows exist with just left bracket and logical operator
704: CURSOR c_left_bracket_operator(p_description_prio_id NUMBER)
705: IS
706: SELECT 'x'
707: FROM xla_conditions c
708: WHERE c.description_prio_id = p_description_prio_id
709: AND c.bracket_left_code is not null
710: AND c.source_code is null
711: AND c.logical_operator_code is not null;
714: -- and have no logical operator
715: CURSOR c_no_logical_operator(p_description_prio_id NUMBER)
716: IS
717: SELECT user_sequence
718: FROM xla_conditions c
719: WHERE c.description_prio_id = p_description_prio_id
720: AND (c.source_code is not null
721: OR c.bracket_right_code is not null)
722: AND c.logical_operator_code is null
728: -- and have no logical operator
729: CURSOR c_only_right_bracket(p_description_prio_id NUMBER)
730: IS
731: SELECT 'x'
732: FROM xla_conditions c
733: WHERE c.description_prio_id = p_description_prio_id
734: AND c.source_code is null
735: AND c.bracket_right_code is not null
736: AND c.user_sequence = l_no_logical_operator.user_sequence + 1;
738: -- Get all rows which have just left bracket and no source
739: CURSOR c_no_source_bracket(p_description_prio_id NUMBER)
740: IS
741: SELECT user_sequence
742: FROM xla_conditions c
743: WHERE c.description_prio_id = p_description_prio_id
744: AND c.source_code is null
745: AND c.bracket_left_code is not null;
746:
749: -- Check if next row has only left bracket
750: CURSOR c_only_left_bracket(p_description_prio_id NUMBER)
751: IS
752: SELECT 'x'
753: FROM xla_conditions c
754: WHERE c.description_prio_id = p_description_prio_id
755: AND c.bracket_left_code is not null
756: AND c.user_sequence = l_no_source_bracket.user_sequence + 1;
757:
758: -- Get all rows with logical operator not null
759: CURSOR c_log_op_not_null(p_description_prio_id NUMBER)
760: IS
761: SELECT user_sequence
762: FROM xla_conditions c
763: WHERE c.description_prio_id = p_description_prio_id
764: AND c.logical_operator_code is not null;
765:
766: l_log_op_not_null c_log_op_not_null%rowtype;
768: -- Check if next row has only right bracket
769: CURSOR c_right_bracket(p_description_prio_id NUMBER)
770: IS
771: SELECT 'x'
772: FROM xla_conditions c
773: WHERE c.description_prio_id = p_description_prio_id
774: AND c.source_code is null
775: AND c.bracket_right_code is not null
776: AND c.user_sequence = l_log_op_not_null.user_sequence + 1;
1070: CLOSE c_desc_min_right_seq;
1071: END IF;
1072:
1073: xla_exceptions_pkg.raise_message
1074: (p_location => 'xla_conditions_pkg.desc_condition_is_invalid');
1075:
1076: END desc_condition_is_invalid;
1077:
1078: /*======================================================================+
1120: AND d.amb_context_code = p_amb_context_code
1121: AND d.segment_rule_type_code = p_segment_rule_type_code
1122: AND d.segment_rule_code = p_segment_rule_code
1123: AND exists(SELECT count(1)
1124: FROM xla_conditions c
1125: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
1126: AND c.bracket_left_code is not null
1127: MINUS
1128: SELECT count(1)
1125: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
1126: AND c.bracket_left_code is not null
1127: MINUS
1128: SELECT count(1)
1129: FROM xla_conditions c1
1130: WHERE c1.segment_rule_detail_id = d.segment_rule_detail_id
1131: AND c1.bracket_right_code is not null);
1132:
1133: CURSOR c_segment_rule_detail_id
1138: AND d.amb_context_code = p_amb_context_code
1139: AND d.segment_rule_type_code = p_segment_rule_type_code
1140: AND d.segment_rule_code = p_segment_rule_code
1141: AND exists (SELECT 'y'
1142: FROM xla_conditions c
1143: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id);
1144:
1145: CURSOR c_seg_max_left_seq(p_segment_rule_detail_id NUMBER)
1146: IS
1144:
1145: CURSOR c_seg_max_left_seq(p_segment_rule_detail_id NUMBER)
1146: IS
1147: SELECT max(user_sequence)
1148: FROM xla_conditions c
1149: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1150: AND c.bracket_left_code is not null;
1151:
1152: CURSOR c_seg_max_right_seq(p_segment_rule_detail_id NUMBER)
1151:
1152: CURSOR c_seg_max_right_seq(p_segment_rule_detail_id NUMBER)
1153: IS
1154: SELECT max(user_sequence)
1155: FROM xla_conditions c
1156: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1157: AND c.bracket_right_code is not null;
1158:
1159: CURSOR c_seg_min_left_seq(p_segment_rule_detail_id NUMBER)
1158:
1159: CURSOR c_seg_min_left_seq(p_segment_rule_detail_id NUMBER)
1160: IS
1161: SELECT min(user_sequence)
1162: FROM xla_conditions c
1163: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1164: AND c.bracket_left_code is not null;
1165:
1166: CURSOR c_seg_min_right_seq(p_segment_rule_detail_id NUMBER)
1165:
1166: CURSOR c_seg_min_right_seq(p_segment_rule_detail_id NUMBER)
1167: IS
1168: SELECT min(user_sequence)
1169: FROM xla_conditions c
1170: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1171: AND c.bracket_right_code is not null;
1172:
1173: -- Check if any empty rows exist with just the sequence number
1173: -- Check if any empty rows exist with just the sequence number
1174: CURSOR c_source(p_segment_rule_detail_id NUMBER)
1175: IS
1176: SELECT 'x'
1177: FROM xla_conditions c
1178: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1179: AND c.bracket_left_code is null
1180: AND c.bracket_right_code is null
1181: AND c.source_code is null;
1183: -- Check if any rows exist with just left and right bracket
1184: CURSOR c_left_right_bracket(p_segment_rule_detail_id NUMBER)
1185: IS
1186: SELECT 'x'
1187: FROM xla_conditions c
1188: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1189: AND c.bracket_left_code is not null
1190: AND c.bracket_right_code is not null
1191: AND c.source_code is null;
1193: -- Get the sequence for the last row
1194: CURSOR c_seg_sequence(p_segment_rule_detail_id NUMBER)
1195: IS
1196: SELECT max(user_sequence)
1197: FROM xla_conditions c
1198: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id;
1199:
1200: -- Check if last row has logical operator
1201: CURSOR c_seg_last_operator(p_segment_rule_detail_id NUMBER)
1200: -- Check if last row has logical operator
1201: CURSOR c_seg_last_operator(p_segment_rule_detail_id NUMBER)
1202: IS
1203: SELECT 'x'
1204: FROM xla_conditions c
1205: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1206: AND c.user_sequence = l_seg_user_sequence
1207: AND c.logical_operator_code is not null;
1208:
1209: -- Check if any rows exist with just left bracket and logical operator
1210: CURSOR c_left_bracket_operator(p_segment_rule_detail_id NUMBER)
1211: IS
1212: SELECT 'x'
1213: FROM xla_conditions c
1214: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1215: AND c.bracket_left_code is not null
1216: AND c.source_code is null
1217: AND c.logical_operator_code is not null;
1220: -- and have no logical operator
1221: CURSOR c_no_logical_operator(p_segment_rule_detail_id NUMBER)
1222: IS
1223: SELECT user_sequence
1224: FROM xla_conditions c
1225: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1226: AND (c.source_code is not null
1227: OR c.bracket_right_code is not null)
1228: AND c.logical_operator_code is null
1234: -- and have no logical operator
1235: CURSOR c_only_right_bracket(p_segment_rule_detail_id NUMBER)
1236: IS
1237: SELECT 'x'
1238: FROM xla_conditions c
1239: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1240: AND c.source_code is null
1241: AND c.bracket_right_code is not null
1242: AND c.user_sequence = l_no_logical_operator.user_sequence + 1;
1244: -- Get all rows which have just left bracket and no source
1245: CURSOR c_no_source_bracket(p_segment_rule_detail_id NUMBER)
1246: IS
1247: SELECT user_sequence
1248: FROM xla_conditions c
1249: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1250: AND c.source_code is null
1251: AND c.bracket_left_code is not null;
1252:
1255: -- Check if next row has only left bracket
1256: CURSOR c_only_left_bracket(p_segment_rule_detail_id NUMBER)
1257: IS
1258: SELECT 'x'
1259: FROM xla_conditions c
1260: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1261: AND c.bracket_left_code is not null
1262: AND c.user_sequence = l_no_source_bracket.user_sequence + 1;
1263:
1264: -- Get all rows with logical operator not null
1265: CURSOR c_log_op_not_null(p_segment_rule_detail_id NUMBER)
1266: IS
1267: SELECT user_sequence
1268: FROM xla_conditions c
1269: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1270: AND c.logical_operator_code is not null;
1271:
1272: l_log_op_not_null c_log_op_not_null%rowtype;
1274: -- Check if next row has only right bracket
1275: CURSOR c_right_bracket(p_segment_rule_detail_id NUMBER)
1276: IS
1277: SELECT 'x'
1278: FROM xla_conditions c
1279: WHERE c.segment_rule_detail_id = p_segment_rule_detail_id
1280: AND c.source_code is null
1281: AND c.bracket_right_code is not null
1282: AND c.user_sequence = l_log_op_not_null.user_sequence + 1;
1281: AND c.bracket_right_code is not null
1282: AND c.user_sequence = l_log_op_not_null.user_sequence + 1;
1283:
1284: BEGIN
1285: trace('> xla_conditions_pkg.seg_condition_is_invalid' , C_LEVEL_PROCEDURE,l_log_module);
1286:
1287: trace('application_id = '||p_application_id , C_LEVEL_STATEMENT,l_log_module);
1288: trace('segment_rule_type_code = '||p_segment_rule_type_code , C_LEVEL_STATEMENT,l_log_module);
1289: trace('segment_rule_code = '||p_segment_rule_code , C_LEVEL_STATEMENT,l_log_module);
1523: CLOSE c_segment_rule_detail_id;
1524: END IF;
1525:
1526: trace('p_message_name = '||p_message_name , C_LEVEL_STATEMENT,l_log_module);
1527: trace('< xla_conditions_pkg.seg_condition_is_invalid' , C_LEVEL_PROCEDURE,l_log_module);
1528:
1529: RETURN l_return;
1530:
1531: EXCEPTION
1579: CLOSE c_seg_min_right_seq;
1580: END IF;
1581:
1582: xla_exceptions_pkg.raise_message
1583: (p_location => 'xla_conditions_pkg.seg_condition_is_invalid');
1584:
1585: END seg_condition_is_invalid;
1586:
1587: /*======================================================================+
1627: --
1628: CURSOR c_condition_exist
1629: IS
1630: SELECT 'x'
1631: FROM xla_conditions c
1632: WHERE c.application_id = p_application_id
1633: AND c.amb_context_code = p_amb_context_code
1634: AND c.entity_code = p_entity_code
1635: AND c.event_class_code = p_event_class_code
1646: AND d.event_class_code = p_event_class_code
1647: AND d.accounting_line_type_code = p_accounting_line_type_code
1648: AND d.accounting_line_code = p_accounting_line_code
1649: AND exists(SELECT count(1)
1650: FROM xla_conditions c
1651: WHERE c.application_id = d.application_id
1652: AND c.amb_context_code = d.amb_context_code
1653: AND c.entity_code = d.entity_code
1654: AND c.event_class_code = d.event_class_code
1656: AND c.accounting_line_code = d.accounting_line_code
1657: AND c.bracket_left_code is not null
1658: MINUS
1659: SELECT count(1)
1660: FROM xla_conditions c1
1661: WHERE c1.application_id = d.application_id
1662: AND c1.amb_context_code = d.amb_context_code
1663: AND c1.entity_code = d.entity_code
1664: AND c1.event_class_code = d.event_class_code
1668:
1669: CURSOR c_acct_max_left_seq
1670: IS
1671: SELECT max(user_sequence)
1672: FROM xla_conditions c
1673: WHERE c.application_id = p_application_id
1674: AND c.amb_context_code = p_amb_context_code
1675: AND c.entity_code = p_entity_code
1676: AND c.event_class_code = p_event_class_code
1680:
1681: CURSOR c_acct_max_right_seq
1682: IS
1683: SELECT max(user_sequence)
1684: FROM xla_conditions c
1685: WHERE c.application_id = p_application_id
1686: AND c.amb_context_code = p_amb_context_code
1687: AND c.entity_code = p_entity_code
1688: AND c.event_class_code = p_event_class_code
1692:
1693: CURSOR c_acct_min_left_seq
1694: IS
1695: SELECT min(user_sequence)
1696: FROM xla_conditions c
1697: WHERE c.application_id = p_application_id
1698: AND c.amb_context_code = p_amb_context_code
1699: AND c.entity_code = p_entity_code
1700: AND c.event_class_code = p_event_class_code
1704:
1705: CURSOR c_acct_min_right_seq
1706: IS
1707: SELECT min(user_sequence)
1708: FROM xla_conditions c
1709: WHERE c.application_id = p_application_id
1710: AND c.amb_context_code = p_amb_context_code
1711: AND c.entity_code = p_entity_code
1712: AND c.event_class_code = p_event_class_code
1717: -- Check if any empty rows exist with just the sequence number
1718: CURSOR c_source
1719: IS
1720: SELECT 'x'
1721: FROM xla_conditions c
1722: WHERE c.application_id = p_application_id
1723: AND c.amb_context_code = p_amb_context_code
1724: AND c.entity_code = p_entity_code
1725: AND c.event_class_code = p_event_class_code
1732: -- Check if any rows exist with just left and right bracket
1733: CURSOR c_left_right_bracket
1734: IS
1735: SELECT 'x'
1736: FROM xla_conditions c
1737: WHERE c.application_id = p_application_id
1738: AND c.amb_context_code = p_amb_context_code
1739: AND c.entity_code = p_entity_code
1740: AND c.event_class_code = p_event_class_code
1747: -- Get the sequence for the last row
1748: CURSOR c_acct_sequence
1749: IS
1750: SELECT max(user_sequence)
1751: FROM xla_conditions c
1752: WHERE c.application_id = p_application_id
1753: AND c.amb_context_code = p_amb_context_code
1754: AND c.entity_code = p_entity_code
1755: AND c.event_class_code = p_event_class_code
1759: -- Check if last row has logical operator
1760: CURSOR c_acct_last_operator
1761: IS
1762: SELECT 'x'
1763: FROM xla_conditions c
1764: WHERE c.application_id = p_application_id
1765: AND c.amb_context_code = p_amb_context_code
1766: AND c.entity_code = p_entity_code
1767: AND c.event_class_code = p_event_class_code
1773: -- Check if any rows exist with just left bracket and logical operator
1774: CURSOR c_left_bracket_operator
1775: IS
1776: SELECT 'x'
1777: FROM xla_conditions c
1778: WHERE c.application_id = p_application_id
1779: AND c.amb_context_code = p_amb_context_code
1780: AND c.entity_code = p_entity_code
1781: AND c.event_class_code = p_event_class_code
1789: -- and have no logical operator
1790: CURSOR c_no_logical_operator
1791: IS
1792: SELECT user_sequence
1793: FROM xla_conditions c
1794: WHERE c.application_id = p_application_id
1795: AND c.amb_context_code = p_amb_context_code
1796: AND c.entity_code = p_entity_code
1797: AND c.event_class_code = p_event_class_code
1808: -- and have no logical operator
1809: CURSOR c_only_right_bracket
1810: IS
1811: SELECT 'x'
1812: FROM xla_conditions c
1813: WHERE c.application_id = p_application_id
1814: AND c.amb_context_code = p_amb_context_code
1815: AND c.entity_code = p_entity_code
1816: AND c.event_class_code = p_event_class_code
1823: -- Get all rows which have just left bracket and no source
1824: CURSOR c_no_source_bracket
1825: IS
1826: SELECT user_sequence
1827: FROM xla_conditions c
1828: WHERE c.application_id = p_application_id
1829: AND c.amb_context_code = p_amb_context_code
1830: AND c.entity_code = p_entity_code
1831: AND c.event_class_code = p_event_class_code
1839: -- Check if next row has only left bracket
1840: CURSOR c_only_left_bracket
1841: IS
1842: SELECT 'x'
1843: FROM xla_conditions c
1844: WHERE c.application_id = p_application_id
1845: AND c.amb_context_code = p_amb_context_code
1846: AND c.entity_code = p_entity_code
1847: AND c.event_class_code = p_event_class_code
1853: -- Get all rows with logical operator not null
1854: CURSOR c_log_op_not_null
1855: IS
1856: SELECT user_sequence
1857: FROM xla_conditions c
1858: WHERE c.application_id = p_application_id
1859: AND c.amb_context_code = p_amb_context_code
1860: AND c.entity_code = p_entity_code
1861: AND c.event_class_code = p_event_class_code
1868: -- Check if next row has only right bracket
1869: CURSOR c_right_bracket
1870: IS
1871: SELECT 'x'
1872: FROM xla_conditions c
1873: WHERE c.application_id = p_application_id
1874: AND c.amb_context_code = p_amb_context_code
1875: AND c.entity_code = p_entity_code
1876: AND c.event_class_code = p_event_class_code
2213: CLOSE c_acct_min_right_seq;
2214: END IF;
2215:
2216: xla_exceptions_pkg.raise_message
2217: (p_location => 'xla_conditions_pkg.acct_condition_is_invalid');
2218:
2219: END acct_condition_is_invalid;
2220:
2221: BEGIN
2227:
2228: IF NOT g_log_enabled THEN
2229: g_log_level := C_LEVEL_LOG_DISABLED;
2230: END IF;
2231: END xla_conditions_pkg;