eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AE_HEADER_PKG dependencies on XLA_AE_JOURNAL_ENTRY_PKG

Line 544: -- XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

540: --
541: -- bulk performance
542: -- Following may not be needed in the bulk approach as
543: -- je status is handled in a different way.
544: -- XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
545: --
546: -- bulk performance
547: -- following initial1ses the status of je headers for each balance type
548: -- initial status is kept as 'valid'

Line 549: g_rec_header_new.array_actual_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

545: --
546: -- bulk performance
547: -- following initial1ses the status of je headers for each balance type
548: -- initial status is kept as 'valid'
549: g_rec_header_new.array_actual_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
550: g_rec_header_new.array_budget_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
551: g_rec_header_new.array_encumbrance_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
552:
553: /* Events Process_Status_Code Update is soley written with X as SUCCESS so any

Line 550: g_rec_header_new.array_budget_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

546: -- bulk performance
547: -- following initial1ses the status of je headers for each balance type
548: -- initial status is kept as 'valid'
549: g_rec_header_new.array_actual_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
550: g_rec_header_new.array_budget_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
551: g_rec_header_new.array_encumbrance_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
552:
553: /* Events Process_Status_Code Update is soley written with X as SUCCESS so any
554: * change in the code to represent SUCCESS/New Status Code changes please revisit the code

Line 551: g_rec_header_new.array_encumbrance_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

547: -- following initial1ses the status of je headers for each balance type
548: -- initial status is kept as 'valid'
549: g_rec_header_new.array_actual_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
550: g_rec_header_new.array_budget_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
551: g_rec_header_new.array_encumbrance_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
552:
553: /* Events Process_Status_Code Update is soley written with X as SUCCESS so any
554: * change in the code to represent SUCCESS/New Status Code changes please revisit the code
555: * changes in xlajeaex.pkb PostAccountingEngine code done for bug#9086275 */

Line 570: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

566:
567: END IF;
568: EXCEPTION
569: WHEN xla_exceptions_pkg.application_exception THEN
570: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
571: RAISE;
572: WHEN OTHERS THEN
573: xla_exceptions_pkg.raise_message
574: (p_location => 'XLA_AE_HEADER_PKG.InitHeader');

Line 684: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date

680: , p_accted_amt IN NUMBER -- this should be the unrounded_accounted_amount
681: , p_entered_amt IN NUMBER -- this should be the unrounded_entered_amount
682: , p_bflow_applied_to_amt IN NUMBER -- 5132302
683: , x_num_entries IN OUT NOCOPY NUMBER
684: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
685: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
686: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
687: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
688: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302

Line 685: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num

681: , p_entered_amt IN NUMBER -- this should be the unrounded_entered_amount
682: , p_bflow_applied_to_amt IN NUMBER -- 5132302
683: , x_num_entries IN OUT NOCOPY NUMBER
684: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
685: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
686: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
687: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
688: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302
689: , p_trx_gl_date IN DATE -- added for bug13018752

Line 686: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num

682: , p_bflow_applied_to_amt IN NUMBER -- 5132302
683: , x_num_entries IN OUT NOCOPY NUMBER
684: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
685: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
686: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
687: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
688: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302
689: , p_trx_gl_date IN DATE -- added for bug13018752
690: )

Line 687: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L

683: , x_num_entries IN OUT NOCOPY NUMBER
684: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
685: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
686: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
687: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
688: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302
689: , p_trx_gl_date IN DATE -- added for bug13018752
690: )
691: IS

Line 688: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302

684: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
685: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
686: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
687: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
688: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302
689: , p_trx_gl_date IN DATE -- added for bug13018752
690: )
691: IS
692: --

Line 838: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;

834: AND gps_orig.adjustment_period_flag = 'N'
835: AND p_trx_gl_date between gps_orig.start_date and gps_orig.end_date
836: ORDER BY gps_mpa.start_date ;
837:
838: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;
839: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;
840: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;
841: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;
842:

Line 839: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;

835: AND p_trx_gl_date between gps_orig.start_date and gps_orig.end_date
836: ORDER BY gps_mpa.start_date ;
837:
838: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;
839: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;
840: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;
841: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;
842:
843: l_total_months NUMBER;

Line 840: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;

836: ORDER BY gps_mpa.start_date ;
837:
838: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;
839: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;
840: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;
841: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;
842:
843: l_total_months NUMBER;
844: l_whole_months NUMBER;

Line 841: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;

