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_FUNCTNS

Line 151: l_function_id igs_sc_obj_functns.function_id%TYPE;

147: l_grant_delete_flag igs_sc_grants.grant_delete_flag%TYPE;
148: l_grant_update_flag igs_sc_grants.grant_update_flag%TYPE;
149: l_grant_insert_flag igs_sc_grants.grant_insert_flag%TYPE;
150: l_locked_flag igs_sc_grants.locked_flag%TYPE := 'N';
151: l_function_id igs_sc_obj_functns.function_id%TYPE;
152: l_obj_group_id igs_sc_objects.object_id%TYPE;
153: l_user_group_id wf_local_roles.orig_system_id%TYPE;
154:
155: BEGIN

Line 1100: table igs_sc_obj_functns. There is validation

1096: Created By : Don Shellito
1097: Date Created By : April 23, 2003
1098: Purpose : The purpose of this procedure is for the
1099: handling of the inserting of data into the
1100: table igs_sc_obj_functns. There is validation
1101: performed on the obj_group_id to ensure that
1102: the value given is present in the OSS data
1103: model.
1104: Remarks :

Line 1115: p_function_id IN OUT NOCOPY igs_sc_obj_functns.function_id%TYPE,

1111: ******************************************************************/
1112: PROCEDURE Insert_Object_Func (p_api_version IN NUMBER,
1113: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1114: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1115: p_function_id IN OUT NOCOPY igs_sc_obj_functns.function_id%TYPE,
1116: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
1117: p_function_name IN igs_sc_obj_functns.function_name%TYPE,
1118: x_return_status OUT NOCOPY VARCHAR2,
1119: x_return_message OUT NOCOPY VARCHAR2

Line 1116: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,

1112: PROCEDURE Insert_Object_Func (p_api_version IN NUMBER,
1113: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1114: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1115: p_function_id IN OUT NOCOPY igs_sc_obj_functns.function_id%TYPE,
1116: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
1117: p_function_name IN igs_sc_obj_functns.function_name%TYPE,
1118: x_return_status OUT NOCOPY VARCHAR2,
1119: x_return_message OUT NOCOPY VARCHAR2
1120: ) IS

Line 1117: p_function_name IN igs_sc_obj_functns.function_name%TYPE,

1113: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1114: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1115: p_function_id IN OUT NOCOPY igs_sc_obj_functns.function_id%TYPE,
1116: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
1117: p_function_name IN igs_sc_obj_functns.function_name%TYPE,
1118: x_return_status OUT NOCOPY VARCHAR2,
1119: x_return_message OUT NOCOPY VARCHAR2
1120: ) IS
1121:

Line 1130: l_obj_group_id igs_sc_obj_functns.obj_group_id%TYPE;

1126: l_api_version CONSTANT NUMBER := 1.0;
1127: l_return_message VARCHAR2(2000);
1128: l_message_count NUMBER(15);
1129: l_return_status VARCHAR2(30);
1130: l_obj_group_id igs_sc_obj_functns.obj_group_id%TYPE;
1131:
1132: BEGIN
1133:
1134: SAVEPOINT Insert_Object_Func_SP;

Line 1194: INTO igs_sc_obj_functns

