1 package FII_PA_BUDGET_HOOK as
2 /* $Header: FIIPA14S.pls 120.0 2002/08/24 05:00:22 appldev noship $ */
3
4 --
5 -- Package FII_PA_BUDGET_HOOK implements collection hooks for
6 -- EDW Project Budget. Collection hooks like FII_PA_COST_HOOK are
7 -- used by EDW collection engine to pass control to
8 -- product specific code at different stages of collection process.
9 --
10 -- When FII_PA_BUDGET_HOOK finishes execution, control is
11 -- returned back to the collection engine.
12 --
13 -- This concept is similar to message (event) handling mechanisms.
14 --
15
16
17
18 -- ------------------------------
19 -- function PRE_FACT_COLL
20 -- ------------------------------
21
22 -- Function PRE_FACT_COLL is Project Budget fact pre-collection hook.
23 -- The function implements "denormalized" Task Owning organization
24 -- foreign key in facts (PROJECT_ORG_FK_KEY).
25 --
26 -- The function does the following:
27 --
28 -- 1. For all new rows in the FII_PA_BUDGET_FSTG staging table it
29 -- populates PROJECT_ORG_FK with the up-to-date Task Owning
30 -- organization foreign key. Task owning organization FK is stored in
31 -- EDW_PROJ_TASK_LCT.DENORM_TASK_ORG_FK column in EDW.
32 --
33 -- 2. Update PROJECT_ORG_FK_KEY for all records in the FII_PA_BUDGET_F
34 -- fact table which belong to tasks (PROJECT_FK_KEY) for which
35 -- Task Owning organization has changed. The function uses
36 -- FII_SYSTEM_EVENT_LOG table to detect changes in Task Owning
37 -- organizations.
38
39 function pre_fact_coll return boolean;
40
41 end;