APPS.FV_BE_XLA_PKG dependencies on FV_BE_TRX_DTLS

Line 314: FROM fv_be_trx_dtls FVBE, xla_events XLAE

310:
311: -- Cursor to pull Event_Id for Delete_Events API for accounting_date change
312: Cursor fv_be_event_id IS
313: SELECT distinct fvbe.event_id,xlae.event_date
314: FROM fv_be_trx_dtls FVBE, xla_events XLAE
315: WHERE FVBE.doc_id = g_doc_id
316: AND FVBE.event_id = XLAE.event_id
317: AND FVBE.gl_date <> XLAE.event_date
318: AND FVBE.transaction_status <> 'AR'

Line 329: -- Cursor to pull gl_date from FV_BE_TRX_DTLS table for doc_id passed

325: AND FVBE.gl_date <> XLAE.event_date
326: AND FVBE.transaction_status <> 'AR';
327:
328:
329: -- Cursor to pull gl_date from FV_BE_TRX_DTLS table for doc_id passed
330: Cursor fv_be_gl_date IS
331: SELECT distinct fvbe.gl_date,fvbe.event_id
332: FROM fv_be_trx_dtls FVBE
333: WHERE FVBE.doc_id = g_doc_id

Line 332: FROM fv_be_trx_dtls FVBE

328:
329: -- Cursor to pull gl_date from FV_BE_TRX_DTLS table for doc_id passed
330: Cursor fv_be_gl_date IS
331: SELECT distinct fvbe.gl_date,fvbe.event_id
332: FROM fv_be_trx_dtls FVBE
333: WHERE FVBE.doc_id = g_doc_id
334: AND fvbe.approval_date is null
335: UNION
336: SELECT distinct fvbe.gl_date,fvbe.event_id

Line 467: -- Stamp Event in FV_BE_TRX_DTLS/FV_BE_RPR_TRANSACTIONS table

463: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Event_id:'||l_event_id);
464: END IF;
465:
466: IF(l_event_id IS NOT NULL) THEN
467: -- Stamp Event in FV_BE_TRX_DTLS/FV_BE_RPR_TRANSACTIONS table
468: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invoke Stamp_Event()');
469: stamp_event(l_event_id);
470: END IF;
471: END LOOP;

Line 575: SELECT distinct event_id,'XLA_ERROR' FROM FV_BE_TRX_DTLS WHERE doc_id = g_doc_id

571: RETURN;
572: ELSE
573: IF g_doc_type = BE_ENTITY THEN
574: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)
575: SELECT distinct event_id,'XLA_ERROR' FROM FV_BE_TRX_DTLS WHERE doc_id = g_doc_id
576: AND approval_date IS NULL;
577: ELSIF g_doc_type = BE_RPR_ENTITY THEN
578: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)
579: SELECT distinct event_id,'XLA_ERROR' FROM FV_BE_RPR_TRANSACTIONS WHERE transaction_id = g_doc_id;

Line 607: UPDATE FV_BE_TRX_DTLS

603: BEGIN
604: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Stamp_Event');
605:
606: IF g_doc_type = BE_ENTITY THEN
607: UPDATE FV_BE_TRX_DTLS
608: SET EVENT_ID = p_event_id
609: WHERE doc_id = g_doc_id
610: AND gl_date = g_accounting_date
611: AND approval_date IS NULL;

Line 646: UPDATE FV_BE_TRX_DTLS

642: BEGIN
643: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Reset_Event');
644:
645: IF g_doc_type = BE_ENTITY THEN
646: UPDATE FV_BE_TRX_DTLS
647: SET EVENT_ID = null
648: WHERE doc_id = g_doc_id
649: AND event_id = p_event_id;
650: