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_ATT_SHD dependencies on PQH_ATTRIBUTES

Line 26: ElsIf (p_constraint_name = 'PQH_ATTRIBUTES_FK2') Then

22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_ATTRIBUTES_FK2') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;

Line 31: ElsIf (p_constraint_name = 'PQH_ATTRIBUTES_PK') Then

27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_ATTRIBUTES_PK') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;

Line 72: from pqh_attributes

68: object_version_number,
69: region_itemname,
70: attribute_itemname,
71: decode_function_name
72: from pqh_attributes
73: where attribute_id = p_attribute_id;
74: --
75: l_proc varchar2(72) := g_package||'api_updating';
76: l_fct_ret boolean;

Line 153: from pqh_attributes

149: object_version_number,
150: region_itemname,
151: attribute_itemname,
152: decode_function_name
153: from pqh_attributes
154: where attribute_id = p_attribute_id
155: for update nowait;
156: --
157: l_proc varchar2(72) := g_package||'lck';

Line 196: hr_utility.set_message_token('TABLE_NAME', 'pqh_attributes');

192: -- The object is locked therefore we need to supply a meaningful
193: -- error message.
194: --
195: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
196: hr_utility.set_message_token('TABLE_NAME', 'pqh_attributes');
197: hr_utility.raise_error;
198: End lck;
199: --
200: -- ----------------------------------------------------------------------------

Line 344: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;

340: l_object_version_number number := 1;
341: l_language varchar2(30) ;
342: l_delete_attr_ranges_flag varchar2(30) := 'N';
343: --
344: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
345: l_master_attribute_id pqh_attributes.master_attribute_id%TYPE;
346: l_master_table_route_id pqh_attributes.master_table_route_id%TYPE;
347: l_master_att_table_route_id pqh_attributes.master_table_route_id%TYPE;
348: --

Line 345: l_master_attribute_id pqh_attributes.master_attribute_id%TYPE;

341: l_language varchar2(30) ;
342: l_delete_attr_ranges_flag varchar2(30) := 'N';
343: --
344: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
345: l_master_attribute_id pqh_attributes.master_attribute_id%TYPE;
346: l_master_table_route_id pqh_attributes.master_table_route_id%TYPE;
347: l_master_att_table_route_id pqh_attributes.master_table_route_id%TYPE;
348: --
349: l_created_by pqh_attributes.created_by%TYPE;

Line 346: l_master_table_route_id pqh_attributes.master_table_route_id%TYPE;

342: l_delete_attr_ranges_flag varchar2(30) := 'N';
343: --
344: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
345: l_master_attribute_id pqh_attributes.master_attribute_id%TYPE;
346: l_master_table_route_id pqh_attributes.master_table_route_id%TYPE;
347: l_master_att_table_route_id pqh_attributes.master_table_route_id%TYPE;
348: --
349: l_created_by pqh_attributes.created_by%TYPE;
350: l_last_updated_by pqh_attributes.last_updated_by%TYPE;

Line 347: l_master_att_table_route_id pqh_attributes.master_table_route_id%TYPE;

343: --
344: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
345: l_master_attribute_id pqh_attributes.master_attribute_id%TYPE;
346: l_master_table_route_id pqh_attributes.master_table_route_id%TYPE;
347: l_master_att_table_route_id pqh_attributes.master_table_route_id%TYPE;
348: --
349: l_created_by pqh_attributes.created_by%TYPE;
350: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
351: l_creation_date pqh_attributes.creation_date%TYPE;

Line 349: l_created_by pqh_attributes.created_by%TYPE;

345: l_master_attribute_id pqh_attributes.master_attribute_id%TYPE;
346: l_master_table_route_id pqh_attributes.master_table_route_id%TYPE;
347: l_master_att_table_route_id pqh_attributes.master_table_route_id%TYPE;
348: --
349: l_created_by pqh_attributes.created_by%TYPE;
350: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
351: l_creation_date pqh_attributes.creation_date%TYPE;
352: l_last_update_date pqh_attributes.last_update_date%TYPE;
353: l_last_update_login pqh_attributes.last_update_login%TYPE;

Line 350: l_last_updated_by pqh_attributes.last_updated_by%TYPE;

346: l_master_table_route_id pqh_attributes.master_table_route_id%TYPE;
347: l_master_att_table_route_id pqh_attributes.master_table_route_id%TYPE;
348: --
349: l_created_by pqh_attributes.created_by%TYPE;
350: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
351: l_creation_date pqh_attributes.creation_date%TYPE;
352: l_last_update_date pqh_attributes.last_update_date%TYPE;
353: l_last_update_login pqh_attributes.last_update_login%TYPE;
354: --

Line 351: l_creation_date pqh_attributes.creation_date%TYPE;

347: l_master_att_table_route_id pqh_attributes.master_table_route_id%TYPE;
348: --
349: l_created_by pqh_attributes.created_by%TYPE;
350: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
351: l_creation_date pqh_attributes.creation_date%TYPE;
352: l_last_update_date pqh_attributes.last_update_date%TYPE;
353: l_last_update_login pqh_attributes.last_update_login%TYPE;
354: --
355: cursor c1 is select userenv('LANG') from dual ;

Line 352: l_last_update_date pqh_attributes.last_update_date%TYPE;

348: --
349: l_created_by pqh_attributes.created_by%TYPE;
350: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
351: l_creation_date pqh_attributes.creation_date%TYPE;
352: l_last_update_date pqh_attributes.last_update_date%TYPE;
353: l_last_update_login pqh_attributes.last_update_login%TYPE;
354: --
355: cursor c1 is select userenv('LANG') from dual ;
356: --

Line 353: l_last_update_login pqh_attributes.last_update_login%TYPE;

349: l_created_by pqh_attributes.created_by%TYPE;
350: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
351: l_creation_date pqh_attributes.creation_date%TYPE;
352: l_last_update_date pqh_attributes.last_update_date%TYPE;
353: l_last_update_login pqh_attributes.last_update_login%TYPE;
354: --
355: cursor c1 is select userenv('LANG') from dual ;
356: --
357: --

Line 363: from pqh_attributes

359: --
360: cursor csr_attribute_id(p_key_column_name IN VARCHAR2, p_table_id IN NUMBER,
361: p_legislation_code varchar2) is
362: select attribute_id,last_update_date
363: from pqh_attributes
364: where key_column_name = p_key_column_name
365: and nvl(legislation_code,'$$$') = nvl(p_legislation_code,'$$$')
366: and nvl(master_table_route_id,-999) = nvl(p_table_id, -999);
367: --

Line 373: l_last_upd_in_db pqh_attributes.last_update_date%TYPE;

369: select table_route_id
370: from pqh_table_route
371: where table_alias = p_table_alias;
372: --
373: l_last_upd_in_db pqh_attributes.last_update_date%TYPE;
374: l_dummy pqh_attributes.last_update_date%TYPE;
375: --
376: --
377: --

Line 374: l_dummy pqh_attributes.last_update_date%TYPE;

370: from pqh_table_route
371: where table_alias = p_table_alias;
372: --
373: l_last_upd_in_db pqh_attributes.last_update_date%TYPE;
374: l_dummy pqh_attributes.last_update_date%TYPE;
375: --
376: --
377: --
378: Begin

Line 436: UPDATE pqh_attributes

432: if l_attribute_id <> 0 then
433: -- row exits so update
434: If l_last_update_date > l_last_upd_in_db then
435:
436: UPDATE pqh_attributes
437: SET attribute_name = p_attribute_name,
438: master_attribute_id = l_master_attribute_id,
439: master_table_route_id = l_master_table_route_id,
440: key_column_name = p_key_column_name,

Line 460: UPDATE pqh_attributes_tl

456:
457: -- update the tl table
458: if (sql%found) then
459:
460: UPDATE pqh_attributes_tl
461: SET attribute_name = p_attribute_name,
462: last_updated_by = l_last_updated_by,
463: last_update_date = l_last_update_date,
464: last_update_login = l_last_update_login,

Line 473: insert into pqh_attributes_tl

469:
470: if (sql%notfound) then
471: -- no row in TL table so insert row
472:
473: insert into pqh_attributes_tl
474: ( attribute_id,
475: attribute_name,
476: language,
477: source_lang,

Line 498: from pqh_attributes_tl T

494: from FND_LANGUAGES L
495: where L.INSTALLED_FLAG in ('I', 'B')
496: and not exists
497: (select NULL
498: from pqh_attributes_tl T
499: where T.attribute_id = l_attribute_id
500: and T.LANGUAGE = L.LANGUAGE_CODE);
501:
502:

Line 510: -- insert into pqh_attributes and pqh_attributes_tl

506:
507: End if;
508: else
509:
510: -- insert into pqh_attributes and pqh_attributes_tl
511:
512: select pqh_attributes_s.nextval into l_attribute_id from dual;
513:
514: INSERT INTO pqh_attributes

Line 512: select pqh_attributes_s.nextval into l_attribute_id from dual;

508: else
509:
510: -- insert into pqh_attributes and pqh_attributes_tl
511:
512: select pqh_attributes_s.nextval into l_attribute_id from dual;
513:
514: INSERT INTO pqh_attributes
515: (attribute_id ,
516: attribute_name,

Line 514: INSERT INTO pqh_attributes

510: -- insert into pqh_attributes and pqh_attributes_tl
511:
512: select pqh_attributes_s.nextval into l_attribute_id from dual;
513:
514: INSERT INTO pqh_attributes
515: (attribute_id ,
516: attribute_name,
517: master_attribute_id,
518: master_table_route_id ,

Line 559: insert into pqh_attributes_tl

555: 1 );
556:
557: -- insert into tl table
558:
559: insert into pqh_attributes_tl
560: ( attribute_id,
561: attribute_name,
562: language,
563: source_lang,

Line 584: from pqh_attributes_tl T

580: from FND_LANGUAGES L
581: where L.INSTALLED_FLAG in ('I', 'B')
582: and not exists
583: (select NULL
584: from pqh_attributes_tl T
585: where T.attribute_id = l_attribute_id
586: and T.LANGUAGE = L.LANGUAGE_CODE);
587:
588:

Line 599: delete from PQH_ATTRIBUTES_TL T

595: -- ----------------------------------------------------------------------------
596: Procedure ADD_LANGUAGE
597: is
598: begin
599: delete from PQH_ATTRIBUTES_TL T
600: where not exists
601: (select NULL
602: from PQH_ATTRIBUTES B
603: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 602: from PQH_ATTRIBUTES B

598: begin
599: delete from PQH_ATTRIBUTES_TL T
600: where not exists
601: (select NULL
602: from PQH_ATTRIBUTES B
603: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
604: );
605:
606: update PQH_ATTRIBUTES_TL T set (

Line 606: update PQH_ATTRIBUTES_TL T set (

602: from PQH_ATTRIBUTES B
603: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
604: );
605:
606: update PQH_ATTRIBUTES_TL T set (
607: ATTRIBUTE_NAME
608: ) = (select
609: B.ATTRIBUTE_NAME
610: from PQH_ATTRIBUTES_TL B

Line 610: from PQH_ATTRIBUTES_TL B

606: update PQH_ATTRIBUTES_TL T set (
607: ATTRIBUTE_NAME
608: ) = (select
609: B.ATTRIBUTE_NAME
610: from PQH_ATTRIBUTES_TL B
611: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
612: and B.LANGUAGE = T.SOURCE_LANG)
613: where (
614: T.ATTRIBUTE_ID,

Line 619: from PQH_ATTRIBUTES_TL SUBB, PQH_ATTRIBUTES_TL SUBT

615: T.LANGUAGE
616: ) in (select
617: SUBT.ATTRIBUTE_ID,
618: SUBT.LANGUAGE
619: from PQH_ATTRIBUTES_TL SUBB, PQH_ATTRIBUTES_TL SUBT
620: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
621: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
622: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
623: ));

Line 625: insert into PQH_ATTRIBUTES_TL (

621: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
622: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
623: ));
624:
625: insert into PQH_ATTRIBUTES_TL (
626: ATTRIBUTE_ID,
627: ATTRIBUTE_NAME,
628: LAST_UPDATE_DATE,
629: CREATION_DATE,

Line 645: from PQH_ATTRIBUTES_TL B, FND_LANGUAGES L

641: B.LAST_UPDATE_LOGIN,
642: B.LAST_UPDATED_BY,
643: L.LANGUAGE_CODE,
644: B.SOURCE_LANG
645: from PQH_ATTRIBUTES_TL B, FND_LANGUAGES L
646: where L.INSTALLED_FLAG in ('I', 'B')
647: and B.LANGUAGE = userenv('LANG')
648: and not exists
649: (select NULL

Line 650: from PQH_ATTRIBUTES_TL T

646: where L.INSTALLED_FLAG in ('I', 'B')
647: and B.LANGUAGE = userenv('LANG')
648: and not exists
649: (select NULL
650: from PQH_ATTRIBUTES_TL T
651: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
652: and T.LANGUAGE = L.LANGUAGE_CODE);
653: end ADD_LANGUAGE;
654: --