[Home] [Help]
PACKAGE: APPS.OE_ORDER_IMPORT_WF
Source
1 PACKAGE OE_ORDER_IMPORT_WF AUTHID CURRENT_USER AS
2 /* $Header: OEXWFOIS.pls 120.1 2005/08/15 14:45:41 jjmcfarl noship $ */
3 G_PKG_NAME VARCHAR2(30) := 'OE_ORDER_IMPORT_WF';
4 G_WFR_NOT_ELIGIBLE CONSTANT VARCHAR2(30) := 'NOT_ELIGIBLE';
5 G_WFR_COMPLETE CONSTANT VARCHAR2(30) := 'COMPLETE';
6 G_WFR_INCOMPLETE CONSTANT VARCHAR2(30) := 'INCOMPLETE';
7 G_WFI_ORDER_IMPORT CONSTANT VARCHAR2(4) := 'OEOI';
8 G_WFI_ORDER_ACK CONSTANT VARCHAR2(4) := 'OEOA';
9 G_WFI_SHOW_SO CONSTANT VARCHAR2(4) := 'OESO';
10 G_WFI_PROC CONSTANT VARCHAR2(4) := 'PROC';
11 G_WFI_CONC_PGM CONSTANT VARCHAR2(4) := 'CONC';
12 G_WFI_CANCEL_PO CONSTANT VARCHAR2(4) := 'OECP';
13 G_WFI_IMPORT_PGM CONSTANT VARCHAR2(4) := 'OIMP';
14
15 PROCEDURE OEOI_SELECTOR
16 ( p_itemtype in varchar2,
17 p_itemkey in varchar2,
18 p_actid in number,
19 p_funcmode in varchar2,
20 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
21 );
22
23 PROCEDURE OESO_SELECTOR
24 ( p_itemtype in varchar2,
25 p_itemkey in varchar2,
26 p_actid in number,
27 p_funcmode in varchar2,
28 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
29 );
30
31 PROCEDURE OEOA_SELECTOR
32 ( p_itemtype in varchar2,
33 p_itemkey in varchar2,
34 p_actid in number,
35 p_funcmode in varchar2,
36 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
37 );
38
39 PROCEDURE START_ORDER_IMPORT
40 ( p_itemtype in varchar2,
41 p_itemkey in varchar2,
42 p_actid in number,
43 p_funcmode in varchar2,
44 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
45 );
46
47 PROCEDURE IS_OI_COMPLETE
48 ( p_itemtype in varchar2,
49 p_itemkey in varchar2,
50 p_actid in number,
51 p_funcmode in varchar2,
52 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
53 );
54
55 PROCEDURE CALL_WF_PURGE
56 ( p_itemtype in varchar2,
57 p_itemkey in varchar2
58 );
59
60 PROCEDURE set_delivery_data
61 ( p_itemtype in varchar2,
62 p_itemkey in varchar2,
63 p_actid in number,
64 p_funcmode in varchar2,
65 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
66 );
67
68 PROCEDURE is_partner_setup
69 ( p_itemtype in varchar2,
70 p_itemkey in varchar2,
71 p_actid in number,
72 p_funcmode in varchar2,
73 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
74 );
75
76 PROCEDURE Process_Xml_Acknowledgment_Wf
77 ( p_itemtype in varchar2,
78 p_itemkey in varchar2,
79 p_actid in number,
80 p_funcmode in varchar2,
81 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
82 );
83
84 PROCEDURE Get_Activity_Result
85 (
86 p_itemtype in varchar2
87 , p_itemkey in varchar2
88 , p_activity_name in varchar2
89 , x_return_status out nocopy varchar2
90
91 , x_activity_result out nocopy varchar2
92
93 , x_activity_status_code out nocopy varchar2
94
95 , x_activity_id out nocopy number
96
97 );
98
99 Procedure Raise_Event_Showso_Wf
100 ( p_itemtype in varchar2,
101 p_itemkey in varchar2,
102 p_actid in number,
103 p_funcmode in varchar2,
104 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
105 );
106
107 Procedure Set_User_Key
108 ( p_itemtype in varchar2,
109 p_itemkey in varchar2,
110 p_actid in number,
111 p_funcmode in varchar2,
112 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
113 );
114
115
116 Procedure Is_CBOD_Out_Reqd
117 ( p_itemtype in varchar2,
118 p_itemkey in varchar2,
119 p_actid in number,
120 p_funcmode in varchar2,
121 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
122 );
123
124 Procedure Populate_CBOD_Out_Globals
125 ( p_itemtype in varchar2,
126 p_itemkey in varchar2,
127 p_actid in number,
128 p_funcmode in varchar2,
129 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
130 );
131
132 Procedure Set_CBOD_EVENT_KEY
133 ( p_itemtype in varchar2,
134 p_itemkey in varchar2,
135 p_actid in number,
136 p_funcmode in varchar2,
137 p_x_result in out NOCOPY /* file.sql.39 change */ varchar2
138 );
139
140
141 Procedure Raise_Event_Xmlint_Wf
142 ( p_itemtype IN Varchar2,
143 p_itemkey IN Varchar2,
144 p_actid in number,
145 p_funcmode IN Varchar2,
146 p_x_result IN OUT NOCOPY /* file.sql.39 change */ Varchar2
147 );
148
149 Procedure Is_OAG_or_RosettaNet
150 ( p_itemtype IN Varchar2,
151 p_itemkey IN Varchar2,
152 p_actid in number,
153 p_funcmode IN Varchar2,
154 p_x_result IN OUT NOCOPY Varchar2
155 );
156
157 END OE_ORDER_IMPORT_WF;