238: l_exist VARCHAR2(1);
239:
240: CURSOR c_desc_detail_sources IS
241: SELECT 'X'
242: FROM xla_descript_details_b d, xla_desc_priorities p
243: WHERE d.description_prio_id = p.description_prio_id
244: AND p.application_id = p_application_id
245: AND p.amb_context_code = p_amb_context_code
246: AND p.description_type_code = p_description_type_code
258: AND s.active_flag = 'Y');
259:
260: CURSOR c_desc_condition_sources IS
261: SELECT 'X'
262: FROM xla_conditions c, xla_desc_priorities d
263: WHERE c.description_prio_id = d.description_prio_id
264: AND d.application_id = p_application_id
265: AND d.amb_context_code = p_amb_context_code
266: AND d.description_type_code = p_description_type_code
277: AND s.event_class_code = p_event_class_code
278: AND s.active_flag = 'Y')
279: UNION
280: SELECT 'X' source_code
281: FROM xla_conditions c, xla_desc_priorities d
282: WHERE c.description_prio_id = d.description_prio_id
283: AND d.application_id = p_application_id
284: AND d.amb_context_code = p_amb_context_code
285: AND d.description_type_code = p_description_type_code
297: AND s.active_flag = 'Y');
298:
299: CURSOR c_desc_detail_der_sources IS
300: SELECT source_type_code, source_code
301: FROM xla_descript_details_b d, xla_desc_priorities p
302: WHERE d.description_prio_id = p.description_prio_id
303: AND p.application_id = p_application_id
304: AND p.amb_context_code = p_amb_context_code
305: AND p.description_type_code = p_description_type_code
308: AND d.source_type_code = 'D';
309:
310: CURSOR c_desc_condition_der_sources IS
311: SELECT source_type_code source_type_code, source_code source_code
312: FROM xla_conditions c, xla_desc_priorities d
313: WHERE c.description_prio_id = d.description_prio_id
314: AND d.application_id = p_application_id
315: AND d.amb_context_code = p_amb_context_code
316: AND d.description_type_code = p_description_type_code
318: AND c.source_code IS NOT NULL
319: AND c.source_type_code = 'D'
320: UNION
321: SELECT value_source_type_code source_type_code, value_source_code source_code
322: FROM xla_conditions c, xla_desc_priorities d
323: WHERE c.description_prio_id = d.description_prio_id
324: AND d.application_id = p_application_id
325: AND d.amb_context_code = p_amb_context_code
326: AND d.description_type_code = p_description_type_code
4802: CURSOR c_invalid_sources IS
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
4830: UNION
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
4859: CURSOR c_der_sources IS
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
4878: UNION
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
5026: CURSOR c_invalid_sources IS
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
5055: CURSOR c_der_sources IS
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
7367: CURSOR c_invalid_sources IS
7368: SELECT distinct xjl.description_type_code, xjl.description_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
7405: UNION
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
7444: CURSOR c_der_sources IS
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
7473: UNION
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
7631: CURSOR c_invalid_sources IS
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
7670: CURSOR c_der_sources IS
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
10603: CURSOR c_invalid_sources IS
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
10632: CURSOR c_der_sources IS
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
10761: CURSOR c_invalid_sources IS
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
10789: UNION
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
10818: CURSOR c_der_sources IS
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
10837: UNION
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