APPS.WIP_JSI_DEFAULTER dependencies on WIP_JOB_NUMBER_S

Line 283: select WORK_ORDER_PREFIX || wip_job_number_s.nextval

279: --when creating a job, if name isn't provided, create one
280: elsif(wjsi_row.job_name is null) then
281: /* Fix for Bug#2994658 */
282: if (wjsi_row.load_type = wip_constants.create_eam_job) then
283: select WORK_ORDER_PREFIX || wip_job_number_s.nextval
284: into wjsi_row.job_name
285: from wip_eam_parameters
286: where organization_id = wjsi_row.organization_id ;
287: else

Line 288: select fnd_profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval

284: into wjsi_row.job_name
285: from wip_eam_parameters
286: where organization_id = wjsi_row.organization_id ;
287: else
288: select fnd_profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval
289: into wjsi_row.job_name
290: from dual;
291: end if ;
292: end if;