DBA Data[Home] [Help]

APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PSA_BC_REPORT_EVENTS_GT

Line 5232: -- the PSA_BC_REPORT_EVENTS_GT global temp table

5228: --Name: POPULATE_BC_REPORT_EVENTS
5229: --Pre-reqs:
5230: -- None.
5231: --Modifies:
5232: -- the PSA_BC_REPORT_EVENTS_GT global temp table
5233: --Locks:
5234: -- None.
5235: --Function:
5236: -- Populates a Global Temp table with the events that are used by the SLA

Line 5263: DELETE FROM PSA_BC_REPORT_EVENTS_GT;

5259: l_api_name CONSTANT varchar2(30) := 'POPULATE_BC_REPORT_EVENTS';
5260: BEGIN
5261: x_return_status := FND_API.G_RET_STS_SUCCESS;
5262:
5263: DELETE FROM PSA_BC_REPORT_EVENTS_GT;
5264: --
5265: --Going forward we would populate the events and distribution ids
5266: --directly from po_bc_distributions based on online_report_id
5267: --We stamp all distributions in the current transaction with online

Line 5270: INSERT INTO PSA_BC_REPORT_EVENTS_GT

5266: --directly from po_bc_distributions based on online_report_id
5267: --We stamp all distributions in the current transaction with online
5268: --report_id and then use online_report_id to identify the distributions
5269: --while reporting.
5270: INSERT INTO PSA_BC_REPORT_EVENTS_GT
5271: (
5272: SOURCE_DISTRIBUTION_ID_NUM_1,
5273: EVENT_ID
5274: )

Line 5299: -- the PSA_BC_REPORT_EVENTS_GT global temp table

5295: --Name: POPULATE_AND_CREATE_BC_REPORT
5296: --Pre-reqs:
5297: -- None.
5298: --Modifies:
5299: -- the PSA_BC_REPORT_EVENTS_GT global temp table
5300: --Locks:
5301: -- None.
5302: --Function:
5303: -- Populates a Global Temp table with Budgetary Control events and creates