1 package FII_PROJECT_HOOK as
2 /* $Header: FIIPA17S.pls 120.0 2002/08/24 05:00:43 appldev noship $ */
3
4 --
5 -- Package FII_PROJECT_HOOK implements collection hooks for
6 -- EDW Project Dimension. Collection hooks like FII_PROJECT_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_PROJECT_HOOK function finishs 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_DIMENSION_CALL
19 -- ---------------------------------
20
21 -- Function PRE_DIMENSION_CALL is Project dimension pre-collection hook.
22 -- The function detects change in Task Owning organization made in Oracle Projects
23 -- and if such change occurs, inserts three records into FII_SYSTEM_EVENT_LOG
24 -- table (one record per PA fact - cost, revenue, budget) to notify
25 -- PA fact collection processes that task has changed its task owning
26 -- organization and that task owing organization foreign key in PA fact tables need to be
27 -- updated accordingly to reflect this.
28 -- PROJECT_ORG_FK column in PA facts is denormalized from Project Task level,
29 -- Corresponding column in the EDW_PROJ_TASK_LTC table is DENORM_TASK_ORG_FK.
30
31 function pre_dimension_coll return boolean;
32
33 end FII_PROJECT_HOOK;