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.2 2005/10/12 20:20:30 srajakum noship $ */
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 229: delete from PQH_TABLE_ROUTE_TL

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

Line 236: delete from PQH_TABLE_ROUTE

232: if (sql%notfound) then
233: raise no_data_found;
234: end if;
235:
236: delete from PQH_TABLE_ROUTE
237: where TABLE_ROUTE_ID = X_TABLE_ROUTE_ID;
238:
239: if (sql%notfound) then
240: raise no_data_found;

Line 247: delete from PQH_TABLE_ROUTE_TL T

243:
244: procedure ADD_LANGUAGE
245: is
246: begin
247: delete from PQH_TABLE_ROUTE_TL T
248: where not exists
249: (select NULL
250: from PQH_TABLE_ROUTE B
251: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID

Line 250: from PQH_TABLE_ROUTE B

246: begin
247: delete from PQH_TABLE_ROUTE_TL T
248: where not exists
249: (select NULL
250: from PQH_TABLE_ROUTE B
251: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
252: );
253:
254: update PQH_TABLE_ROUTE_TL T set (

Line 254: update PQH_TABLE_ROUTE_TL T set (

250: from PQH_TABLE_ROUTE B
251: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
252: );
253:
254: update PQH_TABLE_ROUTE_TL T set (
255: DISPLAY_NAME
256: ) = (select
257: B.DISPLAY_NAME
258: from PQH_TABLE_ROUTE_TL B

Line 258: from PQH_TABLE_ROUTE_TL B

254: update PQH_TABLE_ROUTE_TL T set (
255: DISPLAY_NAME
256: ) = (select
257: B.DISPLAY_NAME
258: from PQH_TABLE_ROUTE_TL B
259: where B.TABLE_ROUTE_ID = T.TABLE_ROUTE_ID
260: and B.LANGUAGE = T.SOURCE_LANG)
261: where (
262: T.TABLE_ROUTE_ID,

Line 267: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT

263: T.LANGUAGE
264: ) in (select
265: SUBT.TABLE_ROUTE_ID,
266: SUBT.LANGUAGE
267: from PQH_TABLE_ROUTE_TL SUBB, PQH_TABLE_ROUTE_TL SUBT
268: where SUBB.TABLE_ROUTE_ID = SUBT.TABLE_ROUTE_ID
269: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
270: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
271: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)

Line 275: insert into PQH_TABLE_ROUTE_TL (

271: or (SUBB.DISPLAY_NAME is null and SUBT.DISPLAY_NAME is not null)
272: or (SUBB.DISPLAY_NAME is not null and SUBT.DISPLAY_NAME is null)
273: ));
274:
275: insert into PQH_TABLE_ROUTE_TL (
276: TABLE_ROUTE_ID,
277: DISPLAY_NAME,
278: LAST_UPDATE_DATE,
279: CREATION_DATE,

Line 295: from PQH_TABLE_ROUTE_TL B, FND_LANGUAGES L

291: B.LAST_UPDATE_LOGIN,
292: B.LAST_UPDATED_BY,
293: L.LANGUAGE_CODE,
294: B.SOURCE_LANG
295: from PQH_TABLE_ROUTE_TL B, FND_LANGUAGES L
296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL

Line 300: from PQH_TABLE_ROUTE_TL T

296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL
300: from PQH_TABLE_ROUTE_TL T
301: where T.TABLE_ROUTE_ID = B.TABLE_ROUTE_ID
302: and T.LANGUAGE = L.LANGUAGE_CODE);
303: end ADD_LANGUAGE;
304:

Line 322: l_table_route_id pqh_table_route.table_route_id%TYPE;

318: p_owner IN VARCHAR2
319: ) is
320:
321:
322: l_table_route_id pqh_table_route.table_route_id%TYPE;
323: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
324: l_from_clause pqh_table_route.from_clause%TYPE;
325: l_table_alias pqh_table_route.table_alias%TYPE;
326: l_where_clause pqh_table_route.where_clause%TYPE;

Line 323: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;

319: ) is
320:
321:
322: l_table_route_id pqh_table_route.table_route_id%TYPE;
323: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
324: l_from_clause pqh_table_route.from_clause%TYPE;
325: l_table_alias pqh_table_route.table_alias%TYPE;
326: l_where_clause pqh_table_route.where_clause%TYPE;
327: l_display_name pqh_table_route.display_name%TYPE;

