APPS.XLA_ANALYTICAL_CRITERIA_PKG dependencies on XLA_AE_HEADER_DETAILS

Line 692: | Inserts a new record in the table xla_ae_header_details. |

688: | Private Procedure |
689: | |
690: | Description |
691: | ----------- |
692: | Inserts a new record in the table xla_ae_header_details. |
693: | |
694: +======================================================================*/
695: l_log_module VARCHAR2 (2000);
696: BEGIN

Line 708: INSERT INTO xla_ae_header_details

704: ,p_msg => 'BEGIN ' || l_log_module
705: ,p_level => C_LEVEL_PROCEDURE);
706: END IF;
707:
708: INSERT INTO xla_ae_header_details
709: ( ae_header_id
710: ,analytical_detail_value_id
711: )
712: VALUES

Line 1444: FROM xla_ae_header_details xahd

1440: ( cp_ae_header_id INTEGER
1441: )
1442: IS
1443: SELECT 1
1444: FROM xla_ae_header_details xahd
1445: WHERE xahd.ae_header_id = cp_ae_header_id
1446: FOR UPDATE NOWAIT;
1447:
1448: CURSOR lc_lock_ae_header_detail

Line 1454: FROM xla_ae_header_details xahd

1450: ,cp_analytical_detail_value_id INTEGER
1451: )
1452: IS
1453: SELECT 1
1454: FROM xla_ae_header_details xahd
1455: WHERE xahd.ae_header_id = cp_ae_header_id
1456: AND xahd.analytical_detail_value_id = cp_analytical_detail_value_id
1457: FOR UPDATE NOWAIT;
1458:

Line 1601: FROM xla_ae_header_details xhd

1597: END IF; --l_balanced_lined_count > 0
1598:
1599: --delete all the header details
1600: DELETE
1601: FROM xla_ae_header_details xhd
1602: WHERE xhd.ae_header_id = p_ae_header_id;
1603: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1604: trace
1605: ( p_module => l_log_module

Line 1607: || ' row(s) deleted from xla_ae_header_details'

1603: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1604: trace
1605: ( p_module => l_log_module
1606: ,p_msg => SQL%ROWCOUNT
1607: || ' row(s) deleted from xla_ae_header_details'
1608: ,p_level => C_LEVEL_STATEMENT);
1609: END IF;
1610:
1611: --loop on all the journal entry lines

Line 1656: FROM xla_ae_header_details xahd

1652: CLOSE lc_lock_ae_header_detail;
1653:
1654: --delete the specified header detail
1655: DELETE
1656: FROM xla_ae_header_details xahd
1657: WHERE xahd.ae_header_id = p_ae_header_id
1658: AND xahd.analytical_detail_value_id = p_analytical_detail_value_id;
1659:
1660: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1664: || ' row(s) deleted from xla_ae_header_details'

1660: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1661: trace
1662: ( p_module => l_log_module
1663: ,p_msg => SQL%ROWCOUNT
1664: || ' row(s) deleted from xla_ae_header_details'
1665: ,p_level => C_LEVEL_STATEMENT);
1666: END IF;
1667: END IF;
1668:

Line 4486: 'FROM xla_ae_header_details xahd

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';
4488:
4489:
4490: l_hdr_fixed_part_footer_2 VARCHAR2(256) :=

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.