APPS.FV_BE_XLA_PKG dependencies on PSA_BC_XLA_EVENTS_GT

Line 237: -- Insert into psa_bc_xla_events_gt

233: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
234: 'call populate_bc_events_tab');
235: END IF;
236:
237: -- Insert into psa_bc_xla_events_gt
238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke populate_bc_events() ');
239: populate_bc_events_tab;
240:
241:

Line 564: | This procedure is used to insert event into psa_bc_xla_events_gt table

560: /*============================================================================
561: | PROCEDURE - POPULATE_BC_EVENTS_TAB(PRIVATE)
562: |
563: | DESCRIPTION
564: | This procedure is used to insert event into psa_bc_xla_events_gt table
565: |
566: | PRAMETERS:
567: | NULL
568: |

Line 585: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)

581: IF g_doc_id is null THEN
582: RETURN;
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'

Line 592: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)

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
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');