DBA Data[Home] [Help]

APPS.XLA_FSAH_INT_PVT dependencies on XLA_AE_LINES

Line 396: FROM xla_ae_headers xah, xla_ae_lines xal

392: c_event_type_code_manual -- EVENT TYPE CODE
393: ,
394: xal.unrounded_entered_dr, xal.unrounded_entered_cr,
395: xal.unrounded_accounted_dr, xal.unrounded_accounted_cr
396: FROM xla_ae_headers xah, xla_ae_lines xal
397: WHERE xah.application_id = p_application_id
398: AND xah.ae_header_id = p_ae_header_id
399: AND xal.application_id = xah.application_id
400: AND xal.ae_header_id = xah.ae_header_id;

Line 712: INSERT INTO xla_ae_lines

708:
709: --
710: -- CREATE JOURNAL ENTRY LINES FOR THE REVERSAL JOURNAL ENTRY
711: --
712: INSERT INTO xla_ae_lines
713: (application_id, ae_header_id, ae_line_num,
714: displayed_line_number, code_combination_id,
715: gl_transfer_mode_code, creation_date, created_by,
716: last_update_date, last_updated_by, last_update_login,

Line 780: FROM xla_ae_lines

776: attribute13, attribute14, attribute15, gain_or_loss_flag,
777: l_info.ledger_id,trunc(p_gl_date),
778: NVL (mpa_accrual_entry_flag, 'N')
779: -- 4262811 MPA_ACCRUAL_ENTRY_FLAG
780: FROM xla_ae_lines
781: WHERE application_id = l_info.application_id
782: AND ae_header_id = l_info.header_id;
783:
784: create_reversal_distr_link (p_application_id => l_info.application_id,

Line 1228: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_lines');

1224: --DBMS_OUTPUT.put_line ('After Updating the xla_ae_headers1');
1225: ------------------------------------------------------------------------------
1226: -- LINES TABLE UPDATE
1227: ------------------------------------------------------------------------------
1228: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_lines');
1229:
1230: IF (c_level_procedure >= g_log_level)
1231: THEN
1232: TRACE (p_msg => 'Before Updating Updating the xla_ae_lines',

Line 1232: TRACE (p_msg => 'Before Updating Updating the xla_ae_lines',

1228: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_lines');
1229:
1230: IF (c_level_procedure >= g_log_level)
1231: THEN
1232: TRACE (p_msg => 'Before Updating Updating the xla_ae_lines',
1233: p_level => c_level_procedure,
1234: p_module => l_log_module
1235: );
1236: END IF;

Line 1239: UPDATE xla_ae_lines

1235: );
1236: END IF;
1237:
1238: FORALL i IN 1 .. l_array_ae_header_id.COUNT
1239: UPDATE xla_ae_lines
1240: SET description = 'DATA FIX ENTRY: EVENT_ID OF ' || p_event_id
1241: WHERE application_id = p_application_id
1242: AND ae_header_id = l_array_ae_header_id (i);
1243: ------------------------------------------------------------------------------

Line 1246: --DBMS_OUTPUT.put_line ('after Updating the xla_ae_lines');

1242: AND ae_header_id = l_array_ae_header_id (i);
1243: ------------------------------------------------------------------------------
1244: -- DISTRIBUTION LINKS TABLE UPDATE
1245: ------------------------------------------------------------------------------
1246: --DBMS_OUTPUT.put_line ('after Updating the xla_ae_lines');
1247:
1248: IF (c_level_procedure >= g_log_level)
1249: THEN
1250: TRACE (p_msg => 'After Updating Updating the xla_ae_lines',

Line 1250: TRACE (p_msg => 'After Updating Updating the xla_ae_lines',

1246: --DBMS_OUTPUT.put_line ('after Updating the xla_ae_lines');
1247:
1248: IF (c_level_procedure >= g_log_level)
1249: THEN
1250: TRACE (p_msg => 'After Updating Updating the xla_ae_lines',
1251: p_level => c_level_procedure,
1252: p_module => l_log_module
1253: );
1254: END IF;

Line 1436: TRACE (p_msg => 'Updating the xla_ae_lines with the Description ',

1432: END IF;
1433:
1434: IF (c_level_statement >= g_log_level)
1435: THEN
1436: TRACE (p_msg => 'Updating the xla_ae_lines with the Description ',
1437: p_module => l_log_module,
1438: p_level => c_level_statement
1439: );
1440: END IF;

Line 1443: UPDATE xla_ae_lines

1439: );
1440: END IF;
1441:
1442: FORALL i IN 1 .. l_array_ae_header_id.COUNT
1443: UPDATE xla_ae_lines
1444: SET description =description||' Original Event_id '|| p_event_id
1445: WHERE application_id = p_application_id
1446: AND ae_header_id = l_array_ae_header_id (i);
1447:

Line 1450: TRACE (p_msg => 'After Updating the xla_ae_lines with the Description ',

1446: AND ae_header_id = l_array_ae_header_id (i);
1447:
1448: IF (c_level_statement >= g_log_level)
1449: THEN
1450: TRACE (p_msg => 'After Updating the xla_ae_lines with the Description ',
1451: p_module => l_log_module,
1452: p_level => c_level_statement
1453: );
1454: END IF;