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 1467: ,xla_ae_line_details xald

1463: )
1464: IS
1465: SELECT 1
1466: FROM xla_ae_lines xal
1467: ,xla_ae_line_details xald
1468: WHERE xal.ae_header_id = cp_ae_header_id
1469: AND xal.application_id = cp_application_id
1470: AND xald.ae_header_id = xal.ae_header_id
1471: FOR UPDATE NOWAIT;

Line 1480: FROM xla_ae_line_details xald

1476: ,cp_ae_line_num INTEGER
1477: )
1478: IS
1479: SELECT 1
1480: FROM xla_ae_line_details xald
1481: WHERE xald.ae_header_id = cp_ae_header_id
1482: AND xald.ae_line_num = cp_ae_line_num
1483: FOR UPDATE NOWAIT;
1484:

Line 1783: FROM xla_ae_line_details xald

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

Line 4482: 'FROM xla_ae_line_details xald

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

Line 4507: /*Stubbed the below function as these xla_ae_header_details and xla_ae_line_details tables are not used in 12.2, commented the code and just returning success.

4503: l_log_module VARCHAR2 (2000);
4504:
4505:
4506: BEGIN
4507: /*Stubbed the below function as these xla_ae_header_details and xla_ae_line_details tables are not used in 12.2, commented the code and just returning success.
4508: Bug 12619876 :- Logged "Import Application Accounting Definitions' program with Import Option as Merge completes in error.
4509: While building the view xla_ac_lines_v we are getting the ORA error ie Duplicate Column Name.
4510: This error occurrs when two supporting refrences have same Analytical Detal Code.
4511: Resolution :- In order to resolved this issue we can define a variable at the begining of this procedure which defines list of all columns.