APPS.EDW_POA_RCV_TXNS_HOOK dependencies on EDW_OWB_COLLECTION_UTIL

Line 7: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering Recieving 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 Recieving 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 Recieving 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_RCV_TXNS_FSTG Fact
13: set UNSPSC_FK =
14: (select Com.Function

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

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

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

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