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.PQH_TABLE_ROUTE_PKG dependencies on PQH_TABLE_ROUTE

Line 1: package body PQH_TABLE_ROUTE_PKG as

1: package body PQH_TABLE_ROUTE_PKG as
2: /* $Header: pqtrtpkg.pkb 120.3 2011/04/28 09:31:20 sidsaxen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_TABLE_ROUTE_ID in NUMBER,

Line 24: cursor C is select ROWID from PQH_TABLE_ROUTE

20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: l_x_rowid varchar2(100) := x_rowid;
23:
24: cursor C is select ROWID from PQH_TABLE_ROUTE
25: where TABLE_ROUTE_ID = X_TABLE_ROUTE_ID
26: ;
27: begin
28: insert into PQH_TABLE_ROUTE (

Line 28: insert into PQH_TABLE_ROUTE (

24: cursor C is select ROWID from PQH_TABLE_ROUTE
25: where TABLE_ROUTE_ID = X_TABLE_ROUTE_ID
26: ;
27: begin
28: insert into PQH_TABLE_ROUTE (
29: TABLE_ROUTE_ID,
30: SHADOW_TABLE_ROUTE_ID,
31: FROM_CLAUSE,
32: TABLE_ALIAS,

Line 64: insert into PQH_TABLE_ROUTE_TL (

60: X_LAST_UPDATED_BY,
61: X_LAST_UPDATE_LOGIN
62: );
63:
64: insert into PQH_TABLE_ROUTE_TL (
65: TABLE_ROUTE_ID,
66: DISPLAY_NAME,
67: LAST_UPDATE_DATE,
68: CREATION_DATE,

Line 88: from PQH_TABLE_ROUTE_TL T

84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
86: and not exists
87: (select NULL
88: from PQH_TABLE_ROUTE_TL T
89: where T.TABLE_ROUTE_ID = X_TABLE_ROUTE_ID
90: and T.LANGUAGE = L.LANGUAGE_CODE);
91:
92: open c;

Line 120: from PQH_TABLE_ROUTE

116: FROM_CLAUSE,
117: TABLE_ALIAS,
118: WHERE_CLAUSE,
119: OBJECT_VERSION_NUMBER
120: from PQH_TABLE_ROUTE
121: where TABLE_ROUTE_ID = X_TABLE_ROUTE_ID
122: for update of TABLE_ROUTE_ID nowait;
123: recinfo c%rowtype;
124:

Line 128: from PQH_TABLE_ROUTE_TL

124:
125: cursor c1 is select
126: DISPLAY_NAME,
127: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
128: from PQH_TABLE_ROUTE_TL
129: where TABLE_ROUTE_ID = X_TABLE_ROUTE_ID
130: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
131: for update of TABLE_ROUTE_ID nowait;
132: begin

Line 189: update PQH_TABLE_ROUTE set

185: X_LAST_UPDATED_BY in NUMBER,
186: X_LAST_UPDATE_LOGIN in NUMBER
187: ) is
188: begin
189: update PQH_TABLE_ROUTE set
190: SHADOW_TABLE_ROUTE_ID = X_SHADOW_TABLE_ROUTE_ID,
191: FROM_CLAUSE = X_FROM_CLAUSE,
192: TABLE_ALIAS = X_TABLE_ALIAS,
193: WHERE_CLAUSE = X_WHERE_CLAUSE,

Line 211: update PQH_TABLE_ROUTE_TL set

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: update PQH_TABLE_ROUTE_TL set
212: DISPLAY_NAME = X_DISPLAY_NAME,
213: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
214: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
215: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 230: delete from PQH_TABLE_ROUTE_TL

226: X_TABLE_ROUTE_ID in NUMBER
227: ) is
228: begin
229:
230: delete from PQH_TABLE_ROUTE_TL
231: where TABLE_ROUTE_ID = X_TABLE_ROUTE_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 242: p_entity_name=>'PQH_TABLE_ROUTE',

238: -- Added the following code as a part of Zero Downtime Patching Project.
239: -- Code Starts Here.
240: --
241: per_ric_pkg.Chk_integrity(
242: p_entity_name=>'PQH_TABLE_ROUTE',
243: p_ref_entity=>'PQH_TABLE_ROUTE_TL',
244: p_ref_column_name=> 'TABLE_ROUTE_ID',
245: p_ref_col_value_number=>X_TABLE_ROUTE_ID,
246: p_ref_col_value_varchar=>NULL,

Line 243: p_ref_entity=>'PQH_TABLE_ROUTE_TL',

239: -- Code Starts Here.
240: --
241: per_ric_pkg.Chk_integrity(
242: p_entity_name=>'PQH_TABLE_ROUTE',
243: p_ref_entity=>'PQH_TABLE_ROUTE_TL',
244: p_ref_column_name=> 'TABLE_ROUTE_ID',
245: p_ref_col_value_number=>X_TABLE_ROUTE_ID,
246: p_ref_col_value_varchar=>NULL,
247: p_ref_col_value_date=>NULL,

Line 253: delete from PQH_TABLE_ROUTE

249: --
250: -- Code Ends Here
251: --
252:
253: delete from PQH_TABLE_ROUTE
254: where TABLE_ROUTE_ID = X_TABLE_ROUTE_ID;
255:
256: if (sql%notfound) then
257: raise no_data_found;

Line 264: delete from PQH_TABLE_ROUTE_TL T

260:
261: procedure ADD_LANGUAGE
262: is
263: begin
264: delete from PQH_TABLE_ROUTE_TL T
265: where not exists
266: (select NULL
267: from PQH_TABLE_ROUTE B
268: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID

Line 267: from PQH_TABLE_ROUTE B

263: begin
264: delete from PQH_TABLE_ROUTE_TL T
265: where not exists
266: (select NULL
267: from PQH_TABLE_ROUTE B
268: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
269: );
270:
271: update PQH_TABLE_ROUTE_TL T set (

Line 271: update PQH_TABLE_ROUTE_TL T set (

267: from PQH_TABLE_ROUTE B
268: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
269: );
270:
271: update PQH_TABLE_ROUTE_TL T set (
272: DISPLAY_NAME
273: ) = (select
274: B.DISPLAY_NAME
275: from PQH_TABLE_ROUTE_TL B

Line 275: from PQH_TABLE_ROUTE_TL B

271: update PQH_TABLE_ROUTE_TL T set (
272: DISPLAY_NAME
273: ) = (select
274: B.DISPLAY_NAME
275: from PQH_TABLE_ROUTE_TL B
276: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
277: and B.LANGUAGE = T.SOURCE_LANG)
278: where (
279: T.TABLE_ROUTE_ID,

Line 284: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT

280: T.LANGUAGE
281: ) in (select
282: SUBT.TABLE_ROUTE_ID,
283: SUBT.LANGUAGE
284: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT
285: where SUBB.TABLE_ROUTE_ID = SUBT.TABLE_ROUTE_ID
286: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
287: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
288: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)

Line 292: insert into PQH_TABLE_ROUTE_TL (

288: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)
289: or (SUBB.DISPLAY_NAME is not null and SUBT.DISPLAY_NAME is null)
290: ));
291:
292: insert into PQH_TABLE_ROUTE_TL (
293: TABLE_ROUTE_ID,
294: DISPLAY_NAME,
295: LAST_UPDATE_DATE,
296: CREATION_DATE,

Line 312: from PQH_TABLE_ROUTE_TL B, FND_LANGUAGES L

308: B.LAST_UPDATE_LOGIN,
309: B.LAST_UPDATED_BY,
310: L.LANGUAGE_CODE,
311: B.SOURCE_LANG
312: from PQH_TABLE_ROUTE_TL B, FND_LANGUAGES L
313: where L.INSTALLED_FLAG in ('I', 'B')
314: and B.LANGUAGE = userenv('LANG')
315: and not exists
316: (select NULL

Line 317: from PQH_TABLE_ROUTE_TL T

313: where L.INSTALLED_FLAG in ('I', 'B')
314: and B.LANGUAGE = userenv('LANG')
315: and not exists
316: (select NULL
317: from PQH_TABLE_ROUTE_TL T
318: where T.TABLE_ROUTE_ID = B.TABLE_ROUTE_ID
319: and T.LANGUAGE = L.LANGUAGE_CODE);
320: end ADD_LANGUAGE;
321:

Line 339: l_table_route_id pqh_table_route.table_route_id%TYPE;

335: p_owner IN VARCHAR2
336: ) is
337:
338:
339: l_table_route_id pqh_table_route.table_route_id%TYPE;
340: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
341: l_from_clause pqh_table_route.from_clause%TYPE;
342: l_table_alias pqh_table_route.table_alias%TYPE;
343: l_where_clause pqh_table_route.where_clause%TYPE;

Line 340: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;

336: ) is
337:
338:
339: l_table_route_id pqh_table_route.table_route_id%TYPE;
340: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
341: l_from_clause pqh_table_route.from_clause%TYPE;
342: l_table_alias pqh_table_route.table_alias%TYPE;
343: l_where_clause pqh_table_route.where_clause%TYPE;
344: l_display_name pqh_table_route.display_name%TYPE;

Line 341: l_from_clause pqh_table_route.from_clause%TYPE;

337:
338:
339: l_table_route_id pqh_table_route.table_route_id%TYPE;
340: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
341: l_from_clause pqh_table_route.from_clause%TYPE;
342: l_table_alias pqh_table_route.table_alias%TYPE;
343: l_where_clause pqh_table_route.where_clause%TYPE;
344: l_display_name pqh_table_route.display_name%TYPE;
345: l_rowid ROWID;

Line 342: l_table_alias pqh_table_route.table_alias%TYPE;

338:
339: l_table_route_id pqh_table_route.table_route_id%TYPE;
340: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
341: l_from_clause pqh_table_route.from_clause%TYPE;
342: l_table_alias pqh_table_route.table_alias%TYPE;
343: l_where_clause pqh_table_route.where_clause%TYPE;
344: l_display_name pqh_table_route.display_name%TYPE;
345: l_rowid ROWID;
346: l_map_required_flag pqh_table_route.map_required_flag%TYPE;

Line 343: l_where_clause pqh_table_route.where_clause%TYPE;

339: l_table_route_id pqh_table_route.table_route_id%TYPE;
340: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
341: l_from_clause pqh_table_route.from_clause%TYPE;
342: l_table_alias pqh_table_route.table_alias%TYPE;
343: l_where_clause pqh_table_route.where_clause%TYPE;
344: l_display_name pqh_table_route.display_name%TYPE;
345: l_rowid ROWID;
346: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
347: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;

Line 344: l_display_name pqh_table_route.display_name%TYPE;

340: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
341: l_from_clause pqh_table_route.from_clause%TYPE;
342: l_table_alias pqh_table_route.table_alias%TYPE;
343: l_where_clause pqh_table_route.where_clause%TYPE;
344: l_display_name pqh_table_route.display_name%TYPE;
345: l_rowid ROWID;
346: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
347: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
348: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;

Line 346: l_map_required_flag pqh_table_route.map_required_flag%TYPE;

342: l_table_alias pqh_table_route.table_alias%TYPE;
343: l_where_clause pqh_table_route.where_clause%TYPE;
344: l_display_name pqh_table_route.display_name%TYPE;
345: l_rowid ROWID;
346: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
347: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
348: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
349: l_display_order pqh_table_route.display_order%TYPE;
350:

Line 347: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;

343: l_where_clause pqh_table_route.where_clause%TYPE;
344: l_display_name pqh_table_route.display_name%TYPE;
345: l_rowid ROWID;
346: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
347: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
348: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
349: l_display_order pqh_table_route.display_order%TYPE;
350:
351:

Line 348: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;

344: l_display_name pqh_table_route.display_name%TYPE;
345: l_rowid ROWID;
346: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
347: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
348: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
349: l_display_order pqh_table_route.display_order%TYPE;
350:
351:
352: l_created_by pqh_table_route.created_by%TYPE;

Line 349: l_display_order pqh_table_route.display_order%TYPE;

345: l_rowid ROWID;
346: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
347: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
348: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
349: l_display_order pqh_table_route.display_order%TYPE;
350:
351:
352: l_created_by pqh_table_route.created_by%TYPE;
353: l_last_updated_by pqh_table_route.last_updated_by%TYPE;

Line 352: l_created_by pqh_table_route.created_by%TYPE;

348: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
349: l_display_order pqh_table_route.display_order%TYPE;
350:
351:
352: l_created_by pqh_table_route.created_by%TYPE;
353: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
354: l_creation_date pqh_table_route.creation_date%TYPE;
355: l_last_update_date pqh_table_route.last_update_date%TYPE;
356: l_last_update_login pqh_table_route.last_update_login%TYPE;

Line 353: l_last_updated_by pqh_table_route.last_updated_by%TYPE;

349: l_display_order pqh_table_route.display_order%TYPE;
350:
351:
352: l_created_by pqh_table_route.created_by%TYPE;
353: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
354: l_creation_date pqh_table_route.creation_date%TYPE;
355: l_last_update_date pqh_table_route.last_update_date%TYPE;
356: l_last_update_login pqh_table_route.last_update_login%TYPE;
357: --

Line 354: l_creation_date pqh_table_route.creation_date%TYPE;

350:
351:
352: l_created_by pqh_table_route.created_by%TYPE;
353: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
354: l_creation_date pqh_table_route.creation_date%TYPE;
355: l_last_update_date pqh_table_route.last_update_date%TYPE;
356: l_last_update_login pqh_table_route.last_update_login%TYPE;
357: --
358: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;

Line 355: l_last_update_date pqh_table_route.last_update_date%TYPE;

351:
352: l_created_by pqh_table_route.created_by%TYPE;
353: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
354: l_creation_date pqh_table_route.creation_date%TYPE;
355: l_last_update_date pqh_table_route.last_update_date%TYPE;
356: l_last_update_login pqh_table_route.last_update_login%TYPE;
357: --
358: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;
359: --

Line 356: l_last_update_login pqh_table_route.last_update_login%TYPE;

352: l_created_by pqh_table_route.created_by%TYPE;
353: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
354: l_creation_date pqh_table_route.creation_date%TYPE;
355: l_last_update_date pqh_table_route.last_update_date%TYPE;
356: l_last_update_login pqh_table_route.last_update_login%TYPE;
357: --
358: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;
359: --
360: cursor csr_table_route_id is

Line 358: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;

354: l_creation_date pqh_table_route.creation_date%TYPE;
355: l_last_update_date pqh_table_route.last_update_date%TYPE;
356: l_last_update_login pqh_table_route.last_update_login%TYPE;
357: --
358: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;
359: --
360: cursor csr_table_route_id is
361: select table_route_id,last_update_date
362: from pqh_table_route

Line 362: from pqh_table_route

358: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;
359: --
360: cursor csr_table_route_id is
361: select table_route_id,last_update_date
362: from pqh_table_route
363: where table_alias = p_table_alias;
364:
365: cursor csr_shadow_table_route_id is
366: select table_route_id

Line 367: from pqh_table_route

363: where table_alias = p_table_alias;
364:
365: cursor csr_shadow_table_route_id is
366: select table_route_id
367: from pqh_table_route
368: where table_alias = p_shadow_table;
369:
370: begin
371:

Line 424: select pqh_table_route_s.nextval into l_table_route_id from dual;

420: End if;
421:
422: else
423: -- select table_route_id into local variable.
424: select pqh_table_route_s.nextval into l_table_route_id from dual;
425:
426: INSERT_ROW (
427: X_ROWID => l_rowid,
428: X_TABLE_ROUTE_ID => l_table_route_id ,

Line 468: select pqh_table_route_s.nextval into l_table_route_id from dual;

464:
465: exception
466: when NO_DATA_FOUND then
467: -- select table_route_id into local variable.
468: select pqh_table_route_s.nextval into l_table_route_id from dual;
469:
470: INSERT_ROW (
471: X_ROWID => l_rowid,
472: X_TABLE_ROUTE_ID => l_table_route_id ,

Line 503: from pqh_table_route

499: p_owner in varchar2) is
500:
501: cursor csr_table_route_id is
502: select table_route_id
503: from pqh_table_route
504: where table_alias = p_table_alias;
505:
506: l_table_route_id pqh_table_route.table_route_id%TYPE;
507: l_created_by pqh_table_route.created_by%TYPE;

Line 506: l_table_route_id pqh_table_route.table_route_id%TYPE;

502: select table_route_id
503: from pqh_table_route
504: where table_alias = p_table_alias;
505:
506: l_table_route_id pqh_table_route.table_route_id%TYPE;
507: l_created_by pqh_table_route.created_by%TYPE;
508: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
509: l_creation_date pqh_table_route.creation_date%TYPE;
510: l_last_update_date pqh_table_route.last_update_date%TYPE;

Line 507: l_created_by pqh_table_route.created_by%TYPE;

503: from pqh_table_route
504: where table_alias = p_table_alias;
505:
506: l_table_route_id pqh_table_route.table_route_id%TYPE;
507: l_created_by pqh_table_route.created_by%TYPE;
508: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
509: l_creation_date pqh_table_route.creation_date%TYPE;
510: l_last_update_date pqh_table_route.last_update_date%TYPE;
511: l_last_update_login pqh_table_route.last_update_login%TYPE;

Line 508: l_last_updated_by pqh_table_route.last_updated_by%TYPE;

504: where table_alias = p_table_alias;
505:
506: l_table_route_id pqh_table_route.table_route_id%TYPE;
507: l_created_by pqh_table_route.created_by%TYPE;
508: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
509: l_creation_date pqh_table_route.creation_date%TYPE;
510: l_last_update_date pqh_table_route.last_update_date%TYPE;
511: l_last_update_login pqh_table_route.last_update_login%TYPE;
512:

Line 509: l_creation_date pqh_table_route.creation_date%TYPE;

505:
506: l_table_route_id pqh_table_route.table_route_id%TYPE;
507: l_created_by pqh_table_route.created_by%TYPE;
508: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
509: l_creation_date pqh_table_route.creation_date%TYPE;
510: l_last_update_date pqh_table_route.last_update_date%TYPE;
511: l_last_update_login pqh_table_route.last_update_login%TYPE;
512:
513:

Line 510: l_last_update_date pqh_table_route.last_update_date%TYPE;

506: l_table_route_id pqh_table_route.table_route_id%TYPE;
507: l_created_by pqh_table_route.created_by%TYPE;
508: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
509: l_creation_date pqh_table_route.creation_date%TYPE;
510: l_last_update_date pqh_table_route.last_update_date%TYPE;
511: l_last_update_login pqh_table_route.last_update_login%TYPE;
512:
513:
514: begin

Line 511: l_last_update_login pqh_table_route.last_update_login%TYPE;

507: l_created_by pqh_table_route.created_by%TYPE;
508: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
509: l_creation_date pqh_table_route.creation_date%TYPE;
510: l_last_update_date pqh_table_route.last_update_date%TYPE;
511: l_last_update_login pqh_table_route.last_update_login%TYPE;
512:
513:
514: begin
515: -- get table_route_id

Line 534: update pqh_table_route_tl

530: l_last_update_date := sysdate;
531: l_last_update_login := 0;
532: l_last_updated_by := fnd_load_util.owner_id(p_owner);
533:
534: update pqh_table_route_tl
535: set display_name = p_display_name ,
536: last_update_date = l_last_update_date,
537: last_updated_by = l_last_updated_by,
538: last_update_login = l_last_update_login,

Line 570: PQH_TABLE_ROUTE_PKG.translate_row (

566: l_data_migrator_mode := hr_general.g_data_migrator_mode ;
567: hr_general.g_data_migrator_mode := 'Y';
568:
569: if (p_upload_mode = 'NLS') then
570: PQH_TABLE_ROUTE_PKG.translate_row (
571: p_table_alias => p_table_alias,
572: p_display_name => p_display_name,
573: p_owner => p_owner );
574: else

Line 575: pqh_table_route_pkg.load_row

571: p_table_alias => p_table_alias,
572: p_display_name => p_display_name,
573: p_owner => p_owner );
574: else
575: pqh_table_route_pkg.load_row
576: ( p_table_alias => p_table_alias,
577: p_shadow_table => p_shadow_table,
578: p_from_clause => p_from_clause,
579: p_where_clause => p_where_clause,

Line 592: end PQH_TABLE_ROUTE_PKG;

588: hr_general.g_data_migrator_mode := l_data_migrator_mode;
589:
590: End;
591: --
592: end PQH_TABLE_ROUTE_PKG;