APPS.CST_XLA_PVT dependencies on XLA_EVENTS_GT

Line 158: DELETE FROM XLA_EVENTS_GT;

154: DELETE FROM XLA_BAL_STATUSES_GT;
155: debug( '11 XLA_BAL_STATUSES_GT row count :'||SQL%ROWCOUNT);
156: DELETE FROM XLA_BAL_CTRL_LINES_GT;
157: debug( '12 XLA_BAL_CTRL_LINES_GT row count :'||SQL%ROWCOUNT);
158: DELETE FROM XLA_EVENTS_GT;
159: debug( '13 XLA_EVENTS_GT row count :'||SQL%ROWCOUNT);
160: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
161: debug( '14 XLA_EVT_CLASS_SOURCES_GT row count :'||SQL%ROWCOUNT);
162: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;

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

155: debug( '11 XLA_BAL_STATUSES_GT row count :'||SQL%ROWCOUNT);
156: DELETE FROM XLA_BAL_CTRL_LINES_GT;
157: debug( '12 XLA_BAL_CTRL_LINES_GT row count :'||SQL%ROWCOUNT);
158: DELETE FROM XLA_EVENTS_GT;
159: debug( '13 XLA_EVENTS_GT row count :'||SQL%ROWCOUNT);
160: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
161: debug( '14 XLA_EVT_CLASS_SOURCES_GT row count :'||SQL%ROWCOUNT);
162: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
163: debug( '15 XLA_EVT_CLASS_ORDERS_GT row count :'||SQL%ROWCOUNT);

Line 622: - Insert this event into PSA_BC_XLA_EVENTS_GT

618:
619:
620: /* If Encumbrance is enabled,
621: - Create a separate encumbrance event
622: - Insert this event into PSA_BC_XLA_EVENTS_GT
623: - Call the Budgetary Control API to create the BC accounting entries */
624:
625:
626: /* For the DELIVER and RTR events, we do not have the encumbrance amount populated in

Line 712: -- DELETE PSA_BC_XLA_EVENTS_GT;

708:
709:
710: -- l_stmt_num := 55;
711:
712: -- DELETE PSA_BC_XLA_EVENTS_GT;
713:
714: -- l_stmt_num := 60;
715: -- INSERT INTO PSA_BC_XLA_EVENTS_GT (
716: -- EVENT_ID,

Line 715: -- INSERT INTO PSA_BC_XLA_EVENTS_GT (

711:
712: -- DELETE PSA_BC_XLA_EVENTS_GT;
713:
714: -- l_stmt_num := 60;
715: -- INSERT INTO PSA_BC_XLA_EVENTS_GT (
716: -- EVENT_ID,
717: -- RESULT_CODE )
718: -- VALUES (
719: -- l_bc_event_id,

Line 1335: --DELETE PSA_BC_XLA_EVENTS_GT;

1331: Inserts are done into the table in the following loop */
1332:
1333: l_stmt_num := 115;
1334:
1335: --DELETE PSA_BC_XLA_EVENTS_GT;
1336:
1337: FOR l_index IN l_events.FIRST .. l_events.LAST LOOP
1338: l_stmt_num := 120;
1339: SELECT

Line 1395: -- - Insert these events into PSA_BC_XLA_EVENTS_GT */

1391:
1392: /* { bug 9356654- Commented for single event -Inventory starts */
1393: -- /* If Encumbrance is enabled,
1394: -- - Create BC Events in SLA
1395: -- - Insert these events into PSA_BC_XLA_EVENTS_GT */
1396: -- IF ( P_TRX_INFO.ENCUMBRANCE_FLAG = 'Y')
1397: --{BUG#6125007
1398: -- AND l_events(l_index).event_type_code IN
1399: -- (

Line 1464: -- INSERT INTO PSA_BC_XLA_EVENTS_GT (

1460: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: -- END IF;
1462:
1463: -- l_stmt_num := 140;
1464: -- INSERT INTO PSA_BC_XLA_EVENTS_GT (
1465: -- EVENT_ID,
1466: -- RESULT_CODE )
1467: -- VALUES (
1468: -- l_bc_event_id,