APPS.FII_PA_REVENUE_HOOK dependencies on EDW_PROJ_TASK_LTC

Line 13: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'

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:
16: begin
17:

Line 27: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'

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';
29:
30:
31: -- Step 2. remove redundant events from the event log table, i.e. leave only

Line 36: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'

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
39: (
40: select max( event_id )

Line 43: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'

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: );
46:
47: -- Step 3. update log table with task and org data

Line 53: from edw_proj_task_ltc task,

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,
54: edw_orga_org_ltc org
55: where log.attribute1 = task.task_pk
56: and task.denorm_task_org_fk = org.organization_pk
57: )

Line 59: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'

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_REVENUE_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
63: -- with Task Owning Organization from the Task Level table

Line 69: from edw_proj_task_ltc task

65: update fii_pa_revenue_fstg fstg
66: set project_org_fk =
67: (
68: select denorm_task_org_fk
69: from edw_proj_task_ltc task
70: where fstg.project_fk = task.task_pk
71: )
72: where fstg.collection_status = 'READY'
73: and fstg.edw_record_type = 'ORACLE';

Line 88: and log.event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_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
91: )
92: where collection_status = 'READY'

Line 99: and event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'

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: );
102:
103:

Line 118: and event_object = 'EDW_PROJ_TASK_LTC.DENORM_TASK_ORG_FK'

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:
121: -- Step 8. commit changes.
122: