DBA Data[Home] [Help]

APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PSA_BC_REPORT_EVENTS_GT

Line 4985: -- the PSA_BC_REPORT_EVENTS_GT global temp table

4981: --Name: POPULATE_BC_REPORT_EVENTS
4982: --Pre-reqs:
4983: -- None.
4984: --Modifies:
4985: -- the PSA_BC_REPORT_EVENTS_GT global temp table
4986: --Locks:
4987: -- None.
4988: --Function:
4989: -- Populates a Global Temp table with the events that are used by the SLA

Line 5016: DELETE FROM PSA_BC_REPORT_EVENTS_GT;

5012: l_api_name CONSTANT varchar2(30) := 'POPULATE_BC_REPORT_EVENTS';
5013: BEGIN
5014: x_return_status := FND_API.G_RET_STS_SUCCESS;
5015:
5016: DELETE FROM PSA_BC_REPORT_EVENTS_GT;
5017: --
5018: --Going forward we would populate the events and distribution ids
5019: --directly from po_bc_distributions based on online_report_id
5020: --We stamp all distributions in the current transaction with online

Line 5023: INSERT INTO PSA_BC_REPORT_EVENTS_GT

5019: --directly from po_bc_distributions based on online_report_id
5020: --We stamp all distributions in the current transaction with online
5021: --report_id and then use online_report_id to identify the distributions
5022: --while reporting.
5023: INSERT INTO PSA_BC_REPORT_EVENTS_GT
5024: (
5025: SOURCE_DISTRIBUTION_ID_NUM_1,
5026: EVENT_ID
5027: )

Line 5052: -- the PSA_BC_REPORT_EVENTS_GT global temp table

5048: --Name: POPULATE_AND_CREATE_BC_REPORT
5049: --Pre-reqs:
5050: -- None.
5051: --Modifies:
5052: -- the PSA_BC_REPORT_EVENTS_GT global temp table
5053: --Locks:
5054: -- None.
5055: --Function:
5056: -- Populates a Global Temp table with Budgetary Control events and creates