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_OBJ_GROUPS

Line 558: of the data insertion into igs_sc_obj_groups

554: /******************************************************************
555: Created By : Don Shellito
556: Date Created By : April 23, 2003
557: Purpose : This procedure is designed for the handling
558: of the data insertion into igs_sc_obj_groups
559: table. There is validation to ensure that
560: the group_name is not null and that the value
561: for the default_policy_type is either 'G'- Global
562: or 'R' - Restricted.

Line 574: p_obj_group_id IN OUT NOCOPY igs_sc_obj_groups.obj_group_id%TYPE,

570: ******************************************************************/
571: PROCEDURE Insert_Object_Group (p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
573: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
574: p_obj_group_id IN OUT NOCOPY igs_sc_obj_groups.obj_group_id%TYPE,
575: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
576: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_return_message OUT NOCOPY VARCHAR2

Line 575: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,

571: PROCEDURE Insert_Object_Group (p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
573: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
574: p_obj_group_id IN OUT NOCOPY igs_sc_obj_groups.obj_group_id%TYPE,
575: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
576: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_return_message OUT NOCOPY VARCHAR2
579: ) IS

Line 576: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,

572: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
573: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
574: p_obj_group_id IN OUT NOCOPY igs_sc_obj_groups.obj_group_id%TYPE,
575: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
576: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
577: x_return_status OUT NOCOPY VARCHAR2,
578: x_return_message OUT NOCOPY VARCHAR2
579: ) IS
580:

Line 589: l_default_policy_type igs_sc_obj_groups.default_policy_type%TYPE;

585: l_api_version CONSTANT NUMBER := 1.0;
586: l_return_message VARCHAR2(2000);
587: l_message_count NUMBER(15);
588: l_return_status VARCHAR2(30);
589: l_default_policy_type igs_sc_obj_groups.default_policy_type%TYPE;
590:
591: BEGIN
592:
593: SAVEPOINT Insert_Object_Group_SP;

Line 654: INTO igs_sc_obj_groups

