APPS.AZ_STRUCTURES_PKG dependencies on AZ_STRUCTURES_TL

Line 40: insert into AZ_STRUCTURES_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into AZ_STRUCTURES_TL (
41: CREATED_BY,
42: CREATION_DATE,
43: LAST_UPDATED_BY,
44: LAST_UPDATE_DATE,

Line 66: from AZ_STRUCTURES_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from AZ_STRUCTURES_TL T
67: where T.STRUCTURE_CODE = X_STRUCTURE_CODE
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 97: from AZ_STRUCTURES_TL

93: cursor c1 is select
94: STRUCTURE_NAME,
95: STRUCTURE_DESC,
96: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
97: from AZ_STRUCTURES_TL
98: where STRUCTURE_CODE = X_STRUCTURE_CODE
99: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
100: for update of STRUCTURE_CODE nowait;
101: begin

Line 158: update AZ_STRUCTURES_TL set

154: if (sql%notfound) then
155: raise no_data_found;
156: end if;
157:
158: update AZ_STRUCTURES_TL set
159: STRUCTURE_NAME = X_STRUCTURE_NAME,
160: STRUCTURE_DESC = X_STRUCTURE_DESC,
161: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
162: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 177: delete from AZ_STRUCTURES_TL

173: procedure DELETE_ROW (
174: X_STRUCTURE_CODE in VARCHAR2
175: ) is
176: begin
177: delete from AZ_STRUCTURES_TL
178: where STRUCTURE_CODE = X_STRUCTURE_CODE;
179:
180: if (sql%notfound) then
181: raise no_data_found;

Line 195: delete from AZ_STRUCTURES_TL T

191:
192: procedure ADD_LANGUAGE
193: is
194: begin
195: delete from AZ_STRUCTURES_TL T
196: where not exists
197: (select NULL
198: from AZ_STRUCTURES_B B
199: where B.STRUCTURE_CODE = T.STRUCTURE_CODE

Line 202: update AZ_STRUCTURES_TL T set (

198: from AZ_STRUCTURES_B B
199: where B.STRUCTURE_CODE = T.STRUCTURE_CODE
200: );
201:
202: update AZ_STRUCTURES_TL T set (
203: STRUCTURE_NAME,
204: STRUCTURE_DESC
205: ) = (select
206: B.STRUCTURE_NAME,

Line 208: from AZ_STRUCTURES_TL B

204: STRUCTURE_DESC
205: ) = (select
206: B.STRUCTURE_NAME,
207: B.STRUCTURE_DESC
208: from AZ_STRUCTURES_TL B
209: where B.STRUCTURE_CODE = T.STRUCTURE_CODE
210: and B.LANGUAGE = T.SOURCE_LANG)
211: where (
212: T.STRUCTURE_CODE,

Line 217: from AZ_STRUCTURES_TL SUBB, AZ_STRUCTURES_TL SUBT

213: T.LANGUAGE
214: ) in (select
215: SUBT.STRUCTURE_CODE,
216: SUBT.LANGUAGE
217: from AZ_STRUCTURES_TL SUBB, AZ_STRUCTURES_TL SUBT
218: where SUBB.STRUCTURE_CODE = SUBT.STRUCTURE_CODE
219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.STRUCTURE_NAME <> SUBT.STRUCTURE_NAME
221: or (SUBB.STRUCTURE_NAME is null and SUBT.STRUCTURE_NAME is not null)

Line 228: insert into AZ_STRUCTURES_TL (

224: or (SUBB.STRUCTURE_DESC is null and SUBT.STRUCTURE_DESC is not null)
225: or (SUBB.STRUCTURE_DESC is not null and SUBT.STRUCTURE_DESC is null)
226: ));
227:
228: insert into AZ_STRUCTURES_TL (
229: CREATED_BY,
230: CREATION_DATE,
231: LAST_UPDATED_BY,
232: LAST_UPDATE_DATE,

Line 250: from AZ_STRUCTURES_TL B, FND_LANGUAGES L

246: B.STRUCTURE_CODE,
247: B.STRUCTURE_NAME,
248: L.LANGUAGE_CODE,
249: B.SOURCE_LANG
250: from AZ_STRUCTURES_TL B, FND_LANGUAGES L
251: where L.INSTALLED_FLAG in ('I', 'B')
252: and B.LANGUAGE = userenv('LANG')
253: and not exists
254: (select NULL

Line 255: from AZ_STRUCTURES_TL T

251: where L.INSTALLED_FLAG in ('I', 'B')
252: and B.LANGUAGE = userenv('LANG')
253: and not exists
254: (select NULL
255: from AZ_STRUCTURES_TL T
256: where T.STRUCTURE_CODE = B.STRUCTURE_CODE
257: and T.LANGUAGE = L.LANGUAGE_CODE);
258: end ADD_LANGUAGE;
259:

Line 266: update AZ_STRUCTURES_TL set

262: X_STRUCTURE_NAME in VARCHAR2,
263: X_OWNER in VARCHAR2,
264: X_STRUCTURE_DESC in VARCHAR2 ) is
265: begin
266: update AZ_STRUCTURES_TL set
267: STRUCTURE_NAME = X_STRUCTURE_NAME,
268: STRUCTURE_DESC = X_STRUCTURE_DESC,
269: last_update_date = sysdate,
270: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),