eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_CREATE_REQUESTSET dependencies on FND_GLOBAL

Line 15: g_current_user_id NUMBER := FND_GLOBAL.User_id;

11: g_reset_flag_app varchar2(30);
12: g_start_stage number ;
13: -- g_set_all_name varchar2(30);
14: -- g_set_all_longname varchar2(240);
15: g_current_user_id NUMBER := FND_GLOBAL.User_id;
16: g_current_login_id NUMBER := FND_GLOBAL.Login_id;
17: g_req_monitoring_err EXCEPTION;
18:
19: g_bsc_loader_ind_program varchar2(30):='BSC_REFRESH_SUMMARY_IND';

Line 16: g_current_login_id NUMBER := FND_GLOBAL.Login_id;

12: g_start_stage number ;
13: -- g_set_all_name varchar2(30);
14: -- g_set_all_longname varchar2(240);
15: g_current_user_id NUMBER := FND_GLOBAL.User_id;
16: g_current_login_id NUMBER := FND_GLOBAL.Login_id;
17: g_req_monitoring_err EXCEPTION;
18:
19: g_bsc_loader_ind_program varchar2(30):='BSC_REFRESH_SUMMARY_IND';
20: g_bsc_loader_dim_program varchar2(30):='BSC_REFRESH_DIM_IND';

Line 128: --g_set_application:=fnd_global.application_short_name;

124:
125: begin
126: l_group_name:='DBI Requests and Reports';
127: l_group_app:='BIS';
128: --g_set_application:=fnd_global.application_short_name;
129: --- g_set_application:='BIS';
130: ----Based on the demo meeting on August 28, 2002
131: ----Need to add the set to DBI requests group attached to Business Intelligence Administrator resp
132: if set_in_group(p_setname,p_setapp,l_group_name,l_group_app)='Y' then

Line 221: --g_set_application:=fnd_global.application_short_name;

217: l_group_name:='DBI Requests and Reports';
218: l_group_app:='BIS';
219:
220:
221: --g_set_application:=fnd_global.application_short_name;
222: --- g_set_application:='BIS';
223: ----Based on the demo meeting on August 28, 2002
224: ----Need to add the set to DBI requests group attached to Business Intelligence Administrator resp
225: if set_in_group(p_setname,p_setapp,l_group_name,l_group_app)='Y' then

Line 3127: g_current_user_id := FND_GLOBAL.User_id;

3123: l_set_app_id number;
3124:
3125: begin
3126: -- perform
3127: g_current_user_id := FND_GLOBAL.User_id;
3128: g_current_login_id := FND_GLOBAL.Login_id;
3129:
3130: select APPLICATION_ID into l_set_app_id from fnd_application where
3131: application_short_name=p_set_app;

Line 3128: g_current_login_id := FND_GLOBAL.Login_id;

3124:
3125: begin
3126: -- perform
3127: g_current_user_id := FND_GLOBAL.User_id;
3128: g_current_login_id := FND_GLOBAL.Login_id;
3129:
3130: select APPLICATION_ID into l_set_app_id from fnd_application where
3131: application_short_name=p_set_app;
3132: l_stmt := 'insert into bis_request_set_options(request_set_name, set_app_id,

Line 3179: g_current_user_id := FND_GLOBAL.User_id;

3175: l_rows integer;
3176:
3177: begin
3178: log(l_module, 'Inside ' || l_module );
3179: g_current_user_id := FND_GLOBAL.User_id;
3180: g_current_login_id := FND_GLOBAL.Login_id;
3181:
3182: -- bug#3426783.
3183: -- added to strip _OA on the fly, if the page name has been migrated

Line 3180: g_current_login_id := FND_GLOBAL.Login_id;

3176:
3177: begin
3178: log(l_module, 'Inside ' || l_module );
3179: g_current_user_id := FND_GLOBAL.User_id;
3180: g_current_login_id := FND_GLOBAL.Login_id;
3181:
3182: -- bug#3426783.
3183: -- added to strip _OA on the fly, if the page name has been migrated
3184: IF(p_object_type = 'PAGE') THEN

Line 3436: -- := FND_GLOBAL.conc_request_id

3432: l_dev_status varchar2(200);
3433: l_message varchar2(200);
3434:
3435: begin
3436: -- := FND_GLOBAL.conc_request_id
3437: l_req_id := p_req_id;
3438: -- make it runnable under sql-plus, as the current req-id will be
3439: -- set to -1.
3440: if l_req_id = -1 THEN

Line 3510: EXIT WHEN NOT ( l_status = 1 and is_req_alive(FND_GLOBAL.conc_request_id) and is_req_alive(p_request_id) );

3506: dbms_alert.register(l_alertname);
3507: LOOP
3508: --dbms_alert.waitone(l_alertname,l_message,l_status, 60*5);
3509: dbms_alert.waitone(l_alertname,l_message,l_status, 60*1);
3510: EXIT WHEN NOT ( l_status = 1 and is_req_alive(FND_GLOBAL.conc_request_id) and is_req_alive(p_request_id) );
3511: END LOOP;
3512: dbms_alert.remove(l_alertname);
3513: end;
3514: **/

Line 3525: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.conc_request_id '||FND_GLOBAL.conc_request_id);

