APPS.HZ_PARTY_SITES_EXT_PKG dependencies on HZ_PARTY_SITES_EXT_TL

Line 209: insert into HZ_PARTY_SITES_EXT_TL (

205: X_LAST_UPDATED_BY,
206: X_LAST_UPDATE_LOGIN
207: );
208:
209: insert into HZ_PARTY_SITES_EXT_TL (
210: TL_EXT_ATTR2,
211: TL_EXT_ATTR3,
212: TL_EXT_ATTR4,
213: TL_EXT_ATTR5,

Line 275: from HZ_PARTY_SITES_EXT_TL T

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

Line 444: from HZ_PARTY_SITES_EXT_TL

440: TL_EXT_ATTR18,
441: TL_EXT_ATTR19,
442: TL_EXT_ATTR20,
443: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
444: from HZ_PARTY_SITES_EXT_TL
445: where EXTENSION_ID = X_EXTENSION_ID
446: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
447: for update of EXTENSION_ID nowait;
448: begin

Line 760: update HZ_PARTY_SITES_EXT_TL set

756: if (sql%notfound) then
757: raise no_data_found;
758: end if;
759:
760: update HZ_PARTY_SITES_EXT_TL set
761: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
762: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
763: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
764: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 796: delete from HZ_PARTY_SITES_EXT_TL

792:
793: procedure DELETE_ROW (
794: X_EXTENSION_ID IN NUMBER) is
795: begin
796: delete from HZ_PARTY_SITES_EXT_TL
797: where EXTENSION_ID = X_EXTENSION_ID;
798:
799: if (sql%notfound) then
800: raise no_data_found;

Line 814: insert into /*+ append parallel(tt) */ HZ_PARTY_SITES_EXT_TL tt (

810:
811: procedure ADD_LANGUAGE
812: is
813: begin
814: insert into /*+ append parallel(tt) */ HZ_PARTY_SITES_EXT_TL tt (
815: TL_EXT_ATTR2,
816: TL_EXT_ATTR3,
817: TL_EXT_ATTR4,
818: TL_EXT_ATTR5,

Line 909: FROM HZ_PARTY_SITES_EXT_TL B ,

905: B.LAST_UPDATE_LOGIN,
906: B.TL_EXT_ATTR1,
907: L.LANGUAGE_CODE,
908: B.SOURCE_LANG
909: FROM HZ_PARTY_SITES_EXT_TL B ,
910: FND_LANGUAGES L
911: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
912: AND B.LANGUAGE = USERENV ( 'LANG' )
913: ) v, HZ_PARTY_SITES_EXT_TL t

Line 913: ) v, HZ_PARTY_SITES_EXT_TL t

909: FROM HZ_PARTY_SITES_EXT_TL B ,
910: FND_LANGUAGES L
911: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
912: AND B.LANGUAGE = USERENV ( 'LANG' )
913: ) v, HZ_PARTY_SITES_EXT_TL t
914: WHERE t.EXTENSION_ID(+) = v.EXTENSION_ID
915: AND t.language(+) = v.language_code
916: AND t.EXTENSION_ID IS NULL;
917: end ADD_LANGUAGE;