APPS.AZ_TAXONOMIES_PKG dependencies on AZ_TAXONOMIES_TL

Line 41: insert into AZ_TAXONOMIES_TL (

37: X_LAST_UPDATED_BY,
38: X_LAST_UPDATE_LOGIN
39: );
40:
41: insert into AZ_TAXONOMIES_TL (
42: TAXONOMY_CODE,
43: USER_ID,
44: TAXONOMY_NAME,
45: TAXONOMY_DESC,

Line 69: from AZ_TAXONOMIES_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from AZ_TAXONOMIES_TL T
70: where T.TAXONOMY_CODE = X_TAXONOMY_CODE
71: and T.USER_ID = X_USER_ID
72: and T.LANGUAGE = L.LANGUAGE_CODE) ;
73:

Line 108: update AZ_TAXONOMIES_TL set

104: if (sql%notfound) then
105: raise no_data_found;
106: end if;
107:
108: update AZ_TAXONOMIES_TL set
109: TAXONOMY_NAME = X_TAXONOMY_NAME,
110: TAXONOMY_DESC = X_TAXONOMY_DESC,
111: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
112: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 129: delete from AZ_TAXONOMIES_TL

125: X_TAXONOMY_CODE in VARCHAR2,
126: X_USER_ID in NUMBER
127: ) is
128: begin
129: delete from AZ_TAXONOMIES_TL
130: where TAXONOMY_CODE = X_TAXONOMY_CODE
131: and USER_ID = X_USER_ID;
132:
133: if (sql%notfound) then

Line 149: delete from AZ_TAXONOMIES_TL T

145:
146: procedure ADD_LANGUAGE
147: is
148: begin
149: delete from AZ_TAXONOMIES_TL T
150: where not exists
151: (select NULL
152: from AZ_TAXONOMIES_B B
153: where B.TAXONOMY_CODE = T.TAXONOMY_CODE

Line 157: update AZ_TAXONOMIES_TL T set (

153: where B.TAXONOMY_CODE = T.TAXONOMY_CODE
154: and B.USER_ID = T.USER_ID
155: );
156:
157: update AZ_TAXONOMIES_TL T set (
158: TAXONOMY_NAME,
159: TAXONOMY_DESC
160: ) = (select
161: B.TAXONOMY_NAME,

Line 163: from AZ_TAXONOMIES_TL B

159: TAXONOMY_DESC
160: ) = (select
161: B.TAXONOMY_NAME,
162: B.TAXONOMY_DESC
163: from AZ_TAXONOMIES_TL B
164: where B.TAXONOMY_CODE = T.TAXONOMY_CODE
165: and B.USER_ID = T.USER_ID
166: and B.LANGUAGE = T.SOURCE_LANG)
167: where (

Line 173: from AZ_TAXONOMIES_TL SUBB, AZ_TAXONOMIES_TL SUBT

169: T.LANGUAGE
170: ) in (select
171: SUBT.TAXONOMY_CODE,
172: SUBT.LANGUAGE
173: from AZ_TAXONOMIES_TL SUBB, AZ_TAXONOMIES_TL SUBT
174: where SUBB.TAXONOMY_CODE = SUBT.TAXONOMY_CODE
175: and SUBB.USER_ID = SUBT.USER_ID
176: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
177: and (SUBB.TAXONOMY_NAME <> SUBT.TAXONOMY_NAME

Line 185: insert into AZ_TAXONOMIES_TL (

181: or (SUBB.TAXONOMY_DESC is null and SUBT.TAXONOMY_DESC is not null)
182: or (SUBB.TAXONOMY_DESC is not null and SUBT.TAXONOMY_DESC is null)
183: ));
184:
185: insert into AZ_TAXONOMIES_TL (
186: CREATED_BY,
187: CREATION_DATE,
188: LAST_UPDATED_BY,
189: LAST_UPDATE_DATE,

Line 209: from AZ_TAXONOMIES_TL B, FND_LANGUAGES L

205: B.TAXONOMY_CODE,
206: B.USER_ID,
207: L.LANGUAGE_CODE,
208: B.SOURCE_LANG
209: from AZ_TAXONOMIES_TL B, FND_LANGUAGES L
210: where L.INSTALLED_FLAG in ('I', 'B')
211: and B.LANGUAGE = userenv('LANG')
212: and not exists
213: (select NULL

Line 214: from AZ_TAXONOMIES_TL T

210: where L.INSTALLED_FLAG in ('I', 'B')
211: and B.LANGUAGE = userenv('LANG')
212: and not exists
213: (select NULL
214: from AZ_TAXONOMIES_TL T
215: where T.TAXONOMY_CODE = B.TAXONOMY_CODE
216: and T.USER_ID = B.USER_ID
217: and T.LANGUAGE = L.LANGUAGE_CODE);
218: end ADD_LANGUAGE;

Line 227: update AZ_TAXONOMIES_TL set

223: X_OWNER in VARCHAR2,
224: X_TAXONOMY_NAME in VARCHAR2,
225: X_TAXONOMY_DESC in VARCHAR2 ) is
226: begin
227: update AZ_TAXONOMIES_TL set
228: TAXONOMY_NAME = X_TAXONOMY_NAME,
229: TAXONOMY_DESC = X_TAXONOMY_DESC,
230: last_update_date = sysdate,
231: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),