APPS.CST_XLA_PVT dependencies on XLA_EVENTS_GT

Line 95: DELETE FROM XLA_EVENTS_GT;

91: DELETE FROM XLA_BAL_STATUSES_GT;
92: debug( '11 XLA_BAL_STATUSES_GT row count :'||SQL%ROWCOUNT);
93: DELETE FROM XLA_BAL_CTRL_LINES_GT;
94: debug( '12 XLA_BAL_CTRL_LINES_GT row count :'||SQL%ROWCOUNT);
95: DELETE FROM XLA_EVENTS_GT;
96: debug( '13 XLA_EVENTS_GT row count :'||SQL%ROWCOUNT);
97: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
98: debug( '14 XLA_EVT_CLASS_SOURCES_GT row count :'||SQL%ROWCOUNT);
99: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;

Line 96: debug( '13 XLA_EVENTS_GT row count :'||SQL%ROWCOUNT);

92: debug( '11 XLA_BAL_STATUSES_GT row count :'||SQL%ROWCOUNT);
93: DELETE FROM XLA_BAL_CTRL_LINES_GT;
94: debug( '12 XLA_BAL_CTRL_LINES_GT row count :'||SQL%ROWCOUNT);
95: DELETE FROM XLA_EVENTS_GT;
96: debug( '13 XLA_EVENTS_GT row count :'||SQL%ROWCOUNT);
97: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
98: debug( '14 XLA_EVT_CLASS_SOURCES_GT row count :'||SQL%ROWCOUNT);
99: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
100: debug( '15 XLA_EVT_CLASS_ORDERS_GT row count :'||SQL%ROWCOUNT);

Line 510: - Insert this event into PSA_BC_XLA_EVENTS_GT

506:
507:
508: /* If Encumbrance is enabled,
509: - Create a separate encumbrance event
510: - Insert this event into PSA_BC_XLA_EVENTS_GT
511: - Call the Budgetary Control API to create the BC accounting entries */
512:
513:
514: /* For the DELIVER and RTR events, we do not have the encumbrance amount populated in

Line 589: DELETE PSA_BC_XLA_EVENTS_GT;

585:
586:
587: l_stmt_num := 55;
588:
589: DELETE PSA_BC_XLA_EVENTS_GT;
590:
591: l_stmt_num := 60;
592: INSERT INTO PSA_BC_XLA_EVENTS_GT (
593: EVENT_ID,

Line 592: INSERT INTO PSA_BC_XLA_EVENTS_GT (

588:
589: DELETE PSA_BC_XLA_EVENTS_GT;
590:
591: l_stmt_num := 60;
592: INSERT INTO PSA_BC_XLA_EVENTS_GT (
593: EVENT_ID,
594: RESULT_CODE )
595: VALUES (
596: l_bc_event_id,

Line 1163: DELETE PSA_BC_XLA_EVENTS_GT;

1159: Inserts are done into the table in the following loop */
1160:
1161: l_stmt_num := 115;
1162:
1163: DELETE PSA_BC_XLA_EVENTS_GT;
1164:
1165: FOR l_index IN l_events.FIRST .. l_events.LAST LOOP
1166: l_stmt_num := 120;
1167: SELECT

Line 1219: - Insert these events into PSA_BC_XLA_EVENTS_GT */

1215: --Need to discuss with PSA
1216: --
1217: /* If Encumbrance is enabled,
1218: - Create BC Events in SLA
1219: - Insert these events into PSA_BC_XLA_EVENTS_GT */
1220: IF ( P_TRX_INFO.ENCUMBRANCE_FLAG = 'Y')
1221: --{BUG#6125007
1222: AND l_events(l_index).event_type_code IN
1223: (

Line 1284: INSERT INTO PSA_BC_XLA_EVENTS_GT (

1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;
1282:
1283: l_stmt_num := 140;
1284: INSERT INTO PSA_BC_XLA_EVENTS_GT (
1285: EVENT_ID,
1286: RESULT_CODE )
1287: VALUES (
1288: l_bc_event_id,