[Home] [Help]
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;
293: exception
294: when others then
311: wip_jsi_utils.record_ignored_column_warning('WIP_ENTITY_ID');
312: end if;
313: select wip_entities_s.nextval
314: into wjsi_row.wip_entity_id
315: from dual;
316: else --do minimal validation of wip_entity_id so future defaulting doesn't error
317: select 1
318: into l_dummy
319: from wip_entities
378: when no_data_found then
379: --having problems using dml returning...
380: select wip_schedule_groups_s.nextval
381: into wjsi_row.schedule_group_id
382: from dual;
383:
384: insert into wip_schedule_groups (
385: schedule_group_id,
386: schedule_group_name,
437: -- fix MOAC, set id so project view works
438: fnd_profile.put('MFG_ORGANIZATION_ID',wjsi_row.organization_id);
439: select pjm_project.val_proj_numtoid(wjsi_row.project_number, wjsi_row.organization_id)
440: into wjsi_row.project_id
441: from dual;
442: elsif(wjsi_row.load_type not in (wip_constants.resched_job, wip_constants.resched_eam_job) and
443: wjsi_row.task_number is not null
444: and wjsi_row.task_id is not null) then
445: raise fnd_api.g_exc_unexpected_error;
552: if(wjsi_row.load_type = wip_constants.create_sched) then
553: if(wjsi_row.repetitive_schedule_id is null) then
554: select wip_repetitive_schedules_s.nextval
555: into wjsi_row.repetitive_schedule_id
556: from dual;
557: end if;
558: elsif(wjsi_row.repetitive_schedule_id is not null) then
559: wip_jsi_utils.record_ignored_column_warning('REPETITIVE_SCHEDULE_ID');
560: end if;