23: -- Function : API to create Operation and its associations to documents, resources,
24: -- resource costing parameters, access panels and materials.
25: -- Pre-reqs :
26: --
27: -- Standard IN Parameters :
28: -- p_api_version IN NUMBER Required, default 1.0
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
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: --
50: -- End of Comments --
51: /*#
52: * Use this procedure to create an Operation and optionally, create associated document references, resource requirements, resource costing parameters and material requirements.
53: * @param p_api_version API Version Number.
54: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
55: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
56: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
57: * @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
58: * @param p_module_type For Internal use only, should always be NULL, default value NULL
51: /*#
52: * Use this procedure to create an Operation and optionally, create associated document references, resource requirements, resource costing parameters and material requirements.
53: * @param p_api_version API Version Number.
54: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
55: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
56: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
57: * @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
58: * @param p_module_type For Internal use only, should always be NULL, default value NULL
59: * @param x_return_status API Return status. Standard API parameter
52: * Use this procedure to create an Operation and optionally, create associated document references, resource requirements, resource costing parameters and material requirements.
53: * @param p_api_version API Version Number.
54: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
55: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
56: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
57: * @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
58: * @param p_module_type For Internal use only, should always be NULL, default value NULL
59: * @param x_return_status API Return status. Standard API parameter
60: * @param x_msg_count API Return message count, if any. Standard API parameter
55: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
56: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
57: * @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
58: * @param p_module_type For Internal use only, should always be NULL, default value NULL
59: * @param x_return_status API Return status. Standard API parameter
60: * @param x_msg_count API Return message count, if any. Standard API parameter
61: * @param x_msg_data API Return message data, if any. Standard API parameter
62: * @param p_x_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
63: * @param p_x_oper_doc_tbl Table of Documents of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Operation
56: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
57: * @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
58: * @param p_module_type For Internal use only, should always be NULL, default value NULL
59: * @param x_return_status API Return status. Standard API parameter
60: * @param x_msg_count API Return message count, if any. Standard API parameter
61: * @param x_msg_data API Return message data, if any. Standard API parameter
62: * @param p_x_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
63: * @param p_x_oper_doc_tbl Table of Documents of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Operation
64: * @param p_x_oper_resource_tbl Table of Resource Requirements of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Operation
57: * @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
58: * @param p_module_type For Internal use only, should always be NULL, default value NULL
59: * @param x_return_status API Return status. Standard API parameter
60: * @param x_msg_count API Return message count, if any. Standard API parameter
61: * @param x_msg_data API Return message data, if any. Standard API parameter
62: * @param p_x_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
63: * @param p_x_oper_doc_tbl Table of Documents of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Operation
64: * @param p_x_oper_resource_tbl Table of Resource Requirements of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Operation
65: * @param p_x_oper_material_tbl Table of Material Requirements of type AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type that need to be associated to the Operation
69: * @rep:displayname Create Operation
70: */
71: PROCEDURE Create_Operation
72: (
73: -- standard IN params
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
76: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
77: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
76: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
77: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
78: p_default IN VARCHAR2 :=FND_API.G_FALSE,
79: p_module_type IN VARCHAR2 :=NULL,
80: -- standard OUT params
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: -- procedure params
96: -- Function : API to modify Operation details and its associations to documents, resources,
97: -- resource costing parameters, access panels and materials.
98: -- Pre-reqs :
99: --
100: -- Standard IN Parameters :
101: -- p_api_version IN NUMBER Required, default 1.0
102: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
103: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
104: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
105: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
106: -- p_module_type IN VARCHAR2 Required, default NULL
107:
108: -- Standard OUT Parameters :
109: -- x_return_status OUT VARCHAR2 Required
110: -- x_msg_count OUT NUMBER Required
111: -- x_msg_data OUT VARCHAR2 Required
112: --
123: -- End of Comments --
124: /*#
125: * Use this procedure to modify an Operation and optionally, create, modify and delete associated document references, resource requirements, resource costing parameters and material requirements.
126: * @param p_api_version API Version Number.
127: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
128: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
129: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
130: * @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
131: * @param p_module_type For Internal use only, should always be NULL, default value NULL
124: /*#
125: * Use this procedure to modify an Operation and optionally, create, modify and delete associated document references, resource requirements, resource costing parameters and material requirements.
126: * @param p_api_version API Version Number.
127: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
128: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
129: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
130: * @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
131: * @param p_module_type For Internal use only, should always be NULL, default value NULL
132: * @param x_return_status API Return status. Standard API parameter
125: * Use this procedure to modify an Operation and optionally, create, modify and delete associated document references, resource requirements, resource costing parameters and material requirements.
126: * @param p_api_version API Version Number.
127: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
128: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
129: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
130: * @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
131: * @param p_module_type For Internal use only, should always be NULL, default value NULL
132: * @param x_return_status API Return status. Standard API parameter
133: * @param x_msg_count API Return message count, if any. Standard API parameter
128: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
129: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
130: * @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
131: * @param p_module_type For Internal use only, should always be NULL, default value NULL
132: * @param x_return_status API Return status. Standard API parameter
133: * @param x_msg_count API Return message count, if any. Standard API parameter
134: * @param x_msg_data API Return message data, if any. Standard API parameter
135: * @param p_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
136: * @param p_x_oper_doc_tbl Table of Documents of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Operation
129: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
130: * @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
131: * @param p_module_type For Internal use only, should always be NULL, default value NULL
132: * @param x_return_status API Return status. Standard API parameter
133: * @param x_msg_count API Return message count, if any. Standard API parameter
134: * @param x_msg_data API Return message data, if any. Standard API parameter
135: * @param p_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
136: * @param p_x_oper_doc_tbl Table of Documents of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Operation
137: * @param p_x_oper_resource_tbl Table of Resource Requirements of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Operation
130: * @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
131: * @param p_module_type For Internal use only, should always be NULL, default value NULL
132: * @param x_return_status API Return status. Standard API parameter
133: * @param x_msg_count API Return message count, if any. Standard API parameter
134: * @param x_msg_data API Return message data, if any. Standard API parameter
135: * @param p_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
136: * @param p_x_oper_doc_tbl Table of Documents of type AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl that need to be associated to the Operation
137: * @param p_x_oper_resource_tbl Table of Resource Requirements of type AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type that need to be associated to the Operation
138: * @param p_x_oper_material_tbl Table of Material Requirements of type AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type that need to be associated to the Operation
142: * @rep:displayname Modify Operation
143: */
144: PROCEDURE Modify_Operation
145: (
146: -- standard IN params
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
149: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
150: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
149: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
150: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
151: p_default IN VARCHAR2 :=FND_API.G_FALSE,
152: p_module_type IN VARCHAR2 :=NULL,
153: -- standard OUT params
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: -- procedure params
169: -- Function : API to deletion of operations. All associations to documents, resources,
170: -- resource costing parameters and materials are also deleted.
171: -- Pre-reqs :
172: --
173: -- Standard IN Parameters :
174: -- p_api_version IN NUMBER Required, default 1.0
175: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
176: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
177: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
178: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
179: -- p_module_type IN VARCHAR2 Required, default NULL
180:
181: -- Standard OUT Parameters :
182: -- x_return_status OUT VARCHAR2 Required
183: -- x_msg_count OUT NUMBER Required
184: -- x_msg_data OUT VARCHAR2 Required
185: --
195: -- End of Comments --
196: /*#
197: * Use this procedure to delete an Operation. All associations to documents, resource requirements, resource costing parameters and material requirements are deleted.
198: * @param p_api_version API Version Number.
199: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
200: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
201: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
202: * @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
203: * @param p_module_type For Internal use only, should always be NULL, default value NULL
196: /*#
197: * Use this procedure to delete an Operation. All associations to documents, resource requirements, resource costing parameters and material requirements are deleted.
198: * @param p_api_version API Version Number.
199: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
200: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
201: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
202: * @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
203: * @param p_module_type For Internal use only, should always be NULL, default value NULL
204: * @param x_return_status API Return status. Standard API parameter
197: * Use this procedure to delete an Operation. All associations to documents, resource requirements, resource costing parameters and material requirements are deleted.
198: * @param p_api_version API Version Number.
199: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
200: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
201: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
202: * @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
203: * @param p_module_type For Internal use only, should always be NULL, default value NULL
204: * @param x_return_status API Return status. Standard API parameter
205: * @param x_msg_count API Return message count, if any. Standard API parameter
200: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
201: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
202: * @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
203: * @param p_module_type For Internal use only, should always be NULL, default value NULL
204: * @param x_return_status API Return status. Standard API parameter
205: * @param x_msg_count API Return message count, if any. Standard API parameter
206: * @param x_msg_data API Return message data, if any. Standard API parameter
207: * @param p_oper_id Operation unique identifier
208: * @param p_oper_number Operation number
201: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
202: * @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
203: * @param p_module_type For Internal use only, should always be NULL, default value NULL
204: * @param x_return_status API Return status. Standard API parameter
205: * @param x_msg_count API Return message count, if any. Standard API parameter
206: * @param x_msg_data API Return message data, if any. Standard API parameter
207: * @param p_oper_id Operation unique identifier
208: * @param p_oper_number Operation number
209: * @param p_oper_revision Operation revision number
202: * @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
203: * @param p_module_type For Internal use only, should always be NULL, default value NULL
204: * @param x_return_status API Return status. Standard API parameter
205: * @param x_msg_count API Return message count, if any. Standard API parameter
206: * @param x_msg_data API Return message data, if any. Standard API parameter
207: * @param p_oper_id Operation unique identifier
208: * @param p_oper_number Operation number
209: * @param p_oper_revision Operation revision number
210: * @param p_oper_object_version Operation object version number
213: * @rep:displayname Delete Operation
214: */
215: PROCEDURE Delete_Operation
216: (
217: -- standard IN params
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
220: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
221: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
220: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
221: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
222: p_default IN VARCHAR2 :=FND_API.G_FALSE,
223: p_module_type IN VARCHAR2 :=NULL,
224: -- standard OUT params
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: -- procedure params
238: -- Type : Public
239: -- Function : API to create a new revision of a Operation.
240: -- Pre-reqs :
241: --
242: -- Standard IN Parameters :
243: -- p_api_version IN NUMBER Required, default 1.0
244: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
246: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
247: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
248: -- p_module_type IN VARCHAR2 Required, default NULL
249:
250: -- Standard OUT Parameters :
251: -- x_return_status OUT VARCHAR2 Required
252: -- x_msg_count OUT NUMBER Required
253: -- x_msg_data OUT VARCHAR2 Required
254: --
265: -- End of Comments --
266: /*#
267: * Use this procedure to create a new revision of an existing and completed Operation.
268: * @param p_api_version API Version Number.
269: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
270: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
271: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
272: * @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
273: * @param p_module_type For Internal use only, should always be NULL, default value NULL
266: /*#
267: * Use this procedure to create a new revision of an existing and completed Operation.
268: * @param p_api_version API Version Number.
269: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
270: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
271: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
272: * @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
273: * @param p_module_type For Internal use only, should always be NULL, default value NULL
274: * @param x_return_status API Return status. Standard API parameter
267: * Use this procedure to create a new revision of an existing and completed Operation.
268: * @param p_api_version API Version Number.
269: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
270: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
271: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
272: * @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
273: * @param p_module_type For Internal use only, should always be NULL, default value NULL
274: * @param x_return_status API Return status. Standard API parameter
275: * @param x_msg_count API Return message count, if any. Standard API parameter
270: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
271: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
272: * @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
273: * @param p_module_type For Internal use only, should always be NULL, default value NULL
274: * @param x_return_status API Return status. Standard API parameter
275: * @param x_msg_count API Return message count, if any. Standard API parameter
276: * @param x_msg_data API Return message data, if any. Standard API parameter
277: * @param p_oper_id Operation unique identifier
278: * @param p_oper_number Operation number
271: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
272: * @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
273: * @param p_module_type For Internal use only, should always be NULL, default value NULL
274: * @param x_return_status API Return status. Standard API parameter
275: * @param x_msg_count API Return message count, if any. Standard API parameter
276: * @param x_msg_data API Return message data, if any. Standard API parameter
277: * @param p_oper_id Operation unique identifier
278: * @param p_oper_number Operation number
279: * @param p_oper_revision Operation revision number
272: * @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
273: * @param p_module_type For Internal use only, should always be NULL, default value NULL
274: * @param x_return_status API Return status. Standard API parameter
275: * @param x_msg_count API Return message count, if any. Standard API parameter
276: * @param x_msg_data API Return message data, if any. Standard API parameter
277: * @param p_oper_id Operation unique identifier
278: * @param p_oper_number Operation number
279: * @param p_oper_revision Operation revision number
280: * @param p_oper_object_version Operation object version number
284: * @rep:displayname Create Operation Revision
285: */
286: PROCEDURE Create_Oper_Revision
287: (
288: -- standard IN params
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
291: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
292: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
291: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
292: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
293: p_default IN VARCHAR2 :=FND_API.G_FALSE,
294: p_module_type IN VARCHAR2 :=NULL,
295: -- standard OUT params
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: -- procedure params
310: -- Type : Public
311: -- Function : API to submit a Operation to complete / terminate approval workflows.
312: -- Pre-reqs :
313: --
314: -- Standard IN Parameters :
315: -- p_api_version IN NUMBER Required, default 1.0
316: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
317: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
318: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
318: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
319: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
320: -- p_module_type IN VARCHAR2 Required, default NULL
321:
322: -- Standard OUT Parameters :
323: -- x_return_status OUT VARCHAR2 Required
324: -- x_msg_count OUT NUMBER Required
325: -- x_msg_data OUT VARCHAR2 Required
326: --
337: -- End of Comments --
338: /*#
339: * Use this procedure to submit an Operation for Completion or Termination approval workflows.
340: * @param p_api_version API Version Number.
341: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
342: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
343: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
344: * @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
345: * @param p_module_type For Internal use only, should always be NULL, default value NULL
338: /*#
339: * Use this procedure to submit an Operation for Completion or Termination approval workflows.
340: * @param p_api_version API Version Number.
341: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
342: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
343: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
344: * @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
345: * @param p_module_type For Internal use only, should always be NULL, default value NULL
346: * @param x_return_status API Return status. Standard API parameter
339: * Use this procedure to submit an Operation for Completion or Termination approval workflows.
340: * @param p_api_version API Version Number.
341: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
342: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
343: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
344: * @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
345: * @param p_module_type For Internal use only, should always be NULL, default value NULL
346: * @param x_return_status API Return status. Standard API parameter
347: * @param x_msg_count API Return message count, if any. Standard API parameter
342: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
343: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
344: * @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
345: * @param p_module_type For Internal use only, should always be NULL, default value NULL
346: * @param x_return_status API Return status. Standard API parameter
347: * @param x_msg_count API Return message count, if any. Standard API parameter
348: * @param x_msg_data API Return message data, if any. Standard API parameter
349: * @param p_oper_id Operation unique identifier
350: * @param p_oper_number Operation number
343: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
344: * @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
345: * @param p_module_type For Internal use only, should always be NULL, default value NULL
346: * @param x_return_status API Return status. Standard API parameter
347: * @param x_msg_count API Return message count, if any. Standard API parameter
348: * @param x_msg_data API Return message data, if any. Standard API parameter
349: * @param p_oper_id Operation unique identifier
350: * @param p_oper_number Operation number
351: * @param p_oper_revision Operation revision number
344: * @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
345: * @param p_module_type For Internal use only, should always be NULL, default value NULL
346: * @param x_return_status API Return status. Standard API parameter
347: * @param x_msg_count API Return message count, if any. Standard API parameter
348: * @param x_msg_data API Return message data, if any. Standard API parameter
349: * @param p_oper_id Operation unique identifier
350: * @param p_oper_number Operation number
351: * @param p_oper_revision Operation revision number
352: * @param p_oper_object_version Operation object version number
356: * @rep:displayname Initiate Operation Approval
357: */
358: PROCEDURE Initiate_Oper_Approval
359: (
360: -- standard IN params
361: p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
363: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
364: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
363: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
364: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
365: p_default IN VARCHAR2 :=FND_API.G_FALSE,
366: p_module_type IN VARCHAR2 :=NULL,
367: -- standard OUT params
368: x_return_status OUT NOCOPY VARCHAR2,
369: x_msg_count OUT NOCOPY NUMBER,
370: x_msg_data OUT NOCOPY VARCHAR2,
371: -- procedure params
382: -- Type : Public
383: -- Function : API to process alternate resources for operations.
384: -- Pre-reqs :
385: --
386: -- Standard IN Parameters :
387: -- p_api_version IN NUMBER Required, default 1.0
388: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
389: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
390: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
390: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
391: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
392: -- p_module_type IN VARCHAR2 Required, default NULL
393:
394: -- Standard OUT Parameters :
395: -- x_return_status OUT VARCHAR2 Required
396: -- x_msg_count OUT NUMBER Required
397: -- x_msg_data OUT VARCHAR2 Required
398: --
410: -- End of Comments --
411: /*#
412: * Use this procedure to define Alternate Resources for an existing Operation-Resource Requirement.
413: * @param p_api_version API Version Number.
414: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
415: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
416: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
417: * @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
418: * @param p_module_type For Internal use only, should always be NULL, default value NULL
411: /*#
412: * Use this procedure to define Alternate Resources for an existing Operation-Resource Requirement.
413: * @param p_api_version API Version Number.
414: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
415: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
416: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
417: * @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
418: * @param p_module_type For Internal use only, should always be NULL, default value NULL
419: * @param x_return_status API Return status. Standard API parameter
412: * Use this procedure to define Alternate Resources for an existing Operation-Resource Requirement.
413: * @param p_api_version API Version Number.
414: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
415: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
416: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
417: * @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
418: * @param p_module_type For Internal use only, should always be NULL, default value NULL
419: * @param x_return_status API Return status. Standard API parameter
420: * @param x_msg_count API Return message count, if any. Standard API parameter
415: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
416: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
417: * @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
418: * @param p_module_type For Internal use only, should always be NULL, default value NULL
419: * @param x_return_status API Return status. Standard API parameter
420: * @param x_msg_count API Return message count, if any. Standard API parameter
421: * @param x_msg_data API Return message data, if any. Standard API parameter
422: * @param p_operation_number Operation number of the Operation to which the resource is associated
423: * @param p_operation_revision Operation revision of the Operation to which the resource is associated
416: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
417: * @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
418: * @param p_module_type For Internal use only, should always be NULL, default value NULL
419: * @param x_return_status API Return status. Standard API parameter
420: * @param x_msg_count API Return message count, if any. Standard API parameter
421: * @param x_msg_data API Return message data, if any. Standard API parameter
422: * @param p_operation_number Operation number of the Operation to which the resource is associated
423: * @param p_operation_revision Operation revision of the Operation to which the resource is associated
424: * @param p_operation_id Operation id of the Operation to which the resource is associated
417: * @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
418: * @param p_module_type For Internal use only, should always be NULL, default value NULL
419: * @param x_return_status API Return status. Standard API parameter
420: * @param x_msg_count API Return message count, if any. Standard API parameter
421: * @param x_msg_data API Return message data, if any. Standard API parameter
422: * @param p_operation_number Operation number of the Operation to which the resource is associated
423: * @param p_operation_revision Operation revision of the Operation to which the resource is associated
424: * @param p_operation_id Operation id of the Operation to which the resource is associated
425: * @param p_resource_id Resource Id of the resource to be associated
430: * @rep:displayname Process Operation Alternate Resource
431: */
432: PROCEDURE Process_Oper_Alt_Resources
433: (
434: -- standard IN params
435: p_api_version IN NUMBER,
436: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
437: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
438: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
437: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
438: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
439: p_default IN VARCHAR2 :=FND_API.G_FALSE,
440: p_module_type IN VARCHAR2 :=NULL,
441: -- standard OUT params
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,
445: -- procedure params