Line 324: l_from_clause pqh_table_route.from_clause%TYPE;

320:
321:
322: l_table_route_id pqh_table_route.table_route_id%TYPE;
323: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
324: l_from_clause pqh_table_route.from_clause%TYPE;
325: l_table_alias pqh_table_route.table_alias%TYPE;
326: l_where_clause pqh_table_route.where_clause%TYPE;
327: l_display_name pqh_table_route.display_name%TYPE;
328: l_rowid ROWID;

Line 325: l_table_alias pqh_table_route.table_alias%TYPE;

321:
322: l_table_route_id pqh_table_route.table_route_id%TYPE;
323: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
324: l_from_clause pqh_table_route.from_clause%TYPE;
325: l_table_alias pqh_table_route.table_alias%TYPE;
326: l_where_clause pqh_table_route.where_clause%TYPE;
327: l_display_name pqh_table_route.display_name%TYPE;
328: l_rowid ROWID;
329: l_map_required_flag pqh_table_route.map_required_flag%TYPE;

Line 326: l_where_clause pqh_table_route.where_clause%TYPE;

322: l_table_route_id pqh_table_route.table_route_id%TYPE;
323: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
324: l_from_clause pqh_table_route.from_clause%TYPE;
325: l_table_alias pqh_table_route.table_alias%TYPE;
326: l_where_clause pqh_table_route.where_clause%TYPE;
327: l_display_name pqh_table_route.display_name%TYPE;
328: l_rowid ROWID;
329: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
330: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;

Line 327: l_display_name pqh_table_route.display_name%TYPE;

323: l_shadow_table_route_id pqh_table_route.shadow_table_route_id%TYPE;
324: l_from_clause pqh_table_route.from_clause%TYPE;
325: l_table_alias pqh_table_route.table_alias%TYPE;
326: l_where_clause pqh_table_route.where_clause%TYPE;
327: l_display_name pqh_table_route.display_name%TYPE;
328: l_rowid ROWID;
329: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
330: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
331: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;

Line 329: l_map_required_flag pqh_table_route.map_required_flag%TYPE;

325: l_table_alias pqh_table_route.table_alias%TYPE;
326: l_where_clause pqh_table_route.where_clause%TYPE;
327: l_display_name pqh_table_route.display_name%TYPE;
328: l_rowid ROWID;
329: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
330: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
331: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
332: l_display_order pqh_table_route.display_order%TYPE;
333:

Line 330: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;

326: l_where_clause pqh_table_route.where_clause%TYPE;
327: l_display_name pqh_table_route.display_name%TYPE;
328: l_rowid ROWID;
329: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
330: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
331: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
332: l_display_order pqh_table_route.display_order%TYPE;
333:
334:

Line 331: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;

327: l_display_name pqh_table_route.display_name%TYPE;
328: l_rowid ROWID;
329: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
330: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
331: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
332: l_display_order pqh_table_route.display_order%TYPE;
333:
334:
335: l_created_by pqh_table_route.created_by%TYPE;

Line 332: l_display_order pqh_table_route.display_order%TYPE;

328: l_rowid ROWID;
329: l_map_required_flag pqh_table_route.map_required_flag%TYPE;
330: l_select_allowed_flag pqh_table_route.select_allowed_flag%TYPE;
331: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
332: l_display_order pqh_table_route.display_order%TYPE;
333:
334:
335: l_created_by pqh_table_route.created_by%TYPE;
336: l_last_updated_by pqh_table_route.last_updated_by%TYPE;

Line 335: l_created_by pqh_table_route.created_by%TYPE;

331: l_hide_table_for_view_flag pqh_table_route.hide_table_for_view_flag%TYPE;
332: l_display_order pqh_table_route.display_order%TYPE;
333:
334:
335: l_created_by pqh_table_route.created_by%TYPE;
336: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
337: l_creation_date pqh_table_route.creation_date%TYPE;
338: l_last_update_date pqh_table_route.last_update_date%TYPE;
339: l_last_update_login pqh_table_route.last_update_login%TYPE;

Line 336: l_last_updated_by pqh_table_route.last_updated_by%TYPE;

332: l_display_order pqh_table_route.display_order%TYPE;
333:
334:
335: l_created_by pqh_table_route.created_by%TYPE;
336: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
337: l_creation_date pqh_table_route.creation_date%TYPE;
338: l_last_update_date pqh_table_route.last_update_date%TYPE;
339: l_last_update_login pqh_table_route.last_update_login%TYPE;
340: --

Line 337: l_creation_date pqh_table_route.creation_date%TYPE;

333:
334:
335: l_created_by pqh_table_route.created_by%TYPE;
336: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
337: l_creation_date pqh_table_route.creation_date%TYPE;
338: l_last_update_date pqh_table_route.last_update_date%TYPE;
339: l_last_update_login pqh_table_route.last_update_login%TYPE;
340: --
341: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;

Line 338: l_last_update_date pqh_table_route.last_update_date%TYPE;

334:
335: l_created_by pqh_table_route.created_by%TYPE;
336: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
337: l_creation_date pqh_table_route.creation_date%TYPE;
338: l_last_update_date pqh_table_route.last_update_date%TYPE;
339: l_last_update_login pqh_table_route.last_update_login%TYPE;
340: --
341: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;
342: --

Line 339: l_last_update_login pqh_table_route.last_update_login%TYPE;

335: l_created_by pqh_table_route.created_by%TYPE;
336: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
337: l_creation_date pqh_table_route.creation_date%TYPE;
338: l_last_update_date pqh_table_route.last_update_date%TYPE;
339: l_last_update_login pqh_table_route.last_update_login%TYPE;
340: --
341: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;
342: --
343: cursor csr_table_route_id is

Line 341: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;

337: l_creation_date pqh_table_route.creation_date%TYPE;
338: l_last_update_date pqh_table_route.last_update_date%TYPE;
339: l_last_update_login pqh_table_route.last_update_login%TYPE;
340: --
341: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;
342: --
343: cursor csr_table_route_id is
344: select table_route_id,last_update_date
345: from pqh_table_route

Line 345: from pqh_table_route

341: l_last_upd_in_db pqh_table_route.last_update_date%TYPE;
342: --
343: cursor csr_table_route_id is
344: select table_route_id,last_update_date
345: from pqh_table_route
346: where table_alias = p_table_alias;
347:
348: cursor csr_shadow_table_route_id is
349: select table_route_id

Line 350: from pqh_table_route

346: where table_alias = p_table_alias;
347:
348: cursor csr_shadow_table_route_id is
349: select table_route_id
350: from pqh_table_route
351: where table_alias = p_shadow_table;
352:
353: begin
354:

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

