DBA Data[Home] [Help]

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 103: -- Standard IN Parameters :

99: -- Function : API to modify Route details and its associations to documents, operations, resources,
100: -- resource costing, materials and disposition effectivities.
101: -- Pre-reqs :
102: --
103: -- Standard IN Parameters :
104: -- p_api_version IN NUMBER
105: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
106: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
107: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 111: -- Standard OUT Parameters :

107: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
108: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
109: -- p_module_type IN VARCHAR2 Required, default NULL
110:
111: -- Standard OUT Parameters :
112: -- x_return_status OUT VARCHAR2 Required
113: -- x_msg_count OUT NUMBER Required
114: -- x_msg_data OUT VARCHAR2 Required
115: --

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

127: -- End of Comments --
128: /*#
129: * 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.
130: * @param p_api_version API Version Number.
131: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
132: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
133: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
134: * @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
135: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

128: /*#
129: * 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.
130: * @param p_api_version API Version Number.
131: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
132: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
133: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
134: * @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
135: * @param p_module_type For Internal use only, should always be NULL, default value NULL
136: * @param x_return_status API Return status. Standard API parameter

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

129: * 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.
130: * @param p_api_version API Version Number.
131: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
132: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
133: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
134: * @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
135: * @param p_module_type For Internal use only, should always be NULL, default value NULL
136: * @param x_return_status API Return status. Standard API parameter
137: * @param x_msg_count API Return message count, if any. Standard API parameter

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

132: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
133: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
134: * @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
135: * @param p_module_type For Internal use only, should always be NULL, default value NULL
136: * @param x_return_status API Return status. Standard API parameter
137: * @param x_msg_count API Return message count, if any. Standard API parameter
138: * @param x_msg_data API Return message data, if any. Standard API parameter
139: * @param p_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
140: * @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 137: * @param x_msg_count API Return message count, if any. Standard API parameter

133: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
134: * @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
135: * @param p_module_type For Internal use only, should always be NULL, default value NULL
136: * @param x_return_status API Return status. Standard API parameter
137: * @param x_msg_count API Return message count, if any. Standard API parameter
138: * @param x_msg_data API Return message data, if any. Standard API parameter
139: * @param p_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
140: * @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
141: * @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 138: * @param x_msg_data API Return message data, if any. Standard API parameter

134: * @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
135: * @param p_module_type For Internal use only, should always be NULL, default value NULL
136: * @param x_return_status API Return status. Standard API parameter
137: * @param x_msg_count API Return message count, if any. Standard API parameter
138: * @param x_msg_data API Return message data, if any. Standard API parameter
139: * @param p_route_rec Route record of type AHL_RM_ROUTE_PVT.route_rec_type
140: * @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
141: * @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
142: * @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 151: -- standard IN params

147: * @rep:displayname Modify Route
148: */
149: PROCEDURE Modify_Route
150: (
151: -- standard IN params
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
154: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
155: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 158: -- standard OUT params

154: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
155: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
156: p_default IN VARCHAR2 :=FND_API.G_FALSE,
157: p_module_type IN VARCHAR2 :=NULL,
158: -- standard OUT params
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: -- procedure params

Line 179: -- Standard IN Parameters :

175: -- Function : API to deletion of routes. All associations to documents, operations, resources,
176: -- resource costing, materials,access panels and disposition effectivities are also deleted.
177: -- Pre-reqs :
178: --
179: -- Standard IN Parameters :
180: -- p_api_version IN NUMBER
181: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
182: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
183: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 187: -- Standard OUT Parameters :

183: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
184: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
185: -- p_module_type IN VARCHAR2 Required, default NULL
186:
187: -- Standard OUT Parameters :
188: -- x_return_status OUT VARCHAR2 Required
189: -- x_msg_count OUT NUMBER Required
190: -- x_msg_data OUT VARCHAR2 Required
191: --

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

201: -- End of Comments --
202: /*#
203: * Use this procedure to delete a Route. All associations to documents, operations, resource requirements, resource costing parameters and material requirements will be deleted.
204: * @param p_api_version API Version Number.
205: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
206: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
207: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
208: * @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
209: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

202: /*#
203: * Use this procedure to delete a Route. All associations to documents, operations, resource requirements, resource costing parameters and material requirements will be deleted.
204: * @param p_api_version API Version Number.
205: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
206: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
207: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
208: * @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
209: * @param p_module_type For Internal use only, should always be NULL, default value NULL
210: * @param x_return_status API Return status. Standard API parameter

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

203: * Use this procedure to delete a Route. All associations to documents, operations, resource requirements, resource costing parameters and material requirements will be deleted.
204: * @param p_api_version API Version Number.
205: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
206: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
207: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
208: * @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
209: * @param p_module_type For Internal use only, should always be NULL, default value NULL
210: * @param x_return_status API Return status. Standard API parameter
211: * @param x_msg_count API Return message count, if any. Standard API parameter

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

206: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
207: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
208: * @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
209: * @param p_module_type For Internal use only, should always be NULL, default value NULL
210: * @param x_return_status API Return status. Standard API parameter
211: * @param x_msg_count API Return message count, if any. Standard API parameter
212: * @param x_msg_data API Return message data, if any. Standard API parameter
213: * @param p_route_id Route unique identifier
214: * @param p_route_number Route number

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

207: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
208: * @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
209: * @param p_module_type For Internal use only, should always be NULL, default value NULL
210: * @param x_return_status API Return status. Standard API parameter
211: * @param x_msg_count API Return message count, if any. Standard API parameter
212: * @param x_msg_data API Return message data, if any. Standard API parameter
213: * @param p_route_id Route unique identifier
214: * @param p_route_number Route number
215: * @param p_route_revision Route revision number

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

208: * @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
209: * @param p_module_type For Internal use only, should always be NULL, default value NULL
210: * @param x_return_status API Return status. Standard API parameter
211: * @param x_msg_count API Return message count, if any. Standard API parameter
212: * @param x_msg_data API Return message data, if any. Standard API parameter
213: * @param p_route_id Route unique identifier
214: * @param p_route_number Route number
215: * @param p_route_revision Route revision number
216: * @param p_route_object_version Route object version number

Line 223: -- standard IN params

219: * @rep:displayname Delete Route
220: */
221: PROCEDURE Delete_Route
222: (
223: -- standard IN params
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
226: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
227: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 230: -- standard OUT params

226: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
227: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
228: p_default IN VARCHAR2 :=FND_API.G_FALSE,
229: p_module_type IN VARCHAR2 :=NULL,
230: -- standard OUT params
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: -- procedure params

Line 248: -- Standard IN Parameters :

244: -- Type : Public
245: -- Function : API to create a new revision of a Route.
246: -- Pre-reqs :
247: --
248: -- Standard IN Parameters :
249: -- p_api_version IN NUMBER
250: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
251: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 256: -- Standard OUT Parameters :

252: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
253: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
254: -- p_module_type IN VARCHAR2 Required, default NULL
255:
256: -- Standard OUT Parameters :
257: -- x_return_status OUT VARCHAR2 Required
258: -- x_msg_count OUT NUMBER Required
259: -- x_msg_data OUT VARCHAR2 Required
260: --

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

271: -- End of Comments --
272: /*#
273: * Use this procedure to create a new revision of a existing and completed Route.
274: * @param p_api_version API Version Number.
275: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
276: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
277: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
278: * @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
279: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

272: /*#
273: * Use this procedure to create a new revision of a existing and completed Route.
274: * @param p_api_version API Version Number.
275: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
276: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
277: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
278: * @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
279: * @param p_module_type For Internal use only, should always be NULL, default value NULL
280: * @param x_return_status API Return status. Standard API parameter

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

273: * Use this procedure to create a new revision of a existing and completed Route.
274: * @param p_api_version API Version Number.
275: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
276: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
277: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
278: * @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
279: * @param p_module_type For Internal use only, should always be NULL, default value NULL
280: * @param x_return_status API Return status. Standard API parameter
281: * @param x_msg_count API Return message count, if any. Standard API parameter

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

276: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
277: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
278: * @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
279: * @param p_module_type For Internal use only, should always be NULL, default value NULL
280: * @param x_return_status API Return status. Standard API parameter
281: * @param x_msg_count API Return message count, if any. Standard API parameter
282: * @param x_msg_data API Return message data, if any. Standard API parameter
283: * @param p_route_id Route unique identifier
284: * @param p_route_number Route Number

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

277: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
278: * @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
279: * @param p_module_type For Internal use only, should always be NULL, default value NULL
280: * @param x_return_status API Return status. Standard API parameter
281: * @param x_msg_count API Return message count, if any. Standard API parameter
282: * @param x_msg_data API Return message data, if any. Standard API parameter
283: * @param p_route_id Route unique identifier
284: * @param p_route_number Route Number
285: * @param p_route_revision Route revision number

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

278: * @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
279: * @param p_module_type For Internal use only, should always be NULL, default value NULL
280: * @param x_return_status API Return status. Standard API parameter
281: * @param x_msg_count API Return message count, if any. Standard API parameter
282: * @param x_msg_data API Return message data, if any. Standard API parameter
283: * @param p_route_id Route unique identifier
284: * @param p_route_number Route Number
285: * @param p_route_revision Route revision number
286: * @param p_route_object_version Route object version number

Line 294: -- standard IN params

290: * @rep:displayname Create Route Revision
291: */
292: PROCEDURE Create_Route_Revision
293: (
294: -- standard IN params
295: p_api_version IN NUMBER,
296: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
297: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
298: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 301: -- standard OUT params

297: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
298: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
299: p_default IN VARCHAR2 :=FND_API.G_FALSE,
300: p_module_type IN VARCHAR2 :=NULL,
301: -- standard OUT params
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: -- procedure params

Line 320: -- Standard IN Parameters :

316: -- Type : Public
317: -- Function : API to submit a Route to complete / terminate approval workflows.
318: -- Pre-reqs :
319: --
320: -- Standard IN Parameters :
321: -- p_api_version IN NUMBER
322: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
323: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 328: -- Standard OUT Parameters :

324: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
325: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
326: -- p_module_type IN VARCHAR2 Required, default NULL
327:
328: -- Standard OUT Parameters :
329: -- x_return_status OUT VARCHAR2 Required
330: -- x_msg_count OUT NUMBER Required
331: -- x_msg_data OUT VARCHAR2 Required
332: --

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

343: -- End of Comments --
344: /*#
345: * Use this procedure to submit a Route for Completion or Termination approval workflows.
346: * @param p_api_version API Version Number.
347: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
348: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
349: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
350: * @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
351: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

344: /*#
345: * Use this procedure to submit a Route for Completion or Termination approval workflows.
346: * @param p_api_version API Version Number.
347: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
348: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
349: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
350: * @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
351: * @param p_module_type For Internal use only, should always be NULL, default value NULL
352: * @param x_return_status API Return status. Standard API parameter

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

345: * Use this procedure to submit a Route for Completion or Termination approval workflows.
346: * @param p_api_version API Version Number.
347: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
348: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
349: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
350: * @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
351: * @param p_module_type For Internal use only, should always be NULL, default value NULL
352: * @param x_return_status API Return status. Standard API parameter
353: * @param x_msg_count API Return message count, if any. Standard API parameter

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

348: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
349: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
350: * @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
351: * @param p_module_type For Internal use only, should always be NULL, default value NULL
352: * @param x_return_status API Return status. Standard API parameter
353: * @param x_msg_count API Return message count, if any. Standard API parameter
354: * @param x_msg_data API Return message data, if any. Standard API parameter
355: * @param p_route_id Route unique identifier
356: * @param p_route_number Route number

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

349: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
350: * @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
351: * @param p_module_type For Internal use only, should always be NULL, default value NULL
352: * @param x_return_status API Return status. Standard API parameter
353: * @param x_msg_count API Return message count, if any. Standard API parameter
354: * @param x_msg_data API Return message data, if any. Standard API parameter
355: * @param p_route_id Route unique identifier
356: * @param p_route_number Route number
357: * @param p_route_revision Route revision number

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

350: * @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
351: * @param p_module_type For Internal use only, should always be NULL, default value NULL
352: * @param x_return_status API Return status. Standard API parameter
353: * @param x_msg_count API Return message count, if any. Standard API parameter
354: * @param x_msg_data API Return message data, if any. Standard API parameter
355: * @param p_route_id Route unique identifier
356: * @param p_route_number Route number
357: * @param p_route_revision Route revision number
358: * @param p_route_object_version Route object version number

Line 366: -- standard IN params

362: * @rep:displayname Initiate Route Approval
363: */
364: PROCEDURE Initiate_Route_Approval
365: (
366: -- standard IN params
367: p_api_version IN NUMBER,
368: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
369: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
370: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 373: -- standard OUT params

369: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
370: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
371: p_default IN VARCHAR2 :=FND_API.G_FALSE,
372: p_module_type IN VARCHAR2 :=NULL,
373: -- standard OUT params
374: x_return_status OUT NOCOPY VARCHAR2,
375: x_msg_count OUT NOCOPY NUMBER,
376: x_msg_data OUT NOCOPY VARCHAR2,
377: -- procedure params

Line 392: -- Standard IN Parameters :

388: -- Type : Public
389: -- Function : API to process disposition details for routes.
390: -- Pre-reqs :
391: --
392: -- Standard IN Parameters :
393: -- p_api_version IN NUMBER
394: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
396: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 400: -- Standard OUT Parameters :

396: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
397: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
398: -- p_module_type IN VARCHAR2 Required, default NULL
399:
400: -- Standard OUT Parameters :
401: -- x_return_status OUT VARCHAR2 Required
402: -- x_msg_count OUT NUMBER Required
403: -- x_msg_data OUT VARCHAR2 Required
404: --

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

415: -- End of Comments --
416: /*#
417: * Use this procedure to create, update and delete disposition effectivities and material requirements for a Route.
418: * @param p_api_version API Version Number.
419: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
420: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
421: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
422: * @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
423: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

416: /*#
417: * Use this procedure to create, update and delete disposition effectivities and material requirements for a Route.
418: * @param p_api_version API Version Number.
419: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
420: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
421: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
422: * @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
423: * @param p_module_type For Internal use only, should always be NULL, default value NULL
424: * @param x_return_status API Return status. Standard API parameter

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

417: * Use this procedure to create, update and delete disposition effectivities and material requirements for a Route.
418: * @param p_api_version API Version Number.
419: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
420: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
421: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
422: * @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
423: * @param p_module_type For Internal use only, should always be NULL, default value NULL
424: * @param x_return_status API Return status. Standard API parameter
425: * @param x_msg_count API Return message count, if any. Standard API parameter

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

420: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
421: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
422: * @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
423: * @param p_module_type For Internal use only, should always be NULL, default value NULL
424: * @param x_return_status API Return status. Standard API parameter
425: * @param x_msg_count API Return message count, if any. Standard API parameter
426: * @param x_msg_data API Return message data, if any. Standard API parameter
427: * @param p_route_id Route ID of the Route to which the Disposition is added.
428: * @param p_route_number Route Number of the Route to which the Disposition is added.

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

421: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
422: * @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
423: * @param p_module_type For Internal use only, should always be NULL, default value NULL
424: * @param x_return_status API Return status. Standard API parameter
425: * @param x_msg_count API Return message count, if any. Standard API parameter
426: * @param x_msg_data API Return message data, if any. Standard API parameter
427: * @param p_route_id Route ID of the Route to which the Disposition is added.
428: * @param p_route_number Route Number of the Route to which the Disposition is added.
429: * @param p_route_revision Route Revision of the Route to which the Disposition is added.

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

422: * @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
423: * @param p_module_type For Internal use only, should always be NULL, default value NULL
424: * @param x_return_status API Return status. Standard API parameter
425: * @param x_msg_count API Return message count, if any. Standard API parameter
426: * @param x_msg_data API Return message data, if any. Standard API parameter
427: * @param p_route_id Route ID of the Route to which the Disposition is added.
428: * @param p_route_number Route Number of the Route to which the Disposition is added.
429: * @param p_route_revision Route Revision of the Route to which the Disposition is added.
430: * @param p_x_route_efct_rec Disposition effectivities record of type AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type

Line 438: -- standard IN params

434: * @rep:displayname Process Route Disposition
435: */
436: PROCEDURE Process_Route_Dispositions
437: (
438: -- standard IN params
439: p_api_version IN NUMBER,
440: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
441: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
442: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 445: -- standard OUT params

441: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
442: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
443: p_default IN VARCHAR2 :=FND_API.G_FALSE,
444: p_module_type IN VARCHAR2 :=NULL,
445: -- standard OUT params
446: x_return_status OUT NOCOPY VARCHAR2,
447: x_msg_count OUT NOCOPY NUMBER,
448: x_msg_data OUT NOCOPY VARCHAR2,
449: -- procedure params

Line 464: -- Standard IN Parameters :

460: -- Type : Public
461: -- Function : API to process alternate resources for routes.
462: -- Pre-reqs :
463: --
464: -- Standard IN Parameters :
465: -- p_api_version IN NUMBER
466: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_TRUE
467: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
468: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 472: -- Standard OUT Parameters :

468: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
469: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
470: -- p_module_type IN VARCHAR2 Required, default NULL
471:
472: -- Standard OUT Parameters :
473: -- x_return_status OUT VARCHAR2 Required
474: -- x_msg_count OUT NUMBER Required
475: -- x_msg_data OUT VARCHAR2 Required
476: --

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

488: -- End of Comments --
489: /*#
490: * Use this procedure to define Alternate Resources for an existing Route-Resource Requirement.
491: * @param p_api_version API Version Number.
492: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
493: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
494: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
495: * @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
496: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

489: /*#
490: * Use this procedure to define Alternate Resources for an existing Route-Resource Requirement.
491: * @param p_api_version API Version Number.
492: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
493: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
494: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
495: * @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
496: * @param p_module_type For Internal use only, should always be NULL, default value NULL
497: * @param x_return_status API Return status. Standard API parameter

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

490: * Use this procedure to define Alternate Resources for an existing Route-Resource Requirement.
491: * @param p_api_version API Version Number.
492: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
493: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
494: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
495: * @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
496: * @param p_module_type For Internal use only, should always be NULL, default value NULL
497: * @param x_return_status API Return status. Standard API parameter
498: * @param x_msg_count API Return message count, if any. Standard API parameter

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

493: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
494: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
495: * @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
496: * @param p_module_type For Internal use only, should always be NULL, default value NULL
497: * @param x_return_status API Return status. Standard API parameter
498: * @param x_msg_count API Return message count, if any. Standard API parameter
499: * @param x_msg_data API Return message data, if any. Standard API parameter
500: * @param p_route_number Route number of the Route to which the resource is associated
501: * @param p_route_revision Route revision of the Route to which the resource is associated

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

494: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
495: * @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
496: * @param p_module_type For Internal use only, should always be NULL, default value NULL
497: * @param x_return_status API Return status. Standard API parameter
498: * @param x_msg_count API Return message count, if any. Standard API parameter
499: * @param x_msg_data API Return message data, if any. Standard API parameter
500: * @param p_route_number Route number of the Route to which the resource is associated
501: * @param p_route_revision Route revision of the Route to which the resource is associated
502: * @param p_route_id Route id of the Route to which the resource is associated

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

495: * @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
496: * @param p_module_type For Internal use only, should always be NULL, default value NULL
497: * @param x_return_status API Return status. Standard API parameter
498: * @param x_msg_count API Return message count, if any. Standard API parameter
499: * @param x_msg_data API Return message data, if any. Standard API parameter
500: * @param p_route_number Route number of the Route to which the resource is associated
501: * @param p_route_revision Route revision of the Route to which the resource is associated
502: * @param p_route_id Route id of the Route to which the resource is associated
503: * @param p_resource_id Resource Id of the resource to be associated

Line 512: -- standard IN params

508: * @rep:displayname Process Route Alternate Resource
509: */
510: PROCEDURE Process_Route_Alt_Resources
511: (
512: -- standard IN params
513: p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
515: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
516: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 519: -- standard OUT params

515: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
516: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
517: p_default IN VARCHAR2 :=FND_API.G_FALSE,
518: p_module_type IN VARCHAR2 :=NULL,
519: -- standard OUT params
520: x_return_status OUT NOCOPY VARCHAR2,
521: x_msg_count OUT NOCOPY NUMBER,
522: x_msg_data OUT NOCOPY VARCHAR2,
523: -- procedure params