[Home] [Help]
380: AND wias_from.item_type = 'OEOL'
381: AND wi.parent_item_key = To_Char(p_header_id)
382: AND wa.item_type = wias_to.item_type
383: AND wa.NAME = wpa_to.activity_name
384: AND wa.FUNCTION = 'OE_STANDARD_WF.STANDARD_BLOCK'
385: AND wa.end_date IS NULL
386: AND wias_to.end_date IS NULL
387: AND wias_to.activity_status = 'NOTIFIED'
388: AND wias_to.item_type = wias_from.item_type
466: BEGIN
467:
468: /* This select statement will pick up the activity which fulfills
469: the following criteria :
470: 1. Activity is based on a OE_STANDARD_WF.STANDARD_BLOCK function
471: 2. Activity is in a 'NOTIFIED' status
472: 3. Activity has been reached via a transition of 'ON_HOLD'
473: 4. For a given item_type and item_key
474: */
491: AND wias_from.item_type = DECODE(p_order_tbl(i).line_id, NULL, 'OEOH', 'OEOL')
492: AND wias_from.item_key = To_Char(NVL(p_order_tbl(i).line_id,p_order_tbl(i).header_id))
493: AND wa.item_type = wias_to.item_type
494: AND wa.NAME = wpa_to.activity_name
495: AND wa.FUNCTION = 'OE_STANDARD_WF.STANDARD_BLOCK'
496: AND wa.end_date IS NULL
497: AND wias_to.end_date IS NULL
498: AND wias_to.activity_status = 'NOTIFIED'
499: AND wias_to.item_type = wias_from.item_type
606: BEGIN
607:
608: /* This select statement will pick up the activity which fulfills
609: the following criteria :
610: 1. Activity is based on a OE_STANDARD_WF.STANDARD_BLOCK function
611: 2. Activity is in a 'NOTIFIED' status
612: 3. Activity has been reached via a transition of 'ON_HOLD'
613: 4. For a given item_type and item_key
614: */
631: AND wias_from.item_type = x.entity_type
632: AND wias_from.item_key = To_Char(x.entity_id)
633: AND wa.item_type = wias_to.item_type
634: AND wa.NAME = wpa_to.activity_name
635: AND wa.FUNCTION = 'OE_STANDARD_WF.STANDARD_BLOCK'
636: AND wa.end_date IS NULL
637: AND wias_to.end_date IS NULL
638: AND wias_to.activity_status = 'NOTIFIED'
639: AND wias_to.item_type = x.entity_type
5235: FROM OE_ORDER_HOLDS_all
5236: WHERE LINE_ID = p_order_rec.line_id;
5237:
5238: BEGIN
5239: -- Standard Start of API savepoint
5240:
5241: SAVEPOINT DELETE_HOLDS_PUB;
5242:
5243: -- Initialize API return status to success