837:
838: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;
839: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;
840: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;
841: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;
842:
843: l_total_months NUMBER;
844: l_whole_months NUMBER;
845: l_other_accted_amt NUMBER;

Line 1368: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1364: -------------------------------------------
1365: -- Validate header accounting attributes
1366: -------------------------------------------
1367: IF NVL(g_rec_header_new.array_party_change_option(p_hdr_idx),'N') NOT IN ('Y','N') THEN
1368: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1369: xla_accounting_err_pkg.build_message
1370: (p_appli_s_name => 'XLA'
1371: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
1372: ,p_token_1 => 'PRODUCT_NAME'

Line 1373: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1369: xla_accounting_err_pkg.build_message
1370: (p_appli_s_name => 'XLA'
1371: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
1372: ,p_token_1 => 'PRODUCT_NAME'
1373: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1374: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1375: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1376: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1377: END IF;

Line 1374: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1370: (p_appli_s_name => 'XLA'
1371: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
1372: ,p_token_1 => 'PRODUCT_NAME'
1373: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1374: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1375: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1376: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1377: END IF;
1378:

Line 1375: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1371: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
1372: ,p_token_1 => 'PRODUCT_NAME'
1373: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1374: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1375: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1376: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1377: END IF;
1378:
1379: IF g_rec_header_new.array_gl_transfer_flag(p_hdr_idx) NOT IN ('Y', 'N') THEN

Line 1376: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

1372: ,p_token_1 => 'PRODUCT_NAME'
1373: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1374: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1375: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1376: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1377: END IF;
1378:
1379: IF g_rec_header_new.array_gl_transfer_flag(p_hdr_idx) NOT IN ('Y', 'N') THEN
1380: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

Line 1380: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1376: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1377: END IF;
1378:
1379: IF g_rec_header_new.array_gl_transfer_flag(p_hdr_idx) NOT IN ('Y', 'N') THEN
1380: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1381: xla_accounting_err_pkg.build_message
1382: (p_appli_s_name => 'XLA'
1383: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1384: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 1387: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1383: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1384: ,p_token_1 => 'ACCT_ATTR_NAME'
1385: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
1386: ,p_token_2 => 'PRODUCT_NAME'
1387: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1388: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1389: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1390: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1391: END IF;

Line 1388: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1384: ,p_token_1 => 'ACCT_ATTR_NAME'
1385: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
1386: ,p_token_2 => 'PRODUCT_NAME'
1387: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1388: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1389: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1390: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1391: END IF;
1392:

Line 1389: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1385: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
1386: ,p_token_2 => 'PRODUCT_NAME'
1387: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1388: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1389: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1390: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1391: END IF;
1392:
1393: IF g_rec_header_new.array_trx_acct_reversal_option(p_hdr_idx) NOT IN ('Y', 'N') THEN

Line 1390: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

1386: ,p_token_2 => 'PRODUCT_NAME'
1387: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1388: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1389: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1390: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1391: END IF;
1392:
1393: IF g_rec_header_new.array_trx_acct_reversal_option(p_hdr_idx) NOT IN ('Y', 'N') THEN
1394: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

Line 1394: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1390: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1391: END IF;
1392:
1393: IF g_rec_header_new.array_trx_acct_reversal_option(p_hdr_idx) NOT IN ('Y', 'N') THEN
1394: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1395: xla_accounting_err_pkg.build_message
1396: (p_appli_s_name => 'XLA'
1397: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1398: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 1401: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1397: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1398: ,p_token_1 => 'ACCT_ATTR_NAME'
1399: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
1400: ,p_token_2 => 'PRODUCT_NAME'
1401: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1402: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1403: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1404: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1405: END IF;

Line 1402: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1398: ,p_token_1 => 'ACCT_ATTR_NAME'
1399: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
1400: ,p_token_2 => 'PRODUCT_NAME'
1401: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1402: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1403: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1404: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1405: END IF;
1406:

Line 1403: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1399: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
1400: ,p_token_2 => 'PRODUCT_NAME'
1401: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1402: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1403: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1404: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1405: END IF;
1406:
1407: IF g_rec_header_new.array_gl_date(p_hdr_idx) is NULL THEN

Line 1404: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

1400: ,p_token_2 => 'PRODUCT_NAME'
1401: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1402: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1403: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1404: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1405: END IF;
1406:
1407: IF g_rec_header_new.array_gl_date(p_hdr_idx) is NULL THEN
1408: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

Line 1408: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1404: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1405: END IF;
1406:
1407: IF g_rec_header_new.array_gl_date(p_hdr_idx) is NULL THEN
1408: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1409: xla_accounting_err_pkg.build_message
1410: (p_appli_s_name => 'XLA'
1411: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1412: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 1415: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1411: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1412: ,p_token_1 => 'ACCT_ATTR_NAME'
1413: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
1414: ,p_token_2 => 'PRODUCT_NAME'
1415: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1416: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1417: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1418: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1419: END IF;

Line 1416: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1412: ,p_token_1 => 'ACCT_ATTR_NAME'
1413: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
1414: ,p_token_2 => 'PRODUCT_NAME'
1415: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1416: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1417: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1418: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1419: END IF;
1420:

Line 1417: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1413: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
1414: ,p_token_2 => 'PRODUCT_NAME'
1415: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1416: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1417: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1418: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1419: END IF;
1420:
1421: --

Line 1418: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

1414: ,p_token_2 => 'PRODUCT_NAME'
1415: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1416: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1417: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1418: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1419: END IF;
1420:
1421: --
1422: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1457: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date

1453: , p_num_entries IN INTEGER
1454: , p_last_hdr_idx IN INTEGER
1455: , p_recog_line_num_1 IN INTEGER
1456: , p_recog_line_num_2 IN INTEGER
1457: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date
1458: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num
1459: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num
1460: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302
1461: ) RETURN NUMBER

Line 1458: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num

1454: , p_last_hdr_idx IN INTEGER
1455: , p_recog_line_num_1 IN INTEGER
1456: , p_recog_line_num_2 IN INTEGER
1457: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date
1458: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num
1459: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num
1460: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302
1461: ) RETURN NUMBER
1462: IS

Line 1459: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num

1455: , p_recog_line_num_1 IN INTEGER
1456: , p_recog_line_num_2 IN INTEGER
1457: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date
1458: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num
1459: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num
1460: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302
1461: ) RETURN NUMBER
1462: IS
1463:

Line 1460: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302

1456: , p_recog_line_num_2 IN INTEGER
1457: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date
1458: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num
1459: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num
1460: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302
1461: ) RETURN NUMBER
1462: IS
1463:
1464: l_hdr_idx NUMBER;

Line 1517: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx

1513: --**************************************************************************************************************
1514: g_rec_header_new.array_gl_date(l_hdr_idx) := trunc(p_gl_dates(i));
1515:
1516:
1517: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1518: ,p_balance_type_code => 'A');
1519:
1520: -----------------------------------------------------------
1521: -- create recognition line - for Recognition JLT1

Line 1547: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx

1543: XLA_AE_LINES_PKG.ValidateCurrentLine;
1544: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1545:
1546:
1547: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1548: ,p_balance_type_code => 'A');
1549:
1550: -----------------------------------------------------------
1551: -- create recognition line - for Recognition JLT2

Line 1575: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx

1571: g_rec_header_new.array_gl_date(l_hdr_idx);
1572: XLA_AE_LINES_PKG.ValidateCurrentLine;
1573: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1574:
1575: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1576: ,p_balance_type_code => 'A');
1577:
1578: END LOOP;
1579:

Line 1629: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.base_ledger_id

1625: ,p_module => l_log_module);
1626: END IF;
1627: --
1628: g_rec_header_new.array_je_category_name(g_header_idx) := xla_accounting_cache_pkg.get_je_category(
1629: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.base_ledger_id
1630: ,p_event_class_code => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_class);
1631: --
1632:
1633: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1630: ,p_event_class_code => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_class);

1626: END IF;
1627: --
1628: g_rec_header_new.array_je_category_name(g_header_idx) := xla_accounting_cache_pkg.get_je_category(
1629: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.base_ledger_id
1630: ,p_event_class_code => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_class);
1631: --
1632:
1633: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1634:

Line 1648: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1644: END IF;
1645: --
1646: EXCEPTION
1647: WHEN xla_exceptions_pkg.application_exception THEN
1648: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1649: RAISE;
1650: WHEN OTHERS THEN
1651: xla_exceptions_pkg.raise_message
1652: (p_location => 'XLA_AE_HEADER_PKG.InitHeader');

Line 1846: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1842: END IF;
1843: RETURN l_analytical_criteria;
1844: EXCEPTION
1845: WHEN xla_exceptions_pkg.application_exception THEN
1846: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1847: RETURN NULL;
1848: WHEN OTHERS THEN
1849: xla_exceptions_pkg.raise_message
1850: (p_location => 'XLA_AE_HEADER_PKG.SetAnalyticalCriteria');

Line 1893: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1889: END IF;
1890: EXCEPTION
1891: --
1892: WHEN xla_exceptions_pkg.application_exception THEN
1893: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1894: RAISE;
1895: WHEN OTHERS THEN
1896: xla_exceptions_pkg.raise_message
1897: (p_location => 'XLA_AE_HEADER_PKG.SetHdrDescription');

Line 1911: l_array_header_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

1907: RETURN BOOLEAN
1908: IS
1909: --
1910: l_period_name VARCHAR2(25);
1911: l_array_header_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
1912: l_array_balance_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L;
1913: l_result BOOLEAN;
1914: l_Idx BINARY_INTEGER := 0;
1915: l_log_module VARCHAR2(240);

Line 1912: l_array_balance_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L;

1908: IS
1909: --
1910: l_period_name VARCHAR2(25);
1911: l_array_header_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
1912: l_array_balance_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L;
1913: l_result BOOLEAN;
1914: l_Idx BINARY_INTEGER := 0;
1915: l_log_module VARCHAR2(240);
1916: -- added 7526530

Line 1952: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1948: l_array_header_id(l_Idx) := g_rec_header_new.array_actual_header_id(g_header_idx);
1949: l_array_balance_type(l_Idx) := C_ACTUAL;
1950: --
1951: l_period_name := get_period_name(
1952: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1953: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1954: , p_ae_header_id => g_rec_header_new.array_actual_header_id(g_header_idx)
1955: );
1956: END IF;

Line 1953: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date

1949: l_array_balance_type(l_Idx) := C_ACTUAL;
1950: --
1951: l_period_name := get_period_name(
1952: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1953: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1954: , p_ae_header_id => g_rec_header_new.array_actual_header_id(g_header_idx)
1955: );
1956: END IF;
1957: --

Line 1965: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1961: l_array_header_id(l_Idx) := g_rec_header_new.array_budget_header_id(g_header_idx);
1962: l_array_balance_type(l_Idx) := C_BUDGET;
1963: --
1964: l_period_name := get_period_name(
1965: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1966: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1967: , p_ae_header_id => g_rec_header_new.array_budget_header_id(g_header_idx)
1968: );
1969: END IF;

Line 1966: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date

1962: l_array_balance_type(l_Idx) := C_BUDGET;
1963: --
1964: l_period_name := get_period_name(
1965: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1966: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1967: , p_ae_header_id => g_rec_header_new.array_budget_header_id(g_header_idx)
1968: );
1969: END IF;
1970: --

Line 1978: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1974: l_array_header_id(l_Idx) := g_rec_header_new.array_encumb_header_id(g_header_idx);
1975: l_array_balance_type(l_Idx) := C_ENCUMBRANCE;
1976: --
1977: l_period_name := get_period_name(
1978: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1979: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1980: , p_ae_header_id => g_rec_header_new.array_encumb_header_id(g_header_idx)
1981: );
1982: END IF;

Line 1979: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date

1975: l_array_balance_type(l_Idx) := C_ENCUMBRANCE;
1976: --
1977: l_period_name := get_period_name(
1978: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1979: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1980: , p_ae_header_id => g_rec_header_new.array_encumb_header_id(g_header_idx)
1981: );
1982: END IF;
1983: */

Line 2150: XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED

2146: g_rec_header_new.array_encumbrance_status(Idx)
2147: when C_ACTUAL THEN
2148: g_rec_header_new.array_actual_status(Idx)
2149: ELSE
2150: XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED
2151: END CASE
2152: , C_STANDARD
2153: , g_rec_header_new.array_target_ledger_id(Idx)
2154: , g_rec_header_new.array_entity_id(Idx)

Line 2158: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_type_code

2154: , g_rec_header_new.array_entity_id(Idx)
2155: , g_rec_header_new.array_event_id(Idx)
2156: , g_rec_header_new.array_event_type_code(Idx)
2157: , g_rec_header_new.array_gl_date(Idx)
2158: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_type_code
2159: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_code
2160: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_version
2161: , g_rec_header_new.array_je_category_name(Idx)
2162: --, 'XYZ' --l_period_name

Line 2159: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_code

2155: , g_rec_header_new.array_event_id(Idx)
2156: , g_rec_header_new.array_event_type_code(Idx)
2157: , g_rec_header_new.array_gl_date(Idx)
2158: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_type_code
2159: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_code
2160: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_version
2161: , g_rec_header_new.array_je_category_name(Idx)
2162: --, 'XYZ' --l_period_name
2163: , g_rec_header_new.array_doc_sequence_id(Idx)

Line 2160: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_version

2156: , g_rec_header_new.array_event_type_code(Idx)
2157: , g_rec_header_new.array_gl_date(Idx)
2158: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_type_code
2159: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_code
2160: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_version
2161: , g_rec_header_new.array_je_category_name(Idx)
2162: --, 'XYZ' --l_period_name
2163: , g_rec_header_new.array_doc_sequence_id(Idx)
2164: , g_rec_header_new.array_doc_sequence_value(Idx)

Line 2173: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.amb_context_code

2169: ,NULL)
2170: --, DECODE(ael.balance_type_code, C_ENCUMBRANCE, g_rec_header_new.array_encumbrance_type_id(Idx)
2171: -- , NULL) -- 4458381 Public Sector Enh
2172: , ael.balance_type_code
2173: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.amb_context_code
2174: , g_rec_header_new.array_doc_category_code(Idx)
2175: , DECODE(g_rec_header_new.array_gl_transfer_flag(Idx), 'N', 'NT', 'Y', 'N', 'N')
2176: , g_rec_header_new.array_event_status(Idx)
2177: , g_rec_header_new.array_anc_id_1(Idx)

Line 2309: (XLA_AE_JOURNAL_ENTRY_PKG.g_global_status = XLA_AE_JOURNAL_ENTRY_PKG.C_VALID)) ;

2305: ,p_module => l_log_module);
2306: END IF;
2307: --
2308: l_result:= ( (SQL%ROWCOUNT > 0) OR
2309: (XLA_AE_JOURNAL_ENTRY_PKG.g_global_status = XLA_AE_JOURNAL_ENTRY_PKG.C_VALID)) ;
2310:
2311: --
2312: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2313:

Line 2562: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

2558: WHEN C_BUDGET THEN g_rec_header_new.array_budget_header_id(g_header_idx)
2559: WHEN C_ENCUMBRANCE THEN g_rec_header_new.array_encumb_header_id(g_header_idx)
2560: END
2561: , XLA_AE_LINES_PKG.SetLineNum(xah.balance_type_code)
2562: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2563: --
2564: , xal.ae_header_id
2565: , xal.ae_line_num
2566: , xdl.temp_line_num

