1 PACKAGE OE_STANDARD_WF AUTHID CURRENT_USER as
2 /* $Header: OEXWSTDS.pls 120.0.12020000.2 2013/01/10 08:35:19 spothula ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_STANDARD_WF';
5
6 -- This is a global that will be evaluated during the upgrade of OE cycle data
7 -- to WF in OM. It will be set to TRUE, ONLY by the upgrade process.
8 G_UPGRADE_MODE BOOLEAN DEFAULT FALSE;
9
10 -- This is a Global that determines whether the Save messages procedure will
11 -- save messages to the database. The caller (eg: Sales Order Form) can set
12 -- this to false, because he wants to manage the messages himself.
13 -- The default is set to TRUE so when the Background engine is in control
14 -- we will save the messages to the db.
15 G_SAVE_MESSAGES BOOLEAN DEFAULT TRUE;
16
17 -- This global determines whether we use the item attributes stored on the
18 -- Header/line wf item to reset application context. The default is TRUE as
19 -- in the case of the Background engine running stuff, we do need to set
20 -- context. However in case of the Sales Order form calling the WF engine
21 -- the context is already set and we do not need to set it again.
22 G_RESET_APPS_CONTEXT BOOLEAN DEFAULT TRUE;
23
24 G_USER_ID NUMBER DEFAULT NULL; -- 3169637
25
26 PROCEDURE UPGRADE_MODE_ON;
27
28 PROCEDURE SAVE_MESSAGES_ON;
29
30 PROCEDURE SAVE_MESSAGES_OFF;
31
32 PROCEDURE RESET_APPS_CONTEXT_ON;
33
34 PROCEDURE RESET_APPS_CONTEXT_OFF;
35
36 PROCEDURE SET_MSG_CONTEXT(P_PROCESS_ACTIVITY IN NUMBER DEFAULT NULL);
37
38 PROCEDURE CLEAR_MSG_CONTEXT;
39
40 PROCEDURE SAVE_MESSAGES(p_instance_id IN NUMBER DEFAULT NULL);
41
42 PROCEDURE STANDARD_BLOCK(
43 itemtype in varchar2,
44 itemkey in varchar2,
45 actid in number,
46 funcmode in varchar2,
47 resultout in out nocopy varchar2 /* file.sql.39 change */
48 );
49
50 PROCEDURE OEOH_SELECTOR
51 ( p_itemtype in varchar2
52 , p_itemkey in varchar2
53 , p_actid in number
54 , p_funcmode in varchar2
55 , p_result in out nocopy varchar2 /* file.sql.39 change */
56 );
57
58 PROCEDURE OEOL_SELECTOR
59 ( p_itemtype in varchar2
60 , p_itemkey in varchar2
61 , p_actid in number
62 , p_funcmode in varchar2
63 , p_result in out nocopy varchar2 /* file.sql.39 change */
64 );
65
66 PROCEDURE OENH_SELECTOR
67 ( p_itemtype in varchar2
68 , p_itemkey in varchar2
69 , p_actid in number
70 , p_funcmode in varchar2
71 , p_result in out nocopy varchar2 /* file.sql.39 change */
72 );
73
74 PROCEDURE OEBH_SELECTOR
75 ( p_itemtype in varchar2
76 , p_itemkey in varchar2
77 , p_actid in number
78 , p_funcmode in varchar2
79 , p_result in out nocopy varchar2 /* file.sql.39 change */
80 );
81
82 PROCEDURE Get_Supply_Source_Type
83 ( p_itemtype in varchar2
84 , p_itemkey in varchar2
85 , p_actid in number
86 , p_funcmode in varchar2
87 , p_result in out nocopy varchar2 /* file.sql.39 change */
88 );
89
90 PROCEDURE Get_Line_Category
91 ( p_itemtype in varchar2
92 , p_itemkey in varchar2
93 , p_actid in number
94 , p_funcmode in varchar2
95 , p_result in out nocopy varchar2 /* file.sql.39 change */
96 );
97 PROCEDURE Set_Exception_Message;
98
99 PROCEDURE Add_Error_Activity_Msg
100 ( p_actid IN NUMBER,
101 p_itemkey IN VARCHAR2,
102 p_itemtype IN VARCHAR2);
103
104 -- Added for AME ER 16084377
105 PROCEDURE OEAME_SELECTOR
106 ( p_itemtype in varchar2
107 , p_itemkey in varchar2
108 , p_actid in number
109 , p_funcmode in varchar2
110 , p_result in out nocopy varchar2 /* file.sql.39 change */
111 );
112
113 END OE_STANDARD_WF;