DBA Data[Home] [Help]

APPS.AHL_RM_OPERATION_PUB dependencies on STANDARD

Line 27: -- Standard IN Parameters :

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 (=2.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

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 54: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE

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 (=2.0).
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

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

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 (=2.0).
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

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

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 (=2.0).
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

Line 59: * @param x_return_status API Return status. 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

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

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

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

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

Line 73: -- standard IN params

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,

Line 80: -- standard OUT params

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

Line 96: -- standard IN params

92: -- Overloaded procedure retained for backaward compatibility (pre 12.0.4).
93: -- This procedure will call the above procedure with api_version = 2.
94: PROCEDURE Create_Operation
95: (
96: -- standard IN params
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
99: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
100: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 103: -- standard OUT params

99: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
100: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
101: p_default IN VARCHAR2 :=FND_API.G_FALSE,
102: p_module_type IN VARCHAR2 :=NULL,
103: -- standard OUT params
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: -- procedure params

Line 122: -- Standard IN Parameters :

118: -- Function : API to modify Operation details and its associations to documents, resources,
119: -- resource costing parameters, access panels and materials.
120: -- Pre-reqs :
121: --
122: -- Standard IN Parameters :
123: -- p_api_version IN NUMBER Required (=2.0)
124: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
125: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 130: -- Standard OUT Parameters :

126: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
127: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
128: -- p_module_type IN VARCHAR2 Required, default NULL
129:
130: -- Standard OUT Parameters :
131: -- x_return_status OUT VARCHAR2 Required
132: -- x_msg_count OUT NUMBER Required
133: -- x_msg_data OUT VARCHAR2 Required
134: --

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

145: -- End of Comments --
146: /*#
147: * Use this procedure to modify an Operation and optionally, create, modify and delete associated document references, resource requirements, resource costing parameters and material requirements.
148: * @param p_api_version API Version Number (=2.0).
149: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
150: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
151: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
152: * @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
153: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

146: /*#
147: * Use this procedure to modify an Operation and optionally, create, modify and delete associated document references, resource requirements, resource costing parameters and material requirements.
148: * @param p_api_version API Version Number (=2.0).
149: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
150: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
151: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
152: * @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
153: * @param p_module_type For Internal use only, should always be NULL, default value NULL
154: * @param x_return_status API Return status. Standard API parameter

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

147: * Use this procedure to modify an Operation and optionally, create, modify and delete associated document references, resource requirements, resource costing parameters and material requirements.
148: * @param p_api_version API Version Number (=2.0).
149: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
150: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
151: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
152: * @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
153: * @param p_module_type For Internal use only, should always be NULL, default value NULL
154: * @param x_return_status API Return status. Standard API parameter
155: * @param x_msg_count API Return message count, if any. Standard API parameter

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

150: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
151: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
152: * @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
153: * @param p_module_type For Internal use only, should always be NULL, default value NULL
154: * @param x_return_status API Return status. Standard API parameter
155: * @param x_msg_count API Return message count, if any. Standard API parameter
156: * @param x_msg_data API Return message data, if any. Standard API parameter
157: * @param p_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
158: * @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

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

151: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
152: * @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
153: * @param p_module_type For Internal use only, should always be NULL, default value NULL
154: * @param x_return_status API Return status. Standard API parameter
155: * @param x_msg_count API Return message count, if any. Standard API parameter
156: * @param x_msg_data API Return message data, if any. Standard API parameter
157: * @param p_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
158: * @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
159: * @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

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

152: * @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
153: * @param p_module_type For Internal use only, should always be NULL, default value NULL
154: * @param x_return_status API Return status. Standard API parameter
155: * @param x_msg_count API Return message count, if any. Standard API parameter
156: * @param x_msg_data API Return message data, if any. Standard API parameter
157: * @param p_oper_rec Operation record of type AHL_RM_OPERATION_PVT.operation_rec_type
158: * @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
159: * @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
160: * @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

Line 168: -- standard IN params

164: * @rep:displayname Modify Operation
165: */
166: PROCEDURE Modify_Operation
167: (
168: -- standard IN params
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
171: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
172: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 175: -- standard OUT params

171: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
172: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
173: p_default IN VARCHAR2 :=FND_API.G_FALSE,
174: p_module_type IN VARCHAR2 :=NULL,
175: -- standard OUT params
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: -- procedure params

Line 191: -- standard IN params

187: -- Overloaded procedure retained for backaward compatibility (pre 12.0.4).
188: -- This procedure will call the above procedure with api_version = 2.
189: PROCEDURE Modify_Operation
190: (
191: -- standard IN params
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
194: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
195: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 198: -- standard OUT params

194: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
195: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
196: p_default IN VARCHAR2 :=FND_API.G_FALSE,
197: p_module_type IN VARCHAR2 :=NULL,
198: -- standard OUT params
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: -- procedure params

Line 217: -- Standard IN Parameters :

213: -- Function : API to deletion of operations. All associations to documents, resources,
214: -- resource costing parameters and materials are also deleted.
215: -- Pre-reqs :
216: --
217: -- Standard IN Parameters :
218: -- p_api_version IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
220: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 225: -- Standard OUT Parameters :

221: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
222: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
223: -- p_module_type IN VARCHAR2 Required, default NULL
224:
225: -- Standard OUT Parameters :
226: -- x_return_status OUT VARCHAR2 Required
227: -- x_msg_count OUT NUMBER Required
228: -- x_msg_data OUT VARCHAR2 Required
229: --

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

239: -- End of Comments --
240: /*#
241: * Use this procedure to delete an Operation. All associations to documents, resource requirements, resource costing parameters and material requirements are deleted.
242: * @param p_api_version API Version Number.
243: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
244: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
245: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
246: * @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
247: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

240: /*#
241: * Use this procedure to delete an Operation. All associations to documents, resource requirements, resource costing parameters and material requirements are deleted.
242: * @param p_api_version API Version Number.
243: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
244: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
245: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
246: * @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
247: * @param p_module_type For Internal use only, should always be NULL, default value NULL
248: * @param x_return_status API Return status. Standard API parameter

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

241: * Use this procedure to delete an Operation. All associations to documents, resource requirements, resource costing parameters and material requirements are deleted.
242: * @param p_api_version API Version Number.
243: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
244: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
245: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
246: * @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
247: * @param p_module_type For Internal use only, should always be NULL, default value NULL
248: * @param x_return_status API Return status. Standard API parameter
249: * @param x_msg_count API Return message count, if any. Standard API parameter

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

244: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
245: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
246: * @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
247: * @param p_module_type For Internal use only, should always be NULL, default value NULL
248: * @param x_return_status API Return status. Standard API parameter
249: * @param x_msg_count API Return message count, if any. Standard API parameter
250: * @param x_msg_data API Return message data, if any. Standard API parameter
251: * @param p_oper_id Operation unique identifier
252: * @param p_oper_number Operation number

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

245: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
246: * @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
247: * @param p_module_type For Internal use only, should always be NULL, default value NULL
248: * @param x_return_status API Return status. Standard API parameter
249: * @param x_msg_count API Return message count, if any. Standard API parameter
250: * @param x_msg_data API Return message data, if any. Standard API parameter
251: * @param p_oper_id Operation unique identifier
252: * @param p_oper_number Operation number
253: * @param p_oper_revision Operation revision number

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

246: * @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
247: * @param p_module_type For Internal use only, should always be NULL, default value NULL
248: * @param x_return_status API Return status. Standard API parameter
249: * @param x_msg_count API Return message count, if any. Standard API parameter
250: * @param x_msg_data API Return message data, if any. Standard API parameter
251: * @param p_oper_id Operation unique identifier
252: * @param p_oper_number Operation number
253: * @param p_oper_revision Operation revision number
254: * @param p_oper_object_version Operation object version number

Line 261: -- standard IN params

257: * @rep:displayname Delete Operation
258: */
259: PROCEDURE Delete_Operation
260: (
261: -- standard IN params
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
264: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
265: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 268: -- standard OUT params

264: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
265: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
266: p_default IN VARCHAR2 :=FND_API.G_FALSE,
267: p_module_type IN VARCHAR2 :=NULL,
268: -- standard OUT params
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: -- procedure params

Line 286: -- Standard IN Parameters :

282: -- Type : Public
283: -- Function : API to create a new revision of a Operation.
284: -- Pre-reqs :
285: --
286: -- Standard IN Parameters :
287: -- p_api_version IN NUMBER Required
288: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
289: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
290: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 294: -- Standard OUT Parameters :

290: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
291: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
292: -- p_module_type IN VARCHAR2 Required, default NULL
293:
294: -- Standard OUT Parameters :
295: -- x_return_status OUT VARCHAR2 Required
296: -- x_msg_count OUT NUMBER Required
297: -- x_msg_data OUT VARCHAR2 Required
298: --

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

309: -- End of Comments --
310: /*#
311: * Use this procedure to create a new revision of an existing and completed Operation.
312: * @param p_api_version API Version Number.
313: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
314: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
315: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
316: * @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
317: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

310: /*#
311: * Use this procedure to create a new revision of an existing and completed Operation.
312: * @param p_api_version API Version Number.
313: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
314: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
315: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
316: * @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
317: * @param p_module_type For Internal use only, should always be NULL, default value NULL
318: * @param x_return_status API Return status. Standard API parameter

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

311: * Use this procedure to create a new revision of an existing and completed Operation.
312: * @param p_api_version API Version Number.
313: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
314: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
315: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
316: * @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
317: * @param p_module_type For Internal use only, should always be NULL, default value NULL
318: * @param x_return_status API Return status. Standard API parameter
319: * @param x_msg_count API Return message count, if any. Standard API parameter

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

314: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
315: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
316: * @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
317: * @param p_module_type For Internal use only, should always be NULL, default value NULL
318: * @param x_return_status API Return status. Standard API parameter
319: * @param x_msg_count API Return message count, if any. Standard API parameter
320: * @param x_msg_data API Return message data, if any. Standard API parameter
321: * @param p_oper_id Operation unique identifier
322: * @param p_oper_number Operation number

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

315: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
316: * @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
317: * @param p_module_type For Internal use only, should always be NULL, default value NULL
318: * @param x_return_status API Return status. Standard API parameter
319: * @param x_msg_count API Return message count, if any. Standard API parameter
320: * @param x_msg_data API Return message data, if any. Standard API parameter
321: * @param p_oper_id Operation unique identifier
322: * @param p_oper_number Operation number
323: * @param p_oper_revision Operation revision number

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

316: * @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
317: * @param p_module_type For Internal use only, should always be NULL, default value NULL
318: * @param x_return_status API Return status. Standard API parameter
319: * @param x_msg_count API Return message count, if any. Standard API parameter
320: * @param x_msg_data API Return message data, if any. Standard API parameter
321: * @param p_oper_id Operation unique identifier
322: * @param p_oper_number Operation number
323: * @param p_oper_revision Operation revision number
324: * @param p_oper_object_version Operation object version number

Line 332: -- standard IN params

328: * @rep:displayname Create Operation Revision
329: */
330: PROCEDURE Create_Oper_Revision
331: (
332: -- standard IN params
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
335: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
336: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 339: -- standard OUT params

335: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
336: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
337: p_default IN VARCHAR2 :=FND_API.G_FALSE,
338: p_module_type IN VARCHAR2 :=NULL,
339: -- standard OUT params
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: -- procedure params

Line 358: -- Standard IN Parameters :

354: -- Type : Public
355: -- Function : API to submit a Operation to complete / terminate approval workflows.
356: -- Pre-reqs :
357: --
358: -- Standard IN Parameters :
359: -- p_api_version IN NUMBER Required
360: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
361: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
362: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 366: -- Standard OUT Parameters :

362: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
363: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
364: -- p_module_type IN VARCHAR2 Required, default NULL
365:
366: -- Standard OUT Parameters :
367: -- x_return_status OUT VARCHAR2 Required
368: -- x_msg_count OUT NUMBER Required
369: -- x_msg_data OUT VARCHAR2 Required
370: --

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

381: -- End of Comments --
382: /*#
383: * Use this procedure to submit an Operation for Completion or Termination approval workflows.
384: * @param p_api_version API Version Number.
385: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
386: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
387: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
388: * @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
389: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

382: /*#
383: * Use this procedure to submit an Operation for Completion or Termination approval workflows.
384: * @param p_api_version API Version Number.
385: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
386: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
387: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
388: * @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
389: * @param p_module_type For Internal use only, should always be NULL, default value NULL
390: * @param x_return_status API Return status. Standard API parameter

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

383: * Use this procedure to submit an Operation for Completion or Termination approval workflows.
384: * @param p_api_version API Version Number.
385: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
386: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
387: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
388: * @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
389: * @param p_module_type For Internal use only, should always be NULL, default value NULL
390: * @param x_return_status API Return status. Standard API parameter
391: * @param x_msg_count API Return message count, if any. Standard API parameter

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

386: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
387: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
388: * @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
389: * @param p_module_type For Internal use only, should always be NULL, default value NULL
390: * @param x_return_status API Return status. Standard API parameter
391: * @param x_msg_count API Return message count, if any. Standard API parameter
392: * @param x_msg_data API Return message data, if any. Standard API parameter
393: * @param p_oper_id Operation unique identifier
394: * @param p_oper_number Operation number

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

387: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
388: * @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
389: * @param p_module_type For Internal use only, should always be NULL, default value NULL
390: * @param x_return_status API Return status. Standard API parameter
391: * @param x_msg_count API Return message count, if any. Standard API parameter
392: * @param x_msg_data API Return message data, if any. Standard API parameter
393: * @param p_oper_id Operation unique identifier
394: * @param p_oper_number Operation number
395: * @param p_oper_revision Operation revision number

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

388: * @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
389: * @param p_module_type For Internal use only, should always be NULL, default value NULL
390: * @param x_return_status API Return status. Standard API parameter
391: * @param x_msg_count API Return message count, if any. Standard API parameter
392: * @param x_msg_data API Return message data, if any. Standard API parameter
393: * @param p_oper_id Operation unique identifier
394: * @param p_oper_number Operation number
395: * @param p_oper_revision Operation revision number
396: * @param p_oper_object_version Operation object version number

Line 404: -- standard IN params

400: * @rep:displayname Initiate Operation Approval
401: */
402: PROCEDURE Initiate_Oper_Approval
403: (
404: -- standard IN params
405: p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
407: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
408: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 411: -- standard OUT params

407: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
408: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
409: p_default IN VARCHAR2 :=FND_API.G_FALSE,
410: p_module_type IN VARCHAR2 :=NULL,
411: -- standard OUT params
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: -- procedure params

Line 430: -- Standard IN Parameters :

426: -- Type : Public
427: -- Function : API to process alternate resources for operations.
428: -- Pre-reqs :
429: --
430: -- Standard IN Parameters :
431: -- p_api_version IN NUMBER Required
432: -- p_init_msg_list IN VARCHAR2 Required, default FND_API.G_FALSE
433: -- p_commit IN VARCHAR2 Required, default FND_API.G_FALSE
434: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL

Line 438: -- Standard OUT Parameters :

434: -- p_validation_level IN NUMBER Required, default FND_API.G_VALID_LEVEL_FULL
435: -- p_default IN VARCHAR2 Required, default FND_API.G_FALSE
436: -- p_module_type IN VARCHAR2 Required, default NULL
437:
438: -- Standard OUT Parameters :
439: -- x_return_status OUT VARCHAR2 Required
440: -- x_msg_count OUT NUMBER Required
441: -- x_msg_data OUT VARCHAR2 Required
442: --

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

454: -- End of Comments --
455: /*#
456: * Use this procedure to define Alternate Resources for an existing Operation-Resource Requirement.
457: * @param p_api_version API Version Number.
458: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
459: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
460: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
461: * @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
462: * @param p_module_type For Internal use only, should always be NULL, default value NULL

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

455: /*#
456: * Use this procedure to define Alternate Resources for an existing Operation-Resource Requirement.
457: * @param p_api_version API Version Number.
458: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
459: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
460: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
461: * @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
462: * @param p_module_type For Internal use only, should always be NULL, default value NULL
463: * @param x_return_status API Return status. Standard API parameter

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

456: * Use this procedure to define Alternate Resources for an existing Operation-Resource Requirement.
457: * @param p_api_version API Version Number.
458: * @param p_init_msg_list Initialize the message stack, Standard API parameter, default value FND_API.G_FALSE
459: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
460: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
461: * @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
462: * @param p_module_type For Internal use only, should always be NULL, default value NULL
463: * @param x_return_status API Return status. Standard API parameter
464: * @param x_msg_count API Return message count, if any. Standard API parameter

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

459: * @param p_commit Parameter to decide whether to commit the transaction or not, Standard API parameter, default value FND_API.G_FALSE
460: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
461: * @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
462: * @param p_module_type For Internal use only, should always be NULL, default value NULL
463: * @param x_return_status API Return status. Standard API parameter
464: * @param x_msg_count API Return message count, if any. Standard API parameter
465: * @param x_msg_data API Return message data, if any. Standard API parameter
466: * @param p_operation_number Operation number of the Operation to which the resource is associated
467: * @param p_operation_revision Operation revision of the Operation to which the resource is associated

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

460: * @param p_validation_level Validation level, Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
461: * @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
462: * @param p_module_type For Internal use only, should always be NULL, default value NULL
463: * @param x_return_status API Return status. Standard API parameter
464: * @param x_msg_count API Return message count, if any. Standard API parameter
465: * @param x_msg_data API Return message data, if any. Standard API parameter
466: * @param p_operation_number Operation number of the Operation to which the resource is associated
467: * @param p_operation_revision Operation revision of the Operation to which the resource is associated
468: * @param p_operation_id Operation id of the Operation to which the resource is associated

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

461: * @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
462: * @param p_module_type For Internal use only, should always be NULL, default value NULL
463: * @param x_return_status API Return status. Standard API parameter
464: * @param x_msg_count API Return message count, if any. Standard API parameter
465: * @param x_msg_data API Return message data, if any. Standard API parameter
466: * @param p_operation_number Operation number of the Operation to which the resource is associated
467: * @param p_operation_revision Operation revision of the Operation to which the resource is associated
468: * @param p_operation_id Operation id of the Operation to which the resource is associated
469: * @param p_resource_id Resource Id of the resource to be associated

Line 478: -- standard IN params

474: * @rep:displayname Process Operation Alternate Resource
475: */
476: PROCEDURE Process_Oper_Alt_Resources
477: (
478: -- standard IN params
479: p_api_version IN NUMBER,
480: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
481: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
482: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 485: -- standard OUT params

481: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
482: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
483: p_default IN VARCHAR2 :=FND_API.G_FALSE,
484: p_module_type IN VARCHAR2 :=NULL,
485: -- standard OUT params
486: x_return_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,
488: x_msg_data OUT NOCOPY VARCHAR2,
489: -- procedure params