403: End if;
404:
405: else
406: -- select table_route_id into local variable.
407: select pqh_table_route_s.nextval into l_table_route_id from dual;
408:
409: INSERT_ROW (
410: X_ROWID => l_rowid,
411: X_TABLE_ROUTE_ID => l_table_route_id ,

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

447:
448: exception
449: when NO_DATA_FOUND then
450: -- select table_route_id into local variable.
451: select pqh_table_route_s.nextval into l_table_route_id from dual;
452:
453: INSERT_ROW (
454: X_ROWID => l_rowid,
455: X_TABLE_ROUTE_ID => l_table_route_id ,

Line 486: from pqh_table_route

482: p_owner in varchar2) is
483:
484: cursor csr_table_route_id is
485: select table_route_id
486: from pqh_table_route
487: where table_alias = p_table_alias;
488:
489: l_table_route_id pqh_table_route.table_route_id%TYPE;
490: l_created_by pqh_table_route.created_by%TYPE;

Line 489: l_table_route_id pqh_table_route.table_route_id%TYPE;

485: select table_route_id
486: from pqh_table_route
487: where table_alias = p_table_alias;
488:
489: l_table_route_id pqh_table_route.table_route_id%TYPE;
490: l_created_by pqh_table_route.created_by%TYPE;
491: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
492: l_creation_date pqh_table_route.creation_date%TYPE;
493: l_last_update_date pqh_table_route.last_update_date%TYPE;

Line 490: l_created_by pqh_table_route.created_by%TYPE;

486: from pqh_table_route
487: where table_alias = p_table_alias;
488:
489: l_table_route_id pqh_table_route.table_route_id%TYPE;
490: l_created_by pqh_table_route.created_by%TYPE;
491: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
492: l_creation_date pqh_table_route.creation_date%TYPE;
493: l_last_update_date pqh_table_route.last_update_date%TYPE;
494: l_last_update_login pqh_table_route.last_update_login%TYPE;

Line 491: l_last_updated_by pqh_table_route.last_updated_by%TYPE;

487: where table_alias = p_table_alias;
488:
489: l_table_route_id pqh_table_route.table_route_id%TYPE;
490: l_created_by pqh_table_route.created_by%TYPE;
491: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
492: l_creation_date pqh_table_route.creation_date%TYPE;
493: l_last_update_date pqh_table_route.last_update_date%TYPE;
494: l_last_update_login pqh_table_route.last_update_login%TYPE;
495:

Line 492: l_creation_date pqh_table_route.creation_date%TYPE;

488:
489: l_table_route_id pqh_table_route.table_route_id%TYPE;
490: l_created_by pqh_table_route.created_by%TYPE;
491: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
492: l_creation_date pqh_table_route.creation_date%TYPE;
493: l_last_update_date pqh_table_route.last_update_date%TYPE;
494: l_last_update_login pqh_table_route.last_update_login%TYPE;
495:
496:

Line 493: l_last_update_date pqh_table_route.last_update_date%TYPE;

489: l_table_route_id pqh_table_route.table_route_id%TYPE;
490: l_created_by pqh_table_route.created_by%TYPE;
491: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
492: l_creation_date pqh_table_route.creation_date%TYPE;
493: l_last_update_date pqh_table_route.last_update_date%TYPE;
494: l_last_update_login pqh_table_route.last_update_login%TYPE;
495:
496:
497: begin

Line 494: l_last_update_login pqh_table_route.last_update_login%TYPE;

490: l_created_by pqh_table_route.created_by%TYPE;
491: l_last_updated_by pqh_table_route.last_updated_by%TYPE;
492: l_creation_date pqh_table_route.creation_date%TYPE;
493: l_last_update_date pqh_table_route.last_update_date%TYPE;
494: l_last_update_login pqh_table_route.last_update_login%TYPE;
495:
496:
497: begin
498: -- get table_route_id

Line 517: update pqh_table_route_tl

513: l_last_update_date := sysdate;
514: l_last_update_login := 0;
515: l_last_updated_by := fnd_load_util.owner_id(p_owner);
516:
517: update pqh_table_route_tl
518: set display_name = p_display_name ,
519: last_update_date = l_last_update_date,
520: last_updated_by = l_last_updated_by,
521: last_update_login = l_last_update_login,

Line 553: PQH_TABLE_ROUTE_PKG.translate_row (

549: l_data_migrator_mode := hr_general.g_data_migrator_mode ;
550: hr_general.g_data_migrator_mode := 'Y';
551:
552: if (p_upload_mode = 'NLS') then
553: PQH_TABLE_ROUTE_PKG.translate_row (
554: p_table_alias => p_table_alias,
555: p_display_name => p_display_name,
556: p_owner => p_owner );
557: else

Line 558: pqh_table_route_pkg.load_row

554: p_table_alias => p_table_alias,
555: p_display_name => p_display_name,
556: p_owner => p_owner );
557: else
558: pqh_table_route_pkg.load_row
559: ( p_table_alias => p_table_alias,
560: p_shadow_table => p_shadow_table,
561: p_from_clause => p_from_clause,
562: p_where_clause => p_where_clause,

Line 575: end PQH_TABLE_ROUTE_PKG;

571: hr_general.g_data_migrator_mode := l_data_migrator_mode;
572:
573: End;
574: --
575: end PQH_TABLE_ROUTE_PKG;