DBA Data[Home] [Help]

APPS.XLA_AE_HEADER_PKG dependencies on XLA_AE_LINES

Line 32: | xla_ae_lines_gt, xla_je_headers_gt by |

28: | 28-APR-2003 K.Boussema Added validation of Accounting Event Extract |
29: | bug 2925651 |
30: | 06-MAI-2003 K.Boussema Modifcation included for bug2936071 |
31: | 13-MAI-2003 K.Boussema Renamed temporary tables xla_je_lines_gt by |
32: | xla_ae_lines_gt, xla_je_headers_gt by |
33: | xla_ae_headers_gt |
34: | Renamed in xla_distribution_links the column |
35: | base_amount by ledger_amount |
36: | 20-MAI-2003 K.Boussema Added a Token to XLA_AP_CANNOT_INSERT_JE |

Line 57: | 12-DEC-2003 K. Boussema Renamed target_coa_id in xla_ae_lines_gt |

53: | 22-OCT-2003 K.Boussema Changed to capture the Merge Matching Lines |
54: | preference for Accounting Reversal from JLT |
55: | 26-NOV-2003 K.Boussema Removed the insert of the sl_coa_mapping name|
56: | for change third party lines, bug 3278955 |
57: | 12-DEC-2003 K. Boussema Renamed target_coa_id in xla_ae_lines_gt |
58: | by ccid_coa_id |
59: | Reviewed the InsertHeaders, bug 3042840 |
60: | 18-DEC-2003 K.Boussema Changed to fix bug 3042840,3307761,3268940 |
61: | 3310291 and 3320689 |

Line 1524: -- XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1);

1520: -----------------------------------------------------------
1521: -- create recognition line - for Recognition JLT1
1522: -----------------------------------------------------------
1523: -- changed the call of CopyLineInfo to pass the data source for copy process: bug-7109881
1524: -- XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1);
1525: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1 , XLA_AE_LINES_PKG.g_mpa_recog_lines );
1526: -- bug9954676
1527: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1528: , p_recog_line_num_1

Line 1525: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1 , XLA_AE_LINES_PKG.g_mpa_recog_lines );

1521: -- create recognition line - for Recognition JLT1
1522: -----------------------------------------------------------
1523: -- changed the call of CopyLineInfo to pass the data source for copy process: bug-7109881
1524: -- XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1);
1525: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1 , XLA_AE_LINES_PKG.g_mpa_recog_lines );
1526: -- bug9954676
1527: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1528: , p_recog_line_num_1
1529: , XLA_AE_LINES_PKG.g_LineNumber );

Line 1527: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)

1523: -- changed the call of CopyLineInfo to pass the data source for copy process: bug-7109881
1524: -- XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1);
1525: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1 , XLA_AE_LINES_PKG.g_mpa_recog_lines );
1526: -- bug9954676
1527: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1528: , p_recog_line_num_1
1529: , XLA_AE_LINES_PKG.g_LineNumber );
1530: --**************************************************************************************************************
1531: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id

Line 1529: , XLA_AE_LINES_PKG.g_LineNumber );

1525: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1 , XLA_AE_LINES_PKG.g_mpa_recog_lines );
1526: -- bug9954676
1527: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1528: , p_recog_line_num_1
1529: , XLA_AE_LINES_PKG.g_LineNumber );
1530: --**************************************************************************************************************
1531: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1532: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1533: --,p_header_num => i); -- original multiple JLT

Line 1531: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id

1527: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1528: , p_recog_line_num_1
1529: , XLA_AE_LINES_PKG.g_LineNumber );
1530: --**************************************************************************************************************
1531: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1532: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1533: --,p_header_num => i); -- original multiple JLT
1534: --**************************************************************************************************************
1535: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);

Line 1535: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);

1531: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1532: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1533: --,p_header_num => i); -- original multiple JLT
1534: --**************************************************************************************************************
1535: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1536: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1537: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302
1538:
1539: -- 4955764

Line 1536: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);

1532: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1533: --,p_header_num => i); -- original multiple JLT
1534: --**************************************************************************************************************
1535: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1536: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1537: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302
1538:
1539: -- 4955764
1540: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=

Line 1537: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302

1533: --,p_header_num => i); -- original multiple JLT
1534: --**************************************************************************************************************
1535: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1536: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1537: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302
1538:
1539: -- 4955764
1540: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1541: g_rec_header_new.array_gl_date(l_hdr_idx);

Line 1540: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=

1536: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1537: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302
1538:
1539: -- 4955764
1540: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1541: g_rec_header_new.array_gl_date(l_hdr_idx);
1542:
1543: XLA_AE_LINES_PKG.ValidateCurrentLine;
1544: XLA_AE_LINES_PKG.SetDebitCreditAmounts;

Line 1543: XLA_AE_LINES_PKG.ValidateCurrentLine;

