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_ACCOUNTING_ENGINE_PKG dependencies on XLA_AE_HEADERS_GT

Line 64: | from XLA_AE_LINES_GT and XLA_AE_HEADERS_GT |

60: | bug 3786968. |
61: | 23-Sep-2004 S.Singhania Made changes for the bulk peroformance.It has|
62: | changed the code at number of places. |
63: | 05-Oct-2004 S.Singhania Bug 3931752: Added code to remove dummy rows |
64: | from XLA_AE_LINES_GT and XLA_AE_HEADERS_GT |
65: | (rows with balance_type_code = 'X') in |
66: | PostAccountingEngine |
67: | 08-Oct-2004 S.Singhania Bug 3928357: Made changes to make sure the |
68: | following cases are handled: |

Line 888: FROM xla_ae_headers_gt

884: HAVING count(*) < aad_count;
885:
886: CURSOR c_je(x_event_type VARCHAR2) IS
887: SELECT entity_id, event_id
888: FROM xla_ae_headers_gt
889: WHERE event_type_code = x_event_type;
890:
891: l_array_event_type xla_ae_journal_entry_pkg.t_array_V30L;
892: l_count INTEGER;

Line 916: UPDATE xla_ae_headers_gt

912:
913: IF (l_array_event_type.COUNT > 0) THEN
914:
915: FORALL i IN 1..l_array_event_type.COUNT
916: UPDATE xla_ae_headers_gt
917: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID
918: ,event_status_code = 'I'
919: WHERE event_type_code = l_array_event_type(i);
920:

Line 925: (p_msg => '# rows updated in xla_ae_headers_gt ='||l_count

921: l_count := SQL%ROWCOUNT;
922:
923: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
924: trace
925: (p_msg => '# rows updated in xla_ae_headers_gt ='||l_count
926: ,p_level => C_LEVEL_STATEMENT
927: ,p_module => l_log_module);
928: END IF;
929:

Line 1111: DELETE FROM xla_ae_headers_gt

1107: DELETE FROM xla_ae_lines_gt
1108: WHERE balance_type_code = 'X'
1109: OR (unrounded_accounted_cr is null AND unrounded_accounted_dr is null AND gain_or_loss_flag = 'Y' AND calculate_g_l_amts_flag= 'Y');
1110:
1111: DELETE FROM xla_ae_headers_gt
1112: WHERE balance_type_code = 'X';
1113:
1114: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1115: trace

Line 1116: (p_msg => 'SQL- update xla_ae_headers_gt (1)'

1112: WHERE balance_type_code = 'X';
1113:
1114: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1115: trace
1116: (p_msg => 'SQL- update xla_ae_headers_gt (1)'
1117: ,p_level => C_LEVEL_STATEMENT
1118: ,p_module => l_log_module);
1119: END IF;
1120:

Line 1122: UPDATE xla_ae_headers_gt aeh

1118: ,p_module => l_log_module);
1119: END IF;
1120:
1121:
1122: UPDATE xla_ae_headers_gt aeh
1123: SET ae_header_id = xla_ae_headers_s.nextval
1124: ,(period_name
1125: , period_year
1126: , period_closing_status

Line 1148: (p_msg => '# rows updated in xla_ae_headers_gt(1) ='||SQL%ROWCOUNT

1144: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;
1145:
1146: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1147: trace
1148: (p_msg => '# rows updated in xla_ae_headers_gt(1) ='||SQL%ROWCOUNT
1149: ,p_level => C_LEVEL_STATEMENT
1150: ,p_module => l_log_module);
1151: END IF;
1152:

Line 1162: UPDATE xla_ae_headers_gt xah

1158: -- in a closed or permentently closed period
1159: -- 3. the accrual reversal gl date mode is Next Day but currenly the next day is
1160: -- in a future open period and the gl date is before the End GL date parameter
1161: --
1162: UPDATE xla_ae_headers_gt xah
1163: SET first_day_next_gl_period =
1164: (SELECT min(gps.start_date)
1165: FROM gl_period_statuses gps
1166: WHERE gps.application_id = 101

Line 1189: UPDATE xla_ae_headers_gt xah

1185: -- open GL period. Update the GL Date to the first day next GL period.
1186: --
1187: IF (SQL%ROWCOUNT > 0) THEN
1188:
1189: UPDATE xla_ae_headers_gt xah
1190: SET (accounting_date
1191: ,period_name
1192: ,period_year
1193: ,period_closing_status

Line 1205: FROM xla_ae_headers_gt xah2

1201: , NVL(gps.period_year, xah.period_year)
1202: , NVL(gps.closing_status, xah.period_closing_status)
1203: , NVL(gps.start_date, xah.period_start_date)
1204: , NVL(gps.end_date, xah.period_end_date)
1205: FROM xla_ae_headers_gt xah2
1206: , gl_period_statuses gps
1207: WHERE xah.ae_header_id = xah2.ae_header_id
1208: AND gps.application_id (+) = 101
1209: AND gps.ledger_id (+) = xah2.ledger_id

Line 1230: (p_msg => 'SQL- update xla_ae_headers_gt (2)'

1226: (p_ledger_id => p_ledger_id);
1227:
1228: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1229: trace
1230: (p_msg => 'SQL- update xla_ae_headers_gt (2)'
1231: ,p_level => C_LEVEL_STATEMENT
1232: ,p_module => l_log_module);
1233: END IF;
1234:

Line 1242: UPDATE xla_ae_headers_gt a

1238: ,p_min_event_date => p_min_event_date
1239: ,p_max_event_date => p_max_event_date);
1240:
1241:
1242: UPDATE xla_ae_headers_gt a
1243: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID
1244: ,event_status_code = 'I'
1245: WHERE accounting_entry_status_code = xla_ae_journal_entry_pkg.C_VALID
1246: AND EXISTS

Line 1248: FROM xla_ae_headers_gt

1244: ,event_status_code = 'I'
1245: WHERE accounting_entry_status_code = xla_ae_journal_entry_pkg.C_VALID
1246: AND EXISTS
1247: (SELECT /*+ HASH_SJ */ '1'
1248: FROM xla_ae_headers_gt
1249: WHERE event_id = a.event_id
1250: AND accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID);
1251:
1252:

Line 1255: (p_msg => '# rows updated in xla_ae_headers_gt(2) ='||SQL%ROWCOUNT

1251:
1252:
1253: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1254: trace
1255: (p_msg => '# rows updated in xla_ae_headers_gt(2) ='||SQL%ROWCOUNT
1256: ,p_level => C_LEVEL_STATEMENT
1257: ,p_module => l_log_module);
1258: END IF;
1259:

Line 1284: FROM xla_ae_headers_gt;

1280: -- the update
1281: --
1282: SELECT DISTINCT event_id, event_status_code BULK COLLECT
1283: INTO l_array_temp_events, l_array_temp_status
1284: FROM xla_ae_headers_gt;
1285:
1286: FORALL i IN 1..l_array_temp_events.COUNT
1287: UPDATE xla_events_gt
1288: SET process_status_code = DECODE(l_array_temp_status(i)