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_FSAH_INT_PVT dependencies on XLA_AE_HEADERS

Line 204: FROM xla_ae_headers xah,

200: xah.attribute4, xah.attribute5, xah.attribute6,
201: xah.attribute7, xah.attribute8, xah.attribute9,
202: xah.attribute10, xah.attribute11, xah.attribute12,
203: xah.attribute13, xah.attribute14, xah.attribute15
204: FROM xla_ae_headers xah,
205: xla_events xe,
206: xla_transaction_entities xte
207: WHERE xte.entity_id = xah.entity_id
208: AND xte.application_id = xah.application_id

Line 363: FROM xla_ae_headers

359: -- CALLED FROM CREATE_REVERSAL_ENTRY
360: --
361: SELECT event_id
362: INTO l_ref_event_id
363: FROM xla_ae_headers
364: WHERE application_id = p_application_id
365: AND ae_header_id = p_ref_ae_header_id;
366: END IF;
367:

Line 396: FROM xla_ae_headers xah, xla_ae_lines xal

392: c_event_type_code_manual -- EVENT TYPE CODE
393: ,
394: xal.unrounded_entered_dr, xal.unrounded_entered_cr,
395: xal.unrounded_accounted_dr, xal.unrounded_accounted_cr
396: FROM xla_ae_headers xah, xla_ae_lines xal
397: WHERE xah.application_id = p_application_id
398: AND xah.ae_header_id = p_ae_header_id
399: AND xal.application_id = xah.application_id
400: AND xal.ae_header_id = xah.ae_header_id;

Line 511: TYPE t_ae_header_id IS TABLE OF xla_ae_headers.ae_header_id%TYPE;

507: p_rev_header_id OUT NOCOPY INTEGER,
508: p_rev_event_id OUT NOCOPY INTEGER
509: )
510: IS
511: TYPE t_ae_header_id IS TABLE OF xla_ae_headers.ae_header_id%TYPE;
512:
513: l_event_source_info xla_events_pub_pkg.t_event_source_info;
514: l_entity_id INTEGER;
515: l_period_name VARCHAR2 (30);

Line 643: FROM xla_ae_headers

639: --
640: BEGIN
641: SELECT ae_header_id
642: BULK COLLECT INTO l_ae_header_id
643: FROM xla_ae_headers
644: WHERE event_id = p_info.event_id;
645: EXCEPTION
646: WHEN OTHERS
647: THEN

Line 668: INSERT INTO xla_ae_headers

