1 PACKAGE ICX_Resp_Sec_Attr_PUB AUTHID CURRENT_USER AS
2 /* $Header: ICXPTRSS.pls 115.2 99/07/17 03:21:20 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_Resp_Sec_Attr_PUB';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ICXPTRSB.pls';
9
10 -- Start of Comments
11 -- API name : Create_Resp_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_responsibility_id IN NUMBER Required
26 -- p_application_id IN NUMBER Required
27 -- p_attribute_code IN VARCHAR2(30) Required
28 -- p_attribute_appl_id IN NUMBER Required
29 -- p_created_by IN NUMBER Required
30 -- p_creation_date IN DATE Required
31 -- p_last_updated_by IN NUMBER Required
32 -- Default = FND_API.G_MISS_NUM
33 -- p_last_update_date IN DATE Required
34 -- Default = FND_API.G_MISS_DATE
35 -- p_last_update_login IN NUMBER Required
36 -- Default = NULL
37 --
38 -- OUT : p_return_status OUT VARCHAR2(1)
39 -- p_msg_count OUT NUMBER
40 -- p_msg_data OUT VARCHAR2(2000)
41 -- p_msg_entity OUT VARCHAR2(30)
42 -- p_msg_entity_index OUT NUMBER
43 -- .
44 -- Version : Current version 1.0
45 -- Initial version 1.0
46 --
47 -- Notes : Note text
48 --
49 --
50 --
51 --
52 -- API name : Delete_Resp_Sec_Attr
53 -- Type : Public.
54 -- Function : Delete Web User information from AK_WEB_USER_SEC_ATTR_VALUES
55 -- Pre-reqs : None.
56 -- Paramaeters :
57 -- IN : p_api_version_number IN NUMBER Required
58 -- p_init_msg_list IN VARCHAR2 Optional
59 -- Default = FND_API.G_FALSE
60 -- p_simulate IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_commit IN VARCHAR2 Optional
63 -- Default = FND_API.G_FALSE
64 -- p_validation_level IN NUMBER Optional
65 -- Default = FND_API.G_VALID_LEVEL_FULL
66 -- p_responsibility_id IN NUMBER Required
67 -- p_application_id IN NUMBER Required
68 -- p_attribute_code IN VARCHAR2(30) Required
69 -- p_attribute_appl_id IN NUMBER Required
70 --
71 -- OUT : p_return_status OUT VARCHAR2(1)
72 -- p_msg_count OUT NUMBER
73 -- p_msg_data OUT VARCHAR2(2000)
74 -- p_msg_entity OUT VARCHAR2(30)
75 -- p_msg_entity_index OUT NUMBER
76 -- .
77 -- Version : Current version 1.0
78 -- Initial version 1.0
79 --
80 -- Notes : Note text
81 --
82 -- End Of Comments
83
84
85 PROCEDURE Create_Resp_Sec_Attr
86 ( p_api_version_number IN NUMBER,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91 p_return_status OUT VARCHAR2,
92 p_msg_count OUT NUMBER,
93 p_msg_data OUT VARCHAR2,
94 -- p_msg_entity OUT VARCHAR2,
95 -- p_msg_entity_index OUT NUMBER,
96 p_responsibility_id IN NUMBER,
97 p_application_id IN NUMBER,
98 p_attribute_code IN VARCHAR2,
99 p_attribute_appl_id IN NUMBER,
100 p_created_by IN NUMBER,
101 p_creation_date IN DATE,
102 p_last_updated_by IN NUMBER,
103 p_last_update_date IN DATE,
104 p_last_update_login IN NUMBER
105 );
106
107
108
109 PROCEDURE Delete_Resp_Sec_Attr
110 ( p_api_version_number IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
113 p_commit IN VARCHAR2 := FND_API.G_FALSE,
114 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115 p_return_status OUT VARCHAR2,
116 p_msg_count OUT NUMBER,
117 p_msg_data OUT VARCHAR2,
118 -- p_msg_entity OUT VARCHAR2,
119 -- p_msg_entity_index OUT NUMBER,
120 p_responsibility_id IN NUMBER,
121 p_application_id IN NUMBER,
122 p_attribute_code IN VARCHAR2,
123 p_attribute_appl_id IN NUMBER
124 );
125
126
127 END ICX_Resp_Sec_Attr_PUB;