APPS.EDW_POA_DIST_HOOK dependencies on EDW_OWB_COLLECTION_UTIL

Line 7: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering PO Distributions Pre Fact Hook Procedure');

3:
4: function Pre_Fact_Collect(p_object_name varchar2) return boolean is
5: begin
6: -- Update UNSPSC
7: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering PO Distributions Pre Fact Hook Procedure');
8:
9: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
10: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Table to reference UNSPSC Dimension');
11:

Line 10: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Table to reference UNSPSC Dimension');

6: -- Update UNSPSC
7: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering PO Distributions Pre Fact Hook Procedure');
8:
9: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
10: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Table to reference UNSPSC Dimension');
11:
12: Update POA_EDW_PO_DIST_FSTG Fact
13: set UNSPSC_FK =
14: (select Com.Function

Line 30: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Tables to reference DUNS and SIC Code Dimension');

26: where (Com.Item_PK = IOrg.Item_Number_FK) and
27: (IOrg.Item_Org_PK = IRev.Item_Org_FK))));
28:
29: -- Update DUNS
30: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Staging Tables to reference DUNS and SIC Code Dimension');
31:
32: Update POA_EDW_PO_DIST_FSTG Fact
33: set (DUNS_FK, SIC_CODE_FK) =
34: (select Com.DUNS, Com.SIC_Code

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

37: where ((Fact.Collection_Status = 'READY') and
38: (Fact.Supplier_Site_FK IN (select Trading_Partner_PK
39: from POA_DNB_TRD_PRTNR)));
40: ELSE
41: EDW_OWB_COLLECTION_UTIL.write_to_log_file('DNB is disabled');
42: END IF;
43:
44: return true;
45: end Pre_Fact_Collect;