APPS.ASG_DOWNLOAD dependencies on JTF_RS_RESOURCE_EXTNS

Line 2483: select user_name from jtf_rs_resource_extns

2479: is
2480: select user_id from fnd_user where user_name = p_user_name;
2481: cursor c_chk_jtf_resource(p_res_id number)
2482: is
2483: select user_name from jtf_rs_resource_extns
2484: where resource_id = p_res_id
2485: and ( trunc(END_DATE_ACTIVE) is null
2486: or trunc(END_DATE_ACTIVE) > trunc(sysdate) );
2487: begin

Line 2537: ' record exists in jtf_rs_resource_extns ';

2533: if(l_user_name is null) then
2534: /* Check if a record exists in jtf_rs_res* table with the
2535: same resource_id as asg_user.resource_id*/
2536: l_err_msg := 'For the resource ID '||l_asg_user_rec.resource_id||' no'||
2537: ' record exists in jtf_rs_resource_extns ';
2538: log(l_err_msg);
2539: update asg_user
2540: set DISABLE_USER_SYNCH='Y',DISABLE_SYNCH_ERROR = l_err_msg
2541: where user_name = l_asg_user_rec.user_name;