APPS.HZ_ORG_PROFILES_EXT_PKG dependencies on HZ_ORG_PROFILES_EXT_TL

Line 212: insert into HZ_ORG_PROFILES_EXT_TL (

208: X_LAST_UPDATED_BY,
209: X_LAST_UPDATE_LOGIN
210: );
211:
212: insert into HZ_ORG_PROFILES_EXT_TL (
213: EXTENSION_ID,
214: ORGANIZATION_PROFILE_ID,
215: ATTR_GROUP_ID,
216: CREATED_BY,

Line 278: from HZ_ORG_PROFILES_EXT_TL T

274: from FND_LANGUAGES L
275: where L.INSTALLED_FLAG in ('I', 'B')
276: and not exists
277: (select NULL
278: from HZ_ORG_PROFILES_EXT_TL T
279: where T.EXTENSION_ID = X_EXTENSION_ID
280: and T.LANGUAGE = L.LANGUAGE_CODE);
281:
282: open c;

Line 449: from HZ_ORG_PROFILES_EXT_TL

445: TL_EXT_ATTR18,
446: TL_EXT_ATTR19,
447: TL_EXT_ATTR20,
448: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
449: from HZ_ORG_PROFILES_EXT_TL
450: where EXTENSION_ID = X_EXTENSION_ID
451: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
452: for update of EXTENSION_ID nowait;
453: begin

Line 769: update HZ_ORG_PROFILES_EXT_TL set

765: if (sql%notfound) then
766: raise no_data_found;
767: end if;
768:
769: update HZ_ORG_PROFILES_EXT_TL set
770: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
771: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
772: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
773: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 805: delete from HZ_ORG_PROFILES_EXT_TL

801:
802: procedure DELETE_ROW (
803: X_EXTENSION_ID IN NUMBER) is
804: begin
805: delete from HZ_ORG_PROFILES_EXT_TL
806: where EXTENSION_ID = X_EXTENSION_ID;
807:
808: if (sql%notfound) then
809: raise no_data_found;

Line 823: insert into /*+ append parallel(tt) */ HZ_ORG_PROFILES_EXT_TL tt (

819:
820: procedure ADD_LANGUAGE
821: is
822: begin
823: insert into /*+ append parallel(tt) */ HZ_ORG_PROFILES_EXT_TL tt (
824: EXTENSION_ID,
825: ORGANIZATION_PROFILE_ID,
826: ATTR_GROUP_ID,
827: CREATED_BY,

Line 918: FROM HZ_ORG_PROFILES_EXT_TL B ,

914: B.TL_EXT_ATTR19,
915: B.TL_EXT_ATTR20,
916: L.LANGUAGE_CODE,
917: B.SOURCE_LANG
918: FROM HZ_ORG_PROFILES_EXT_TL B ,
919: FND_LANGUAGES L
920: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
921: AND B.LANGUAGE = USERENV ( 'LANG' )
922: ) v, HZ_ORG_PROFILES_EXT_TL t

Line 922: ) v, HZ_ORG_PROFILES_EXT_TL t

918: FROM HZ_ORG_PROFILES_EXT_TL B ,
919: FND_LANGUAGES L
920: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
921: AND B.LANGUAGE = USERENV ( 'LANG' )
922: ) v, HZ_ORG_PROFILES_EXT_TL t
923: WHERE t.EXTENSION_ID(+) = v.EXTENSION_ID
924: AND t.language(+) = v.language_code
925: AND t.EXTENSION_ID IS NULL;
926: end ADD_LANGUAGE;