[Home] [Help]
780: -- 'NA' side_code
781: --
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
908:
909: -- For JLT assignment of non-prior-entry JLT, there must be ADR assignment.
910: CURSOR c_invalid_no_adr IS
911: SELECT distinct xlj.accounting_line_type_code, xlj.accounting_line_code
912: FROM xla_line_defn_jlt_assgns xlj
913: ,xla_acct_line_types_b jlt
914: WHERE xlj.application_id = p_application_id
915: AND xlj.amb_context_code = p_amb_context_code
916: AND xlj.event_class_code = p_event_class_code
940: -- If ADR assignment exists, the ADR assignment must be complete
941: --
942: CURSOR c_invalid_adrs_no_coa IS
943: SELECT distinct xlj.accounting_line_type_code, xlj.accounting_line_code
944: FROM xla_line_defn_jlt_assgns xlj
945: --,xla_acct_line_types_b jlt
946: WHERE xlj.application_id = p_application_id
947: AND xlj.amb_context_code = p_amb_context_code
948: AND xlj.event_class_code = p_event_class_code
984: -- If ADR assignment exists, it must be complete.
985: --
986: CURSOR c_invalid_adrs IS
987: SELECT distinct xlj.accounting_line_type_code, xlj.accounting_line_code
988: FROM xla_line_defn_jlt_assgns xlj
989: ,fnd_id_flex_segments_vl fif
990: -- , xla_acct_line_types_b jlt
991: WHERE fif.application_id = 101
992: AND fif.id_flex_code = 'GL#'
1192: RETURN BOOLEAN
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
1220:
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
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
1401:
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
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
1569: AND xsr.segment_rule_type_code = xad.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
1607: AND xsr.segment_rule_type_code = xad.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
1646: AND xsr.segment_rule_type_code = xad.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
1675: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1695: CURSOR c_child_adr IS
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
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
1978: AND xsr.segment_rule_code = xad.segment_rule_code
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
2014: AND xsr.segment_rule_code = xad.segment_rule_code
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
2051: AND xsr.segment_rule_code = xad.segment_rule_code
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
2076: AND xsr.segment_rule_code = xad.segment_rule_code
2094: CURSOR c_child_adr IS
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
2472: -- Get any JLT assignment that has a disabled JLT
2473: --
2474: CURSOR c_active_line_assgns IS
2475: SELECT 'X'
2476: FROM xla_line_defn_jlt_assgns xld
2477: WHERE xld.application_id = p_application_id
2478: AND xld.amb_context_code = p_amb_context_code
2479: AND xld.event_class_code = p_event_class_code
2480: AND xld.event_type_code = p_event_type_code
2574: --
2575: CURSOR c_invalid_jlt IS
2576: SELECT distinct event_class_code, event_type_code,
2577: accounting_line_type_code, accounting_line_code
2578: FROM xla_line_defn_jlt_assgns xld
2579: WHERE xld.application_id = p_application_id
2580: AND xld.amb_context_code = p_amb_context_code
2581: AND xld.event_class_code = p_event_class_code
2582: AND xld.event_type_code = p_event_type_code
2684: --
2685: CURSOR c_invalid_jlt IS
2686: SELECT distinct xld.event_class_code, xld.event_type_code,
2687: xld.accounting_line_type_code, xld.accounting_line_code
2688: FROM xla_line_defn_jlt_assgns xld
2689: , xla_acct_line_types_b xal
2690: WHERE xal.application_id = xld.application_id
2691: AND xal.amb_context_code = xld.amb_context_code
2692: AND xal.event_class_code = xld.event_class_code
2795: --
2796: CURSOR c_invalid_jlt IS
2797: SELECT distinct xld.event_class_code, xld.event_type_code,
2798: xld.accounting_line_type_code, xld.accounting_line_code
2799: FROM xla_line_defn_jlt_assgns xld
2800: , xla_acct_line_types_b xal
2801: WHERE xal.application_id = xld.application_id
2802: AND xal.amb_context_code = xld.amb_context_code
2803: AND xal.event_class_code = xld.event_class_code
2908: --
2909: CURSOR c_invalid_jlt IS
2910: SELECT distinct xld.event_class_code, xld.event_type_code,
2911: xld.accounting_line_type_code, xld.accounting_line_code
2912: FROM xla_line_defn_jlt_assgns xld
2913: , xla_acct_line_types_b xal
2914: WHERE xal.application_id = xld.application_id
2915: AND xal.amb_context_code = xld.amb_context_code
2916: AND xal.event_class_code = xld.event_class_code
3021: --
3022: CURSOR c_invalid_jlt IS
3023: SELECT distinct xld.event_class_code, xld.event_type_code,
3024: xld.accounting_line_type_code, xld.accounting_line_code
3025: FROM xla_line_defn_jlt_assgns xld
3026: , xla_acct_line_types_b xal
3027: WHERE xal.application_id = xld.application_id
3028: AND xal.amb_context_code = xld.amb_context_code
3029: AND xal.event_class_code = xld.event_class_code
3135: --
3136: CURSOR c_invalid_jlt IS
3137: SELECT distinct event_class_code, event_type_code,
3138: accounting_line_type_code, accounting_line_code
3139: FROM xla_line_defn_jlt_assgns xld
3140: WHERE xld.application_id = p_application_id
3141: AND xld.amb_context_code = p_amb_context_code
3142: AND xld.event_class_code = p_event_class_code
3143: AND xld.event_type_code = p_event_type_code
3166: --
3167: CURSOR c_pe_adr_jlt IS
3168: SELECT distinct xld.event_class_code, xld.event_type_code,
3169: xld.accounting_line_type_code, xld.accounting_line_code
3170: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
3171: WHERE xld.application_id = p_application_id
3172: AND xld.amb_context_code = p_amb_context_code
3173: AND xld.event_class_code = p_event_class_code
3174: AND xld.event_type_code = p_event_type_code
3199: --
3200: CURSOR c_pe_ac_jlt IS
3201: SELECT distinct xld.event_class_code, xld.event_type_code,
3202: xld.accounting_line_type_code, xld.accounting_line_code
3203: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
3204: WHERE xld.application_id = p_application_id
3205: AND xld.amb_context_code = p_amb_context_code
3206: AND xld.event_class_code = p_event_class_code
3207: AND xld.event_type_code = p_event_type_code
3231: --
3232: CURSOR c_se_adr_jlt IS
3233: SELECT distinct xld.event_class_code, xld.event_type_code,
3234: xld.accounting_line_type_code, xld.accounting_line_code
3235: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
3236: WHERE xld.application_id = p_application_id
3237: AND xld.amb_context_code = p_amb_context_code
3238: AND xld.event_class_code = p_event_class_code
3239: AND xld.event_type_code = p_event_type_code
3263: --
3264: CURSOR c_invalid_class IS
3265: SELECT distinct xld.event_class_code, xld.event_type_code,
3266: xld.accounting_line_type_code, xld.accounting_line_code
3267: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
3268: WHERE xld.application_id = p_application_id
3269: AND xld.amb_context_code = p_amb_context_code
3270: AND xld.event_class_code = p_event_class_code
3271: AND xld.event_type_code = p_event_type_code
3486: -- and have inherit_desc_flag set to 'Y'
3487: --
3488: CURSOR c_same_entry_jlt_debit IS
3489: SELECT 'x'
3490: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
3491: WHERE xld.application_id = p_application_id
3492: AND xld.amb_context_code = p_amb_context_code
3493: AND xld.event_class_code = p_event_class_code
3494: AND xld.event_type_code = p_event_type_code
3503: AND xal.natural_side_code = 'D';
3504:
3505: CURSOR c_same_entry_jlt_credit IS
3506: SELECT 'x'
3507: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b xal
3508: WHERE xld.application_id = p_application_id
3509: AND xld.amb_context_code = p_amb_context_code
3510: AND xld.event_class_code = p_event_class_code
3511: AND xld.event_type_code = p_event_type_code
3628: CURSOR c_invalid_sources IS
3629: SELECT distinct xld.event_class_code, xld.event_type_code,
3630: xld.accounting_line_type_code, xld.accounting_line_code,
3631: xco.source_type_code, xco.source_code
3632: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
3633: WHERE xld.application_id = p_application_id
3634: AND xld.amb_context_code = p_amb_context_code
3635: AND xld.event_class_code = p_event_class_code
3636: AND xld.event_type_code = p_event_type_code
3655: UNION
3656: SELECT distinct xld.event_class_code, xld.event_type_code,
3657: xld.accounting_line_type_code, xld.accounting_line_code,
3658: xco.value_source_type_code source_type_code, xco.value_source_code source_code
3659: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
3660: WHERE xld.application_id = p_application_id
3661: AND xld.amb_context_code = p_amb_context_code
3662: AND xld.event_class_code = p_event_class_code
3663: AND xld.event_type_code = p_event_type_code
3686: CURSOR c_jlt_cond_der_sources IS
3687: SELECT distinct xld.event_class_code, xld.event_type_code,
3688: xld.accounting_line_type_code, xld.accounting_line_code,
3689: xco.source_type_code, xco.source_code
3690: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
3691: WHERE xld.application_id = p_application_id
3692: AND xld.amb_context_code = p_amb_context_code
3693: AND xld.event_class_code = p_event_class_code
3694: AND xld.event_type_code = p_event_type_code
3704: UNION
3705: SELECT distinct xld.event_class_code, xld.event_type_code,
3706: xld.accounting_line_type_code, xld.accounting_line_code,
3707: xco.value_source_type_code source_type_code, xco.value_source_code source_code
3708: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
3709: WHERE xld.application_id = p_application_id
3710: AND xld.amb_context_code = p_amb_context_code
3711: AND xld.event_class_code = p_event_class_code
3712: AND xld.event_type_code = p_event_type_code
3855: SELECT distinct xld.event_class_code, xld.event_type_code,
3856: xld.accounting_line_type_code, xld.accounting_line_code,
3857: xco.source_type_code, xco.source_code
3858: ,xco.accounting_attribute_code
3859: FROM xla_jlt_acct_attrs xco, xla_line_defn_jlt_assgns xld,
3860: xla_acct_attributes_b xaab
3861: WHERE xld.application_id = p_application_id
3862: AND xld.amb_context_code = p_amb_context_code
3863: AND xld.event_class_code = p_event_class_code
3890: SELECT distinct xld.event_class_code, xld.event_type_code,
3891: xld.accounting_line_type_code, xld.accounting_line_code,
3892: xco.source_type_code, xco.source_code
3893: ,xco.accounting_attribute_code
3894: FROM xla_jlt_acct_attrs xco, xla_line_defn_jlt_assgns xld
3895: WHERE xld.application_id = p_application_id
3896: AND xld.amb_context_code = p_amb_context_code
3897: AND xld.event_class_code = p_event_class_code
3898: AND xld.event_type_code = p_event_type_code
4041: CURSOR c_non_pe_jlt IS
4042: SELECT xld.accounting_line_type_code
4043: ,xld.accounting_line_code
4044: ,xja.accounting_attribute_code
4045: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt, xla_jlt_acct_attrs xja
4046: WHERE xld.application_id = xja.application_id
4047: AND xld.amb_context_code = xja.amb_context_code
4048: AND xld.event_class_code = xja.event_class_code
4049: AND xld.accounting_line_type_code = xja.accounting_line_type_code
4070: CURSOR c_pe_jlt IS
4071: SELECT xld.accounting_line_type_code
4072: ,xld.accounting_line_code
4073: ,xja.accounting_attribute_code
4074: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt, xla_jlt_acct_attrs xja
4075: WHERE xld.application_id = xja.application_id
4076: AND xld.amb_context_code = xja.amb_context_code
4077: AND xld.event_class_code = xja.event_class_code
4078: AND xld.accounting_line_type_code = xja.accounting_line_type_code
4213: RETURN BOOLEAN
4214: IS
4215: CURSOR c_jlt_assgns IS
4216: SELECT accounting_line_type_code, accounting_line_code
4217: FROM xla_line_defn_jlt_assgns
4218: WHERE application_id = p_application_id
4219: AND amb_context_code = p_amb_context_code
4220: AND event_class_code = p_event_class_code
4221: AND event_type_code = p_event_type_code
4695: RETURN BOOLEAN
4696: IS
4697: CURSOR c_invalid_line_desc IS
4698: SELECT distinct xdb.description_type_code, xdb.description_code
4699: FROM xla_line_defn_jlt_assgns xjl
4700: ,xla_descriptions_b xdb
4701: WHERE xjl.application_id = p_application_id
4702: AND xjl.amb_context_code = p_amb_context_code
4703: AND xjl.event_class_code = p_event_class_code
4803: SELECT distinct xjl.description_type_code, xjl.description_code,
4804: xco.source_type_code source_type_code, xco.source_code source_code
4805: FROM xla_conditions xco
4806: ,xla_desc_priorities xdp
4807: ,xla_line_defn_jlt_assgns xjl
4808: WHERE xco.description_prio_id = xdp.description_prio_id
4809: AND xdp.application_id = xjl.application_id
4810: AND xdp.amb_context_code = xjl.amb_context_code
4811: AND xdp.description_type_code = xjl.description_type_code
4831: SELECT distinct xjl.description_type_code, xjl.description_code,
4832: xco.value_source_type_code source_type_code, xco.value_source_code source_code
4833: FROM xla_conditions xco
4834: ,xla_desc_priorities xdp
4835: ,xla_line_defn_jlt_assgns xjl
4836: WHERE xco.description_prio_id = xdp.description_prio_id
4837: AND xdp.application_id = xjl.application_id
4838: AND xdp.amb_context_code = xjl.amb_context_code
4839: AND xdp.description_type_code = xjl.description_type_code
4860: SELECT distinct xjl.description_type_code, xjl.description_code,
4861: xco.source_type_code source_type_code, xco.source_code source_code
4862: FROM xla_conditions xco
4863: ,xla_desc_priorities xdp
4864: ,xla_line_defn_jlt_assgns xjl
4865: WHERE xco.description_prio_id = xdp.description_prio_id
4866: AND xdp.application_id = xjl.application_id
4867: AND xdp.amb_context_code = xjl.amb_context_code
4868: AND xdp.description_type_code = xjl.description_type_code
4879: SELECT distinct xjl.description_type_code, xjl.description_code,
4880: xco.value_source_type_code source_type_code, xco.value_source_code source_code
4881: FROM xla_conditions xco
4882: ,xla_desc_priorities xdp
4883: ,xla_line_defn_jlt_assgns xjl
4884: WHERE xco.description_prio_id = xdp.description_prio_id
4885: AND xdp.application_id = xjl.application_id
4886: AND xdp.amb_context_code = xjl.amb_context_code
4887: AND xdp.description_type_code = xjl.description_type_code
5027: SELECT distinct xjl.description_type_code, xjl.description_code,
5028: xdd.source_type_code, xdd.source_code
5029: FROM xla_descript_details_b xdd
5030: ,xla_desc_priorities xdp
5031: ,xla_line_defn_jlt_assgns xjl
5032: WHERE xdd.description_prio_id = xdp.description_prio_id
5033: AND xdp.application_id = xjl.application_id
5034: AND xdp.amb_context_code = xjl.amb_context_code
5035: AND xdp.description_type_code = xjl.description_type_code
5056: SELECT distinct xjl.description_type_code, xjl.description_code,
5057: xdd.source_type_code, xdd.source_code
5058: FROM xla_descript_details_b xdd
5059: ,xla_desc_priorities xdp
5060: ,xla_line_defn_jlt_assgns xjl
5061: WHERE xdd.description_prio_id = xdp.description_prio_id
5062: AND xdp.application_id = xjl.application_id
5063: AND xdp.amb_context_code = xjl.amb_context_code
5064: AND xdp.description_type_code = xjl.description_type_code
5284: IS
5285: CURSOR c_invalid_line_ac IS
5286: SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
5287: FROM xla_line_defn_ac_assgns xac
5288: ,xla_line_defn_jlt_assgns xjl
5289: ,xla_analytical_hdrs_b xah
5290: WHERE xah.amb_context_code = xac.amb_context_code
5291: AND xah.analytical_criterion_code = xac.analytical_criterion_code
5292: AND xah.analytical_criterion_type_code = xac.analytical_criterion_type_code
5392: IS
5393: CURSOR c_invalid_ac IS
5394: SELECT distinct xac.analytical_criterion_type_code, xac.analytical_criterion_code
5395: FROM xla_line_defn_ac_assgns xac
5396: ,xla_line_defn_jlt_assgns xjl
5397: WHERE xac.application_id = xjl.application_id
5398: AND xac.amb_context_code = xjl.amb_context_code
5399: AND xac.event_class_code = xjl.event_class_code
5400: AND xac.event_type_code = xjl.event_type_code
5505: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
5506: xas.source_code, xas.source_type_code
5507: FROM xla_analytical_sources xas
5508: ,xla_line_defn_ac_assgns xac
5509: ,xla_line_defn_jlt_assgns xjl
5510: ,xla_event_sources xes
5511: WHERE xas.application_id = xac.application_id
5512: AND xas.amb_context_code = xac.amb_context_code
5513: AND xas.event_class_code = xac.event_class_code
5542: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
5543: xas.source_code, xas.source_type_code
5544: FROM xla_analytical_sources xas
5545: ,xla_line_defn_ac_assgns xac
5546: ,xla_line_defn_jlt_assgns xjl
5547: WHERE xas.application_id = xac.application_id
5548: AND xas.amb_context_code = xac.amb_context_code
5549: AND xas.event_class_code = xac.event_class_code
5550: AND xas.analytical_criterion_code = xac.analytical_criterion_code
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
5782: AND xms.enabled_flag <> 'Y'
5954: -- Get all JLT assignment that have less than 2 MPA JLT assignments
5955: --
5956: CURSOR c_invalid_jlt IS
5957: SELECT distinct xld.accounting_line_type_code, xld.accounting_line_code
5958: FROM xla_line_defn_jlt_assgns xld, xla_acct_line_types_b jlt
5959: WHERE xld.application_id = p_application_id
5960: AND xld.amb_context_code = p_amb_context_code
5961: AND xld.event_class_code = p_event_class_code
5962: AND xld.event_type_code = p_event_type_code
6088: --
6089: CURSOR c_invalid_jlt IS
6090: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6091: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
6092: FROM xla_line_defn_jlt_assgns xld
6093: ,xla_mpa_jlt_assgns mpa
6094: WHERE xld.application_id = p_application_id
6095: AND xld.amb_context_code = p_amb_context_code
6096: AND xld.event_class_code = p_event_class_code
6106: AND xld.line_definition_code = mpa.line_definition_code
6107: AND xld.accounting_line_type_code = mpa.accounting_line_type_code
6108: AND xld.accounting_line_code = mpa.accounting_line_code
6109: AND NOT EXISTS (SELECT 'x'
6110: FROM xla_line_defn_jlt_assgns xld1
6111: WHERE xld1.application_id = mpa.application_id
6112: AND xld1.amb_context_code = mpa.amb_context_code
6113: AND xld1.event_class_code = mpa.event_class_code
6114: AND xld1.event_type_code = mpa.event_type_code
6217: --
6218: CURSOR c_invalid_jlt IS
6219: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6220: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
6221: FROM xla_line_defn_jlt_assgns xld
6222: , xla_acct_line_types_b xal
6223: ,xla_mpa_jlt_assgns mpa
6224: WHERE xal.application_id = mpa.application_id
6225: AND xal.amb_context_code = mpa.amb_context_code
6242: AND xld.line_definition_code = mpa.line_definition_code
6243: AND xld.accounting_line_type_code = mpa.accounting_line_type_code
6244: AND xld.accounting_line_code = mpa.accounting_line_code
6245: AND NOT EXISTS (SELECT 'x'
6246: FROM xla_line_defn_jlt_assgns xld1
6247: WHERE xld1.application_id = mpa.application_id
6248: AND xld1.amb_context_code = mpa.amb_context_code
6249: AND xld1.event_class_code = mpa.event_class_code
6250: AND xld1.event_type_code = mpa.event_type_code
6351: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6352: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
6353: xco.source_type_code, xco.source_code
6354: FROM xla_conditions xco
6355: ,xla_line_defn_jlt_assgns xld
6356: ,xla_mpa_jlt_assgns mpa
6357: WHERE xld.application_id = p_application_id
6358: AND xld.amb_context_code = p_amb_context_code
6359: AND xld.event_class_code = p_event_class_code
6375: AND xld.line_definition_code = mpa.line_definition_code
6376: AND xld.accounting_line_type_code = mpa.accounting_line_type_code
6377: AND xld.accounting_line_code = mpa.accounting_line_code
6378: AND NOT EXISTS (SELECT 'x'
6379: FROM xla_line_defn_jlt_assgns xld1
6380: WHERE xld1.application_id = mpa.application_id
6381: AND xld1.amb_context_code = mpa.amb_context_code
6382: AND xld1.event_class_code = mpa.event_class_code
6383: AND xld1.event_type_code = mpa.event_type_code
6398: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6399: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
6400: xco.value_source_type_code source_type_code, xco.value_source_code source_code
6401: FROM xla_conditions xco
6402: ,xla_line_defn_jlt_assgns xld
6403: ,xla_mpa_jlt_assgns mpa
6404: WHERE xld.application_id = p_application_id
6405: AND xld.amb_context_code = p_amb_context_code
6406: AND xld.event_class_code = p_event_class_code
6422: AND xld.line_definition_code = mpa.line_definition_code
6423: AND xld.accounting_line_type_code = mpa.accounting_line_type_code
6424: AND xld.accounting_line_code = mpa.accounting_line_code
6425: AND NOT EXISTS (SELECT 'x'
6426: FROM xla_line_defn_jlt_assgns xld1
6427: WHERE xld1.application_id = mpa.application_id
6428: AND xld1.amb_context_code = mpa.amb_context_code
6429: AND xld1.event_class_code = mpa.event_class_code
6430: AND xld1.event_type_code = mpa.event_type_code
6449: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6450: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
6451: xco.source_type_code, xco.source_code
6452: FROM xla_conditions xco
6453: ,xla_line_defn_jlt_assgns xld
6454: ,xla_mpa_jlt_assgns mpa
6455: WHERE xld.application_id = p_application_id
6456: AND xld.amb_context_code = p_amb_context_code
6457: AND xld.event_class_code = p_event_class_code
6473: AND xld.line_definition_code = mpa.line_definition_code
6474: AND xld.accounting_line_type_code = mpa.accounting_line_type_code
6475: AND xld.accounting_line_code = mpa.accounting_line_code
6476: AND NOT EXISTS (SELECT 'x'
6477: FROM xla_line_defn_jlt_assgns xld1
6478: WHERE xld1.application_id = mpa.application_id
6479: AND xld1.amb_context_code = mpa.amb_context_code
6480: AND xld1.event_class_code = mpa.event_class_code
6481: AND xld1.event_type_code = mpa.event_type_code
6487: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6488: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
6489: xco.value_source_type_code source_type_code, xco.value_source_code source_code
6490: FROM xla_conditions xco
6491: ,xla_line_defn_jlt_assgns xld
6492: ,xla_mpa_jlt_assgns mpa
6493: WHERE xld.application_id = p_application_id
6494: AND xld.amb_context_code = p_amb_context_code
6495: AND xld.event_class_code = p_event_class_code
6511: AND xld.line_definition_code = mpa.line_definition_code
6512: AND xld.accounting_line_type_code = mpa.accounting_line_type_code
6513: AND xld.accounting_line_code = mpa.accounting_line_code
6514: AND NOT EXISTS (SELECT 'x'
6515: FROM xla_line_defn_jlt_assgns xld1
6516: WHERE xld1.application_id = mpa.application_id
6517: AND xld1.amb_context_code = mpa.amb_context_code
6518: AND xld1.event_class_code = mpa.event_class_code
6519: AND xld1.event_type_code = mpa.event_type_code
6655: CURSOR c_non_pe_jlt IS
6656: SELECT mpa.mpa_accounting_line_type_code
6657: ,mpa.mpa_accounting_line_code
6658: ,xja.accounting_attribute_code
6659: FROM xla_line_defn_jlt_assgns xld
6660: ,xla_acct_line_types_b jlt
6661: ,xla_jlt_acct_attrs xja
6662: ,xla_mpa_jlt_assgns mpa
6663: WHERE jlt.application_id = xja.application_id
6687: AND xld.accounting_line_type_code = mpa.accounting_line_type_code
6688: AND xld.accounting_line_code = mpa.accounting_line_code
6689: AND xja.source_code is null
6690: AND NOT EXISTS (SELECT 'x'
6691: FROM xla_line_defn_jlt_assgns xld1
6692: WHERE xld1.application_id = mpa.application_id
6693: AND xld1.amb_context_code = mpa.amb_context_code
6694: AND xld1.event_class_code = mpa.event_class_code
6695: AND xld1.event_type_code = mpa.event_type_code
6706: CURSOR c_pe_jlt IS
6707: SELECT mpa.mpa_accounting_line_type_code
6708: ,mpa.mpa_accounting_line_code
6709: ,xja.accounting_attribute_code
6710: FROM xla_line_defn_jlt_assgns xld
6711: ,xla_acct_line_types_b jlt
6712: ,xla_jlt_acct_attrs xja
6713: ,xla_mpa_jlt_assgns mpa
6714: WHERE jlt.application_id = xja.application_id
6738: AND xld.accounting_line_type_code = mpa.accounting_line_type_code
6739: AND xld.accounting_line_code = mpa.accounting_line_code
6740: AND xja.source_code is null
6741: AND NOT EXISTS (SELECT 'x'
6742: FROM xla_line_defn_jlt_assgns xld1
6743: WHERE xld1.application_id = mpa.application_id
6744: AND xld1.amb_context_code = mpa.amb_context_code
6745: AND xld1.event_class_code = mpa.event_class_code
6746: AND xld1.event_type_code = mpa.event_type_code
6871: RETURN BOOLEAN
6872: IS
6873: CURSOR c_jlt_assgns IS
6874: SELECT distinct mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
6875: FROM xla_line_defn_jlt_assgns xld
6876: ,xla_mpa_jlt_assgns mpa
6877: WHERE xld.application_id = p_application_id
6878: AND xld.amb_context_code = p_amb_context_code
6879: AND xld.event_class_code = p_event_class_code
6889: AND xld.line_definition_code = mpa.line_definition_code
6890: AND xld.accounting_line_type_code = mpa.accounting_line_type_code
6891: AND xld.accounting_line_code = mpa.accounting_line_code
6892: AND NOT EXISTS (SELECT 'x'
6893: FROM xla_line_defn_jlt_assgns xld1
6894: WHERE xld1.application_id = mpa.application_id
6895: AND xld1.amb_context_code = mpa.amb_context_code
6896: AND xld1.event_class_code = mpa.event_class_code
6897: AND xld1.event_type_code = mpa.event_type_code
7252: IS
7253: CURSOR c_invalid_line_desc IS
7254: SELECT distinct xdb.description_type_code, xdb.description_code
7255: FROM xla_mpa_jlt_assgns mjl
7256: ,xla_line_defn_jlt_assgns xjl
7257: ,xla_descriptions_b xdb
7258: WHERE xjl.application_id = p_application_id
7259: AND xjl.amb_context_code = p_amb_context_code
7260: AND xjl.event_class_code = p_event_class_code
7369: xco.source_type_code source_type_code, xco.source_code source_code
7370: FROM xla_conditions xco
7371: ,xla_desc_priorities xdp
7372: ,xla_mpa_jlt_assgns mjl
7373: ,xla_line_defn_jlt_assgns xjl
7374: WHERE xco.description_prio_id = xdp.description_prio_id
7375: AND xdp.application_id = mjl.application_id
7376: AND xdp.amb_context_code = mjl.amb_context_code
7377: AND xdp.description_type_code = mjl.description_type_code
7406: SELECT distinct xjl.description_type_code, xjl.description_code,
7407: xco.value_source_type_code source_type_code, xco.value_source_code source_code
7408: FROM xla_conditions xco
7409: ,xla_desc_priorities xdp
7410: ,xla_line_defn_jlt_assgns xjl
7411: ,xla_mpa_jlt_assgns mjl
7412: WHERE xco.description_prio_id = xdp.description_prio_id
7413: AND xdp.application_id = mjl.application_id
7414: AND xdp.amb_context_code = mjl.amb_context_code
7445: SELECT distinct xjl.description_type_code, xjl.description_code,
7446: xco.source_type_code source_type_code, xco.source_code source_code
7447: FROM xla_conditions xco
7448: ,xla_desc_priorities xdp
7449: ,xla_line_defn_jlt_assgns xjl
7450: ,xla_mpa_jlt_assgns mjl
7451: WHERE xco.description_prio_id = xdp.description_prio_id
7452: AND xdp.application_id = mjl.application_id
7453: AND xdp.amb_context_code = mjl.amb_context_code
7474: SELECT distinct xjl.description_type_code, xjl.description_code,
7475: xco.value_source_type_code source_type_code, xco.value_source_code source_code
7476: FROM xla_conditions xco
7477: ,xla_desc_priorities xdp
7478: ,xla_line_defn_jlt_assgns xjl
7479: ,xla_mpa_jlt_assgns mjl
7480: WHERE xco.description_prio_id = xdp.description_prio_id
7481: AND xdp.application_id = mjl.application_id
7482: AND xdp.amb_context_code = mjl.amb_context_code
7632: SELECT distinct xjl.description_type_code, xjl.description_code,
7633: xdd.source_type_code, xdd.source_code
7634: FROM xla_descript_details_b xdd
7635: ,xla_desc_priorities xdp
7636: ,xla_line_defn_jlt_assgns xjl
7637: ,xla_mpa_jlt_assgns mjl
7638: WHERE xdd.description_prio_id = xdp.description_prio_id
7639: AND xdp.application_id = mjl.application_id
7640: AND xdp.amb_context_code = mjl.amb_context_code
7671: SELECT distinct xjl.description_type_code, xjl.description_code,
7672: xdd.source_type_code, xdd.source_code
7673: FROM xla_descript_details_b xdd
7674: ,xla_desc_priorities xdp
7675: ,xla_line_defn_jlt_assgns xjl
7676: ,xla_mpa_jlt_assgns mjl
7677: WHERE xdd.description_prio_id = xdp.description_prio_id
7678: AND xdp.application_id = mjl.application_id
7679: AND xdp.amb_context_code = mjl.amb_context_code
7908: IS
7909: CURSOR c_invalid_line_ac IS
7910: SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
7911: FROM xla_mpa_jlt_ac_assgns xac
7912: ,xla_line_defn_jlt_assgns xjl
7913: ,xla_analytical_hdrs_b xah
7914: WHERE xah.amb_context_code = xac.amb_context_code
7915: AND xah.analytical_criterion_code = xac.analytical_criterion_code
7916: AND xah.analytical_criterion_type_code = xac.analytical_criterion_type_code
8016: IS
8017: CURSOR c_invalid_ac IS
8018: SELECT distinct xac.analytical_criterion_type_code, xac.analytical_criterion_code
8019: FROM xla_mpa_jlt_ac_assgns xac
8020: ,xla_line_defn_jlt_assgns xjl
8021: WHERE xac.application_id = xjl.application_id
8022: AND xac.amb_context_code = xjl.amb_context_code
8023: AND xac.event_class_code = xjl.event_class_code
8024: AND xac.event_type_code = xjl.event_type_code
8129: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
8130: xas.source_code, xas.source_type_code
8131: FROM xla_analytical_sources xas
8132: ,xla_mpa_jlt_ac_assgns xac
8133: ,xla_line_defn_jlt_assgns xjl
8134: ,xla_event_sources xes
8135: WHERE xas.application_id = xac.application_id
8136: AND xas.amb_context_code = xac.amb_context_code
8137: AND xas.event_class_code = xac.event_class_code
8166: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
8167: xas.source_code, xas.source_type_code
8168: FROM xla_analytical_sources xas
8169: ,xla_mpa_jlt_ac_assgns xac
8170: ,xla_line_defn_jlt_assgns xjl
8171: WHERE xas.application_id = xac.application_id
8172: AND xas.amb_context_code = xac.amb_context_code
8173: AND xas.event_class_code = xac.event_class_code
8174: AND xas.analytical_criterion_code = xac.analytical_criterion_code
8413: -- Get line assignments that does not contain flexfield assignment
8414: --
8415: CURSOR c_invalid_adrs_no_coa IS
8416: SELECT distinct mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
8417: FROM xla_line_defn_jlt_assgns xlj
8418: ,xla_acct_line_types_b jlt
8419: ,xla_acct_line_types_b jlt1
8420: ,xla_mpa_jlt_assgns mpa
8421: WHERE xlj.application_id = p_application_id
8467: -- assignment or does not have complete segment assignments
8468: --
8469: CURSOR c_invalid_adrs IS
8470: SELECT distinct mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code
8471: FROM xla_line_defn_jlt_assgns xlj
8472: ,fnd_id_flex_segments_vl fif
8473: , xla_acct_line_types_b jlt
8474: ,xla_acct_line_types_b jlt1
8475: ,xla_mpa_jlt_assgns mpa
8640: RETURN BOOLEAN
8641: IS
8642: CURSOR c_invalid_adrs IS
8643: SELECT distinct xsr.segment_rule_type_code, xsr.segment_rule_code
8644: FROM xla_line_defn_jlt_assgns xjl
8645: ,xla_mpa_jlt_adr_assgns xad
8646: ,xla_seg_rules_b xsr
8647: WHERE xsr.application_id = xad.application_id
8648: AND xsr.amb_context_code = xad.amb_context_code
8665: AND xjl.line_definition_owner_code = p_line_definition_owner_code
8666: AND xjl.line_definition_code = p_line_definition_code
8667: AND xjl.active_flag = 'Y'
8668: AND NOT EXISTS (SELECT 'x'
8669: FROM xla_line_defn_jlt_assgns xld1
8670: WHERE xld1.application_id = xad.application_id
8671: AND xld1.amb_context_code = xad.amb_context_code
8672: AND xld1.event_class_code = xad.event_class_code
8673: AND xld1.event_type_code = xad.event_type_code
8679:
8680: CURSOR c_adr IS
8681: SELECT distinct xsr.application_id, xsr.amb_context_code,
8682: xsr.segment_rule_type_code, xsr.segment_rule_code
8683: FROM xla_line_defn_jlt_assgns xjl
8684: ,xla_mpa_jlt_adr_assgns xad
8685: ,xla_seg_rules_b xsr
8686: WHERE xsr.application_id = xad.application_id
8687: AND xsr.amb_context_code = xad.amb_context_code
8703: AND xjl.line_definition_owner_code = p_line_definition_owner_code
8704: AND xjl.line_definition_code = p_line_definition_code
8705: AND xjl.active_flag = 'Y'
8706: AND NOT EXISTS (SELECT 'x'
8707: FROM xla_line_defn_jlt_assgns xld1
8708: WHERE xld1.application_id = xad.application_id
8709: AND xld1.amb_context_code = xad.amb_context_code
8710: AND xld1.event_class_code = xad.event_class_code
8711: AND xld1.event_type_code = xad.event_type_code
8843: RETURN BOOLEAN
8844: IS
8845: CURSOR c_invalid_adrs IS
8846: SELECT distinct xad.segment_rule_code, xad.segment_rule_type_code
8847: FROM xla_mpa_jlt_adr_assgns xad, xla_line_defn_jlt_assgns xjl
8848: WHERE xad.application_id = xjl.application_id
8849: AND xad.amb_context_code = xjl.amb_context_code
8850: AND xad.event_class_code = xjl.event_class_code
8851: AND xad.event_type_code = xjl.event_type_code
8861: AND xjl.line_definition_code = p_line_definition_code
8862: AND xjl.active_flag = 'Y'
8863: AND xad.segment_rule_code is not null
8864: AND NOT EXISTS (SELECT 'x'
8865: FROM xla_line_defn_jlt_assgns xld1
8866: WHERE xld1.application_id = xad.application_id
8867: AND xld1.amb_context_code = xad.amb_context_code
8868: AND xld1.event_class_code = xad.event_class_code
8869: AND xld1.event_type_code = xad.event_type_code
8881:
8882: CURSOR c_adr IS
8883: SELECT distinct xsr.application_id, xsr.amb_context_code,
8884: xsr.segment_rule_type_code, xsr.segment_rule_code
8885: FROM xla_line_defn_jlt_assgns xjl
8886: ,xla_mpa_jlt_adr_assgns xad
8887: ,xla_seg_rules_b xsr
8888: WHERE xsr.application_id = xad.application_id
8889: AND xsr.amb_context_code = xad.amb_context_code
8905: AND xjl.line_definition_owner_code = p_line_definition_owner_code
8906: AND xjl.line_definition_code = p_line_definition_code
8907: AND xjl.active_flag = 'Y'
8908: AND NOT EXISTS (SELECT 'x'
8909: FROM xla_line_defn_jlt_assgns xld1
8910: WHERE xld1.application_id = xad.application_id
8911: AND xld1.amb_context_code = xad.amb_context_code
8912: AND xld1.event_class_code = xad.event_class_code
8913: AND xld1.event_type_code = xad.event_type_code
9051: xco.source_type_code, xco.source_code
9052: FROM xla_conditions xco
9053: ,xla_seg_rule_details xsr
9054: ,xla_mpa_jlt_adr_assgns xad
9055: ,xla_line_defn_jlt_assgns xjl
9056: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
9057: AND xsr.application_id = xad.application_id
9058: AND xsr.amb_context_code = xad.amb_context_code
9059: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9075: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9076: AND xjl.line_definition_code = p_line_definition_code
9077: AND xjl.active_flag = 'Y'
9078: AND NOT EXISTS (SELECT 'x'
9079: FROM xla_line_defn_jlt_assgns xld1
9080: WHERE xld1.application_id = xad.application_id
9081: AND xld1.amb_context_code = xad.amb_context_code
9082: AND xld1.event_class_code = xad.event_class_code
9083: AND xld1.event_type_code = xad.event_type_code
9099: xco.value_source_type_code source_type_code, xco.value_source_code source_code
9100: FROM xla_conditions xco
9101: ,xla_seg_rule_details xsr
9102: ,xla_mpa_jlt_adr_assgns xad
9103: ,xla_line_defn_jlt_assgns xjl
9104: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
9105: AND xsr.application_id = xad.application_id
9106: AND xsr.amb_context_code = xad.amb_context_code
9107: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9123: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9124: AND xjl.line_definition_code = p_line_definition_code
9125: AND xjl.active_flag = 'Y'
9126: AND NOT EXISTS (SELECT 'x'
9127: FROM xla_line_defn_jlt_assgns xld1
9128: WHERE xld1.application_id = xad.application_id
9129: AND xld1.amb_context_code = xad.amb_context_code
9130: AND xld1.event_class_code = xad.event_class_code
9131: AND xld1.event_type_code = xad.event_type_code
9148: xco.source_type_code source_type_code, xco.source_code source_code
9149: FROM xla_conditions xco
9150: ,xla_seg_rule_details xsr
9151: ,xla_mpa_jlt_adr_assgns xad
9152: ,xla_line_defn_jlt_assgns xjl
9153: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
9154: AND xsr.application_id = xad.application_id
9155: AND xsr.amb_context_code = xad.amb_context_code
9156: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9172: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9173: AND xjl.line_definition_code = p_line_definition_code
9174: AND xjl.active_flag = 'Y'
9175: AND NOT EXISTS (SELECT 'x'
9176: FROM xla_line_defn_jlt_assgns xld1
9177: WHERE xld1.application_id = xad.application_id
9178: AND xld1.amb_context_code = xad.amb_context_code
9179: AND xld1.event_class_code = xad.event_class_code
9180: AND xld1.event_type_code = xad.event_type_code
9187: xco.value_source_type_code source_type_code, xco.value_source_code source_code
9188: FROM xla_conditions xco
9189: ,xla_seg_rule_details xsr
9190: ,xla_mpa_jlt_adr_assgns xad
9191: ,xla_line_defn_jlt_assgns xjl
9192: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
9193: AND xsr.application_id = xad.application_id
9194: AND xsr.amb_context_code = xad.amb_context_code
9195: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9211: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9212: AND xjl.line_definition_code = p_line_definition_code
9213: AND xjl.active_flag = 'Y'
9214: AND NOT EXISTS (SELECT 'x'
9215: FROM xla_line_defn_jlt_assgns xld1
9216: WHERE xld1.application_id = xad.application_id
9217: AND xld1.amb_context_code = xad.amb_context_code
9218: AND xld1.event_class_code = xad.event_class_code
9219: AND xld1.event_type_code = xad.event_type_code
9224:
9225: CURSOR c_child_adr IS
9226: SELECT distinct xsr.value_segment_rule_appl_id,
9227: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
9228: FROM xla_line_defn_jlt_assgns xjl
9229: ,xla_mpa_jlt_adr_assgns xad
9230: ,xla_seg_rule_details xsr
9231: WHERE xsr.application_id = xad.application_id
9232: AND xsr.amb_context_code = xad.amb_context_code
9249: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9250: AND xjl.line_definition_code = p_line_definition_code
9251: AND xjl.active_flag = 'Y'
9252: AND NOT EXISTS (SELECT 'x'
9253: FROM xla_line_defn_jlt_assgns xld1
9254: WHERE xld1.application_id = xad.application_id
9255: AND xld1.amb_context_code = xad.amb_context_code
9256: AND xld1.event_class_code = xad.event_class_code
9257: AND xld1.event_type_code = xad.event_type_code
9512: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9513: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
9514: FROM xla_seg_rule_details xsr
9515: ,xla_mpa_jlt_adr_assgns xad
9516: ,xla_line_defn_jlt_assgns xjl
9517: WHERE xsr.application_id = xad.application_id
9518: AND xsr.amb_context_code = xad.amb_context_code
9519: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9520: AND xsr.segment_rule_code = xad.segment_rule_code
9535: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9536: AND xjl.line_definition_code = p_line_definition_code
9537: AND xjl.active_flag = 'Y'
9538: AND NOT EXISTS (SELECT 'x'
9539: FROM xla_line_defn_jlt_assgns xld1
9540: WHERE xld1.application_id = xad.application_id
9541: AND xld1.amb_context_code = xad.amb_context_code
9542: AND xld1.event_class_code = xad.event_class_code
9543: AND xld1.event_type_code = xad.event_type_code
9558: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9559: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
9560: FROM xla_seg_rule_details xsr
9561: ,xla_mpa_jlt_adr_assgns xad
9562: ,xla_line_defn_jlt_assgns xjl
9563: WHERE xsr.application_id = xad.application_id
9564: AND xsr.amb_context_code = xad.amb_context_code
9565: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9566: AND xsr.segment_rule_code = xad.segment_rule_code
9581: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9582: AND xjl.line_definition_code = p_line_definition_code
9583: AND xjl.active_flag = 'Y'
9584: AND NOT EXISTS (SELECT 'x'
9585: FROM xla_line_defn_jlt_assgns xld1
9586: WHERE xld1.application_id = xad.application_id
9587: AND xld1.amb_context_code = xad.amb_context_code
9588: AND xld1.event_class_code = xad.event_class_code
9589: AND xld1.event_type_code = xad.event_type_code
9605: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9606: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
9607: FROM xla_seg_rule_details xsr
9608: ,xla_mpa_jlt_adr_assgns xad
9609: ,xla_line_defn_jlt_assgns xjl
9610: WHERE xsr.application_id = xad.application_id
9611: AND xsr.amb_context_code = xad.amb_context_code
9612: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9613: AND xsr.segment_rule_code = xad.segment_rule_code
9626: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9627: AND xjl.line_definition_code = p_line_definition_code
9628: AND xjl.active_flag = 'Y'
9629: AND NOT EXISTS (SELECT 'x'
9630: FROM xla_line_defn_jlt_assgns xld1
9631: WHERE xld1.application_id = xad.application_id
9632: AND xld1.amb_context_code = xad.amb_context_code
9633: AND xld1.event_class_code = xad.event_class_code
9634: AND xld1.event_type_code = xad.event_type_code
9640: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9641: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
9642: FROM xla_seg_rule_details xsr
9643: ,xla_mpa_jlt_adr_assgns xad
9644: ,xla_line_defn_jlt_assgns xjl
9645: WHERE xsr.application_id = xad.application_id
9646: AND xsr.amb_context_code = xad.amb_context_code
9647: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9648: AND xsr.segment_rule_code = xad.segment_rule_code
9661: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9662: AND xjl.line_definition_code = p_line_definition_code
9663: AND xjl.active_flag = 'Y'
9664: AND NOT EXISTS (SELECT 'x'
9665: FROM xla_line_defn_jlt_assgns xld1
9666: WHERE xld1.application_id = xad.application_id
9667: AND xld1.amb_context_code = xad.amb_context_code
9668: AND xld1.event_class_code = xad.event_class_code
9669: AND xld1.event_type_code = xad.event_type_code
9675:
9676: CURSOR c_child_adr IS
9677: SELECT distinct xsr.value_segment_rule_appl_id,
9678: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
9679: FROM xla_line_defn_jlt_assgns xjl
9680: ,xla_mpa_jlt_adr_assgns xad
9681: ,xla_seg_rule_details xsr
9682: WHERE xsr.application_id = xad.application_id
9683: AND xsr.amb_context_code = xad.amb_context_code
9700: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9701: AND xjl.line_definition_code = p_line_definition_code
9702: AND xjl.active_flag = 'Y'
9703: AND NOT EXISTS (SELECT 'x'
9704: FROM xla_line_defn_jlt_assgns xld1
9705: WHERE xld1.application_id = xad.application_id
9706: AND xld1.amb_context_code = xad.amb_context_code
9707: AND xld1.event_class_code = xad.event_class_code
9708: AND xld1.event_type_code = xad.event_type_code
9957: SELECT distinct xad.segment_rule_appl_id, xad.segment_rule_type_code,
9958: xad.segment_rule_code,
9959: xsr.value_segment_rule_appl_id,
9960: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
9961: FROM xla_line_defn_jlt_assgns xjl
9962: ,xla_mpa_jlt_adr_assgns xad
9963: ,xla_seg_rule_details xsr
9964: WHERE xsr.application_id = xad.application_id
9965: AND xsr.amb_context_code = xad.amb_context_code
9982: AND xjl.line_definition_owner_code = p_line_definition_owner_code
9983: AND xjl.line_definition_code = p_line_definition_code
9984: AND xjl.active_flag = 'Y'
9985: AND NOT EXISTS (SELECT 'x'
9986: FROM xla_line_defn_jlt_assgns xld1
9987: WHERE xld1.application_id = xad.application_id
9988: AND xld1.amb_context_code = xad.amb_context_code
9989: AND xld1.event_class_code = xad.event_class_code
9990: AND xld1.event_type_code = xad.event_type_code
10213: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
10214: xsr.value_mapping_set_code
10215: FROM xla_seg_rule_details xsr
10216: ,xla_mpa_jlt_adr_assgns xad
10217: ,xla_line_defn_jlt_assgns xjl
10218: ,xla_mapping_sets_b xms
10219: WHERE xms.mapping_set_code = xsr.value_mapping_set_code
10220: AND xms.amb_context_code = xsr.amb_context_code
10221: AND xms.enabled_flag <> 'Y'
10239: AND xjl.line_definition_owner_code = p_line_definition_owner_code
10240: AND xjl.line_definition_code = p_line_definition_code
10241: AND xjl.active_flag = 'Y'
10242: AND NOT EXISTS (SELECT 'x'
10243: FROM xla_line_defn_jlt_assgns xld1
10244: WHERE xld1.application_id = xad.application_id
10245: AND xld1.amb_context_code = xad.amb_context_code
10246: AND xld1.event_class_code = xad.event_class_code
10247: AND xld1.event_type_code = xad.event_type_code
10506: RETURN BOOLEAN
10507: IS
10508: CURSOR c_invalid_hdr_desc IS
10509: SELECT distinct xdb.description_type_code, xdb.description_code
10510: FROM xla_line_defn_jlt_assgns xjl
10511: ,xla_descriptions_b xdb
10512: WHERE xjl.application_id = p_application_id
10513: AND xjl.amb_context_code = p_amb_context_code
10514: AND xjl.event_class_code = p_event_class_code
10604: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10605: xdd.source_type_code, xdd.source_code
10606: FROM xla_descript_details_b xdd
10607: ,xla_desc_priorities xdp
10608: ,xla_line_defn_jlt_assgns xjl
10609: WHERE xdd.description_prio_id = xdp.description_prio_id
10610: AND xdp.application_id = xjl.application_id
10611: AND xdp.amb_context_code = xjl.amb_context_code
10612: AND xdp.description_type_code = xjl.mpa_header_desc_type_code
10633: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10634: xdd.source_type_code, xdd.source_code
10635: FROM xla_descript_details_b xdd
10636: ,xla_desc_priorities xdp
10637: ,xla_line_defn_jlt_assgns xjl
10638: WHERE xdd.description_prio_id = xdp.description_prio_id
10639: AND xdp.application_id = xjl.application_id
10640: AND xdp.amb_context_code = xjl.amb_context_code
10641: AND xdp.description_type_code = xjl.mpa_header_desc_type_code
10762: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10763: xco.source_type_code source_type_code, xco.source_code source_code
10764: FROM xla_conditions xco
10765: ,xla_desc_priorities xdp
10766: ,xla_line_defn_jlt_assgns xjl
10767: WHERE xco.description_prio_id = xdp.description_prio_id
10768: AND xdp.application_id = xjl.application_id
10769: AND xdp.amb_context_code = xjl.amb_context_code
10770: AND xdp.description_type_code = xjl.mpa_header_desc_type_code
10790: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10791: xco.value_source_type_code source_type_code, xco.value_source_code source_code
10792: FROM xla_conditions xco
10793: ,xla_desc_priorities xdp
10794: ,xla_line_defn_jlt_assgns xjl
10795: WHERE xco.description_prio_id = xdp.description_prio_id
10796: AND xdp.application_id = xjl.application_id
10797: AND xdp.amb_context_code = xjl.amb_context_code
10798: AND xdp.description_type_code = xjl.mpa_header_desc_type_code
10819: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10820: xco.source_type_code source_type_code, xco.source_code source_code
10821: FROM xla_conditions xco
10822: ,xla_desc_priorities xdp
10823: ,xla_line_defn_jlt_assgns xjl
10824: WHERE xco.description_prio_id = xdp.description_prio_id
10825: AND xdp.application_id = xjl.application_id
10826: AND xdp.amb_context_code = xjl.amb_context_code
10827: AND xdp.description_type_code = xjl.mpa_header_desc_type_code
10838: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10839: xco.value_source_type_code source_type_code, xco.value_source_code source_code
10840: FROM xla_conditions xco
10841: ,xla_desc_priorities xdp
10842: ,xla_line_defn_jlt_assgns xjl
10843: WHERE xco.description_prio_id = xdp.description_prio_id
10844: AND xdp.application_id = xjl.application_id
10845: AND xdp.amb_context_code = xjl.amb_context_code
10846: AND xdp.description_type_code = xjl.mpa_header_desc_type_code
10964: IS
10965: CURSOR c_invalid_line_ac IS
10966: SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
10967: FROM xla_mpa_header_ac_assgns xac
10968: ,xla_line_defn_jlt_assgns xjl
10969: ,xla_analytical_hdrs_b xah
10970: WHERE xah.amb_context_code = xac.amb_context_code
10971: AND xah.analytical_criterion_code = xac.analytical_criterion_code
10972: AND xah.analytical_criterion_type_code = xac.analytical_criterion_type_code
11066: IS
11067: CURSOR c_invalid_line_ac IS
11068: SELECT distinct xah.analytical_criterion_type_code, xah.analytical_criterion_code
11069: FROM xla_mpa_header_ac_assgns xac
11070: ,xla_line_defn_jlt_assgns xjl
11071: ,xla_analytical_hdrs_b xah
11072: WHERE xah.amb_context_code = xac.amb_context_code
11073: AND xah.analytical_criterion_code = xac.analytical_criterion_code
11074: AND xah.analytical_criterion_type_code = xac.analytical_criterion_type_code
11168: IS
11169: CURSOR c_invalid_ac IS
11170: SELECT distinct xac.analytical_criterion_type_code, xac.analytical_criterion_code
11171: FROM xla_mpa_header_ac_assgns xac
11172: ,xla_line_defn_jlt_assgns xjl
11173: WHERE xac.application_id = xjl.application_id
11174: AND xac.amb_context_code = xjl.amb_context_code
11175: AND xac.event_class_code = xjl.event_class_code
11176: AND xac.event_type_code = xjl.event_type_code
11275: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
11276: xas.source_code, xas.source_type_code
11277: FROM xla_analytical_sources xas
11278: ,xla_mpa_header_ac_assgns xac
11279: ,xla_line_defn_jlt_assgns xjl
11280: ,xla_event_sources xes
11281: WHERE xas.application_id = xac.application_id
11282: AND xas.amb_context_code = xac.amb_context_code
11283: AND xas.event_class_code = xac.event_class_code
11312: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
11313: xas.source_code, xas.source_type_code
11314: FROM xla_analytical_sources xas
11315: ,xla_mpa_header_ac_assgns xac
11316: ,xla_line_defn_jlt_assgns xjl
11317: WHERE xas.application_id = xac.application_id
11318: AND xas.amb_context_code = xac.amb_context_code
11319: AND xas.event_class_code = xac.event_class_code
11320: AND xas.analytical_criterion_code = xac.analytical_criterion_code
11620: AND line_definition_owner_code = p_line_definition_owner_code
11621: AND line_definition_code = p_line_definition_code;
11622:
11623: DELETE
11624: FROM xla_line_defn_jlt_assgns
11625: WHERE application_id = p_application_id
11626: AND amb_context_code = p_amb_context_code
11627: AND event_class_code = p_event_class_code
11628: AND event_type_code = p_event_type_code
11852: ,p_module => l_log_module
11853: ,p_level => C_LEVEL_PROCEDURE);
11854: END IF;
11855:
11856: INSERT INTO xla_line_defn_jlt_assgns
11857: (application_id
11858: ,amb_context_code
11859: ,event_class_code
11860: ,event_type_code
11900: ,l_created_by
11901: ,l_last_update_date
11902: ,l_last_updated_by
11903: ,l_last_update_login
11904: FROM xla_line_defn_jlt_assgns
11905: WHERE application_id = p_application_id
11906: AND amb_context_code = p_amb_context_code
11907: AND event_class_code = p_event_class_code
11908: AND event_type_code = p_event_type_code
14041:
14042: CURSOR c_child_adr IS
14043: SELECT distinct xsr.value_segment_rule_appl_id,
14044: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
14045: FROM xla_line_defn_jlt_assgns xjl
14046: ,xla_line_defn_adr_assgns xad
14047: ,xla_seg_rule_details xsr
14048: WHERE xsr.application_id = xad.application_id
14049: AND xsr.amb_context_code = xad.amb_context_code