APPS.OZF_WORKSHEET_HEADERS_PKG dependencies on OZF_WORKSHEET_HEADERS_TL

Line 86: insert into OZF_WORKSHEET_HEADERS_TL (

82: X_LAST_UPDATED_BY,
83: X_LAST_UPDATE_LOGIN
84: );
85:
86: insert into OZF_WORKSHEET_HEADERS_TL (
87: WORKSHEET_HEADER_ID,
88: CREATION_DATE,
89: CREATED_BY,
90: LAST_UPDATE_DATE,

Line 114: from OZF_WORKSHEET_HEADERS_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from OZF_WORKSHEET_HEADERS_TL T
115: where T.WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 179: from OZF_WORKSHEET_HEADERS_TL

175: NAME,
176: DESCRIPTION,
177: VERSION_NO,
178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
179: from OZF_WORKSHEET_HEADERS_TL
180: where WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID
181: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: for update of WORKSHEET_HEADER_ID nowait;
183: begin

Line 303: update OZF_WORKSHEET_HEADERS_TL set

299: if (sql%notfound) then
300: raise no_data_found;
301: end if;
302:
303: update OZF_WORKSHEET_HEADERS_TL set
304: NAME = X_NAME,
305: DESCRIPTION = X_DESCRIPTION,
306: VERSION_NO = X_VERSION_NO,
307: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 323: delete from OZF_WORKSHEET_HEADERS_TL

319: procedure DELETE_ROW (
320: X_WORKSHEET_HEADER_ID in NUMBER
321: ) is
322: begin
323: delete from OZF_WORKSHEET_HEADERS_TL
324: where WORKSHEET_HEADER_ID = X_WORKSHEET_HEADER_ID;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 341: delete from OZF_WORKSHEET_HEADERS_TL T

337:
338: procedure ADD_LANGUAGE
339: is
340: begin
341: delete from OZF_WORKSHEET_HEADERS_TL T
342: where not exists
343: (select NULL
344: from OZF_WORKSHEET_HEADERS_B B
345: where B.WORKSHEET_HEADER_ID = T.WORKSHEET_HEADER_ID

Line 348: update OZF_WORKSHEET_HEADERS_TL T set (

344: from OZF_WORKSHEET_HEADERS_B B
345: where B.WORKSHEET_HEADER_ID = T.WORKSHEET_HEADER_ID
346: );
347:
348: update OZF_WORKSHEET_HEADERS_TL T set (
349: NAME,
350: DESCRIPTION,
351: VERSION_NO
352: ) = (select

Line 356: from OZF_WORKSHEET_HEADERS_TL B

352: ) = (select
353: B.NAME,
354: B.DESCRIPTION,
355: B.VERSION_NO
356: from OZF_WORKSHEET_HEADERS_TL B
357: where B.WORKSHEET_HEADER_ID = T.WORKSHEET_HEADER_ID
358: and B.LANGUAGE = T.SOURCE_LANG)
359: where (
360: T.WORKSHEET_HEADER_ID,

Line 365: from OZF_WORKSHEET_HEADERS_TL SUBB, OZF_WORKSHEET_HEADERS_TL SUBT

361: T.LANGUAGE
362: ) in (select
363: SUBT.WORKSHEET_HEADER_ID,
364: SUBT.LANGUAGE
365: from OZF_WORKSHEET_HEADERS_TL SUBB, OZF_WORKSHEET_HEADERS_TL SUBT
366: where SUBB.WORKSHEET_HEADER_ID = SUBT.WORKSHEET_HEADER_ID
367: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
368: and (SUBB.NAME <> SUBT.NAME
369: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 377: insert into OZF_WORKSHEET_HEADERS_TL (

373: or (SUBB.VERSION_NO is null and SUBT.VERSION_NO is not null)
374: or (SUBB.VERSION_NO is not null and SUBT.VERSION_NO is null)
375: ));
376:
377: insert into OZF_WORKSHEET_HEADERS_TL (
378: WORKSHEET_HEADER_ID,
379: CREATION_DATE,
380: CREATED_BY,
381: LAST_UPDATE_DATE,

Line 401: from OZF_WORKSHEET_HEADERS_TL B, FND_LANGUAGES L

397: B.DESCRIPTION,
398: B.VERSION_NO,
399: L.LANGUAGE_CODE,
400: B.SOURCE_LANG
401: from OZF_WORKSHEET_HEADERS_TL B, FND_LANGUAGES L
402: where L.INSTALLED_FLAG in ('I', 'B')
403: and B.LANGUAGE = userenv('LANG')
404: and not exists
405: (select NULL

Line 406: from OZF_WORKSHEET_HEADERS_TL T

402: where L.INSTALLED_FLAG in ('I', 'B')
403: and B.LANGUAGE = userenv('LANG')
404: and not exists
405: (select NULL
406: from OZF_WORKSHEET_HEADERS_TL T
407: where T.WORKSHEET_HEADER_ID = B.WORKSHEET_HEADER_ID
408: and T.LANGUAGE = L.LANGUAGE_CODE);
409: end ADD_LANGUAGE;
410: