[Home] [Help]
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
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;
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:
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;
2146: p_refresh_mode ,
2147: p_force_full_refresh );
2148:
2149: /* changes for 'view request set history': insert record into
2150: bis_request_set_objects. */
2151: create_rs_objects(upper(p_setname), p_setapp, p_object_type,
2152: p_object_name , p_object_owner);
2153:
2154:
2327:
2328: cursor c_pages is
2329: select distinct a.object_name,a.object_type
2330: from
2331: bis_request_set_objects a,
2332: fnd_request_sets b,
2333: fnd_application c
2334: where a.request_set_name=b.request_set_name
2335: and a.set_app_id=b.application_id
3204: IF( p_object_name = l_func1 AND
3205: l_func1 = l_func2 ) THEN
3206: log(l_module, 'Migrating ' || p_object_name || '_OA' || ' to '|| p_object_name);
3207: l_stmt :='
3208: UPDATE bis_request_set_objects
3209: set object_name = :1
3210: where object_name = :2
3211: and object_type = ''PAGE''
3212: ';
3225: fetch c_owner into l_object_owner;
3226: close c_owner;
3227: else l_object_owner:=p_object_owner;
3228: end if;
3229: l_stmt := 'insert into bis_request_set_objects(request_set_name, set_app_id,
3230: object_type,object_name, object_owner, CREATED_BY,
3231: CREATION_DATE,LAST_UPDATED_BY,
3232: LAST_UPDATE_LOGIN,LAST_UPDATE_DATE) values
3233: (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10)';
3249: begin
3250: ---- ----dbms_output.put_Line('within delete rs objects');
3251: select APPLICATION_ID into l_set_app_id from fnd_application where
3252: application_short_name=p_set_app;
3253: l_stmt := 'delete bis_request_set_objects where request_set_name=:a and
3254: set_app_id=:b';
3255: EXECUTE IMMEDIATE l_stmt USING p_set_name, l_set_app_id;
3256: commit;
3257: --------dbms_output.put_Line('end of delete rs objects');
3538: procedure check_unimpl_objects_is_sets(p_request_set_code in varchar2) is
3539:
3540: cursor c_unimpl_obj_in_set is
3541: select distinct a.object_type, bis_impl_dev_pkg.get_user_object_name(a.object_type,a.object_name) user_object_name
3542: from bis_request_set_objects a,
3543: bis_obj_properties b
3544: where a.request_set_name=p_request_set_code
3545: and a.set_app_id=191
3546: and a.object_type=b.object_type
3551:
3552:
3553: cursor c_set_with_unimpl_obj is
3554: select distinct c.user_request_set_name from
3555: bis_request_set_objects a,
3556: bis_obj_properties b,
3557: fnd_request_sets_vl c
3558: where a.object_name=b.object_name
3559: and a.object_type=b.object_type
3930:
3931: cursor c_page_objects is
3932: select distinct a.object_name,a.object_type
3933: from
3934: bis_request_set_objects a,
3935: fnd_request_sets b
3936: where a.request_set_name=b.request_set_name
3937: and a.set_app_id=b.application_id
3938: and b.request_set_name=p_request_set_code
4146:
4147: cursor c_pages is
4148: select distinct a.object_name,a.object_type
4149: from
4150: bis_request_set_objects a,
4151: fnd_request_sets b,
4152: fnd_application c
4153: where a.request_set_name=b.request_set_name
4154: and a.set_app_id=b.application_id