1190: -- -----------------------------------------------------------------
1191: -- Insert the values requested into the Grants table.
1192: -- -----------------------------------------------------------------
1193: INSERT
1194: INTO igs_sc_obj_functns
1195: (function_id,
1196: obj_group_id,
1197: function_name,
1198: creation_date,

Line 1204: VALUES (NVL(igs_sc_obj_functns_s.nextval,p_function_id),

1200: last_updated_by,
1201: last_update_date,
1202: last_update_login
1203: )
1204: VALUES (NVL(igs_sc_obj_functns_s.nextval,p_function_id),
1205: l_obj_group_id,
1206: p_function_name,
1207: SYSDATE,
1208: NVL(FND_GLOBAL.user_id,-1),

Line 3565: to be made to the table igs_sc_obj_functns.

3561: /******************************************************************
3562: Created By : Don Shellito
3563: Date Created By : April 23, 2003
3564: Purpose : This procedure is designed for the updates
3565: to be made to the table igs_sc_obj_functns.
3566: There are validations performed on the IDs that
3567: are provided to ensure they exist in the OSS
3568: data model.
3569: Remarks :

Line 3580: p_function_id IN igs_sc_obj_functns.function_id%TYPE,

3576: ******************************************************************/
3577: PROCEDURE Update_Object_Func (p_api_version IN NUMBER,
3578: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3579: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3580: p_function_id IN igs_sc_obj_functns.function_id%TYPE,
3581: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
3582: p_function_name IN igs_sc_obj_functns.function_name%TYPE,
3583: x_return_status OUT NOCOPY VARCHAR2,
3584: x_return_message OUT NOCOPY VARCHAR2

Line 3581: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,

3577: PROCEDURE Update_Object_Func (p_api_version IN NUMBER,
3578: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3579: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3580: p_function_id IN igs_sc_obj_functns.function_id%TYPE,
3581: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
3582: p_function_name IN igs_sc_obj_functns.function_name%TYPE,
3583: x_return_status OUT NOCOPY VARCHAR2,
3584: x_return_message OUT NOCOPY VARCHAR2
3585: ) IS

Line 3582: p_function_name IN igs_sc_obj_functns.function_name%TYPE,

3578: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3579: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3580: p_function_id IN igs_sc_obj_functns.function_id%TYPE,
3581: p_obj_group_id IN igs_sc_obj_functns.obj_group_id%TYPE,
3582: p_function_name IN igs_sc_obj_functns.function_name%TYPE,
3583: x_return_status OUT NOCOPY VARCHAR2,
3584: x_return_message OUT NOCOPY VARCHAR2
3585: ) IS
3586:

Line 3596: l_obj_group_id igs_sc_obj_functns.obj_group_id%TYPE;

3592: l_update_oper CONSTANT VARCHAR2(30) := 'UPDATE';
3593: l_return_message VARCHAR2(2000);
3594: l_message_count NUMBER(15);
3595: l_return_status VARCHAR2(30);
3596: l_obj_group_id igs_sc_obj_functns.obj_group_id%TYPE;
3597: l_function_name igs_sc_obj_functns.function_name%TYPE;
3598: l_grant_id igs_sc_grants.grant_id%TYPE;
3599: l_grant_name igs_sc_grants.grant_name%TYPE;
3600:

Line 3597: l_function_name igs_sc_obj_functns.function_name%TYPE;

3593: l_return_message VARCHAR2(2000);
3594: l_message_count NUMBER(15);
3595: l_return_status VARCHAR2(30);
3596: l_obj_group_id igs_sc_obj_functns.obj_group_id%TYPE;
3597: l_function_name igs_sc_obj_functns.function_name%TYPE;
3598: l_grant_id igs_sc_grants.grant_id%TYPE;
3599: l_grant_name igs_sc_grants.grant_name%TYPE;
3600:
3601: -- -----------------------------------------------------------------

Line 3607: FROM igs_sc_obj_functns fnc

3603: -- -----------------------------------------------------------------
3604: CURSOR c_get_func_values IS
3605: SELECT fnc.obj_group_id,
3606: fnc.function_name
3607: FROM igs_sc_obj_functns fnc
3608: WHERE fnc.function_id = p_function_id;
3609:
3610: CURSOR c_get_grants IS
3611: SELECT grt.grant_id,

Line 3697: UPDATE igs_sc_obj_functns fnct

3693:
3694: -- -----------------------------------------------------------------
3695: -- Update the object function values received.
3696: -- -----------------------------------------------------------------
3697: UPDATE igs_sc_obj_functns fnct
3698: SET fnct.function_name = p_function_name,
3699: fnct.last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3700: fnct.last_update_date = SYSDATE,
3701: fnct.last_update_login = NVL(FND_GLOBAL.login_id, -1)

Line 4293: l_function_id igs_sc_obj_functns.function_id%TYPE;

4289: -- -----------------------------------------------------------------
4290: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Object_Group';
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);

Line 4310: FROM igs_sc_obj_functns funcs

4306: WHERE objs.obj_group_id = p_obj_group_id;
4307:
4308: CURSOR c_get_function_id IS
4309: SELECT funcs.function_id
4310: FROM igs_sc_obj_functns funcs
4311: WHERE funcs.obj_group_id = p_obj_group_id;
4312:
4313: CURSOR c_get_grant_id IS
4314: SELECT grts.grant_id

Line 4913: p_function_id IN igs_sc_obj_functns.function_id%TYPE,

4909: ******************************************************************/
4910: PROCEDURE Delete_Object_Func (p_api_version IN NUMBER,
4911: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4912: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4913: p_function_id IN igs_sc_obj_functns.function_id%TYPE,
4914: x_return_status OUT NOCOPY VARCHAR2,
4915: x_return_message OUT NOCOPY VARCHAR2
4916: ) IS
4917:

Line 4934: igs_sc_obj_functns fnc

4930: -- -----------------------------------------------------------------
4931: CURSOR c_get_grant_id IS
4932: SELECT grt.grant_id
4933: FROM igs_sc_grants grt,
4934: igs_sc_obj_functns fnc
4935: WHERE fnc.function_id = p_function_id
4936: AND grt.function_id = fnc.function_id
4937: AND grt.obj_group_id = fnc.obj_group_id;
4938:

Line 5010: FROM igs_sc_obj_functns fctn

5006: -- -----------------------------------------------------------------
5007: -- Delete the function that is provided.
5008: -- -----------------------------------------------------------------
5009: DELETE
5010: FROM igs_sc_obj_functns fctn
5011: WHERE fctn.function_id = p_function_id;
5012:
5013: -- -----------------------------------------------------------------
5014: -- Commit the transaction if requested to via parameter value.

Line 6732: l_function_id igs_sc_obj_functns.function_id%TYPE;

6728: -- -----------------------------------------------------------------
6729: -- Define local variables to be used.
6730: -- -----------------------------------------------------------------
6731: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Function_ID';
6732: l_function_id igs_sc_obj_functns.function_id%TYPE;
6733:
6734: -- -----------------------------------------------------------------
6735: -- Define the cursors to be used in procedure.
6736: -- -----------------------------------------------------------------

Line 6739: FROM igs_sc_obj_functns fnc

6735: -- Define the cursors to be used in procedure.
6736: -- -----------------------------------------------------------------
6737: CURSOR c_check_func_id IS
6738: SELECT fnc.function_id
6739: FROM igs_sc_obj_functns fnc
6740: WHERE fnc.function_id = p_function_id;
6741:
6742: BEGIN
6743:

Line 7793: IGS_SC_OBJ_FUNCTNS function_id,obj_group_id

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
7794:
7795: IGS_SC_OBJ_ATT_MTHS object_id,obj_attrib_id
7796:
7797: IGS_SC_OBJ_ATTRIBS obj_group_id ,obj_attrib_id

Line 7828: CURSOR igs_sc_obj_functns_c IS

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
7829: SELECT function_id
7830: FROM igs_sc_obj_functns
7831: ORDER BY function_id
7832: FOR UPDATE OF function_id;

Line 7830: FROM igs_sc_obj_functns

7826: FOR UPDATE OF obj_group_id;
7827:
7828: CURSOR igs_sc_obj_functns_c IS
7829: SELECT function_id
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

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 7932: FOR igs_sc_obj_functns_rec IN igs_sc_obj_functns_c LOOP

7928: -- UPDATE FUNCTIONS
7929:
7930: l_current_seq := 1;
7931:
7932: FOR igs_sc_obj_functns_rec IN igs_sc_obj_functns_c LOOP
7933:
7934: IF igs_sc_obj_functns_rec.function_id <> l_current_seq THEN
7935:
7936: -- Update all tables

Line 7934: IF igs_sc_obj_functns_rec.function_id <> l_current_seq THEN

7930: l_current_seq := 1;
7931:
7932: FOR igs_sc_obj_functns_rec IN igs_sc_obj_functns_c LOOP
7933:
7934: IF igs_sc_obj_functns_rec.function_id <> l_current_seq THEN
7935:
7936: -- Update all tables
7937:
7938: UPDATE IGS_SC_GRANTS SET function_id = l_current_seq WHERE function_id = igs_sc_obj_functns_rec.function_id;

Line 7938: UPDATE IGS_SC_GRANTS SET function_id = l_current_seq WHERE function_id = igs_sc_obj_functns_rec.function_id;

7934: IF igs_sc_obj_functns_rec.function_id <> l_current_seq THEN
7935:
7936: -- Update all tables
7937:
7938: UPDATE IGS_SC_GRANTS SET function_id = l_current_seq WHERE function_id = igs_sc_obj_functns_rec.function_id;
7939:
7940: -- Update table itself
7941: UPDATE igs_sc_obj_functns SET function_id = l_current_seq WHERE CURRENT OF igs_sc_obj_functns_c;
7942:

Line 7941: UPDATE igs_sc_obj_functns SET function_id = l_current_seq WHERE CURRENT OF igs_sc_obj_functns_c;

7937:
7938: UPDATE IGS_SC_GRANTS SET function_id = l_current_seq WHERE function_id = igs_sc_obj_functns_rec.function_id;
7939:
7940: -- Update table itself
7941: UPDATE igs_sc_obj_functns SET function_id = l_current_seq WHERE CURRENT OF igs_sc_obj_functns_c;
7942:
7943: END IF;
7944:
7945: l_current_seq := l_current_seq +1;