APPS.BEN_CWB_INTEGRATOR_COPY dependencies on BNE_LCT_TOOLS_PKG

Line 37: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_param_list_app_id),1,30) upl_param_list_asn,

33: v.integrator_code,
34: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
35: v.object_version_number,
36: v.enabled_flag,
37: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_param_list_app_id),1,30) upl_param_list_asn,
38: v.upload_param_list_code upl_param_list_code,
39: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_serv_param_list_app_id),1,30) upl_serv_param_list_asn,
40: v.upload_serv_param_list_code upl_serv_param_list_code,
41: substr(bne_lct_tools_pkg.app_id_to_asn(v.import_param_list_app_id),1,30) import_param_list_asn,

Line 39: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_serv_param_list_app_id),1,30) upl_serv_param_list_asn,

35: v.object_version_number,
36: v.enabled_flag,
37: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_param_list_app_id),1,30) upl_param_list_asn,
38: v.upload_param_list_code upl_param_list_code,
39: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_serv_param_list_app_id),1,30) upl_serv_param_list_asn,
40: v.upload_serv_param_list_code upl_serv_param_list_code,
41: substr(bne_lct_tools_pkg.app_id_to_asn(v.import_param_list_app_id),1,30) import_param_list_asn,
42: v.import_param_list_code,
43: v.date_format,

Line 41: substr(bne_lct_tools_pkg.app_id_to_asn(v.import_param_list_app_id),1,30) import_param_list_asn,

37: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_param_list_app_id),1,30) upl_param_list_asn,
38: v.upload_param_list_code upl_param_list_code,
39: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_serv_param_list_app_id),1,30) upl_serv_param_list_asn,
40: v.upload_serv_param_list_code upl_serv_param_list_code,
41: substr(bne_lct_tools_pkg.app_id_to_asn(v.import_param_list_app_id),1,30) import_param_list_asn,
42: v.import_param_list_code,
43: v.date_format,
44: v.import_type,
45: v.uploader_class,

Line 50: substr(bne_lct_tools_pkg.app_id_to_asn(v.create_doc_list_app_id),1,30) create_doc_param_list_asn,

46: v.user_name,
47: v.upload_header,
48: v.upload_title_bar,
49: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
50: substr(bne_lct_tools_pkg.app_id_to_asn(v.create_doc_list_app_id),1,30) create_doc_param_list_asn,
51: v.create_doc_list_code create_doc_param_list_code,
52: v.new_session_flag,
53: v.layout_resolver_class,
54: v.layout_verifier_class,

Line 56: substr(bne_lct_tools_pkg.app_id_to_asn(v.session_param_list_app_id),1,30) session_param_list_asn,

52: v.new_session_flag,
53: v.layout_resolver_class,
54: v.layout_verifier_class,
55: v.session_config_class,
56: substr(bne_lct_tools_pkg.app_id_to_asn(v.session_param_list_app_id),1,30) session_param_list_asn,
57: v.session_param_list_code,
58: substr(bne_lct_tools_pkg.app_id_to_asn(s.application_id),1,30),
59: s.object_code,
60: s.object_type,

Line 58: substr(bne_lct_tools_pkg.app_id_to_asn(s.application_id),1,30),

54: v.layout_verifier_class,
55: v.session_config_class,
56: substr(bne_lct_tools_pkg.app_id_to_asn(v.session_param_list_app_id),1,30) session_param_list_asn,
57: v.session_param_list_code,
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

Line 80: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_param_list_app_id),1,30) upload_param_list_asn,

76: v.object_version_number,
77: v.interface_name,
78: v.upload_type,
79: v.upload_obj_name,
80: substr(bne_lct_tools_pkg.app_id_to_asn(v.upload_param_list_app_id),1,30) upload_param_list_asn,
81: v.upload_param_list_code,
82: v.upload_order,
83: v.user_name,
84: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date

Line 119: substr(bne_lct_tools_pkg.app_id_to_asn(v.val_component_app_id),1,30) val_component_asn,

115: v.val_mean_col,
116: v.val_desc_col,
117: v.val_obj_name,
118: v.val_addl_w_c,
119: substr(bne_lct_tools_pkg.app_id_to_asn(v.val_component_app_id),1,30) val_component_asn,
120: v.val_component_code,
121: v.oa_flex_num,
122: v.oa_flex_application_id,
123: v.display_order,

Line 137: substr(bne_lct_tools_pkg.app_id_to_asn(v.val_query_app_id),1,30) val_query_asn,

133: v.variable_data_type_class,
134: v.viewer_group,
135: v.edit_type,
136: v.display_width,
137: substr(bne_lct_tools_pkg.app_id_to_asn(v.val_query_app_id),1,30) val_query_asn,
138: v.val_query_code,
139: substr(bne_lct_tools_pkg.app_id_to_asn(v.expanded_sql_query_app_id),1,30) expanded_sql_query_asn,
140: v.expanded_sql_query_code
141: from bne_interface_cols_vl v, fnd_application a

