[Home] [Help]
769: -- Get all disabled header descriptions for the AAD
770: CURSOR c_enabled_hdr_desc IS
771: SELECT distinct d.entity_code, d.event_class_code, d.event_type_code,
772: d.description_type_code, d.description_code
773: FROM xla_prod_acct_headers d
774: WHERE d.application_id = p_application_id
775: AND d.amb_context_code = p_amb_context_code
776: AND d.product_rule_type_code = p_product_rule_type_code
777: AND d.product_rule_code = p_product_rule_code
790: -- details which do not belong to the event class
791: CURSOR c_hdr_desc_detail_sources IS
792: SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
793: l.description_type_code, l.description_code, d.source_type_code, d.source_code
794: FROM xla_descript_details_b d, xla_desc_priorities p, xla_prod_acct_headers l
795: WHERE d.description_prio_id = p.description_prio_id
796: AND p.application_id = l.application_id
797: AND p.amb_context_code = l.amb_context_code
798: AND p.description_type_code = l.description_type_code
820: CURSOR c_hdr_desc_con_sources IS
821: SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
822: l.description_type_code, l.description_code,
823: c.source_type_code source_type_code, c.source_code source_code
824: FROM xla_conditions c, xla_desc_priorities p, xla_prod_acct_headers l
825: WHERE c.description_prio_id = p.description_prio_id
826: AND p.application_id = l.application_id
827: AND p.amb_context_code = l.amb_context_code
828: AND p.description_type_code = l.description_type_code
847: UNION
848: SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
849: l.description_type_code, l.description_code,
850: c.value_source_type_code source_type_code, c.value_source_code source_code
851: FROM xla_conditions c, xla_desc_priorities p, xla_prod_acct_headers l
852: WHERE c.description_prio_id = p.description_prio_id
853: AND p.application_id = l.application_id
854: AND p.amb_context_code = l.amb_context_code
855: AND p.description_type_code = l.description_type_code
876: -- details which do not belong to the event class
877: CURSOR c_hdr_desc_det_der_sources IS
878: SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
879: l.description_type_code, l.description_code, d.source_type_code, d.source_code
880: FROM xla_descript_details_b d, xla_desc_priorities p, xla_prod_acct_headers l
881: WHERE d.description_prio_id = p.description_prio_id
882: AND p.application_id = l.application_id
883: AND p.amb_context_code = l.amb_context_code
884: AND p.description_type_code = l.description_type_code
896: CURSOR c_hdr_desc_con_der_sources IS
897: SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
898: l.description_type_code, l.description_code,
899: c.source_type_code source_type_code, c.source_code source_code
900: FROM xla_conditions c, xla_desc_priorities p, xla_prod_acct_headers l
901: WHERE c.description_prio_id = p.description_prio_id
902: AND p.application_id = l.application_id
903: AND p.amb_context_code = l.amb_context_code
904: AND p.description_type_code = l.description_type_code
913: UNION
914: SELECT distinct l.entity_code, l.event_class_code, l.event_type_code,
915: l.description_type_code, l.description_code,
916: c.value_source_type_code source_type_code, c.value_source_code source_code
917: FROM xla_conditions c, xla_desc_priorities p, xla_prod_acct_headers l
918: WHERE c.description_prio_id = p.description_prio_id
919: AND p.application_id = l.application_id
920: AND p.amb_context_code = l.amb_context_code
921: AND p.description_type_code = l.description_type_code
1410: -- Get all event classes that are assigned to the AAD and disabled
1411: CURSOR c_enabled_classes
1412: IS
1413: SELECT entity_code, event_class_code
1414: FROM xla_prod_acct_headers d
1415: WHERE d.application_id = p_application_id
1416: AND d.amb_context_code = p_amb_context_code
1417: AND d.product_rule_type_code = p_product_rule_type_code
1418: AND d.product_rule_code = p_product_rule_code
1426: -- Get all event classes that have circular references
1427: CURSOR c_ec_predecs
1428: IS
1429: SELECT entity_code, event_class_code
1430: FROM xla_prod_acct_headers d
1431: WHERE d.application_id = p_application_id
1432: AND d.amb_context_code = p_amb_context_code
1433: AND d.product_rule_type_code = p_product_rule_type_code
1434: AND d.product_rule_code = p_product_rule_code
1442: -- Check if atleast one event type is being accounting for the AAD
1443: CURSOR c_accting_required
1444: IS
1445: SELECT 'x'
1446: FROM xla_prod_acct_headers d
1447: WHERE d.application_id = p_application_id
1448: AND d.amb_context_code = p_amb_context_code
1449: AND d.product_rule_type_code = p_product_rule_type_code
1450: AND d.product_rule_code = p_product_rule_code
1454: -- have atleast one enabled accounting event class
1455: CURSOR c_class_enabled_types
1456: IS
1457: SELECT entity_code, event_class_code
1458: FROM xla_prod_acct_headers d
1459: WHERE d.application_id = p_application_id
1460: AND d.amb_context_code = p_amb_context_code
1461: AND d.product_rule_type_code = p_product_rule_type_code
1462: AND d.product_rule_code = p_product_rule_code
1473: -- Get all event types that are assigned to the AAD and are not enabled accounting event types
1474: CURSOR c_enabled_types
1475: IS
1476: SELECT application_id, entity_code, event_class_code, event_type_code
1477: FROM xla_prod_acct_headers d
1478: WHERE d.application_id = p_application_id
1479: AND d.amb_context_code = p_amb_context_code
1480: AND d.product_rule_type_code = p_product_rule_type_code
1481: AND d.product_rule_code = p_product_rule_code
1493: -- Get all event types to be accounted for which do not have any lines assigned to them
1494: CURSOR c_acct_headers
1495: IS
1496: SELECT xpa.entity_code, xpa.event_class_code, xpa.event_type_code
1497: FROM xla_prod_acct_headers xpa
1498: WHERE xpa.application_id = p_application_id
1499: AND xpa.amb_context_code = p_amb_context_code
1500: AND xpa.product_rule_type_code = p_product_rule_type_code
1501: AND xpa.product_rule_code = p_product_rule_code
1521: -- Get all event classes to be accounted for the AAD
1522: CURSOR c_prod_acct_headers
1523: IS
1524: SELECT distinct entity_code, event_class_code, event_type_code
1525: FROM xla_prod_acct_headers d
1526: WHERE d.application_id = p_application_id
1527: AND d.amb_context_code = p_amb_context_code
1528: AND d.product_rule_type_code = p_product_rule_type_code
1529: AND d.product_rule_code = p_product_rule_code
1944: -- For all event class assignment of the invalid line definition or invalid
1945: -- header assignment of the eventclass, mark the event class assignment to Error
1946: IF (NOT l_return) THEN
1947: FORALL j IN 1..l_err_count
1948: UPDATE xla_prod_acct_headers xpa
1949: SET validation_status_code = 'E'
1950: WHERE application_id = p_application_id
1951: AND amb_context_code = p_amb_context_code
1952: AND product_rule_type_code = p_product_rule_type_code
2066: ,p_product_rule_code => p_product_rule_code);
2067:
2068: -- All event class/type assignment that are not Valid are eligiable for
2069: -- validation
2070: UPDATE xla_prod_acct_headers
2071: SET validation_status_code = 'R'
2072: WHERE application_id = p_application_id
2073: AND amb_context_code = p_amb_context_code
2074: AND product_rule_type_code = p_product_rule_type_code
2105: END IF;
2106:
2107: -- For assignments that are valid (and does not marked for validation),
2108: -- change the validation status to R so they are eligiable for compilation.
2109: UPDATE xla_prod_acct_headers
2110: SET validation_status_code = 'R'
2111: WHERE application_id = p_application_id
2112: AND amb_context_code = p_amb_context_code
2113: AND product_rule_type_code = p_product_rule_type_code
2152: ELSE
2153: x_compilation_status_code := 'E';
2154: END IF;
2155:
2156: UPDATE xla_prod_acct_headers
2157: SET validation_status_code = x_compilation_status_code
2158: , last_update_date = sysdate
2159: , last_updated_by = xla_environment_pkg.g_usr_id
2160: , last_update_login = xla_environment_pkg.g_login_id