DBA Data[Home] [Help]

APPS.AS_VALIDATE_SETUP dependencies on JTF_TASK_PRIORITIES_VL

Line 494: ( select 1 from JTF_TASK_PRIORITIES_VL

490: SELECT count(*) INTO l_count
491: FROM AS_LOOKUPS aslkp
492: WHERE aslkp.lookup_type = 'TODO_PRIORITY'
493: and not exists
494: ( select 1 from JTF_TASK_PRIORITIES_VL
495: where upper(rtrim(ltrim(aslkp.meaning))) =
496: upper(rtrim(ltrim(name))));
497: EXCEPTION
498: WHEN OTHERS THEN

Line 507: ||'which are not defined in JTF_TASK_PRIORITIES_VL');

503: l_err_total := l_err_total+1;
504: Write_Log(l_module, ' ');
505: Write_Log(l_module, 'Error('||to_char(l_err_total)
506: ||'): Lookup_Type ''TODO_PRIORITY'' has some lookup code(s), '
507: ||'which are not defined in JTF_TASK_PRIORITIES_VL');
508: ELSE
509: Write_Log(l_module, ' ');
510: Write_Log(l_module, 'Success: all lookup codes for ''TODO_PRIORITY'''
511: ||' have been setup in JTF_TASK_PRIORITIES_VL');

Line 511: ||' have been setup in JTF_TASK_PRIORITIES_VL');

507: ||'which are not defined in JTF_TASK_PRIORITIES_VL');
508: ELSE
509: Write_Log(l_module, ' ');
510: Write_Log(l_module, 'Success: all lookup codes for ''TODO_PRIORITY'''
511: ||' have been setup in JTF_TASK_PRIORITIES_VL');
512: END IF;
513:
514: BEGIN
515: SELECT count(*) INTO l_count