1 PACKAGE WIP_EAM_WORKREQUEST_PUB AUTHID CURRENT_USER AS
2 /* $Header: WIPPWRPS.pls 120.0.12020000.2 2013/02/19 07:20:31 vboddapa ship $ */
3 /*#
4 * This package is used for importing the Work Requests.
5 * This is actually a public script to create and update work request with validations.
6 * It defines 1 key procedure work_request_import
7 * which first validates and massages the IN parameters
8 * and then carries out the respective operations.
9 * @rep:scope public
10 * @rep:product EAM
11 * @rep:lifecycle active
12 * @rep:displayname Work Request Import
13 * @rep:category BUSINESS_ENTITY EAM_WORK_REQUEST
14 */
15
16 -- Start of comments
17 -- API name : WIP_EAM_WORKREQUEST_PUB
18 -- Type : Public
19 -- Function :
20 -- Pre-reqs : None.
21 -- Parameters :
22 -- IN p_api_version IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Optional
24 -- Default = FND_API.G_FALSE
25 -- p_commit IN VARCHAR2 Optional
26 -- Default = FND_API.G_FALSE
27 -- p_validation_level IN NUMBER Optional
28 -- Default = FND_API.G_VALID_LEVEL_FULL
29 -- p_work_request_record_type IN record
30 -- OUT x_return_status OUT VARCHAR2(1)
31 -- x_msg_count OUT NUMBER
32 -- x_msg_data OUT VARCHAR2(2000)
33 --
34 -- Version Current version 115.0
35 --
36 -- Notes : public script to create and update work request with validations
37 --
38 -- End of comments
39
40 /*#
41 * This procedure creates or updates the work request based on the parameter p_mode
42 * @param p_api_version Version of the API
43 * @param p_init_msg_list Flag to indicate initialization of message list
44 * @param p_commit Flag to indicate whether API should commit changes
45 * @param p_validation_level Validation Level of the API
46 * @param x_return_status Return status of the procedure call
47 * @param x_msg_count Count of the return messages that API returns
48 * @param x_msg_data The collection of the messages.
49 * @param p_mode The flag indicating the operation is CREATE or UPDATE
50 * @param p_work_request_rec This is a PL QL record type, it is a ROWTYPE of WIP_EAM_WORK_REQUESTS table
51 * @param p_request_log This is a reqest log for the current work request, if this is null, it is same as the work request description
52 * @param p_user_id The user who creates / updates the work request
53 * @param x_work_request_id This is the unique identifier of newly created work request record.
54 * @scope public
55 * @rep:displayname Create / Update Work Request
56 */
57
58 procedure work_request_import
59 (
60 p_api_version in NUMBER := 1.0,
61 p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
62 p_commit in VARCHAR2 := FND_API.G_TRUE,
63 p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 p_mode in VARCHAR2,
65 p_work_request_rec in WIP_EAM_WORK_REQUESTS%ROWTYPE,
66 p_request_log in VARCHAR2,
67 p_user_id in NUMBER,
68 x_work_request_id out NOCOPY NUMBER,
69 x_return_status out NOCOPY VARCHAR2,
70 x_msg_count out NOCOPY NUMBER,
71 x_msg_data out NOCOPY VARCHAR2
72 );
73
74 end WIP_EAM_WORKREQUEST_PUB;