eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_ANALYTICAL_CRITERIA_PKG dependencies on XLA_ANALYTICAL_DTL_VALS

Line 221: | Inserts a new record in the table xla_analytical_dtl_vals. |

217: | Private Procedure |
218: | |
219: | Description |
220: | ----------- |
221: | Inserts a new record in the table xla_analytical_dtl_vals. |
222: | |
223: +======================================================================*/
224:
225: l_detail_value_id INTEGER;

Line 241: INSERT INTO xla_analytical_dtl_vals

237: ,p_level => C_LEVEL_PROCEDURE);
238: END IF;
239:
240: IF p_detail_char_id IS NULL THEN
241: INSERT INTO xla_analytical_dtl_vals
242: ( analytical_detail_value_id
243: ,analytical_criterion_code
244: ,analytical_criterion_type_code
245: ,amb_context_code

Line 268: ( xla_analytical_dtl_vals_s.nextval

264: ,last_updated_by
265: ,last_update_login
266: )
267: VALUES
268: ( xla_analytical_dtl_vals_s.nextval
269: ,p_anacri_code
270: ,p_anacri_type_code
271: ,p_amb_context_code
272: ,p_detail_char_1

Line 300: ' row(s) inserted into xla_analytical_dtl_vals '

296: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
297: trace
298: ( p_module => l_log_module
299: ,p_msg => SQL%ROWCOUNT ||
300: ' row(s) inserted into xla_analytical_dtl_vals '
301: ,p_level => C_LEVEL_STATEMENT);
302: END IF;
303:
304: ELSE

Line 307: INSERT INTO xla_analytical_dtl_vals

303:
304: ELSE
305: l_detail_value_id := p_detail_char_id;
306:
307: INSERT INTO xla_analytical_dtl_vals
308: ( analytical_detail_value_id
309: ,analytical_criterion_code
310: ,analytical_criterion_type_code
311: ,amb_context_code

Line 364: || ' row(s) inserted into xla_analytical_dtl_vals '

360: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
361: trace
362: ( p_module => l_log_module
363: ,p_msg => SQL%ROWCOUNT
364: || ' row(s) inserted into xla_analytical_dtl_vals '
365: ,p_level => C_LEVEL_STATEMENT);
366: END IF;
367: END IF;
368:

Line 403: | INDEX ON XLA_ANALYTICAL_DTL_VALS. |

399: | It returns the first nonnull among the given params, formatted to |
400: | VARCHAR2 |
401: | |
402: | MUST BE KEPT IN SYNCH WITH THE FUNCTION USED IN THE FUNCTION-BASED |
403: | INDEX ON XLA_ANALYTICAL_DTL_VALS. |
404: +======================================================================*/
405: l_log_module VARCHAR2 (2000);
406: BEGIN
407: IF g_log_enabled THEN

Line 467: | Wrapper for accessing the table xla_analytical_dtl_vals. |

463: | Private Function |
464: | |
465: | Description |
466: | ----------- |
467: | Wrapper for accessing the table xla_analytical_dtl_vals. |
468: | |
469: | Returns the detail_value_id of the analytical detail value if it |
470: | exists, or inserts a new record. |
471: | |

Line 495: FROM xla_analytical_dtl_vals

491:
492: BEGIN
493: SELECT analytical_detail_value_id
494: INTO l_detail_value_id
495: FROM xla_analytical_dtl_vals
496: WHERE analytical_criterion_code = p_anacri_code
497: AND analytical_criterion_type_code = p_anacri_type_code
498: AND amb_context_code = p_amb_context_code
499: --Detail 1

Line 630: || ' row(s) selected from xla_analytical_dtl_vals '

626: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
627: trace
628: ( p_module => l_log_module
629: ,p_msg => SQL%ROWCOUNT
630: || ' row(s) selected from xla_analytical_dtl_vals '
631: ,p_level => C_LEVEL_STATEMENT);
632: END IF;
633:
634: EXCEPTION

Line 1784: ,xla_analytical_dtl_vals xadv

1780: AND 0 =
1781: (
1782: SELECT count(xald.ae_line_num)
1783: FROM xla_ae_line_details xald
1784: ,xla_analytical_dtl_vals xadv
1785: ,xla_analytical_hdrs_b xahb
1786: WHERE xald.ae_header_id = p_ae_header_id
1787: AND xald.ae_line_num = p_ae_line_num
1788: AND xadv.analytical_detail_value_id = xald.analytical_detail_value_id

Line 2667: | No need to maintain xla_analytical_dtl_vals

2663: /*======================================================================+
2664: | |
2665: | Public Function |
2666: | Obsolete in R12+ Supporting References Re-Architecture |
2667: | No need to maintain xla_analytical_dtl_vals
2668: | From AeLineAcEOImpl.java, call update_balances. |
2669: | |
2670: | Description |
2671: | ----------- |

Line 4172: FROM xla_analytical_dtl_vals xadv

4168:
4169: --check if there is at least one detail value for the criterion
4170: SELECT count(*)
4171: INTO l_count_exist_dvals
4172: FROM xla_analytical_dtl_vals xadv
4173: WHERE xadv.analytical_criterion_code = p_anacri_code
4174: AND xadv.analytical_criterion_type_code = p_anacri_type_code
4175: AND xadv.amb_context_code = p_amb_context_code
4176: AND ROWNUM = 1;

Line 4483: ,xla_analytical_dtl_vals xadv';

4479: ' ,MAX(DECODE( 1, 2, xadv.))';
4480:
4481: l_ln_fixed_part_footer_1 VARCHAR2(256) :=
4482: 'FROM xla_ae_line_details xald
4483: ,xla_analytical_dtl_vals xadv';
4484:
4485: l_hdr_fixed_part_footer_1 VARCHAR2(256) :=
4486: 'FROM xla_ae_header_details xahd
4487: ,xla_analytical_dtl_vals xadv';

Line 4487: ,xla_analytical_dtl_vals xadv';

4483: ,xla_analytical_dtl_vals xadv';
4484:
4485: l_hdr_fixed_part_footer_1 VARCHAR2(256) :=
4486: 'FROM xla_ae_header_details xahd
4487: ,xla_analytical_dtl_vals xadv';
4488:
4489:
4490: l_hdr_fixed_part_footer_2 VARCHAR2(256) :=
4491: 'WHERE xadv.analytical_detail_value_id = xahd.analytical_detail_value_id