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