APPS.JTF_RS_UPDATE_LOCATION_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 9: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,

5: PROCEDURE update_resource
6: (P_API_VERSION IN NUMBER,
7: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
10: P_LOCATION IN MDSYS.SDO_GEOMETRY ,
11: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
12: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
13: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 11: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,

7: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
10: P_LOCATION IN MDSYS.SDO_GEOMETRY ,
11: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
12: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
13: X_MSG_COUNT OUT NOCOPY NUMBER,
14: X_MSG_DATA OUT NOCOPY VARCHAR2
15: )

Line 27: from jtf_rs_resource_extns

23: cursor res_cur
24: is
25: select resource_id,
26: object_version_number
27: from jtf_rs_resource_extns
28: where resource_id = p_resource_id;
29:
30: res_rec res_cur%rowtype;
31:

Line 71: jtf_rs_resource_extns_pkg.lock_row(

67: RAISE fnd_api.g_exc_error;
68: else
69:
70: BEGIN
71: jtf_rs_resource_extns_pkg.lock_row(
72: x_resource_id => p_resource_id,
73: x_object_version_number => p_object_version_num
74: );
75:

Line 83: update jtf_rs_resource_extns

79: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
80: fnd_msg_pub.add;
81: RAISE fnd_api.g_exc_unexpected_error;
82: END;
83: update jtf_rs_resource_extns
84: set location = p_location,
85: object_version_number = object_version_number + 1
86: where resource_id = p_resource_id;
87: