APPS.PER_SECURITY_PROFILES_PKG dependencies on PER_SECURITY_PROFILES_S

Line 47: CURSOR C2 IS SELECT per_security_profiles_s.nextval FROM sys.dual;

43: ) IS
44: CURSOR C IS SELECT rowid FROM per_security_profiles
45: WHERE security_profile_id = X_Security_Profile_Id;
46: --
47: CURSOR C2 IS SELECT per_security_profiles_s.nextval FROM sys.dual;
48: BEGIN
49:
50: if (X_Security_Profile_Id is NULL) then
51: OPEN C2;

Line 428: l_security_profile_id per_security_profiles.SECURITY_PROFILE_ID%type;

424: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
425: --Bug 5021035 starts here5021035
426: l_dummy_number number;
427: v_record_exists boolean := FALSE;
428: l_security_profile_id per_security_profiles.SECURITY_PROFILE_ID%type;
429: cursor prfl_assignmen(p_profile_id number) is select null
430: from PER_SEC_PROFILE_ASSIGNMENTS a
431: where a.security_profile_id = p_profile_id;
432: --Bug 5021035 ends here