APPS.WIP_BOMROUTING_PVT dependencies on STANDARD

Line 12: -- p_rtgRefID: only useful when p_jobType is nonstandard

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,

Line 13: -- p_bomRefID: only useful when p_jobType is nonstandard

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,

Line 91: /* Bug 4515999 Non standard jobs cannot have both dates not null */

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

Line 92: p_jobType = wip_constants.standard) ) then

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.

Line 110: if ( p_jobType = wip_constants.standard ) then

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;

Line 215: -- p_rtgRefID: only useful when p_jobType is nonstandard

211: -- and p_endDate, you can not provide both, however.
212: -- if it is not routing based, then you must provide both.
213: -- p_startDate: forward schedule the job if it is not null
214: -- p_endDate: backward schedule the job it it is not null
215: -- p_rtgRefID: only useful when p_jobType is nonstandard
216: -- p_bomRefID: only useful when p_jobType is nonstandard
217: -- p_unitNumber: To explode components properly based on unit number for unit effective assemblies.
218: -- for anything related to do not want to change, for instance, bom_reference_id, you must pass the original
219: -- value queried up from the job. If you pass null, this API will consider that you want to change the

Line 216: -- p_bomRefID: only useful when p_jobType is nonstandard

212: -- if it is not routing based, then you must provide both.
213: -- p_startDate: forward schedule the job if it is not null
214: -- p_endDate: backward schedule the job it it is not null
215: -- p_rtgRefID: only useful when p_jobType is nonstandard
216: -- p_bomRefID: only useful when p_jobType is nonstandard
217: -- p_unitNumber: To explode components properly based on unit number for unit effective assemblies.
218: -- for anything related to do not want to change, for instance, bom_reference_id, you must pass the original
219: -- value queried up from the job. If you pass null, this API will consider that you want to change the
220: -- value to null instead of not touching it at all.

Line 320: (l_jobType = wip_constants.nonstandard and

316: --p_routingRevDate IS NOT NULL or
317: nvl(p_altRouting, nvl(l_altRtg,fnd_api.g_miss_char)) <> nvl(l_altRtg, fnd_api.g_miss_char) or
318: nvl(p_routingRevDate, nvl(l_rtgRevDate, fnd_api.g_miss_date)) <> nvl(l_rtgRevDate, fnd_api.g_miss_date) OR
319: --Bug 5464449:End of changes
320: (l_jobType = wip_constants.nonstandard and
321: nvl(p_rtgRefID, -1) <> nvl(l_rtgRefID, -1)) ) then
322: l_expRtgRequired := true;
323: else
324: l_expRtgRequired := false;

Line 336: (l_jobType = wip_constants.nonstandard and

332: --p_bomRevDate IS NOT NULL or
333: nvl(p_altBom, nvl(l_altBom, fnd_api.g_miss_char)) <> nvl(l_altBom, fnd_api.g_miss_char) or
334: nvl(p_bomRevDate, nvl(l_bomRevDate, fnd_api.g_miss_date)) <> nvl(l_bomRevDate, fnd_api.g_miss_date) or
335: --Bug 5464449:End of changes
336: (l_jobType = wip_constants.nonstandard and
337: nvl(p_bomRefID, -1) <> nvl(l_bomRefID, -1)) ) then
338: l_expBomRequired := true;
339: else
340: l_expBomRequired := false;

Line 392: if ( l_jobType = wip_constants.standard ) then

388: x_pk1_value => to_char(p_wipEntityID),
389: x_pk3_value => to_char(p_orgID),
390: x_delete_document_flag => 'Y');
391:
392: if ( l_jobType = wip_constants.standard ) then
393: l_rtgItemID := l_assemblyID;
394: else
395: l_rtgItemID := p_rtgRefID;
396: end if;

Line 471: if ( l_jobType = wip_constants.standard ) then

467: delete from wip_requirement_operations
468: where wip_entity_id = p_wipEntityID
469: and organization_id = p_orgID;
470:
471: if ( l_jobType = wip_constants.standard ) then
472: l_bomItemID := l_assemblyID;
473: else
474: l_bomItemID := p_bomRefID;
475: end if;