APPS.FV_BE_XLA_PKG dependencies on FV_BE_RPR_TRANSACTIONS

Line 322: FROM fv_be_rpr_transactions FVBE, xla_events XLAE

318: AND FVBE.transaction_status <> 'AR'
319: AND fvbe.approval_date is null
320: UNION
321: SELECT distinct fvbe.event_id,xlae.event_date
322: FROM fv_be_rpr_transactions FVBE, xla_events XLAE
323: WHERE FVBE.transaction_id = g_doc_id
324: AND FVBE.event_id = XLAE.event_id
325: AND FVBE.gl_date <> XLAE.event_date
326: AND FVBE.transaction_status <> 'AR';

Line 337: FROM fv_be_rpr_transactions 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
337: FROM fv_be_rpr_transactions FVBE
338: WHERE FVBE.transaction_id = g_doc_id;
339:
340:
341: l_module_name VARCHAR(1000);

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 526: l_prepare_stmt := l_prepare_stmt ||'FV_BE_RPR_TRANSACTIONS WHERE TRANSACTION_ID = :1';

522: g_event_class := BE_CLASS;
523:
524: ELSIF g_doc_type = BE_RPR_ENTITY THEN
525:
526: l_prepare_stmt := l_prepare_stmt ||'FV_BE_RPR_TRANSACTIONS WHERE TRANSACTION_ID = :1';
527: l_event_source_info.entity_type_code := BE_RPR_ENTITY;
528: g_event_class := BE_RPR_CLASS;
529:
530: END IF;

Line 579: SELECT distinct event_id,'XLA_ERROR' FROM FV_BE_RPR_TRANSACTIONS WHERE transaction_id = g_doc_id;

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;
580: END IF;
581: END IF;
582: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Populate_BC_Events_Tab');
583: END populate_bc_events_tab;

Line 614: UPDATE FV_BE_RPR_TRANSACTIONS

610: AND gl_date = g_accounting_date
611: AND approval_date IS NULL;
612:
613: ELSIF g_doc_type = BE_RPR_ENTITY THEN
614: UPDATE FV_BE_RPR_TRANSACTIONS
615: SET EVENT_ID = p_event_id
616: WHERE transaction_id = g_doc_id
617: AND gl_date = g_accounting_date;
618: END IF;

Line 652: UPDATE FV_BE_RPR_TRANSACTIONS

648: WHERE doc_id = g_doc_id
649: AND event_id = p_event_id;
650:
651: ELSIF g_doc_type = BE_RPR_ENTITY THEN
652: UPDATE FV_BE_RPR_TRANSACTIONS
653: SET EVENT_ID = null
654: WHERE transaction_id = g_doc_id
655: AND event_id = p_event_id;
656: END IF;