25: -- Pre-reqs :
26: --
27: -- Standard IN Parameters :
28: -- p_api_version IN NUMBER
29: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
32: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
33: -- p_module_type IN VARCHAR2 Required, default NULL
26: --
27: -- Standard IN Parameters :
28: -- p_api_version IN NUMBER
29: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
32: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
33: -- p_module_type IN VARCHAR2 Required, default NULL
34:
27: -- Standard IN Parameters :
28: -- p_api_version IN NUMBER
29: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
32: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
33: -- p_module_type IN VARCHAR2 Required, default NULL
34:
35: -- Standard OUT Parameters :
28: -- p_api_version IN NUMBER
29: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
30: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
32: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
33: -- p_module_type IN VARCHAR2 Required, default NULL
34:
35: -- Standard OUT Parameters :
36: -- x_return_status OUT VARCHAR2 Required
51: -- End of Comments --
52: /*#
53: * Use this procedure to Create a Route and optionally, create associated document references, operations, resource requirements, resource costing parameters and material requirements.
54: * @param p_api_version API Version Number.
55: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
56: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
57: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
58: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
59: * @param p_module_type For Internal use only, should always be NULL, default value NULL
52: /*#
53: * Use this procedure to Create a Route and optionally, create associated document references, operations, resource requirements, resource costing parameters and material requirements.
54: * @param p_api_version API Version Number.
55: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
56: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
57: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
58: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
59: * @param p_module_type For Internal use only, should always be NULL, default value NULL
60: * @param x_return_status API Return status. Standard API parameter
53: * Use this procedure to Create a Route and optionally, create associated document references, operations, resource requirements, resource costing parameters and material requirements.
54: * @param p_api_version API Version Number.
55: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
56: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
57: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
58: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
59: * @param p_module_type For Internal use only, should always be NULL, default value NULL
60: * @param x_return_status API Return status. Standard API parameter
61: * @param x_msg_count API Return message count, if any. Standard API parameter
54: * @param p_api_version API Version Number.
55: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
56: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
57: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
58: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
59: * @param p_module_type For Internal use only, should always be NULL, default value NULL
60: * @param x_return_status API Return status. Standard API parameter
61: * @param x_msg_count API Return message count, if any. Standard API parameter
62: * @param x_msg_data API Return message data, if any. Standard API parameter
73: PROCEDURE Create_Route
74: (
75: -- standard IN params
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
78: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
79: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
80: p_default IN VARCHAR2 :=FND_API.G_FALSE,
81: p_module_type IN VARCHAR2 :=NULL,
74: (
75: -- standard IN params
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
78: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
79: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
80: p_default IN VARCHAR2 :=FND_API.G_FALSE,
81: p_module_type IN VARCHAR2 :=NULL,
82: -- standard OUT params
75: -- standard IN params
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
78: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
79: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
80: p_default IN VARCHAR2 :=FND_API.G_FALSE,
81: p_module_type IN VARCHAR2 :=NULL,
82: -- standard OUT params
83: x_return_status OUT NOCOPY VARCHAR2,
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
78: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
79: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
80: p_default IN VARCHAR2 :=FND_API.G_FALSE,
81: p_module_type IN VARCHAR2 :=NULL,
82: -- standard OUT params
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
97: PROCEDURE Create_Route
98: (
99: -- standard IN params
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
102: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
103: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
104: p_default IN VARCHAR2 :=FND_API.G_FALSE,
105: p_module_type IN VARCHAR2 :=NULL,
98: (
99: -- standard IN params
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
102: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
103: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
104: p_default IN VARCHAR2 :=FND_API.G_FALSE,
105: p_module_type IN VARCHAR2 :=NULL,
106: -- standard OUT params
99: -- standard IN params
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
102: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
103: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
104: p_default IN VARCHAR2 :=FND_API.G_FALSE,
105: p_module_type IN VARCHAR2 :=NULL,
106: -- standard OUT params
107: x_return_status OUT NOCOPY VARCHAR2,
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
102: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
103: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
104: p_default IN VARCHAR2 :=FND_API.G_FALSE,
105: p_module_type IN VARCHAR2 :=NULL,
106: -- standard OUT params
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
125: -- Pre-reqs :
126: --
127: -- Standard IN Parameters :
128: -- p_api_version IN NUMBER
129: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
130: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
132: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
133: -- p_module_type IN VARCHAR2 Required, default NULL
126: --
127: -- Standard IN Parameters :
128: -- p_api_version IN NUMBER
129: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
130: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
132: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
133: -- p_module_type IN VARCHAR2 Required, default NULL
134:
127: -- Standard IN Parameters :
128: -- p_api_version IN NUMBER
129: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
130: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
132: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
133: -- p_module_type IN VARCHAR2 Required, default NULL
134:
135: -- Standard OUT Parameters :
128: -- p_api_version IN NUMBER
129: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
130: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
132: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
133: -- p_module_type IN VARCHAR2 Required, default NULL
134:
135: -- Standard OUT Parameters :
136: -- x_return_status OUT VARCHAR2 Required
151: -- End of Comments --
152: /*#
153: * Use this procedure to modify a Route and optionally, create, modify and delete associated document references, operations, resource requirements, resource costing parameters, access panels and material requirements.
154: * @param p_api_version API Version Number.
155: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
156: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
157: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
158: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
159: * @param p_module_type For Internal use only, should always be NULL, default value NULL
152: /*#
153: * Use this procedure to modify a Route and optionally, create, modify and delete associated document references, operations, resource requirements, resource costing parameters, access panels and material requirements.
154: * @param p_api_version API Version Number.
155: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
156: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
157: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
158: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
159: * @param p_module_type For Internal use only, should always be NULL, default value NULL
160: * @param x_return_status API Return status. Standard API parameter
153: * Use this procedure to modify a Route and optionally, create, modify and delete associated document references, operations, resource requirements, resource costing parameters, access panels and material requirements.
154: * @param p_api_version API Version Number.
155: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
156: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
157: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
158: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
159: * @param p_module_type For Internal use only, should always be NULL, default value NULL
160: * @param x_return_status API Return status. Standard API parameter
161: * @param x_msg_count API Return message count, if any. Standard API parameter
154: * @param p_api_version API Version Number.
155: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
156: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
157: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
158: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
159: * @param p_module_type For Internal use only, should always be NULL, default value NULL
160: * @param x_return_status API Return status. Standard API parameter
161: * @param x_msg_count API Return message count, if any. Standard API parameter
162: * @param x_msg_data API Return message data, if any. Standard API parameter
173: PROCEDURE Modify_Route
174: (
175: -- standard IN params
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
178: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
179: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
180: p_default IN VARCHAR2 :=FND_API.G_FALSE,
181: p_module_type IN VARCHAR2 :=NULL,
174: (
175: -- standard IN params
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
178: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
179: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
180: p_default IN VARCHAR2 :=FND_API.G_FALSE,
181: p_module_type IN VARCHAR2 :=NULL,
182: -- standard OUT params
175: -- standard IN params
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
178: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
179: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
180: p_default IN VARCHAR2 :=FND_API.G_FALSE,
181: p_module_type IN VARCHAR2 :=NULL,
182: -- standard OUT params
183: x_return_status OUT NOCOPY VARCHAR2,
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
178: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
179: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
180: p_default IN VARCHAR2 :=FND_API.G_FALSE,
181: p_module_type IN VARCHAR2 :=NULL,
182: -- standard OUT params
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
197: PROCEDURE Modify_Route
198: (
199: -- standard IN params
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
202: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
203: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
204: p_default IN VARCHAR2 :=FND_API.G_FALSE,
205: p_module_type IN VARCHAR2 :=NULL,
198: (
199: -- standard IN params
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
202: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
203: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
204: p_default IN VARCHAR2 :=FND_API.G_FALSE,
205: p_module_type IN VARCHAR2 :=NULL,
206: -- standard OUT params
199: -- standard IN params
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
202: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
203: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
204: p_default IN VARCHAR2 :=FND_API.G_FALSE,
205: p_module_type IN VARCHAR2 :=NULL,
206: -- standard OUT params
207: x_return_status OUT NOCOPY VARCHAR2,
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
202: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
203: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
204: p_default IN VARCHAR2 :=FND_API.G_FALSE,
205: p_module_type IN VARCHAR2 :=NULL,
206: -- standard OUT params
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
225: -- Pre-reqs :
226: --
227: -- Standard IN Parameters :
228: -- p_api_version IN NUMBER
229: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
230: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
232: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
233: -- p_module_type IN VARCHAR2 Required, default NULL
226: --
227: -- Standard IN Parameters :
228: -- p_api_version IN NUMBER
229: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
230: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
232: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
233: -- p_module_type IN VARCHAR2 Required, default NULL
234:
227: -- Standard IN Parameters :
228: -- p_api_version IN NUMBER
229: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
230: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
232: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
233: -- p_module_type IN VARCHAR2 Required, default NULL
234:
235: -- Standard OUT Parameters :
228: -- p_api_version IN NUMBER
229: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
230: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
232: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
233: -- p_module_type IN VARCHAR2 Required, default NULL
234:
235: -- Standard OUT Parameters :
236: -- x_return_status OUT VARCHAR2 Required
249: -- End of Comments --
250: /*#
251: * Use this procedure to delete a Route. All associations to documents, operations, resource requirements, resource costing parameters and material requirements will be deleted.
252: * @param p_api_version API Version Number.
253: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
254: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
255: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
256: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
257: * @param p_module_type For Internal use only, should always be NULL, default value NULL
250: /*#
251: * Use this procedure to delete a Route. All associations to documents, operations, resource requirements, resource costing parameters and material requirements will be deleted.
252: * @param p_api_version API Version Number.
253: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
254: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
255: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
256: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
257: * @param p_module_type For Internal use only, should always be NULL, default value NULL
258: * @param x_return_status API Return status. Standard API parameter
251: * Use this procedure to delete a Route. All associations to documents, operations, resource requirements, resource costing parameters and material requirements will be deleted.
252: * @param p_api_version API Version Number.
253: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
254: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
255: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
256: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
257: * @param p_module_type For Internal use only, should always be NULL, default value NULL
258: * @param x_return_status API Return status. Standard API parameter
259: * @param x_msg_count API Return message count, if any. Standard API parameter
252: * @param p_api_version API Version Number.
253: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
254: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
255: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
256: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
257: * @param p_module_type For Internal use only, should always be NULL, default value NULL
258: * @param x_return_status API Return status. Standard API parameter
259: * @param x_msg_count API Return message count, if any. Standard API parameter
260: * @param x_msg_data API Return message data, if any. Standard API parameter
269: PROCEDURE Delete_Route
270: (
271: -- standard IN params
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
274: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
275: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
276: p_default IN VARCHAR2 :=FND_API.G_FALSE,
277: p_module_type IN VARCHAR2 :=NULL,
270: (
271: -- standard IN params
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
274: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
275: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
276: p_default IN VARCHAR2 :=FND_API.G_FALSE,
277: p_module_type IN VARCHAR2 :=NULL,
278: -- standard OUT params
271: -- standard IN params
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
274: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
275: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
276: p_default IN VARCHAR2 :=FND_API.G_FALSE,
277: p_module_type IN VARCHAR2 :=NULL,
278: -- standard OUT params
279: x_return_status OUT NOCOPY VARCHAR2,
272: p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
274: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
275: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
276: p_default IN VARCHAR2 :=FND_API.G_FALSE,
277: p_module_type IN VARCHAR2 :=NULL,
278: -- standard OUT params
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
294: -- Pre-reqs :
295: --
296: -- Standard IN Parameters :
297: -- p_api_version IN NUMBER
298: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
299: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
301: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
302: -- p_module_type IN VARCHAR2 Required, default NULL
295: --
296: -- Standard IN Parameters :
297: -- p_api_version IN NUMBER
298: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
299: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
301: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
302: -- p_module_type IN VARCHAR2 Required, default NULL
303:
296: -- Standard IN Parameters :
297: -- p_api_version IN NUMBER
298: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
299: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
301: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
302: -- p_module_type IN VARCHAR2 Required, default NULL
303:
304: -- Standard OUT Parameters :
297: -- p_api_version IN NUMBER
298: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
299: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
300: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
301: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
302: -- p_module_type IN VARCHAR2 Required, default NULL
303:
304: -- Standard OUT Parameters :
305: -- x_return_status OUT VARCHAR2 Required
319: -- End of Comments --
320: /*#
321: * Use this procedure to create a new revision of a existing and completed Route.
322: * @param p_api_version API Version Number.
323: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
324: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
325: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
326: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
327: * @param p_module_type For Internal use only, should always be NULL, default value NULL
320: /*#
321: * Use this procedure to create a new revision of a existing and completed Route.
322: * @param p_api_version API Version Number.
323: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
324: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
325: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
326: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
327: * @param p_module_type For Internal use only, should always be NULL, default value NULL
328: * @param x_return_status API Return status. Standard API parameter
321: * Use this procedure to create a new revision of a existing and completed Route.
322: * @param p_api_version API Version Number.
323: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
324: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
325: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
326: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
327: * @param p_module_type For Internal use only, should always be NULL, default value NULL
328: * @param x_return_status API Return status. Standard API parameter
329: * @param x_msg_count API Return message count, if any. Standard API parameter
322: * @param p_api_version API Version Number.
323: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
324: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
325: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
326: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
327: * @param p_module_type For Internal use only, should always be NULL, default value NULL
328: * @param x_return_status API Return status. Standard API parameter
329: * @param x_msg_count API Return message count, if any. Standard API parameter
330: * @param x_msg_data API Return message data, if any. Standard API parameter
340: PROCEDURE Create_Route_Revision
341: (
342: -- standard IN params
343: p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
345: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
346: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
347: p_default IN VARCHAR2 :=FND_API.G_FALSE,
348: p_module_type IN VARCHAR2 :=NULL,
341: (
342: -- standard IN params
343: p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
345: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
346: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
347: p_default IN VARCHAR2 :=FND_API.G_FALSE,
348: p_module_type IN VARCHAR2 :=NULL,
349: -- standard OUT params
342: -- standard IN params
343: p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
345: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
346: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
347: p_default IN VARCHAR2 :=FND_API.G_FALSE,
348: p_module_type IN VARCHAR2 :=NULL,
349: -- standard OUT params
350: x_return_status OUT NOCOPY VARCHAR2,
343: p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
345: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
346: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
347: p_default IN VARCHAR2 :=FND_API.G_FALSE,
348: p_module_type IN VARCHAR2 :=NULL,
349: -- standard OUT params
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
366: -- Pre-reqs :
367: --
368: -- Standard IN Parameters :
369: -- p_api_version IN NUMBER
370: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
371: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
372: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
373: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
374: -- p_module_type IN VARCHAR2 Required, default NULL
367: --
368: -- Standard IN Parameters :
369: -- p_api_version IN NUMBER
370: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
371: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
372: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
373: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
374: -- p_module_type IN VARCHAR2 Required, default NULL
375:
368: -- Standard IN Parameters :
369: -- p_api_version IN NUMBER
370: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
371: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
372: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
373: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
374: -- p_module_type IN VARCHAR2 Required, default NULL
375:
376: -- Standard OUT Parameters :
369: -- p_api_version IN NUMBER
370: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
371: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
372: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
373: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
374: -- p_module_type IN VARCHAR2 Required, default NULL
375:
376: -- Standard OUT Parameters :
377: -- x_return_status OUT VARCHAR2 Required
391: -- End of Comments --
392: /*#
393: * Use this procedure to submit a Route for Completion or Termination approval workflows.
394: * @param p_api_version API Version Number.
395: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
396: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
397: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
398: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
399: * @param p_module_type For Internal use only, should always be NULL, default value NULL
392: /*#
393: * Use this procedure to submit a Route for Completion or Termination approval workflows.
394: * @param p_api_version API Version Number.
395: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
396: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
397: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
398: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
399: * @param p_module_type For Internal use only, should always be NULL, default value NULL
400: * @param x_return_status API Return status. Standard API parameter
393: * Use this procedure to submit a Route for Completion or Termination approval workflows.
394: * @param p_api_version API Version Number.
395: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
396: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
397: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
398: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
399: * @param p_module_type For Internal use only, should always be NULL, default value NULL
400: * @param x_return_status API Return status. Standard API parameter
401: * @param x_msg_count API Return message count, if any. Standard API parameter
394: * @param p_api_version API Version Number.
395: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
396: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
397: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
398: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
399: * @param p_module_type For Internal use only, should always be NULL, default value NULL
400: * @param x_return_status API Return status. Standard API parameter
401: * @param x_msg_count API Return message count, if any. Standard API parameter
402: * @param x_msg_data API Return message data, if any. Standard API parameter
412: PROCEDURE Initiate_Route_Approval
413: (
414: -- standard IN params
415: p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
417: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
418: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
419: p_default IN VARCHAR2 :=FND_API.G_FALSE,
420: p_module_type IN VARCHAR2 :=NULL,
413: (
414: -- standard IN params
415: p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
417: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
418: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
419: p_default IN VARCHAR2 :=FND_API.G_FALSE,
420: p_module_type IN VARCHAR2 :=NULL,
421: -- standard OUT params
414: -- standard IN params
415: p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
417: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
418: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
419: p_default IN VARCHAR2 :=FND_API.G_FALSE,
420: p_module_type IN VARCHAR2 :=NULL,
421: -- standard OUT params
422: x_return_status OUT NOCOPY VARCHAR2,
415: p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
417: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
418: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
419: p_default IN VARCHAR2 :=FND_API.G_FALSE,
420: p_module_type IN VARCHAR2 :=NULL,
421: -- standard OUT params
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
438: -- Pre-reqs :
439: --
440: -- Standard IN Parameters :
441: -- p_api_version IN NUMBER
442: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
443: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
444: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
445: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
446: -- p_module_type IN VARCHAR2 Required, default NULL
439: --
440: -- Standard IN Parameters :
441: -- p_api_version IN NUMBER
442: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
443: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
444: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
445: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
446: -- p_module_type IN VARCHAR2 Required, default NULL
447:
440: -- Standard IN Parameters :
441: -- p_api_version IN NUMBER
442: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
443: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
444: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
445: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
446: -- p_module_type IN VARCHAR2 Required, default NULL
447:
448: -- Standard OUT Parameters :
441: -- p_api_version IN NUMBER
442: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
443: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
444: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
445: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
446: -- p_module_type IN VARCHAR2 Required, default NULL
447:
448: -- Standard OUT Parameters :
449: -- x_return_status OUT VARCHAR2 Required
463: -- End of Comments --
464: /*#
465: * Use this procedure to create, update and delete disposition effectivities and material requirements for a Route.
466: * @param p_api_version API Version Number.
467: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
468: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
469: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
470: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
471: * @param p_module_type For Internal use only, should always be NULL, default value NULL
464: /*#
465: * Use this procedure to create, update and delete disposition effectivities and material requirements for a Route.
466: * @param p_api_version API Version Number.
467: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
468: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
469: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
470: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
471: * @param p_module_type For Internal use only, should always be NULL, default value NULL
472: * @param x_return_status API Return status. Standard API parameter
465: * Use this procedure to create, update and delete disposition effectivities and material requirements for a Route.
466: * @param p_api_version API Version Number.
467: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
468: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
469: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
470: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
471: * @param p_module_type For Internal use only, should always be NULL, default value NULL
472: * @param x_return_status API Return status. Standard API parameter
473: * @param x_msg_count API Return message count, if any. Standard API parameter
466: * @param p_api_version API Version Number.
467: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
468: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
469: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
470: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
471: * @param p_module_type For Internal use only, should always be NULL, default value NULL
472: * @param x_return_status API Return status. Standard API parameter
473: * @param x_msg_count API Return message count, if any. Standard API parameter
474: * @param x_msg_data API Return message data, if any. Standard API parameter
484: PROCEDURE Process_Route_Dispositions
485: (
486: -- standard IN params
487: p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
489: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
490: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
491: p_default IN VARCHAR2 :=FND_API.G_FALSE,
492: p_module_type IN VARCHAR2 :=NULL,
485: (
486: -- standard IN params
487: p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
489: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
490: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
491: p_default IN VARCHAR2 :=FND_API.G_FALSE,
492: p_module_type IN VARCHAR2 :=NULL,
493: -- standard OUT params
486: -- standard IN params
487: p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
489: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
490: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
491: p_default IN VARCHAR2 :=FND_API.G_FALSE,
492: p_module_type IN VARCHAR2 :=NULL,
493: -- standard OUT params
494: x_return_status OUT NOCOPY VARCHAR2,
487: p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
489: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
490: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
491: p_default IN VARCHAR2 :=FND_API.G_FALSE,
492: p_module_type IN VARCHAR2 :=NULL,
493: -- standard OUT params
494: x_return_status OUT NOCOPY VARCHAR2,
495: x_msg_count OUT NOCOPY NUMBER,
510: -- Pre-reqs :
511: --
512: -- Standard IN Parameters :
513: -- p_api_version IN NUMBER
514: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_TRUE
515: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
516: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
517: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
518: -- p_module_type IN VARCHAR2 Required, default NULL
511: --
512: -- Standard IN Parameters :
513: -- p_api_version IN NUMBER
514: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_TRUE
515: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
516: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
517: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
518: -- p_module_type IN VARCHAR2 Required, default NULL
519:
512: -- Standard IN Parameters :
513: -- p_api_version IN NUMBER
514: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_TRUE
515: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
516: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
517: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
518: -- p_module_type IN VARCHAR2 Required, default NULL
519:
520: -- Standard OUT Parameters :
513: -- p_api_version IN NUMBER
514: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_TRUE
515: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
516: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
517: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
518: -- p_module_type IN VARCHAR2 Required, default NULL
519:
520: -- Standard OUT Parameters :
521: -- x_return_status OUT VARCHAR2 Required
536: -- End of Comments --
537: /*#
538: * Use this procedure to define Alternate Resources for an existing Route-Resource Requirement.
539: * @param p_api_version API Version Number.
540: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
541: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
542: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
543: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
544: * @param p_module_type For Internal use only, should always be NULL, default value NULL
537: /*#
538: * Use this procedure to define Alternate Resources for an existing Route-Resource Requirement.
539: * @param p_api_version API Version Number.
540: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
541: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
542: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
543: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
544: * @param p_module_type For Internal use only, should always be NULL, default value NULL
545: * @param x_return_status API Return status. Standard API parameter
538: * Use this procedure to define Alternate Resources for an existing Route-Resource Requirement.
539: * @param p_api_version API Version Number.
540: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
541: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
542: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
543: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
544: * @param p_module_type For Internal use only, should always be NULL, default value NULL
545: * @param x_return_status API Return status. Standard API parameter
546: * @param x_msg_count API Return message count, if any. Standard API parameter
539: * @param p_api_version API Version Number.
540: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
541: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
542: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
543: * @param p_default Parameter to decide whether to default attributes or not, valid values are FND_API.G_TRUE or FND_API.G_FALSE, default value NULL
544: * @param p_module_type For Internal use only, should always be NULL, default value NULL
545: * @param x_return_status API Return status. Standard API parameter
546: * @param x_msg_count API Return message count, if any. Standard API parameter
547: * @param x_msg_data API Return message data, if any. Standard API parameter
558: PROCEDURE Process_Route_Alt_Resources
559: (
560: -- standard IN params
561: p_api_version IN NUMBER,
562: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
563: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
564: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
565: p_default IN VARCHAR2 :=FND_API.G_FALSE,
566: p_module_type IN VARCHAR2 :=NULL,
559: (
560: -- standard IN params
561: p_api_version IN NUMBER,
562: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
563: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
564: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
565: p_default IN VARCHAR2 :=FND_API.G_FALSE,
566: p_module_type IN VARCHAR2 :=NULL,
567: -- standard OUT params
560: -- standard IN params
561: p_api_version IN NUMBER,
562: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
563: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
564: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
565: p_default IN VARCHAR2 :=FND_API.G_FALSE,
566: p_module_type IN VARCHAR2 :=NULL,
567: -- standard OUT params
568: x_return_status OUT NOCOPY VARCHAR2,
561: p_api_version IN NUMBER,
562: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
563: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
564: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
565: p_default IN VARCHAR2 :=FND_API.G_FALSE,
566: p_module_type IN VARCHAR2 :=NULL,
567: -- standard OUT params
568: x_return_status OUT NOCOPY VARCHAR2,
569: x_msg_count OUT NOCOPY NUMBER,