[Home] [Help]
782: CURSOR c_invalid_side_code IS
783: SELECT distinct xlj.accounting_line_type_code, xlj.accounting_line_code
784: FROM xla_line_defn_jlt_assgns xlj
785: , xla_acct_line_types_b xalt
786: , xla_line_defn_adr_assgns xld
787: WHERE xlj.application_id = p_application_id
788: AND xlj.amb_context_code = p_amb_context_code
789: AND xlj.event_class_code = p_event_class_code
790: AND xlj.event_type_code = p_event_type_code
924: AND xlj.accounting_line_type_code = jlt.accounting_line_type_code
925: AND xlj.accounting_line_code = jlt.accounting_line_code
926: AND jlt.business_method_code <> 'PRIOR_ENTRY'
927: AND NOT EXISTS
928: (SELECT 1 FROM xla_line_defn_adr_assgns xad1
929: WHERE xlj.application_id = xad1.application_id
930: AND xlj.amb_context_code = xad1.amb_context_code
931: AND xlj.event_class_code = xad1.event_class_code
932: AND xlj.event_type_code = xad1.event_type_code
955: --AND xlj.event_class_code = jlt.event_class_code
956: --AND xlj.accounting_line_type_code = jlt.accounting_line_type_code
957: --AND xlj.accounting_line_code = jlt.accounting_line_code
958: --AND jlt.business_method_code <> 'PRIOR_ENTRY'
959: AND EXISTS (SELECT 1 FROM xla_line_defn_adr_assgns xad1
960: WHERE xlj.application_id = xad1.application_id
961: AND xlj.amb_context_code = xad1.amb_context_code
962: AND xlj.event_class_code = xad1.event_class_code
963: AND xlj.event_type_code = xad1.event_type_code
966: AND xlj.accounting_line_type_code = xad1.accounting_line_type_code
967: AND xlj.accounting_line_code = xad1.accounting_line_code )
968: AND 2<>
969: (SELECT nvl(sum(decode(side_code, 'ALL', 2, 'NA', 2, 1)), 0)
970: FROM xla_line_defn_adr_assgns xad
971: WHERE xlj.application_id = xad.application_id
972: AND xlj.amb_context_code = xad.amb_context_code
973: AND xlj.event_class_code = xad.event_class_code
974: AND xlj.event_type_code = xad.event_type_code
1004: -- AND xlj.event_class_code = jlt.event_class_code
1005: -- AND xlj.accounting_line_type_code = jlt.accounting_line_type_code
1006: -- AND xlj.accounting_line_code = jlt.accounting_line_code
1007: -- AND jlt.business_method_code <> 'PRIOR_ENTRY' -- Bug 4922099
1008: AND EXISTS (SELECT 1 FROM xla_line_defn_adr_assgns xad1
1009: WHERE xlj.application_id = xad1.application_id
1010: AND xlj.amb_context_code = xad1.amb_context_code
1011: AND xlj.event_class_code = xad1.event_class_code
1012: AND xlj.event_type_code = xad1.event_type_code
1016: AND xlj.accounting_line_code = xad1.accounting_line_code )
1017: AND (
1018: (NOT EXISTS
1019: (SELECT 'Y'
1020: FROM xla_line_defn_adr_assgns xad
1021: WHERE xlj.application_id = xad.application_id
1022: AND xlj.amb_context_code = xad.amb_context_code
1023: AND xlj.event_class_code = xad.event_class_code
1024: AND xlj.event_type_code = xad.event_type_code
1029: AND xad.flexfield_segment_code = fif.application_column_name
1030: AND xad.side_code in ('NA', 'CREDIT', 'ALL'))
1031: AND NOT EXISTS
1032: (SELECT 'Y'
1033: FROM xla_line_defn_adr_assgns xad
1034: WHERE xlj.application_id = xad.application_id
1035: AND xlj.amb_context_code = xad.amb_context_code
1036: AND xlj.event_class_code = xad.event_class_code
1037: AND xlj.event_type_code = xad.event_type_code
1042: AND xad.flexfield_segment_code = 'ALL'
1043: AND xad.side_code in ('NA', 'CREDIT', 'ALL')))
1044: OR ( NOT EXISTS
1045: (SELECT 'Y'
1046: FROM xla_line_defn_adr_assgns xad
1047: WHERE xlj.application_id = xad.application_id
1048: AND xlj.amb_context_code = xad.amb_context_code
1049: AND xlj.event_class_code = xad.event_class_code
1050: AND xlj.event_type_code = xad.event_type_code
1055: AND xad.flexfield_segment_code = fif.application_column_name
1056: AND xad.side_code in ('NA', 'DEBIT', 'ALL'))
1057: AND NOT EXISTS
1058: (SELECT 'Y'
1059: FROM xla_line_defn_adr_assgns xad
1060: WHERE xlj.application_id = xad.application_id
1061: AND xlj.amb_context_code = xad.amb_context_code
1062: AND xlj.event_class_code = xad.event_class_code
1063: AND xlj.event_type_code = xad.event_type_code
1193: IS
1194: CURSOR c_invalid_adrs IS
1195: SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code
1196: FROM xla_line_defn_jlt_assgns xjl
1197: ,xla_line_defn_adr_assgns xad
1198: ,xla_seg_rules_b xsr
1199: WHERE xsr.application_id = xad.application_id
1200: AND xsr.amb_context_code = xad.amb_context_code
1201: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1221: CURSOR c_adr IS
1222: SELECT distinct xsr.application_id, xsr.amb_context_code,
1223: xsr.segment_rule_type_code, xsr.segment_rule_code
1224: FROM xla_line_defn_jlt_assgns xjl
1225: ,xla_line_defn_adr_assgns xad
1226: ,xla_seg_rules_b xsr
1227: WHERE xsr.application_id = xad.application_id
1228: AND xsr.amb_context_code = xad.amb_context_code
1229: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1373: RETURN BOOLEAN
1374: IS
1375: CURSOR c_invalid_adrs IS
1376: SELECT distinct xad.segment_rule_code, xad.segment_rule_type_code
1377: FROM xla_line_defn_adr_assgns xad, xla_line_defn_jlt_assgns xjl
1378: WHERE xad.application_id = xjl.application_id
1379: AND xad.amb_context_code = xjl.amb_context_code
1380: AND xad.event_class_code = xjl.event_class_code
1381: AND xad.event_type_code = xjl.event_type_code
1402: CURSOR c_adr IS
1403: SELECT distinct xsr.application_id, xsr.amb_context_code,
1404: xsr.segment_rule_type_code, xsr.segment_rule_code
1405: FROM xla_line_defn_jlt_assgns xjl
1406: ,xla_line_defn_adr_assgns xad
1407: ,xla_seg_rules_b xsr
1408: WHERE xsr.application_id = xad.application_id
1409: AND xsr.amb_context_code = xad.amb_context_code
1410: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1560: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1561: xco.source_type_code, xco.source_code
1562: FROM xla_conditions xco
1563: ,xla_seg_rule_details xsr
1564: ,xla_line_defn_adr_assgns xad
1565: ,xla_line_defn_jlt_assgns xjl
1566: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
1567: AND xsr.application_id = xad.application_id
1568: AND xsr.amb_context_code = xad.amb_context_code
1598: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1599: xco.value_source_type_code source_type_code, xco.value_source_code source_code
1600: FROM xla_conditions xco
1601: ,xla_seg_rule_details xsr
1602: ,xla_line_defn_adr_assgns xad
1603: ,xla_line_defn_jlt_assgns xjl
1604: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
1605: AND xsr.application_id = xad.application_id
1606: AND xsr.amb_context_code = xad.amb_context_code
1637: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1638: xco.source_type_code source_type_code, xco.source_code source_code
1639: FROM xla_conditions xco
1640: ,xla_seg_rule_details xsr
1641: ,xla_line_defn_adr_assgns xad
1642: ,xla_line_defn_jlt_assgns xjl
1643: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
1644: AND xsr.application_id = xad.application_id
1645: AND xsr.amb_context_code = xad.amb_context_code
1666: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1667: xco.value_source_type_code source_type_code, xco.value_source_code source_code
1668: FROM xla_conditions xco
1669: ,xla_seg_rule_details xsr
1670: ,xla_line_defn_adr_assgns xad
1671: ,xla_line_defn_jlt_assgns xjl
1672: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
1673: AND xsr.application_id = xad.application_id
1674: AND xsr.amb_context_code = xad.amb_context_code
1696: SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code,
1697: xsr.value_segment_rule_appl_id,
1698: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
1699: FROM xla_line_defn_jlt_assgns xjl
1700: ,xla_line_defn_adr_assgns xad
1701: ,xla_seg_rule_details xsr
1702: WHERE xsr.application_id = xad.application_id
1703: AND xsr.amb_context_code = xad.amb_context_code
1704: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1969: CURSOR c_invalid_sources IS
1970: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1971: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
1972: FROM xla_seg_rule_details xsr
1973: ,xla_line_defn_adr_assgns xad
1974: ,xla_line_defn_jlt_assgns xjl
1975: WHERE xsr.application_id = xad.application_id
1976: AND xsr.amb_context_code = xad.amb_context_code
1977: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
2005: UNION
2006: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2007: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
2008: FROM xla_seg_rule_details xsr
2009: ,xla_line_defn_adr_assgns xad
2010: ,xla_line_defn_jlt_assgns xjl
2011: WHERE xsr.application_id = xad.application_id
2012: AND xsr.amb_context_code = xad.amb_context_code
2013: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
2042: CURSOR c_der_sources IS
2043: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2044: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
2045: FROM xla_seg_rule_details xsr
2046: ,xla_line_defn_adr_assgns xad
2047: ,xla_line_defn_jlt_assgns xjl
2048: WHERE xsr.application_id = xad.application_id
2049: AND xsr.amb_context_code = xad.amb_context_code
2050: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
2067: UNION
2068: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2069: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
2070: FROM xla_seg_rule_details xsr
2071: ,xla_line_defn_adr_assgns xad
2072: ,xla_line_defn_jlt_assgns xjl
2073: WHERE xsr.application_id = xad.application_id
2074: AND xsr.amb_context_code = xad.amb_context_code
2075: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
2095: SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code,
2096: xsr.value_segment_rule_appl_id,
2097: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
2098: FROM xla_line_defn_jlt_assgns xjl
2099: ,xla_line_defn_adr_assgns xad
2100: ,xla_seg_rule_details xsr
2101: WHERE xsr.application_id = xad.application_id
2102: AND xsr.amb_context_code = xad.amb_context_code
2103: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
3181: AND xal.accounting_line_code = xld.accounting_line_code
3182: AND xal.business_method_code = 'PRIOR_ENTRY'
3183: AND EXISTS
3184: (SELECT 'y'
3185: FROM xla_line_defn_adr_assgns adr
3186: WHERE adr.application_id = xld.application_id
3187: AND adr.amb_context_code = xld.amb_context_code
3188: AND adr.event_class_code = xld.event_class_code
3189: AND adr.event_type_code = xld.event_type_code
3246: AND xal.accounting_line_code = xld.accounting_line_code
3247: AND xal.business_method_code = 'NONE'
3248: AND EXISTS
3249: (SELECT 'y'
3250: FROM xla_line_defn_adr_assgns adr
3251: WHERE adr.application_id = xld.application_id
3252: AND adr.amb_context_code = xld.amb_context_code
3253: AND adr.event_class_code = xld.event_class_code
3254: AND adr.event_type_code = xld.event_type_code
5773: CURSOR c_invalid_ms IS
5774: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
5775: xsr.value_mapping_set_code
5776: FROM xla_seg_rule_details xsr
5777: ,xla_line_defn_adr_assgns xad
5778: ,xla_line_defn_jlt_assgns xjl
5779: ,xla_mapping_sets_b xms
5780: WHERE xms.mapping_set_code = xsr.value_mapping_set_code
5781: AND xms.amb_context_code = xsr.amb_context_code
11602: ,p_level => C_LEVEL_STATEMENT);
11603: END IF;
11604:
11605: DELETE
11606: FROM xla_line_defn_adr_assgns
11607: WHERE application_id = p_application_id
11608: AND amb_context_code = p_amb_context_code
11609: AND event_class_code = p_event_class_code
11610: AND event_type_code = p_event_type_code
11721: ,p_level => C_LEVEL_STATEMENT);
11722: END IF;
11723:
11724: DELETE
11725: FROM xla_line_defn_adr_assgns
11726: WHERE application_id = p_application_id
11727: AND amb_context_code = p_amb_context_code
11728: AND event_class_code = p_event_class_code
11729: AND event_type_code = p_event_type_code
12001:
12002:
12003: IF p_new_accounting_coa_id is not null and p_old_accounting_coa_id is null THEN
12004:
12005: INSERT INTO xla_line_defn_adr_assgns
12006: (application_id
12007: ,amb_context_code
12008: ,event_class_code
12009: ,event_type_code
12045: ,l_created_by
12046: ,l_last_update_date
12047: ,l_last_updated_by
12048: ,l_last_update_login
12049: FROM xla_line_defn_adr_assgns
12050: WHERE application_id = p_application_id
12051: AND amb_context_code = p_amb_context_code
12052: AND event_class_code = p_event_class_code
12053: AND event_type_code = p_event_type_code
12080: ,l_created_by
12081: ,l_last_update_date
12082: ,l_last_updated_by
12083: ,l_last_update_login
12084: FROM xla_line_defn_adr_assgns
12085: WHERE application_id = p_application_id
12086: AND amb_context_code = p_amb_context_code
12087: AND event_class_code = p_event_class_code
12088: AND event_type_code = p_event_type_code
12179: AND flexfield_segment_code <> 'ALL';
12180:
12181: ELSE
12182:
12183: INSERT INTO xla_line_defn_adr_assgns
12184: (application_id
12185: ,amb_context_code
12186: ,event_class_code
12187: ,event_type_code
12223: ,l_created_by
12224: ,l_last_update_date
12225: ,l_last_updated_by
12226: ,l_last_update_login
12227: FROM xla_line_defn_adr_assgns
12228: WHERE application_id = p_application_id
12229: AND amb_context_code = p_amb_context_code
12230: AND event_class_code = p_event_class_code
12231: AND event_type_code = p_event_type_code
13307: ,p_level => C_LEVEL_STATEMENT);
13308: END IF;
13309:
13310: IF ( p_include_adr_assignments = 'Y') THEN
13311: INSERT INTO xla_line_defn_adr_assgns
13312: (application_id
13313: ,amb_context_code
13314: ,event_class_code
13315: ,event_type_code
13351: ,l_created_by
13352: ,l_last_update_date
13353: ,l_last_updated_by
13354: ,l_last_update_login
13355: FROM xla_line_defn_adr_assgns
13356: WHERE application_id = p_application_id
13357: AND amb_context_code = p_amb_context_code
13358: AND event_class_code = p_event_class_code
13359: AND event_type_code = p_event_type_code
13904:
13905: CURSOR c_adr
13906: IS
13907: SELECT laa.flexfield_segment_code, seg.flex_value_set_id
13908: FROM xla_line_defn_adr_assgns laa, xla_seg_rules_b seg
13909: WHERE laa.application_id = p_application_id
13910: AND laa.amb_context_code = p_amb_context_code
13911: AND laa.event_class_code = p_event_class_code
13912: AND laa.event_type_code = p_event_type_code
14043: CURSOR c_child_adr IS
14044: SELECT distinct xsr.value_segment_rule_appl_id,
14045: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
14046: FROM xla_line_defn_jlt_assgns xjl
14047: ,xla_line_defn_adr_assgns xad
14048: ,xla_seg_rule_details xsr
14049: WHERE xsr.application_id = xad.application_id
14050: AND xsr.amb_context_code = xad.amb_context_code
14051: AND xsr.segment_rule_type_code = xad.segment_rule_type_code