APPS.FII_PA_REVENUE_HOOK dependencies on FII_SYSTEM_EVENT_LOG

Line 11: from fii_system_event_log log

7: function pre_fact_coll return boolean is
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_REVENUE_F'
13: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
14: and log.status = 'PROCESSING';
15:

Line 24: update fii_system_event_log log

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

Line 34: delete from fii_system_event_log log

30:
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_REVENUE_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

Line 41: from fii_system_event_log log

37: and log.status = 'PROCESSING'
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_REVENUE_F'
43: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
44: and log.status = 'PROCESSING'
45: );

Line 49: update fii_system_event_log log

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

Line 86: from fii_system_event_log log

82: update fii_pa_revenue_fstg fstg
83: set project_org_fk =
84: (
85: select attribute3
86: from fii_system_event_log log
87: where log.event_type = 'DNRM:FII_PA_REVENUE_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

Line 97: from fii_system_event_log

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

Line 116: delete from fii_system_event_log

112: end loop;
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_REVENUE_F'
118: and event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'
119: and status = 'PROCESSING';
120: