The following lines contain the word 'select', 'insert', 'update' or 'delete':
create, update and delete resource salesrep territories from other modules.
Its main procedures are as following:
Create Resource Values
Update Resource Values
Delete Resource Values
Delete All Resource Values
Get Resource Values
Get Resource Param List
Calls to these procedures will invoke procedures from jtf_rs_resource_values_pvt
to do business validations and to do actual inserts, updates and deletes into tables.
******************************************************************************************/
--Package variables
G_PKG_NAME VARCHAR2(30) := 'JTF_RESOURCE_PARAMS_PUB';
PROCEDURE UPDATE_RS_RESOURCE_VALUES(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_resource_param_value_id IN NUMBER,
p_resource_id IN NUMBER,
p_resource_param_id IN NUMBER,
p_value IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
p_value_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
p_object_version_number IN OUT NOCOPY JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RS_RESOURCE_VALUES';
SAVEPOINT update_rs_resource_values_pub;
SELECT resource_param_value_id
INTO l_resource_param_value_id
FROM jtf_rs_resource_values
WHERE resource_id = l_resource_id
AND resource_param_id = l_resource_param_id
AND value_type = l_value_type;
jtf_rs_resource_values_pvt.update_rs_resource_values(
P_API_VERSION => 1,
P_INIT_MSG_LIST => fnd_api.g_false,
P_COMMIT => fnd_api.g_false,
p_resource_param_value_id => l_resource_param_value_id,
p_value => l_value,
p_object_version_number => l_object_version_number,
X_RETURN_STATUS => x_return_status,
X_MSG_COUNT => x_msg_count,
X_MSG_DATA => x_msg_data
);
ROLLBACK TO update_rs_resource_values_pub;
ROLLBACK TO update_rs_resource_values_pub;
END update_rs_resource_values;
/* Procedure to Delete Resource Values based on the
input values provided by the calling routines */
PROCEDURE DELETE_RS_RESOURCE_VALUES(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_resource_param_value_id IN NUMBER,
p_object_version_number IN JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RS_RESOURCE_VALUES';
SAVEPOINT delete_rs_resource_values_pub;
jtf_rs_resource_values_pvt.delete_rs_resource_values(
P_API_VERSION => 1,
P_INIT_MSG_LIST => fnd_api.g_false,
P_COMMIT => fnd_api.g_false,
P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
P_OBJECT_VERSION_NUMBER => l_object_version_number,
X_RETURN_STATUS => x_return_status,
X_MSG_COUNT => x_msg_count,
X_MSG_DATA => x_msg_data
);
ROLLBACK TO delete_rs_resource_values_pub;
ROLLBACK TO delete_rs_resource_values_pub;
END delete_rs_resource_values;
/* Procedure to Delete all Resource Values based on the
Resource Id provided by the calling routines */
PROCEDURE DELETE_ALL_RS_RESOURCE_VALUES(
P_Api_Version IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_resource_id IN NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ALL_RS_RESOURCE_VALUES';
SAVEPOINT delete_all_rs_values_pub;
jtf_rs_resource_values_pvt.delete_all_rs_resource_values(
P_API_VERSION => 1,
P_INIT_MSG_LIST => fnd_api.g_false,
P_COMMIT => fnd_api.g_false,
P_RESOURCE_ID => l_resource_id,
X_RETURN_STATUS => x_return_status,
X_MSG_COUNT => x_msg_count,
X_MSG_DATA => x_msg_data
);
ROLLBACK TO delete_all_rs_values_pub;
ROLLBACK TO delete_all_rs_values_pub;
END delete_all_rs_resource_values;