APPS.OE_HOLDS_PVT dependencies on WF_ENGINE

Line 495: l_rel_threshold := wf_engine.threshold;

491: AND wias_to.item_key = wi.item_key;
492:
493: BEGIN
494:
495: l_rel_threshold := wf_engine.threshold;
496: SAVEPOINT progress_order;
497:
498: -- Begin : 8284926
499: -- Get the activity name on which the hold is defined

Line 559: wf_engine.threshold := -1;

555: IF l_release_children = 'Y' THEN
556:
557: Oe_debug_pub.ADD('Handling apply_to_order_and_line_flag..');
558:
559: wf_engine.threshold := -1;
560:
561: FOR c_rec IN c_child_lines(p_order_tbl(1).header_id, l_hold_activity)
562: LOOP
563: Oe_debug_pub.ADD('Processing OEOL : ' || c_rec.item_key);

Line 564: wf_engine.CompleteActivity('OEOL', c_rec.item_key, c_rec.full_activity_name, l_result);

560:
561: FOR c_rec IN c_child_lines(p_order_tbl(1).header_id, l_hold_activity)
562: LOOP
563: Oe_debug_pub.ADD('Processing OEOL : ' || c_rec.item_key);
564: wf_engine.CompleteActivity('OEOL', c_rec.item_key, c_rec.full_activity_name, l_result);
565: END LOOP;
566:
567: wf_engine.threshold := l_rel_threshold;
568: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 567: wf_engine.threshold := l_rel_threshold;

563: Oe_debug_pub.ADD('Processing OEOL : ' || c_rec.item_key);
564: wf_engine.CompleteActivity('OEOL', c_rec.item_key, c_rec.full_activity_name, l_result);
565: END LOOP;
566:
567: wf_engine.threshold := l_rel_threshold;
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569: Oe_msg_pub.Count_And_Get
570: ( p_count => x_msg_count
571: ,p_data => x_msg_data

Line 580: wf_engine.threshold := -1 ;

576:
577: /* This section will take care of the normal situation */
578:
579: IF p_num_of_records > 1 THEN
580: wf_engine.threshold := -1 ;
581: END IF;
582:
583: Oe_debug_pub.ADD('p_num_of_records : ' || p_num_of_records);
584:

Line 721: wf_engine.CompleteActivity(l_item_type, To_Char(NVL(p_order_tbl(1).line_id,p_order_tbl(1).header_id)),l_activity, l_result);

717:
718: -- End : 8284926
719:
720: IF l_found = 'T' THEN
721: wf_engine.CompleteActivity(l_item_type, To_Char(NVL(p_order_tbl(1).line_id,p_order_tbl(1).header_id)),l_activity, l_result);
722:
723: END IF;
724:
725: END LOOP;

Line 727: wf_engine.threshold := l_rel_threshold;

723: END IF;
724:
725: END LOOP;
726:
727: wf_engine.threshold := l_rel_threshold;
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729: Oe_msg_pub.Count_And_Get
730: ( p_count => x_msg_count
731: ,p_data => x_msg_data

Line 737: wf_engine.threshold := l_rel_threshold;

733:
734: EXCEPTION
735: WHEN OTHERS THEN
736: Oe_debug_pub.ADD('Failed from progress order.');
737: wf_engine.threshold := l_rel_threshold;
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: Oe_msg_pub.Count_And_Get
740: ( p_count => x_msg_count
741: ,p_data => x_msg_data

Line 792: l_rel_threshold := wf_engine.threshold;

788: BEGIN
789:
790: Oe_debug_pub.ADD('In overloaded progress_order!!');
791:
792: l_rel_threshold := wf_engine.threshold;
793:
794: -- Begin : 8284926
795: -- Get the activity name on which the hold is defined
796: BEGIN

Line 826: wf_engine.threshold := -1 ;

822: -- RAISE;
823: END;
824:
825: IF NVL(l_hold_entity_code,'INVALID') <> 'O' THEN
826: wf_engine.threshold := -1 ;
827: END IF;
828:
829: FOR x IN released_orders_lines LOOP
830:

Line 933: wf_engine.CompleteActivity(l_item_type, To_Char(x.entity_id),l_activity, l_result);

929:
930: SAVEPOINT progress_order;
931:
932: IF l_found = 'T' THEN
933: wf_engine.CompleteActivity(l_item_type, To_Char(x.entity_id),l_activity, l_result);
934: END IF;
935:
936: END LOOP;
937:

Line 938: wf_engine.threshold := l_rel_threshold;

934: END IF;
935:
936: END LOOP;
937:
938: wf_engine.threshold := l_rel_threshold;
939: x_return_status := FND_API.G_RET_STS_SUCCESS;
940: Oe_msg_pub.Count_And_Get
941: ( p_count => x_msg_count
942: ,p_data => x_msg_data

Line 948: wf_engine.threshold := l_rel_threshold;

944:
945: EXCEPTION
946: WHEN OTHERS THEN
947: OE_debug_pub.ADD('Failed from progress order');
948: wf_engine.threshold := l_rel_threshold;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: Oe_msg_pub.Count_And_Get
951: ( p_count => x_msg_count
952: ,p_data => x_msg_data