APPS.XLA_ANALYTICAL_CRITERIA_PKG dependencies on XLA_AE_LINE_DETAILS

Line 753: | Inserts a new record in the table xla_ae_line_details |

749: | Private Procedure |
750: | |
751: | Description |
752: | ----------- |
753: | Inserts a new record in the table xla_ae_line_details |
754: | |
755: | |
756: | Open issues |
757: | ----------- |

Line 772: INSERT INTO xla_ae_line_details

768: ,p_msg => 'BEGIN ' || l_log_module
769: ,p_level => C_LEVEL_PROCEDURE);
770: END IF;
771:
772: INSERT INTO xla_ae_line_details
773: ( ae_header_id
774: ,ae_line_num
775: ,analytical_detail_value_id
776: )

Line 787: ' row(s) inserted into xla_ae_line_details '

783: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
784: trace
785: ( p_module => l_log_module
786: ,p_msg => SQL%ROWCOUNT ||
787: ' row(s) inserted into xla_ae_line_details '
788: ,p_level => C_LEVEL_STATEMENT);
789: END IF;
790:
791: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 846: FROM xla_ae_line_details

842: IF p_analytical_detail_value_id IS NULL
843: THEN
844: --Remove all the line details
845: DELETE
846: FROM xla_ae_line_details
847: WHERE ae_header_id = p_ae_header_id
848: AND ae_line_num = p_ae_line_num;
849:
850: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 854: || ' row(s) deleted from xla_ae_line_details'

850: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
851: trace
852: ( p_module => l_log_module
853: ,p_msg => SQL%ROWCOUNT
854: || ' row(s) deleted from xla_ae_line_details'
855: ,p_level => C_LEVEL_STATEMENT);
856: END IF;
857:
858: --Else (p_analytical_detail_value_id is not null)

Line 862: FROM xla_ae_line_details

858: --Else (p_analytical_detail_value_id is not null)
859: ELSE
860: --Remove only the detail specified
861: DELETE
862: FROM xla_ae_line_details
863: WHERE ae_header_id = p_ae_header_id
864: AND ae_line_num = p_ae_line_num
865: AND analytical_detail_value_id = p_analytical_detail_value_id;
866:

Line 871: || ' row(s) deleted from xla_ae_line_details'

867: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
868: trace
869: ( p_module => l_log_module
870: ,p_msg => SQL%ROWCOUNT
871: || ' row(s) deleted from xla_ae_line_details'
872: ,p_level => C_LEVEL_STATEMENT);
873: END IF;
874:
875: END IF;

Line 938: FROM xla_ae_line_details xald

934: ,cp_ae_line_num INTEGER
935: )
936: IS
937: SELECT 1
938: FROM xla_ae_line_details xald
939: WHERE xald.ae_header_id = cp_ae_header_id
940: AND xald.ae_line_num = cp_ae_line_num
941: FOR UPDATE NOWAIT;
942:

Line 1411: ,xla_ae_line_details xald

1407: )
1408: IS
1409: SELECT 1
1410: FROM xla_ae_lines xal
1411: ,xla_ae_line_details xald
1412: WHERE xal.ae_header_id = cp_ae_header_id
1413: AND xal.application_id = cp_application_id
1414: AND xald.ae_header_id = xal.ae_header_id
1415: FOR UPDATE NOWAIT;

Line 1424: FROM xla_ae_line_details xald

1420: ,cp_ae_line_num INTEGER
1421: )
1422: IS
1423: SELECT 1
1424: FROM xla_ae_line_details xald
1425: WHERE xald.ae_header_id = cp_ae_header_id
1426: AND xald.ae_line_num = cp_ae_line_num
1427: FOR UPDATE NOWAIT;
1428:

Line 1673: FROM xla_ae_line_details xald

1669: AND xal.ae_line_num = p_ae_line_num
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

Line 4317: 'FROM xla_ae_line_details xald

4313: l_field_template_null VARCHAR2(256) :=
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