APPS.XLA_AE_HEADER_PKG dependencies on XLA_AE_LINES_GT

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