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.CST_RECEIPTACCRUALPEREND_PVT dependencies on XLA_EVENTS

Line 1164: DELETE FROM XLA_EVENTS_INT_GT;

1160: l_reference_date_1 := INV_LE_TIMEZONE_PUB.get_le_day_time_for_ou(
1161: p_sys_setup_rec.transaction_date,
1162: p_sys_setup_rec.org_id);
1163: l_stmt_num := 200;
1164: DELETE FROM XLA_EVENTS_INT_GT;
1165: l_stmt_num := 220;
1166: FORALL l_ctr IN g_rae_event_id_tbl.FIRST..g_rae_event_id_tbl.LAST
1167: /* Populate XLA Event GT */
1168: INSERT INTO XLA_EVENTS_INT_GT

Line 1168: INSERT INTO XLA_EVENTS_INT_GT

1164: DELETE FROM XLA_EVENTS_INT_GT;
1165: l_stmt_num := 220;
1166: FORALL l_ctr IN g_rae_event_id_tbl.FIRST..g_rae_event_id_tbl.LAST
1167: /* Populate XLA Event GT */
1168: INSERT INTO XLA_EVENTS_INT_GT
1169: ( application_id,
1170: ledger_id,
1171: entity_code,
1172: source_id_int_1,

Line 1198: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,

1194: g_rae_inv_org_id_tbl(l_ctr),
1195: 'PERIOD_END_ACCRUAL',
1196: 'PERIOD_END_ACCRUAL',
1197: p_sys_setup_rec.transaction_date,
1198: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED,
1199: g_rae_inv_org_id_tbl(l_ctr),
1200: p_sys_setup_rec.org_id,
1201: p_sys_setup_rec.transaction_date,
1202: l_reference_date_1,

Line 1220: xla_events_pub_pkg.create_bulk_events(p_application_id => 707,

1216: g_encum_index_tbl.DELETE;
1217: g_rae_pnt_event_id_tbl.DELETE;
1218: /* Call XLA API to create event in bulk mode */
1219: l_stmt_num := 240;
1220: xla_events_pub_pkg.create_bulk_events(p_application_id => 707,
1221: p_ledger_id => p_sys_setup_rec.set_of_books_id,
1222: p_entity_type_code => 'RCV_ACCOUNTING_EVENTS',
1223: p_source_application_id => 201);
1224: l_stmt_num := 260;

Line 1234: FROM xla_events xe,

1230: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1231: l_stmt_num := 280;
1232: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
1233: SELECT xe.event_id
1234: FROM xla_events xe,
1235: xla_events_int_gt xegt,
1236: xla_transaction_entities xte
1237: WHERE xe.entity_id = xte.entity_id
1238: AND xe.application_id = 707

Line 1235: xla_events_int_gt xegt,

1231: l_stmt_num := 280;
1232: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
1233: SELECT xe.event_id
1234: FROM xla_events xe,
1235: xla_events_int_gt xegt,
1236: xla_transaction_entities xte
1237: WHERE xe.entity_id = xte.entity_id
1238: AND xe.application_id = 707
1239: AND nvl(xegt.budgetary_control_flag,'N') = 'N'

Line 1261: /Populate PSA_BC_XLA_EVENTS_GT for Encumbrance Event/

1257: IF ( l_retcode <> 0) THEN
1258: l_msg_data := 'Error in Creating SLA Accounting For Actuals';
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;
1261: /*Populate PSA_BC_XLA_EVENTS_GT for Encumbrance Event*/
1262: l_stmt_num := 320;
1263: DELETE FROM PSA_BC_XLA_EVENTS_GT;
1264: l_stmt_num := 340;
1265: INSERT INTO PSA_BC_XLA_EVENTS_GT (

Line 1263: DELETE FROM PSA_BC_XLA_EVENTS_GT;

1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: END IF;
1261: /*Populate PSA_BC_XLA_EVENTS_GT for Encumbrance Event*/
1262: l_stmt_num := 320;
1263: DELETE FROM PSA_BC_XLA_EVENTS_GT;
1264: l_stmt_num := 340;
1265: INSERT INTO PSA_BC_XLA_EVENTS_GT (
1266: EVENT_ID,
1267: RESULT_CODE )

Line 1265: INSERT INTO PSA_BC_XLA_EVENTS_GT (

1261: /*Populate PSA_BC_XLA_EVENTS_GT for Encumbrance Event*/
1262: l_stmt_num := 320;
1263: DELETE FROM PSA_BC_XLA_EVENTS_GT;
1264: l_stmt_num := 340;
1265: INSERT INTO PSA_BC_XLA_EVENTS_GT (
1266: EVENT_ID,
1267: RESULT_CODE )
1268: SELECT xe.event_id,
1269: 'UNPROCESSED'

Line 1270: FROM xla_events xe,

1266: EVENT_ID,
1267: RESULT_CODE )
1268: SELECT xe.event_id,
1269: 'UNPROCESSED'
1270: FROM xla_events xe,
1271: xla_events_int_gt xegt,
1272: xla_transaction_entities xte
1273: WHERE xe.entity_id = xte.entity_id
1274: AND xe.application_id = 707

Line 1271: xla_events_int_gt xegt,

1267: RESULT_CODE )
1268: SELECT xe.event_id,
1269: 'UNPROCESSED'
1270: FROM xla_events xe,
1271: xla_events_int_gt xegt,
1272: xla_transaction_entities xte
1273: WHERE xe.entity_id = xte.entity_id
1274: AND xe.application_id = 707
1275: AND nvl(xegt.budgetary_control_flag,'N') = 'Y'

Line 1284: /* Delete from the GT tables for XLA_EVENTS_INT_GT and

1280: AND nvl(xte.source_id_int_1,-99) = xegt.source_id_int_1
1281: AND nvl(xte.source_id_int_2,-99) = xegt.source_id_int_2
1282: AND nvl(xte.source_id_int_3,-99) = xegt.source_id_int_3;
1283: l_stmt_num := 360;
1284: /* Delete from the GT tables for XLA_EVENTS_INT_GT and
1285: XLA_ACCT_PROG_EVENTS_GT before calling PSA API as
1286: PSA API also uses the same GTT */
1287: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1288: DELETE FROM XLA_EVENTS_INT_GT;

Line 1288: DELETE FROM XLA_EVENTS_INT_GT;

1284: /* Delete from the GT tables for XLA_EVENTS_INT_GT and
1285: XLA_ACCT_PROG_EVENTS_GT before calling PSA API as
1286: PSA API also uses the same GTT */
1287: DELETE FROM XLA_ACCT_PROG_EVENTS_GT;
1288: DELETE FROM XLA_EVENTS_INT_GT;
1289: l_stmt_num := 380;
1290: FND_PROFILE.get('USER_ID', l_user_id);
1291: FND_PROFILE.get('RESP_ID', l_resp_id);
1292: FND_PROFILE.get('RESP_APPL_ID', l_resp_appl_id);