eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DM_GEN_TUPS dependencies on HR_DM_LIBRARY

Line 34: g_columns_tbl hr_dm_library.t_varchar2_tbl;

30: proc_parameters varchar2(32767)
31: );
32:
33: g_table_info hr_dm_gen_main.t_table_info;
34: g_columns_tbl hr_dm_library.t_varchar2_tbl;
35: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
36: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;

Line 35: g_parameters_tbl hr_dm_library.t_varchar2_tbl;

31: );
32:
33: g_table_info hr_dm_gen_main.t_table_info;
34: g_columns_tbl hr_dm_library.t_varchar2_tbl;
35: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
36: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;

Line 36: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;

32:
33: g_table_info hr_dm_gen_main.t_table_info;
34: g_columns_tbl hr_dm_library.t_varchar2_tbl;
35: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
36: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
40: g_pk_columns_tbl hr_dm_library.t_varchar2_tbl;

Line 37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;

33: g_table_info hr_dm_gen_main.t_table_info;
34: g_columns_tbl hr_dm_library.t_varchar2_tbl;
35: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
36: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
40: g_pk_columns_tbl hr_dm_library.t_varchar2_tbl;
41: g_pk_parameters_tbl hr_dm_library.t_varchar2_tbl;

Line 38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;

34: g_columns_tbl hr_dm_library.t_varchar2_tbl;
35: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
36: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
40: g_pk_columns_tbl hr_dm_library.t_varchar2_tbl;
41: g_pk_parameters_tbl hr_dm_library.t_varchar2_tbl;
42: g_fk_to_aol_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;

Line 39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;

35: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
36: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
40: g_pk_columns_tbl hr_dm_library.t_varchar2_tbl;
41: g_pk_parameters_tbl hr_dm_library.t_varchar2_tbl;
42: g_fk_to_aol_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
43: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;

Line 40: g_pk_columns_tbl hr_dm_library.t_varchar2_tbl;

36: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
40: g_pk_columns_tbl hr_dm_library.t_varchar2_tbl;
41: g_pk_parameters_tbl hr_dm_library.t_varchar2_tbl;
42: g_fk_to_aol_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
43: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
44: g_surrogate_pk_col_param varchar2(30);

Line 41: g_pk_parameters_tbl hr_dm_library.t_varchar2_tbl;

37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
40: g_pk_columns_tbl hr_dm_library.t_varchar2_tbl;
41: g_pk_parameters_tbl hr_dm_library.t_varchar2_tbl;
42: g_fk_to_aol_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
43: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
44: g_surrogate_pk_col_param varchar2(30);
45: g_no_of_pk_columns number;

Line 48: g_exception_tbl hr_dm_library.t_varchar2_tbl;

44: g_surrogate_pk_col_param varchar2(30);
45: g_no_of_pk_columns number;
46: g_chk_row_exists t_chk_row_exists;
47: g_delete_dml t_delete_dml;
48: g_exception_tbl hr_dm_library.t_varchar2_tbl;
49:
50: -- to store the package body in to array so as to overcome the limit of 32767
51: -- character the global variable is defined.
52: g_package_body dbms_sql.varchar2s;

Line 80: l_spaces := hr_dm_library.indent(p_indent_spaces => p_indent_spaces,

76: ) return varchar2 is
77: l_spaces varchar2(100);
78: begin
79:
80: l_spaces := hr_dm_library.indent(p_indent_spaces => p_indent_spaces,
81: p_newline => p_newline);
82: return l_spaces;
83: exception
84: when others then

Line 330: p_pk_columns_tbl in hr_dm_library.t_varchar2_tbl,

326: -- p_dev_key_local_var_body - returns the string defining local variable
327: -- ------------------------------------------------------------------------
328: procedure prepare_code_for_resolving_pk
329: (
330: p_pk_columns_tbl in hr_dm_library.t_varchar2_tbl,
331: p_table_info in hr_dm_gen_main.t_table_info,
332: p_call_to_proc_body in out nocopy varchar2,
333: p_local_var_body in out nocopy varchar2
334: )

