DBA Data[Home] [Help]

APPS.BEN_DM_GEN_SELF_REF dependencies on BEN_DM_DATA_UTIL

Line 332: l_cursor:= l_cursor||'l_new_pk_key := ben_dm_data_util.get_cache_target('||indent(l_indent);

328: l_cursor := l_cursor ||indent( l_indent) || '-- Assign the source Primary key to the variable ' || indent(l_indent) ;
329: l_cursor := l_cursor|| 'l_old_pk_key := l_rslt.'|| i.SURROGATE_PK_COLUMN_NAME||' ; '||indent(l_indent);
330: l_cursor := l_cursor || '-- get the target Primary key to the variable ' || indent(l_indent) ;
331: l_indent := 40 ;
332: l_cursor:= l_cursor||'l_new_pk_key := ben_dm_data_util.get_cache_target('||indent(l_indent);
333: l_cursor:= l_cursor||' p_table_name => '''||i.table_name||'''' || indent(l_indent) ;
334: l_cursor:= l_cursor||',p_source_id => l_old_pk_key '||indent(l_indent);
335: l_cursor:= l_cursor||',p_source_column => '''||i.SURROGATE_PK_COLUMN_NAME||'''' || indent(l_indent);
336: l_cursor:= l_cursor||',p_business_group_name => p_business_group_name ' || indent(l_indent);

Line 353: l_cursor := l_cursor|| 'l_target_id := ben_dm_data_util.get_cache_target('||indent(l_indent+40);

349: l_cursor := l_cursor||indent(l_indent) || '--' || 'Get the Key for '||i.parent_table_name ||'.'||
350: i.parent_id_column_name || indent(l_indent) ;
351: l_cursor := l_cursor|| 'If l_rslt.'||i.column_name||' IS NOT NULL THEN '||indent(l_indent+3);
352: l_cursor := l_cursor|| 'l_source_id := l_rslt.'||i.column_name||' ; '||indent(l_indent+3);
353: l_cursor := l_cursor|| 'l_target_id := ben_dm_data_util.get_cache_target('||indent(l_indent+40);
354: l_cursor := l_cursor||' p_table_name => '''||i.parent_table_name||'''' || indent(l_indent+40) ;
355: l_cursor := l_cursor||',p_source_id => l_source_id '||indent(l_indent+40);
356: l_cursor := l_cursor||',p_source_column => '''||i.parent_id_column_name||'''' || indent(l_indent+40);
357: l_cursor := l_cursor||',p_business_group_name => p_business_group_name ' || indent(l_indent+40);

Line 432: ben_dm_data_util.get_generator_version(p_generator_version => l_generator_version,

428: -- Get the version of the generator to be appended to the TUPS package
429: -- generated for a table. This will help in finding out which version
430: -- of Generator is used to generate the TUPS package.
431:
432: ben_dm_data_util.get_generator_version(p_generator_version => l_generator_version,
433: p_format_output => 'Y');
434:
435: -- Get the package version of this TDS package body.
436: hr_dm_library.get_package_version ( p_package_name => 'BEN_DM_GEN_SELF_REF',