1 PACKAGE ICX_User_Sec_Attr_PUB AUTHID CURRENT_USER AS
2 /* $Header: ICXPTUSS.pls 115.2 99/07/17 03:21:26 porting ship $ */
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ICX_User_Sec_Attr_PUB';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ICXPTUSB.pls';
9
10 -- Start of Comments
11 -- API name : Create_User_Sec_Attr
12 -- Type : Public.
13 -- Function : Create Web User information in AK_WEB_USER_SEC_ATTR_VALUES
14 -- Pre-reqs : None.
15 -- Paramaeters :
16 -- IN : p_api_version_number IN NUMBER Required
17 -- p_init_msg_list IN VARCHAR2 Optional
18 -- Default = FND_API.G_FALSE
19 -- p_simulate IN VARCHAR2 Optional
20 -- Default = FND_API.G_FALSE
21 -- p_commit IN VARCHAR2 Optional
22 -- Default = FND_API.G_FALSE
23 -- p_validation_level IN NUMBER Optional
24 -- Default = FND_API.G_VALID_LEVEL_FULL
25 -- p_web_user_id IN NUMBER Required
26 -- p_attribute_code IN VARCHAR2(30) Required
27 -- p_attribute_appl_id IN NUMBER Required
28 -- p_varchar2_value IN VARCHAR2(240) Required
29 -- p_date_value IN DATE Required
30 -- p_number_value IN NUMBER Required
31 -- p_created_by IN NUMBER Required
32 -- p_creation_date IN DATE Required
33 -- p_last_updated_by IN NUMBER Required
34 -- Default = FND_API.G_MISS_NUM
35 -- p_last_update_date IN DATE Required
36 -- Default = FND_API.G_MISS_DATE
37 -- p_last_update_login IN NUMBER Required
38 -- Default = NULL
39 --
40 -- OUT : p_return_status OUT VARCHAR2(1)
41 -- p_msg_count OUT NUMBER
42 -- p_msg_data OUT VARCHAR2(2000)
43 -- p_msg_entity OUT VARCHAR2(30)
44 -- p_msg_entity_index OUT NUMBER
45 -- .
46 -- Version : Current version 1.0
47 -- Initial version 1.0
48 --
49 -- Notes : Note text
50 --
51 --
52 --
53 --
54 -- API name : Delete_User_Sec_Attr
55 -- Type : Public.
56 -- Function : Delete Web User information from AK_WEB_USER_SEC_ATTR_VALUES
57 -- Pre-reqs : None.
58 -- Paramaeters :
59 -- IN : p_api_version_number IN NUMBER Required
60 -- p_init_msg_list IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_simulate IN VARCHAR2 Optional
63 -- Default = FND_API.G_FALSE
64 -- p_commit IN VARCHAR2 Optional
65 -- Default = FND_API.G_FALSE
66 -- p_validation_level IN NUMBER Optional
67 -- Default = FND_API.G_VALID_LEVEL_FULL
68 -- p_web_user_id IN NUMBER Required
69 -- p_attribute_code IN VARCHAR2(30) Required
70 -- p_attribute_appl_id IN NUMBER Required
71 -- p_varchar2_value IN VARCHAR2 Required
72 -- p_date_value IN DATE Required
73 -- p_number_value IN NUMBER Required
74 --
75 -- OUT : p_return_status OUT VARCHAR2(1)
76 -- p_msg_count OUT NUMBER
77 -- p_msg_data OUT VARCHAR2(2000)
78 -- p_msg_entity OUT VARCHAR2(30)
79 -- p_msg_entity_index OUT NUMBER
80 -- .
81 -- Version : Current version 1.0
82 -- Initial version 1.0
83 --
84 -- Notes : Note text
85 --
86 -- End Of Comments
87
88
89 PROCEDURE Create_User_Sec_Attr
90 ( p_api_version_number IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 p_return_status OUT VARCHAR2,
96 p_msg_count OUT NUMBER,
97 p_msg_data OUT VARCHAR2,
98 -- p_msg_entity OUT VARCHAR2,
99 -- p_msg_entity_index OUT NUMBER,
100 p_web_user_id IN NUMBER,
101 p_attribute_code IN VARCHAR2,
102 p_attribute_appl_id IN NUMBER,
103 p_varchar2_value IN VARCHAR2,
104 p_date_value IN DATE,
105 p_number_value IN NUMBER,
106 p_created_by IN NUMBER,
107 p_creation_date IN DATE,
108 p_last_updated_by IN NUMBER,
109 p_last_update_date IN DATE,
110 p_last_update_login IN NUMBER
111 );
112
113
114
115 PROCEDURE Delete_User_Sec_Attr
116 ( p_api_version_number IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
119 p_commit IN VARCHAR2 := FND_API.G_FALSE,
120 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121 p_return_status OUT VARCHAR2,
122 p_msg_count OUT NUMBER,
123 p_msg_data OUT VARCHAR2,
124 -- p_msg_entity OUT VARCHAR2,
125 -- p_msg_entity_index OUT NUMBER,
126 p_web_user_id IN NUMBER,
127 p_attribute_code IN VARCHAR2,
128 p_attribute_appl_id IN NUMBER,
129 p_varchar2_value IN VARCHAR2,
130 p_date_value IN DATE,
131 p_number_value IN NUMBER
132
133 );
134
135
136 END ICX_User_Sec_Attr_PUB;