PACKAGE: APPS.OE_UPGRADE_WF2

Source

1 PACKAGE OE_UPGRADE_WF2 as
2 /* $Header: OEXIUWUS.pls 120.0 2005/06/01 01:17:34 appldev noship $ */
3 
4 V_API_ERROR_CODE    number:=0;      /* Globle variable */
5 V_DUMMY             varchar2(1);    /* Globle variable */
6 V_ERROR_CODE        number;         /* Globle variable */
7 V_ERROR_FLAG        varchar2(1);    /* Globle variable */
8 V_ERROR_LEVEL       number;         /* Globle variable */
9 V_ERROR_MESSAGE     varchar2(240);   /* Globle variable */
10 
11 PROCEDURE get_pre_activity
12 (
13   p_action_id          IN	NUMBER,
14   p_sequence_id        IN     NUMBER,
15 v_pre_activity OUT NOCOPY varchar2,
16 
17 v_pre_result OUT NOCOPY varchar2
18 
19 );
20 
21 FUNCTION get_post_activity
22 (
23   p_action_id          IN	NUMBER,
24   p_sequence_id        IN     NUMBER
25 )
26 return VARCHAR2;
27 
28 FUNCTION get_instance_id
29 (
30   p_process_name      IN   varchar2,
31   p_activity_name     IN   varchar2,
32   p_instance_label    IN   varchar2
33 )
34 return number;
35 
36 PROCEDURE insert_into_wf_table
37 (
38   p_from_instance_id  IN   NUMBER,
39   p_to_instance_id    IN   NUMBER,
40   p_result_code       IN   VARCHAR2,
41 p_level_error OUT NOCOPY NUMBER
42 
43 );
44 
45 PROCEDURE Get_Icon_X_value
46 (
47   p_icon_geometry    IN  varchar2,
48 p_x_value OUT NOCOPY number
49 
50 );
51 
52 
53 PROCEDURE Create_Process_Name
54  (
55       p_item_type           IN     VARCHAR2,
56 	 p_line_type           IN     VARCHAR2,
57       p_cycle_id            IN     NUMBER
58  );
59 
60 PROCEDURE Create_Lookup_Type
61 (
62      p_item_type   IN   VARCHAR2
63 );
64 
65 PROCEDURE Create_Lookup_Code
66 (
67      p_item_type   IN   VARCHAR2
68 );
69 
70 PROCEDURE Create_Activity_Name
71 (
72      p_item_type   IN   VARCHAR2
73 );
74 
75 PROCEDURE Create_Process_Activity
76 (
77      p_item_type              IN   VARCHAR2,
78      p_cycle_id               IN   NUMBER,
79      p_line_type              IN   varchar2
80 );
81 
82 PROCEDURE Create_Activity_And
83 (
84       p_item_type        IN   varchar2,
85       p_line_type        IN   varchar2,
86       p_cycle_id         IN   number
87 );
88 
89 PROCEDURE Create_Header_Line_Dependency
90 (
91        p_cycle_id          IN    number,
92        p_line_type         IN    varchar2
93 );
94 
95 
96 PROCEDURE Create_Notification
97 (
98        p_cycle_id          IN     NUMBER,
99        p_line_type         IN     VARCHAR2,
100        p_item_type         IN     VARCHAR2
101 );
102 
103 
104 PROCEDURE Create_Activity_Or
105 (
106      p_item_type         IN     varchar2,
107      p_line_type         IN     varchar2,
108      p_cycle_id          IN     number
109 );
110 
111 PROCEDURE Create_Activity_Transition
112 (
113     p_item_type        IN   varchar2,
114     p_cycle_id         IN   number,
115     p_line_type        IN   varchar2
116 );
117 
118 PROCEDURE Ship_Confirm_Adjusting
119 (
120     p_cycle_id         IN   NUMBER,
121     p_line_type        IN   VARCHAR2
122 );
123 
124 
125 PROCEDURE ATO_Adjusting
126 (
127     p_cycle_id         IN   NUMBER
128 );
129 
130 PROCEDURE Generic_Flow_Adjusting
131 (
132     p_item_type        IN   VARCHAR2,
133     p_cycle_id         IN   NUMBER,
134     p_line_type        IN   VARCHAR2
135 );
136 
137 PROCEDURE Create_Default_Transition
138 (
139       p_item_type         IN    varchar2,
140       p_line_type         IN   varchar2,
141       p_cycle_id          IN    number
142 );
143 
144 PROCEDURE Create_Line_Start
145 (
146       p_cycle_id           IN     number,
147       p_line_type          IN     varchar2
148 );
149 
150 PROCEDURE Adjust_Arrow_Geometry
151 (
152       p_item_type           IN      varchar2,
153       p_line_type           IN      varchar2,
154       p_cycle_id            IN      number
155 );
156 
157 PROCEDURE Close_Open_End
158 (
159      p_cycle_id            IN     number,
160      p_line_type           IN     varchar2,
161      p_item_type           IN     varchar2
162 );
163 
164 
165 PROCEDURE Upgrade_Workflow;
166 
167 END OE_UPGRADE_WF2;