1 package FII_PA_COST_HOOK as
2 /* $Header: FIIPA15S.pls 120.0 2002/08/24 05:00:30 appldev noship $ */
3
4 --
5 -- Package FII_PA_COST_HOOK implements collection hooks for
6 -- EDW Project Cost fact. 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_COST_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 -- function PRE_FACT_COLL
19 -- --------------------------
20
21 -- Function PRE_FACT_COLL is Project Cost fact pre-collection hook.
22 -- The function implements "denormalized" Task Owning organization
23 -- foreign key in facts (PROJECT_ORG_FK_KEY).
24 --
25 -- The function does the following:
26 --
27 -- 1. For all new rows in the FII_PA_COST_FSTG staging table it
28 -- populates PROJECT_ORG_FK with the up-to-date Task Owning
29 -- organization foreign key. Task owning organization FK is stored in
30 -- EDW_PROJ_TASK_LCT.DENORM_TASK_ORG_FK column in EDW.
31 --
32 -- 2. Update PROJECT_ORG_FK_KEY for all records in the FII_PA_COST_F
33 -- fact table which belong to tasks (PROJECT_FK_KEY) for which
34 -- Task Owning organization has changed. The function uses
35 -- FII_SYSTEM_EVENT_LOG table to detect changes in Task Owning
36 -- organizations.
37
38 function pre_fact_coll return boolean;
39
40 end;