664: p_info.application_id,
665: g_msg_mode
666: );
667:
668: INSERT INTO xla_ae_headers
669: (ae_header_id, application_id,
670: ledger_id, entity_id, event_id,
671: event_type_code, accounting_date, period_name,
672: reference_date, balance_type_code,

Line 681: VALUES (xla_ae_headers_s.NEXTVAL, l_info.application_id,

677: creation_date, created_by, last_update_date,
678: last_updated_by, last_update_login,
679: accrual_reversal_flag
680: )
681: VALUES (xla_ae_headers_s.NEXTVAL, l_info.application_id,
682: l_info.ledger_id, l_entity_id, p_rev_event_id,
683: c_event_type_code_manual,trunc(p_gl_date), l_period_name,
684: l_info.reference_date, l_info.balance_type_code,
685: l_info.budget_version_id, c_gl_transfer_mode_no,

Line 877: xla_ae_headers xah,

873: xah.ae_header_id, xah.accounting_date, xah.ledger_id,
874: e.legal_entity_id, xah.accrual_reversal_flag,
875: xe.budgetary_control_flag
876: FROM xla_gl_ledgers_v xgl,
877: xla_ae_headers xah,
878: xla_subledgers xsu,
879: xla_transaction_entities e,
880: xla_events xe
881: WHERE xgl.ledger_id = xah.ledger_id

Line 894: FROM xla_ae_headers xah2

890: AND xah.accounting_entry_status_code = c_status_final_code
891: AND xah.parent_ae_header_id IS NULL
892: AND NOT EXISTS (
893: SELECT 1
894: FROM xla_ae_headers xah2
895: WHERE xah2.application_id = p_application_id
896: AND xah2.event_id = p_event_id
897: AND xah2.accounting_entry_status_code =
898: c_status_final_code

Line 914: TYPE t_ae_header_id IS TABLE OF xla_ae_headers.ae_header_id%TYPE;

910: l_mpa_acc_rev_flag VARCHAR2 (1);
911: l_bc_flag VARCHAR2 (1);
912: l_transfer_request_id INTEGER;
913:
914: TYPE t_ae_header_id IS TABLE OF xla_ae_headers.ae_header_id%TYPE;
915:
916: l_ae_header_id INTEGER;
917: l_event_source_info xla_events_pub_pkg.t_event_source_info;
918: l_array_ae_header_id t_array_integer;

Line 1197: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_headers');

1193: --DBMS_OUTPUT.put_line ('After Updating the xla_transaction_entities');
1194: ------------------------------------------------------------------------------
1195: -- HEADERS TABLE UPDATE
1196: ------------------------------------------------------------------------------
1197: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_headers');
1198:
1199: IF (c_level_procedure >= g_log_level)
1200: THEN
1201: TRACE (p_msg => 'Before Updating the xla_ae_headers',

Line 1201: TRACE (p_msg => 'Before Updating the xla_ae_headers',

1197: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_headers');
1198:
1199: IF (c_level_procedure >= g_log_level)
1200: THEN
1201: TRACE (p_msg => 'Before Updating the xla_ae_headers',
1202: p_level => c_level_procedure,
1203: p_module => l_log_module
1204: );
1205: END IF;

Line 1207: UPDATE xla_ae_headers

1203: p_module => l_log_module
1204: );
1205: END IF;
1206:
1207: UPDATE xla_ae_headers
1208: SET entity_id = x_new_entity_id,
1209: event_id = x_new_event_id,
1210: event_type_code = 'REVERSAL',
1211: description = 'DATA FIX ENTRY: EVENT_ID OF ' || p_event_id

Line 1218: TRACE (p_msg => 'After Updating the xla_ae_headers',

1214: BULK COLLECT INTO l_array_ae_header_id;
1215:
1216: IF (c_level_procedure >= g_log_level)
1217: THEN
1218: TRACE (p_msg => 'After Updating the xla_ae_headers',
1219: p_level => c_level_procedure,
1220: p_module => l_log_module
1221: );
1222: END IF;

Line 1224: --DBMS_OUTPUT.put_line ('After Updating the xla_ae_headers1');

1220: p_module => l_log_module
1221: );
1222: END IF;
1223:
1224: --DBMS_OUTPUT.put_line ('After Updating the xla_ae_headers1');
1225: ------------------------------------------------------------------------------
1226: -- LINES TABLE UPDATE
1227: ------------------------------------------------------------------------------
1228: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_lines');

Line 1292: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_headers2');

1288: -----------------------------------------------------------------------------------
1289: -- CURRENTLY, XLA_JOURNAL_ENTRIES_PKG.REVERSE_JOURNAL_ENTRY ONLY PROCESS REVERSAL ENTRY
1290: -----------------------------------------------------------------------------------
1291:
1292: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_headers2');
1293:
1294: IF (c_level_procedure >= g_log_level)
1295: THEN
1296: TRACE (p_msg => 'Before Updating the xla_ae_headers2',

Line 1296: TRACE (p_msg => 'Before Updating the xla_ae_headers2',

1292: --DBMS_OUTPUT.put_line ('Before Updating the xla_ae_headers2');
1293:
1294: IF (c_level_procedure >= g_log_level)
1295: THEN
1296: TRACE (p_msg => 'Before Updating the xla_ae_headers2',
1297: p_level => c_level_procedure,
1298: p_module => l_log_module
1299: );
1300: END IF;

Line 1302: UPDATE xla_ae_headers

1298: p_module => l_log_module
1299: );
1300: END IF;
1301:
1302: UPDATE xla_ae_headers
1303: SET accounting_entry_type_code = 'REVERSAL'
1304: WHERE application_id = p_application_id AND event_id = x_new_event_id;
1305:
1306: IF (c_level_procedure >= g_log_level)

Line 1308: TRACE (p_msg => 'After Updating the xla_ae_headers2',

1304: WHERE application_id = p_application_id AND event_id = x_new_event_id;
1305:
1306: IF (c_level_procedure >= g_log_level)
1307: THEN
1308: TRACE (p_msg => 'After Updating the xla_ae_headers2',
1309: p_level => c_level_procedure,
1310: p_module => l_log_module
1311: );
1312: END IF;

Line 1314: --DBMS_OUTPUT.put_line ('After Updating the xla_ae_headers2');

1310: p_module => l_log_module
1311: );
1312: END IF;
1313:
1314: --DBMS_OUTPUT.put_line ('After Updating the xla_ae_headers2');
1315: --------------------------------------------------------
1316: -- REVERSE JOURNAL ENTRIES
1317: --------------------------------------------------------
1318: --DBMS_OUTPUT.put_line ('x_new_event_id ' || x_new_event_id);

Line 1330: from xla_ae_headers where event_id = x_new_event_id ;

1326: END IF;
1327:
1328: /*select count(*) into
1329: l_ae_header_id_count
1330: from xla_ae_headers where event_id = x_new_event_id ;
1331:
1332: --DBMS_OUTPUT.put_line ('l_ae_header_id_count ' || l_ae_header_id_count);*/
1333: BEGIN
1334: SELECT ae_header_id

Line 1336: FROM xla_ae_headers

1332: --DBMS_OUTPUT.put_line ('l_ae_header_id_count ' || l_ae_header_id_count);*/
1333: BEGIN
1334: SELECT ae_header_id
1335: INTO l_ae_header_id
1336: FROM xla_ae_headers
1337: WHERE event_id = x_new_event_id AND ROWNUM = 1;
1338: EXCEPTION
1339: WHEN OTHERS
1340: THEN

Line 1404: TRACE (p_msg => 'Updating the xla_ae_headers3 with the Description',

1400:
1401:
1402: IF (c_level_statement >= g_log_level)
1403: THEN
1404: TRACE (p_msg => 'Updating the xla_ae_headers3 with the Description',
1405: p_module => l_log_module,
1406: p_level => c_level_statement
1407: );
1408: END IF;

Line 1416: UPDATE xla_ae_headers

1412: event_status_code = 'P',
1413: process_status_code = 'P'
1414: WHERE event_id = x_rev_event_id;
1415:
1416: UPDATE xla_ae_headers
1417: SET /*description =
1418: 'DATA FIX REVERSAL ENTRY: EVENT_ID OF '
1419: || p_event_id,*/
1420: event_type_code = 'REVERSAL'

Line 1428: TRACE (p_msg => 'After Updating the xla_ae_headers3 with the Description',

1424: BULK COLLECT INTO l_array_ae_header_id;
1425:
1426: IF (c_level_statement >= g_log_level)
1427: THEN
1428: TRACE (p_msg => 'After Updating the xla_ae_headers3 with the Description',
1429: p_module => l_log_module,
1430: p_level => c_level_statement
1431: );
1432: END IF;

Line 1564: FROM xla_ae_headers

1560: -- collecting the data for reversal
1561: BEGIN
1562: SELECT event_id, application_id,accounting_date
1563: INTO l_event_id, l_application_id,l_gl_date
1564: FROM xla_ae_headers
1565: WHERE ae_header_id = p_ae_header_id;
1566: EXCEPTION
1567: WHEN OTHERS
1568: THEN

Line 1577: FROM xla_ae_headers xah,

1573:
1574: /* BEGIN
1575: SELECT xte.security_id_int_1
1576: INTO l_security_id_int_1
1577: FROM xla_ae_headers xah,
1578: xla_events xe,
1579: xla_transaction_entities xte
1580: WHERE xah.ae_header_id = p_ae_header_id
1581: AND xah.event_id = xe.event_id

Line 1691: FROM xla_ae_headers

1687: FOR i IN p_list_ae_header_id.FIRST .. p_list_ae_header_id.LAST
1688: LOOP
1689: SELECT ledger_id
1690: INTO l_first_ledger_id
1691: FROM xla_ae_headers
1692: WHERE ae_header_id = p_list_ae_header_id (i);
1693: END LOOP;
1694:
1695: FOR j IN p_list_ae_header_id.FIRST .. p_list_ae_header_id.LAST

Line 1699: FROM xla_ae_headers

1695: FOR j IN p_list_ae_header_id.FIRST .. p_list_ae_header_id.LAST
1696: LOOP
1697: SELECT ledger_id
1698: INTO l_ledger_id
1699: FROM xla_ae_headers
1700: WHERE ae_header_id = p_list_ae_header_id (j);
1701:
1702: IF l_ledger_id <> l_first_ledger_id
1703: THEN

Line 1829: l_group_id xla_ae_headers.GROUP_ID%TYPE;

1825: )
1826: RETURN NUMBER
1827: IS
1828: --Declaring Process Variables
1829: l_group_id xla_ae_headers.GROUP_ID%TYPE;
1830: l_log_module VARCHAR2 (240);
1831: l_pro_records NUMBER;
1832: l_ledger_status VARCHAR2 (100);
1833: l_primary VARCHAR2 (100);

Line 1907: FROM xla_ae_headers

1903: END IF;
1904:
1905: SELECT ae_header_id
1906: BULK COLLECT INTO l_arry_ae_hdr_id
1907: FROM xla_ae_headers
1908: WHERE gl_transfer_status_code = 'N'
1909: AND accounting_entry_status_code = 'F'
1910: AND application_id = l_application_id
1911: AND accounting_date <= p_end_date

Line 1935: TRACE (p_msg => 'Before Updating the group_id and Status in xla_ae_headers',

1931: l_group_id := -1;
1932: ELSE
1933: IF (c_level_statement >= g_log_level)
1934: THEN
1935: TRACE (p_msg => 'Before Updating the group_id and Status in xla_ae_headers',
1936: p_module => l_log_module,
1937: p_level => c_level_statement
1938: );
1939: END IF;

Line 1941: /* DBMS_OUTPUT.put_line ('Before Updating the group_id and Status in xla_ae_headers'

1937: p_level => c_level_statement
1938: );
1939: END IF;
1940:
1941: /* DBMS_OUTPUT.put_line ('Before Updating the group_id and Status in xla_ae_headers'
1942: );*/
1943:
1944: SELECT gl_journal_import_s.NEXTVAL
1945: INTO l_group_id

Line 2084: FROM xla_ae_headers

2080:
2081: -- Identifying the records to update
2082: SELECT ae_header_id
2083: BULK COLLECT INTO l_arry_ae_hdr_id_set
2084: FROM xla_ae_headers
2085: WHERE gl_transfer_status_code = 'N'
2086: AND accounting_entry_status_code = 'F'
2087: AND application_id = l_application_id
2088: AND accounting_date <= p_end_date

Line 2102: UPDATE xla_ae_headers

2098: /*DBMS_OUTPUT.put_line ( 'Total records identified to Updated = '
2099: || l_arry_ae_hdr_id_set.COUNT
2100: );*/
2101: FORALL i IN l_arry_ae_hdr_id_set.FIRST .. l_arry_ae_hdr_id_set.LAST
2102: UPDATE xla_ae_headers
2103: SET gl_transfer_status_code = 'S',
2104: GROUP_ID = p_group_id
2105: WHERE ae_header_id = l_arry_ae_hdr_id_set (i);
2106:

Line 2134: l_group_id xla_ae_headers.GROUP_ID%TYPE;

2130: IS
2131: ------------------------------------------------------------------------------------
2132: -- Declaring Local Variabls
2133: ------------------------------------------------------------------------------------
2134: l_group_id xla_ae_headers.GROUP_ID%TYPE;
2135: l_batch_status VARCHAR2 (10);
2136: l_records_updated NUMBER;
2137: l_return_status VARCHAR2 (100);
2138: l_msg_data VARCHAR2 (100);

Line 2172: UPDATE xla_ae_headers

2168: THEN
2169: ------------------------------------------------------------------------------------
2170: --Condition Sucess
2171: ------------------------------------------------------------------------------------
2172: UPDATE xla_ae_headers
2173: SET gl_transfer_status_code = 'Y',
2174: gl_transfer_date = TO_CHAR (SYSDATE, 'DD-MON-YYYY'),
2175: last_update_date = TO_CHAR (SYSDATE, 'DD-MON-YYYY'),
2176: last_updated_by = fnd_profile.VALUE ('USER_ID'),

Line 2198: UPDATE xla_ae_headers

2194: THEN
2195: ------------------------------------------------------------------------------------
2196: --Condition Failure
2197: ------------------------------------------------------------------------------------
2198: UPDATE xla_ae_headers
2199: SET GROUP_ID = NULL,
2200: gl_transfer_status_code = 'N',
2201: last_update_date = TO_CHAR (SYSDATE, 'DD-MON-YYYY'),
2202: last_updated_by = fnd_profile.VALUE ('USER_ID'),