DBA Data[Home] [Help]

APPS.AMW_EVALUATIONS_PKG dependencies on AMW_EVALUATIONS_B

Line 61: insert into amw_evaluations_b (

57: /*****************************************************************************/
58: /********************************CODE FOR CREATE******************************/
59: /*****************************************************************************/
60:
61: insert into amw_evaluations_b (
62: EVALUATION_ID,
63: EVALUATION_SET_ID,
64: EVALUATION_OBJECT_NAME,
65: EVALUATION_CONTEXT,

Line 230: update amw_evaluations_b set

226: /*****************************************************************************/
227: /********************************CODE FOR UPDATE******************************/
228: /*****************************************************************************/
229:
230: update amw_evaluations_b set
231: -- DATE_EVALUATED = to_date(p_DATE_EVALUATED, 'DD-MON-YYYY HH24:MI:SS'),
232: -- DATE_EVALUATED = to_date(p_DATE_EVALUATED),
233: -- 12.31.2003 tsho: for bug 3326347, don't convert varchar2 to date
234: -- DATE_EVALUATED = to_date(p_DATE_EVALUATED,'DD/MM/YYYY'),

Line 455: from AMW_EVALUATIONS_B B

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
457: );
458:
459: update AMW_EVALUATIONS_TL T set (