111: end if;
112: --Enh#4418520-aguwalan
113: IF(BIS_CREATE_REQUESTSET.is_history_collect_on(l_root_request_id)) THEN
114: begin
115: bis_collection_utilities.put_line('Calling BIS_COLL_RS_HISTORY.insert_program_object_data ');
116: if nvl(l_object_owner,'NOTFOUND')<>'NOTFOUND' then
117: BIS_COLL_RS_HISTORY.insert_program_object_data
118: (x_request_id => l_request_id,
119: x_stage_req_id =>null,
113: IF(BIS_CREATE_REQUESTSET.is_history_collect_on(l_root_request_id)) THEN
114: begin
115: bis_collection_utilities.put_line('Calling BIS_COLL_RS_HISTORY.insert_program_object_data ');
116: if nvl(l_object_owner,'NOTFOUND')<>'NOTFOUND' then
117: BIS_COLL_RS_HISTORY.insert_program_object_data
118: (x_request_id => l_request_id,
119: x_stage_req_id =>null,
120: x_object_name =>objectname,
121: x_object_type =>objecttype,
123: x_set_request_id =>l_root_request_id);
124: end if;
125:
126: if l_object_log is not null and l_num_rows<>0 then
127: BIS_COLL_RS_HISTORY.insert_program_object_data
128: (x_request_id => l_request_id,
129: x_stage_req_id =>null,
130: x_object_name =>l_object_log,
131: x_object_type =>'MV_LOG',
132: x_refresh_type =>'ANALYZED',
133: x_set_request_id =>l_root_request_id);
134: end if;
135:
136: bis_collection_utilities.put_line('Called BIS_COLL_RS_HISTORY.insert_program_object_data');
137: exception
138: when others then
139: bis_collection_utilities.put_line('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data'||sqlcode||sqlerrm);
140: raise;
135:
136: bis_collection_utilities.put_line('Called BIS_COLL_RS_HISTORY.insert_program_object_data');
137: exception
138: when others then
139: bis_collection_utilities.put_line('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data'||sqlcode||sqlerrm);
140: raise;
141: end;
142: ELSE
143: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');