APPS.ZX_REPORTING_CODES_PKG dependencies on ZX_REPORTING_CODES_TL

Line 70: insert into ZX_REPORTING_CODES_TL (

66: X_PROGRAM_APPLICATION_ID,
67: X_PROGRAM_ID,
68: X_OBJECT_VERSION_NUMBER );
69:
70: insert into ZX_REPORTING_CODES_TL (
71: REPORTING_CODE_ID,
72: REPORTING_CODE_NAME,
73: CREATED_BY,
74: CREATION_DATE,

Line 94: from ZX_REPORTING_CODES_TL T

90: from FND_LANGUAGES L
91: where L.INSTALLED_FLAG in ('I', 'B')
92: and not exists
93: (select NULL
94: from ZX_REPORTING_CODES_TL T
95: where T.REPORTING_CODE_ID = X_REPORTING_CODE_ID
96: and T.LANGUAGE = L.LANGUAGE_CODE);
97:
98: open c;

Line 145: from ZX_REPORTING_CODES_TL

141:
142: cursor c1 is select
143: REPORTING_CODE_NAME,
144: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
145: from ZX_REPORTING_CODES_TL
146: where REPORTING_CODE_ID = X_REPORTING_CODE_ID
147: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
148: for update of REPORTING_CODE_ID nowait;
149: begin

Line 241: update ZX_REPORTING_CODES_TL set

237: if (sql%notfound) then
238: raise no_data_found;
239: end if;
240:
241: update ZX_REPORTING_CODES_TL set
242: REPORTING_CODE_NAME = X_REPORTING_CODE_NAME,
243: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
244: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
245: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 259: delete from ZX_REPORTING_CODES_TL

255: procedure DELETE_ROW (
256: X_REPORTING_CODE_ID in NUMBER
257: ) is
258: begin
259: delete from ZX_REPORTING_CODES_TL
260: where REPORTING_CODE_ID = X_REPORTING_CODE_ID;
261:
262: if (sql%notfound) then
263: raise no_data_found;

Line 277: delete from ZX_REPORTING_CODES_TL T

273:
274: procedure ADD_LANGUAGE
275: is
276: begin
277: delete from ZX_REPORTING_CODES_TL T
278: where not exists
279: (select NULL
280: from ZX_REPORTING_CODES_B B
281: where B.REPORTING_CODE_ID = T.REPORTING_CODE_ID

Line 284: update ZX_REPORTING_CODES_TL T set (

280: from ZX_REPORTING_CODES_B B
281: where B.REPORTING_CODE_ID = T.REPORTING_CODE_ID
282: );
283:
284: update ZX_REPORTING_CODES_TL T set (
285: REPORTING_CODE_NAME
286: ) = (select
287: B.REPORTING_CODE_NAME
288: from ZX_REPORTING_CODES_TL B

Line 288: from ZX_REPORTING_CODES_TL B

284: update ZX_REPORTING_CODES_TL T set (
285: REPORTING_CODE_NAME
286: ) = (select
287: B.REPORTING_CODE_NAME
288: from ZX_REPORTING_CODES_TL B
289: where B.REPORTING_CODE_ID = T.REPORTING_CODE_ID
290: and B.LANGUAGE = T.SOURCE_LANG)
291: where (
292: T.REPORTING_CODE_ID,

Line 297: from ZX_REPORTING_CODES_TL SUBB, ZX_REPORTING_CODES_TL SUBT

293: T.LANGUAGE
294: ) in (select
295: SUBT.REPORTING_CODE_ID,
296: SUBT.LANGUAGE
297: from ZX_REPORTING_CODES_TL SUBB, ZX_REPORTING_CODES_TL SUBT
298: where SUBB.REPORTING_CODE_ID = SUBT.REPORTING_CODE_ID
299: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
300: and (SUBB.REPORTING_CODE_NAME <> SUBT.REPORTING_CODE_NAME
301: or (SUBB.REPORTING_CODE_NAME is null and SUBT.REPORTING_CODE_NAME is not null)

Line 305: insert into ZX_REPORTING_CODES_TL (

301: or (SUBB.REPORTING_CODE_NAME is null and SUBT.REPORTING_CODE_NAME is not null)
302: or (SUBB.REPORTING_CODE_NAME is not null and SUBT.REPORTING_CODE_NAME is null)
303: ));
304:
305: insert into ZX_REPORTING_CODES_TL (
306: REPORTING_CODE_ID,
307: REPORTING_CODE_NAME,
308: CREATED_BY,
309: CREATION_DATE,

Line 325: from ZX_REPORTING_CODES_TL B, FND_LANGUAGES L

321: B.LAST_UPDATE_DATE,
322: B.LAST_UPDATE_LOGIN,
323: L.LANGUAGE_CODE,
324: B.SOURCE_LANG
325: from ZX_REPORTING_CODES_TL B, FND_LANGUAGES L
326: where L.INSTALLED_FLAG in ('I', 'B')
327: and B.LANGUAGE = userenv('LANG')
328: and not exists
329: (select NULL

Line 330: from ZX_REPORTING_CODES_TL T

326: where L.INSTALLED_FLAG in ('I', 'B')
327: and B.LANGUAGE = userenv('LANG')
328: and not exists
329: (select NULL
330: from ZX_REPORTING_CODES_TL T
331: where T.REPORTING_CODE_ID = B.REPORTING_CODE_ID
332: and T.LANGUAGE = L.LANGUAGE_CODE);
333: end ADD_LANGUAGE;
334: