[Home] [Help]
480: AND wias_from.item_type = 'OEOL'
481: AND wi.parent_item_key = To_Char(p_header_id)
482: AND wa.item_type = wias_to.item_type
483: AND wa.NAME = wpa_to.activity_name
484: AND wa.FUNCTION = 'OE_STANDARD_WF.STANDARD_BLOCK'
485: AND wa.end_date IS NULL
486: AND wias_to.end_date IS NULL
487: AND wias_to.activity_status = 'NOTIFIED'
488: AND wias_to.item_type = wias_from.item_type
587: BEGIN
588:
589: /* This select statement will pick up the activity which fulfills
590: the following criteria :
591: 1. Activity is based on a OE_STANDARD_WF.STANDARD_BLOCK function
592: 2. Activity is in a 'NOTIFIED' status
593: 3. Activity has been reached via a transition of 'ON_HOLD'
594: 4. For a given item_type and item_key
595: */
617: AND wias_from.item_type = DECODE(p_order_tbl(i).line_id, NULL, 'OEOH', 'OEOL')
618: AND wias_from.item_key = To_Char(NVL(p_order_tbl(i).line_id,p_order_tbl(i).header_id))
619: AND wa.item_type = wias_to.item_type
620: AND wa.NAME = wpa_to.activity_name
621: AND wa.FUNCTION = 'OE_STANDARD_WF.STANDARD_BLOCK'
622: AND wa.end_date IS NULL
623: AND wias_to.end_date IS NULL
624: AND wias_to.activity_status = 'NOTIFIED'
625: AND wias_to.item_type = wias_from.item_type
646: AND wias_from.item_type = DECODE(p_order_tbl(i).line_id, NULL, 'OEOH', 'OEOL')
647: AND wias_from.item_key = To_Char(NVL(p_order_tbl(i).line_id,p_order_tbl(i).header_id))
648: AND wa.item_type = wias_to.item_type
649: AND wa.NAME = wpa_to.activity_name
650: AND wa.FUNCTION = 'OE_STANDARD_WF.STANDARD_BLOCK'
651: AND wa.end_date IS NULL
652: AND wias_to.end_date IS NULL
653: AND wias_to.activity_status = 'NOTIFIED'
654: AND wias_to.item_type = wias_from.item_type
700: AND wias_from.item_type = DECODE(p_order_tbl(i).line_id, NULL, 'OEOH', 'OEOL')
701: AND wias_from.item_key = To_Char(NVL(p_order_tbl(i).line_id,p_order_tbl(i).header_id))
702: AND wa.item_type = wias_to.item_type
703: AND wa.NAME = wpa_to.activity_name
704: AND wa.FUNCTION = 'OE_STANDARD_WF.STANDARD_BLOCK'
705: AND wa.end_date IS NULL
706: AND wias_to.end_date IS NULL
707: AND wias_to.activity_status = 'NOTIFIED'
708: AND wias_to.item_type = wias_from.item_type
831: BEGIN
832:
833: /* This select statement will pick up the activity which fulfills
834: the following criteria :
835: 1. Activity is based on a OE_STANDARD_WF.STANDARD_BLOCK function
836: 2. Activity is in a 'NOTIFIED' status
837: 3. Activity has been reached via a transition of 'ON_HOLD'
838: 4. For a given item_type and item_key
839: */
859: AND wias_from.item_type = x.entity_type
860: AND wias_from.item_key = To_Char(x.entity_id)
861: AND wa.item_type = wias_to.item_type
862: AND wa.NAME = wpa_to.activity_name
863: AND wa.FUNCTION = 'OE_STANDARD_WF.STANDARD_BLOCK'
864: AND wa.end_date IS NULL
865: AND wias_to.end_date IS NULL
866: AND wias_to.activity_status = 'NOTIFIED'
867: AND wias_to.item_type = wias_from.item_type
910: AND wias_from.item_type = x.entity_type
911: AND wias_from.item_key = To_Char(x.entity_id)
912: AND wa.item_type = wias_to.item_type
913: AND wa.NAME = wpa_to.activity_name
914: AND wa.FUNCTION = 'OE_STANDARD_WF.STANDARD_BLOCK'
915: AND wa.end_date IS NULL
916: AND wias_to.end_date IS NULL
917: AND wias_to.activity_status = 'NOTIFIED'
918: AND wias_to.item_type = wias_from.item_type
5796: FROM OE_ORDER_HOLDS_all
5797: WHERE LINE_ID = p_order_rec.line_id;
5798:
5799: BEGIN
5800: -- Standard Start of API savepoint
5801:
5802: SAVEPOINT DELETE_HOLDS_PUB;
5803:
5804: -- Initialize API return status to success