[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| update according to the new datamodel |
| 22-APR-2003 K.Boussema Included Error messages |
| 02-JUN-2003 K.Boussema Modified to fix bug 2975670 and bug 2729143 |
| 17-JUL-2003 K.Boussema Reviewed the code |
| 27-SEP-2003 K.Boussema Changed the event_class clauses using '_ALL' |
| 10-OCT-2003 K.Boussema Added an Outer join to query Anlytical |
| criteria information, bug 3187719 |
| 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 |
| 20-Sep-2004 S.Singhania Made ffg chagnes for the bulk changes: |
| - Modified constant C_AC_HDR_CALL |
| - Minor change to GenerateHdrAnalyticCriteria|
| 07-Mar-2005 K.Boussema Changed for ADR-enhancements. |
| 11-Jul-2005 A.Wan Changed for MPA Bug 4262811 |
+===========================================================================*/
--
--+==========================================================================+
--| |
--| |
--| Global Constants/variables |
--| |
--| |
--+==========================================================================+
--
--
-- Analytical criteria defined in header
--
C_AC_HDR_CALL CONSTANT VARCHAR2(10000):= '
xla_ae_header_pkg.g_rec_header_new.array_anc_id_$number$(hdr_idx) :=
xla_ae_header_pkg.SetAnalyticalCriteria(
p_analytical_criterion_name => ''$analytical_criterion_name$''
, p_analytical_criterion_owner => ''$analytical_criterion_owner$''
, p_analytical_criterion_code => ''$analytical_criterion_code$''
, p_amb_context_code => ''$amb_context_code$''
, p_balancing_flag => ''$balancing_flag$''
$analytical_details$
)
;
SELECT DISTINCT
xas.source_application_id
, xas.source_type_code
, xas.source_code
FROM xla_analytical_sources xas
, xla_aad_header_ac_assgns xah
, xla_analytical_hdrs_b xahb
WHERE xas.analytical_criterion_code = xah.analytical_criterion_code
AND xas.analytical_criterion_type_code = xah.analytical_criterion_type_code
AND xas.amb_context_code = xah.amb_context_code
AND xas.analytical_criterion_code = xahb.analytical_criterion_code
AND xas.analytical_criterion_type_code = xahb.analytical_criterion_type_code
AND xas.amb_context_code = xahb.amb_context_code
AND xas.application_id = p_application_id
AND xas.entity_code = p_entity
AND xas.amb_context_code = p_amb_context_code
AND (
xas.event_class_code = xah.event_class_code
OR
xas.event_class_code = xas.entity_code ||'_ALL'
)
AND xah.event_class_code = p_event_class
AND xah.event_type_code = p_event_type
AND xas.source_application_id IS NOT NULL
AND xas.source_code IS NOT NULL
AND xas.source_type_code IS NOT NULL
AND xahb.enabled_flag = 'Y'
AND xah.product_rule_code = p_product_rule_code
AND xah.product_rule_type_code = p_product_rule_type_code
ORDER BY xas.source_type_code, xas.source_code
;
SELECT xas.source_code
, xas.source_type_code
, xas.source_application_id
, xadb.grouping_order
, xadb.data_type_code
, xadb.analytical_detail_code
FROM xla_analytical_dtls_b xadb
, xla_analytical_sources xas
WHERE xadb.analytical_detail_code = xas.analytical_detail_code
AND xadb.analytical_criterion_code = xas.analytical_criterion_code
AND xadb.amb_context_code = xas.amb_context_code
AND xadb.analytical_criterion_type_code = xas.analytical_criterion_type_code
AND (
xas.event_class_code = p_event_class
OR
xas.event_class_code = xas.entity_code ||'_ALL'
)
AND xas.application_id = p_application_id
AND xas.entity_code = p_entity
AND xas.analytical_criterion_code = p_analytical_criterion_code
AND xas.analytical_criterion_type_code = p_analytical_criterion_type
AND xas.amb_context_code = p_amb_context_code
AND xadb.analytical_detail_code IS NOT NULL
AND xadb.data_type_code IS NOT NULL
AND xadb.grouping_order IS NOT NULL
ORDER BY xadb.grouping_order
;
SELECT DISTINCT
xah.analytical_criterion_code
, xah.analytical_criterion_type_code
, xahb.balancing_flag
, DECODE(xahb.criterion_value_code,
'MEANING','Y'
,'N')
, xaht.name
FROM xla_aad_header_ac_assgns xah
, xla_analytical_hdrs_b xahb
, xla_analytical_hdrs_tl xaht
WHERE xah.analytical_criterion_code = xahb.analytical_criterion_code
AND xah.analytical_criterion_type_code = xahb.analytical_criterion_type_code
AND xah.amb_context_code = xahb.amb_context_code
AND xah.analytical_criterion_code = xaht.analytical_criterion_code (+)
AND xah.analytical_criterion_type_code = xaht.analytical_criterion_type_code (+)
AND xah.amb_context_code = xaht.amb_context_code (+)
AND xah.application_id = p_application_id
AND xah.product_rule_type_code = p_product_rule_type_code
AND xah.product_rule_code = p_product_rule_code
AND xah.amb_context_code = p_amb_context_code
AND xah.event_class_code = p_event_class
AND xah.event_type_code = p_event_type
AND xahb.enabled_flag = 'Y'
AND xaht.language(+) = USERENV('LANG')
ORDER BY xah.analytical_criterion_type_code, xah.analytical_criterion_code
;
SELECT xas.source_code
, xas.source_type_code
, xas.source_application_id
, xadb.grouping_order
, xadb.data_type_code
, xadb.analytical_detail_code
FROM xla_analytical_dtls_b xadb
, xla_analytical_sources xas
WHERE xadb.analytical_detail_code = xas.analytical_detail_code
AND xadb.analytical_criterion_code = xas.analytical_criterion_code
AND xadb.analytical_criterion_type_code = xas.analytical_criterion_type_code
AND xadb.amb_context_code = xas.amb_context_code
AND (
xas.event_class_code = p_event_class
OR
xas.event_class_code = xas.entity_code ||'_ALL'
)
AND xas.analytical_criterion_code = p_analytical_criterion_code
AND xas.analytical_criterion_type_code = p_analytical_criterion_type
AND xas.amb_context_code = p_amb_context_code
AND xas.application_id = p_application_id
AND xadb.analytical_detail_code IS NOT NULL
AND xadb.data_type_code IS NOT NULL
AND xadb.grouping_order IS NOT NULL
ORDER BY xadb.grouping_order
;
SELECT xmhc.analytical_criterion_code
, xmhc.analytical_criterion_type_code
, xahb.balancing_flag
, DECODE(xahb.criterion_value_code,
'MEANING','Y'
,'N')
, xaht.name
FROM xla_mpa_header_ac_assgns xmhc
, xla_analytical_hdrs_b xahb
, xla_analytical_hdrs_tl xaht
WHERE xahb.analytical_criterion_code = xaht.analytical_criterion_code (+)
AND xahb.analytical_criterion_type_code = xaht.analytical_criterion_type_code(+)
AND xahb.amb_context_code = xaht.amb_context_code (+)
AND xaht.language(+) = USERENV('LANG')
AND xmhc.analytical_criterion_code = xahb.analytical_criterion_code
AND xmhc.analytical_criterion_type_code = xahb.analytical_criterion_type_code
AND xmhc.amb_context_code = xahb.amb_context_code
AND xmhc.application_id = p_application_id
AND xmhc.amb_context_code = p_amb_context_code
AND xmhc.event_class_code = p_event_class
AND xmhc.event_type_code = p_event_type
AND xmhc.line_definition_owner_code = p_line_definition_owner_code
AND xmhc.line_definition_code = p_line_definition_code
AND xmhc.accounting_line_type_code = p_accrual_jlt_owner_code
AND xmhc.accounting_line_code = p_accrual_jlt_code
AND xahb.enabled_flag = 'Y'
ORDER BY xmhc.analytical_criterion_type_code, xmhc.analytical_criterion_code
;
SELECT xmlc.analytical_criterion_code
, xmlc.analytical_criterion_type_code
, xahb.balancing_flag
, DECODE(xahb.criterion_value_code,
'MEANING','Y'
,'N')
, xaht.name
FROM xla_mpa_jlt_ac_assgns xmlc
, xla_analytical_hdrs_b xahb
, xla_analytical_hdrs_tl xaht
WHERE xahb.analytical_criterion_code = xaht.analytical_criterion_code (+)
AND xahb.analytical_criterion_type_code = xaht.analytical_criterion_type_code(+)
AND xahb.amb_context_code = xaht.amb_context_code (+)
AND xaht.language(+) = USERENV('LANG')
AND xmlc.analytical_criterion_code = xahb.analytical_criterion_code
AND xmlc.analytical_criterion_type_code = xahb.analytical_criterion_type_code
AND xmlc.amb_context_code = xahb.amb_context_code
AND xmlc.application_id = p_application_id
AND xmlc.amb_context_code = p_amb_context_code
AND xmlc.event_class_code = p_event_class
AND xmlc.event_type_code = p_event_type
AND xmlc.line_definition_owner_code = p_line_definition_owner_code
AND xmlc.line_definition_code = p_line_definition_code
AND xmlc.accounting_line_type_code = p_accrual_jlt_owner_code
AND xmlc.accounting_line_code = p_accrual_jlt_code
AND xmlc.mpa_accounting_line_type_code = p_mpa_jlt_owner_code
AND xmlc.mpa_accounting_line_code = p_mpa_jlt_code
AND xahb.enabled_flag = 'Y'
ORDER BY xmlc.analytical_criterion_type_code, xmlc.analytical_criterion_code
;
SELECT xlda.analytical_criterion_code
, xlda.analytical_criterion_type_code
, xahb.balancing_flag
, DECODE(xahb.criterion_value_code,
'MEANING','Y'
,'N')
, xaht.name
FROM xla_line_defn_ac_assgns xlda
, xla_analytical_hdrs_b xahb
, xla_analytical_hdrs_tl xaht
WHERE xahb.analytical_criterion_code = xaht.analytical_criterion_code (+)
AND xahb.analytical_criterion_type_code = xaht.analytical_criterion_type_code (+)
AND xahb.amb_context_code = xaht.amb_context_code (+)
AND xaht.language(+) = USERENV('LANG')
AND xlda.analytical_criterion_code = xahb.analytical_criterion_code
AND xlda.analytical_criterion_type_code = xahb.analytical_criterion_type_code
AND xlda.amb_context_code = xahb.amb_context_code
AND xlda.application_id = p_application_id
AND xlda.amb_context_code = p_amb_context_code
AND xlda.event_class_code = p_event_class
AND xlda.event_type_code = p_event_type
AND xlda.line_definition_owner_code = p_line_definition_owner_code
AND xlda.line_definition_code = p_line_definition_code
AND xlda.accounting_line_code = p_accounting_line_code
AND xlda.accounting_line_type_code = p_accounting_line_type_code
AND xahb.enabled_flag = 'Y'
ORDER BY xlda.analytical_criterion_type_code, xlda.analytical_criterion_code
;