APPS.AS_FORECAST_CATEGORIES_PKG dependencies on AS_FORECAST_CATEGORIES_TL

Line 53: INSERT INTO AS_FORECAST_CATEGORIES_TL(

49: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
50: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
51: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE));
52:
53: INSERT INTO AS_FORECAST_CATEGORIES_TL(
54: FORECAST_CATEGORY_ID,
55: CREATED_BY,
56: CREATION_DATE,
57: LAST_UPDATED_BY,

Line 77: from AS_FORECAST_CATEGORIES_TL T

73: from FND_LANGUAGES L
74: where L.INSTALLED_FLAG in ('I', 'B')
75: and not exists
76: (select NULL
77: from AS_FORECAST_CATEGORIES_TL T
78: where T.FORECAST_CATEGORY_ID = px_FORECAST_CATEGORY_ID
79: and T.LANGUAGE = L.LANGUAGE_CODE);
80:
81:

Line 112: Update AS_FORECAST_CATEGORIES_TL

108: If (SQL%NOTFOUND) then
109: RAISE NO_DATA_FOUND;
110: End If;
111:
112: Update AS_FORECAST_CATEGORIES_TL
113: SET
114: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
115: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
116: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 141: DELETE FROM AS_FORECAST_CATEGORIES_TL

137: If (SQL%NOTFOUND) then
138: RAISE NO_DATA_FOUND;
139: End If;
140:
141: DELETE FROM AS_FORECAST_CATEGORIES_TL
142: WHERE FORECAST_CATEGORY_ID = p_FORECAST_CATEGORY_ID;
143:
144: If (SQL%NOTFOUND) then
145: RAISE NO_DATA_FOUND;

Line 174: FROM AS_FORECAST_CATEGORIES_TL

170: CURSOR C1 IS
171: SELECT FORECAST_CATEGORY_NAME,
172: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
173:
174: FROM AS_FORECAST_CATEGORIES_TL
175: WHERE FORECAST_CATEGORY_ID = p_FORECAST_CATEGORY_ID
176: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
177: FOR UPDATE of FORECAST_CATEGORY_ID NOWAIT;
178:

Line 238: delete from AS_FORECAST_CATEGORIES_TL T

234:
235: procedure ADD_LANGUAGE
236: is
237: begin
238: delete from AS_FORECAST_CATEGORIES_TL T
239: where not exists
240: (select NULL
241: from AS_FORECAST_CATEGORIES_B B
242: where B.FORECAST_CATEGORY_ID = T.FORECAST_CATEGORY_ID

Line 245: update AS_FORECAST_CATEGORIES_TL T set (

241: from AS_FORECAST_CATEGORIES_B B
242: where B.FORECAST_CATEGORY_ID = T.FORECAST_CATEGORY_ID
243: );
244:
245: update AS_FORECAST_CATEGORIES_TL T set (
246: FORECAST_CATEGORY_NAME
247: ) = (select
248: FORECAST_CATEGORY_NAME
249: from AS_FORECAST_CATEGORIES_TL B

Line 249: from AS_FORECAST_CATEGORIES_TL B

245: update AS_FORECAST_CATEGORIES_TL T set (
246: FORECAST_CATEGORY_NAME
247: ) = (select
248: FORECAST_CATEGORY_NAME
249: from AS_FORECAST_CATEGORIES_TL B
250: where B.FORECAST_CATEGORY_ID = T.FORECAST_CATEGORY_ID
251: and B.LANGUAGE = T.SOURCE_LANG)
252: where (
253: T.FORECAST_CATEGORY_ID,

Line 258: from AS_FORECAST_CATEGORIES_TL SUBB, AS_FORECAST_CATEGORIES_TL SUBT

254: T.LANGUAGE
255: ) in (select
256: SUBT.FORECAST_CATEGORY_ID,
257: SUBT.LANGUAGE
258: from AS_FORECAST_CATEGORIES_TL SUBB, AS_FORECAST_CATEGORIES_TL SUBT
259: where SUBB.FORECAST_CATEGORY_ID = SUBT.FORECAST_CATEGORY_ID
260: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
261: and ( SUBB.FORECAST_CATEGORY_NAME <> SUBT.FORECAST_CATEGORY_NAME
262: or (SUBB.FORECAST_CATEGORY_NAME is null and SUBT.FORECAST_CATEGORY_NAME is not null)

Line 266: insert into AS_FORECAST_CATEGORIES_TL (

262: or (SUBB.FORECAST_CATEGORY_NAME is null and SUBT.FORECAST_CATEGORY_NAME is not null)
263: or (SUBB.FORECAST_CATEGORY_NAME is not null and SUBT.FORECAST_CATEGORY_NAME is null)
264: ));
265:
266: insert into AS_FORECAST_CATEGORIES_TL (
267: FORECAST_CATEGORY_ID,
268: LAST_UPDATE_DATE,
269: LAST_UPDATED_BY,
270: CREATION_DATE,

Line 286: from AS_FORECAST_CATEGORIES_TL B, FND_LANGUAGES L

282: B.LAST_UPDATE_LOGIN,
283: B.FORECAST_CATEGORY_NAME,
284: L.LANGUAGE_CODE,
285: B.SOURCE_LANG
286: from AS_FORECAST_CATEGORIES_TL B, FND_LANGUAGES L
287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL

Line 291: from AS_FORECAST_CATEGORIES_TL T

287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL
291: from AS_FORECAST_CATEGORIES_TL T
292: where T.FORECAST_CATEGORY_ID = B.FORECAST_CATEGORY_ID
293: and T.LANGUAGE = L.LANGUAGE_CODE);
294: end ADD_LANGUAGE;
295:

Line 376: update AS_FORECAST_CATEGORIES_TL

372: p_OWNER in VARCHAR2)IS
373:
374: begin
375: -- only update rows that have not been altered by user
376: update AS_FORECAST_CATEGORIES_TL
377: set FORECAST_CATEGORY_NAME = p_FORECAST_CATEGORY_NAME,
378: source_lang = userenv('LANG'),
379: last_update_date = sysdate,
380: last_updated_by = decode(p_OWNER, 'SEED', 1, 0),