[Home] [Help]
8: -- and p_endDate, you can not provide both, however.
9: -- if it is not routing based, then you must provide both.
10: -- p_startDate: forward schedule the job if it is not null
11: -- p_endDate: backward schedule the job it it is not null
12: -- p_rtgRefID: only useful when p_jobType is nonstandard
13: -- p_bomRefID: only useful when p_jobType is nonstandard
14: -- p_unitNumber: To explode components properly based on unit number for unit effective assemblies.
15: procedure createJob(p_orgID in number,
16: p_wipEntityID in number,
9: -- if it is not routing based, then you must provide both.
10: -- p_startDate: forward schedule the job if it is not null
11: -- p_endDate: backward schedule the job it it is not null
12: -- p_rtgRefID: only useful when p_jobType is nonstandard
13: -- p_bomRefID: only useful when p_jobType is nonstandard
14: -- p_unitNumber: To explode components properly based on unit number for unit effective assemblies.
15: procedure createJob(p_orgID in number,
16: p_wipEntityID in number,
17: p_jobType in number,
87:
88: if ( p_schedulingMethod = wip_constants.routing ) then
89: if ( (p_startDate is null and p_endDate is null) or
90: ((p_startDate is not null and p_endDate is not null) and
91: /* Bug 4515999 Non standard jobs cannot have both dates not null */
92: p_jobType = wip_constants.standard) ) then
93: x_errorMsg := 'Must only provide one of the p_startDate and p_endDate for routing based scheduling';
94: raise fnd_api.g_exc_unexpected_error;
95: else
88: if ( p_schedulingMethod = wip_constants.routing ) then
89: if ( (p_startDate is null and p_endDate is null) or
90: ((p_startDate is not null and p_endDate is not null) and
91: /* Bug 4515999 Non standard jobs cannot have both dates not null */
92: p_jobType = wip_constants.standard) ) then
93: x_errorMsg := 'Must only provide one of the p_startDate and p_endDate for routing based scheduling';
94: raise fnd_api.g_exc_unexpected_error;
95: else
96: -- populate some value and then we will reschedule it later on.
106: l_endDate := p_endDate;
107: end if;
108: end if;
109:
110: if ( p_jobType = wip_constants.standard ) then
111: l_rtgItemID := p_itemID;
112: l_bomItemID := p_itemID;
113: else
114: l_rtgItemID := p_rtgRefID;
238: -- and p_endDate, you can not provide both, however.
239: -- if it is not routing based, then you must provide both.
240: -- p_startDate: forward schedule the job if it is not null
241: -- p_endDate: backward schedule the job it it is not null
242: -- p_rtgRefID: only useful when p_jobType is nonstandard
243: -- p_bomRefID: only useful when p_jobType is nonstandard
244: -- p_unitNumber: To explode components properly based on unit number for unit effective assemblies.
245: -- for anything related to do not want to change, for instance, bom_reference_id, you must pass the original
246: -- value queried up from the job. If you pass null, this API will consider that you want to change the
239: -- if it is not routing based, then you must provide both.
240: -- p_startDate: forward schedule the job if it is not null
241: -- p_endDate: backward schedule the job it it is not null
242: -- p_rtgRefID: only useful when p_jobType is nonstandard
243: -- p_bomRefID: only useful when p_jobType is nonstandard
244: -- p_unitNumber: To explode components properly based on unit number for unit effective assemblies.
245: -- for anything related to do not want to change, for instance, bom_reference_id, you must pass the original
246: -- value queried up from the job. If you pass null, this API will consider that you want to change the
247: -- value to null instead of not touching it at all.
353: if ( nvl(p_altRouting, nvl(l_altRtg,'@@@')) <> nvl(l_altRtg, '@@@') or
354: nvl(p_routingRevDate, nvl(l_rtgRevDate, fnd_api.g_miss_date)) <> nvl(l_rtgRevDate, fnd_api.g_miss_date) OR
355: /*bug 15963294: when revision changes with no change of revision date due to bom_high_date being in the future, we still reexplode*/
356: nvl(p_routingRev, nvl(l_rtgRev, fnd_api.g_miss_char)) <> nvl(l_rtgRev, fnd_api.g_miss_char) OR
357: (p_allowExplosion) or (l_jobType = wip_constants.nonstandard and nvl(p_rtgRefID, -1) <> nvl(l_rtgRefID, -1)) ) then
358: l_expRtgRequired := true;
359: if (p_altRouting = '@@@' or p_altRouting = fnd_api.g_miss_char ) then
360: l_altRtg := null;
361: else
369: if ( nvl(p_altBom, nvl(l_altBom, '@@@')) <> nvl(l_altBom, '@@@') or
370: nvl(p_bomRevDate, nvl(l_bomRevDate, fnd_api.g_miss_date)) <> nvl(l_bomRevDate, fnd_api.g_miss_date) or
371: /*bug 15963294: when revision changes with no change of revision date due to bom_high_date being in the future, we still reexplode*/
372: nvl(p_bomRev, nvl(l_bomRev, fnd_api.g_miss_char)) <> nvl(l_bomRev, fnd_api.g_miss_char) OR
373: (p_allowExplosion) or (l_jobType = wip_constants.nonstandard and nvl(p_bomRefID, -1) <> nvl(l_bomRefID, -1)) ) then
374: l_expBomRequired := true;
375: if (p_altBom = '@@@' or p_altBom = fnd_api.g_miss_char) then
376: l_altBom := null;
377: else
432: x_pk1_value => to_char(p_wipEntityID),
433: x_pk3_value => to_char(p_orgID),
434: x_delete_document_flag => 'Y');
435: */
436: if ( l_jobType = wip_constants.standard ) then
437: l_rtgItemID := l_assemblyID;
438: else
439: l_rtgItemID := p_rtgRefID;
440: if p_rtgRefID is NULL then --Bug#14301607: If the Routing reference is removed, the routing should be removed for NonStdJobs
536:
537:
538: if ( l_expBomRequired ) then
539:
540: if ( l_jobType = wip_constants.standard ) then
541: l_bomItemID := l_assemblyID;
542: else
543: l_bomItemID := p_bomRefID;
544: end if;