APPS.EDW_POA_UNSPSC_HOOK dependencies on EDW_OWB_COLLECTION_UTIL

Line 8: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering UNSPSC Post Dimension Hook Procedure');

4: CURSOR c_items IS
5: Select Function_PK from EDW_SPSC_FUNCTION_LSTG
6: where Update_Fact_Flag = 'Y';
7: begin
8: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering UNSPSC Post Dimension Hook Procedure');
9:
10: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
11: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Existing POA facts to reference UNSPSC Dimension');
12:

Line 11: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Existing POA facts to reference UNSPSC Dimension');

7: begin
8: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering UNSPSC Post Dimension Hook Procedure');
9:
10: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
11: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Existing POA facts to reference UNSPSC Dimension');
12:
13: FOR litem in c_items LOOP
14: -- Update all facts
15:

Line 95: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated Existing POA Facts');

91: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));
92:
93: END LOOP;
94:
95: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated Existing POA Facts');
96:
97: -- Call AP to update its Facts
98: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating FII Facts');
99:

Line 98: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating FII Facts');

94:
95: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated Existing POA Facts');
96:
97: -- Call AP to update its Facts
98: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating FII Facts');
99:
100: return EDW_SICM_UNSPSC_HOOK.Post_Dim_Collect(p_object_name);
101: ELSE
102: EDW_OWB_COLLECTION_UTIL.write_to_log_file('DNB is disabled');

Line 102: EDW_OWB_COLLECTION_UTIL.write_to_log_file('DNB is disabled');

98: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating FII Facts');
99:
100: return EDW_SICM_UNSPSC_HOOK.Post_Dim_Collect(p_object_name);
101: ELSE
102: EDW_OWB_COLLECTION_UTIL.write_to_log_file('DNB is disabled');
103: END IF;
104:
105: return true;
106: end Post_Dim_Collect;