APPS.IGS_SC_GEN_001 dependencies on FND_USER

Line 1230: P_USER_ID IN number DEFAULT NULL) -- fnd user id)

1226:
1227: FUNCTION check_user_policy
1228: ( P_BUSINESS_OBJECT IN varchar2, -- BO name
1229: P_ACTION IN varchar2 , -- S,I,D,U
1230: P_USER_ID IN number DEFAULT NULL) -- fnd user id)
1231: RETURN VARCHAR2 IS
1232: ------------------------------------------------------------------
1233: --Updated by : ssawhney, Oracle India
1234: --Date created: 27-MAY-2001

Line 1244: l_user_id fnd_user.user_id%type;

1240: --skpandey 10-JAN-2006 Bug#4937960
1241: -- Changed c_user cursor definition to optimize query
1242: ------------------------------------------------------------------
1243:
1244: l_user_id fnd_user.user_id%type;
1245: l_return varchar2(4000); --incase sql errmr then 4000
1246: l_default IGS_SC_OBJ_GROUPS.default_policy_type%type ;
1247: l_obj_grp_id IGS_SC_OBJ_GROUPS.obj_group_id%type;
1248: l_role_id NUMBER;

Line 1250: CURSOR c_user (cp_igs varchar, cp_fnd varchar, cp_fnd_user fnd_user.user_id%type) IS

1246: l_default IGS_SC_OBJ_GROUPS.default_policy_type%type ;
1247: l_obj_grp_id IGS_SC_OBJ_GROUPS.obj_group_id%type;
1248: l_role_id NUMBER;
1249:
1250: CURSOR c_user (cp_igs varchar, cp_fnd varchar, cp_fnd_user fnd_user.user_id%type) IS
1251: SELECT role_orig_system_id
1252: FROM wf_local_user_roles role, fnd_user use
1253: WHERE role_orig_system = cp_igs
1254: AND user_orig_system = cp_fnd

Line 1252: FROM wf_local_user_roles role, fnd_user use

1248: l_role_id NUMBER;
1249:
1250: CURSOR c_user (cp_igs varchar, cp_fnd varchar, cp_fnd_user fnd_user.user_id%type) IS
1251: SELECT role_orig_system_id
1252: FROM wf_local_user_roles role, fnd_user use
1253: WHERE role_orig_system = cp_igs
1254: AND user_orig_system = cp_fnd
1255: AND user_orig_system_id = cp_fnd_user
1256: AND role.user_name = use.user_name

Line 1255: AND user_orig_system_id = cp_fnd_user

1251: SELECT role_orig_system_id
1252: FROM wf_local_user_roles role, fnd_user use
1253: WHERE role_orig_system = cp_igs
1254: AND user_orig_system = cp_fnd
1255: AND user_orig_system_id = cp_fnd_user
1256: AND role.user_name = use.user_name
1257: AND use.user_id = cp_fnd_user;
1258:
1259:

Line 1257: AND use.user_id = cp_fnd_user;

1253: WHERE role_orig_system = cp_igs
1254: AND user_orig_system = cp_fnd
1255: AND user_orig_system_id = cp_fnd_user
1256: AND role.user_name = use.user_name
1257: AND use.user_id = cp_fnd_user;
1258:
1259:
1260: CURSOR c_bo (cp_bo_name varchar) IS
1261: SELECT default_policy_type, obj_group_id