Line 2585: , DECODE(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option,

2581: , NULL
2582: , xal.description
2583: , xal.gl_transfer_mode_code
2584: , xdl.merge_duplicate_code
2585: , DECODE(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option,
2586: 'SIDE', C_SWITCH,
2587: C_NO_SWITCH
2588: )
2589: /* , xdl.entered_amount

Line 2869: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

2865: AND xe.event_id = xah.event_id
2866: AND xal.ae_header_id = xdl.ae_header_id
2867: AND xal.ae_header_id = xah.ae_header_id
2868: AND xal.ae_line_num = xdl.ae_line_num
2869: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2870: AND anc.ae_header_id = xdl.ae_header_id
2871: AND anc.ae_line_num = xdl.ae_line_num
2872: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2873: AND (g_rec_header_new.array_previous_party_id(g_header_idx) IS NULL

Line 2872: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

2868: AND xal.ae_line_num = xdl.ae_line_num
2869: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2870: AND anc.ae_header_id = xdl.ae_header_id
2871: AND anc.ae_line_num = xdl.ae_line_num
2872: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2873: AND (g_rec_header_new.array_previous_party_id(g_header_idx) IS NULL
2874: OR
2875: xal.party_id = g_rec_header_new.array_previous_party_id(g_header_idx))
2876: AND (g_rec_header_new.array_previous_party_site_id(g_header_idx) IS NULL

Line 2987: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

2983: WHEN C_BUDGET THEN g_rec_header_new.array_budget_header_id(g_header_idx)
2984: WHEN C_ENCUMBRANCE THEN g_rec_header_new.array_encumb_header_id(g_header_idx)
2985: END
2986: , XLA_AE_LINES_PKG.SetLineNum(xah.balance_type_code)
2987: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2988: --
2989: , xal.ae_header_id
2990: , xal.ae_line_num
2991: , xdl.temp_line_num

Line 3010: , DECODE(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option,

3006: , NULL
3007: , xal.description
3008: , xal.gl_transfer_mode_code
3009: , xdl.merge_duplicate_code
3010: , DECODE(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option,
3011: 'SIDE', C_SWITCH,
3012: C_NO_SWITCH
3013: )
3014: -- , xdl.entered_amount

Line 3068: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

3064: AND xe.event_id = xah.event_id
3065: AND xal.ae_header_id = xdl.ae_header_id
3066: AND xal.ae_header_id = xah.ae_header_id
3067: AND xal.ae_line_num = xdl.ae_line_num
3068: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3069: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3070: AND ( g_rec_header_new.array_previous_party_id(g_header_idx) IS NULL
3071: OR
3072: xal.party_id = g_rec_header_new.array_previous_party_id(g_header_idx))

Line 3069: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

3065: AND xal.ae_header_id = xdl.ae_header_id
3066: AND xal.ae_header_id = xah.ae_header_id
3067: AND xal.ae_line_num = xdl.ae_line_num
3068: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3069: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3070: AND ( g_rec_header_new.array_previous_party_id(g_header_idx) IS NULL
3071: OR
3072: xal.party_id = g_rec_header_new.array_previous_party_id(g_header_idx))
3073: AND ( g_rec_header_new.array_previous_party_site_id(g_header_idx) IS NULL

Line 3139: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := NULL;

3135: END IF;
3136: --
3137: g_rec_header_new := l_null_rec_header_new ;
3138: g_cache_period_name := l_null_rec_period_name;
3139: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := NULL;
3140: --
3141: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3142:
3143: trace

Line 3219: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

3215: g_rec_header_new.array_party_change_option(g_header_idx) := p_rec_acct_attrs.array_num_value(i);
3216: END IF;
3217:
3218: IF NVL(g_rec_header_new.array_party_change_option(g_header_idx),'N') NOT IN ('Y','N') THEN
3219: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
3220: xla_accounting_err_pkg.build_message
3221: (p_appli_s_name => 'XLA'
3222: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
3223: ,p_token_1 => 'PRODUCT_NAME'

Line 3224: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

3220: xla_accounting_err_pkg.build_message
3221: (p_appli_s_name => 'XLA'
3222: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
3223: ,p_token_1 => 'PRODUCT_NAME'
3224: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3225: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3226: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3227: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3228: END IF;

Line 3225: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

3221: (p_appli_s_name => 'XLA'
3222: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
3223: ,p_token_1 => 'PRODUCT_NAME'
3224: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3225: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3226: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3227: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3228: END IF;
3229:

Line 3226: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

3222: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
3223: ,p_token_1 => 'PRODUCT_NAME'
3224: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3225: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3226: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3227: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3228: END IF;
3229:
3230: WHEN 'GL_TRANSFER_FLAG' THEN

Line 3227: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

3223: ,p_token_1 => 'PRODUCT_NAME'
3224: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3225: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3226: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3227: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3228: END IF;
3229:
3230: WHEN 'GL_TRANSFER_FLAG' THEN
3231: -- 5161760

Line 3243: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

3239: g_rec_header_new.array_gl_transfer_flag(g_header_idx) := nvl(p_rec_acct_attrs.array_num_value(i), 'Y');
3240: END IF;
3241:
3242: IF NVL(g_rec_header_new.array_gl_transfer_flag(g_header_idx),'Y') NOT IN ('Y', 'N') THEN
3243: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
3244: xla_accounting_err_pkg.build_message
3245: (p_appli_s_name => 'XLA'
3246: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3247: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 3250: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

3246: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3247: ,p_token_1 => 'ACCT_ATTR_NAME'
3248: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
3249: ,p_token_2 => 'PRODUCT_NAME'
3250: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3251: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3252: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3253: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3254: END IF;

Line 3251: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

3247: ,p_token_1 => 'ACCT_ATTR_NAME'
3248: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
3249: ,p_token_2 => 'PRODUCT_NAME'
3250: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3251: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3252: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3253: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3254: END IF;
3255:

Line 3252: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

3248: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
3249: ,p_token_2 => 'PRODUCT_NAME'
3250: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3251: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3252: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3253: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3254: END IF;
3255:
3256: WHEN 'TRX_ACCT_REVERSAL_OPTION' THEN

Line 3253: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

3249: ,p_token_2 => 'PRODUCT_NAME'
3250: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3251: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3252: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3253: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3254: END IF;
3255:
3256: WHEN 'TRX_ACCT_REVERSAL_OPTION' THEN
3257: -- 5161760

Line 3269: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

3265: g_rec_header_new.array_trx_acct_reversal_option(g_header_idx) := nvl(p_rec_acct_attrs.array_num_value(i), 'N');
3266: END IF;
3267:
3268: IF NVL(g_rec_header_new.array_trx_acct_reversal_option(g_header_idx),'N') NOT IN ('Y', 'N') THEN
3269: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
3270: xla_accounting_err_pkg.build_message
3271: (p_appli_s_name => 'XLA'
3272: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3273: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 3276: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

3272: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3273: ,p_token_1 => 'ACCT_ATTR_NAME'
3274: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3275: ,p_token_2 => 'PRODUCT_NAME'
3276: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3277: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3278: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3279: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3280: END IF;

Line 3277: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

3273: ,p_token_1 => 'ACCT_ATTR_NAME'
3274: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3275: ,p_token_2 => 'PRODUCT_NAME'
3276: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3277: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3278: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3279: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3280: END IF;
3281:

Line 3278: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

3274: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3275: ,p_token_2 => 'PRODUCT_NAME'
3276: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3277: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3278: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3279: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3280: END IF;
3281:
3282: WHEN 'PARTY_CHANGE_TYPE' THEN

Line 3279: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

3275: ,p_token_2 => 'PRODUCT_NAME'
3276: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3277: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3278: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3279: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3280: END IF;
3281:
3282: WHEN 'PARTY_CHANGE_TYPE' THEN
3283: IF p_rec_acct_attrs.array_char_value.EXISTS(i) THEN

Line 3318: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

3314:
3315: WHEN 'GL_DATE' THEN
3316: g_rec_header_new.array_gl_date(g_header_idx) := trunc(p_rec_acct_attrs.array_date_value(i));
3317: IF p_rec_acct_attrs.array_date_value(i) is NULL THEN
3318: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
3319: xla_accounting_err_pkg.build_message
3320: (p_appli_s_name => 'XLA'
3321: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3322: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 3325: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

3321: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3322: ,p_token_1 => 'ACCT_ATTR_NAME'
3323: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
3324: ,p_token_2 => 'PRODUCT_NAME'
3325: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3326: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3327: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3328: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3329: END IF;

Line 3326: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

3322: ,p_token_1 => 'ACCT_ATTR_NAME'
3323: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
3324: ,p_token_2 => 'PRODUCT_NAME'
3325: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3326: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3327: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3328: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3329: END IF;
3330: ELSE null;

Line 3327: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

3323: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
3324: ,p_token_2 => 'PRODUCT_NAME'
3325: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3326: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3327: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3328: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3329: END IF;
3330: ELSE null;
3331: END CASE;

Line 3328: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

3324: ,p_token_2 => 'PRODUCT_NAME'
3325: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3326: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3327: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3328: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3329: END IF;
3330: ELSE null;
3331: END CASE;
3332: end loop;

Line 3427: FORALL i IN xla_ae_journal_entry_pkg.g_array_ae_header_id.FIRST .. xla_ae_journal_entry_pkg.g_array_ae_header_id.LAST

3423: -- AND xah.ae_header_id = tmp.ae_header_id
3424: -- and tmp.TRANSACTION_DATE >= XAH.PERIOD_START_DATE /* added vdamerla bug 8898196 */));
3425:
3426:
3427: FORALL i IN xla_ae_journal_entry_pkg.g_array_ae_header_id.FIRST .. xla_ae_journal_entry_pkg.g_array_ae_header_id.LAST
3428: UPDATE /*+ index(xah XLA_AE_HEADERS_GT_U1) */ xla_ae_headers_gt xah --added U1 hint for bug#10229047
3429: SET accounting_date =
3430: DECODE(xah.acc_rev_gl_date_option,
3431: 'XLA_NEXT_DAY',

Line 3453: AND xah2.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i)

3449: AND gps.ledger_id = xah2.ledger_id
3450: AND gps.period_name = xah2.period_name
3451: AND d.transaction_date <= gps.end_date
3452: AND d.transaction_date >= gps.start_date
3453: AND xah2.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i)
3454: ORDER by CASE WHEN d.transaction_date = xah2.accounting_date
3455: THEN 0
3456: WHEN d.transaction_date < xah2.accounting_date
3457: THEN xah2.accounting_date - d.transaction_date

Line 3463: WHERE xah.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i);

3459: THEN 1000 + d.transaction_date - xah2.accounting_date
3460: END ) tmp
3461: WHERE ROWNUM = 1 )
3462: )
3463: WHERE xah.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i);
3464:
3465:
3466: -- above query will always update rows, even if all days are business days, same accounting date will be
3467: -- restamped, as a result, removed the l_count > 0 check in below query, only retained l_count for fnd logging

Line 3473: FOR i IN 1..xla_ae_journal_entry_pkg.g_array_ae_header_id.COUNT

3469: l_count := 0;
3470:
3471: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3472:
3473: FOR i IN 1..xla_ae_journal_entry_pkg.g_array_ae_header_id.COUNT
3474: LOOP
3475: l_count := SQL%BULK_ROWCOUNT(i) + l_count;
3476: END LOOP;
3477:

Line 3492: FORALL i IN xla_ae_journal_entry_pkg.g_array_ae_header_id.FIRST .. xla_ae_journal_entry_pkg.g_array_ae_header_id.LAST

3488: --IF l_count > 0 THEN
3489: --
3490: --
3491: -- added hints for the perf change via bug#10047074
3492: FORALL i IN xla_ae_journal_entry_pkg.g_array_ae_header_id.FIRST .. xla_ae_journal_entry_pkg.g_array_ae_header_id.LAST
3493: UPDATE /*+ INDEX(XAL XLA_AE_LINES_GT_N4) */ xla_ae_lines_gt XAL
3494: SET XAL.ACCOUNTING_DATE = (SELECT /*+ INDEX(xah XLA_AE_HEADERS_GT_U1) */xah.accounting_date
3495: FROM xla_ae_headers_gt xah
3496: WHERE xah.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i)

Line 3496: WHERE xah.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i)

3492: FORALL i IN xla_ae_journal_entry_pkg.g_array_ae_header_id.FIRST .. xla_ae_journal_entry_pkg.g_array_ae_header_id.LAST
3493: UPDATE /*+ INDEX(XAL XLA_AE_LINES_GT_N4) */ xla_ae_lines_gt XAL
3494: SET XAL.ACCOUNTING_DATE = (SELECT /*+ INDEX(xah XLA_AE_HEADERS_GT_U1) */xah.accounting_date
3495: FROM xla_ae_headers_gt xah
3496: WHERE xah.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i)
3497: and xah.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3498: and xah.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3499: and xah.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i)
3500: )

Line 3497: and xah.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)

3493: UPDATE /*+ INDEX(XAL XLA_AE_LINES_GT_N4) */ xla_ae_lines_gt XAL
3494: SET XAL.ACCOUNTING_DATE = (SELECT /*+ INDEX(xah XLA_AE_HEADERS_GT_U1) */xah.accounting_date
3495: FROM xla_ae_headers_gt xah
3496: WHERE xah.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i)
3497: and xah.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3498: and xah.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3499: and xah.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i)
3500: )
3501: WHERE xal.ae_header_id = xla_ae_journal_entry_pkg.g_array_event_id(i)

Line 3498: and xah.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)

3494: SET XAL.ACCOUNTING_DATE = (SELECT /*+ INDEX(xah XLA_AE_HEADERS_GT_U1) */xah.accounting_date
3495: FROM xla_ae_headers_gt xah
3496: WHERE xah.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i)
3497: and xah.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3498: and xah.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3499: and xah.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i)
3500: )
3501: WHERE xal.ae_header_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3502: and xal.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)

Line 3499: and xah.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i)

3495: FROM xla_ae_headers_gt xah
3496: WHERE xah.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i)
3497: and xah.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3498: and xah.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3499: and xah.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i)
3500: )
3501: WHERE xal.ae_header_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3502: and xal.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3503: and xal.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)

Line 3501: WHERE xal.ae_header_id = xla_ae_journal_entry_pkg.g_array_event_id(i)

3497: and xah.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3498: and xah.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3499: and xah.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i)
3500: )
3501: WHERE xal.ae_header_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3502: and xal.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3503: and xal.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3504: and xal.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i);
3505:

Line 3502: and xal.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)

3498: and xah.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3499: and xah.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i)
3500: )
3501: WHERE xal.ae_header_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3502: and xal.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3503: and xal.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3504: and xal.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i);
3505:
3506:

Line 3503: and xal.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)

3499: and xah.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i)
3500: )
3501: WHERE xal.ae_header_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3502: and xal.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3503: and xal.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3504: and xal.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i);
3505:
3506:
3507:

Line 3504: and xal.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i);

3500: )
3501: WHERE xal.ae_header_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3502: and xal.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)
3503: and xal.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3504: and xal.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i);
3505:
3506:
3507:
3508: l_count := SQL%ROWCOUNT;