650: -- -----------------------------------------------------------------
651: -- Insert the values requested into the Grants table.
652: -- -----------------------------------------------------------------
653: INSERT
654: INTO igs_sc_obj_groups
655: (obj_group_id,
656: obj_group_name,
657: default_policy_type,
658: creation_date,

Line 664: VALUES (NVL(p_obj_group_id,igs_sc_obj_groups_s.nextval),

660: last_updated_by,
661: last_update_date,
662: last_update_login
663: )
664: VALUES (NVL(p_obj_group_id,igs_sc_obj_groups_s.nextval),
665: p_obj_group_name,
666: l_default_policy_type,
667: SYSDATE,
668: NVL(FND_GLOBAL.user_id,-1),

Line 752: l_obj_group_id igs_sc_obj_groups.obj_group_id%TYPE;

748: l_api_version CONSTANT NUMBER := 1.0;
749: l_return_message VARCHAR2(2000);
750: l_message_count NUMBER(15);
751: l_return_status VARCHAR2(30);
752: l_obj_group_id igs_sc_obj_groups.obj_group_id%TYPE;
753:
754: BEGIN
755:
756: SAVEPOINT Insert_Object_Attr_SP;

Line 3078: the updating of the igs_sc_obj_groups records.

3074: /******************************************************************
3075: Created By : Don Shellito
3076: Date Created By : April 23, 2003
3077: Purpose : The purpose of this procedure is to handle
3078: the updating of the igs_sc_obj_groups records.
3079: There is validation on the IDs given and ensure
3080: that the appropriate values are updated.
3081: Remarks :
3082:

Line 3092: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,

3088: ******************************************************************/
3089: PROCEDURE Update_Object_Group (p_api_version IN NUMBER,
3090: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3091: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3092: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
3093: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
3094: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
3095: x_return_status OUT NOCOPY VARCHAR2,
3096: x_return_message OUT NOCOPY VARCHAR2

Line 3093: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,

3089: PROCEDURE Update_Object_Group (p_api_version IN NUMBER,
3090: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3091: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3092: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
3093: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
3094: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
3095: x_return_status OUT NOCOPY VARCHAR2,
3096: x_return_message OUT NOCOPY VARCHAR2
3097: ) IS

Line 3094: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,

3090: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3091: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3092: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
3093: p_obj_group_name IN igs_sc_obj_groups.obj_group_name%TYPE ,
3094: p_default_policy_type IN igs_sc_obj_groups.default_policy_type%TYPE,
3095: x_return_status OUT NOCOPY VARCHAR2,
3096: x_return_message OUT NOCOPY VARCHAR2
3097: ) IS
3098:

Line 3108: l_obj_group_name igs_sc_obj_groups.obj_group_name%TYPE;

3104: l_api_version CONSTANT NUMBER := 1.0;
3105: l_return_message VARCHAR2(2000);
3106: l_message_count NUMBER(15);
3107: l_return_status VARCHAR2(30);
3108: l_obj_group_name igs_sc_obj_groups.obj_group_name%TYPE;
3109: l_default_policy_type igs_sc_obj_groups.default_policy_type%TYPE;
3110: l_grant_name igs_sc_grants.grant_name%TYPE;
3111: l_grant_id igs_sc_grants.grant_id%TYPE;
3112:

Line 3109: l_default_policy_type igs_sc_obj_groups.default_policy_type%TYPE;

3105: l_return_message VARCHAR2(2000);
3106: l_message_count NUMBER(15);
3107: l_return_status VARCHAR2(30);
3108: l_obj_group_name igs_sc_obj_groups.obj_group_name%TYPE;
3109: l_default_policy_type igs_sc_obj_groups.default_policy_type%TYPE;
3110: l_grant_name igs_sc_grants.grant_name%TYPE;
3111: l_grant_id igs_sc_grants.grant_id%TYPE;
3112:
3113: -- -----------------------------------------------------------------

Line 3119: FROM igs_sc_obj_groups grps

3115: -- -----------------------------------------------------------------
3116: CURSOR c_get_obj_group IS
3117: SELECT grps.obj_group_name,
3118: grps.default_policy_type
3119: FROM igs_sc_obj_groups grps
3120: WHERE grps.obj_group_id = p_obj_group_id;
3121:
3122: CURSOR c_get_grant_name IS
3123: SELECT grt.grant_name

Line 3210: UPDATE igs_sc_obj_groups objs

3206: -- Update the object groups information for the group ID given.
3207: -- -----------------------------------------------------------------
3208: IF IGS_SC_GRANTS_PVT.admin_mode <> 'Y' AND g_upgrade_mode <> 'Y' THEN
3209:
3210: UPDATE igs_sc_obj_groups objs
3211: SET objs.default_policy_type = l_default_policy_type,
3212: objs.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3213: objs.last_update_date = SYSDATE,
3214: objs.last_update_login = NVL(FND_GLOBAL.login_id, -1)

Line 3219: UPDATE igs_sc_obj_groups objs

3215: WHERE objs.obj_group_id = p_obj_group_id;
3216:
3217: ELSE
3218:
3219: UPDATE igs_sc_obj_groups objs
3220: SET objs.obj_group_name = l_obj_group_name,
3221: objs.default_policy_type = l_default_policy_type,
3222: objs.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3223: objs.last_update_date = SYSDATE,

Line 4282: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,

4278: ******************************************************************/
4279: PROCEDURE Delete_Object_Group (p_api_version IN NUMBER,
4280: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4281: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4282: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
4283: x_return_status OUT NOCOPY VARCHAR2,
4284: x_return_message OUT NOCOPY VARCHAR2
4285: ) IS
4286:

Line 4477: FROM igs_sc_obj_groups grps

4473: -- -----------------------------------------------------------------
4474: -- Delete the object group group that has been requested for delete.
4475: -- -----------------------------------------------------------------
4476: DELETE
4477: FROM igs_sc_obj_groups grps
4478: WHERE grps.obj_group_id = p_obj_group_id;
4479:
4480: -- -----------------------------------------------------------------
4481: -- Commit the transaction if requested to via parameter value.

Line 6797: l_group_id igs_sc_obj_groups.obj_group_id%TYPE;

6793: -- -----------------------------------------------------------------
6794: -- Define local variables to be used.
6795: -- -----------------------------------------------------------------
6796: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Obj_Grp_ID';
6797: l_group_id igs_sc_obj_groups.obj_group_id%TYPE;
6798:
6799: -- -----------------------------------------------------------------
6800: -- Define the cursors to be used in procedure.
6801: -- -----------------------------------------------------------------

Line 6804: FROM igs_sc_obj_groups grps

6800: -- Define the cursors to be used in procedure.
6801: -- -----------------------------------------------------------------
6802: CURSOR c_check_obj_group IS
6803: SELECT grps.obj_group_id
6804: FROM igs_sc_obj_groups grps
6805: WHERE grps.obj_group_id = p_group_id;
6806:
6807: BEGIN
6808:

Line 7343: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE

7339: /******************************************************************/
7340: PROCEDURE Unlock_All_Grants(
7341: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
7342: retcode OUT NOCOPY NUMBER , -- Request standard return status
7343: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE
7344: ) IS
7345:
7346: l_api_name CONSTANT VARCHAR2(30) := 'Unlock_All_Grants';
7347: l_msg_data VARCHAR2(2000);

Line 7400: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE

7396:
7397: PROCEDURE Lock_All_Grants(
7398: errbuf OUT NOCOPY VARCHAR2, -- Request standard error string
7399: retcode OUT NOCOPY NUMBER , -- Request standard return status
7400: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE
7401: ) IS
7402:
7403: l_api_name CONSTANT VARCHAR2(30) := 'Lock_All_Grants';
7404: l_msg_data VARCHAR2(2000);

Line 7789: IGS_SC_OBJ_GROUPS obj_group_id

7785: IGS_SC_USR_ATTRIBS user_attrib_id
7786:
7787: IGS_SC_USR_ATT_VALS user_id ,user_attrib_id
7788:
7789: IGS_SC_OBJ_GROUPS obj_group_id
7790:
7791: IGS_SC_OBJECTS object_id,obj_group_id
7792:
7793: IGS_SC_OBJ_FUNCTNS function_id,obj_group_id

Line 7822: CURSOR igs_sc_obj_groups_c IS

7818: FROM igs_sc_usr_attribs
7819: ORDER BY user_attrib_id
7820: FOR UPDATE OF user_attrib_id;
7821:
7822: CURSOR igs_sc_obj_groups_c IS
7823: SELECT obj_group_id
7824: FROM igs_sc_obj_groups
7825: ORDER BY obj_group_id
7826: FOR UPDATE OF obj_group_id;

Line 7824: FROM igs_sc_obj_groups

7820: FOR UPDATE OF user_attrib_id;
7821:
7822: CURSOR igs_sc_obj_groups_c IS
7823: SELECT obj_group_id
7824: FROM igs_sc_obj_groups
7825: ORDER BY obj_group_id
7826: FOR UPDATE OF obj_group_id;
7827:
7828: CURSOR igs_sc_obj_functns_c IS

Line 7905: FOR igs_sc_obj_groups_rec IN igs_sc_obj_groups_c LOOP

7901: -- UPDATE GROUPS
7902:
7903: l_current_seq := 1;
7904:
7905: FOR igs_sc_obj_groups_rec IN igs_sc_obj_groups_c LOOP
7906:
7907: IF igs_sc_obj_groups_rec.obj_group_id <> l_current_seq THEN
7908:
7909: -- Update all tables

Line 7907: IF igs_sc_obj_groups_rec.obj_group_id <> l_current_seq THEN

7903: l_current_seq := 1;
7904:
7905: FOR igs_sc_obj_groups_rec IN igs_sc_obj_groups_c LOOP
7906:
7907: IF igs_sc_obj_groups_rec.obj_group_id <> l_current_seq THEN
7908:
7909: -- Update all tables
7910:
7911: UPDATE IGS_SC_OBJECTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;

Line 7911: UPDATE IGS_SC_OBJECTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;

7907: IF igs_sc_obj_groups_rec.obj_group_id <> l_current_seq THEN
7908:
7909: -- Update all tables
7910:
7911: UPDATE IGS_SC_OBJECTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7912:
7913: UPDATE IGS_SC_OBJ_FUNCTNS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7914:
7915: UPDATE IGS_SC_OBJ_ATTRIBS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;

Line 7913: UPDATE IGS_SC_OBJ_FUNCTNS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;

7909: -- Update all tables
7910:
7911: UPDATE IGS_SC_OBJECTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7912:
7913: UPDATE IGS_SC_OBJ_FUNCTNS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7914:
7915: UPDATE IGS_SC_OBJ_ATTRIBS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7916:
7917: UPDATE IGS_SC_GRANTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;

Line 7915: UPDATE IGS_SC_OBJ_ATTRIBS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;

7911: UPDATE IGS_SC_OBJECTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7912:
7913: UPDATE IGS_SC_OBJ_FUNCTNS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7914:
7915: UPDATE IGS_SC_OBJ_ATTRIBS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7916:
7917: UPDATE IGS_SC_GRANTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7918:
7919: -- Update table itself

Line 7917: UPDATE IGS_SC_GRANTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;

7913: UPDATE IGS_SC_OBJ_FUNCTNS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7914:
7915: UPDATE IGS_SC_OBJ_ATTRIBS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7916:
7917: UPDATE IGS_SC_GRANTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7918:
7919: -- Update table itself
7920: UPDATE igs_sc_obj_groups SET obj_group_id = l_current_seq WHERE CURRENT OF igs_sc_obj_groups_c;
7921:

Line 7920: UPDATE igs_sc_obj_groups SET obj_group_id = l_current_seq WHERE CURRENT OF igs_sc_obj_groups_c;

7916:
7917: UPDATE IGS_SC_GRANTS SET obj_group_id = l_current_seq WHERE obj_group_id = igs_sc_obj_groups_rec.obj_group_id;
7918:
7919: -- Update table itself
7920: UPDATE igs_sc_obj_groups SET obj_group_id = l_current_seq WHERE CURRENT OF igs_sc_obj_groups_c;
7921:
7922: END IF;
7923:
7924: l_current_seq := l_current_seq +1;

Line 7983: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,

7979: PROCEDURE enable_upgrade_mode (
7980: p_api_version IN NUMBER,
7981: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7982: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7983: p_obj_group_id IN igs_sc_obj_groups.obj_group_id%TYPE,
7984: x_return_status OUT NOCOPY VARCHAR2,
7985: x_msg_data OUT NOCOPY VARCHAR2
7986: ) IS
7987: