The following lines contain the word 'select', 'insert', 'update' or 'delete':
/*** found item -> delete from array and return TRUE ***/
p_pubitems_tbl.DELETE( l_index );
procedures which will insert the data that came from mobile into the backend tables using public APIs.
***/
PROCEDURE APPLY_CLIENT_CHANGES
(
p_user_name IN VARCHAR2,
p_tranid IN NUMBER
) IS
l_pubitems_tbl asg_apply.vc2_tbl_type;
applied and needs to be deleted from the in-queue.
***/
PROCEDURE DELETE_RECORD
(
p_user_name IN VARCHAR2,
p_tranid IN NUMBER,
p_seqno IN NUMBER,
p_pk IN VARCHAR2,
p_object_name IN VARCHAR2,
p_pub_name IN VARCHAR2,
p_error_msg OUT NOCOPY VARCHAR2,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
BEGIN
x_return_status := FND_API.G_RET_STS_SUCCESS;
, v_message => 'Entering ' || g_object_name || '.DELETE_RECORD'
, v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
asg_apply.delete_row(p_user_name,
p_tranid,
p_pub_name,
p_seqno,
x_return_status);
fnd_msg_pub.Add_Exc_Msg( g_object_name, 'DELETE_RECORD', 'Unknown error');
, v_message => 'Leaving ' || g_object_name || '.DELETE_RECORD'
, v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
, v_message => 'Exception occurred in DELETE_RECORD:' || fnd_global.local_chr(10) || sqlerrm
, v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
fnd_msg_pub.Add_Exc_Msg( g_object_name, 'DELETE_RECORD', sqlerrm);
, v_message => 'Leaving ' || g_object_name || '.DELETE_RECORD'
, v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
END DELETE_RECORD;
/*** defer successful -> reject record except for updates ***/
IF p_dml_type = 'I' THEN
IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
jtm_message_log_pkg.Log_Msg
( v_object_id => p_pk
, v_object_name => p_object_name
, v_message => 'Rejecting record'
, v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
SELECT RESOURCE_ID
FROM ASG_USER
WHERE USER_ID = b_user_id;
This procedure gets called when a user gets deleted
***/
PROCEDURE DELETE_ACCESS_RECORDS ( P_USER_ID IN NUMBER )
IS
PRAGMA AUTONOMOUS_TRANSACTION;
SELECT RESOURCE_ID
FROM ASG_USER
WHERE USER_ID = b_user_id;
CSL_USER_PKG.DELETE_USER( P_RESOURCE_ID => r_user.RESOURCE_ID
, X_RETURN_STATUS => x_status);
/*** if delete user returned error then raise exception ***/
IF x_status <> FND_API.G_RET_STS_SUCCESS THEN
ROLLBACK;
END DELETE_ACCESS_RECORDS;