APPS.AS_VALIDATE_SETUP dependencies on JTF_TASK_TYPES_VL

Line 469: ( select 1 from JTF_TASK_TYPES_VL

465: SELECT count(*) INTO l_count
466: FROM AS_LOOKUPS aslkp
467: WHERE aslkp.lookup_type = 'TODO'
468: and not exists
469: ( select 1 from JTF_TASK_TYPES_VL
470: where upper(rtrim(ltrim(aslkp.meaning))) =
471: upper(rtrim(ltrim(name))));
472: EXCEPTION
473: WHEN OTHERS THEN

Line 482: ||' defined in JTF_TASK_TYPES_VL');

478: l_err_total := l_err_total+1;
479: Write_Log(l_module, ' ');
480: Write_Log(l_module, 'Error('||to_char(l_err_total)
481: ||'): Lookup_Type ''TODO'' has some lookup code(s), which are not'
482: ||' defined in JTF_TASK_TYPES_VL');
483: ELSE
484: Write_Log(l_module, ' ');
485: Write_Log(l_module, 'Success: all lookup codes for ''TODO'''
486: ||' have been setup in JTF_TASK_TYPES_VL');

Line 486: ||' have been setup in JTF_TASK_TYPES_VL');

482: ||' defined in JTF_TASK_TYPES_VL');
483: ELSE
484: Write_Log(l_module, ' ');
485: Write_Log(l_module, 'Success: all lookup codes for ''TODO'''
486: ||' have been setup in JTF_TASK_TYPES_VL');
487: END IF;
488:
489: BEGIN
490: SELECT count(*) INTO l_count