Line 378: 'hr_dm_library.get_resolved_pk (' ||

374: ' the value in source database.',
375: l_indent) || indent(l_indent);
376:
377: p_call_to_proc_body := p_call_to_proc_body ||
378: 'hr_dm_library.get_resolved_pk (' ||
379: 'p_table_name => ''' || upper(p_table_info.table_name) || '''' ||
380: indent(l_indent+32) ||
381: ', p_source_id => ' ||rpad('p_' || l_column_name,30)
382: || indent(l_indent+32) ||

Line 494: 'hr_dm_library.get_resolved_pk (' ||

490: ' the value in source database.',
491: l_indent) || indent(l_indent);
492:
493: p_call_to_proc_body := p_call_to_proc_body ||
494: 'hr_dm_library.get_resolved_pk (' ||
495: 'p_table_name => ''' || upper(l_parent_table_name) || '''' ||
496: indent(l_indent+32) ||
497: ', p_source_id => ' ||rpad('p_' || l_column_name,30)
498: || indent(l_indent+32) ||

Line 776: 'hr_dm_library.ins_dt_delete (p_id => ' || 'p_' ||

772: hr_dm_utility.message('ROUT','entry:hr_dm_gen_tups.prepare_ins_dt_delete_stmt ', 5);
773:
774: if p_table_info.surrogate_primary_key = 'Y' then
775: p_proc_body := p_proc_body ||
776: 'hr_dm_library.ins_dt_delete (p_id => ' || 'p_' ||
777: rpad(g_pk_columns_tbl(1),28) ||',' ||indent(p_indent + 29) ||
778: 'p_table_name => '''|| l_table_name || ''',' ||
779: indent(p_indent + 29) || 'p_ins_type => ''' || p_ins_type ||
780: ''');' ;

Line 783: 'hr_dm_library.ins_dt_delete ( p_table_name => '''|| l_table_name

