[Home] [Help]
8446: AND mpa.mpa_accounting_line_code = jlt.accounting_line_code
8447: AND jlt.business_method_code <> 'PRIOR_ENTRY'
8448: AND NOT EXISTS
8449: (SELECT 'x'
8450: FROM xla_mpa_jlt_adr_assgns xad
8451: WHERE mpa.application_id = xad.application_id
8452: AND mpa.amb_context_code = xad.amb_context_code
8453: AND mpa.event_class_code = xad.event_class_code
8454: AND mpa.event_type_code = xad.event_type_code
8505: AND mpa.mpa_accounting_line_code = jlt.accounting_line_code
8506: AND jlt.business_method_code <> 'PRIOR_ENTRY'
8507: AND NOT EXISTS
8508: (SELECT 'Y'
8509: FROM xla_mpa_jlt_adr_assgns xad
8510: WHERE mpa.application_id = xad.application_id
8511: AND mpa.amb_context_code = xad.amb_context_code
8512: AND mpa.event_class_code = xad.event_class_code
8513: AND mpa.event_type_code = xad.event_type_code
8520: AND xad.flexfield_segment_code = fif.application_column_name
8521: )
8522: AND NOT EXISTS
8523: (SELECT 'Y'
8524: FROM xla_mpa_jlt_adr_assgns xad
8525: WHERE mpa.application_id = xad.application_id
8526: AND mpa.amb_context_code = xad.amb_context_code
8527: AND mpa.event_class_code = xad.event_class_code
8528: AND mpa.event_type_code = xad.event_type_code
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
8649: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
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
8688: AND xsr.segment_rule_type_code = xad.segment_rule_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
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
8890: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9050: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_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
9098: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_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
9147: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_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
9186: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_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
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
9233: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9511: CURSOR c_invalid_sources IS
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
9557: UNION
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
9604: CURSOR c_der_sources IS
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
9639: UNION
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
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
9684: AND xsr.segment_rule_type_code = 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
9966: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
10212: CURSOR c_invalid_ms IS
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
11647: AND line_definition_owner_code = p_line_definition_owner_code
11648: AND line_definition_code = p_line_definition_code;
11649:
11650: DELETE
11651: FROM xla_mpa_jlt_adr_assgns
11652: WHERE application_id = p_application_id
11653: AND amb_context_code = p_amb_context_code
11654: AND event_class_code = p_event_class_code
11655: AND event_type_code = p_event_type_code
11766: AND accounting_line_type_code = p_accounting_line_type_code
11767: AND accounting_line_code = p_accounting_line_code;
11768:
11769: DELETE
11770: FROM xla_mpa_jlt_adr_assgns
11771: WHERE application_id = p_application_id
11772: AND amb_context_code = p_amb_context_code
11773: AND event_class_code = p_event_class_code
11774: AND event_type_code = p_event_type_code
12089: AND line_definition_owner_code = p_old_line_defn_owner_code
12090: AND line_definition_code = p_old_line_defn_code
12091: AND flexfield_segment_code <> 'ALL';
12092:
12093: INSERT INTO xla_mpa_jlt_adr_assgns
12094: (application_id
12095: ,amb_context_code
12096: ,event_class_code
12097: ,event_type_code
12133: ,l_created_by
12134: ,l_last_update_date
12135: ,l_last_updated_by
12136: ,l_last_update_login
12137: FROM xla_mpa_jlt_adr_assgns
12138: WHERE application_id = p_application_id
12139: AND amb_context_code = p_amb_context_code
12140: AND event_class_code = p_event_class_code
12141: AND event_type_code = p_event_type_code
12168: ,l_created_by
12169: ,l_last_update_date
12170: ,l_last_updated_by
12171: ,l_last_update_login
12172: FROM xla_mpa_jlt_adr_assgns
12173: WHERE application_id = p_application_id
12174: AND amb_context_code = p_amb_context_code
12175: AND event_class_code = p_event_class_code
12176: AND event_type_code = p_event_type_code
12231: AND event_type_code = p_event_type_code
12232: AND line_definition_owner_code = p_old_line_defn_owner_code
12233: AND line_definition_code = p_old_line_defn_code;
12234:
12235: INSERT INTO xla_mpa_jlt_adr_assgns
12236: (application_id
12237: ,amb_context_code
12238: ,event_class_code
12239: ,event_type_code
12275: ,l_created_by
12276: ,l_last_update_date
12277: ,l_last_updated_by
12278: ,l_last_update_login
12279: FROM xla_mpa_jlt_adr_assgns
12280: WHERE application_id = p_application_id
12281: AND amb_context_code = p_amb_context_code
12282: AND event_class_code = p_event_class_code
12283: AND event_type_code = p_event_type_code
13363: AND accounting_line_code = p_old_accounting_line_code;
13364:
13365: If (p_mpa_option_code = 'ACCRUAL') then
13366:
13367: INSERT INTO xla_mpa_jlt_adr_assgns
13368: (application_id
13369: ,amb_context_code
13370: ,event_class_code
13371: ,event_type_code
13407: ,l_created_by
13408: ,l_last_update_date
13409: ,l_last_updated_by
13410: ,l_last_update_login
13411: FROM xla_mpa_jlt_adr_assgns
13412: WHERE application_id = p_application_id
13413: AND amb_context_code = p_amb_context_code
13414: AND event_class_code = p_event_class_code
13415: AND event_type_code = p_event_type_code
14196: ,p_level => C_LEVEL_STATEMENT);
14197: END IF;
14198:
14199: DELETE
14200: FROM xla_mpa_jlt_adr_assgns
14201: WHERE application_id = p_application_id
14202: AND amb_context_code = p_amb_context_code
14203: AND event_class_code = p_event_class_code
14204: AND event_type_code = p_event_type_code