DBA Data[Home] [Help]

APPS.IBY_SECURITY_PKG dependencies on FND_GLOBAL

Line 155: last_updated_by = fnd_global.user_id,

151: salt_version = get_salt_version,
152: sys_key_file_location = p_wallet_path,
153: object_version_number = object_version_number + 1,
154: last_update_date = sysdate,
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

Line 156: last_update_login = fnd_global.login_id;

152: sys_key_file_location = p_wallet_path,
153: object_version_number = object_version_number + 1,
154: last_update_date = sysdate,
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;

Line 194: last_updated_by = fnd_global.user_id,

190: SET subkey_cipher_text =
191: Recipher_Key(subkey_cipher_text,p_sys_key_old,p_sys_key_new),
192: object_version_number = object_version_number + 1,
193: last_update_date = sysdate,
194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.login_id;
196:
197: -- update system key hash
198: UPDATE iby_sys_security_options

Line 195: last_update_login = fnd_global.login_id;

191: Recipher_Key(subkey_cipher_text,p_sys_key_old,p_sys_key_new),
192: object_version_number = object_version_number + 1,
193: last_update_date = sysdate,
194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.login_id;
196:
197: -- update system key hash
198: UPDATE iby_sys_security_options
199: SET sys_key_hash = get_key_hash(p_sys_key_new),

Line 204: last_updated_by = fnd_global.user_id,

200: salt_version = get_salt_version,
201: sys_key_file_location = p_wallet_path_new,
202: object_version_number = object_version_number + 1,
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;

Line 205: last_update_login = fnd_global.login_id;

201: sys_key_file_location = p_wallet_path_new,
202: object_version_number = object_version_number + 1,
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;

Line 266: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

262: created_by, creation_date, last_updated_by, last_update_date,
263: last_update_login, object_version_number)
264: VALUES
265: (x_subkey_id, l_subkey_ciphertxt, 1,
266: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
267: fnd_global.login_id, 1);
268: ELSE
269: -- valid subkey existing found
270: x_subkey :=

Line 267: fnd_global.login_id, 1);

263: last_update_login, object_version_number)
264: VALUES
265: (x_subkey_id, l_subkey_ciphertxt, 1,
266: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
267: fnd_global.login_id, 1);
268: ELSE
269: -- valid subkey existing found
270: x_subkey :=
271: dbms_obfuscation_toolkit.des3decrypt

Line 283: last_updated_by = fnd_global.user_id,

279: UPDATE iby_sys_security_subkeys
280: SET use_count = use_count + 1,
281: object_version_number = object_version_number + 1,
282: last_update_date = sysdate,
283: last_updated_by = fnd_global.user_id,
284: last_update_login = fnd_global.login_id
285: WHERE (sec_subkey_id = x_subkey_id);
286: END IF;
287: END IF;

Line 284: last_update_login = fnd_global.login_id

280: SET use_count = use_count + 1,
281: object_version_number = object_version_number + 1,
282: last_update_date = sysdate,
283: last_updated_by = fnd_global.user_id,
284: last_update_login = fnd_global.login_id
285: WHERE (sec_subkey_id = x_subkey_id);
286: END IF;
287: END IF;
288:

Line 657: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,

653: last_update_login, object_version_number
654: )
655: VALUES
656: (x_segment_id, l_segment_cipher, lx_subkey_id, p_encoding,
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

Line 658: fnd_global.login_id, 1

654: )
655: VALUES
656: (x_segment_id, l_segment_cipher, lx_subkey_id, p_encoding,
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;

Line 693: last_updated_by = fnd_global.user_id,

689: UPDATE iby_security_segments
690: SET
691: segment_cipher_text = l_segment_cipher,
692: encoding_scheme = NVL(p_encoding,encoding_scheme),
693: last_updated_by = fnd_global.user_id,
694: last_update_date = SYSDATE,
695: last_update_login = fnd_global.user_id,
696: object_version_number = object_version_number + 1
697: WHERE sec_segment_id=p_segment_id;

Line 695: last_update_login = fnd_global.user_id,

691: segment_cipher_text = l_segment_cipher,
692: encoding_scheme = NVL(p_encoding,encoding_scheme),
693: last_updated_by = fnd_global.user_id,
694: last_update_date = SYSDATE,
695: last_update_login = fnd_global.user_id,
696: object_version_number = object_version_number + 1
697: WHERE sec_segment_id=p_segment_id;
698: END Update_Segment;
699: