APPS.PQH_ATT_SHD dependencies on PQH_ATTRIBUTES_TL

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:

Line 576: insert into pqh_attributes_tl

572: 1 );
573:
574: -- insert into tl table
575:
576: insert into pqh_attributes_tl
577: ( attribute_id,
578: attribute_name,
579: language,
580: source_lang,

Line 601: from pqh_attributes_tl T

597: from FND_LANGUAGES L
598: where L.INSTALLED_FLAG in ('I', 'B')
599: and not exists
600: (select NULL
601: from pqh_attributes_tl T
602: where T.attribute_id = l_attribute_id
603: and T.LANGUAGE = L.LANGUAGE_CODE);
604:
605:

Line 616: delete from PQH_ATTRIBUTES_TL T

612: -- ----------------------------------------------------------------------------
613: Procedure ADD_LANGUAGE
614: is
615: begin
616: delete from PQH_ATTRIBUTES_TL T
617: where not exists
618: (select NULL
619: from PQH_ATTRIBUTES B
620: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 623: update PQH_ATTRIBUTES_TL T set (

619: from PQH_ATTRIBUTES B
620: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
621: );
622:
623: update PQH_ATTRIBUTES_TL T set (
624: ATTRIBUTE_NAME
625: ) = (select
626: B.ATTRIBUTE_NAME
627: from PQH_ATTRIBUTES_TL B

Line 627: from PQH_ATTRIBUTES_TL B

623: update PQH_ATTRIBUTES_TL T set (
624: ATTRIBUTE_NAME
625: ) = (select
626: B.ATTRIBUTE_NAME
627: from PQH_ATTRIBUTES_TL B
628: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
629: and B.LANGUAGE = T.SOURCE_LANG)
630: where (
631: T.ATTRIBUTE_ID,

Line 636: from PQH_ATTRIBUTES_TL SUBB, PQH_ATTRIBUTES_TL SUBT

632: T.LANGUAGE
633: ) in (select
634: SUBT.ATTRIBUTE_ID,
635: SUBT.LANGUAGE
636: from PQH_ATTRIBUTES_TL SUBB, PQH_ATTRIBUTES_TL SUBT
637: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
638: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
639: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
640: ));

Line 642: insert into PQH_ATTRIBUTES_TL (

638: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
639: and (SUBB.ATTRIBUTE_NAME <> SUBT.ATTRIBUTE_NAME
640: ));
641:
642: insert into PQH_ATTRIBUTES_TL (
643: ATTRIBUTE_ID,
644: ATTRIBUTE_NAME,
645: LAST_UPDATE_DATE,
646: CREATION_DATE,

Line 662: from PQH_ATTRIBUTES_TL B, FND_LANGUAGES L

658: B.LAST_UPDATE_LOGIN,
659: B.LAST_UPDATED_BY,
660: L.LANGUAGE_CODE,
661: B.SOURCE_LANG
662: from PQH_ATTRIBUTES_TL B, FND_LANGUAGES L
663: where L.INSTALLED_FLAG in ('I', 'B')
664: and B.LANGUAGE = userenv('LANG')
665: and not exists
666: (select NULL

Line 667: from PQH_ATTRIBUTES_TL T

663: where L.INSTALLED_FLAG in ('I', 'B')
664: and B.LANGUAGE = userenv('LANG')
665: and not exists
666: (select NULL
667: from PQH_ATTRIBUTES_TL T
668: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
669: and T.LANGUAGE = L.LANGUAGE_CODE);
670: end ADD_LANGUAGE;
671: --