1 PACKAGE IEM_UTILS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemputis.pls 120.0 2005/06/02 14:13:40 appldev noship $*/
3
4 G_key VARCHAR2(8) :='EMCENTER';
5
6 TYPE key_tbl_type IS table of VARCHAR(100) INDEX BY BINARY_INTEGER;
7
8 -- Start of Comments
9 -- API name : IEM_EncryptPassword
10 -- Type : Private
11 -- Function : This procedure is used to encrypt password.
12 -- Note, encrypted data is rounded to muliples of 8 bytes.
13 -- Pre-reqs : None.
14 -- Parameters :
15 -- IN
16 -- p_api_version_number IN NUMBER Required
17 -- p_init_msg_list IN VARCHAR2
18 -- p_commit IN VARCHAR2
19 -- p_raw_data IN VARCHAR2 Required
20 --
21 -- OUT
22 -- x_encrypted_data OUT VARCHAR2 Encrypted data
23 -- x_encrypted_key OUT VARCHAR2 Encrypted key
24 -- x_return_status OUT VARCHAR2
25 -- x_msg_count OUT NUMBER
26 -- x_msg_data OUT VARCHAR2
27 --
28 -- Version : 1.0
29 -- Notes :
30 --
31 -- End of comments
32 -- **********************************************************
33 PROCEDURE IEM_EncryptPassword(
34 P_Api_Version_Number IN NUMBER,
35 P_Init_Msg_List IN VARCHAR2,
36 P_Commit IN VARCHAR2,
37 p_raw_data IN VARCHAR2,
38 x_encrypted_data OUT NOCOPY VARCHAR2,
39 x_encrypted_key OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_data OUT NOCOPY VARCHAR2);
43
44 -- Start of Comments
45 -- API name : IEM_DecryptPassword
46 -- Type : Private
47 -- Function : This procedure is used to decrypt password.
48 -- Pre-reqs : None.
49 -- Parameters :
50 -- IN
51 -- p_api_version_number IN NUMBER Required
52 -- p_init_msg_list IN VARCHAR2
53 -- p_commit IN VARCHAR2
54 -- p_input_data IN VARCHAR2 Required
55 -- p_decrypted_key IN VARCHAR2,
56 --
57 -- OUT
58 -- x_decrypted_data OUT VARCHAR2
59 -- x_return_status OUT VARCHAR2
60 -- x_msg_count OUT NUMBER
61 -- x_msg_data OUT VARCHAR2
62 --
63 -- Version : 1.0
64 -- Notes :
65 --
66 -- End of comments
67 -- **********************************************************
68 PROCEDURE IEM_DecryptPassword(
69 P_Api_Version_Number IN NUMBER,
70 P_Init_Msg_List IN VARCHAR2,
71 P_Commit IN VARCHAR2,
72 p_input_data IN VARCHAR2,
73 p_decrypted_key IN VARCHAR2,
74 x_decrypted_data OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_data OUT NOCOPY VARCHAR2);
78
79
80 FUNCTION varchar_to_table ( inString IN VARCHAR2 )
81 return jtf_varchar2_Table_100;
82
83 END IEM_UTILS_PVT;