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_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 1397: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1);

1393:
1394: -----------------------------------------------------------
1395: -- create recognition line - for Recognition JLT1
1396: -----------------------------------------------------------
1397: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1);
1398: --**************************************************************************************************************
1399: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1400: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1401: --,p_header_num => i); -- original multiple JLT

Line 1399: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id

1395: -- create recognition line - for Recognition JLT1
1396: -----------------------------------------------------------
1397: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_1);
1398: --**************************************************************************************************************
1399: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1400: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1401: --,p_header_num => i); -- original multiple JLT
1402: --**************************************************************************************************************
1403: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);

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

1399: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1400: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1401: --,p_header_num => i); -- original multiple JLT
1402: --**************************************************************************************************************
1403: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1404: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1405: 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
1406:
1407: -- 4955764

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

1400: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1401: --,p_header_num => i); -- original multiple JLT
1402: --**************************************************************************************************************
1403: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1404: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1405: 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
1406:
1407: -- 4955764
1408: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=

Line 1405: 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

1401: --,p_header_num => i); -- original multiple JLT
1402: --**************************************************************************************************************
1403: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1404: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1405: 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
1406:
1407: -- 4955764
1408: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1409: g_rec_header_new.array_gl_date(l_hdr_idx);

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

1404: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1405: 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
1406:
1407: -- 4955764
1408: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1409: g_rec_header_new.array_gl_date(l_hdr_idx);
1410:
1411: XLA_AE_LINES_PKG.ValidateCurrentLine;
1412: XLA_AE_LINES_PKG.SetDebitCreditAmounts;

Line 1411: XLA_AE_LINES_PKG.ValidateCurrentLine;

1407: -- 4955764
1408: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1409: g_rec_header_new.array_gl_date(l_hdr_idx);
1410:
1411: XLA_AE_LINES_PKG.ValidateCurrentLine;
1412: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1413:
1414: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1415: ,p_balance_type_code => 'A');

Line 1412: XLA_AE_LINES_PKG.SetDebitCreditAmounts;

1408: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1409: g_rec_header_new.array_gl_date(l_hdr_idx);
1410:
1411: XLA_AE_LINES_PKG.ValidateCurrentLine;
1412: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1413:
1414: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1415: ,p_balance_type_code => 'A');
1416:

Line 1420: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2);

1416:
1417: -----------------------------------------------------------
1418: -- create recognition line - for Recognition JLT2
1419: -----------------------------------------------------------
1420: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2);
1421: --**************************************************************************************************************
1422: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1423: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1424: --,p_header_num => i); -- original multiple JLT

Line 1422: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id

1418: -- create recognition line - for Recognition JLT2
1419: -----------------------------------------------------------
1420: XLA_AE_LINES_PKG.CopyLineInfo(p_recog_line_num_2);
1421: --**************************************************************************************************************
1422: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1423: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1424: --,p_header_num => i); -- original multiple JLT
1425: --**************************************************************************************************************
1426: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);

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

1422: XLA_AE_LINES_PKG.set_ae_header_id(p_ae_header_id => p_event_id
1423: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1424: --,p_header_num => i); -- original multiple JLT
1425: --**************************************************************************************************************
1426: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1427: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1428: 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
1429:
1430: -- 4955764

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

1423: ,p_header_num => g_mpa_line_num ); -- multiple JLT
1424: --,p_header_num => i); -- original multiple JLT
1425: --**************************************************************************************************************
1426: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1427: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1428: 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
1429:
1430: -- 4955764
1431: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=

Line 1428: 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

1424: --,p_header_num => i); -- original multiple JLT
1425: --**************************************************************************************************************
1426: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_accted_amts(i);
1427: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1428: 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
1429:
1430: -- 4955764
1431: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1432: g_rec_header_new.array_gl_date(l_hdr_idx);

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

1427: XLA_AE_LINES_PKG.g_rec_lines.array_entered_amount (XLA_AE_LINES_PKG.g_LineNumber) := p_entered_amts(i);
1428: 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
1429:
1430: -- 4955764
1431: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1432: g_rec_header_new.array_gl_date(l_hdr_idx);
1433: XLA_AE_LINES_PKG.ValidateCurrentLine;
1434: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1435:

Line 1433: XLA_AE_LINES_PKG.ValidateCurrentLine;

1429:
1430: -- 4955764
1431: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1432: g_rec_header_new.array_gl_date(l_hdr_idx);
1433: XLA_AE_LINES_PKG.ValidateCurrentLine;
1434: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1435:
1436: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1437: ,p_balance_type_code => 'A');

Line 1434: XLA_AE_LINES_PKG.SetDebitCreditAmounts;

1430: -- 4955764
1431: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1432: g_rec_header_new.array_gl_date(l_hdr_idx);
1433: XLA_AE_LINES_PKG.ValidateCurrentLine;
1434: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1435:
1436: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1437: ,p_balance_type_code => 'A');
1438:

