eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_ROUTE_PUB dependencies on STANDARD

Line 27: -- Standard IN Parameters :

23: -- Function : API to create Route and its associations to documents, operations, resources,
24: -- resource costing, materials,access panels and disposition effectivities.
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

Line 35: -- Standard OUT Parameters :

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
37: -- x_msg_count OUT NUMBER Required
38: -- x_msg_data OUT VARCHAR2 Required
39: --

Line 55: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

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

Line 56: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

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

Line 57: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

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

Line 60: * @param x_return_status API Return status. Standard API parameter

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
63: * @param p_x_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
64: * @param p_x_route_doc_tbl Route associated documents table of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Route

Line 61: * @param x_msg_count API Return message count, if any. Standard API parameter

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
63: * @param p_x_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
64: * @param p_x_route_doc_tbl Route associated documents table of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Route
65: * @param p_x_route_operation_tbl Route associated operations table of type AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type that need to be associated to the Route

Line 62: * @param x_msg_data API Return message data, if any. Standard API parameter

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
63: * @param p_x_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
64: * @param p_x_route_doc_tbl Route associated documents table of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Route
65: * @param p_x_route_operation_tbl Route associated operations table of type AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type that need to be associated to the Route
66: * @param p_x_route_resource_tbl Route associated resources table of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Route

Line 75: -- standard IN params

71: * @rep:displayname Create Route
72: */
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,

Line 82: -- standard OUT params

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,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: -- procedure params

Line 99: -- standard IN params

95: -- Overloaded procedure retained for backaward compatibility (pre 12.0.4).
96: -- This procedure will call the above procedure with api_version = 2.
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,

Line 106: -- standard OUT params

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,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: -- procedure params

Line 127: -- Standard IN Parameters :

123: -- Function : API to modify Route details and its associations to documents, operations, resources,
124: -- resource costing, materials and disposition effectivities.
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

Line 135: -- Standard OUT Parameters :

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
137: -- x_msg_count OUT NUMBER Required
138: -- x_msg_data OUT VARCHAR2 Required
139: --

Line 155: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

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

Line 156: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

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

Line 157: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

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

Line 160: * @param x_return_status API Return status. Standard API parameter

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
163: * @param p_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
164: * @param p_x_route_doc_tbl Route associated documents table of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Route

Line 161: * @param x_msg_count API Return message count, if any. Standard API parameter

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
163: * @param p_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
164: * @param p_x_route_doc_tbl Route associated documents table of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Route
165: * @param p_x_route_operation_tbl Route associated operations table of type AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type that need to be associated to the Route

Line 162: * @param x_msg_data API Return message data, if any. Standard API parameter

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
163: * @param p_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
164: * @param p_x_route_doc_tbl Route associated documents table of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Route
165: * @param p_x_route_operation_tbl Route associated operations table of type AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type that need to be associated to the Route
166: * @param p_x_route_resource_tbl Route associated resources table of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Route

Line 175: -- standard IN params

171: * @rep:displayname Modify Route
172: */
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,

Line 182: -- standard OUT params

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,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: -- procedure params

Line 199: -- standard IN params

195: -- Overloaded procedure retained for backaward compatibility (pre 12.0.4).
196: -- This procedure will call the above procedure with api_version = 2.
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,

Line 206: -- standard OUT params

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,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: -- procedure params

Line 227: -- Standard IN Parameters :

223: -- Function : API to deletion of routes. All associations to documents, operations, resources,
224: -- resource costing, materials,access panels and disposition effectivities are also deleted.
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

Line 235: -- Standard OUT Parameters :

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
237: -- x_msg_count OUT NUMBER Required
238: -- x_msg_data OUT VARCHAR2 Required
239: --

Line 253: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

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

Line 254: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

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

Line 255: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

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

Line 258: * @param x_return_status API Return status. Standard API parameter

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
261: * @param p_route_id Route unique identifier
262: * @param p_route_number Route number

Line 259: * @param x_msg_count API Return message count, if any. Standard API parameter

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
261: * @param p_route_id Route unique identifier
262: * @param p_route_number Route number
263: * @param p_route_revision Route revision number

Line 260: * @param x_msg_data API Return message data, if any. Standard API parameter

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
261: * @param p_route_id Route unique identifier
262: * @param p_route_number Route number
263: * @param p_route_revision Route revision number
264: * @param p_route_object_version Route object version number

Line 271: -- standard IN params

267: * @rep:displayname Delete Route
268: */
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,

Line 278: -- standard OUT params

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,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: -- procedure params

Line 296: -- Standard IN Parameters :

292: -- Type : Public
293: -- Function : API to create a new revision of a Route.
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

Line 304: -- Standard OUT Parameters :

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
306: -- x_msg_count OUT NUMBER Required
307: -- x_msg_data OUT VARCHAR2 Required
308: --

Line 323: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

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

Line 324: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

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

Line 325: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

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

Line 328: * @param x_return_status API Return status. Standard API parameter

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
331: * @param p_route_id Route unique identifier
332: * @param p_route_number Route Number

Line 329: * @param x_msg_count API Return message count, if any. Standard API parameter

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
331: * @param p_route_id Route unique identifier
332: * @param p_route_number Route Number
333: * @param p_route_revision Route revision number

Line 330: * @param x_msg_data API Return message data, if any. Standard API parameter

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
331: * @param p_route_id Route unique identifier
332: * @param p_route_number Route Number
333: * @param p_route_revision Route revision number
334: * @param p_route_object_version Route object version number

Line 342: -- standard IN params

338: * @rep:displayname Create Route Revision
339: */
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,

Line 349: -- standard OUT params

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,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: -- procedure params

Line 368: -- Standard IN Parameters :

364: -- Type : Public
365: -- Function : API to submit a Route to complete / terminate approval workflows.
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

Line 376: -- Standard OUT Parameters :

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
378: -- x_msg_count OUT NUMBER Required
379: -- x_msg_data OUT VARCHAR2 Required
380: --

Line 395: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

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

Line 396: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

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

Line 397: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

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

Line 400: * @param x_return_status API Return status. Standard API parameter

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
403: * @param p_route_id Route unique identifier
404: * @param p_route_number Route number

Line 401: * @param x_msg_count API Return message count, if any. Standard API parameter

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
403: * @param p_route_id Route unique identifier
404: * @param p_route_number Route number
405: * @param p_route_revision Route revision number

Line 402: * @param x_msg_data API Return message data, if any. Standard API parameter

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
403: * @param p_route_id Route unique identifier
404: * @param p_route_number Route number
405: * @param p_route_revision Route revision number
406: * @param p_route_object_version Route object version number

Line 414: -- standard IN params

410: * @rep:displayname Initiate Route Approval
411: */
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,

Line 421: -- standard OUT params

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,
424: x_msg_data OUT NOCOPY VARCHAR2,
425: -- procedure params

Line 440: -- Standard IN Parameters :

436: -- Type : Public
437: -- Function : API to process disposition details for routes.
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

Line 448: -- Standard OUT Parameters :

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
450: -- x_msg_count OUT NUMBER Required
451: -- x_msg_data OUT VARCHAR2 Required
452: --

Line 467: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

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

Line 468: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

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

Line 469: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

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

Line 472: * @param x_return_status API Return status. Standard API parameter

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
475: * @param p_route_id Route ID of the Route to which the Disposition is added.
476: * @param p_route_number Route Number of the Route to which the Disposition is added.

Line 473: * @param x_msg_count API Return message count, if any. Standard API parameter

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
475: * @param p_route_id Route ID of the Route to which the Disposition is added.
476: * @param p_route_number Route Number of the Route to which the Disposition is added.
477: * @param p_route_revision Route Revision of the Route to which the Disposition is added.

Line 474: * @param x_msg_data API Return message data, if any. Standard API parameter

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
475: * @param p_route_id Route ID of the Route to which the Disposition is added.
476: * @param p_route_number Route Number of the Route to which the Disposition is added.
477: * @param p_route_revision Route Revision of the Route to which the Disposition is added.
478: * @param p_x_route_efct_rec Disposition effectivities record of type AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type

Line 486: -- standard IN params

482: * @rep:displayname Process Route Disposition
483: */
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,

Line 493: -- standard OUT params

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,
496: x_msg_data OUT NOCOPY VARCHAR2,
497: -- procedure params

Line 512: -- Standard IN Parameters :

508: -- Type : Public
509: -- Function : API to process alternate resources for routes.
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

Line 520: -- Standard OUT Parameters :

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
522: -- x_msg_count OUT NUMBER Required
523: -- x_msg_data OUT VARCHAR2 Required
524: --

Line 540: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

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

Line 541: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE

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

Line 542: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL

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

Line 545: * @param x_return_status API Return status. Standard API parameter

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
548: * @param p_route_number Route number of the Route to which the resource is associated
549: * @param p_route_revision Route revision of the Route to which the resource is associated

Line 546: * @param x_msg_count API Return message count, if any. Standard API parameter

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
548: * @param p_route_number Route number of the Route to which the resource is associated
549: * @param p_route_revision Route revision of the Route to which the resource is associated
550: * @param p_route_id Route id of the Route to which the resource is associated

Line 547: * @param x_msg_data API Return message data, if any. Standard API parameter

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
548: * @param p_route_number Route number of the Route to which the resource is associated
549: * @param p_route_revision Route revision of the Route to which the resource is associated
550: * @param p_route_id Route id of the Route to which the resource is associated
551: * @param p_resource_id Resource Id of the resource to be associated

Line 560: -- standard IN params

556: * @rep:displayname Process Route Alternate Resource
557: */
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,

Line 567: -- standard OUT params

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,
570: x_msg_data OUT NOCOPY VARCHAR2,
571: -- procedure params