1 PACKAGE jtf_rs_update_location_pub AS
2 /* $Header: jtfrsugs.pls 120.0 2005/05/11 08:22:46 appldev ship $ */
3 /*#
4 * Resource Location Update API
5 * This API contains the procedure to update the Resource record with the location.
6 * @rep:scope internal
7 * @rep:product JTF
8 * @rep:displayname Resource Location Update API
9 * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE
10 */
11
12 /*#
13 * Update Resource Location API
14 * This procedure allows the user to update a resource record with the location.
15 * @param p_api_version API version
16 * @param p_init_msg_list Initialization of the message list
17 * @param p_commit Commit
18 * @param p_resource_id Resource Identifier
19 * @param p_location Resource Location
20 * @param p_object_version_num The object version number of the resource derives from the jtf_rs_resource_extns table.
21 * @param x_return_status Output parameter for return status
22 * @param x_msg_count Output parameter for number of user messages from this procedure
23 * @param x_msg_data Output parameter containing last user message from this procedure
24 * @rep:scope internal
25 * @rep:lifecycle active
26 * @rep:displayname Update Resource Location API
27 */
28 PROCEDURE update_resource
29 (P_API_VERSION IN NUMBER,
30 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
31 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
32 P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
33 P_LOCATION IN MDSYS.SDO_GEOMETRY ,
34 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
35 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36 X_MSG_COUNT OUT NOCOPY NUMBER,
37 X_MSG_DATA OUT NOCOPY VARCHAR2
38 );
39
40
41 END jtf_rs_update_location_pub;