APPS.FV_BE_XLA_PKG dependencies on FV_BE_TRX_DTLS

Line 325: FROM fv_be_trx_dtls FVBE, xla_events XLAE

321:
322: -- Cursor to pull Event_Id for Delete_Events API for accounting_date change
323: Cursor fv_be_event_id IS
324: SELECT distinct fvbe.event_id,xlae.event_date
325: FROM fv_be_trx_dtls FVBE, xla_events XLAE
326: WHERE FVBE.doc_id = g_doc_id
327: AND FVBE.event_id = XLAE.event_id
328: AND FVBE.gl_date <> XLAE.event_date
329: AND FVBE.transaction_status <> 'AR'

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

336: AND FVBE.gl_date <> XLAE.event_date
337: AND FVBE.transaction_status <> 'AR';
338:
339:
340: -- Cursor to pull gl_date from FV_BE_TRX_DTLS table for doc_id passed
341: Cursor fv_be_gl_date IS
342: SELECT distinct fvbe.gl_date,fvbe.event_id
343: FROM fv_be_trx_dtls FVBE
344: WHERE FVBE.doc_id = g_doc_id

Line 343: FROM fv_be_trx_dtls FVBE

339:
340: -- Cursor to pull gl_date from FV_BE_TRX_DTLS table for doc_id passed
341: Cursor fv_be_gl_date IS
342: SELECT distinct fvbe.gl_date,fvbe.event_id
343: FROM fv_be_trx_dtls FVBE
344: WHERE FVBE.doc_id = g_doc_id
345: AND fvbe.approval_date is null
346: UNION
347: SELECT distinct fvbe.gl_date,fvbe.event_id

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

474: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Event_id:'||l_event_id);
475: END IF;
476:
477: IF(l_event_id IS NOT NULL) THEN
478: -- Stamp Event in FV_BE_TRX_DTLS/FV_BE_RPR_TRANSACTIONS table
479: FND_FILE.PUT_LINE(FND_FILE.LOG,'Invoke Stamp_Event()');
480: stamp_event(l_event_id);
481: END IF;
482: END LOOP;

Line 587: FROM FV_BE_TRX_DTLS

583: ELSE
584: IF g_doc_type = BE_ENTITY THEN
585: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)
586: SELECT distinct event_id,'XLA_ERROR'
587: FROM FV_BE_TRX_DTLS
588: WHERE doc_id = g_doc_id
589: AND transaction_status <> 'AR'
590: AND approval_date IS NULL;
591: ELSIF g_doc_type = BE_RPR_ENTITY THEN

Line 621: UPDATE FV_BE_TRX_DTLS

617: BEGIN
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Stamp_Event');
619:
620: IF g_doc_type = BE_ENTITY THEN
621: UPDATE FV_BE_TRX_DTLS
622: SET EVENT_ID = p_event_id
623: WHERE doc_id = g_doc_id
624: AND gl_date = g_accounting_date
625: AND transaction_status <> 'AR'

Line 661: UPDATE FV_BE_TRX_DTLS

657: BEGIN
658: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Reset_Event');
659:
660: IF g_doc_type = BE_ENTITY THEN
661: UPDATE FV_BE_TRX_DTLS
662: SET EVENT_ID = null
663: WHERE doc_id = g_doc_id
664: AND event_id = p_event_id;
665: