Line 504: p_sched_num := substr(FND_PROFILE.value('WIP_JOB_PREFIX'),1,20)
500: if(p_sched_num is null) then
501:
502: select WIP_JOB_NUMBER_S.nextval into p_sched_num
503: from dual ; 504: p_sched_num := substr(FND_PROFILE.value('WIP_JOB_PREFIX'),1,20) 505: || p_sched_num ;
506:
507: end if ;
508: