APPS.FV_BE_XLA_PKG dependencies on PSA_BC_XLA_EVENTS_GT

Line 226: -- Insert into psa_bc_xla_events_gt

222: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
223: 'call populate_bc_events_tab');
224: END IF;
225:
226: -- Insert into psa_bc_xla_events_gt
227: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke populate_bc_events() ');
228: populate_bc_events_tab;
229:
230:

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

549: /*============================================================================
550: | PROCEDURE - POPULATE_BC_EVENTS_TAB(PRIVATE)
551: |
552: | DESCRIPTION
553: | This procedure is used to insert event into psa_bc_xla_events_gt table
554: |
555: | PRAMETERS:
556: | NULL
557: |

Line 574: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)

570: IF g_doc_id is null THEN
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)

Line 578: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)

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