Line 513: p_sched_num := substr(FND_PROFILE.value('WIP_JOB_PREFIX'),1,20)
509: if(p_sched_num is null) then
510:
511: select WIP_JOB_NUMBER_S.nextval into p_sched_num
512: from dual ; 513: p_sched_num := substr(FND_PROFILE.value('WIP_JOB_PREFIX'),1,20) 514: || p_sched_num ;
515:
516: end if ;
517: