[Home] [Help]
PACKAGE: APPS.GMD_ROUTING_STEPS_PUB
Source
1 PACKAGE GMD_ROUTING_STEPS_PUB AS
2 /* $Header: GMDPRTSS.pls 120.1 2006/10/03 18:14:12 rajreddy noship $ */
3 /*#
4 * This package is used to create or modify routing steps and dependencies.
5 * This package defines and implements the procedures and datatypes
6 * required to create/update/delete routing steps and dependencies.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname Routing Steps package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_ROUTING
13 */
14
15 m_api_version CONSTANT NUMBER := 1;
16 m_pkg_name CONSTANT VARCHAR2 (30) := 'GMD_ROUTING_STEPS_PUB';
17
18 /*#
19 * Inserts Routing Steps
20 * This is a PL/SQL procedure to insert Routing Steps in Routing details table
21 * @param p_api_version API version field
22 * @param p_init_msg_list Flag to check if message list intialized
23 * @param p_commit Flag to check for commit
24 * @param p_routing_id Routing ID
25 * @param p_routing_no Routing Number
26 * @param p_routing_vers Routing Version
27 * @param p_routing_step_rec Row type of Routing details table
28 * @param p_routings_step_dep_tbl Table structure of Step dependency table
29 * @param x_message_count Number of msg's on message stack
30 * @param x_message_list Message list
31 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
32 * @rep:scope public
33 * @rep:lifecycle active
34 * @rep:displayname Insert Routing Steps procedure
35 * @rep:compatibility S
36 */
37 PROCEDURE insert_routing_steps
38 (
39 p_api_version IN NUMBER := 1
40 , p_init_msg_list IN BOOLEAN := TRUE
41 , p_commit IN BOOLEAN := FALSE
42 , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
43 , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
44 , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
45 , p_routing_step_rec IN fm_rout_dtl%ROWTYPE
46 , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
47 , x_message_count OUT NOCOPY NUMBER
48 , x_message_list OUT NOCOPY VARCHAR2
49 , x_return_status OUT NOCOPY VARCHAR2
50 );
51
52 /*#
53 * Inserts Step Dependencies
54 * This is a PL/SQL procedure to insert Routing Steps dependencies in Step dependency table
55 * @param p_api_version API version field
56 * @param p_init_msg_list Flag to check if message list intialized
57 * @param p_commit Flag to check for commit
58 * @param p_routing_id Routing ID
59 * @param p_routing_no Routing Number
60 * @param p_routing_vers Version of the Routing
61 * @param p_routingstep_id Routing Step ID
62 * @param p_routingstep_no Routing Step Number
63 * @param p_routings_step_dep_tbl Table structure of Step dependency table
64 * @param x_message_count Number of msg's on message stack
65 * @param x_message_list Message list
66 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
67 * @rep:scope public
68 * @rep:lifecycle active
69 * @rep:displayname Insert Step Dependency procedure
70 * @rep:compatibility S
71 */
72 PROCEDURE insert_step_dependencies
73 (
74 p_api_version IN NUMBER := 1
75 , p_init_msg_list IN BOOLEAN := TRUE
76 , p_commit IN BOOLEAN := FALSE
77 , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
78 , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
79 , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
80 , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
81 , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
82 , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
83 , x_message_count OUT NOCOPY NUMBER
84 , x_message_list OUT NOCOPY VARCHAR2
85 , x_return_status OUT NOCOPY VARCHAR2
86 );
87
88 /*#
89 * Updates Routing Steps
90 * This is a PL/SQL procedure to update Routing Steps in Routing details table
91 * @param p_api_version API version field
92 * @param p_init_msg_list Flag to check if message list intialized
93 * @param p_commit Flag to check for commit
94 * @param p_routingstep_id Routing Step ID
95 * @param p_routingstep_no Routing Step Number
96 * @param p_routing_id Routing ID
97 * @param p_routing_no Routing Number
98 * @param p_routing_vers Routing version
99 * @param p_update_table Table structure containing column and table to be updated
100 * @param x_message_count Number of msg's on message stack
101 * @param x_message_list Message list
102 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
103 * @rep:scope public
104 * @rep:lifecycle active
105 * @rep:displayname Update Routing Steps procedure
106 * @rep:compatibility S
107 */
108 PROCEDURE update_routing_steps
109 ( p_api_version IN NUMBER := 1
110 , p_init_msg_list IN BOOLEAN := TRUE
111 , p_commit IN BOOLEAN := FALSE
112 , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
113 , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
114 , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
115 , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
116 , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
117 , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
118 , x_message_count OUT NOCOPY NUMBER
119 , x_message_list OUT NOCOPY VARCHAR2
120 , x_return_status OUT NOCOPY VARCHAR2
121 );
122
123 /*#
124 * Updates Step Dependencies
125 * This is a PL/SQL procedure to update Routing Steps dependencies in Step dependency table
126 * @param p_api_version API version field
127 * @param p_init_msg_list Flag to check if message list intialized
128 * @param p_commit Flag to check for commit
129 * @param p_routingstep_no Routing Step Number
130 * @param p_routingstep_id Routing Step ID
131 * @param p_dep_routingstep_no Dependency Routing Step number
132 * @param p_routing_id Routing ID
133 * @param p_routing_no Routing Number
134 * @param p_routing_vers Routing Version
135 * @param p_update_table Table structure containing column and table to be updated
136 * @param x_message_count Number of msg's on message stack
137 * @param x_message_list Message list
138 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
139 * @rep:scope public
140 * @rep:lifecycle active
141 * @rep:displayname Update Step Dependency procedure
142 * @rep:compatibility S
143 */
144 PROCEDURE update_step_dependencies
145 ( p_api_version IN NUMBER := 1
146 , p_init_msg_list IN BOOLEAN := TRUE
147 , p_commit IN BOOLEAN := FALSE
148 , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
149 , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
150 , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
151 , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
152 , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
153 , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
154 , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
155 , x_message_count OUT NOCOPY NUMBER
156 , x_message_list OUT NOCOPY VARCHAR2
157 , x_return_status OUT NOCOPY VARCHAR2
158 );
159
160 /*#
161 * Deletes Routing Steps
162 * This is a PL/SQL procedure to delete Routing Steps in Routing details table
163 * @param p_api_version API version field
164 * @param p_init_msg_list Flag to check if message list intialized
165 * @param p_commit Flag to check for commit
166 * @param p_routingstep_id Routing Step ID
167 * @param p_routingstep_no Routing Step Number
168 * @param p_routing_id Routing ID
169 * @param p_routing_no Routing Number
170 * @param p_routing_vers Routing Version
171 * @param x_message_count Number of msg's on message stack
172 * @param x_message_list Message list
173 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
174 * @rep:scope public
175 * @rep:lifecycle active
176 * @rep:displayname Delete Routing Steps procedure
177 * @rep:compatibility S
178 */
179 PROCEDURE delete_routing_step
180 ( p_api_version IN NUMBER := 1
181 , p_init_msg_list IN BOOLEAN := TRUE
182 , p_commit IN BOOLEAN := FALSE
183 , p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE := NULL
184 , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE := NULL
185 , p_routing_id IN fm_rout_dtl.routing_id%TYPE := NULL
186 , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
187 , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
188 , x_message_count OUT NOCOPY NUMBER
189 , x_message_list OUT NOCOPY VARCHAR2
190 , x_return_status OUT NOCOPY VARCHAR2
191 );
192
193 /*#
194 * Deletes Routing Step Dependencies
195 * This is a PL/SQL procedure to delete Routing Steps dependencies in Step dependency table
196 * @param p_api_version API version field
197 * @param p_init_msg_list Flag to check if message list intialized
198 * @param p_commit Flag to check for commit
199 * @param p_routingstep_no Routing Step Number
200 * @param p_dep_routingstep_no Dependency Routing Step number
201 * @param p_routing_id Routing ID
202 * @param p_routing_no Routing Number
203 * @param p_routing_vers Routing Version
204 * @param x_message_count Number of msg's on message stack
205 * @param x_message_list Message list
206 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
207 * @rep:scope public
208 * @rep:lifecycle active
209 * @rep:displayname Delete Step Dependency procedure
210 * @rep:compatibility S
211 */
212 PROCEDURE delete_step_dependencies
213 ( p_api_version IN NUMBER := 1
214 , p_init_msg_list IN BOOLEAN := TRUE
215 , p_commit IN BOOLEAN := FALSE
216 , p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
217 , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
218 , p_routing_id IN fm_rout_dep.routing_id%TYPE := NULL
219 , p_routing_no IN gmd_routings.routing_no%TYPE := NULL
220 , p_routing_vers IN gmd_routings.routing_vers%TYPE := NULL
221 , x_message_count OUT NOCOPY NUMBER
222 , x_message_list OUT NOCOPY VARCHAR2
223 , x_return_status OUT NOCOPY VARCHAR2
224 );
225
226 END GMD_ROUTING_STEPS_PUB;