APPS.IBY_SECURITY_PKG dependencies on FND_API

Line 159: IF FND_API.to_Boolean( p_commit ) THEN

155: last_updated_by = fnd_global.user_id,
156: last_update_login = fnd_global.login_id;
157: END IF;
158:
159: IF FND_API.to_Boolean( p_commit ) THEN
160: COMMIT;
161: END IF;
162: END Create_Sys_Key;
163:

Line 207: IF FND_API.to_Boolean( p_commit ) THEN

203: last_update_date = sysdate,
204: last_updated_by = fnd_global.user_id,
205: last_update_login = fnd_global.login_id;
206:
207: IF FND_API.to_Boolean( p_commit ) THEN
208: COMMIT;
209: END IF;
210: END Change_Sys_Key;
211:

Line 289: IF FND_API.to_Boolean( p_commit ) THEN

285: WHERE (sec_subkey_id = x_subkey_id);
286: END IF;
287: END IF;
288:
289: IF FND_API.to_Boolean( p_commit ) THEN
290: COMMIT;
291: END IF;
292: END Get_Sys_Subkey;
293:

Line 309: (p_commit IN VARCHAR2 := FND_API.G_FALSE,

305: );
306: END Get_Sys_Subkey;
307:
308: PROCEDURE Get_Sys_Subkey_Hex
309: (p_commit IN VARCHAR2 := FND_API.G_FALSE,
310: p_sys_key IN DES3_KEY_TYPE,
311: p_inc_use_flag IN VARCHAR2,
312: x_subkey_id OUT NOCOPY iby_sys_security_subkeys.sec_subkey_id%TYPE,
313: x_subkey_Hex OUT NOCOPY VARCHAR2

Line 641: (FND_API.G_FALSE,p_sys_key,'Y',lx_subkey_id,lx_subkey);

637: lx_subkey iby_sys_security_subkeys.subkey_cipher_text%TYPE;
638: BEGIN
639:
640: IBY_SECURITY_PKG.Get_Sys_Subkey
641: (FND_API.G_FALSE,p_sys_key,'Y',lx_subkey_id,lx_subkey);
642:
643: l_segment_cipher :=
644: DBMS_OBFUSCATION_TOOLKIT.des3encrypt
645: (input => p_segment, key => lx_subkey,

Line 661: IF FND_API.to_Boolean(p_commit) THEN

657: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
658: fnd_global.login_id, 1
659: );
660:
661: IF FND_API.to_Boolean(p_commit) THEN
662: COMMIT;
663: END IF;
664: END Create_Segment;
665:

Line 710: x_verify := FND_API.G_FALSE;

706: PROCEDURE Verify_Credential
707: ( p_key IN VARCHAR2, p_cred IN NUMBER, x_verify OUT NOCOPY VARCHAR2 )
708: IS
709: BEGIN
710: x_verify := FND_API.G_FALSE;
711: IF (fnd_gfm.one_time_use_retrieve(p_cred)=1) THEN
712: x_verify := FND_API.G_TRUE;
713: END IF;
714: EXCEPTION

Line 712: x_verify := FND_API.G_TRUE;

708: IS
709: BEGIN
710: x_verify := FND_API.G_FALSE;
711: IF (fnd_gfm.one_time_use_retrieve(p_cred)=1) THEN
712: x_verify := FND_API.G_TRUE;
713: END IF;
714: EXCEPTION
715: WHEN OTHERS THEN
716: x_verify := FND_API.G_FALSE;

Line 716: x_verify := FND_API.G_FALSE;

712: x_verify := FND_API.G_TRUE;
713: END IF;
714: EXCEPTION
715: WHEN OTHERS THEN
716: x_verify := FND_API.G_FALSE;
717: END Verify_Credential;
718:
719:
720:

Line 767: IF (FND_API.To_Boolean(p_salt)) THEN

763: -- !!! WARNING: DO NOT CHANGE THE SALTING FUNCTION !!!
764: -- !!! THIS WILL CORRUPT EVERY ENTITY THAT STORES !!!
765: -- !!! A SALTED HASH VALUE (HASH_VALUE_2) !!!
766: --
767: IF (FND_API.To_Boolean(p_salt)) THEN
768: l_hash := dbms_obfuscation_toolkit.md5
769: (input_string => p_text||SUBSTR(p_text,-1));
770: ELSE
771: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);

Line 787: IF (FND_API.To_Boolean(p_salt)) THEN

783: -- !!! WARNING: DO NOT CHANGE THE SALTING FUNCTION !!!
784: -- !!! THIS WILL CORRUPT EVERY ENTITY THAT STORES !!!
785: -- !!! A SALTED HASH VALUE (HASH_VALUE_2) !!!
786: --
787: IF (FND_API.To_Boolean(p_salt)) THEN
788: l_hash := dbms_obfuscation_toolkit.md5
789: (input_string => p_text||SUBSTR(p_text,-1));
790: ELSE
791: l_hash := dbms_obfuscation_toolkit.md5(input_string => p_text);

Line 960: Create_Segment ( FND_API.G_FALSE

956: l_fv_segment := UTL_RAW.CAST_TO_RAW(CONVERT(lx_compress_val,'AL32UTF8'));
957: l_fv_segment := PKCS5_PAD(l_fv_segment);
958:
959: IF (p_sec_segment_id IS NULL) THEN
960: Create_Segment ( FND_API.G_FALSE
961: , l_fv_segment
962: , iby_security_pkg.G_ENCODING_UTF8_AL32
963: , master_key_in
964: , x_sec_segment_id

Line 975: Update_Segment ( FND_API.G_FALSE

971: , iby_security_segments ss
972: WHERE sk.sec_subkey_id = ss.sec_subkey_id
973: AND ss.sec_segment_id = p_sec_segment_id;
974: END;
975: Update_Segment ( FND_API.G_FALSE
976: , p_sec_segment_id
977: , l_fv_segment
978: , iby_security_pkg.G_ENCODING_UTF8_AL32
979: , master_key_in