APPS.BEN_CWB_INTEGRATOR_COPY dependencies on BNE_STORED_SQL

Line 179: cursor c_bne_stored_sql (

175: and v.content_code = v_content_code
176: and a.application_short_name = 'PER'
177: order by a.application_short_name, v.content_code, v.sequence_num;
178:
179: cursor c_bne_stored_sql (
180: v_content_code IN VARCHAR2 ) is
181: select v.object_version_number,
182: v.query,
183: substr(bne_lct_tools_pkg.app_id_to_asn(v.query_app_id),1,30) bne_query_query_asn,

Line 187: from bne_stored_sql v, fnd_application a

183: substr(bne_lct_tools_pkg.app_id_to_asn(v.query_app_id),1,30) bne_query_query_asn,
184: v.query_code,
185: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
186: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
187: from bne_stored_sql v, fnd_application a
188: where v.application_id = a.application_id
189: and v.content_code = v_content_code
190: and a.application_short_name = 'PER';
191:

Line 522: -- fnd_file.put_line(Fnd_file.LOG,'3.3.Creating the bne_stored_sql...');

518: );
519:
520: END LOOP; -- contents columns
521:
522: -- fnd_file.put_line(Fnd_file.LOG,'3.3.Creating the bne_stored_sql...');
523: l_step := 'Stored Sql Creation';
524: FOR l_bne_stored_sql in c_bne_stored_sql (l_bne_content.content_code)
525: LOOP
526: bne_stored_sql_pkg.load_row(

Line 524: FOR l_bne_stored_sql in c_bne_stored_sql (l_bne_content.content_code)

520: END LOOP; -- contents columns
521:
522: -- fnd_file.put_line(Fnd_file.LOG,'3.3.Creating the bne_stored_sql...');
523: l_step := 'Stored Sql Creation';
524: FOR l_bne_stored_sql in c_bne_stored_sql (l_bne_content.content_code)
525: LOOP
526: bne_stored_sql_pkg.load_row(
527: x_content_asn => 'PER' ,
528: x_content_code => l_new_content_code ,

Line 526: bne_stored_sql_pkg.load_row(

522: -- fnd_file.put_line(Fnd_file.LOG,'3.3.Creating the bne_stored_sql...');
523: l_step := 'Stored Sql Creation';
524: FOR l_bne_stored_sql in c_bne_stored_sql (l_bne_content.content_code)
525: LOOP
526: bne_stored_sql_pkg.load_row(
527: x_content_asn => 'PER' ,
528: x_content_code => l_new_content_code ,
529: x_object_version_number=> 1 ,
530: x_query => l_bne_stored_sql.query ,

Line 530: x_query => l_bne_stored_sql.query ,

526: bne_stored_sql_pkg.load_row(
527: x_content_asn => 'PER' ,
528: x_content_code => l_new_content_code ,
529: x_object_version_number=> 1 ,
530: x_query => l_bne_stored_sql.query ,
531: x_owner => l_bne_stored_sql.owner ,
532: x_last_update_date => l_bne_stored_sql.last_update_date ,
533: x_custom_mode => null ,
534: x_query_app_asn => l_bne_stored_sql.bne_query_query_asn ,

Line 531: x_owner => l_bne_stored_sql.owner ,

527: x_content_asn => 'PER' ,
528: x_content_code => l_new_content_code ,
529: x_object_version_number=> 1 ,
530: x_query => l_bne_stored_sql.query ,
531: x_owner => l_bne_stored_sql.owner ,
532: x_last_update_date => l_bne_stored_sql.last_update_date ,
533: x_custom_mode => null ,
534: x_query_app_asn => l_bne_stored_sql.bne_query_query_asn ,
535: x_query_code => l_bne_stored_sql.query_code

Line 532: x_last_update_date => l_bne_stored_sql.last_update_date ,

528: x_content_code => l_new_content_code ,
529: x_object_version_number=> 1 ,
530: x_query => l_bne_stored_sql.query ,
531: x_owner => l_bne_stored_sql.owner ,
532: x_last_update_date => l_bne_stored_sql.last_update_date ,
533: x_custom_mode => null ,
534: x_query_app_asn => l_bne_stored_sql.bne_query_query_asn ,
535: x_query_code => l_bne_stored_sql.query_code
536: );

Line 534: x_query_app_asn => l_bne_stored_sql.bne_query_query_asn ,

530: x_query => l_bne_stored_sql.query ,
531: x_owner => l_bne_stored_sql.owner ,
532: x_last_update_date => l_bne_stored_sql.last_update_date ,
533: x_custom_mode => null ,
534: x_query_app_asn => l_bne_stored_sql.bne_query_query_asn ,
535: x_query_code => l_bne_stored_sql.query_code
536: );
537:
538: END LOOP; -- bne_stored_sql

Line 535: x_query_code => l_bne_stored_sql.query_code

531: x_owner => l_bne_stored_sql.owner ,
532: x_last_update_date => l_bne_stored_sql.last_update_date ,
533: x_custom_mode => null ,
534: x_query_app_asn => l_bne_stored_sql.bne_query_query_asn ,
535: x_query_code => l_bne_stored_sql.query_code
536: );
537:
538: END LOOP; -- bne_stored_sql
539:

Line 538: END LOOP; -- bne_stored_sql

534: x_query_app_asn => l_bne_stored_sql.bne_query_query_asn ,
535: x_query_code => l_bne_stored_sql.query_code
536: );
537:
538: END LOOP; -- bne_stored_sql
539:
540: END LOOP; -- contents
541:
542: fnd_file.put_line(Fnd_file.LOG,'4.Creating the mapping...');