[Home] [Help]
1: PACKAGE BODY OE_BULK_WF_UTIL AS
2: /* $Header: OEBUOWFB.pls 120.6.12020000.2 2013/04/19 05:45:14 shaofhua ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_WF_UTIL';
5:
1: PACKAGE BODY OE_BULK_WF_UTIL AS
2: /* $Header: OEBUOWFB.pls 120.6.12020000.2 2013/04/19 05:45:14 shaofhua ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_BULK_WF_UTIL';
5:
6: -------------------------------------------------------------------
7: -- LOCAL PROCEDURES/FUNCTIONS
8: -------------------------------------------------------------------
582: -- This causes issues like free good lines not being scheduled for
583: -- subsequent orders.
584: G_LINE_INDEX := null;
585:
586: OE_BULK_WF_UTIL.Create_HdrWorkItem
587: (p_index => i
588: ,p_header_rec => p_header_rec
589: );
590: /*Before we move to start Header flow, create line flow also -- bug 5261216*/
596:
597: G_LINE_INDEX := j;
598:
599: /* Start of WF Bulk API ER #8601238 */
600: /* OE_BULK_WF_UTIL.Create_LineWorkItem
601: (p_line_index => j
602: ,p_header_index => i
603: ,p_line_rec => p_line_rec
604: ,p_header_rec => p_header_rec
664:
665: FOR k IN 1..p_line_rec.ii_count(j) LOOP
666: G_LINE_INDEX := l_ii_index;
667:
668: /* OE_BULK_WF_UTIL.Create_LineWorkItem
669: (p_line_index => l_ii_index
670: ,p_header_index => i
671: ,p_line_rec => p_line_rec
672: ,p_header_rec => p_header_rec
843: IF p_line_rec.header_id(j) = l_header_id THEN
844:
845: G_LINE_INDEX := j;
846:
847: /*OE_BULK_WF_UTIL.Create_LineWorkItem
848: (p_line_index => j
849: ,p_header_index => i
850: ,p_line_rec => p_line_rec
851: ,p_header_rec => p_header_rec
880: -- concluding that all included items were scheduled if the
881: -- kit is schedule. This is not true for non-SMC kits.
882: G_LINE_INDEX := l_ii_index;
883:
884: /* OE_BULK_WF_UTIL.Create_LineWorkItem
885: (p_line_index => l_ii_index
886: ,p_header_index => i
887: ,p_line_rec => p_line_rec
888: ,p_header_rec => p_header_rec
937: , 'Start_Flows'
938: );
939: END Start_Flows;
940:
941: END OE_BULK_WF_UTIL;