APPS.FII_PA_BUDGET_HOOK dependencies on FII_PA_BUDGET_F

Line 12: where log.event_type = 'DNRM:FII_PA_BUDGET_F'

8:
9: cursor task_c is
10: select attribute1, attribute2, attribute3, attribute4
11: from fii_system_event_log log
12: where log.event_type = 'DNRM:FII_PA_BUDGET_F'
13: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
14: and log.status = 'PROCESSING';
15:
16: begin

Line 26: where log.event_type = 'DNRM:FII_PA_BUDGET_F'

22: -- collection process.
23:
24: update fii_system_event_log log
25: set status = 'PROCESSING'
26: where log.event_type = 'DNRM:FII_PA_BUDGET_F'
27: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
28: and log.status = 'READY';
29:
30:

Line 35: where log.event_type = 'DNRM:FII_PA_BUDGET_F'

31: -- Step 2. remove redundant events from the event log table, i.e. leave only
32: -- the latest event for each task
33:
34: delete from fii_system_event_log log
35: where log.event_type = 'DNRM:FII_PA_BUDGET_F'
36: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
37: and log.status = 'PROCESSING'
38: and log.event_id not in
39: (

Line 42: where log.event_type = 'DNRM:FII_PA_BUDGET_F'

38: and log.event_id not in
39: (
40: select max( event_id )
41: from fii_system_event_log log
42: where log.event_type = 'DNRM:FII_PA_BUDGET_F'
43: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
44: and log.status = 'PROCESSING'
45: );
46:

Line 58: where log.event_type = 'DNRM:FII_PA_BUDGET_F'

54: edw_orga_org_ltc org
55: where log.attribute1 = task.task_pk
56: and task.denorm_task_org_fk = org.organization_pk
57: )
58: where log.event_type = 'DNRM:FII_PA_BUDGET_F'
59: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
60: and log.status = 'PROCESSING';
61:
62: -- Step 4. update PROJECT_ORG_FK in the fact staging table

Line 65: update fii_pa_budget_fstg fstg

61:
62: -- Step 4. update PROJECT_ORG_FK in the fact staging table
63: -- with Task Owning Organization from the Task Level table
64:
65: update fii_pa_budget_fstg fstg
66: set project_org_fk =
67: (
68: select denorm_task_org_fk
69: from edw_proj_task_ltc task

Line 82: update fii_pa_budget_fstg fstg

78: -- table by Project Dimension collection process between Steps 3 and 4.
79: -- Step 5 guarantees that FSTG and F tables are always in sync in
80: -- respect to the LTC tables.
81:
82: update fii_pa_budget_fstg fstg
83: set project_org_fk =
84: (
85: select attribute3
86: from fii_system_event_log log

Line 87: where log.event_type = 'DNRM:FII_PA_BUDGET_F'

83: set project_org_fk =
84: (
85: select attribute3
86: from fii_system_event_log log
87: where log.event_type = 'DNRM:FII_PA_BUDGET_F'
88: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
89: and log.status = 'PROCESSING'
90: and fstg.project_fk = log.attribute1
91: )

Line 98: where event_type = 'DNRM:FII_PA_BUDGET_F'

94: and project_fk in
95: (
96: select attribute1
97: from fii_system_event_log
98: where event_type = 'DNRM:FII_PA_BUDGET_F'
99: and event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
100: and status = 'PROCESSING'
101: );
102:

Line 108: update fii_pa_budget_f fact

104: -- Step 6. update fact table
105:
106: for c in task_c loop
107: if ( c.attribute2 is not null ) and ( c.attribute4 is not null ) then
108: update fii_pa_budget_f fact
109: set fact.project_org_fk_key = to_number( c.attribute4 )
110: where fact.project_fk_key = to_number( c.attribute2 );
111: end if;
112: end loop;

Line 117: where event_type = 'DNRM:FII_PA_BUDGET_F'

113:
114: -- Step 7. delete processed records from the Log table
115:
116: delete from fii_system_event_log
117: where event_type = 'DNRM:FII_PA_BUDGET_F'
118: and event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
119: and status = 'PROCESSING';
120:
121: -- Step 8. commit changes.