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_LIBRARY dependencies on HR_DM_GEN_MAIN

Line 145: p_table_info out nocopy hr_dm_gen_main.t_table_info

141:
142: procedure get_table_info
143: (
144: p_table_id in number,
145: p_table_info out nocopy hr_dm_gen_main.t_table_info
146: );
147:
148: -- ------------------------- check_col_for_fk_on_aol ------------------------
149: -- Description:

Line 164: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,

160: -- list.
161: --------------------------------------------------------------------------------
162: procedure check_col_for_fk_on_aol
163: (
164: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
165: p_column_name in varchar2,
166: p_index out nocopy number
167: ) ;
168:

Line 183: p_table_info in hr_dm_gen_main.t_table_info,

179: -- 'L' - lookup type hierarchy.
180: ----------------------------------------------------------------------------
181: procedure populate_fk_to_aol_cols_info
182: (
183: p_table_info in hr_dm_gen_main.t_table_info,
184: p_fk_to_aol_columns_tbl out nocopy hr_dm_gen_main.t_fk_to_aol_columns_tbl,
185: p_hierarchy_type in varchar2 default 'A'
186: );
187: -- ------------------------- populate_columns_list ------------------------

Line 184: p_fk_to_aol_columns_tbl out nocopy hr_dm_gen_main.t_fk_to_aol_columns_tbl,

180: ----------------------------------------------------------------------------
181: procedure populate_fk_to_aol_cols_info
182: (
183: p_table_info in hr_dm_gen_main.t_table_info,
184: p_fk_to_aol_columns_tbl out nocopy hr_dm_gen_main.t_fk_to_aol_columns_tbl,
185: p_hierarchy_type in varchar2 default 'A'
186: );
187: -- ------------------------- populate_columns_list ------------------------
188: -- Description:

Line 207: p_table_info in hr_dm_gen_main.t_table_info,

203: -- in the procedure.
204: -- ------------------------------------------------------------------------
205: procedure populate_columns_list
206: (
207: p_table_info in hr_dm_gen_main.t_table_info,
208: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
209: p_columns_tbl out nocopy t_varchar2_tbl,
210: p_parameter_tbl out nocopy t_varchar2_tbl,
211: p_aol_columns_tbl out nocopy t_varchar2_tbl,

Line 208: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,

204: -- ------------------------------------------------------------------------
205: procedure populate_columns_list
206: (
207: p_table_info in hr_dm_gen_main.t_table_info,
208: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
209: p_columns_tbl out nocopy t_varchar2_tbl,
210: p_parameter_tbl out nocopy t_varchar2_tbl,
211: p_aol_columns_tbl out nocopy t_varchar2_tbl,
212: p_aol_parameter_tbl out nocopy t_varchar2_tbl,

Line 240: p_table_info in hr_dm_gen_main.t_table_info,

236: -- primary key.
237: -- ------------------------------------------------------------------------
238: procedure populate_pk_columns_list
239: (
240: p_table_info in hr_dm_gen_main.t_table_info,
241: p_pk_columns_tbl out nocopy t_varchar2_tbl,
242: p_pk_parameter_tbl out nocopy t_varchar2_tbl,
243: p_no_of_pk_columns out nocopy number
244: );

Line 278: p_table_info in hr_dm_gen_main.t_table_info,

274: -- generator package.
275: -- ------------------------------------------------------------------------
276: procedure populate_hierarchy_cols_list
277: (
278: p_table_info in hr_dm_gen_main.t_table_info,
279: p_hier_columns_tbl out nocopy t_varchar2_tbl,
280: p_hier_parameter_tbl out nocopy t_varchar2_tbl,
281: p_called_from in varchar2
282: );

Line 422: p_overide_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,

418: p_columns_tbl in t_varchar2_tbl,
419: p_col_length in number default 30,
420: p_start_terminator in varchar2 default ',',
421: p_end_terminator in varchar2 default null,
422: p_overide_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
423: p_overide_prefix in varchar2 default null
424: )
425: return varchar2;
426:

Line 638: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,

634: p_left_asg_pad_len in number default 30,
635: p_right_asg_pad_len in number default 30,
636: p_start_terminator in varchar2 default ',' ,
637: p_end_terminator in varchar2 default null,
638: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
639: p_test_with_nvl in varchar2 default 'N',
640: p_table_name in varchar2 default null
641: )
642: return varchar2;

Line 733: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,

729: p_pad_first_line in varchar2 default 'Y' ,
730: p_left_asg_pad_len in number default 30,
731: p_right_asg_pad_len in number default 30,
732: p_use_aol_id_col in varchar2,
733: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
734: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
735: )
736: return varchar2;
737: -- ------------------------ get_resolved_pk ------------------------------

Line 734: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl

730: p_left_asg_pad_len in number default 30,
731: p_right_asg_pad_len in number default 30,
732: p_use_aol_id_col in varchar2,
733: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
734: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
735: )
736: return varchar2;
737: -- ------------------------ get_resolved_pk ------------------------------
738: -- Description: This function is used by TUPS.

Line 994: p_table_info in hr_dm_gen_main.t_table_info

990: -- ------------------------------------------------------------------------
991:
992: procedure create_view
993: (
994: p_table_info in hr_dm_gen_main.t_table_info
995: );
996:
997:
998: -- ------------------------- create_stub_views ------------------------