APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on WF_LOCAL_ROLES

Line 153: l_user_group_id wf_local_roles.orig_system_id%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
156: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
157: l_label := 'igs.plsql.igs_sc_data_sec_apis_pkg.Insert_Grant';

Line 6911: associated to the wf_local_roles record being present.

6907: Date Created By : April 23, 2003
6908: Purpose : The purpose of this function is to ensure that
6909: the user group ID is defined in the system prior
6910: to insert or updated. The user group ID is
6911: associated to the wf_local_roles record being present.
6912: Remarks :
6913:
6914: Change History
6915: Who When What

Line 6928: l_user_group_id wf_local_roles.orig_system_id%TYPE;

6924: -- -----------------------------------------------------------------
6925: -- Define local variables to be used.
6926: -- -----------------------------------------------------------------
6927: l_api_name CONSTANT VARCHAR2(30) := 'Validate_User_Grp_ID';
6928: l_user_group_id wf_local_roles.orig_system_id%TYPE;
6929:
6930: -- -----------------------------------------------------------------
6931: -- Define the cursors to be used in procedure.
6932: -- -----------------------------------------------------------------

Line 6935: FROM wf_local_roles wflr

6931: -- Define the cursors to be used in procedure.
6932: -- -----------------------------------------------------------------
6933: CURSOR c_check_user_group_id IS
6934: SELECT wflr.orig_system_id
6935: FROM wf_local_roles wflr
6936: WHERE wflr.ORIG_SYSTEM = 'IGS'
6937: AND wflr.orig_system_id = p_user_group_id;
6938:
6939: BEGIN