APPS.FII_PA_COST_HOOK dependencies on FII_SYSTEM_EVENT_LOG

Line 12: from fii_system_event_log log

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

Line 25: update fii_system_event_log log

21: -- the same set of data ignoring any new records that may be
22: -- concurrently created in the Log table by the Project Dimension
23: -- collection process.
24:
25: update fii_system_event_log log
26: set status = 'PROCESSING'
27: where log.event_type = 'DNRM:FII_PA_COST_F'
28: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
29: and log.status = 'READY';

Line 35: delete from fii_system_event_log log

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

Line 42: from fii_system_event_log log

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

Line 50: update fii_system_event_log log

46: );
47:
48: -- Step 3. update log table with task and org data
49:
50: update fii_system_event_log log
51: set (attribute2, attribute3, attribute4) =
52: (
53: select to_char(task.task_pk_key), task.denorm_task_org_fk, to_char(org.organization_pk_key)
54: from edw_proj_task_ltc task,

Line 87: from fii_system_event_log log

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

Line 98: from fii_system_event_log

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

Line 117: delete from fii_system_event_log

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