DBA Data[Home] [Help]

APPS.WMS_RULE_PVT_EXT_PSETJ dependencies on STANDARD

Line 230: -- @@@

226: -- @@@ if (mtrl.backorder_delivery_detail_id is not null)
227: -- @@@ then
228: -- @@@ (backordered line)
229: -- @@@ else
230: -- @@@
231: -- @@@ if (mtrl.inspection_flag is 1)
232: -- @@@ then
233: -- @@@ (Inspection routing)
234: -- @@@ elseif (mtrl.inspection_flag in (2, 3, null) or any other values)

Line 236: -- @@@ (Standard Routing assumed)

232: -- @@@ then
233: -- @@@ (Inspection routing)
234: -- @@@ elseif (mtrl.inspection_flag in (2, 3, null) or any other values)
235: -- @@@ then
236: -- @@@ (Standard Routing assumed)
237: -- @@@ end if;
238: -- @@@ end if;
239: and wop.plan_type_id = decode(mtrl.inspection_status
240: ,1 --stamp inspection op plan

Line 242: --Inspection not req, stamped standard/xdock plan

238: -- @@@ end if;
239: and wop.plan_type_id = decode(mtrl.inspection_status
240: ,1 --stamp inspection op plan
241: ,2
242: --Inspection not req, stamped standard/xdock plan
243: ,Decode(mtrl.backorder_delivery_detail_id
244: ,NULL
245: ,1
246: ,3)

Line 276: -- @@@

272: -- @@@ if (mtrl.backorder_delivery_detail_id is not null)
273: -- @@@ then
274: -- @@@ (backordered line)
275: -- @@@ else
276: -- @@@
277: -- @@@ if (mtrl.inspection_flag is 1)
278: -- @@@ then
279: -- @@@ (Inspection routing)
280: -- @@@ elseif (mtrl.inspection_flag in (2, 3, null) or any other values)

Line 282: -- @@@ (Standard Routing assumed)

278: -- @@@ then
279: -- @@@ (Inspection routing)
280: -- @@@ elseif (mtrl.inspection_flag in (2, 3, null) or any other values)
281: -- @@@ then
282: -- @@@ (Standard Routing assumed)
283: -- @@@ end if;
284: -- @@@ end if;
285: -- and wop.plan_type_id = decode(mtrl.backorder_delivery_detail_id, null, decode(mtrl.inspection_status, null, 1, 2), 3)
286: and wop.plan_type_id = decode(mtrl.inspection_status

Line 289: --Inspection not req, stamped standard/xdock plan

285: -- and wop.plan_type_id = decode(mtrl.backorder_delivery_detail_id, null, decode(mtrl.inspection_status, null, 1, 2), 3)
286: and wop.plan_type_id = decode(mtrl.inspection_status
287: ,1 --stamp inspection op plan
288: ,2
289: --Inspection not req, stamped standard/xdock plan
290: ,Decode(mtrl.backorder_delivery_detail_id
291: ,NULL
292: ,1
293: ,3)

Line 338: -- ### Standard call to check for call compatibility

334: savepoint assign_operation_plan_sp;
335: IF l_debug = 1 THEN
336: trace(' Task ID passed to the inner call is ' || p_task_id, 1);
337: END IF;
338: -- ### Standard call to check for call compatibility
339: if not fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) then
340: raise fnd_api.g_exc_unexpected_error;
341: end if;
342:

Line 644: -- ### Standard check of p_commit

640: elsif c_default_op_plan_outbound%ISOPEN then
641: close c_default_op_plan_outbound;
642: end if;
643:
644: -- ### Standard check of p_commit
645: --if p_commit in ('TRUE','T') then
646: -- commit work;
647: -- trace(' Exiting procedure assign_operation_plans '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
648: -- trace( ' p_api_version => ' || p_api_version