1539: -- 4955764
1540: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1541: g_rec_header_new.array_gl_date(l_hdr_idx);
1542:
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

Line 1544: XLA_AE_LINES_PKG.SetDebitCreditAmounts;

1540: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1541: g_rec_header_new.array_gl_date(l_hdr_idx);
1542:
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');

Line 1554: -- XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2);

1550: -----------------------------------------------------------
1551: -- create recognition line - for Recognition JLT2
1552: -----------------------------------------------------------
1553: -- changed the call of CopyLineInfo to pass the data source for copy process: bug-7109881
1554: -- XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2);
1555: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2 , XLA_AE_LINES_PKG.g_mpa_recog_lines );
1556: -- bug9954676
1557: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1558: , p_recog_line_num_2

Line 1555: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2 , XLA_AE_LINES_PKG.g_mpa_recog_lines );

1551: -- create recognition line - for Recognition JLT2
1552: -----------------------------------------------------------
1553: -- changed the call of CopyLineInfo to pass the data source for copy process: bug-7109881
1554: -- XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2);
1555: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2 , XLA_AE_LINES_PKG.g_mpa_recog_lines );
1556: -- bug9954676
1557: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1558: , p_recog_line_num_2
1559: , XLA_AE_LINES_PKG.g_LineNumber );

Line 1557: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)

1553: -- changed the call of CopyLineInfo to pass the data source for copy process: bug-7109881
1554: -- XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2);
1555: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2 , XLA_AE_LINES_PKG.g_mpa_recog_lines );
1556: -- bug9954676
1557: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1558: , p_recog_line_num_2
1559: , XLA_AE_LINES_PKG.g_LineNumber );
1560: --**************************************************************************************************************
1561: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id

Line 1559: , XLA_AE_LINES_PKG.g_LineNumber );

1555: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2 , XLA_AE_LINES_PKG.g_mpa_recog_lines );
1556: -- bug9954676
1557: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1558: , p_recog_line_num_2
1559: , XLA_AE_LINES_PKG.g_LineNumber );
1560: --**************************************************************************************************************
1561: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1562: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1563: --,p_header_num => i); -- original multiple JLT

Line 1561: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id

1557: XLA_AE_LINES_PKG.CopyMpaTrxAcctCopyInfo( XLA_AE_LINES_PKG.g_rec_lines.array_ae_header_id(XLA_AE_LINES_PKG.g_LineNumber)
1558: , p_recog_line_num_2
1559: , XLA_AE_LINES_PKG.g_LineNumber );
1560: --**************************************************************************************************************
1561: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1562: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1563: --,p_header_num => i); -- original multiple JLT
1564: --**************************************************************************************************************
1565: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);

Line 1565: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);

1561: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1562: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1563: --,p_header_num => i); -- original multiple JLT
1564: --**************************************************************************************************************
1565: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1566: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1567: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302
1568:
1569: -- 4955764

Line 1566: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);

1562: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1563: --,p_header_num => i); -- original multiple JLT
1564: --**************************************************************************************************************
1565: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1566: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1567: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302
1568:
1569: -- 4955764
1570: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=

Line 1567: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302

1563: --,p_header_num => i); -- original multiple JLT
1564: --**************************************************************************************************************
1565: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1566: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1567: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302
1568:
1569: -- 4955764
1570: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1571: g_rec_header_new.array_gl_date(l_hdr_idx);

Line 1570: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=

1566: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1567: XLA_AE_LINES_PKG.g_rec_lines.array_bflow_applied_to_amt (XLA_AE_LINES_PKG.g_LineNumber) := p_bflow_applied_to_amts(i); -- 5132302
1568:
1569: -- 4955764
1570: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1571: g_rec_header_new.array_gl_date(l_hdr_idx);
1572: XLA_AE_LINES_PKG.ValidateCurrentLine;
1573: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1574:

Line 1572: XLA_AE_LINES_PKG.ValidateCurrentLine;

1568:
1569: -- 4955764
1570: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
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');

Line 1573: XLA_AE_LINES_PKG.SetDebitCreditAmounts;

1569: -- 4955764
1570: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
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:

