DBA Data[Home] [Help]

APPS.WIP_FLOW_DERIVE dependencies on WIP_JOB_NUMBER_S

Line 511: select WIP_JOB_NUMBER_S.nextval into p_sched_num

507: begin
508:
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: