APPS.EDW_UPDATE_ATTRIBUTES dependencies on EDW_OWB_COLLECTION_UTIL

Line 62: edw_owb_collection_util.write_to_log_file(p_msg);

58: l_length number;
59:
60: begin
61: IF (not g_separate_logging) THEN
62: edw_owb_collection_util.write_to_log_file(p_msg);
63: return;
64: END IF;
65:
66: l_count := 0;

Line 708: l_bis_schema varchar2(100):= EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');

704:
705: l_attribute_name varchar2(100);
706: b_temp_table_created boolean := false;
707:
708: l_bis_schema varchar2(100):= EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');
709: l_op_table_space varchar2(100) := fnd_profile.value('EDW_OP_TABLE_SPACE');
710:
711: CURSOR c_contexts (c_obj_name VARCHAR2, c_lvl VARCHAR2, c_attr VARCHAR2) IS
712: SELECT

Line 796: l_op_table_space := EDW_OWB_COLLECTION_UTIL.get_table_space(l_bis_schema);

792:
793:
794:
795: IF (l_op_table_space is null) THEN
796: l_op_table_space := EDW_OWB_COLLECTION_UTIL.get_table_space(l_bis_schema);
797: END IF;
798:
799: writelog('Object name is : '||p_object_name);
800: writelog('BIS Schema is : '||l_bis_schema);

Line 1083: edw_owb_collection_util.analyze_table_stats('INT_ROWIDS_'||l_object_id, l_bis_schema, 1);

1079: l_current_table||'(row_id)';
1080:
1081:
1082: writelog('Unique Index created, Time is :'||to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1083: edw_owb_collection_util.analyze_table_stats('INT_ROWIDS_'||l_object_id, l_bis_schema, 1);
1084:
1085:
1086: writelog('INT_ROWIDS_'||l_object_id||' analyzed, Time is :'||to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1087:

Line 1155: edw_owb_collection_util.analyze_table_stats('INT_USER_ATTRIBUTES_'||l_object_id, l_bis_schema, 1);

1151:
1152: writelog('Create unique index on INT_USER_ATTRIBUTES, '||
1153: 'Time is :'||to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1154:
1155: edw_owb_collection_util.analyze_table_stats('INT_USER_ATTRIBUTES_'||l_object_id, l_bis_schema, 1);
1156: writelog('Analyzed INT_USER_ATTRIBUTES, Time is :'||to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
1157:
1158:
1159: