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.

[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_OBJ_ATTRIBS

Line 384: l_obj_attr_id igs_sc_obj_attribs.obj_attrib_id%TYPE := p_obj_attrib_id;

380: l_return_message VARCHAR2(2000);
381: l_message_count NUMBER(15);
382: l_return_status VARCHAR2(30);
383: l_user_attr_id igs_sc_usr_attribs.user_attrib_id%TYPE := p_user_attrib_id;
384: l_obj_attr_id igs_sc_obj_attribs.obj_attrib_id%TYPE := p_obj_attrib_id;
385: l_grant_id igs_sc_grants.grant_id%TYPE := p_grant_id;
386:
387: BEGIN
388: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 721: on insertion of data into igs_sc_obj_attribs table.

717: /******************************************************************
718: Created By : Don Shellito
719: Date Created By : April 23, 2003
720: Purpose : The purpose of this procedure is for the handling
721: on insertion of data into igs_sc_obj_attribs table.
722: There is validation performed on the obj_group_id
723: and obj_attrib_id provided to ensure that the
724: records are present in the OSS data structure.
725: Remarks :

Line 736: p_obj_attrib_id IN OUT NOCOPY igs_sc_obj_attribs.obj_attrib_id%TYPE,

732: ******************************************************************/
733: PROCEDURE Insert_Object_Attr (p_api_version IN NUMBER,
734: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
735: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
736: p_obj_attrib_id IN OUT NOCOPY igs_sc_obj_attribs.obj_attrib_id%TYPE,
737: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
738: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
739: p_active_flag IN VARCHAR2 DEFAULT 'Y',
740: x_return_status OUT NOCOPY VARCHAR2,

Line 737: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,

733: PROCEDURE Insert_Object_Attr (p_api_version IN NUMBER,
734: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
735: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
736: p_obj_attrib_id IN OUT NOCOPY igs_sc_obj_attribs.obj_attrib_id%TYPE,
737: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
738: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
739: p_active_flag IN VARCHAR2 DEFAULT 'Y',
740: x_return_status OUT NOCOPY VARCHAR2,
741: x_return_message OUT NOCOPY VARCHAR2

Line 738: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,

734: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
735: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
736: p_obj_attrib_id IN OUT NOCOPY igs_sc_obj_attribs.obj_attrib_id%TYPE,
737: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
738: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
739: p_active_flag IN VARCHAR2 DEFAULT 'Y',
740: x_return_status OUT NOCOPY VARCHAR2,
741: x_return_message OUT NOCOPY VARCHAR2
742: ) IS

Line 816: INTO igs_sc_obj_attribs

812: -- -----------------------------------------------------------------
813: -- Insert the values requested into the Grants table.
814: -- -----------------------------------------------------------------
815: INSERT
816: INTO igs_sc_obj_attribs
817: (obj_group_id,
818: obj_attrib_id,
819: obj_attrib_name,
820: creation_date,

Line 828: NVL(p_obj_attrib_id,igs_sc_obj_attribs_s.nextval),

824: last_update_login,
825: active_flag
826: )
827: VALUES (l_obj_group_id,
828: NVL(p_obj_attrib_id,igs_sc_obj_attribs_s.nextval),
829: p_obj_attrib_name,
830: SYSDATE,
831: NVL(FND_GLOBAL.user_id,-1),
832: NVL(FND_GLOBAL.user_id,-1),

Line 3759: to be made to data present in igs_sc_obj_attribs.

3755: /******************************************************************
3756: Created By : Don Shellito
3757: Date Created By : April 23, 2003
3758: Purpose : The purpose of this procedure is for the updates
3759: to be made to data present in igs_sc_obj_attribs.
3760: The IDs that are provided are validated to ensure
3761: data present in the OSS data model.
3762: Remarks :
3763:

Line 3773: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,

3769: ******************************************************************/
3770: PROCEDURE Update_Object_Attr (p_api_version IN NUMBER,
3771: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3772: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3773: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
3774: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
3775: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
3776: p_active_flag IN VARCHAR2 DEFAULT 'Y',
3777: x_return_status OUT NOCOPY VARCHAR2,

Line 3774: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,

3770: PROCEDURE Update_Object_Attr (p_api_version IN NUMBER,
3771: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3772: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3773: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
3774: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
3775: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
3776: p_active_flag IN VARCHAR2 DEFAULT 'Y',
3777: x_return_status OUT NOCOPY VARCHAR2,
3778: x_return_message OUT NOCOPY VARCHAR2

Line 3775: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,

3771: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3772: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3773: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
3774: p_obj_group_id IN igs_sc_obj_attribs.obj_group_id%TYPE,
3775: p_obj_attrib_name IN igs_sc_obj_attribs.obj_attrib_name%TYPE,
3776: p_active_flag IN VARCHAR2 DEFAULT 'Y',
3777: x_return_status OUT NOCOPY VARCHAR2,
3778: x_return_message OUT NOCOPY VARCHAR2
3779: ) IS

Line 3790: l_obj_group_id igs_sc_obj_attribs.obj_group_id%TYPE;

3786: l_api_version CONSTANT NUMBER := 1.0;
3787: l_return_message VARCHAR2(2000);
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:

Line 3791: l_obj_attrib_name igs_sc_obj_attribs.obj_attrib_name%TYPE;

3787: l_return_message VARCHAR2(2000);
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: -- -----------------------------------------------------------------

Line 3801: FROM igs_sc_obj_attribs attr

3797: -- -----------------------------------------------------------------
3798: CURSOR c_get_obj_attrib IS
3799: SELECT attr.obj_group_id,
3800: attr.obj_attrib_name
3801: FROM igs_sc_obj_attribs attr
3802: WHERE attr.obj_attrib_id = p_obj_attrib_id;
3803:
3804: CURSOR c_get_grant_info IS
3805: SELECT cond.grant_id,

Line 3905: UPDATE igs_sc_obj_attribs attr

3901:
3902: -- ----------------------------------------------------------------
3903: -- Update the object attributes with the values received.
3904: -- ----------------------------------------------------------------
3905: UPDATE igs_sc_obj_attribs attr
3906: SET attr.obj_attrib_name = p_obj_attrib_name,
3907: attr.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3908: attr.last_update_date = SYSDATE,
3909: attr.last_update_login = NVL(FND_GLOBAL.login_id, -1),

Line 4295: l_obj_attrib_id igs_sc_obj_attribs.obj_attrib_id%TYPE;

4291: l_api_version CONSTANT NUMBER := 1.0;
4292: l_object_id igs_sc_objects.object_id%TYPE;
4293: l_function_id igs_sc_obj_functns.function_id%TYPE;
4294: l_grant_id igs_sc_grants.grant_id%TYPE;
4295: l_obj_attrib_id igs_sc_obj_attribs.obj_attrib_id%TYPE;
4296: l_return_message VARCHAR2(2000);
4297: l_message_count NUMBER(15);
4298: l_return_status VARCHAR2(30);
4299:

Line 4320: FROM igs_sc_obj_attribs attrs

4316: WHERE grts.obj_group_id = p_obj_group_id;
4317:
4318: CURSOR c_get_obj_attr_id IS
4319: SELECT attrs.obj_attrib_id
4320: FROM igs_sc_obj_attribs attrs
4321: WHERE attrs.obj_group_id = p_obj_group_id;
4322:
4323: BEGIN
4324:

Line 4577: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,

4573: ******************************************************************/
4574: PROCEDURE Delete_Object_Attr (p_api_version IN NUMBER,
4575: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4576: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4577: p_obj_attrib_id IN igs_sc_obj_attribs.obj_attrib_id%TYPE,
4578: x_return_status OUT NOCOPY VARCHAR2,
4579: x_return_message OUT NOCOPY VARCHAR2
4580: ) IS
4581:

Line 4710: FROM igs_sc_obj_attribs attrs

4706: -- -----------------------------------------------------------------
4707: -- Delete the attribute that has been requested for deletion.
4708: -- -----------------------------------------------------------------
4709: DELETE
4710: FROM igs_sc_obj_attribs attrs
4711: WHERE attrs.obj_attrib_id = p_obj_attrib_id;
4712:
4713: -- -----------------------------------------------------------------
4714: -- Commit the transaction if requested to via parameter value.

Line 6862: l_obj_attr_id igs_sc_obj_attribs.obj_attrib_id%TYPE;

6858: -- -----------------------------------------------------------------
6859: -- Define local variables to be used.
6860: -- -----------------------------------------------------------------
6861: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Obj_Attr_ID';
6862: l_obj_attr_id igs_sc_obj_attribs.obj_attrib_id%TYPE;
6863:
6864: -- -----------------------------------------------------------------
6865: -- Define the cursors to be used in procedure.
6866: -- -----------------------------------------------------------------

Line 6869: FROM igs_sc_obj_attribs attr

6865: -- Define the cursors to be used in procedure.
6866: -- -----------------------------------------------------------------
6867: CURSOR c_check_obj_attrib IS
6868: SELECT attr.obj_attrib_id
6869: FROM igs_sc_obj_attribs attr
6870: WHERE attr.obj_attrib_id = p_obj_attr_id;
6871:
6872: BEGIN
6873:

Line 7797: IGS_SC_OBJ_ATTRIBS obj_group_id ,obj_attrib_id

7793: IGS_SC_OBJ_FUNCTNS function_id,obj_group_id
7794:
7795: IGS_SC_OBJ_ATT_MTHS object_id,obj_attrib_id
7796:
7797: IGS_SC_OBJ_ATTRIBS obj_group_id ,obj_attrib_id
7798:
7799: IGS_SC_OBJ_ATT_VALS object_id,obj_attrib_id
7800:
7801: IGS_SC_OBJ_GRANTS grant_id,object_id

Line 7834: CURSOR igs_sc_obj_attribs_c IS

7830: FROM igs_sc_obj_functns
7831: ORDER BY function_id
7832: FOR UPDATE OF function_id;
7833:
7834: CURSOR igs_sc_obj_attribs_c IS
7835: SELECT obj_attrib_id
7836: FROM igs_sc_obj_attribs
7837: ORDER BY obj_attrib_id
7838: FOR UPDATE OF obj_attrib_id;

Line 7836: FROM igs_sc_obj_attribs

7832: FOR UPDATE OF function_id;
7833:
7834: CURSOR igs_sc_obj_attribs_c IS
7835: SELECT obj_attrib_id
7836: FROM igs_sc_obj_attribs
7837: ORDER BY obj_attrib_id
7838: FOR UPDATE OF obj_attrib_id;
7839:
7840: l_current_seq NUMBER;

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 7954: FOR igs_sc_obj_attribs_rec IN igs_sc_obj_attribs_c LOOP

7950: -- UPDATE OBJ ATTRIBS
7951:
7952: l_current_seq := 1;
7953:
7954: FOR igs_sc_obj_attribs_rec IN igs_sc_obj_attribs_c LOOP
7955:
7956: IF igs_sc_obj_attribs_rec.obj_attrib_id <> l_current_seq THEN
7957:
7958: -- Update all tables

Line 7956: IF igs_sc_obj_attribs_rec.obj_attrib_id <> l_current_seq THEN

7952: l_current_seq := 1;
7953:
7954: FOR igs_sc_obj_attribs_rec IN igs_sc_obj_attribs_c LOOP
7955:
7956: IF igs_sc_obj_attribs_rec.obj_attrib_id <> l_current_seq THEN
7957:
7958: -- Update all tables
7959:
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;

Line 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;

7956: IF igs_sc_obj_attribs_rec.obj_attrib_id <> l_current_seq THEN
7957:
7958: -- Update all tables
7959:
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;

Line 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;

7958: -- Update all tables
7959:
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

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:

Line 7967: UPDATE igs_sc_obj_attribs SET obj_attrib_id = l_current_seq WHERE CURRENT OF igs_sc_obj_attribs_c;

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:
7969: END IF;
7970:
7971: l_current_seq := l_current_seq +1;