APPS.POA_SIC_CODE_HOOK dependencies on EDW_OWB_COLLECTION_UTIL

Line 9: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering SIC Code Post Dimension Hook Procedure');

5: CURSOR c_sic IS
6: Select SIC_CODE_PK from EDW_SICM_SIC_LSTG
7: where Update_Fact_Flag = 'Y';
8: begin
9: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering SIC Code Post Dimension Hook Procedure');
10:
11: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
12: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Exiting POA Facts to reference SIC Code Dimension');
13:

Line 12: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Exiting POA Facts to reference SIC Code Dimension');

8: begin
9: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering SIC Code Post Dimension Hook Procedure');
10:
11: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
12: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Exiting POA Facts to reference SIC Code Dimension');
13:
14: FOR lsic in c_sic LOOP
15: -- Update all facts
16:

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

110: (TPrt.TPartner_Loc_PK = dnb.Trading_Partner_PK))));
111:
112: END LOOP;
113:
114: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated POA Facts');
115: ELSE
116: EDW_OWB_COLLECTION_UTIL.write_to_log_file('DNB is disabled');
117: END IF;
118:

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

112: END LOOP;
113:
114: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated POA Facts');
115: ELSE
116: EDW_OWB_COLLECTION_UTIL.write_to_log_file('DNB is disabled');
117: END IF;
118:
119: return true;
120: end Post_Dim_Collect;