APPS.EAM_MATERIALISSUE_PVT dependencies on WIP_JOB_NUMBER_S

Line 593: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/

589: 'inserting rebuild job');
590: end if;
591: if ((p_rebuild_job_name is null) and (l_rebuild_item_id is not null))then
592:
593: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
594: SELECT
595: wip_job_number_s.nextval INTO l_rebuild_job_temp
596: FROM
597: DUAL;

Line 595: wip_job_number_s.nextval INTO l_rebuild_job_temp

591: if ((p_rebuild_job_name is null) and (l_rebuild_item_id is not null))then
592:
593: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
594: SELECT
595: wip_job_number_s.nextval INTO l_rebuild_job_temp
596: FROM
597: DUAL;
598:
599: l_rebuild_job_name:= l_rebuild_job_temp ;

Line 956: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/

952: --this program will produce abug when users will is tarsnacting more than one rebuild-item
953:
954: if (p_rebuild_job_name is null) then
955:
956: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
957: SELECT
958: wip_job_number_s.nextval INTO l_rebuild_job_temp
959: FROM
960: DUAL;

Line 958: wip_job_number_s.nextval INTO l_rebuild_job_temp

954: if (p_rebuild_job_name is null) then
955:
956: /* BUG#2988552 wip_job_number_s sequence is to be used for work order name*/
957: SELECT
958: wip_job_number_s.nextval INTO l_rebuild_job_temp
959: FROM
960: DUAL;
961:
962: l_rebuild_job_name:= l_rebuild_job_temp ;