APPS.FND_OAM_METALINK_CREDS dependencies on FND_OAM_METALINK_CRED

Line 1: PACKAGE BODY fnd_oam_metalink_creds AS

1: PACKAGE BODY fnd_oam_metalink_creds AS
2: /* $Header: AFOAMMCB.pls 120.2 2005/10/19 11:26:34 ilawler noship $ */
3:
4: PROCEDURE dbg_print(p_msg varchar2)
5: AS

Line 19: -- fnd_oam_metalink_cred. If a row already exists for given username

15: -- put_credentials
16: --
17: -- Purpose
18: -- Stores the given metalink credentials for the given user in
19: -- fnd_oam_metalink_cred. If a row already exists for given username
20: -- it will update, otherwise it will insert a new row
21: --
22: -- Input Arguments
23: -- p_username - Applications username

Line 46: v_enc fnd_oam_metalink_cred.metalink_password%TYPE;

42:
43: v_key raw(24);
44: v_encr raw(2000);
45: v_dec raw(2000);
46: v_enc fnd_oam_metalink_cred.metalink_password%TYPE;
47:
48: BEGIN
49: p_retcode := 0;
50: p_errmsg := '';

Line 78: from fnd_oam_metalink_cred

74:
75:
76: begin
77: select user_id into v_userid
78: from fnd_oam_metalink_cred
79: where user_id = v_userid;
80:
81: update fnd_oam_metalink_cred set
82: metalink_user_id = p_metalink_userid,

Line 81: update fnd_oam_metalink_cred set

77: select user_id into v_userid
78: from fnd_oam_metalink_cred
79: where user_id = v_userid;
80:
81: update fnd_oam_metalink_cred set
82: metalink_user_id = p_metalink_userid,
83: metalink_password = v_enc,
84: email_address = p_email_address,
85: last_updated_by = v_userid,

Line 91: insert into fnd_oam_metalink_cred (

87: last_update_login = 0
88: where user_id = v_userid;
89: exception
90: when no_data_found then
91: insert into fnd_oam_metalink_cred (
92: user_id,
93: metalink_user_id,
94: metalink_password,
95: email_address,

Line 147: v_enc fnd_oam_metalink_cred.metalink_password%TYPE;

143: AS
144: v_key raw(24);
145: v_encr raw(2000);
146: v_dec raw(2000);
147: v_enc fnd_oam_metalink_cred.metalink_password%TYPE;
148: BEGIN
149: p_retcode := 0;
150: p_errmsg := '';
151: p_metalink_userid := '';

Line 161: from fnd_oam_metalink_cred fom,

157: fom.email_address
158: into p_metalink_userid,
159: v_enc,
160: p_email_address
161: from fnd_oam_metalink_cred fom,
162: fnd_user fu
163: where fu.user_id = fom.user_id
164: and upper(fu.user_name) = upper(p_username);
165:

Line 211: fnd_oam_metalink_creds.put_credentials(

207: v_username varchar2(30) := 'anonymous';
208:
209: BEGIN
210: dbg_print('Adding credentials .. ');
211: fnd_oam_metalink_creds.put_credentials(
212: p_username => v_username,
213: p_metalink_userid => 'test_user',
214: p_metalink_password => 'welcome1',
215: p_email_address => '[email protected]',

Line 222: fnd_oam_metalink_creds.get_credentials(

218: dbg_print('Ret code: ' || to_char(v_retcode));
219: dbg_print('Err msg: ' || v_errmsg);
220:
221: dbg_print('Getting credentials .. ');
222: fnd_oam_metalink_creds.get_credentials(
223: p_username => v_username,
224: p_metalink_userid => v_mlink_userid,
225: p_metalink_password => v_mlink_pw,
226: p_email_address => v_email,

Line 236: fnd_oam_metalink_creds.put_credentials(

232: dbg_print('Mlink pw: ' || v_mlink_pw);
233: dbg_print('Email: ' || v_email);
234:
235: dbg_print('Updating credentials .. ');
236: fnd_oam_metalink_creds.put_credentials(
237: p_username => v_username,
238: p_metalink_userid => 'test_user2',
239: p_metalink_password => 'abcdefghijklmnopqrstuvwxyz0123456789',
240: p_email_address => '[email protected]',

Line 247: fnd_oam_metalink_creds.get_credentials(

243: dbg_print('Ret code: ' || to_char(v_retcode));
244: dbg_print('Err msg: ' || v_errmsg);
245:
246: dbg_print('Getting credentials .. ');
247: fnd_oam_metalink_creds.get_credentials(
248: p_username => v_username,
249: p_metalink_userid => v_mlink_userid,
250: p_metalink_password => v_mlink_pw,
251: p_email_address => v_email,

Line 264: END fnd_oam_metalink_creds;

260: dbg_print('Rolling back test data .. ');
261: rollback;
262: END test;
263:
264: END fnd_oam_metalink_creds;