[Home] [Help]
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
789: AND xlj.event_class_code = p_event_class_code
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
917: AND xlj.event_type_code = p_event_type_code
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
949: AND xlj.event_type_code = p_event_type_code
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#'
993: AND fif.id_flex_num = l_coa_id
994: AND fif.enabled_flag = 'Y'
2584: AND xld.line_definition_code = p_line_definition_code
2585: AND xld.active_flag = 'Y'
2586: AND NOT EXISTS
2587: (SELECT 'y'
2588: FROM xla_acct_line_types_b xal
2589: WHERE xal.application_id = xld.application_id
2590: AND xal.amb_context_code = xld.amb_context_code
2591: AND xal.event_class_code = xld.event_class_code
2592: AND xal.accounting_line_type_code = xld.accounting_line_type_code
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
2693: AND xal.accounting_line_type_code = xld.accounting_line_type_code
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
2804: AND xal.accounting_line_type_code = xld.accounting_line_type_code
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
2917: AND xal.accounting_line_type_code = xld.accounting_line_type_code
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
3030: AND xal.accounting_line_type_code = xld.accounting_line_type_code
3145: AND xld.line_definition_code = p_line_definition_code
3146: AND xld.inherit_desc_flag = 'Y'
3147: AND EXISTS
3148: (SELECT 'y'
3149: FROM xla_acct_line_types_b xal
3150: WHERE xal.application_id = xld.application_id
3151: AND xal.amb_context_code = xld.amb_context_code
3152: AND xal.event_class_code = xld.event_class_code
3153: AND xal.accounting_line_type_code = xld.accounting_line_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
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
4225: CURSOR c_business_method(l_accounting_line_type_code VARCHAR2
4226: ,l_accounting_line_code VARCHAR2)
4227: IS
4228: SELECT business_method_code, mpa_option_code
4229: FROM xla_acct_line_types_b
4230: WHERE application_id = p_application_id
4231: AND amb_context_code = p_amb_context_code
4232: AND event_class_code = p_event_class_code
4233: AND accounting_line_type_code = l_accounting_line_type_code
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
6117: AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
6118: AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
6119: AND NOT EXISTS
6120: (SELECT 'y'
6121: FROM xla_acct_line_types_b xal
6122: WHERE xal.application_id = mpa.application_id
6123: AND xal.amb_context_code = mpa.amb_context_code
6124: AND xal.event_class_code = mpa.event_class_code
6125: AND xal.accounting_line_type_code = mpa.mpa_accounting_line_type_code
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
6226: AND xal.event_class_code = mpa.event_class_code
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
6664: AND jlt.amb_context_code = xja.amb_context_code
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
6715: AND jlt.amb_context_code = xja.amb_context_code
6903: CURSOR c_business_method(l_accounting_line_type_code VARCHAR2
6904: ,l_accounting_line_code VARCHAR2)
6905: IS
6906: SELECT business_method_code
6907: FROM xla_acct_line_types_b
6908: WHERE application_id = p_application_id
6909: AND amb_context_code = p_amb_context_code
6910: AND event_class_code = p_event_class_code
6911: AND accounting_line_type_code = l_accounting_line_type_code
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
8422: AND xlj.amb_context_code = p_amb_context_code
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
8422: AND xlj.amb_context_code = p_amb_context_code
8423: AND xlj.event_class_code = p_event_class_code
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
8476: WHERE fif.application_id = 101
8477: AND fif.id_flex_code = 'GL#'
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
8476: WHERE fif.application_id = 101
8477: AND fif.id_flex_code = 'GL#'
8478: AND fif.id_flex_num = l_coa_id