APPS.FV_BE_XLA_PKG dependencies on FV_BE_RPR_TRANSACTIONS

Line 333: FROM fv_be_rpr_transactions FVBE, xla_events XLAE

329: AND FVBE.transaction_status <> 'AR'
330: AND fvbe.approval_date is null
331: UNION
332: SELECT distinct fvbe.event_id,xlae.event_date
333: FROM fv_be_rpr_transactions FVBE, xla_events XLAE
334: WHERE FVBE.transaction_id = g_doc_id
335: AND FVBE.event_id = XLAE.event_id
336: AND FVBE.gl_date <> XLAE.event_date
337: AND FVBE.transaction_status <> 'AR';

Line 348: FROM fv_be_rpr_transactions 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
348: FROM fv_be_rpr_transactions FVBE
349: WHERE FVBE.transaction_id = g_doc_id;
350:
351:
352: l_module_name VARCHAR(1000);

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

533: g_event_class := BE_CLASS;
534:
535: ELSIF g_doc_type = BE_RPR_ENTITY THEN
536:
537: l_prepare_stmt := l_prepare_stmt ||'FV_BE_RPR_TRANSACTIONS WHERE TRANSACTION_ID = :1';
538: l_event_source_info.entity_type_code := BE_RPR_ENTITY;
539: g_event_class := BE_RPR_CLASS;
540:
541: END IF;

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

589: AND transaction_status <> 'AR'
590: AND approval_date IS NULL;
591: ELSIF g_doc_type = BE_RPR_ENTITY THEN
592: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)
593: SELECT distinct event_id,'XLA_ERROR' FROM FV_BE_RPR_TRANSACTIONS WHERE transaction_id = g_doc_id;
594: END IF;
595: END IF;
596: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Populate_BC_Events_Tab');
597: END populate_bc_events_tab;

Line 629: UPDATE FV_BE_RPR_TRANSACTIONS

625: AND transaction_status <> 'AR'
626: AND approval_date IS NULL;
627:
628: ELSIF g_doc_type = BE_RPR_ENTITY THEN
629: UPDATE FV_BE_RPR_TRANSACTIONS
630: SET EVENT_ID = p_event_id
631: WHERE transaction_id = g_doc_id
632: AND gl_date = g_accounting_date;
633: END IF;

Line 667: UPDATE FV_BE_RPR_TRANSACTIONS

663: WHERE doc_id = g_doc_id
664: AND event_id = p_event_id;
665:
666: ELSIF g_doc_type = BE_RPR_ENTITY THEN
667: UPDATE FV_BE_RPR_TRANSACTIONS
668: SET EVENT_ID = null
669: WHERE transaction_id = g_doc_id
670: AND event_id = p_event_id;
671: END IF;