Line 2001: (SELECT /+ INDEX (AEL, XLA_AE_LINES_GT_N2) / -- 4752774

1997: , accrual_reversal_flag -- 4262811
1998: , acc_rev_gl_date_option -- 4262811
1999: , parent_header_id -- 4262811
2000: , parent_ae_line_num) -- 4262811
2001: (SELECT /*+ INDEX (AEL, XLA_AE_LINES_GT_N2) */ -- 4752774
2002: g_rec_header_new.array_event_id(Idx)
2003: , CASE ael.balance_type_code
2004: when C_BUDGET THEN
2005: g_rec_header_new.array_budget_status(Idx)

Line 2145: FROM xla_ae_lines_gt ael

2141: , g_rec_header_new.array_accrual_reversal_flag(Idx) -- 4262811
2142: , g_rec_header_new.array_acc_rev_gl_date_option(Idx) -- 4262811
2143: , g_rec_header_new.array_parent_header_id(Idx) -- 4262811
2144: , g_rec_header_new.array_parent_line_num(Idx) -- 4262811
2145: FROM xla_ae_lines_gt ael
2146: WHERE ael.ae_header_id = g_rec_header_new.array_event_id(Idx)
2147: AND ael.ledger_id = g_rec_header_new.array_target_ledger_id(Idx)
2148: AND (nvl(ael.gain_or_loss_flag, 'N') <> 'Y' or nvl(ael.calculate_g_l_amts_flag, 'N') <> 'Y')
2149: -- AND nvl(ael.entered_amount,0) > 0

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

2228: --
2229: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2230:
2231: trace
2232: (p_msg => 'SQL - Insert into xla_ae_lines_gt '
2233: ,p_level => C_LEVEL_STATEMENT
2234: ,p_module => l_log_module);
2235: END IF;
2236: --

Line 2237: INSERT INTO xla_ae_lines_gt

2233: ,p_level => C_LEVEL_STATEMENT
2234: ,p_module => l_log_module);
2235: END IF;
2236: --
2237: INSERT INTO xla_ae_lines_gt
2238: (
2239: ae_header_id
2240: , temp_line_num
2241: , event_id

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

2413: WHEN C_ACTUAL THEN g_rec_header_new.array_actual_header_id(g_header_idx)
2414: WHEN C_BUDGET THEN g_rec_header_new.array_budget_header_id(g_header_idx)
2415: WHEN C_ENCUMBRANCE THEN g_rec_header_new.array_encumb_header_id(g_header_idx)
2416: END
2417: , XLA_AE_LINES_PKG.SetLineNum(xah.balance_type_code)
2418: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2419: --
2420: , xal.ae_header_id
2421: , xal.ae_line_num

Line 2590: FROM xla_ae_lines xal,

2586: , 'N' -- 4262811 mpa_accrual_entry_flag
2587: , xal.encumbrance_type_id -- 4458381 Public Sector Enh
2588: , 0 -- 5100860 assign value to avoid using function index
2589: --
2590: FROM xla_ae_lines xal,
2591: xla_ae_headers xah,
2592: xla_distribution_links xdl,
2593: xla_events xe,
2594: (SELECT ae_header_id

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

2739:
2740: IF (C_LEVEL_EVENT >= g_log_level) THEN
2741:
2742: trace
2743: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT
2744: ,p_level => C_LEVEL_EVENT
2745: ,p_module => l_log_module);
2746:
2747: END IF;

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

2752: --
2753: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2754:
2755: trace
2756: (p_msg => 'SQL - Insert into xla_ae_lines_gt '
2757: ,p_level => C_LEVEL_STATEMENT
2758: ,p_module => l_log_module);
2759: END IF;
2760: --

Line 2762: INSERT INTO xla_ae_lines_gt

2758: ,p_module => l_log_module);
2759: END IF;
2760: --
2761: --
2762: INSERT INTO xla_ae_lines_gt
2763: (
2764: ae_header_id
2765: , temp_line_num
2766: , event_id

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

2838: WHEN C_ACTUAL THEN g_rec_header_new.array_actual_header_id(g_header_idx)
2839: WHEN C_BUDGET THEN g_rec_header_new.array_budget_header_id(g_header_idx)
2840: WHEN C_ENCUMBRANCE THEN g_rec_header_new.array_encumb_header_id(g_header_idx)
2841: END
2842: , XLA_AE_LINES_PKG.SetLineNum(xah.balance_type_code)
2843: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2844: --
2845: , xal.ae_header_id
2846: , xal.ae_line_num

Line 2915: FROM xla_ae_lines xal,

2911: , 'N' -- 4262811 mpa_accrual_entry_flag
2912: , xal.encumbrance_type_id -- 4458381 Public Sector Enh
2913: , 0 -- 5100860 assign value to avoid using function index
2914: --
2915: FROM xla_ae_lines xal,
2916: xla_ae_headers xah,
2917: xla_distribution_links xdl,
2918: xla_events xe
2919: WHERE xe.event_id = xdl.event_id

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

2937: --
2938: IF (C_LEVEL_EVENT >= g_log_level) THEN
2939:
2940: trace
2941: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT
2942: ,p_level => C_LEVEL_EVENT
2943: ,p_module => l_log_module);
2944: END IF;
2945: