APPS.EDW_POA_DUNS_HOOK dependencies on EDW_OWB_COLLECTION_UTIL

Line 9: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering Duns Post Dimension Hook rocedure');

5: CURSOR c_duns IS
6: Select DUNS_NUM_PK from EDW_DUNS_NUMBER_LSTG
7: where Update_Fact_Flag = 'Y';
8: begin
9: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering Duns Post Dimension Hook rocedure');
10:
11: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
12: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Exisiting POA Facts to refer to DUNS Dimension');
13:

Line 12: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Exisiting POA Facts to refer to DUNS Dimension');

8: begin
9: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Entering Duns Post Dimension Hook rocedure');
10:
11: IF (fnd_profile.value('POA_DNB_HOOKS') = 'N') THEN
12: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating Exisiting POA Facts to refer to DUNS Dimension');
13:
14: FOR lduns in c_duns LOOP
15: -- Update all facts
16:

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

93: where ((lduns.DUNS_NUM_PK = Com.DUNS) and
94: (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));
95:
96: END LOOP;
97: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated POA Facts');
98: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating FII Facts to refer to DUNS Dimension');
99: -- Call AP to update its Facts
100: return EDW_SICM_DUNS_HOOK.Post_Dim_Collect(p_object_name);
101: ELSE

Line 98: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating FII Facts to refer to DUNS Dimension');

94: (TPrt.TPartner_Loc_PK = Com.TRADING_PARTNER_PK))));
95:
96: END LOOP;
97: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updated POA Facts');
98: EDW_OWB_COLLECTION_UTIL.write_to_log_file('Updating FII Facts to refer to DUNS Dimension');
99: -- Call AP to update its Facts
100: return EDW_SICM_DUNS_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 to refer to DUNS Dimension');
99: -- Call AP to update its Facts
100: return EDW_SICM_DUNS_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;