1 package AK_SECURITY_GRP as
2 /* $Header: akdgsecs.pls 120.2 2005/09/15 22:26:43 tshort 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) := 'AK_SECURITY_GRP';
8
9 --
10 -- Procedure specs
11 --
12 --=======================================================
13 -- Procedure CREATE_EXCLUDED_ITEM
14 --
15 -- Usage Group API for creating an attribute
16 --
17 -- Desc Calls the private API to creates an attribute
18 -- using the given info
19 --
20 -- Results The API returns the standard p_return_status parameter
21 -- indicating one of the standard return statuses :
22 -- * Unexpected error
23 -- * Error
24 -- * Success
25 -- Parameters Attribute columns
26 --
27 -- Version Initial version number = 1.0
28 -- History Current version number = 1.0
29 --=======================================================
30 procedure CREATE_EXCLUDED_ITEM (
31 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32 p_api_version_number IN NUMBER,
33 p_init_msg_tbl IN BOOLEAN := FALSE,
34 p_msg_count OUT NOCOPY NUMBER,
35 p_msg_data OUT NOCOPY VARCHAR2,
36 p_return_status OUT NOCOPY VARCHAR2,
37 p_responsibility_id IN NUMBER,
38 p_resp_application_id IN NUMBER,
39 p_attribute_code IN VARCHAR2,
40 p_attribute_application_id IN NUMBER,
41 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
42 p_creation_date IN DATE := FND_API.G_MISS_DATE,
43 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
44 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
45 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
46 );
47
48 --=======================================================
49 -- Procedure CREATE_RESP_SECURITY_ATTR
50 --
51 -- Usage Group API for creating an attribute
52 --
53 -- Desc Calls the private API to creates an attribute
54 -- using the given info
55 --
56 -- Results The API returns the standard p_return_status parameter
57 -- indicating one of the standard return statuses :
58 -- * Unexpected error
59 -- * Error
60 -- * Success
61 -- Parameters Attribute columns
62 --
63 -- Version Initial version number = 1.0
64 -- History Current version number = 1.0
65 --=======================================================
66 procedure CREATE_RESP_SECURITY_ATTR (
67 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68 p_api_version_number IN NUMBER,
69 p_init_msg_tbl IN BOOLEAN := FALSE,
70 p_msg_count OUT NOCOPY NUMBER,
71 p_msg_data OUT NOCOPY VARCHAR2,
72 p_return_status OUT NOCOPY VARCHAR2,
73 p_responsibility_id IN NUMBER,
74 p_resp_application_id IN NUMBER,
75 p_attribute_code IN VARCHAR2,
76 p_attribute_application_id IN NUMBER,
77 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
78 p_creation_date IN DATE := FND_API.G_MISS_DATE,
79 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
80 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
81 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
82 );
83
84 --========================================================
85 -- Procedure DOWNLOAD_RESP
86 --
87 -- Usage Group API for downloading security objects
88 --
89 -- Desc This API first write out standard loader
90 -- file header for attributes to a flat file.
91 -- Then it calls the private API to extract the
92 -- attributes selected by application ID or by
93 -- key values from the database to the output file.
94 --
95 -- Results The API returns the standard p_return_status parameter
96 -- indicating one of the standard return statuses :
97 -- * Unexpected error
98 -- * Error
99 -- * Success
100 -- Parameters
101 -- p_nls_language : IN optional
102 -- NLS language for database. If none if given,
103 -- the current NLS language will be used.
104 --
105 -- One of the following three parameters must be given:
106 --
107 -- p_application_id : IN optional
108 -- If given, all attributes for this application ID
109 -- will be written to the output file.
110 -- p_application_short_name : IN optional
111 -- If given, all attributes for this application short
112 -- name will be written to the output file.
113 -- Application short name will be ignored if an
114 -- application ID is given.
115 -- p_excluded_pk_tbl : IN optional
116 -- If given, only excluded_items whose key values are
117 -- included in this table will be written to the
118 -- output file.
119 -- p_resp_pk_tbl : IN optional
120 -- If given, only resp_sec_attributes whose key values are
121 -- included in this table will be written to the
122 -- output file.
123 --
124 --
125 -- Version Initial version number = 1.0
126 -- History Current version number = 1.0
127 --=======================================================
128 procedure DOWNLOAD_RESP (
129 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130 p_api_version_number IN NUMBER,
131 p_init_msg_tbl IN BOOLEAN := FALSE,
132 p_msg_count OUT NOCOPY NUMBER,
133 p_msg_data OUT NOCOPY VARCHAR2,
134 p_return_status OUT NOCOPY VARCHAR2,
135 p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
137 p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_excluded_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
139 AK_SECURITY_PUB.G_MISS_RESP_PK_TBL,
140 p_resp_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
141 AK_SECURITY_PUB.G_MISS_RESP_PK_TBL
142 );
143
144 end AK_SECURITY_GRP;