APPS.IGS_SC_GRANTS_PVT dependencies on IGS_SC_GRANT_CONDS

Line 51: obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE,

47: l_label VARCHAR2(4000);
48: l_debug_str VARCHAR2(32000);
49:
50: TYPE g_grant_cond_rec IS RECORD (
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,

Line 52: user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE,

48: l_debug_str VARCHAR2(32000);
49:
50: TYPE g_grant_cond_rec IS RECORD (
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,

Line 53: condition igs_sc_grant_conds.condition%TYPE,

49:
50: TYPE g_grant_cond_rec IS RECORD (
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),

Line 54: text_value igs_sc_grant_conds.text_value%TYPE,

50: TYPE g_grant_cond_rec IS RECORD (
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

Line 652: FROM igs_sc_grant_conds

648: obj_attrib_id,
649: user_attrib_id,
650: condition,
651: text_value
652: FROM igs_sc_grant_conds
653: WHERE grant_id = s_grant_id;
654:
655: CURSOR c_user_attrib (s_attrib_id NUMBER) IS
656: SELECT *