APPS.BEN_CWB_INTEGRATOR_COPY dependencies on BNE_MAPPING_LINES

Line 208: cursor c_bne_mapping_lines (

204: and v.integrator_code = p_integrator_code
205: and a.application_short_name = 'PER'
206: order by a.application_short_name, v.mapping_code;
207:
208: cursor c_bne_mapping_lines (
209: v_mapping_code IN VARCHAR2 ) is
210: select v.sequence_num,
211: substr(bne_lct_tools_pkg.app_id_to_asn(v.interface_app_id),1,30) interface_asn,
212: v.interface_code,

Line 221: from bne_mapping_lines v, fnd_application a

217: substr(bne_lct_tools_pkg.app_id_to_asn(v.content_app_id),1,30) content_asn,
218: v.content_code,
219: v.content_seq_num,
220: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
221: from bne_mapping_lines v, fnd_application a
222: where v.application_id = a.application_id
223: and v.mapping_code = v_mapping_code
224: and a.application_short_name = 'PER'
225: order by a.application_short_name, v.mapping_code, v.sequence_num;

Line 562: FOR l_bne_mapping_line in c_bne_mapping_lines (l_bne_mapping.mapping_code)

558: x_custom_mode => null
559: );
560: -- fnd_file.put_line(Fnd_file.LOG,'4.2.Creating the mapping lines...');
561: l_step := 'Mapping Lines Creation';
562: FOR l_bne_mapping_line in c_bne_mapping_lines (l_bne_mapping.mapping_code)
563: LOOP
564: bne_mapping_lines_pkg.load_row(
565: x_mapping_asn => 'PER' ,
566: x_mapping_code => l_new_mapping_code ,

Line 564: bne_mapping_lines_pkg.load_row(

560: -- fnd_file.put_line(Fnd_file.LOG,'4.2.Creating the mapping lines...');
561: l_step := 'Mapping Lines Creation';
562: FOR l_bne_mapping_line in c_bne_mapping_lines (l_bne_mapping.mapping_code)
563: LOOP
564: bne_mapping_lines_pkg.load_row(
565: x_mapping_asn => 'PER' ,
566: x_mapping_code => l_new_mapping_code ,
567: x_interface_asn => l_bne_mapping_line.interface_asn ,
568: x_interface_code => l_new_interface_code ,