Line 139: substr(bne_lct_tools_pkg.app_id_to_asn(v.expanded_sql_query_app_id),1,30) expanded_sql_query_asn,

135: v.edit_type,
136: v.display_width,
137: substr(bne_lct_tools_pkg.app_id_to_asn(v.val_query_app_id),1,30) val_query_asn,
138: v.val_query_code,
139: substr(bne_lct_tools_pkg.app_id_to_asn(v.expanded_sql_query_app_id),1,30) expanded_sql_query_asn,
140: v.expanded_sql_query_code
141: from bne_interface_cols_vl v, fnd_application a
142: where v.application_id = a.application_id
143: and v.interface_code = v_interface_code

Line 152: substr(bne_lct_tools_pkg.app_id_to_asn(v.param_list_app_id),1,30) param_list_asn,

148: select a.application_short_name,
149: v.content_code,
150: v.object_version_number,
151: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
152: substr(bne_lct_tools_pkg.app_id_to_asn(v.param_list_app_id),1,30) param_list_asn,
153: v.param_list_code,
154: v.content_class,
155: v.user_name,
156: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,

Line 183: substr(bne_lct_tools_pkg.app_id_to_asn(v.query_app_id),1,30) bne_query_query_asn,

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,
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

Line 196: substr(bne_lct_tools_pkg.app_id_to_asn(v.reporting_interface_app_id),1,30) reporting_interface_asn,

192: cursor c_bne_mappings is
193: select a.application_short_name,
194: v.mapping_code,
195: v.reporting_flag,
196: substr(bne_lct_tools_pkg.app_id_to_asn(v.reporting_interface_app_id),1,30) reporting_interface_asn,
197: v.reporting_interface_code,
198: v.user_name,
199: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
200: v.object_version_number,

Line 211: substr(bne_lct_tools_pkg.app_id_to_asn(v.interface_app_id),1,30) interface_asn,

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,
213: v.interface_seq_num,
214: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
215: v.decode_flag,

Line 217: substr(bne_lct_tools_pkg.app_id_to_asn(v.content_app_id),1,30) content_asn,

213: v.interface_seq_num,
214: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
215: v.decode_flag,
216: v.object_version_number,
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

Line 232: substr(bne_lct_tools_pkg.app_id_to_asn(v.stylesheet_app_id),1,30) stylesheet_asn,

228: select a.application_short_name,
229: v.layout_code,
230: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
231: v.object_version_number,
232: substr(bne_lct_tools_pkg.app_id_to_asn(v.stylesheet_app_id),1,30) stylesheet_asn,
233: v.stylesheet_code,
234: v.style,
235: v.style_class,
236: v.reporting_flag,

Line 237: substr(bne_lct_tools_pkg.app_id_to_asn(v.reporting_interface_app_id),1,30) reporting_interface_asn,

233: v.stylesheet_code,
234: v.style,
235: v.style_class,
236: v.reporting_flag,
237: substr(bne_lct_tools_pkg.app_id_to_asn(v.reporting_interface_app_id),1,30) reporting_interface_asn,
238: v.reporting_interface_code,
239: v.user_name,
240: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
241: substr(bne_lct_tools_pkg.app_id_to_asn(v.create_doc_list_app_id),1,30) create_doc_list_asn,

Line 241: substr(bne_lct_tools_pkg.app_id_to_asn(v.create_doc_list_app_id),1,30) create_doc_list_asn,

237: substr(bne_lct_tools_pkg.app_id_to_asn(v.reporting_interface_app_id),1,30) reporting_interface_asn,
238: v.reporting_interface_code,
239: v.user_name,
240: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
241: substr(bne_lct_tools_pkg.app_id_to_asn(v.create_doc_list_app_id),1,30) create_doc_list_asn,
242: v.create_doc_list_code
243: from bne_layouts_vl v, fnd_application a
244: where v.integrator_app_id = a.application_id
245: and v.integrator_code like p_integrator_code

Line 297: substr(bne_lct_tools_pkg.app_id_to_asn(v.interface_app_id),1,30) interface_asn,

293: v_block_id IN varchar2) is
294: select v.sequence_num,
295: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
296: v.object_version_number,
297: substr(bne_lct_tools_pkg.app_id_to_asn(v.interface_app_id),1,30) interface_asn,
298: v.interface_code,
299: v.interface_seq_num,
300: v.style_class,
301: v.style,

Line 323: substr(bne_lct_tools_pkg.app_id_to_asn(v.security_rule_app_id),1,30) rule_security_rule_asn,

319: select a.application_short_name,
320: v.object_code,
321: v.object_type,
322: v.object_version_number,
323: substr(bne_lct_tools_pkg.app_id_to_asn(v.security_rule_app_id),1,30) rule_security_rule_asn,
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