DBA Data[Home] [Help]

APPS.BEN_CWB_INTEGRATOR_COPY dependencies on FND_LOAD_UTIL

Line 34: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

30:
31: cursor c_bne_integrators is
32: select a.application_short_name,
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,

Line 75: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

71:
72: cursor c_bne_interfaces is
73: select a.application_short_name,
74: v.interface_code,
75: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
76: v.object_version_number,
77: v.interface_name,
78: v.upload_type,
79: v.upload_obj_name,

Line 94: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

90:
91: cursor c_bne_interface_cols (
92: v_interface_code IN VARCHAR2 ) is
93: select v.sequence_num,
94: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
95: v.object_version_number,
96: v.interface_col_type,
97: v.interface_col_name,
98: v.enabled_flag,

Line 151: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

147: cursor c_bne_contents is
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,

Line 168: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

164: cursor c_bne_content_cols (
165: v_content_code IN VARCHAR2 ) is
166: select v.sequence_num,
167: v.object_version_number,
168: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
169: v.col_name,
170: v.user_name,
171: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date,
172: v.read_only_flag

Line 185: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

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
188: where v.application_id = a.application_id
189: and v.content_code = v_content_code

Line 199: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

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,
201: to_char(v.last_update_date, 'yyyy/mm/dd') last_update_date
202: from bne_mappings_vl v, fnd_application a
203: where v.application_id = a.application_id

Line 214: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

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

Line 230: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

226:
227: cursor c_bne_layouts is
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,

Line 252: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

248:
249: cursor c_bne_layout_blocks(
250: v_layout_code IN varchar2) is
251: select v.block_id,
252: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,
253: v.object_version_number,
254: v.parent_id,
255: v.layout_element,
256: v.style_class,

Line 295: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

291: cursor c_bne_layout_cols (
292: v_layout_code IN varchar2,
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,

Line 325: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

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
328: from bne_secured_objects v, fnd_application a
329: where v.application_id = a.application_id

Line 342: substr(fnd_load_util.owner_name(v.last_updated_by),1,30) owner,

338: v.security_code,
339: v.object_version_number,
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