Line 2140: (SELECT /*+ INDEX (AEL, XLA_AE_LINES_GT_N3) */ -- 4752774 -- changed in 8319065 performance changes

2136: , accrual_reversal_flag -- 4262811
2137: , acc_rev_gl_date_option -- 4262811
2138: , parent_header_id -- 4262811
2139: , parent_ae_line_num) -- 4262811
2140: (SELECT /*+ INDEX (AEL, XLA_AE_LINES_GT_N3) */ -- 4752774 -- changed in 8319065 performance changes
2141: g_rec_header_new.array_event_id(Idx)
2142: , CASE ael.balance_type_code
2143: when C_BUDGET THEN
2144: g_rec_header_new.array_budget_status(Idx)

Line 2284: FROM xla_ae_lines_gt ael

2280: , g_rec_header_new.array_accrual_reversal_flag(Idx) -- 4262811
2281: , g_rec_header_new.array_acc_rev_gl_date_option(Idx) -- 4262811
2282: , g_rec_header_new.array_parent_header_id(Idx) -- 4262811
2283: , g_rec_header_new.array_parent_line_num(Idx) -- 4262811
2284: FROM xla_ae_lines_gt ael
2285: WHERE ael.ae_header_id = g_rec_header_new.array_event_id(Idx)
2286: AND ael.ledger_id = g_rec_header_new.array_target_ledger_id(Idx)
2287: AND (nvl(ael.gain_or_loss_flag, 'N') <> 'Y' or nvl(ael.calculate_g_l_amts_flag, 'N') <> 'Y')
2288: AND ael.header_num =

Line 2376: (p_msg => 'SQL - Insert into xla_ae_lines_gt '

2372: --
2373: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2374:
2375: trace
2376: (p_msg => 'SQL - Insert into xla_ae_lines_gt '
2377: ,p_level => C_LEVEL_STATEMENT
2378: ,p_module => l_log_module);
2379: END IF;
2380: --

Line 2381: INSERT INTO xla_ae_lines_gt

2377: ,p_level => C_LEVEL_STATEMENT
2378: ,p_module => l_log_module);
2379: END IF;
2380: --
2381: INSERT INTO xla_ae_lines_gt
2382: (
2383: ae_header_id
2384: , temp_line_num
2385: , event_id

Line 2561: , XLA_AE_LINES_PKG.SetLineNum(xah.balance_type_code)

2557: WHEN C_ACTUAL THEN g_rec_header_new.array_actual_header_id(g_header_idx)
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

Line 2734: FROM xla_ae_lines xal,

2730: , 'N' -- 4262811 mpa_accrual_entry_flag
2731: , xal.encumbrance_type_id -- 4458381 Public Sector Enh
2732: , 0 -- 5100860 assign value to avoid using function index
2733: --
2734: FROM xla_ae_lines xal,
2735: xla_ae_headers xah,
2736: xla_distribution_links xdl,
2737: xla_events xe,
2738: (SELECT ae_header_id

Line 2887: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT

2883:
2884: IF (C_LEVEL_EVENT >= g_log_level) THEN
2885:
2886: trace
2887: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT
2888: ,p_level => C_LEVEL_EVENT
2889: ,p_module => l_log_module);
2890:
2891: END IF;

Line 2900: (p_msg => 'SQL - Insert into xla_ae_lines_gt '

2896: --
2897: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2898:
2899: trace
2900: (p_msg => 'SQL - Insert into xla_ae_lines_gt '
2901: ,p_level => C_LEVEL_STATEMENT
2902: ,p_module => l_log_module);
2903: END IF;
2904: --

Line 2906: INSERT INTO xla_ae_lines_gt

2902: ,p_module => l_log_module);
2903: END IF;
2904: --
2905: --
2906: INSERT INTO xla_ae_lines_gt
2907: (
2908: ae_header_id
2909: , temp_line_num
2910: , event_id

Line 2986: , XLA_AE_LINES_PKG.SetLineNum(xah.balance_type_code)

2982: WHEN C_ACTUAL THEN g_rec_header_new.array_actual_header_id(g_header_idx)
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

Line 3059: FROM xla_ae_lines xal,

3055: , 'N' -- 4262811 mpa_accrual_entry_flag
3056: , xal.encumbrance_type_id -- 4458381 Public Sector Enh
3057: , 0 -- 5100860 assign value to avoid using function index
3058: --
3059: FROM xla_ae_lines xal,
3060: xla_ae_headers xah,
3061: xla_distribution_links xdl,
3062: xla_events xe
3063: WHERE xe.event_id = xdl.event_id

Line 3085: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT

3081: --
3082: IF (C_LEVEL_EVENT >= g_log_level) THEN
3083:
3084: trace
3085: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT
3086: ,p_level => C_LEVEL_EVENT
3087: ,p_module => l_log_module);
3088: END IF;
3089:

Line 3493: UPDATE /*+ INDEX(XAL XLA_AE_LINES_GT_N4) */ xla_ae_lines_gt XAL

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)
3497: and xah.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)

Line 3512: (p_msg => '# rows updated in xla_ae_lines_gt(date_adjust) =' || l_count

3508: l_count := SQL%ROWCOUNT;
3509:
3510: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3511: trace
3512: (p_msg => '# rows updated in xla_ae_lines_gt(date_adjust) =' || l_count
3513: ,p_level => C_LEVEL_STATEMENT
3514: ,p_module => l_log_module);
3515: END IF;
3516: