APPS.BEN_CWB_INTEGRATOR_COPY dependencies on BNE_SECURITY_RULES

Line 335: cursor c_bne_security_rules(

331: and v.object_type = 'INTEGRATOR'
332: and a.application_short_name = 'PER'
333: order by a.application_short_name, v.object_code, v.object_type;
334:
335: cursor c_bne_security_rules(
336: v_security_rule_code IN VARCHAR2) is
337: select a.application_short_name,
338: v.security_code,
339: v.object_version_number,

Line 344: from bne_security_rules v, fnd_application a

340: v.security_type,
341: v.security_value,
342: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
343: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
344: from bne_security_rules v, fnd_application a
345: where v.application_id = a.application_id
346: and v.security_code = v_security_rule_code
347: and a.application_short_name = 'PER'
348: order by a.application_short_name, v.security_code;

Line 703: FOR l_bne_security_rule in c_bne_security_rules (l_bne_secured_object.rule_security_rule_code)

699: x_last_update_date => l_bne_secured_object.last_update_date ,
700: x_custom_mode => null
701: );
702: l_step := 'Security rule Creation';
703: FOR l_bne_security_rule in c_bne_security_rules (l_bne_secured_object.rule_security_rule_code)
704: LOOP
705: bne_security_rules_pkg.load_row(
706: x_security_rule_asn => l_bne_security_rule.application_short_name ,
707: x_security_rule_code =>

Line 705: bne_security_rules_pkg.load_row(

701: );
702: l_step := 'Security rule Creation';
703: FOR l_bne_security_rule in c_bne_security_rules (l_bne_secured_object.rule_security_rule_code)
704: LOOP
705: bne_security_rules_pkg.load_row(
706: x_security_rule_asn => l_bne_security_rule.application_short_name ,
707: x_security_rule_code =>
708: l_new_integrator_code,
709: x_object_version_number=> 1 ,