eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_GRANT_CONDS

Line 348: handling on inserting data into igs_sc_grant_conds

344: /******************************************************************
345: Created By : Don Shellito
346: Date Created By : April 23, 2003
347: Purpose : The purpose of this procedure is for the
348: handling on inserting data into igs_sc_grant_conds
349: table. There is validation on the grant_id,
350: obj_attrib_id, and user_attrib_id values received
351: to ensure that these records have been inserted
352: into the OSS security data model.

Line 364: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,

360: ******************************************************************/
361: PROCEDURE Insert_Grant_Cond (p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
363: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
364: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
365: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
366: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
367: p_condition IN igs_sc_grant_conds.condition%TYPE,
368: p_text_value IN igs_sc_grant_conds.text_value%TYPE,

Line 365: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,

361: PROCEDURE Insert_Grant_Cond (p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
363: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
364: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
365: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
366: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
367: p_condition IN igs_sc_grant_conds.condition%TYPE,
368: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
369: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

Line 366: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,

362: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
363: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
364: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
365: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
366: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
367: p_condition IN igs_sc_grant_conds.condition%TYPE,
368: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
369: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
370: x_return_status OUT NOCOPY VARCHAR2,

Line 367: p_condition IN igs_sc_grant_conds.condition%TYPE,

363: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
364: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
365: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
366: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
367: p_condition IN igs_sc_grant_conds.condition%TYPE,
368: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
369: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_return_message OUT NOCOPY VARCHAR2

Line 368: p_text_value IN igs_sc_grant_conds.text_value%TYPE,

364: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
365: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
366: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
367: p_condition IN igs_sc_grant_conds.condition%TYPE,
368: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
369: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_return_message OUT NOCOPY VARCHAR2
372: )

Line 369: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

365: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
366: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
367: p_condition IN igs_sc_grant_conds.condition%TYPE,
368: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
369: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
370: x_return_status OUT NOCOPY VARCHAR2,
371: x_return_message OUT NOCOPY VARCHAR2
372: )
373: IS

Line 467: INTO igs_sc_grant_conds

463: -- -----------------------------------------------------------------
464: -- Insert the values requested into the Grant Conditions table.
465: -- -----------------------------------------------------------------
466: INSERT
467: INTO igs_sc_grant_conds
468: (grant_id,
469: grant_cond_num,
470: obj_attrib_id,
471: user_attrib_id,

Line 2847: the updates on the igs_sc_grant_conds table.

2843: /******************************************************************
2844: Created By : Don Shellito
2845: Date Created By : April 23, 2003
2846: Purpose : The purpose of this procedure is to handle
2847: the updates on the igs_sc_grant_conds table.
2848: There are validations to ensure that the IDs
2849: provided are valid.
2850: Remarks :
2851:

Line 2862: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,

2858: ******************************************************************/
2859: PROCEDURE Update_Grant_Cond (p_api_version IN NUMBER,
2860: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2861: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2862: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
2863: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
2864: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
2865: p_condition IN igs_sc_grant_conds.condition%TYPE,
2866: p_text_value IN igs_sc_grant_conds.text_value%TYPE,

Line 2863: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,

2859: PROCEDURE Update_Grant_Cond (p_api_version IN NUMBER,
2860: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2861: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2862: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
2863: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
2864: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
2865: p_condition IN igs_sc_grant_conds.condition%TYPE,
2866: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
2867: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

Line 2864: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,

2860: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2861: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2862: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
2863: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
2864: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
2865: p_condition IN igs_sc_grant_conds.condition%TYPE,
2866: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
2867: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
2868: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,

Line 2865: p_condition IN igs_sc_grant_conds.condition%TYPE,

2861: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2862: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
2863: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
2864: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
2865: p_condition IN igs_sc_grant_conds.condition%TYPE,
2866: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
2867: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
2868: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,
2869: x_return_status OUT NOCOPY VARCHAR2,

Line 2866: p_text_value IN igs_sc_grant_conds.text_value%TYPE,

2862: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
2863: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
2864: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
2865: p_condition IN igs_sc_grant_conds.condition%TYPE,
2866: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
2867: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
2868: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,
2869: x_return_status OUT NOCOPY VARCHAR2,
2870: x_return_message OUT NOCOPY VARCHAR2

Line 2867: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

2863: p_obj_attrib_id IN igs_sc_grant_conds.obj_attrib_id%TYPE,
2864: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
2865: p_condition IN igs_sc_grant_conds.condition%TYPE,
2866: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
2867: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
2868: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,
2869: x_return_status OUT NOCOPY VARCHAR2,
2870: x_return_message OUT NOCOPY VARCHAR2
2871: ) IS

Line 2868: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,

2864: p_user_attrib_id IN igs_sc_grant_conds.user_attrib_id%TYPE,
2865: p_condition IN igs_sc_grant_conds.condition%TYPE,
2866: p_text_value IN igs_sc_grant_conds.text_value%TYPE,
2867: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
2868: p_old_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE DEFAULT 0,
2869: x_return_status OUT NOCOPY VARCHAR2,
2870: x_return_message OUT NOCOPY VARCHAR2
2871: ) IS
2872:

Line 2882: l_obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE;

2878: l_api_version CONSTANT NUMBER := 1.0;
2879: l_return_message VARCHAR2(2000);
2880: l_message_count NUMBER(15);
2881: l_return_status VARCHAR2(30);
2882: l_obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE;
2883: l_user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE;
2884: l_grant_name igs_sc_grants.grant_name%TYPE;
2885: l_old_grant_cond_num NUMBER;
2886:

Line 2883: l_user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE;

2879: l_return_message VARCHAR2(2000);
2880: l_message_count NUMBER(15);
2881: l_return_status VARCHAR2(30);
2882: l_obj_attrib_id igs_sc_grant_conds.obj_attrib_id%TYPE;
2883: l_user_attrib_id igs_sc_grant_conds.user_attrib_id%TYPE;
2884: l_grant_name igs_sc_grants.grant_name%TYPE;
2885: l_old_grant_cond_num NUMBER;
2886:
2887: -- -----------------------------------------------------------------

Line 2893: FROM igs_sc_grant_conds cnds

2889: -- -----------------------------------------------------------------
2890: CURSOR c_get_grant_cond IS
2891: SELECT cnds.obj_attrib_id,
2892: cnds.user_attrib_id
2893: FROM igs_sc_grant_conds cnds
2894: WHERE cnds.grant_id = p_grant_id
2895: AND cnds.grant_cond_num = p_grant_cond_num;
2896:
2897: CURSOR c_get_grant_name IS

Line 2991: UPDATE igs_sc_grant_conds cnds

2987:
2988: -- -----------------------------------------------------------------
2989: -- Update the Grant Conditions record.
2990: -- -----------------------------------------------------------------
2991: UPDATE igs_sc_grant_conds cnds
2992: SET cnds.obj_attrib_id = l_obj_attrib_id,
2993: cnds.user_attrib_id = l_user_attrib_id,
2994: cnds.condition = p_condition,
2995: cnds.text_value = p_text_value,

Line 3340: FROM igs_sc_grant_conds cond,

3336:
3337: CURSOR c_get_grant_info IS
3338: SELECT cond.grant_id,
3339: grt.grant_name
3340: FROM igs_sc_grant_conds cond,
3341: igs_sc_grants grt
3342: WHERE cond.obj_attrib_id = p_obj_attrib_id
3343: AND grt.grant_id = cond.grant_id;
3344:

Line 3792: l_grant_id igs_sc_grant_conds.grant_id%TYPE;

3788: l_message_count NUMBER(15);
3789: l_return_status VARCHAR2(30);
3790: l_obj_group_id igs_sc_obj_attribs.obj_group_id%TYPE;
3791: l_obj_attrib_name igs_sc_obj_attribs.obj_attrib_name%TYPE;
3792: l_grant_id igs_sc_grant_conds.grant_id%TYPE;
3793: l_grant_name igs_sc_grants.grant_name%TYPE;
3794:
3795: -- -----------------------------------------------------------------
3796: -- Define the cursors to be used in procedure.

Line 3807: FROM igs_sc_grant_conds cond,

3803:
3804: CURSOR c_get_grant_info IS
3805: SELECT cond.grant_id,
3806: grt.grant_name
3807: FROM igs_sc_grant_conds cond,
3808: igs_sc_grants grt
3809: WHERE cond.obj_attrib_id = p_obj_attrib_id
3810: AND grt.grant_id = cond.grant_id;
3811:

Line 4022: FROM igs_sc_grant_conds cond,

4018:
4019: CURSOR c_get_grant_info IS
4020: SELECT cond.grant_id,
4021: grt.grant_name
4022: FROM igs_sc_grant_conds cond,
4023: igs_sc_grants grt
4024: WHERE cond.user_attrib_id = p_user_attrib_id
4025: AND grt.grant_id = cond.grant_id;
4026:

Line 4587: l_grant_id igs_sc_grant_conds.grant_id%TYPE;

4583: -- Define local variables to be used.
4584: -- -----------------------------------------------------------------
4585: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Object_Attr';
4586: l_api_version CONSTANT NUMBER := 1.0;
4587: l_grant_id igs_sc_grant_conds.grant_id%TYPE;
4588: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;
4589: l_object_id_mthd igs_sc_obj_att_mths.object_id%TYPE;
4590: l_object_id_val igs_sc_obj_att_vals.object_id%TYPE;
4591: l_return_message VARCHAR2(2000);

Line 4588: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;

4584: -- -----------------------------------------------------------------
4585: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Object_Attr';
4586: l_api_version CONSTANT NUMBER := 1.0;
4587: l_grant_id igs_sc_grant_conds.grant_id%TYPE;
4588: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;
4589: l_object_id_mthd igs_sc_obj_att_mths.object_id%TYPE;
4590: l_object_id_val igs_sc_obj_att_vals.object_id%TYPE;
4591: l_return_message VARCHAR2(2000);
4592: l_message_count NUMBER(15);

Line 5346: l_grant_id igs_sc_grant_conds.grant_id%TYPE;

5342: -- Define local variables to be used.
5343: -- -----------------------------------------------------------------
5344: l_api_name CONSTANT VARCHAR2(30) := 'Delete_User_Attr';
5345: l_api_version CONSTANT NUMBER := 1.0;
5346: l_grant_id igs_sc_grant_conds.grant_id%TYPE;
5347: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;
5348: l_user_id igs_sc_usr_att_vals.user_id%TYPE;
5349: l_grant_name igs_sc_grants.grant_name%TYPE;
5350: l_return_message VARCHAR2(2000);

Line 5347: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;

5343: -- -----------------------------------------------------------------
5344: l_api_name CONSTANT VARCHAR2(30) := 'Delete_User_Attr';
5345: l_api_version CONSTANT NUMBER := 1.0;
5346: l_grant_id igs_sc_grant_conds.grant_id%TYPE;
5347: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;
5348: l_user_id igs_sc_usr_att_vals.user_id%TYPE;
5349: l_grant_name igs_sc_grants.grant_name%TYPE;
5350: l_return_message VARCHAR2(2000);
5351: l_message_count NUMBER(15);

Line 5361: FROM igs_sc_grant_conds grts,

5357: CURSOR c_get_grant_conds IS
5358: SELECT grts.grant_id,
5359: grts.grant_cond_num,
5360: gnt.grant_name
5361: FROM igs_sc_grant_conds grts,
5362: igs_sc_grants gnt
5363: WHERE grts.user_attrib_id = p_user_attrib_id
5364: AND gnt.grant_id = grts.grant_id;
5365:

Line 5658: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;

5654: -- -----------------------------------------------------------------
5655: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Grant';
5656: l_delete_oper CONSTANT VARCHAR2(30) := 'DELETE';
5657: l_api_version CONSTANT NUMBER := 1.0;
5658: l_grant_cond_num igs_sc_grant_conds.grant_cond_num%TYPE;
5659: l_grant_name igs_sc_grants.grant_name%TYPE;
5660: l_return_message VARCHAR2(2000);
5661: l_message_count NUMBER(15);
5662: l_return_status VARCHAR2(30);

Line 5669: FROM igs_sc_grant_conds grts

5665: -- Define the cursors to be used in procedure.
5666: -- -----------------------------------------------------------------
5667: CURSOR c_get_grant_cond IS
5668: SELECT grts.grant_cond_num
5669: FROM igs_sc_grant_conds grts
5670: WHERE grts.grant_id = p_grant_id;
5671:
5672: CURSOR c_get_grant_name IS
5673: SELECT grts.grant_name

Line 5867: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,

5863: ******************************************************************/
5864: PROCEDURE Delete_Grant_Cond (p_api_version IN NUMBER,
5865: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5866: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5867: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
5868: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
5869: x_return_status OUT NOCOPY VARCHAR2,
5870: x_return_message OUT NOCOPY VARCHAR2
5871: ) IS

Line 5868: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,

5864: PROCEDURE Delete_Grant_Cond (p_api_version IN NUMBER,
5865: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5866: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5867: p_grant_id IN igs_sc_grant_conds.grant_id%TYPE,
5868: p_grant_cond_num IN igs_sc_grant_conds.grant_cond_num%TYPE,
5869: x_return_status OUT NOCOPY VARCHAR2,
5870: x_return_message OUT NOCOPY VARCHAR2
5871: ) IS
5872:

Line 5934: FROM igs_sc_grant_conds conds

5930: -- -----------------------------------------------------------------
5931: -- Delete the grant condition that is being requested.
5932: -- -----------------------------------------------------------------
5933: DELETE
5934: FROM igs_sc_grant_conds conds
5935: WHERE conds.grant_id = p_grant_id
5936: AND conds.grant_cond_num = p_grant_cond_num;
5937:
5938: ELSE

Line 7805: IGS_SC_GRANT_CONDS grant_id,obj_attrib_id,user_attrib_id

7801: IGS_SC_OBJ_GRANTS grant_id,object_id
7802:
7803: IGS_SC_GRANTS grant_id,user_group_id,obj_group_id ,function_id
7804:
7805: IGS_SC_GRANT_CONDS grant_id,obj_attrib_id,user_attrib_id
7806:
7807: */
7808: PROCEDURE change_seq IS
7809:

Line 7866: UPDATE IGS_SC_GRANT_CONDS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;

7862:
7863: -- Update all tables
7864: UPDATE IGS_SC_OBJ_GRANTS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7865:
7866: UPDATE IGS_SC_GRANT_CONDS SET grant_id = l_current_seq WHERE grant_id = igs_sc_grants_rec.grant_id;
7867:
7868: -- Update table itself
7869: UPDATE igs_sc_grants SET grant_id = l_current_seq WHERE CURRENT OF igs_sc_grants_c;
7870:

Line 7887: UPDATE IGS_SC_GRANT_CONDS SET user_attrib_id = l_current_seq WHERE user_attrib_id = igs_sc_usr_attribs_rec.user_attrib_id;

7883: IF igs_sc_usr_attribs_rec.user_attrib_id <> l_current_seq THEN
7884:
7885: -- Update all tables
7886:
7887: UPDATE IGS_SC_GRANT_CONDS SET user_attrib_id = l_current_seq WHERE user_attrib_id = igs_sc_usr_attribs_rec.user_attrib_id;
7888: UPDATE IGS_SC_USR_ATT_VALS SET user_attrib_id = l_current_seq WHERE user_attrib_id = igs_sc_usr_attribs_rec.user_attrib_id;
7889:
7890: -- Update table itself
7891: UPDATE igs_sc_usr_attribs SET user_attrib_id = l_current_seq WHERE CURRENT OF igs_sc_usr_attribs_c;

Line 7964: UPDATE IGS_SC_GRANT_CONDS SET obj_attrib_id = l_current_seq WHERE obj_attrib_id = igs_sc_obj_attribs_rec.obj_attrib_id;

7960: UPDATE IGS_SC_OBJ_ATT_MTHS SET obj_attrib_id = l_current_seq WHERE obj_attrib_id = igs_sc_obj_attribs_rec.obj_attrib_id;
7961:
7962: UPDATE IGS_SC_OBJ_ATT_VALS SET obj_attrib_id = l_current_seq WHERE obj_attrib_id = igs_sc_obj_attribs_rec.obj_attrib_id;
7963:
7964: UPDATE IGS_SC_GRANT_CONDS SET obj_attrib_id = l_current_seq WHERE obj_attrib_id = igs_sc_obj_attribs_rec.obj_attrib_id;
7965:
7966: -- Update table itself
7967: UPDATE igs_sc_obj_attribs SET obj_attrib_id = l_current_seq WHERE CURRENT OF igs_sc_obj_attribs_c;
7968: