49: AND segment_rule_code = p_segment_rule_code;
50:
51: BEGIN
52:
53: xla_utility_pkg.trace('> xla_seg_rules_pkg.delete_seg_rule_details' , 10);
54:
55: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
56: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
57: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
51: BEGIN
52:
53: xla_utility_pkg.trace('> xla_seg_rules_pkg.delete_seg_rule_details' , 10);
54:
55: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
56: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
57: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
58:
59: OPEN c_seg_rule_details;
52:
53: xla_utility_pkg.trace('> xla_seg_rules_pkg.delete_seg_rule_details' , 10);
54:
55: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
56: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
57: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
58:
59: OPEN c_seg_rule_details;
60: LOOP
53: xla_utility_pkg.trace('> xla_seg_rules_pkg.delete_seg_rule_details' , 10);
54:
55: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
56: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
57: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
58:
59: OPEN c_seg_rule_details;
60: LOOP
61: FETCH c_seg_rule_details
75: AND amb_context_code = p_amb_context_code
76: AND segment_rule_type_code = p_segment_rule_type_code
77: AND segment_rule_code = p_segment_rule_code;
78:
79: xla_utility_pkg.trace('< xla_seg_rules_pkg.delete_seg_rule_details' , 10);
80:
81: EXCEPTION
82: WHEN xla_exceptions_pkg.application_exception THEN
83: IF c_seg_rule_details%ISOPEN THEN
193: AND source_code = l_detail_condition.value_source_code;
194:
195: BEGIN
196:
197: xla_utility_pkg.trace('> xla_seg_rules_pkg.copy_seg_rule_details' , 10);
198:
199: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
200: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
201: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
195: BEGIN
196:
197: xla_utility_pkg.trace('> xla_seg_rules_pkg.copy_seg_rule_details' , 10);
198:
199: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
200: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
201: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);
196:
197: xla_utility_pkg.trace('> xla_seg_rules_pkg.copy_seg_rule_details' , 10);
198:
199: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
200: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
201: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);
204:
197: xla_utility_pkg.trace('> xla_seg_rules_pkg.copy_seg_rule_details' , 10);
198:
199: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
200: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
201: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);
204:
205:
198:
199: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
200: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
201: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);
204:
205:
206: l_creation_date := sysdate;
199: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
200: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
201: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
202: xla_utility_pkg.trace('segment_rule_type_code = '||p_new_segment_rule_type_code , 20);
203: xla_utility_pkg.trace('segment_rule_code = '||p_new_segment_rule_code , 20);
204:
205:
206: l_creation_date := sysdate;
207: l_last_update_date := sysdate;
444:
445: END LOOP;
446: CLOSE c_seg_rule_details;
447:
448: xla_utility_pkg.trace('< xla_seg_rules_pkg.copy_seg_rule_details' , 10);
449:
450: EXCEPTION
451: WHEN xla_exceptions_pkg.application_exception THEN
452: IF c_detail_conditions%ISOPEN THEN
528: l_active_assignment_exist c_active_assignment_exist%rowtype;
529:
530: BEGIN
531:
532: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use' , 10);
533:
534: xla_utility_pkg.trace('event = '||p_event , 20);
535: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
536: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
530: BEGIN
531:
532: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use' , 10);
533:
534: xla_utility_pkg.trace('event = '||p_event , 20);
535: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
536: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
537: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
538:
531:
532: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use' , 10);
533:
534: xla_utility_pkg.trace('event = '||p_event , 20);
535: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
536: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
537: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
538:
539: IF p_event in ('DELETE','UPDATE') THEN
532: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use' , 10);
533:
534: xla_utility_pkg.trace('event = '||p_event , 20);
535: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
536: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
537: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
538:
539: IF p_event in ('DELETE','UPDATE') THEN
540: OPEN c_assignment_exist;
533:
534: xla_utility_pkg.trace('event = '||p_event , 20);
535: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
536: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
537: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
538:
539: IF p_event in ('DELETE','UPDATE') THEN
540: OPEN c_assignment_exist;
541: FETCH c_assignment_exist
590:
591: x_line_definition_name := l_line_definition_name;
592: x_line_definition_owner := l_line_definition_owner;
593:
594: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_in_use' , 10);
595:
596: return l_return;
597:
598: EXCEPTION
650: l_segment_rule_code VARCHAR2(30);
651:
652: BEGIN
653:
654: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_is_invalid' , 10);
655:
656: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
657: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
658: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
652: BEGIN
653:
654: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_is_invalid' , 10);
655:
656: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
657: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
658: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
659:
660: l_application_id := p_application_id;
653:
654: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_is_invalid' , 10);
655:
656: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
657: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
658: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
659:
660: l_application_id := p_application_id;
661: l_amb_context_code := p_amb_context_code;
654: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_is_invalid' , 10);
655:
656: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
657: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
658: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
659:
660: l_application_id := p_application_id;
661: l_amb_context_code := p_amb_context_code;
662: l_segment_rule_type_code := p_segment_rule_type_code;
675: p_message_name := NULL;
676: l_return := FALSE;
677: END IF;
678:
679: xla_utility_pkg.trace('p_message_name = '||p_message_name , 20);
680: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_is_invalid' , 10);
681:
682: return l_return;
683:
676: l_return := FALSE;
677: END IF;
678:
679: xla_utility_pkg.trace('p_message_name = '||p_message_name , 20);
680: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_is_invalid' , 10);
681:
682: return l_return;
683:
684: EXCEPTION
754: AND a.locking_status_flag = 'Y');
755:
756: BEGIN
757:
758: xla_utility_pkg.trace('> xla_seg_rules_pkg.seg_rule_is_locked' , 10);
759:
760: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
761: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
762: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
756: BEGIN
757:
758: xla_utility_pkg.trace('> xla_seg_rules_pkg.seg_rule_is_locked' , 10);
759:
760: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
761: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
762: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
763:
764: OPEN c_frozen_assignment_exist;
757:
758: xla_utility_pkg.trace('> xla_seg_rules_pkg.seg_rule_is_locked' , 10);
759:
760: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
761: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
762: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
763:
764: OPEN c_frozen_assignment_exist;
765: FETCH c_frozen_assignment_exist
758: xla_utility_pkg.trace('> xla_seg_rules_pkg.seg_rule_is_locked' , 10);
759:
760: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
761: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
762: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
763:
764: OPEN c_frozen_assignment_exist;
765: FETCH c_frozen_assignment_exist
766: INTO l_exist;
782: END IF;
783: CLOSE c_tab_assignment_exist;
784: END IF;
785:
786: xla_utility_pkg.trace('< xla_seg_rules_pkg.seg_rule_is_locked' , 10);
787:
788: return l_return;
789:
790: EXCEPTION
894: l_product_rule_type_codes t_array_type_codes;
895: l_product_rule_codes t_array_codes;
896: BEGIN
897:
898: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_definitions' , 10);
899:
900: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
901: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
902: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
896: BEGIN
897:
898: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_definitions' , 10);
899:
900: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
901: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
902: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
903: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
904:
897:
898: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_definitions' , 10);
899:
900: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
901: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
902: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
903: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
904:
905: l_return := TRUE;
898: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_definitions' , 10);
899:
900: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
901: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
902: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
903: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
904:
905: l_return := TRUE;
906:
899:
900: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
901: xla_utility_pkg.trace('amb_context_code = '||p_amb_context_code , 20);
902: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code , 20);
903: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code , 20);
904:
905: l_return := TRUE;
906:
907: FOR l_lock_aad IN c_lock_aads LOOP
1011: x_event_class_name := l_event_class_name;
1012: x_event_type_name := l_event_type_name;
1013: x_locking_status_flag := l_locking_status_flag;
1014:
1015: xla_utility_pkg.trace('< xla_seg_rules_pkg.uncompile_definitions' , 10);
1016:
1017: return l_return;
1018:
1019: EXCEPTION
1082: l_assignment_exist c_assignment_exist%rowtype;
1083:
1084: BEGIN
1085:
1086: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use_by_tab' , 10);
1087:
1088: xla_utility_pkg.trace('event = '||p_event , 20);
1089: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1090: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1084: BEGIN
1085:
1086: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use_by_tab' , 10);
1087:
1088: xla_utility_pkg.trace('event = '||p_event , 20);
1089: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1090: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1091: , 20);
1092: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1085:
1086: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use_by_tab' , 10);
1087:
1088: xla_utility_pkg.trace('event = '||p_event , 20);
1089: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1090: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1091: , 20);
1092: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1093: 20);
1086: xla_utility_pkg.trace('> xla_seg_rules_pkg.rule_in_use_by_tab' , 10);
1087:
1088: xla_utility_pkg.trace('event = '||p_event , 20);
1089: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1090: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1091: , 20);
1092: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1093: 20);
1094:
1088: xla_utility_pkg.trace('event = '||p_event , 20);
1089: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1090: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1091: , 20);
1092: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1093: 20);
1094:
1095: IF p_event in ('DELETE','UPDATE','DISABLE') THEN
1096: OPEN c_assignment_exist;
1129: p_trx_acct_def := l_trx_acct_def;
1130: p_trx_acct_def_type := l_trx_acct_def_type;
1131: p_trx_acct_type := l_trx_acct_type;
1132:
1133: xla_utility_pkg.trace('< xla_seg_rules_pkg.rule_in_use_by_tab' , 10);
1134:
1135: return l_return;
1136:
1137: EXCEPTION
1200: l_trx_def c_trx_defs%rowtype;
1201:
1202: BEGIN
1203:
1204: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_tran_acct_def' , 10);
1205:
1206: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1207: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1208: , 20);
1202: BEGIN
1203:
1204: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_tran_acct_def' , 10);
1205:
1206: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1207: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1208: , 20);
1209: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1210: 20);
1203:
1204: xla_utility_pkg.trace('> xla_seg_rules_pkg.uncompile_tran_acct_def' , 10);
1205:
1206: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1207: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1208: , 20);
1209: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1210: 20);
1211:
1205:
1206: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1207: xla_utility_pkg.trace('segment_rule_type_code = '||p_segment_rule_type_code
1208: , 20);
1209: xla_utility_pkg.trace('segment_rule_code = '||p_segment_rule_code ,
1210: 20);
1211:
1212: OPEN c_trx_defs;
1213: LOOP
1241: p_application_name := l_application_name;
1242: p_trx_acct_def := l_trx_acct_def;
1243: p_trx_acct_def_type := l_trx_acct_def_type;
1244:
1245: xla_utility_pkg.trace('< xla_seg_rules_pkg.uncompile_tran_acct_def' , 10);
1246:
1247: return l_return;
1248:
1249: EXCEPTION
1372: AND source_code = l_detail_condition.value_source_code;
1373:
1374: BEGIN
1375:
1376: xla_utility_pkg.trace('> xla_seg_rules_pkg.check_copy_seg_rule_details' , 10);
1377:
1378: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1379: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
1380: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
1374: BEGIN
1375:
1376: xla_utility_pkg.trace('> xla_seg_rules_pkg.check_copy_seg_rule_details' , 10);
1377:
1378: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1379: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
1380: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
1381:
1382: IF p_new_flex_value_set_id is not null then
1375:
1376: xla_utility_pkg.trace('> xla_seg_rules_pkg.check_copy_seg_rule_details' , 10);
1377:
1378: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1379: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
1380: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
1381:
1382: IF p_new_flex_value_set_id is not null then
1383: IF p_old_flex_value_set_id <> p_new_flex_value_set_id THEN
1376: xla_utility_pkg.trace('> xla_seg_rules_pkg.check_copy_seg_rule_details' , 10);
1377:
1378: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
1379: xla_utility_pkg.trace('segment_rule_type_code = '||p_old_segment_rule_type_code , 20);
1380: xla_utility_pkg.trace('segment_rule_code = '||p_old_segment_rule_code , 20);
1381:
1382: IF p_new_flex_value_set_id is not null then
1383: IF p_old_flex_value_set_id <> p_new_flex_value_set_id THEN
1384: OPEN c_flex_value;
1543: END LOOP;
1544: CLOSE c_seg_rule_details;
1545: END IF;
1546:
1547: xla_utility_pkg.trace('< xla_seg_rules_pkg.check_copy_seg_rule_details' , 10);
1548:
1549: return l_return;
1550:
1551: EXCEPTION