APPS.CSI_CTR_ESTIMATE_METHODS_PKG dependencies on CSI_CTR_ESTIMATION_METHODS_TL

Line 120: INSERT INTO CSI_CTR_ESTIMATION_METHODS_TL(

116: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
117: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
118: );
119:
120: INSERT INTO CSI_CTR_ESTIMATION_METHODS_TL(
121: ESTIMATION_ID
122: ,NAME
123: ,DESCRIPTION
124: ,LANGUAGE

Line 148: FROM CSI_CTR_ESTIMATION_METHODS_TL cct

144: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
145: FROM fnd_languages L
146: WHERE L.installed_flag IN ('I','B')
147: AND NOT EXISTS (SELECT 'x'
148: FROM CSI_CTR_ESTIMATION_METHODS_TL cct
149: WHERE cct.ESTIMATION_ID = px_ESTIMATION_ID
150: AND cct.LANGUAGE = L.LANGUAGE_CODE);
151: END Insert_Row;
152:

Line 223: UPDATE CSI_CTR_ESTIMATION_METHODS_TL

219: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
220: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
221: WHERE ESTIMATION_ID = p_ESTIMATION_ID;
222:
223: UPDATE CSI_CTR_ESTIMATION_METHODS_TL
224: SET
225: NAME = decode (p_NAME, NULL, NAME, FND_API.G_MISS_CHAR, NULL, p_NAME)
226: ,DESCRIPTION = decode (p_DESCRIPTION, NULL, DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
227: ,SOURCE_LANG = userenv('LANG')

Line 289: FROM CSI_CTR_ESTIMATION_METHODS_TL

285: CURSOR C2 IS
286: SELECT name,
287: description,
288: decode(language, userenv('LANG'), 'Y', 'N') baselang
289: FROM CSI_CTR_ESTIMATION_METHODS_TL
290: WHERE ESTIMATION_ID = p_ESTIMATION_ID
291: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG)
292: FOR UPDATE of ESTIMATION_ID NOWAIT;
293: BEGIN

Line 339: DELETE FROM CSI_CTR_ESTIMATION_METHODS_TL t

335: END Delete_Row;
336:
337: PROCEDURE add_language IS
338: BEGIN
339: DELETE FROM CSI_CTR_ESTIMATION_METHODS_TL t
340: WHERE NOT EXISTS (SELECT NULL
341: FROM CSI_CTR_ESTIMATION_METHODS_B b
342: WHERE b.ESTIMATION_ID = t.ESTIMATION_ID);
343:

Line 344: UPDATE CSI_CTR_ESTIMATION_METHODS_TL t

340: WHERE NOT EXISTS (SELECT NULL
341: FROM CSI_CTR_ESTIMATION_METHODS_B b
342: WHERE b.ESTIMATION_ID = t.ESTIMATION_ID);
343:
344: UPDATE CSI_CTR_ESTIMATION_METHODS_TL t
345: SET (name, description) = (SELECT b.name,
346: b.description
347: FROM CSI_CTR_ESTIMATION_METHODS_TL b
348: WHERE b.ESTIMATION_ID = t.ESTIMATION_ID

Line 347: FROM CSI_CTR_ESTIMATION_METHODS_TL b

343:
344: UPDATE CSI_CTR_ESTIMATION_METHODS_TL t
345: SET (name, description) = (SELECT b.name,
346: b.description
347: FROM CSI_CTR_ESTIMATION_METHODS_TL b
348: WHERE b.ESTIMATION_ID = t.ESTIMATION_ID
349: AND b.language = t.source_lang)
350: WHERE (t.ESTIMATION_ID, t.language)
351: IN (SELECT subt.ESTIMATION_ID,

Line 353: FROM CSI_CTR_ESTIMATION_METHODS_TL subb, CSI_CTR_ESTIMATION_METHODS_TL subt

349: AND b.language = t.source_lang)
350: WHERE (t.ESTIMATION_ID, t.language)
351: IN (SELECT subt.ESTIMATION_ID,
352: subt.LANGUAGE
353: FROM CSI_CTR_ESTIMATION_METHODS_TL subb, CSI_CTR_ESTIMATION_METHODS_TL subt
354: WHERE subb.ESTIMATION_ID = subt.ESTIMATION_ID
355: AND subb.language = subt.source_lang
356: AND (subb.name <> subt.name
357: OR subb.description <> subt.description

Line 363: INSERT INTO CSI_CTR_ESTIMATION_METHODS_TL(

359: OR (subb.description IS NOT NULL AND subt.description IS NULL)
360: )
361: );
362:
363: INSERT INTO CSI_CTR_ESTIMATION_METHODS_TL(
364: ESTIMATION_ID
365: ,NAME
366: ,DESCRIPTION
367: ,LANGUAGE

Line 385: FROM CSI_CTR_ESTIMATION_METHODS_TL b, FND_LANGUAGES l

381: b.CREATION_DATE,
382: b.LAST_UPDATED_BY,
383: b.LAST_UPDATE_DATE,
384: b.LAST_UPDATE_LOGIN
385: FROM CSI_CTR_ESTIMATION_METHODS_TL b, FND_LANGUAGES l
386: WHERE l.installed_flag IN ('I', 'B')
387: AND b.language = userenv('LANG')
388: AND NOT EXISTS (SELECT NULL
389: FROM CSI_CTR_ESTIMATION_METHODS_TL t

Line 389: FROM CSI_CTR_ESTIMATION_METHODS_TL t

385: FROM CSI_CTR_ESTIMATION_METHODS_TL b, FND_LANGUAGES l
386: WHERE l.installed_flag IN ('I', 'B')
387: AND b.language = userenv('LANG')
388: AND NOT EXISTS (SELECT NULL
389: FROM CSI_CTR_ESTIMATION_METHODS_TL t
390: WHERE t.ESTIMATION_ID = b.ESTIMATION_ID
391: AND t.language = l.language_code);
392: END add_language;
393:

Line 401: UPDATE CSI_CTR_ESTIMATION_METHODS_TL

397: ,p_description VARCHAR2
398: ,p_owner VARCHAR2
399: ) IS
400: BEGIN
401: UPDATE CSI_CTR_ESTIMATION_METHODS_TL
402: SET name = p_name,
403: description = p_description,
404: last_update_date = sysdate,
405: last_updated_by = decode(p_owner, 'SEED', 1, 0),