APPS.AZ_STRUCTURE_APIS_PKG dependencies on AZ_STRUCTURE_APIS_TL

Line 49: insert into AZ_STRUCTURE_APIS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into AZ_STRUCTURE_APIS_TL (
50: LAST_UPDATED_BY,
51: LAST_UPDATE_DATE,
52: LAST_UPDATE_LOGIN,
53: CREATED_BY,

Line 75: from AZ_STRUCTURE_APIS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from AZ_STRUCTURE_APIS_TL T
76: where T.STRUCTURE_CODE = X_STRUCTURE_CODE
77: and T.ENTITY_CODE = X_ENTITY_CODE
78: and T.LANGUAGE = L.LANGUAGE_CODE);
79:

Line 113: from AZ_STRUCTURE_APIS_TL

109:
110: cursor c1 is select
111: ENTITY_NAME,
112: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
113: from AZ_STRUCTURE_APIS_TL
114: where STRUCTURE_CODE = X_STRUCTURE_CODE
115: and ENTITY_CODE = X_ENTITY_CODE
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of STRUCTURE_CODE nowait;

Line 183: update AZ_STRUCTURE_APIS_TL set

179: if (sql%notfound) then
180: raise no_data_found;
181: end if;
182:
183: update AZ_STRUCTURE_APIS_TL set
184: ENTITY_NAME = X_ENTITY_NAME,
185: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
186: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
187: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 203: delete from AZ_STRUCTURE_APIS_TL

199: X_STRUCTURE_CODE in VARCHAR2,
200: X_ENTITY_CODE in VARCHAR2
201: ) is
202: begin
203: delete from AZ_STRUCTURE_APIS_TL
204: where STRUCTURE_CODE = X_STRUCTURE_CODE
205: and ENTITY_CODE = X_ENTITY_CODE;
206:
207: if (sql%notfound) then

Line 223: delete from AZ_STRUCTURE_APIS_TL T

219:
220: procedure ADD_LANGUAGE
221: is
222: begin
223: delete from AZ_STRUCTURE_APIS_TL T
224: where not exists
225: (select NULL
226: from AZ_STRUCTURE_APIS_B B
227: where B.STRUCTURE_CODE = T.STRUCTURE_CODE

Line 231: update AZ_STRUCTURE_APIS_TL T set (

227: where B.STRUCTURE_CODE = T.STRUCTURE_CODE
228: and B.ENTITY_CODE = T.ENTITY_CODE
229: );
230:
231: update AZ_STRUCTURE_APIS_TL T set (
232: ENTITY_NAME
233: ) = (select
234: B.ENTITY_NAME
235: from AZ_STRUCTURE_APIS_TL B

Line 235: from AZ_STRUCTURE_APIS_TL B

231: update AZ_STRUCTURE_APIS_TL T set (
232: ENTITY_NAME
233: ) = (select
234: B.ENTITY_NAME
235: from AZ_STRUCTURE_APIS_TL B
236: where B.STRUCTURE_CODE = T.STRUCTURE_CODE
237: and B.ENTITY_CODE = T.ENTITY_CODE
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (

Line 247: from AZ_STRUCTURE_APIS_TL SUBB, AZ_STRUCTURE_APIS_TL SUBT

243: ) in (select
244: SUBT.STRUCTURE_CODE,
245: SUBT.ENTITY_CODE,
246: SUBT.LANGUAGE
247: from AZ_STRUCTURE_APIS_TL SUBB, AZ_STRUCTURE_APIS_TL SUBT
248: where SUBB.STRUCTURE_CODE = SUBT.STRUCTURE_CODE
249: and SUBB.ENTITY_CODE = SUBT.ENTITY_CODE
250: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
251: and (SUBB.ENTITY_NAME <> SUBT.ENTITY_NAME

Line 254: insert into AZ_STRUCTURE_APIS_TL (

250: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
251: and (SUBB.ENTITY_NAME <> SUBT.ENTITY_NAME
252: ));
253:
254: insert into AZ_STRUCTURE_APIS_TL (
255: LAST_UPDATED_BY,
256: LAST_UPDATE_DATE,
257: LAST_UPDATE_LOGIN,
258: CREATED_BY,

Line 276: from AZ_STRUCTURE_APIS_TL B, FND_LANGUAGES L

272: B.ENTITY_CODE,
273: B.STRUCTURE_CODE,
274: L.LANGUAGE_CODE,
275: B.SOURCE_LANG
276: from AZ_STRUCTURE_APIS_TL B, FND_LANGUAGES L
277: where L.INSTALLED_FLAG in ('I', 'B')
278: and B.LANGUAGE = userenv('LANG')
279: and not exists
280: (select NULL

Line 281: from AZ_STRUCTURE_APIS_TL T

277: where L.INSTALLED_FLAG in ('I', 'B')
278: and B.LANGUAGE = userenv('LANG')
279: and not exists
280: (select NULL
281: from AZ_STRUCTURE_APIS_TL T
282: where T.STRUCTURE_CODE = B.STRUCTURE_CODE
283: and T.ENTITY_CODE = B.ENTITY_CODE
284: and T.LANGUAGE = L.LANGUAGE_CODE);
285: end ADD_LANGUAGE;

Line 294: update AZ_STRUCTURE_APIS_TL set

290: X_ENTITY_NAME in VARCHAR2,
291: X_OWNER in VARCHAR2
292: ) IS
293: begin
294: update AZ_STRUCTURE_APIS_TL set
295: ENTITY_NAME = X_ENTITY_NAME,
296: last_update_date = sysdate,
297: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
298: last_update_login = 0,