[Home] [Help]
5972:
5973: CURSOR c_mpa_jlt(l_accounting_line_type_code IN VARCHAR2
5974: ,l_accounting_line_code IN VARCHAR2) IS
5975: SELECT count(*)
5976: FROM xla_mpa_jlt_assgns mpa
5977: WHERE mpa.application_id = p_application_id
5978: AND mpa.amb_context_code = p_amb_context_code
5979: AND mpa.event_class_code = p_event_class_code
5980: AND mpa.event_type_code = p_event_type_code
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
6097: AND xld.event_type_code = p_event_type_code
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
6227: AND xal.accounting_line_type_code = mpa.mpa_accounting_line_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
6360: AND xld.event_type_code = p_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
6407: AND xld.event_type_code = p_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
6458: AND xld.event_type_code = p_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
6496: AND xld.event_type_code = p_event_type_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
6665: AND jlt.event_class_code = xja.event_class_code
6666: AND jlt.accounting_line_type_code = xja.accounting_line_type_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
6716: AND jlt.event_class_code = xja.event_class_code
6717: AND jlt.accounting_line_type_code = xja.accounting_line_type_code
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
6880: AND xld.event_type_code = p_event_type_code
7251: RETURN BOOLEAN
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
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
7376: AND xdp.amb_context_code = mjl.amb_context_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
7415: AND xdp.description_type_code = mjl.description_type_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
7454: AND xdp.description_type_code = mjl.description_type_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
7483: AND xdp.description_type_code = mjl.description_type_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
7641: AND xdp.description_type_code = mjl.description_type_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
7680: AND xdp.description_type_code = mjl.description_type_code
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
8424: AND xlj.event_type_code = p_event_type_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
8479: AND fif.enabled_flag = 'Y'
11638: AND line_definition_owner_code = p_line_definition_owner_code
11639: AND line_definition_code = p_line_definition_code;
11640:
11641: DELETE
11642: FROM xla_mpa_jlt_assgns
11643: WHERE application_id = p_application_id
11644: AND amb_context_code = p_amb_context_code
11645: AND event_class_code = p_event_class_code
11646: AND event_type_code = p_event_type_code
11755: AND accounting_line_type_code = p_accounting_line_type_code
11756: AND accounting_line_code = p_accounting_line_code;
11757:
11758: DELETE
11759: FROM xla_mpa_jlt_assgns
11760: WHERE application_id = p_application_id
11761: AND amb_context_code = p_amb_context_code
11762: AND event_class_code = p_event_class_code
11763: AND event_type_code = p_event_type_code
11950: AND event_type_code = p_event_type_code
11951: AND line_definition_owner_code = p_old_line_defn_owner_code
11952: AND line_definition_code = p_old_line_defn_code;
11953:
11954: INSERT INTO xla_mpa_jlt_assgns
11955: (application_id
11956: ,amb_context_code
11957: ,event_class_code
11958: ,event_type_code
11990: ,l_created_by
11991: ,l_last_update_date
11992: ,l_last_updated_by
11993: ,l_last_update_login
11994: FROM xla_mpa_jlt_assgns
11995: WHERE application_id = p_application_id
11996: AND amb_context_code = p_amb_context_code
11997: AND event_class_code = p_event_class_code
11998: AND event_type_code = p_event_type_code