APPS.HZ_CREDIT_RATINGS_EXT_PKG dependencies on HZ_CREDIT_RATINGS_EXT_TL

Line 209: insert into HZ_CREDIT_RATINGS_EXT_TL (

205: X_LAST_UPDATED_BY,
206: X_LAST_UPDATE_LOGIN
207: );
208:
209: insert into HZ_CREDIT_RATINGS_EXT_TL (
210: CREATED_BY,
211: CREATION_DATE,
212: LAST_UPDATED_BY,
213: LAST_UPDATE_DATE,

Line 275: from HZ_CREDIT_RATINGS_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_CREDIT_RATINGS_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_CREDIT_RATINGS_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_CREDIT_RATINGS_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_CREDIT_RATINGS_EXT_TL set

756: if (sql%notfound) then
757: raise no_data_found;
758: end if;
759:
760: update HZ_CREDIT_RATINGS_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_CREDIT_RATINGS_EXT_TL

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

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

810:
811: procedure ADD_LANGUAGE
812: is
813: begin
814: insert /*+ append parallel(tt) */ into HZ_CREDIT_RATINGS_EXT_TL tt (
815: CREATED_BY,
816: CREATION_DATE,
817: LAST_UPDATED_BY,
818: LAST_UPDATE_DATE,

Line 909: FROM HZ_CREDIT_RATINGS_EXT_TL B ,

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

Line 913: ) v, HZ_CREDIT_RATINGS_EXT_TL t

909: FROM HZ_CREDIT_RATINGS_EXT_TL B ,
910: FND_LANGUAGES L
911: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
912: AND B.LANGUAGE = USERENV ( 'LANG' )
913: ) v, HZ_CREDIT_RATINGS_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;