3521: commit;
3522: LOOP
3523: dbms_lock.sleep(10);
3524: BIS_COLLECTION_UTILITIES.put_line('inside the loop of waitforrequest');
3525: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.conc_request_id '||FND_GLOBAL.conc_request_id);
3526: BIS_COLLECTION_UTILITIES.put_line('p_request_id'||p_request_id);
3527: EXIT WHEN NOT ( is_req_alive(FND_GLOBAL.conc_request_id) and is_req_alive(p_request_id) );
3528: --EXIT WHEN NOT ( is_req_alive(p_request_id) );
3529: END LOOP;

Line 3527: EXIT WHEN NOT ( is_req_alive(FND_GLOBAL.conc_request_id) and is_req_alive(p_request_id) );

3523: dbms_lock.sleep(10);
3524: BIS_COLLECTION_UTILITIES.put_line('inside the loop of waitforrequest');
3525: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.conc_request_id '||FND_GLOBAL.conc_request_id);
3526: BIS_COLLECTION_UTILITIES.put_line('p_request_id'||p_request_id);
3527: EXIT WHEN NOT ( is_req_alive(FND_GLOBAL.conc_request_id) and is_req_alive(p_request_id) );
3528: --EXIT WHEN NOT ( is_req_alive(p_request_id) );
3529: END LOOP;
3530:
3531: end;

Line 3664: open get_req_set_details(FND_GLOBAL.CONC_PRIORITY_REQUEST);

3660:
3661: -- Enh#4418520-aguwalan
3662: IF(is_history_collect_on(p_request_set_code, 191)) THEN
3663: --Add entry of this request set in table BIS_RS_RUN_HISTORY Enh#3473874 aguwalan
3664: open get_req_set_details(FND_GLOBAL.CONC_PRIORITY_REQUEST);
3665: fetch get_req_set_details into l_req_set_appl_id, l_req_set_id;
3666: close get_req_set_details;
3667:
3668: BEGIN

Line 3674: p_root_req_id =>FND_GLOBAL.CONC_PRIORITY_REQUEST);

3670:
3671: BIS_COLL_RS_HISTORY.add_rsg_rs_run_record(p_request_set_id =>l_req_set_id,
3672: p_request_set_appl_id => l_req_set_appl_id,
3673: p_request_name => p_request_set_code,
3674: p_root_req_id =>FND_GLOBAL.CONC_PRIORITY_REQUEST);
3675: EXCEPTION WHEN OTHERS THEN
3676: BIS_COLLECTION_UTILITIES.put_line('Exception while adding record for RS Run in BIS_RS_RUN_HISTORY_TABLE or updating terminated request set. ignorable exception ' || sqlerrm);
3677: errbuf := sqlerrm;
3678: retcode := sqlcode;

Line 3782: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;

3778: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || sqlerrm);
3779: return;
3780: END IF;
3781:
3782: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
3783: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
3784: fnd_profile.put ('CONC_SINGLE_THREAD','N');
3785:
3786: l_request_id := FND_REQUEST.SUBMIT_REQUEST (

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

3779: return;
3780: END IF;
3781:
3782: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
3783: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
3784: fnd_profile.put ('CONC_SINGLE_THREAD','N');
3785:
3786: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
3787: 'BIS',

Line 4036: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);

4032: x_stage_req_id => null,
4033: x_object_name => l_kpi_list,
4034: x_object_type => 'BSC_CUSTOM_KPI',
4035: x_refresh_type => loading_mode(p_request_set_code),
4036: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
4037: END IF;
4038: end if;
4039: BIS_COLLECTION_UTILITIES.put_line('Call loader program to load custom dimensions');
4040: l_request_id := FND_REQUEST.SUBMIT_REQUEST (

Line 4057: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);

4053: x_stage_req_id => null,
4054: x_object_name => l_kpi_list,
4055: x_object_type => 'BSC_CUSTOM_KPI',
4056: x_refresh_type => loading_mode(p_request_set_code),
4057: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
4058: END IF;
4059: BIS_COLLECTION_UTILITIES.put_line('Call loader program to load data for indicators');
4060: l_request_id := FND_REQUEST.SUBMIT_REQUEST (
4061: 'BSC',

Line 4078: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);

4074: x_stage_req_id => null,
4075: x_object_name => l_kpi_list,
4076: x_object_type => 'BSC_CUSTOM_KPI',
4077: x_refresh_type => loading_mode(p_request_set_code),
4078: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
4079: END IF;
4080: end if;
4081: BIS_COLLECTION_UTILITIES.put_line('********************************************');
4082:

Line 4326: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;

4322:
4323: BEGIN
4324: ---Add RSG History Report program at the end of the request set
4325:
4326: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
4327: if (p_rsg_history_flag = 'Y') then
4328: fnd_set.add_stage
4329: (name=>g_stage_prompt||' '||to_char(p_max_stage+50),
4330: request_set=>upper(p_set_name),

Line 4456: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;

4452: l_name VARCHAR2(240);
4453: l_type VARCHAR2(10);
4454: l_program_status BOOLEAN;
4455: BEGIN
4456: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
4457: BIS_COLLECTION_UTILITIES.put_line('Checking the status of all the program of the Request Set :: RequestId#'||l_root_request_id);
4458: OPEN c_get_all_prog_status;
4459: FETCH c_get_all_prog_status INTO l_request_id, l_name, l_type;
4460: CLOSE c_get_all_prog_status;