1 PACKAGE OE_BULK_WF_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEBUOWFS.pls 120.1.12020000.1 2012/06/26 08:19:06 appldev ship $ */
3
4 -------------------------------------------------------------------
5 -- GLOBAL DECLARATIONS
6 -------------------------------------------------------------------
7
8 -- Global Table to store Order Type WF Assignments
9 TYPE ORDER_TYPE_WF_ASSIGN_REC IS RECORD (Order_Type_ID NUMBER,
10 Process_Name VARCHAR2(30));
11
12 TYPE ORDER_TYPE_WF_ASSIGN_TBL IS TABLE OF ORDER_TYPE_WF_ASSIGN_REC
13 INDEX BY BINARY_INTEGER;
14
15 G_ORDER_TYPE_WF_ASSIGN_TBL ORDER_TYPE_WF_ASSIGN_TBL;
16
17 -- Global Table to store Line Type WF Assignments
18 TYPE LINE_TYPE_WF_ASSIGN_REC IS RECORD (Order_Type_ID NUMBER,
19 Line_Type_ID NUMBER,
20 WF_Item_Type VARCHAR2(30),
21 Process_Name VARCHAR2(30));
22
23 TYPE LINE_TYPE_WF_ASSIGN_TBL IS TABLE OF LINE_TYPE_WF_ASSIGN_REC
24 INDEX BY BINARY_INTEGER;
25
26 G_LINE_TYPE_WF_ASSIGN_TBL LINE_TYPE_WF_ASSIGN_TBL;
27
28 G_HEADER_INDEX NUMBER;
29 G_LINE_INDEX NUMBER;
30
31
32 -------------------------------------------------------------------
33 -- FUNCTION/PROCEDURE DECLARATIONS
34 -------------------------------------------------------------------
35
36 -----------------------------------------------------------------------
37 -- FUNCTION Validate_OT_WF_Assignment
38 --
39 -- This function returns TRUE if this order type has a valid header WF
40 -- assignment.
41 --
42 -- If valid, it also returns the header WF process name in
43 -- x_process_name OUT parameter.
44 -----------------------------------------------------------------------
45
46 FUNCTION Validate_OT_WF_Assignment
47 ( p_order_type_id IN NUMBER
48 ,x_process_name OUT NOCOPY VARCHAR2
49 )
50 RETURN BOOLEAN;
51
52 -----------------------------------------------------------------------
53 -- FUNCTION Validate_LT_WF_Assignment
54 --
55 -- This function returns TRUE if order type, line type, WF item type
56 -- combination has a valid line WF assignment. p_item_type_code and
57 -- p_order_quantity_uom are used to derive the WF item type.
58 --
59 -- If valid, it also returns the line WF process name in x_process_name
60 -- OUT parameter.
61 -----------------------------------------------------------------------
62
63 FUNCTION Validate_LT_WF_Assignment
64 ( p_order_type_id IN NUMBER
65 , p_line_index IN NUMBER
66 , p_line_rec IN OE_WSH_BULK_GRP.LINE_REC_TYPE
67 , x_process_name OUT NOCOPY VARCHAR2
68
69 )
70 RETURN BOOLEAN;
71
72 -----------------------------------------------------------------------
73 -- PROCEDURE Start_Flows
74 --
75 -- This API is called from BULK process order to start workflows for
76 -- all orders or lines processed in a batch.
77 -----------------------------------------------------------------------
78
79 PROCEDURE Start_Flows
80 (p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
81 ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
82 ,x_return_status OUT NOCOPY VARCHAR2
83 );
84
85 END OE_BULK_WF_UTIL;