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 BIS_REQUEST_SET_OPTIONS

Line 152: bis_request_set_options and bis_request_set_objects if the request

148:
149: if l_setname is not null then
150: fnd_set.delete_set(upper(l_setname),p_setapp);
151: /* changes for 'view request set history': delete from
152: bis_request_set_options and bis_request_set_objects if the request
153: set already exists in these tables. */
154: delete_rs_objects(upper(l_setname), p_setapp);
155: delete_rs_option(upper(l_setname), p_setapp);
156: else

Line 159: bis_request_set_options and bis_request_set_objects if the request

155: delete_rs_option(upper(l_setname), p_setapp);
156: else
157: fnd_set.delete_set(upper(p_setname),p_setapp);
158: /* changes for 'view request set history': delete from
159: bis_request_set_options and bis_request_set_objects if the request
160: set already exists in these tables. */
161: delete_rs_objects(upper(p_setname), p_setapp);
162: delete_rs_option(upper(p_setname), p_setapp);
163: end if;

Line 247: bis_request_set_options and bis_request_set_objects if the request

243:
244: if l_setname is not null then
245: fnd_set.delete_set(upper(l_setname),p_setapp);
246: /* changes for 'view request set history': delete from
247: bis_request_set_options and bis_request_set_objects if the request
248: set already exists in these tables. */
249: delete_rs_objects(upper(l_setname), p_setapp);
250: delete_rs_option(upper(l_setname), p_setapp);
251:

Line 255: bis_request_set_options and bis_request_set_objects if the request

251:
252: else
253: fnd_set.delete_set(upper(p_setname),p_setapp);
254: /* changes for 'view request set history': delete from
255: bis_request_set_options and bis_request_set_objects if the request
256: set already exists in these tables. */
257: delete_rs_objects(upper(p_setname), p_setapp);
258: delete_rs_option(upper(p_setname), p_setapp);
259: end if;

Line 3111: bis_request_set_options. */

3107:
3108:
3109:
3110: /* changes for 'view request set history': insert record into
3111: bis_request_set_options. */
3112: create_rs_option(upper(p_setname), p_setapp,
3113: p_refresh_mode, p_analyze_table,p_force_full_refresh, p_alert_flag, p_rsg_history_flag);
3114:
3115:

Line 3132: l_stmt := 'insert into bis_request_set_options(request_set_name, set_app_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,
3133: option_name,option_value, CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
3134: LAST_UPDATE_LOGIN,LAST_UPDATE_DATE) values
3135: (:1,:2,:3,:4,:5,:6,:7,:8,:9)';
3136: EXECUTE IMMEDIATE l_stmt USING p_set_name, l_set_app_id,'REFRESH_MODE',p_refresh_mode,

Line 3267: l_stmt := 'delete bis_request_set_options where request_set_name=:a and

3263: begin
3264: -- ----dbms_output.put_Line('within delete rs options');
3265: select APPLICATION_ID into l_set_app_id from fnd_application where
3266: application_short_name=p_set_app;
3267: l_stmt := 'delete bis_request_set_options where request_set_name=:a and
3268: set_app_id=:b';
3269: EXECUTE IMMEDIATE l_stmt USING p_set_name, l_set_app_id;
3270: COMMIT;
3271: --------dbms_output.put_Line('end of delete rs options');

Line 3475: CURSOR C_ALERT_FLAG ( pReqCode bis_request_set_options.OPTION_NAME%type )

3471: end;
3472:
3473: FUNCTION isSubmitAlert(pReqCode VARCHAR2) RETURN BOOLEAN
3474: IS
3475: CURSOR C_ALERT_FLAG ( pReqCode bis_request_set_options.OPTION_NAME%type )
3476: IS
3477: select NVL(OPTION_VALUE, 'N')
3478: from bis_request_set_options
3479: where request_set_name = pReqCode

Line 3478: from bis_request_set_options

3474: IS
3475: CURSOR C_ALERT_FLAG ( pReqCode bis_request_set_options.OPTION_NAME%type )
3476: IS
3477: select NVL(OPTION_VALUE, 'N')
3478: from bis_request_set_options
3479: where request_set_name = pReqCode
3480: and OPTION_NAME = 'ALERT_FLAG';
3481: l_flag VARCHAR2(10) := NULL;
3482: BEGIN

Line 3612: from bis_request_set_options

3608: l_program_status boolean :=true;
3609:
3610: cursor refresh_mode is
3611: select option_value
3612: from bis_request_set_options
3613: where request_set_name=p_request_set_code
3614: and SET_APP_ID=191
3615: and option_name='REFRESH_MODE';
3616:

Line 3619: from bis_request_set_options

3615: and option_name='REFRESH_MODE';
3616:
3617: cursor force_full_refresh is
3618: select option_value
3619: from bis_request_set_options
3620: where request_set_name=p_request_set_code
3621: and set_app_id=191
3622: and option_name='FORCE_FULL';
3623:

Line 3881: from bis_request_set_options

3877: l_loading_mode varchar2(30);
3878: begin
3879: l_loading_mode:=null;
3880: select distinct option_value into l_loading_mode
3881: from bis_request_set_options
3882: where request_set_name=p_request_set_name
3883: and option_name='REFRESH_MODE';
3884: return l_loading_mode;
3885: exception

Line 3899: from bis_request_set_options

3895: l_force_full_refresh varchar2(30);
3896: begin
3897: l_force_full_refresh:=null;
3898: select distinct option_value into l_force_full_refresh
3899: from bis_request_set_options
3900: where request_set_name=p_request_set_name
3901: and option_name='FORCE_FULL';
3902: return l_force_full_refresh;
3903: exception

Line 4490: from bis_request_set_options

4486: IS
4487: CURSOR c_history_coll_option(rs_name VARCHAR2, rs_app_id NUMBER)
4488: IS
4489: select NVL(OPTION_VALUE, 'Y')
4490: from bis_request_set_options
4491: where request_set_name = rs_name
4492: and set_app_id = rs_app_id
4493: and OPTION_NAME = 'HISTORY_COLLECT';
4494: l_flag VARCHAR2(10);