DBA Data[Home] [Help]

APPS.BIS_MV_REFRESH dependencies on FND_GLOBAL

Line 240: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;

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;

Line 241: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);

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);

Line 1048: l_prog_req_id:=fnd_global.CONC_REQUEST_ID;

1044: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
1045: return;
1046: END IF;
1047:
1048: l_prog_req_id:=fnd_global.CONC_REQUEST_ID;
1049:
1050:
1051: logmsg('This program is for RSG internal use only. ');
1052: logmsg('The purpose of this program is to make sure ');

Line 1342: prog_request_id := FND_GLOBAL.conc_request_id;

1338: errbuf := NULL;
1339: retcode := '0';
1340:
1341: -- get current request id information from FND to put in Summary report table.
1342: prog_request_id := FND_GLOBAL.conc_request_id;
1343:
1344: IF (Not BIS_COLLECTION_UTILITIES.setup(P_MVNAME)) THEN
1345: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || sqlerrm);
1346: return;

Line 1403: IF (BIS_CREATE_REQUESTSET.is_history_collect_on(FND_GLOBAL.CONC_PRIORITY_REQUEST)) THEN

1399: -----For MVs processed by "BIS Materialized View Batch Refresh Program for MVs not to implement",
1400: -----we will record them to history table in procedure CONSIDER_REFRESH
1401:
1402: -- Enh#4418520-aguwalan
1403: IF (BIS_CREATE_REQUESTSET.is_history_collect_on(FND_GLOBAL.CONC_PRIORITY_REQUEST)) THEN
1404: BIS_COLL_RS_HISTORY.insert_program_object_data
1405: (
1406: x_request_id => prog_request_id,
1407: x_stage_req_id => null,

Line 1411: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);

1407: x_stage_req_id => null,
1408: x_object_name => P_MVNAME ,
1409: x_object_type => 'MV',
1410: x_refresh_type => l_mv_refresh_type,
1411: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
1412: ELSE
1413: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1414: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
1415: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');