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 1674: ,xla_analytical_dtl_vals xadv

1670: AND 0 =
1671: (
1672: SELECT count(xald.ae_line_num)
1673: FROM xla_ae_line_details xald
1674: ,xla_analytical_dtl_vals xadv
1675: ,xla_analytical_hdrs_b xahb
1676: WHERE xald.ae_header_id = p_ae_header_id
1677: AND xald.ae_line_num = p_ae_line_num
1678: AND xadv.analytical_detail_value_id = xald.analytical_detail_value_id

Line 2502: | No need to maintain xla_analytical_dtl_vals

2498: /*======================================================================+
2499: | |
2500: | Public Function |
2501: | Obsolete in R12+ Supporting References Re-Architecture |
2502: | No need to maintain xla_analytical_dtl_vals
2503: | From AeLineAcEOImpl.java, call update_balances. |
2504: | |
2505: | Description |
2506: | ----------- |

Line 4007: FROM xla_analytical_dtl_vals xadv

4003:
4004: --check if there is at least one detail value for the criterion
4005: SELECT count(*)
4006: INTO l_count_exist_dvals
4007: FROM xla_analytical_dtl_vals xadv
4008: WHERE xadv.analytical_criterion_code = p_anacri_code
4009: AND xadv.analytical_criterion_type_code = p_anacri_type_code
4010: AND xadv.amb_context_code = p_amb_context_code
4011: AND ROWNUM = 1;

Line 4318: ,xla_analytical_dtl_vals xadv';

4314: ' ,MAX(DECODE( 1, 2, xadv.))';
4315:
4316: l_ln_fixed_part_footer_1 VARCHAR2(256) :=
4317: 'FROM xla_ae_line_details xald
4318: ,xla_analytical_dtl_vals xadv';
4319:
4320: l_hdr_fixed_part_footer_1 VARCHAR2(256) :=
4321: 'FROM xla_ae_header_details xahd
4322: ,xla_analytical_dtl_vals xadv';

Line 4322: ,xla_analytical_dtl_vals xadv';

4318: ,xla_analytical_dtl_vals xadv';
4319:
4320: l_hdr_fixed_part_footer_1 VARCHAR2(256) :=
4321: 'FROM xla_ae_header_details xahd
4322: ,xla_analytical_dtl_vals xadv';
4323:
4324:
4325: l_hdr_fixed_part_footer_2 VARCHAR2(256) :=
4326: 'WHERE xadv.analytical_detail_value_id = xahd.analytical_detail_value_id