The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 02-JUL-2003 K.Boussema Updated error messages |
| 17-JUL-2003 K.Boussema Reviewed the code |
| 27-SEP-2003 K.Boussema Changed the event_class clauses using '_ALL' |
| 23-FEB-2004 K.Boussema Made changes for the FND_LOG. |
| 22-MAR-2004 K.Boussema Added a parameter p_module to the TRACE calls|
| and the procedure. |
| 11-MAY-2004 K.Boussema Removed the call to XLA trace routine from |
| trace() procedure |
| 24-MAY-2005 Ashish Removed call to ax_exceptions_pkg and |
| replaced it with xla_exception_pkg. See |
| bug 4382783 |
+===========================================================================*/
--+==========================================================================+
--| |
--| Private global constant or variable declarations |
--| |
--+==========================================================================+
--
--
g_product_rule_name VARCHAR2(80);
SELECT xdb.rowid
FROM xla_aad_line_defn_assgns xal
, xla_line_defn_jlt_assgns xld
, xla_descriptions_b xdb
, xla_descriptions_tl xdt
WHERE xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.product_rule_code = p_product_rule_code
AND xal.product_rule_type_code = p_product_rule_type_code
AND xld.application_id = xal.application_id
AND xld.amb_context_code = xal.amb_context_code
AND xld.event_class_code = xal.event_class_code
AND xld.event_type_code = xal.event_type_code
AND xld.line_definition_code = xal.line_definition_code
AND xld.line_definition_owner_code = xal.line_definition_owner_code
AND xdb.application_id = xld.application_id
AND xdb.amb_context_code = xld.amb_context_code
AND xdb.description_code = xld.description_code
AND xdb.description_type_code = xld.description_type_code
AND xdt.application_id = xdb.application_id
AND xdt.amb_context_code = xdb.amb_context_code
AND xdt.description_code = xdb.description_code
AND xdt.description_type_code = xdb.description_type_code
AND xdt.language = USERENV('LANG')
FOR UPDATE NOWAIT
;
SELECT xdp.rowid
FROM xla_aad_line_defn_assgns xal
, xla_line_defn_jlt_assgns xld
, xla_desc_priorities xdp
, xla_conditions xco
WHERE xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.product_rule_code = p_product_rule_code
AND xal.product_rule_type_code = p_product_rule_type_code
AND xld.application_id = xal.application_id
AND xld.amb_context_code = xal.amb_context_code
AND xld.event_class_code = xal.event_class_code
AND xld.event_type_code = xal.event_type_code
AND xld.line_definition_code = xal.line_definition_code
AND xld.line_definition_owner_code = xal.line_definition_owner_code
AND xdp.application_id = xld.application_id
AND xdp.amb_context_code = xld.amb_context_code
AND xdp.description_code = xld.description_code
AND xdp.description_type_code = xld.description_type_code
AND xco.description_prio_id = xdp.description_prio_id
FOR UPDATE NOWAIT
;
SELECT xdd.rowid
FROM xla_aad_line_defn_assgns xal
, xla_line_defn_jlt_assgns xld
, xla_desc_priorities xdp
, xla_descript_details_b xdd
, xla_descript_details_tl xdt
WHERE xal.application_id = p_application_id
AND xal.amb_context_code = p_amb_context_code
AND xal.product_rule_code = p_product_rule_code
AND xal.product_rule_type_code = p_product_rule_type_code
AND xld.application_id = xal.application_id
AND xld.amb_context_code = xal.amb_context_code
AND xld.event_class_code = xal.event_class_code
AND xld.event_type_code = xal.event_type_code
AND xld.line_definition_code = xal.line_definition_code
AND xld.line_definition_owner_code = xal.line_definition_owner_code
AND xdp.application_id = xld.application_id
AND xdp.amb_context_code = xld.amb_context_code
AND xdp.description_code = xld.description_code
AND xdp.description_type_code = xld.description_type_code
AND xdd.description_prio_id = xdp.description_prio_id
AND xdt.description_detail_id = xdd.description_detail_id
FOR UPDATE NOWAIT
;
SELECT xdb.rowid
FROM xla_prod_acct_headers xpah
, xla_descriptions_b xdb
, xla_descriptions_tl xdt
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xdb.application_id = xpah.application_id
AND xdb.amb_context_code = xpah.amb_context_code
AND xdb.description_code = xpah.description_code
AND xdb.description_type_code = xpah.description_type_code
AND xdt.application_id = xdb.application_id
AND xdt.amb_context_code = xdb.amb_context_code
AND xdt.description_code = xdb.description_code
AND xdt.description_type_code = xdb.description_type_code
AND xdt.language = USERENV('LANG')
FOR UPDATE NOWAIT
;
SELECT xdp.rowid
FROM xla_prod_acct_headers xpah
, xla_desc_priorities xdp
, xla_conditions xco
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xdp.application_id = xpah.application_id
AND xdp.amb_context_code = xpah.amb_context_code
AND xdp.description_code = xpah.description_code
AND xdp.description_type_code = xpah.description_type_code
AND xco.description_prio_id = xdp.description_prio_id
FOR UPDATE NOWAIT
;
SELECT xdd.rowid
FROM xla_prod_acct_headers xpah
, xla_desc_priorities xdp
, xla_descript_details_b xdd
, xla_descript_details_tl xdt
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xdp.application_id = xpah.application_id
AND xdp.amb_context_code = xpah.amb_context_code
AND xdp.description_code = xpah.description_code
AND xdp.description_type_code = xpah.description_type_code
AND xdd.description_prio_id = xdp.description_prio_id
AND xdt.description_detail_id = xdd.description_detail_id
FOR UPDATE NOWAIT
;
SELECT xes.rowid
FROM xla_prod_acct_headers xpah
, xla_event_sources xes
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xpah.event_class_code <> xpah.entity_code || '_ALL'
AND xes.application_id = xpah.application_id
AND xes.entity_code = xpah.entity_code
AND (
xes.event_class_code = xpah.event_class_code
OR
xes.event_class_code = xes.entity_code ||'_ALL'
)
FOR UPDATE NOWAIT
;
SELECT xeo.rowid
FROM xla_prod_acct_headers xpah
, xla_extract_objects xeo
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xpah.event_class_code <> xpah.entity_code || '_ALL'
AND xeo.application_id = xpah.application_id
AND xeo.entity_code = xpah.entity_code
AND (xeo.event_class_code = xpah.event_class_code
OR
xeo.event_class_code = xeo.entity_code ||'_ALL'
)
FOR UPDATE NOWAIT
;
SELECT xett.rowid
FROM xla_prod_acct_headers xpah
, xla_event_types_b xetb
, xla_event_types_tl xett
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xpah.event_class_code <> xpah.entity_code || '_ALL'
AND xetb.application_id = xpah.application_id
AND xetb.entity_code = xpah.entity_code
AND xetb.event_class_code = xpah.event_class_code
AND xetb.event_type_code = xpah.event_type_code
AND xetb.application_id = xett.application_id
AND xetb.entity_code = xett.entity_code
AND xetb.event_class_code = xett.event_class_code
AND xetb.event_type_code = xett.event_type_code
AND xett.language = USERENV('LANG')
FOR UPDATE NOWAIT
;
SELECT xecgt.rowid
FROM xla_prod_acct_headers xpah
, xla_event_class_attrs xeca
, xla_event_class_grps_b xecgb
, xla_event_class_grps_tl xecgt
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xpah.event_class_code <> xpah.entity_code || '_ALL'
AND xeca.application_id = xpah.application_id
AND xeca.entity_code = xpah.entity_code
AND xeca.event_class_code = xpah.event_class_code
AND xeca.application_id = xecgb.application_id
AND xeca.event_class_group_code = xecgb.event_class_group_code
AND xeca.application_id = xecgt.application_id
AND xeca.event_class_group_code = xecgt.event_class_group_code
AND xecgt.language = USERENV('LANG')
AND xeca.event_class_group_code IS NOT NULL
FOR UPDATE NOWAIT
;
SELECT xect.rowid
FROM xla_prod_acct_headers xpah
, xla_event_classes_b xecb
, xla_event_classes_tl xect
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xpah.event_class_code <> xpah.entity_code || '_ALL'
AND xecb.application_id = xpah.application_id
AND xecb.entity_code = xpah.entity_code
AND xecb.event_class_code = xpah.event_class_code
AND xect.application_id = xecb.application_id
AND xect.entity_code = xecb.entity_code
AND xect.event_class_code = xecb.event_class_code
AND xect.language = USERENV('LANG')
FOR UPDATE NOWAIT
;
SELECT xsrd.rowid
FROM xla_aad_line_defn_assgns xald
, xla_line_defn_adr_assgns xlda
, xla_seg_rule_details xsrd
, xla_seg_rules_b xsrb
, xla_seg_rules_tl xsrt
, xla_conditions xco
WHERE xald.application_id = p_application_id
AND xald.amb_context_code = p_amb_context_code
AND xald.product_rule_type_code = p_product_rule_type_code
AND xald.product_rule_code = p_product_rule_code
AND xlda.application_id = xald.application_id
AND xlda.amb_context_code = xald.amb_context_code
AND xlda.event_class_code = xald.event_class_code
AND xlda.event_type_code = xald.event_type_code
AND xlda.line_definition_owner_code = xald.line_definition_owner_code
AND xlda.line_definition_code = xald.line_definition_code
AND xsrd.application_id = xlda.application_id
AND xsrd.amb_context_code = xlda.amb_context_code
AND xsrd.segment_rule_code = xlda.segment_rule_code
AND xsrd.segment_rule_type_code = xlda.segment_rule_type_code
AND xsrb.application_id = xlda.application_id
AND xsrb.amb_context_code = xlda.amb_context_code
AND xsrb.segment_rule_code = xlda.segment_rule_code
AND xsrb.segment_rule_type_code = xlda.segment_rule_type_code
AND xsrt.application_id = xlda.application_id
AND xsrt.amb_context_code = xlda.amb_context_code
AND xsrt.segment_rule_code = xlda.segment_rule_code
AND xsrt.segment_rule_type_code = xlda.segment_rule_type_code
AND xsrt.language = USERENV('LANG')
AND xco.segment_rule_detail_id(+) = xsrd.segment_rule_detail_id
FOR UPDATE NOWAIT
;
SELECT xald.rowid
FROM xla_aad_line_defn_assgns xald
, xla_line_defn_jlt_assgns xldj
, xla_line_definitions_b xldb
, xla_line_definitions_tl xldt
, xla_acct_line_types_b xalb
, xla_acct_line_types_tl xalt
, xla_conditions xcon
, xla_prod_acct_headers xpah
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xald.application_id = xpah.application_id
AND xald.amb_context_code = xpah.amb_context_code
AND xald.event_class_code = xpah.event_class_code
AND xald.event_type_code = xpah.event_type_code
AND xald.product_rule_code = xpah.product_rule_code
AND xald.product_rule_type_code = xpah.product_rule_type_code
AND xldj.application_id = xald.application_id
AND xldj.amb_context_code = xald.amb_context_code
AND xldj.event_class_code = xald.event_class_code
AND xldj.event_type_code = xald.event_type_code
AND xldj.line_definition_code = xald.line_definition_code
AND xldj.line_definition_owner_code = xald.line_definition_owner_code
AND xldb.application_id = xldj.application_id
AND xldb.amb_context_code = xldj.amb_context_code
AND xldb.event_class_code = xldj.event_class_code
AND xldb.event_type_code = xldj.event_type_code
AND xldb.line_definition_code = xldj.line_definition_code
AND xldb.line_definition_owner_code = xldj.line_definition_owner_code
AND xldt.application_id = xldb.application_id
AND xldt.amb_context_code = xldb.amb_context_code
AND xldt.event_class_code = xldb.event_class_code
AND xldt.event_type_code = xldb.event_type_code
AND xldt.line_definition_code = xldb.line_definition_code
AND xldt.line_definition_owner_code = xldb.line_definition_owner_code
AND xalb.application_id = xldj.application_id
AND xalb.amb_context_code = xldj.amb_context_code
AND xalb.entity_code = xpah.entity_code
AND xalb.event_class_code = xldj.event_class_code
AND xalb.accounting_line_type_code = xldj.accounting_line_type_code
AND xalb.accounting_line_code = xldj.accounting_line_code
AND xalt.application_id = xalb.application_id
AND xalt.amb_context_code = xalb.amb_context_code
AND xalt.entity_code = xalb.entity_code
AND xalt.event_class_code = xalb.event_class_code
AND xalt.accounting_line_type_code = xalb.accounting_line_type_code
AND xalt.accounting_line_code = xalb.accounting_line_code
AND xcon.application_id(+) = xalb.application_id
AND xcon.amb_context_code(+) = xalb.amb_context_code
AND xcon.entity_code(+) = xalb.entity_code
AND xcon.event_class_code(+) = xalb.event_class_code
AND xcon.accounting_line_type_code(+) = xalb.accounting_line_type_code
AND xcon.accounting_line_code(+) = xalb.accounting_line_code
FOR UPDATE NOWAIT
;
SELECT xpah.rowid
FROM xla_prod_acct_headers xpah
, xla_entity_types_b xetb
, xla_entity_types_tl xett
, xla_event_classes_b xecb
, xla_event_classes_tl xect
WHERE xpah.application_id = p_application_id
AND xpah.amb_context_code = p_amb_context_code
AND xpah.product_rule_code = p_product_rule_code
AND xpah.product_rule_type_code = p_product_rule_type_code
AND xetb.entity_code = xpah.entity_code
AND xetb.application_id = xpah.application_id
AND xetb.entity_code = xpah.entity_code
AND xetb.application_id = xett.application_id
AND xetb.entity_code = xett.entity_code
AND xecb.application_id(+) = xpah.application_id
AND xecb.entity_code(+) = xpah.entity_code
AND xecb.event_class_code(+) = xpah.event_class_code
AND xect.application_id(+) = xecb.application_id
AND xect.entity_code(+) = xecb.entity_code
AND xect.event_class_code(+) = xecb.event_class_code
FOR UPDATE NOWAIT
;
SELECT xprb.rowid
, xprt.name
FROM xla_product_rules_b xprb
, xla_product_rules_tl xprt
WHERE xprb.application_id = p_application_id
AND xprb.product_rule_code = p_product_rule_code
AND xprb.product_rule_type_code = p_product_rule_type_code
AND xprb.amb_context_code = p_amb_context_code
AND xprb.application_id = xprt.application_id
AND xprb.product_rule_code = xprt.product_rule_code
AND xprb.product_rule_type_code = xprt.product_rule_type_code
AND xprb.amb_context_code = xprt.amb_context_code
AND xprt.language = USERENV('LANG')
FOR UPDATE NOWAIT
;