[Home] [Help]
236: and opt.request_set_name = sets.request_set_name
237: and opt.option_name = 'FORCE_FULL';
238:
239: BEGIN
240: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
241: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
242: open c_force_full(l_root_request_id);
243: fetch c_force_full into l_rs_name, l_is_force_full;
244: close c_force_full;
237: and opt.option_name = 'FORCE_FULL';
238:
239: BEGIN
240: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
241: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
242: open c_force_full(l_root_request_id);
243: fetch c_force_full into l_rs_name, l_is_force_full;
244: close c_force_full;
245: BIS_COLLECTION_UTILITIES.put_line('Request Set: ' || l_rs_name || ', ' || 'FORCE_FULL option: ' || l_is_force_full);
1048: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
1049: return;
1050: END IF;
1051:
1052: l_prog_req_id:=fnd_global.CONC_REQUEST_ID;
1053:
1054:
1055: logmsg('This program is for RSG internal use only. ');
1056: logmsg('The purpose of this program is to make sure ');
1342: errbuf := NULL;
1343: retcode := '0';
1344:
1345: -- get current request id information from FND to put in Summary report table.
1346: prog_request_id := FND_GLOBAL.conc_request_id;
1347:
1348: IF (Not BIS_COLLECTION_UTILITIES.setup(P_MVNAME)) THEN
1349: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || sqlerrm);
1350: return;
1403: -----For MVs processed by "BIS Materialized View Batch Refresh Program for MVs not to implement",
1404: -----we will record them to history table in procedure CONSIDER_REFRESH
1405:
1406: -- Enh#4418520-aguwalan
1407: IF (BIS_CREATE_REQUESTSET.is_history_collect_on(FND_GLOBAL.CONC_PRIORITY_REQUEST)) THEN
1408: BIS_COLL_RS_HISTORY.insert_program_object_data
1409: (
1410: x_request_id => prog_request_id,
1411: x_stage_req_id => null,
1411: x_stage_req_id => null,
1412: x_object_name => P_MVNAME ,
1413: x_object_type => 'MV',
1414: x_refresh_type => l_mv_refresh_type,
1415: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
1416: ELSE
1417: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1418: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
1419: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');