APPS.HR_DM_GEN_MAIN dependencies on HR_DM_HIERARCHIES

Line 23: -- Column hierarchy are derived from HR_DM_HIERARCHIES table

19: -- alias - Alias of the table. Used in the select statement.
20: -- short_name - Short name of the table. Used to define the TUPS/TDS
21: -- package name
22: -- column_hierarchy - one or more column has foreign key on own table.
23: -- Column hierarchy are derived from HR_DM_HIERARCHIES table
24: -- with hierarchy type 'H' defined for this table.
25: -- table_hierarchy - business group_id has to be derived from parent table.
26: -- Parents table are derived from HR_DM_HIERARCHIES table
27: -- with hierarchy type 'PC' defined for this table.

Line 26: -- Parents table are derived from HR_DM_HIERARCHIES table

22: -- column_hierarchy - one or more column has foreign key on own table.
23: -- Column hierarchy are derived from HR_DM_HIERARCHIES table
24: -- with hierarchy type 'H' defined for this table.
25: -- table_hierarchy - business group_id has to be derived from parent table.
26: -- Parents table are derived from HR_DM_HIERARCHIES table
27: -- with hierarchy type 'PC' defined for this table.
28: -- use_non_pk_col_for_chk_row
29: -- - one or more column required, other than primary key column
30: -- to check whether row exists in the table or not. It is used

Line 43: -- Columns are derived from HR_DM_HIERARCHIES table

39: -- - tables has a AOL hierarchy i.e hierarchy type = 'A'
40: -- - has a table hierarchy i.e hierarchy type = 'PC'
41: -- - does not have 'long' data type.--
42: -- fk_to_aol_table - one or more column has foreign key on AOL table.
43: -- Columns are derived from HR_DM_HIERARCHIES table
44: -- with hierarchy type 'A' defined for this table.
45: -- missing_who_info - 'Y' - if table does not have WHO columns
46: -- 'N' - if table has WHO columns
47: -- missing_primary_key - 'Y' - if table does not have any primary key defined

Line 49: -- key is derived from HR_DM_HIERARCHIES table

45: -- missing_who_info - 'Y' - if table does not have WHO columns
46: -- 'N' - if table has WHO columns
47: -- missing_primary_key - 'Y' - if table does not have any primary key defined
48: -- in data base. In this case the logical primary
49: -- key is derived from HR_DM_HIERARCHIES table
50: -- with hierarchy type 'P' defined for this table.
51: -- 'N' - if the table has a primary key defined in database.
52: -- chk_row_exists_for_non_glb_tbl - It will contain following value :
53: -- 'Y' - add the code in the upload procedure of TUPS

Line 144: column_name hr_dm_hierarchies.column_name%type,

140: -- parent_id_column_name - Primary key of AOL table.
141:
142: type t_fk_to_aol_columns_info is record
143: (
144: column_name hr_dm_hierarchies.column_name%type,
145: parent_table_id hr_dm_hierarchies.parent_table_id%type,
146: parent_table_name hr_dm_tables.table_name%type,
147: parent_table_alias hr_dm_tables.table_alias%type,
148: parent_column_name hr_dm_hierarchies.parent_column_name%type,

Line 145: parent_table_id hr_dm_hierarchies.parent_table_id%type,

141:
142: type t_fk_to_aol_columns_info is record
143: (
144: column_name hr_dm_hierarchies.column_name%type,
145: parent_table_id hr_dm_hierarchies.parent_table_id%type,
146: parent_table_name hr_dm_tables.table_name%type,
147: parent_table_alias hr_dm_tables.table_alias%type,
148: parent_column_name hr_dm_hierarchies.parent_column_name%type,
149: parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type

Line 148: parent_column_name hr_dm_hierarchies.parent_column_name%type,

144: column_name hr_dm_hierarchies.column_name%type,
145: parent_table_id hr_dm_hierarchies.parent_table_id%type,
146: parent_table_name hr_dm_tables.table_name%type,
147: parent_table_alias hr_dm_tables.table_alias%type,
148: parent_column_name hr_dm_hierarchies.parent_column_name%type,
149: parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type
150: );
151:
152: type t_fk_to_aol_columns_tbl is table of t_fk_to_aol_columns_info index by

Line 149: parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type

145: parent_table_id hr_dm_hierarchies.parent_table_id%type,
146: parent_table_name hr_dm_tables.table_name%type,
147: parent_table_alias hr_dm_tables.table_alias%type,
148: parent_column_name hr_dm_hierarchies.parent_column_name%type,
149: parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type
150: );
151:
152: type t_fk_to_aol_columns_tbl is table of t_fk_to_aol_columns_info index by
153: binary_integer;