[Home] [Help]
51: obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE,
52: user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE,
53: condition igs_sc_grant_conds.condition%TYPE,
54: text_value igs_sc_grant_conds.text_value%TYPE,
55: user_attrib_value igs_sc_usr_att_vals.attr_value%TYPE,
56: obj_attrib_value igs_sc_obj_att_vals.attr_value%TYPE,
57: cond_text VARCHAR2(2000),
58: z_typ_flag VARCHAR2(1) --mmkumar
59: );
897:
898: -- If yes then construct for multi-value attribute
899: -- Add select from values table
900:
901: l_usr_select :='SELECT '||l_usr_alias||'.attr_value FROM igs_sc_usr_att_vals '||l_usr_alias||' WHERE '||l_usr_alias||'.user_id=igs_sc_vars.get_userid AND '
902: ||l_usr_alias||'.user_attrib_id='||c_grant_cond_rec.user_attrib_id;
903:
904: ELSE
905: --Simply get value for an attribute using API and append
1449:
1450:
1451: CURSOR c_party_value (s_user_id NUMBER) IS
1452: SELECT attr_value
1453: FROM igs_sc_usr_att_vals
1454: WHERE user_attrib_id = 1
1455: AND user_id = s_user_id;
1456:
1457:
1616: BEGIN
1617:
1618: -- delete all values for the current user
1619:
1620: DELETE FROM igs_sc_usr_att_vals
1621: WHERE user_id = p_user_id
1622: AND user_attrib_id = p_user_attrib_id;
1623:
1624: l_select := 'INSERT INTO igs_sc_usr_att_vals (USER_ID,USER_ATTRIB_ID,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,ATTR_VALUE )';
1620: DELETE FROM igs_sc_usr_att_vals
1621: WHERE user_id = p_user_id
1622: AND user_attrib_id = p_user_attrib_id;
1623:
1624: l_select := 'INSERT INTO igs_sc_usr_att_vals (USER_ID,USER_ATTRIB_ID,CREATION_DATE,CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE,ATTR_VALUE )';
1625:
1626: -- find is :USER_ID or :PARTY_ID is used in the text
1627: -- replace all PARTY_ID with call to a IGS_SC_GRANTS_PVT.get_current_party function
1628: