DBA Data[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on WF_ENGINE

Line 395: l_rel_threshold := wf_engine.threshold;

391: AND wias_to.item_key = wi.item_key;
392:
393: BEGIN
394:
395: l_rel_threshold := wf_engine.threshold;
396: SAVEPOINT progress_order;
397:
398: /*
399: This section will be executed in the following situation :

Line 438: wf_engine.threshold := -1;

434: IF l_release_children = 'Y' THEN
435:
436: Oe_debug_pub.ADD('Handling apply_to_order_and_line_flag..');
437:
438: wf_engine.threshold := -1;
439:
440: FOR c_rec IN c_child_lines(p_order_tbl(1).header_id)
441: LOOP
442: Oe_debug_pub.ADD('Processing OEOL : ' || c_rec.item_key);

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

439:
440: FOR c_rec IN c_child_lines(p_order_tbl(1).header_id)
441: LOOP
442: Oe_debug_pub.ADD('Processing OEOL : ' || c_rec.item_key);
443: wf_engine.CompleteActivity('OEOL', c_rec.item_key, c_rec.full_activity_name, l_result);
444: END LOOP;
445:
446: wf_engine.threshold := l_rel_threshold;
447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 446: wf_engine.threshold := l_rel_threshold;

442: Oe_debug_pub.ADD('Processing OEOL : ' || c_rec.item_key);
443: wf_engine.CompleteActivity('OEOL', c_rec.item_key, c_rec.full_activity_name, l_result);
444: END LOOP;
445:
446: wf_engine.threshold := l_rel_threshold;
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448: Oe_msg_pub.Count_And_Get
449: ( p_count => x_msg_count
450: ,p_data => x_msg_data

Line 459: wf_engine.threshold := -1 ;

455:
456: /* This section will take care of the normal situation */
457:
458: IF p_num_of_records > 1 THEN
459: wf_engine.threshold := -1 ;
460: END IF;
461:
462: Oe_debug_pub.ADD('p_num_of_records : ' || p_num_of_records);
463:

Line 518: 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);

514: -- RAISE;
515: END;
516:
517: IF l_found = 'T' THEN
518: 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);
519: END IF;
520:
521: END LOOP;
522:

Line 523: wf_engine.threshold := l_rel_threshold;

519: END IF;
520:
521: END LOOP;
522:
523: wf_engine.threshold := l_rel_threshold;
524: x_return_status := FND_API.G_RET_STS_SUCCESS;
525: Oe_msg_pub.Count_And_Get
526: ( p_count => x_msg_count
527: ,p_data => x_msg_data

Line 533: wf_engine.threshold := l_rel_threshold;

529:
530: EXCEPTION
531: WHEN OTHERS THEN
532: Oe_debug_pub.ADD('Failed from progress order.');
533: wf_engine.threshold := l_rel_threshold;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: Oe_msg_pub.Count_And_Get
536: ( p_count => x_msg_count
537: ,p_data => x_msg_data

Line 587: l_rel_threshold := wf_engine.threshold;

583: BEGIN
584:
585: Oe_debug_pub.ADD('In overloaded progress_order!!');
586:
587: l_rel_threshold := wf_engine.threshold;
588:
589: BEGIN
590: SELECT hold_entity_code
591: INTO l_hold_entity_code

Line 601: wf_engine.threshold := -1 ;

597: -- RAISE;
598: END;
599:
600: IF NVL(l_hold_entity_code,'INVALID') <> 'O' THEN
601: wf_engine.threshold := -1 ;
602: END IF;
603:
604: FOR x IN released_orders_lines LOOP
605:

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

655:
656: SAVEPOINT progress_order;
657:
658: IF l_found = 'T' THEN
659: wf_engine.CompleteActivity(l_item_type, To_Char(x.entity_id),l_activity, l_result);
660: END IF;
661:
662: END LOOP;
663:

Line 664: wf_engine.threshold := l_rel_threshold;

660: END IF;
661:
662: END LOOP;
663:
664: wf_engine.threshold := l_rel_threshold;
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666: Oe_msg_pub.Count_And_Get
667: ( p_count => x_msg_count
668: ,p_data => x_msg_data

Line 674: wf_engine.threshold := l_rel_threshold;

670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: OE_debug_pub.ADD('Failed from progress order');
674: wf_engine.threshold := l_rel_threshold;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: Oe_msg_pub.Count_And_Get
677: ( p_count => x_msg_count
678: ,p_data => x_msg_data