380: 'inserting rebuild job');
381: end if;
382: if ((p_rebuild_job_name is null) and (l_rebuild_item_id is not null))then
383:
384: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
385: SELECT
386: wip_job_number_s.nextval INTO l_rebuild_job_temp
387: FROM
388: DUAL;
382: if ((p_rebuild_job_name is null) and (l_rebuild_item_id is not null))then
383:
384: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
385: SELECT
386: wip_job_number_s.nextval INTO l_rebuild_job_temp
387: FROM
388: DUAL;
389:
390: l_rebuild_job_name:= l_rebuild_job_temp ;
725: --this program will produce abug when users will is tarsnacting more than one rebuild-item
726:
727: if (p_rebuild_job_name is null) then
728:
729: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
730: SELECT
731: wip_job_number_s.nextval INTO l_rebuild_job_temp
732: FROM
733: DUAL;
727: if (p_rebuild_job_name is null) then
728:
729: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
730: SELECT
731: wip_job_number_s.nextval INTO l_rebuild_job_temp
732: FROM
733: DUAL;
734:
735: l_rebuild_job_name:= l_rebuild_job_temp ;