APPS.CST_RECEIPTACCRUALPEREND_PVT dependencies on XLA_EVENTS_INT_GT

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 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 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);