APPS.IGS_SC_GEN_001 dependencies on IGS_SC_GRANT_CONDS

Line 25: TYPE g_grant_cond_rec IS RECORD (obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE,

21: -- -----------------------------------------------------------------
22: -- Define the global variables to be used in this package.
23: -- -----------------------------------------------------------------
24:
25: TYPE g_grant_cond_rec IS RECORD (obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE,
26: user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE,
27: condition igs_sc_grant_conds.condition%TYPE,
28: text_value igs_sc_grant_conds.text_value%TYPE,
29: user_attrib_value igs_sc_usr_att_vals.attr_value%TYPE,

Line 26: user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE,

22: -- Define the global variables to be used in this package.
23: -- -----------------------------------------------------------------
24:
25: TYPE g_grant_cond_rec IS RECORD (obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE,
26: user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE,
27: condition igs_sc_grant_conds.condition%TYPE,
28: text_value igs_sc_grant_conds.text_value%TYPE,
29: user_attrib_value igs_sc_usr_att_vals.attr_value%TYPE,
30: obj_attrib_value igs_sc_obj_att_vals.attr_value%TYPE,

Line 27: condition igs_sc_grant_conds.condition%TYPE,

23: -- -----------------------------------------------------------------
24:
25: TYPE g_grant_cond_rec IS RECORD (obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE,
26: user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE,
27: condition igs_sc_grant_conds.condition%TYPE,
28: text_value igs_sc_grant_conds.text_value%TYPE,
29: user_attrib_value igs_sc_usr_att_vals.attr_value%TYPE,
30: obj_attrib_value igs_sc_obj_att_vals.attr_value%TYPE,
31: cond_text VARCHAR2(4000),

Line 28: text_value igs_sc_grant_conds.text_value%TYPE,

24:
25: TYPE g_grant_cond_rec IS RECORD (obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE,
26: user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE,
27: condition igs_sc_grant_conds.condition%TYPE,
28: text_value igs_sc_grant_conds.text_value%TYPE,
29: user_attrib_value igs_sc_usr_att_vals.attr_value%TYPE,
30: obj_attrib_value igs_sc_obj_att_vals.attr_value%TYPE,
31: cond_text VARCHAR2(4000),
32: obj_const VARCHAR2(4000),

Line 197: FROM igs_sc_grant_conds

193: obj_attrib_id,
194: user_attrib_id,
195: condition,
196: text_value
197: FROM igs_sc_grant_conds
198: WHERE grant_id = s_grant_id;
199:
200: -- Get user attributes.
201: CURSOR c_user_attrib (s_attrib_id NUMBER) IS