[Home] [Help]
58: substr(bne_lct_tools_pkg.app_id_to_asn(s.application_id),1,30),
59: s.object_code,
60: s.object_type,
61: v.display_flag
62: from bne_integrators_vl v, bne_secured_objects s, fnd_application a
63: where v.application_id = a.application_id
64: and v.application_id = s.application_id (+)
65: and v.integrator_code = s.object_code (+)
66: and s.object_type (+) = 'INTEGRATOR'
314: and a.application_short_name = 'PER'
315: and v.block_id = v_block_id
316: order by a.application_short_name, v.layout_code, v.block_id, v.sequence_num;
317:
318: cursor c_bne_secured_objects is
319: select a.application_short_name,
320: v.object_code,
321: v.object_type,
322: v.object_version_number,
324: v.security_rule_code rule_security_rule_code,
325: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
326: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
327: v.security_rule_app_id
328: from bne_secured_objects v, fnd_application a
329: where v.application_id = a.application_id
330: and v.object_code = p_integrator_code
331: and v.object_type = 'INTEGRATOR'
332: and a.application_short_name = 'PER'
685: END LOOP; -- layouts
686:
687: fnd_file.put_line(Fnd_file.LOG,'6.Creating the secured objects...');
688: l_step := 'Secured objects Creation';
689: FOR l_bne_secured_object in c_bne_secured_objects
690: LOOP
691: bne_secured_objects_pkg.load_row(
692: x_secured_object_asn => l_bne_secured_object.application_short_name ,
693: x_secured_object_code => l_new_integrator_code ,
687: fnd_file.put_line(Fnd_file.LOG,'6.Creating the secured objects...');
688: l_step := 'Secured objects Creation';
689: FOR l_bne_secured_object in c_bne_secured_objects
690: LOOP
691: bne_secured_objects_pkg.load_row(
692: x_secured_object_asn => l_bne_secured_object.application_short_name ,
693: x_secured_object_code => l_new_integrator_code ,
694: x_secured_object_type => l_bne_secured_object.object_type ,
695: x_object_version_number=> 1 ,