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 1388: FROM xla_ae_header_details xahd

1384: ( cp_ae_header_id INTEGER
1385: )
1386: IS
1387: SELECT 1
1388: FROM xla_ae_header_details xahd
1389: WHERE xahd.ae_header_id = cp_ae_header_id
1390: FOR UPDATE NOWAIT;
1391:
1392: CURSOR lc_lock_ae_header_detail

Line 1398: FROM xla_ae_header_details xahd

1394: ,cp_analytical_detail_value_id INTEGER
1395: )
1396: IS
1397: SELECT 1
1398: FROM xla_ae_header_details xahd
1399: WHERE xahd.ae_header_id = cp_ae_header_id
1400: AND xahd.analytical_detail_value_id = cp_analytical_detail_value_id
1401: FOR UPDATE NOWAIT;
1402:

Line 1517: FROM xla_ae_header_details xhd

1513: END IF; --l_balanced_lined_count > 0
1514:
1515: --delete all the header details
1516: DELETE
1517: FROM xla_ae_header_details xhd
1518: WHERE xhd.ae_header_id = p_ae_header_id;
1519: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1520: trace
1521: ( p_module => l_log_module

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

1519: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1520: trace
1521: ( p_module => l_log_module
1522: ,p_msg => SQL%ROWCOUNT
1523: || ' row(s) deleted from xla_ae_header_details'
1524: ,p_level => C_LEVEL_STATEMENT);
1525: END IF;
1526:
1527: --loop on all the journal entry lines

Line 1572: FROM xla_ae_header_details xahd

1568: CLOSE lc_lock_ae_header_detail;
1569:
1570: --delete the specified header detail
1571: DELETE
1572: FROM xla_ae_header_details xahd
1573: WHERE xahd.ae_header_id = p_ae_header_id
1574: AND xahd.analytical_detail_value_id = p_analytical_detail_value_id;
1575:
1576: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

1576: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1577: trace
1578: ( p_module => l_log_module
1579: ,p_msg => SQL%ROWCOUNT
1580: || ' row(s) deleted from xla_ae_header_details'
1581: ,p_level => C_LEVEL_STATEMENT);
1582: END IF;
1583: END IF;
1584:

Line 4321: 'FROM xla_ae_header_details xahd

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';
4323:
4324:
4325: l_hdr_fixed_part_footer_2 VARCHAR2(256) :=