779: indent(p_indent + 29) || 'p_ins_type => ''' || p_ins_type ||
780: ''');' ;
781: else
782: p_proc_body := p_proc_body ||
783: 'hr_dm_library.ins_dt_delete ( p_table_name => '''|| l_table_name
784: || '''' || indent(p_indent + 29) || ',p_ins_type => ''' ||
785: p_ins_type || '''' ;
786: -- add the first column of the primary key.
787: p_proc_body := p_proc_body || indent(p_indent + 29) ||

Line 850: 'hr_dm_library.chk_row_in_dt_delete (p_id => p_' ||

846: hr_dm_utility.message('ROUT','entry:hr_dm_gen_tups.prepare_chk_dt_delete_stmt ', 5);
847:
848: if p_table_info.surrogate_primary_key = 'Y' then
849: p_proc_body := p_proc_body ||
850: 'hr_dm_library.chk_row_in_dt_delete (p_id => p_' ||
851: rpad(g_pk_columns_tbl(1),28) ||',' ||indent(p_indent + 30) ||
852: 'p_table_name => '''|| l_table_name || ''',' ||
853: indent(p_indent + 30) || 'p_ins_type => l_ins_type,' ||
854: indent(p_indent + 30) || 'p_row_exists => l_row_exists);';

Line 861: 'hr_dm_library.' || l_proc_name || '(' ||

857: -- key.
858: l_proc_name := 'chk_row_in_dt_delete_' || to_char(g_no_of_pk_columns) ||
859: '_pkcol' ;
860: p_proc_body := p_proc_body ||
861: 'hr_dm_library.' || l_proc_name || '(' ||
862: indent(p_indent + 28) || 'p_table_name => ''' || l_table_name || '''' ||
863: indent(p_indent + 29) || ',p_ins_type => l_ins_type' ||
864: indent(p_indent + 29) || ',p_row_exists => l_row_exists';
865:

Line 950: hr_dm_library.conv_list_to_text(

946: g_chk_row_exists.call_to_proc;
947: else
948: l_proc_body := l_proc_body || l_proc_comment || indent(l_indent) ||
949: 'chk_row_exists( ' ||
950: hr_dm_library.conv_list_to_text(
951: p_rpad_spaces => l_indent + 13,
952: p_pad_first_line => 'N',
953: p_prefix_col => 'p_',
954: p_columns_tbl => g_pk_columns_tbl,

Line 1039: hr_dm_library.get_func_asg

1035: -- code to check whether this Id had been processed earlier by comapring the
1036: -- Id value of the last
1037:
1038: l_proc_body := l_proc_body || indent(l_indent) || 'if ' ||
1039: hr_dm_library.get_func_asg
1040: ( p_rpad_spaces => l_indent,
1041: p_columns_tbl => g_pk_columns_tbl,
1042: p_prefix_left_asg => 'g_old_',
1043: p_prefix_right_asg => 'p_',

Line 1109: hr_dm_library.conv_list_to_text(

1105: g_chk_row_exists.call_to_proc;
1106: else
1107: l_proc_body := l_proc_body || l_proc_comment || indent(l_indent) ||
1108: 'chk_row_exists( ' ||
1109: hr_dm_library.conv_list_to_text(
1110: p_rpad_spaces => l_indent + 15,
1111: p_pad_first_line => 'N',
1112: p_prefix_col => 'p_',
1113: p_columns_tbl => g_pk_columns_tbl,

Line 1196: 'delete_dml( ' || hr_dm_library.conv_list_to_text(

1192: if p_table_info.use_non_pk_col_for_chk_row = 'Y' then
1193: l_proc_body := l_proc_body || indent(l_indent) || g_delete_dml.call_to_proc;
1194: else
1195: l_proc_body := l_proc_body || indent(l_indent) ||
1196: 'delete_dml( ' || hr_dm_library.conv_list_to_text(
1197: p_rpad_spaces => l_indent + 11,
1198: p_pad_first_line => 'N',
1199: p_prefix_col => 'p_',
1200: p_columns_tbl => g_pk_columns_tbl,

Line 1303: hr_dm_library.conv_list_to_text(

1299: indent(l_indent) || g_chk_row_exists.call_to_proc;
1300: else
1301: l_proc_body := l_proc_body || indent(l_indent) || l_proc_comment ||
1302: indent(l_indent) || 'chk_row_exists( ' ||
1303: hr_dm_library.conv_list_to_text(
1304: p_rpad_spaces => l_indent + 13,
1305: p_pad_first_line => 'N',
1306: p_prefix_col => 'p_',
1307: p_columns_tbl => g_pk_columns_tbl,

Line 1379: hr_dm_library.conv_list_to_text(

1375: l_proc_body := l_proc_body || g_chk_row_exists.call_to_proc;
1376: else
1377: l_proc_body := l_proc_body ||
1378: 'chk_row_exists( ' ||
1379: hr_dm_library.conv_list_to_text(
1380: p_rpad_spaces => l_indent + 15,
1381: p_pad_first_line => 'N',
1382: p_prefix_col => 'p_',
1383: p_columns_tbl => g_pk_columns_tbl,

Line 1462: l_parameters_tbl hr_dm_library.t_varchar2_tbl;

1458: -- indentation for the statements.it specifies number of blank spaces
1459: -- after which the staement should start.
1460:
1461: l_indent number;
1462: l_parameters_tbl hr_dm_library.t_varchar2_tbl;
1463: l_proc_body_tbl t_varchar2_32k_tbl;
1464: l_proc_index number := 1;
1465: begin
1466: hr_dm_utility.message('ROUT','entry:hr_dm_gen_tups.generate_upload', 5);

Line 1482: hr_dm_library.conv_list_to_text(

1478: ',';
1479:
1480: -- add the column parameters to the procedure.
1481: l_interface := l_interface ||
1482: hr_dm_library.conv_list_to_text(
1483: p_rpad_spaces => 0,
1484: p_pad_first_line => 'N',
1485: p_columns_tbl => l_parameters_tbl,
1486: p_col_length => 70) ||indent || ')' ;

Line 1575: l_proc_body_tbl(l_proc_index) := hr_dm_library.get_func_asg (

1571: -- if the columns of the table have foreign key to AOL table then call
1572: -- call assignment function which uses the l_ instead of p_ for the
1573: -- that column assignment.
1574: if p_table_info.fk_to_aol_table = 'N' then
1575: l_proc_body_tbl(l_proc_index) := hr_dm_library.get_func_asg (
1576: p_rpad_spaces => l_indent + 14,
1577: p_columns_tbl => g_columns_tbl,
1578: p_omit_business_group_id => 'N',
1579: p_comma_on_first_line => 'N',

Line 1585: hr_dm_library.get_func_asg_with_dev_key (

1581: p_resolve_pk_columns_tbl => g_resolve_pk_columns_tbl ) || ');';
1582: l_proc_index := l_proc_index + 1;
1583: else
1584: l_proc_body_tbl(l_proc_index) :=
1585: hr_dm_library.get_func_asg_with_dev_key (
1586: p_rpad_spaces => l_indent + 14,
1587: p_columns_tbl => g_columns_tbl,
1588: p_omit_business_group_id => 'N',
1589: p_comma_on_first_line => 'N',

Line 1612: hr_dm_library.get_func_asg

1608:
1609: l_proc_index := l_proc_index + 1;
1610:
1611: l_proc_body_tbl(l_proc_index) := indent(l_indent + 1) ||
1612: hr_dm_library.get_func_asg
1613: ( p_rpad_spaces => l_indent + 2,
1614: p_columns_tbl => g_pk_columns_tbl,
1615: p_prefix_left_asg => 'g_old_',
1616: p_prefix_right_asg => 'p_',

Line 1643: l_proc_body_tbl(l_proc_index ) := hr_dm_library.get_func_asg (

1639: -- if the columns of the table have foreign key to AOL table then call
1640: -- call assignment function which uses the l_ instead of p_ for the
1641: -- that column assignment.
1642: if p_table_info.fk_to_aol_table = 'N' then
1643: l_proc_body_tbl(l_proc_index ) := hr_dm_library.get_func_asg (
1644: p_rpad_spaces => l_indent + 14,
1645: p_columns_tbl => g_columns_tbl,
1646: p_omit_business_group_id => 'N',
1647: p_comma_on_first_line => 'N',

Line 1654: hr_dm_library.get_func_asg_with_dev_key (

1650: l_proc_index := l_proc_index + 1;
1651:
1652: else
1653: l_proc_body_tbl(l_proc_index) :=
1654: hr_dm_library.get_func_asg_with_dev_key (
1655: p_rpad_spaces => l_indent + 14,
1656: p_columns_tbl => g_columns_tbl,
1657: p_omit_business_group_id => 'N',
1658: p_comma_on_first_line => 'N',

Line 1923: l_cursor_select_where := ' where' || hr_dm_library.get_func_asg (

1919: l_cursor_select_where := g_chk_row_exists.where_clause ;
1920:
1921: else -- use primary key for where clause
1922:
1923: l_cursor_select_where := ' where' || hr_dm_library.get_func_asg (
1924: p_rpad_spaces => 0,
1925: p_columns_tbl => g_pk_columns_tbl,
1926: p_prefix_left_asg => p_table_info.alias || '.' ,
1927: p_prefix_right_asg => 'p_',

Line 2107: hr_dm_library.get_nvl_arguement('Y',

2103: for csr_get_chk_columns_rec in csr_get_chk_columns loop
2104:
2105: -- if csr_get_chk_columns_rec.hierarchy_type = 'R' then
2106:
2107: hr_dm_library.get_nvl_arguement('Y',
2108: csr_get_chk_columns_rec.table_name,
2109: csr_get_chk_columns_rec.column_name,
2110: l_nvl_left,
2111: l_nvl_right);

Line 2132: hr_dm_library.get_nvl_arguement('Y',

2128: if upper(csr_get_chk_columns_rec.column_name) not in ('EFFECTIVE_START_DATE',
2129: 'EFFECTIVE_END_DATE')
2130: then
2131:
2132: hr_dm_library.get_nvl_arguement('Y',
2133: csr_get_chk_columns_rec.table_name,
2134: csr_get_chk_columns_rec.column_name,
2135: l_nvl_left,
2136: l_nvl_right);

Line 2159: hr_dm_library.check_col_for_fk_on_aol

2155: -- if the column has a 'L' type hierarchy then we want to use the
2156: -- the local variable in the call so as to use the correct value
2157: -- of the column i.e value of the column in the destination database.
2158:
2159: hr_dm_library.check_col_for_fk_on_aol
2160: ( p_fk_to_aol_columns_tbl => g_resolve_pk_columns_tbl,
2161: p_column_name => upper(csr_get_chk_columns_rec.column_name),
2162: p_index => l_index);
2163:

Line 2171: hr_dm_library.check_col_for_fk_on_aol

2167: -- so as to use the correct value of the column i.e l_column_name instead
2168: -- of p_column_name.
2169:
2170: if l_index is null and p_table_info.fk_to_aol_table = 'Y' then
2171: hr_dm_library.check_col_for_fk_on_aol
2172: ( p_fk_to_aol_columns_tbl => g_fk_to_aol_columns_tbl,
2173: p_column_name => upper(csr_get_chk_columns_rec.column_name),
2174: p_index => l_index);
2175: end if;

Line 2248: hr_dm_library.conv_list_to_text(

2244:
2245: else -- use primary key for input parameters
2246:
2247: l_interface := indent || '(' ||
2248: hr_dm_library.conv_list_to_text(
2249: p_rpad_spaces => 0,
2250: p_pad_first_line => 'N',
2251: p_columns_tbl => g_pk_parameters_tbl,
2252: p_col_length => 70) ||indent ||

Line 2289: indent (l_indent +2) || 'hr_dm_library.ins_resolve_pks (' ||

2285:
2286: -- add the code to store the surrogate id in the hr_dm_pk_resolve table
2287: if p_table_info.ins_resolve_pk = 'Y' then
2288: l_proc_body := l_proc_body || indent(l_indent) || 'if p_row_exists = ''Y'' then' ||
2289: indent (l_indent +2) || 'hr_dm_library.ins_resolve_pks (' ||
2290: 'p_table_name => ''' || upper(p_table_info.upload_table_name)
2291: || '''' || indent(l_indent+32) ||
2292: ', p_source_id => ' ||rpad('p_' || p_table_info.surrogate_pk_column_name,30)
2293: || indent(l_indent+32) ||

Line 2357: hr_dm_library.conv_list_to_text (

2353:
2354: -- input parameters for the procedure
2355:
2356: l_proc_body_tbl(l_proc_index) := indent || '(' ||
2357: hr_dm_library.conv_list_to_text (
2358: p_rpad_spaces => l_indent + 2,
2359: p_pad_first_line => 'Y',
2360: p_columns_tbl => g_parameters_tbl,
2361: p_col_length => 70) || indent || ')';

Line 2432: hr_dm_library.conv_list_to_text (

2428: l_proc_body_tbl(l_proc_index) :=
2429: format_comment('insert the row', l_indent) || indent ||
2430: ' insert into ' || p_table_info.upload_table_name || indent(l_indent)
2431: || '( ' || indent(l_indent) ||
2432: hr_dm_library.conv_list_to_text (
2433: p_rpad_spaces => l_indent + 1,
2434: p_pad_first_line => 'Y',
2435: p_columns_tbl => g_columns_tbl);
2436: l_proc_index := l_proc_index + 1;

Line 2440: hr_dm_library.conv_list_to_text (

2436: l_proc_index := l_proc_index + 1;
2437:
2438: l_proc_body_tbl(l_proc_index) := indent(l_indent) || ')' ||
2439: ' values' || indent(l_indent) || '(' || indent(l_indent) ||
2440: hr_dm_library.conv_list_to_text (
2441: p_rpad_spaces => l_indent+ 1,
2442: p_pad_first_line => 'Y',
2443: p_prefix_col => 'p_',
2444: p_columns_tbl => g_columns_tbl,

Line 2491: hr_dm_library.conv_list_to_text(

2487: g_chk_row_exists.call_to_proc;
2488: else
2489: l_proc_body_tbl(l_proc_index) := indent(l_indent) ||
2490: 'chk_row_exists( ' ||
2491: hr_dm_library.conv_list_to_text(
2492: p_rpad_spaces => l_indent + 15,
2493: p_pad_first_line => 'N',
2494: p_prefix_col => 'p_',
2495: p_columns_tbl => g_pk_columns_tbl,

Line 2529: ' hr_dm_library.ins_resolve_pks (' ||

2525: l_proc_index := l_proc_index + 1;
2526:
2527: -- write details to resolve_pks table
2528: l_proc_body_tbl(l_proc_index) :=
2529: ' hr_dm_library.ins_resolve_pks (' ||
2530: 'p_table_name => ''' || upper(p_table_info.upload_table_name) || '''' ||
2531: indent(l_indent+30) ||
2532: ' ,p_source_id => ' || rpad('p_' || p_table_info.surrogate_pk_column_name,30)
2533: || indent(l_indent+30) ||

Line 2549: hr_dm_library.conv_list_to_text (

2545: l_proc_body_tbl(l_proc_index) :=
2546: format_comment('insert the row', l_indent) || indent ||
2547: ' insert into ' || p_table_info.upload_table_name || indent(l_indent)
2548: || '( ' || indent(l_indent) ||
2549: hr_dm_library.conv_list_to_text (
2550: p_rpad_spaces => l_indent + 1,
2551: p_pad_first_line => 'Y',
2552: p_columns_tbl => g_columns_tbl);
2553: l_proc_index := l_proc_index + 1;

Line 2557: hr_dm_library.conv_list_to_text (

2553: l_proc_index := l_proc_index + 1;
2554:
2555: l_proc_body_tbl(l_proc_index) := indent(l_indent) || ')' ||
2556: ' values' || indent(l_indent) || '(' || indent(l_indent) ||
2557: hr_dm_library.conv_list_to_text (
2558: p_rpad_spaces => l_indent+ 1,
2559: p_pad_first_line => 'Y',
2560: p_prefix_col => 'l_',
2561: p_columns_tbl => g_columns_tbl,

Line 2613: l_columns_tbl hr_dm_library.t_varchar2_tbl;

2609: l_indent number;
2610: l_proc_body_tbl t_varchar2_32k_tbl;
2611: l_proc_index number := 1;
2612:
2613: l_columns_tbl hr_dm_library.t_varchar2_tbl;
2614: begin
2615: hr_dm_utility.message('ROUT','entry:hr_dm_gen_tups.generate_update_dml', 5);
2616:
2617: -- input parameters for the procedure

Line 2620: hr_dm_library.conv_list_to_text (

2616:
2617: -- input parameters for the procedure
2618:
2619: l_proc_body_tbl(l_proc_index) := indent || '(' ||
2620: hr_dm_library.conv_list_to_text (
2621: p_rpad_spaces => l_indent + 2,
2622: p_pad_first_line => 'Y',
2623: p_columns_tbl => g_parameters_tbl,
2624: p_col_length => 70) || indent || ')';

Line 2646: hr_dm_library.get_cols_list_wo_pk_cols (

2642: -- add the body of the download procedure
2643: l_indent := 2;
2644:
2645: -- get the list of columns of the table without primary key columns
2646: hr_dm_library.get_cols_list_wo_pk_cols (
2647: p_columns_tbl => g_columns_tbl,
2648: p_pk_columns_tbl => g_pk_columns_tbl ,
2649: p_cols_wo_pk_cols_tbl => l_columns_tbl );
2650:

Line 2665: hr_dm_library.get_func_asg (

2661: l_proc_body_tbl(l_proc_index) := format_comment('update all columns of' ||
2662: ' the row.', l_indent) || indent ||
2663: ' update ' || p_table_info.upload_table_name || ' ' || p_table_info.alias
2664: || indent(l_indent) || 'set ' ||
2665: hr_dm_library.get_func_asg (
2666: p_rpad_spaces => l_indent + 4,
2667: p_columns_tbl => l_columns_tbl,
2668: p_prefix_left_asg => null ,
2669: p_omit_business_group_id => 'N',

Line 2685: ' where' || hr_dm_library.get_func_asg (

2681: l_proc_body_tbl(l_proc_index) := indent(l_indent) ||
2682: g_chk_row_exists.where_clause ;
2683: else
2684: l_proc_body_tbl(l_proc_index) := indent(l_indent) ||
2685: ' where' || hr_dm_library.get_func_asg (
2686: p_rpad_spaces => 0,
2687: p_columns_tbl => g_pk_columns_tbl,
2688: p_prefix_left_asg => null ,
2689: p_prefix_right_asg => 'p_',

Line 2769: hr_dm_library.conv_list_to_text(

2765: || indent ||',';
2766:
2767: -- add the column parameters to the procedure.
2768: l_interface := l_interface ||
2769: hr_dm_library.conv_list_to_text(
2770: p_rpad_spaces => 0,
2771: p_pad_first_line => 'N',
2772: p_columns_tbl => g_hier_parameters_tbl,
2773: p_col_length => 70) ||indent || ')' ;

Line 2828: hr_dm_library.get_func_asg (

2824: indent(l_indent)||'set ';
2825: l_proc_index := l_proc_index + 1;
2826:
2827: l_proc_body_tbl(l_proc_index) :=
2828: hr_dm_library.get_func_asg (
2829: p_rpad_spaces => l_indent + 4,
2830: p_columns_tbl => g_hier_columns_tbl,
2831: p_prefix_left_asg => null ,
2832: p_prefix_right_asg => 'p_',

Line 2842: hr_dm_library.get_func_asg (

2838: p_right_asg_pad_len => 30);
2839: l_proc_index := l_proc_index + 1;
2840:
2841: l_proc_body_tbl(l_proc_index) := indent(l_indent)||' where'||
2842: hr_dm_library.get_func_asg (
2843: p_rpad_spaces => 0,
2844: p_columns_tbl => g_pk_columns_tbl,
2845: p_prefix_left_asg => null ,
2846: p_prefix_right_asg => l_prefix_right_asg,

Line 2914: hr_dm_library.conv_list_to_text(

2910:
2911: l_interface := indent || g_delete_dml.proc_parameters || indent;
2912: else
2913: l_interface := indent || '(' ||
2914: hr_dm_library.conv_list_to_text(
2915: p_rpad_spaces => 0,
2916: p_pad_first_line => 'N',
2917: p_columns_tbl => g_pk_parameters_tbl,
2918: p_col_length => 70) || ') ' || indent;

Line 2955: ' where' || hr_dm_library.get_func_asg (

2951: l_proc_body := l_proc_body || indent(l_indent) ||
2952: g_delete_dml.where_clause ;
2953: else
2954: l_proc_body := l_proc_body || indent(l_indent) ||
2955: ' where' || hr_dm_library.get_func_asg (
2956: p_rpad_spaces => 0,
2957: p_columns_tbl => g_pk_columns_tbl,
2958: p_prefix_left_asg => p_table_info.alias || '.' ,
2959: p_prefix_right_asg => 'p_',

Line 3022: p_columns_tbl in hr_dm_library.t_varchar2_tbl,

3018: -- ------------------------------------------------------------------------
3019: procedure create_tups_pacakge
3020: (
3021: p_table_info in hr_dm_gen_main.t_table_info ,
3022: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
3023: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3024: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
3025: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3026: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl

Line 3023: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,

3019: procedure create_tups_pacakge
3020: (
3021: p_table_info in hr_dm_gen_main.t_table_info ,
3022: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
3023: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3024: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
3025: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3026: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
3027: )

Line 3024: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,

3020: (
3021: p_table_info in hr_dm_gen_main.t_table_info ,
3022: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
3023: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3024: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
3025: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3026: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
3027: )
3028: is

Line 3025: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,

3021: p_table_info in hr_dm_gen_main.t_table_info ,
3022: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
3023: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3024: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
3025: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3026: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
3027: )
3028: is
3029: l_header varchar2(32767);

Line 3059: hr_dm_library.get_generator_version(p_generator_version => l_generator_version,

3055: -- Get the version of the generator to be appended to the TUPS package
3056: -- generated for a table. This will help in finding out which version
3057: -- of Generator is used to generate the TUPS package.
3058:
3059: hr_dm_library.get_generator_version(p_generator_version => l_generator_version,
3060: p_format_output => 'Y');
3061:
3062: -- Get the package version of this TDS package body.
3063: hr_dm_library.get_package_version ( p_package_name => 'HR_DM_GEN_TUPS',

Line 3063: hr_dm_library.get_package_version ( p_package_name => 'HR_DM_GEN_TUPS',

3059: hr_dm_library.get_generator_version(p_generator_version => l_generator_version,
3060: p_format_output => 'Y');
3061:
3062: -- Get the package version of this TDS package body.
3063: hr_dm_library.get_package_version ( p_package_name => 'HR_DM_GEN_TUPS',
3064: p_package_version => l_package_version,
3065: p_version_type => 'FULL');
3066:
3067: -- if there is a column hirearchy then store the hierarchy columns list and

Line 3072: hr_dm_library.populate_hierarchy_cols_list

3068: -- parameter assignment in pl/sql variable.
3069:
3070: if p_table_info.column_hierarchy = 'Y' then
3071: -- get the columns and parameter list. store in pl/sql table.
3072: hr_dm_library.populate_hierarchy_cols_list
3073: (p_table_info => p_table_info,
3074: p_hier_columns_tbl => g_hier_columns_tbl,
3075: p_hier_parameter_tbl => g_hier_parameters_tbl,
3076: p_called_from => 'TUPS' );

Line 3084: hr_dm_library.populate_fk_to_aol_cols_info

3080: -- if one or more columns have to resolve primary key then store the
3081: -- information about the column and corresponding AOL table e.t.c for each
3082: -- column.
3083: if p_table_info.resolve_pk = 'Y' then
3084: hr_dm_library.populate_fk_to_aol_cols_info
3085: ( p_table_info => p_table_info,
3086: p_fk_to_aol_columns_tbl => g_resolve_pk_columns_tbl,
3087: p_hierarchy_type => 'L');
3088: end if;

Line 3092: hr_dm_library.populate_pk_columns_list(p_table_info,

3088: end if;
3089:
3090:
3091: -- populate the list with primary key columns.
3092: hr_dm_library.populate_pk_columns_list(p_table_info,
3093: g_pk_columns_tbl,
3094: g_pk_parameters_tbl,
3095: g_no_of_pk_columns);
3096:

Line 3221: hr_dm_library.run_sql( l_header );

3217: --
3218: -- Compile the header and body.
3219: --
3220:
3221: hr_dm_library.run_sql( l_header );
3222:
3223: g_package_index := g_package_index+1;
3224: g_package_body(g_package_index ) := indent || 'end ' ||
3225: l_package_name || ';';

Line 3227: hr_dm_library.run_sql( g_package_body,

3223: g_package_index := g_package_index+1;
3224: g_package_body(g_package_index ) := indent || 'end ' ||
3225: l_package_name || ';';
3226:
3227: hr_dm_library.run_sql( g_package_body,
3228: g_package_index);
3229:
3230: -- check the status of the package
3231: begin

Line 3232: hr_dm_library.check_compile (p_object_name => l_package_name,

3228: g_package_index);
3229:
3230: -- check the status of the package
3231: begin
3232: hr_dm_library.check_compile (p_object_name => l_package_name,
3233: p_object_type => 'PACKAGE BODY' );
3234: exception
3235: when others then
3236: hr_dm_utility.error(SQLCODE,'Error in compiling TUPS for ' ||