APPS.AD_JAR dependencies on AD_JAR

Line 1: package body AD_JAR as

1: package body AD_JAR as
2: /* $Header: ADJRIB.pls 120.0.12020000.2 2013/05/16 04:29:40 mkumandu noship $ */
3:
4:
5: /*-----------------------------------------------------------------+

Line 17: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');

13: l_storepass varchar2(30);
14: l_keypass varchar2(30);
15: begin
16:
17: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');
18:
19: l_storepass := fnd_vault.get('AD_JAR', 'STOREPASS');
20: l_keypass := fnd_vault.get('AD_JAR', 'KEYPASS');
21:

Line 19: l_storepass := fnd_vault.get('AD_JAR', 'STOREPASS');

15: begin
16:
17: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');
18:
19: l_storepass := fnd_vault.get('AD_JAR', 'STOREPASS');
20: l_keypass := fnd_vault.get('AD_JAR', 'KEYPASS');
21:
22: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');
23:

Line 20: l_keypass := fnd_vault.get('AD_JAR', 'KEYPASS');

16:
17: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');
18:
19: l_storepass := fnd_vault.get('AD_JAR', 'STOREPASS');
20: l_keypass := fnd_vault.get('AD_JAR', 'KEYPASS');
21:
22: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');
23:
24: storepass := nvl(l_storepass, 'NOT-EXIST');

Line 22: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');

18:
19: l_storepass := fnd_vault.get('AD_JAR', 'STOREPASS');
20: l_keypass := fnd_vault.get('AD_JAR', 'KEYPASS');
21:
22: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');
23:
24: storepass := nvl(l_storepass, 'NOT-EXIST');
25: keypass := nvl(l_keypass, 'NOT-EXIST');
26:

Line 44: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');

40: then
41: raise_application_error(-20001, 'Both Store Password and Key Password cannot be null');
42: end if;
43:
44: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');
45:
46: if (storepass is not null)
47: then
48: fnd_vault.puts('AD_JAR', 'STOREPASS', storepass);

Line 48: fnd_vault.puts('AD_JAR', 'STOREPASS', storepass);

44: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');
45:
46: if (storepass is not null)
47: then
48: fnd_vault.puts('AD_JAR', 'STOREPASS', storepass);
49: end if;
50:
51: if (keypass is not null)
52: then

Line 53: fnd_vault.puts('AD_JAR', 'KEYPASS', keypass);

49: end if;
50:
51: if (keypass is not null)
52: then
53: fnd_vault.puts('AD_JAR', 'KEYPASS', keypass);
54: end if;
55:
56: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');
57:

Line 56: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');

52: then
53: fnd_vault.puts('AD_JAR', 'KEYPASS', keypass);
54: end if;
55:
56: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');
57:
58: end put_jripasswords;
59:
60:

Line 70: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');

66: procedure del_jripasswords
67: is
68: begin
69:
70: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');
71:
72: fnd_vault.del('AD_JAR', 'STOREPASS');
73: fnd_vault.del('AD_JAR', 'KEYPASS');
74:

Line 72: fnd_vault.del('AD_JAR', 'STOREPASS');

68: begin
69:
70: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');
71:
72: fnd_vault.del('AD_JAR', 'STOREPASS');
73: fnd_vault.del('AD_JAR', 'KEYPASS');
74:
75: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');
76:

Line 73: fnd_vault.del('AD_JAR', 'KEYPASS');

69:
70: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'Y');
71:
72: fnd_vault.del('AD_JAR', 'STOREPASS');
73: fnd_vault.del('AD_JAR', 'KEYPASS');
74:
75: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');
76:
77: end del_jripasswords;

Line 75: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');

71:
72: fnd_vault.del('AD_JAR', 'STOREPASS');
73: fnd_vault.del('AD_JAR', 'KEYPASS');
74:
75: dbms_session.set_context('AD_JAR', 'VAULT_ACCESS', 'N');
76:
77: end del_jripasswords;
78:
79:

Line 80: end AD_JAR;

76:
77: end del_jripasswords;
78:
79:
80: end AD_JAR;