APPS.AMW_EVALUATIONS_PKG dependencies on AMW_EVALUATIONS_TL

Line 106: insert into AMW_EVALUATIONS_TL (

102: p_EVALUATION_SET_STATUS_CODE
103: )returning EVALUATION_ID into l_evaluation_id;
104:
105:
106: insert into AMW_EVALUATIONS_TL (
107: EVALUATION_ID,
108: COMMENTS,
109: LANGUAGE,
110: SOURCE_LANG,

Line 132: from AMW_EVALUATIONS_TL T

128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from AMW_EVALUATIONS_TL T
133: where T.EVALUATION_ID = l_evaluation_id
134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
136:

Line 248: update AMW_EVALUATIONS_TL set

244: EVALUATION_SET_STATUS_CODE = p_EVALUATION_SET_STATUS_CODE
245: where EVALUATION_ID = p_EVALUATION_ID;
246:
247:
248: update AMW_EVALUATIONS_TL set
249: COMMENTS = p_comments,
250: LAST_UPDATE_DATE = sysdate,
251: LAST_UPDATED_BY = G_USER_ID,
252: CREATION_DATE = sysdate,

Line 452: delete from AMW_EVALUATIONS_TL T

448:
449: procedure ADD_LANGUAGE
450: is
451: begin
452: delete from AMW_EVALUATIONS_TL T
453: where not exists
454: (select NULL
455: from AMW_EVALUATIONS_B B
456: where B.EVALUATION_ID = T.EVALUATION_ID

Line 459: update AMW_EVALUATIONS_TL T set (

455: from AMW_EVALUATIONS_B B
456: where B.EVALUATION_ID = T.EVALUATION_ID
457: );
458:
459: update AMW_EVALUATIONS_TL T set (
460: COMMENTS
461: ) = (select
462: B.COMMENTS
463: from AMW_EVALUATIONS_TL B

Line 463: from AMW_EVALUATIONS_TL B

459: update AMW_EVALUATIONS_TL T set (
460: COMMENTS
461: ) = (select
462: B.COMMENTS
463: from AMW_EVALUATIONS_TL B
464: where B.EVALUATION_ID = T.EVALUATION_ID
465: and B.LANGUAGE = T.SOURCE_LANG)
466: where (
467: T.EVALUATION_ID,

Line 472: from AMW_EVALUATIONS_TL SUBB, AMW_EVALUATIONS_TL SUBT

468: T.LANGUAGE
469: ) in (select
470: SUBT.EVALUATION_ID,
471: SUBT.LANGUAGE
472: from AMW_EVALUATIONS_TL SUBB, AMW_EVALUATIONS_TL SUBT
473: where SUBB.EVALUATION_ID = SUBT.EVALUATION_ID
474: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
475: and (SUBB.COMMENTS <> SUBT.COMMENTS
476: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)

Line 480: insert into AMW_EVALUATIONS_TL (

476: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
477: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
478: ));
479:
480: insert into AMW_EVALUATIONS_TL (
481: EVALUATION_ID,
482: COMMENTS,
483: LAST_UPDATE_DATE,
484: LAST_UPDATED_BY,

Line 504: from AMW_EVALUATIONS_TL B, FND_LANGUAGES L

500: B.SECURITY_GROUP_ID,
501: B.OBJECT_VERSION_NUMBER,
502: L.LANGUAGE_CODE,
503: B.SOURCE_LANG
504: from AMW_EVALUATIONS_TL B, FND_LANGUAGES L
505: where L.INSTALLED_FLAG in ('I', 'B')
506: and B.LANGUAGE = userenv('LANG')
507: and not exists
508: (select NULL

Line 509: from AMW_EVALUATIONS_TL T

505: where L.INSTALLED_FLAG in ('I', 'B')
506: and B.LANGUAGE = userenv('LANG')
507: and not exists
508: (select NULL
509: from AMW_EVALUATIONS_TL T
510: where T.EVALUATION_ID = B.EVALUATION_ID
511: and T.LANGUAGE = L.LANGUAGE_CODE);
512: end ADD_LANGUAGE;
513: