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_ATT_MTHS

Line 886: of data insertion into the igs_sc_obj_att_mths

882: /******************************************************************
883: Created By : Don Shellito
884: Date Created By : April 23, 2003
885: Purpose : The purpose of this procedure is for the handling
886: of data insertion into the igs_sc_obj_att_mths
887: table. There is validation performed on the
888: object_id, obj_attrib_id, obj_attrib_type, and
889: static_type to ensure that the values given are
890: in the OSS data model or have valid values expected

Line 903: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,

899: ******************************************************************/
900: PROCEDURE Insert_Object_Attr_Method (p_api_version IN NUMBER,
901: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
902: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
903: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
904: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
905: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
906: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
907: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,

Line 904: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,

900: PROCEDURE Insert_Object_Attr_Method (p_api_version IN NUMBER,
901: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
902: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
903: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
904: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
905: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
906: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
907: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
908: p_null_allow_flag IN VARCHAR2 DEFAULT 'N',

Line 905: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,

901: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
902: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
903: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
904: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
905: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
906: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
907: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
908: p_null_allow_flag IN VARCHAR2 DEFAULT 'N',
909: p_call_from_lct IN VARCHAR2 DEFAULT 'N',

Line 906: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,

902: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
903: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
904: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
905: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
906: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
907: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
908: p_null_allow_flag IN VARCHAR2 DEFAULT 'N',
909: p_call_from_lct IN VARCHAR2 DEFAULT 'N',
910: x_return_status OUT NOCOPY VARCHAR2,

Line 907: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,

903: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
904: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
905: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
906: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
907: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
908: p_null_allow_flag IN VARCHAR2 DEFAULT 'N',
909: p_call_from_lct IN VARCHAR2 DEFAULT 'N',
910: x_return_status OUT NOCOPY VARCHAR2,
911: x_return_message OUT NOCOPY VARCHAR2

Line 922: l_object_id igs_sc_obj_att_mths.object_id%TYPE;

918: l_api_version CONSTANT NUMBER := 1.0;
919: l_return_message VARCHAR2(2000);
920: l_message_count NUMBER(15);
921: l_return_status VARCHAR2(30);
922: l_object_id igs_sc_obj_att_mths.object_id%TYPE;
923: l_obj_attrib_id igs_sc_obj_att_mths.obj_attrib_id%TYPE;
924: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
925: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
926: l_object_name fnd_objects.database_object_name%TYPE;

Line 923: l_obj_attrib_id igs_sc_obj_att_mths.obj_attrib_id%TYPE;

919: l_return_message VARCHAR2(2000);
920: l_message_count NUMBER(15);
921: l_return_status VARCHAR2(30);
922: l_object_id igs_sc_obj_att_mths.object_id%TYPE;
923: l_obj_attrib_id igs_sc_obj_att_mths.obj_attrib_id%TYPE;
924: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
925: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
926: l_object_name fnd_objects.database_object_name%TYPE;
927:

Line 924: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;

920: l_message_count NUMBER(15);
921: l_return_status VARCHAR2(30);
922: l_object_id igs_sc_obj_att_mths.object_id%TYPE;
923: l_obj_attrib_id igs_sc_obj_att_mths.obj_attrib_id%TYPE;
924: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
925: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
926: l_object_name fnd_objects.database_object_name%TYPE;
927:
928: BEGIN

Line 925: l_static_type igs_sc_obj_att_mths.static_type%TYPE;

921: l_return_status VARCHAR2(30);
922: l_object_id igs_sc_obj_att_mths.object_id%TYPE;
923: l_obj_attrib_id igs_sc_obj_att_mths.obj_attrib_id%TYPE;
924: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
925: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
926: l_object_name fnd_objects.database_object_name%TYPE;
927:
928: BEGIN
929:

Line 1027: INTO igs_sc_obj_att_mths

1023: -- -----------------------------------------------------------------
1024: -- Insert the values requested into the Grants table.
1025: -- -----------------------------------------------------------------
1026: INSERT
1027: INTO igs_sc_obj_att_mths
1028: (object_id,
1029: obj_attrib_id,
1030: obj_attrib_type,
1031: static_type,

Line 3284: the updates made to igs_sc_obj_att_mths is perform

3280: /******************************************************************
3281: Created By : Don Shellito
3282: Date Created By : April 23, 2003
3283: Purpose : The purpose of this procedure is to ensure that
3284: the updates made to igs_sc_obj_att_mths is perform
3285: with the proper validation. The IDs are validated
3286: to ensure they exist in the OSS data model.
3287: Remarks :
3288:

Line 3298: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,

3294: ******************************************************************/
3295: PROCEDURE Update_Object_Attr_Method (p_api_version IN NUMBER,
3296: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3298: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
3299: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
3300: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
3301: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
3302: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,

Line 3299: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,

3295: PROCEDURE Update_Object_Attr_Method (p_api_version IN NUMBER,
3296: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3298: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
3299: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
3300: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
3301: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
3302: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
3303: p_null_allow_flag IN VARCHAR2 DEFAULT 'N',

Line 3300: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,

3296: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3298: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
3299: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
3300: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
3301: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
3302: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
3303: p_null_allow_flag IN VARCHAR2 DEFAULT 'N',
3304: p_call_from_lct IN VARCHAR2 DEFAULT 'N',

Line 3301: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,

3297: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3298: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
3299: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
3300: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
3301: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
3302: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
3303: p_null_allow_flag IN VARCHAR2 DEFAULT 'N',
3304: p_call_from_lct IN VARCHAR2 DEFAULT 'N',
3305: x_return_status OUT NOCOPY VARCHAR2,

Line 3302: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,

3298: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
3299: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
3300: p_obj_attrib_type IN igs_sc_obj_att_mths.obj_attrib_type%TYPE,
3301: p_static_type IN igs_sc_obj_att_mths.static_type%TYPE,
3302: p_select_text IN igs_sc_obj_att_mths.select_text%TYPE,
3303: p_null_allow_flag IN VARCHAR2 DEFAULT 'N',
3304: p_call_from_lct IN VARCHAR2 DEFAULT 'N',
3305: x_return_status OUT NOCOPY VARCHAR2,
3306: x_return_message OUT NOCOPY VARCHAR2

Line 3318: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;

3314: l_api_version CONSTANT NUMBER := 1.0;
3315: l_return_message VARCHAR2(2000);
3316: l_message_count NUMBER(15);
3317: l_return_status VARCHAR2(30);
3318: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
3319: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
3320: l_select_text igs_sc_obj_att_mths.select_text%TYPE;
3321: l_grant_id igs_sc_grants.grant_id%TYPE;
3322: l_grant_name igs_sc_grants.grant_name%TYPE;

Line 3319: l_static_type igs_sc_obj_att_mths.static_type%TYPE;

3315: l_return_message VARCHAR2(2000);
3316: l_message_count NUMBER(15);
3317: l_return_status VARCHAR2(30);
3318: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
3319: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
3320: l_select_text igs_sc_obj_att_mths.select_text%TYPE;
3321: l_grant_id igs_sc_grants.grant_id%TYPE;
3322: l_grant_name igs_sc_grants.grant_name%TYPE;
3323: l_object_name fnd_objects.database_object_name%TYPE;

Line 3320: l_select_text igs_sc_obj_att_mths.select_text%TYPE;

3316: l_message_count NUMBER(15);
3317: l_return_status VARCHAR2(30);
3318: l_obj_attrib_type igs_sc_obj_att_mths.obj_attrib_type%TYPE;
3319: l_static_type igs_sc_obj_att_mths.static_type%TYPE;
3320: l_select_text igs_sc_obj_att_mths.select_text%TYPE;
3321: l_grant_id igs_sc_grants.grant_id%TYPE;
3322: l_grant_name igs_sc_grants.grant_name%TYPE;
3323: l_object_name fnd_objects.database_object_name%TYPE;
3324:

Line 3333: FROM igs_sc_obj_att_mths mthd

3329: CURSOR c_get_obj_mthd IS
3330: SELECT mthd.obj_attrib_type,
3331: mthd.static_type,
3332: mthd.select_text
3333: FROM igs_sc_obj_att_mths mthd
3334: WHERE mthd.object_id = p_object_id
3335: AND mthd.obj_attrib_id = p_obj_attrib_id;
3336:
3337: CURSOR c_get_grant_info IS

Line 3490: UPDATE igs_sc_obj_att_mths mthd

3486: END IF;
3487: END IF;
3488:
3489:
3490: UPDATE igs_sc_obj_att_mths mthd
3491: SET mthd.obj_attrib_type = l_obj_attrib_type,
3492: mthd.static_type = l_static_type,
3493: mthd.select_text = l_select_text,
3494: mthd.last_updated_by = NVL(FND_GLOBAL.user_id,-1),

Line 4589: l_object_id_mthd igs_sc_obj_att_mths.object_id%TYPE;

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);
4593: l_return_status VARCHAR2(30);

Line 4600: FROM igs_sc_obj_att_mths objs

4596: -- Define the cursors to be used in procedure.
4597: -- -----------------------------------------------------------------
4598: CURSOR c_get_object_id_mthd IS
4599: SELECT objs.object_id
4600: FROM igs_sc_obj_att_mths objs
4601: WHERE objs.obj_attrib_id = p_obj_attrib_id;
4602:
4603: CURSOR c_get_object_id_val IS
4604: SELECT attrs.object_id

Line 4793: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,

4789: ******************************************************************/
4790: PROCEDURE Delete_Object_Attr_Method (p_api_version IN NUMBER,
4791: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4792: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4793: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
4794: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
4795: x_return_status OUT NOCOPY VARCHAR2,
4796: x_return_message OUT NOCOPY VARCHAR2
4797: ) IS

Line 4794: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,

4790: PROCEDURE Delete_Object_Attr_Method (p_api_version IN NUMBER,
4791: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4792: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4793: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
4794: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
4795: x_return_status OUT NOCOPY VARCHAR2,
4796: x_return_message OUT NOCOPY VARCHAR2
4797: ) IS
4798:

Line 4849: FROM igs_sc_obj_att_mths mtds

4845: -- Delete all the methods associated to the object_id and the
4846: -- obj_attrib_id provided.
4847: -- -----------------------------------------------------------------
4848: DELETE
4849: FROM igs_sc_obj_att_mths mtds
4850: WHERE mtds.object_id = p_object_id
4851: AND mtds.obj_attrib_id = p_obj_attrib_id;
4852:
4853: -- -----------------------------------------------------------------

Line 5082: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,

5078: ******************************************************************/
5079: PROCEDURE Delete_Object_Attr_Val (p_api_version IN NUMBER,
5080: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5081: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5082: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
5083: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
5084: x_return_status OUT NOCOPY VARCHAR2,
5085: x_return_message OUT NOCOPY VARCHAR2
5086: ) IS

Line 5083: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,

5079: PROCEDURE Delete_Object_Attr_Val (p_api_version IN NUMBER,
5080: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5081: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5082: p_object_id IN igs_sc_obj_att_mths.object_id%TYPE,
5083: p_obj_attrib_id IN igs_sc_obj_att_mths.obj_attrib_id%TYPE,
5084: x_return_status OUT NOCOPY VARCHAR2,
5085: x_return_message OUT NOCOPY VARCHAR2
5086: ) IS
5087:

Line 7795: IGS_SC_OBJ_ATT_MTHS object_id,obj_attrib_id

7791: IGS_SC_OBJECTS object_id,obj_group_id
7792:
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

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;