97: -- Version Initial version number = 1.0
98: -- History Current version number = 1.0
99: --=======================================================
100: procedure CREATE_EXCLUDED_ITEM (
101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102: p_api_version_number IN NUMBER,
103: p_init_msg_tbl IN BOOLEAN := FALSE,
104: p_msg_count OUT NOCOPY NUMBER,
105: p_msg_data OUT NOCOPY VARCHAR2,
107: p_responsibility_id IN NUMBER,
108: p_resp_application_id IN NUMBER,
109: p_attribute_code IN VARCHAR2,
110: p_attribute_application_id IN NUMBER,
111: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
112: p_creation_date IN DATE := FND_API.G_MISS_DATE,
113: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
114: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
115: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
108: p_resp_application_id IN NUMBER,
109: p_attribute_code IN VARCHAR2,
110: p_attribute_application_id IN NUMBER,
111: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
112: p_creation_date IN DATE := FND_API.G_MISS_DATE,
113: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
114: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
115: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
116: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
109: p_attribute_code IN VARCHAR2,
110: p_attribute_application_id IN NUMBER,
111: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
112: p_creation_date IN DATE := FND_API.G_MISS_DATE,
113: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
114: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
115: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
116: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
117: );
110: p_attribute_application_id IN NUMBER,
111: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
112: p_creation_date IN DATE := FND_API.G_MISS_DATE,
113: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
114: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
115: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
116: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
117: );
118:
111: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
112: p_creation_date IN DATE := FND_API.G_MISS_DATE,
113: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
114: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
115: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
116: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
117: );
118:
119: --=======================================================
112: p_creation_date IN DATE := FND_API.G_MISS_DATE,
113: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
114: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
115: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
116: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
117: );
118:
119: --=======================================================
120: -- Procedure CREATE_RESP_SECURITY_ATTR
141: -- Version Initial version number = 1.0
142: -- History Current version number = 1.0
143: --=======================================================
144: procedure CREATE_RESP_SECURITY_ATTR (
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: p_api_version_number IN NUMBER,
147: p_init_msg_tbl IN BOOLEAN := FALSE,
148: p_msg_count OUT NOCOPY NUMBER,
149: p_msg_data OUT NOCOPY VARCHAR2,
151: p_responsibility_id IN NUMBER,
152: p_resp_application_id IN NUMBER,
153: p_attribute_code IN VARCHAR2,
154: p_attribute_application_id IN NUMBER,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
152: p_resp_application_id IN NUMBER,
153: p_attribute_code IN VARCHAR2,
154: p_attribute_application_id IN NUMBER,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
160: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
153: p_attribute_code IN VARCHAR2,
154: p_attribute_application_id IN NUMBER,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
160: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
161: );
154: p_attribute_application_id IN NUMBER,
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
160: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
161: );
162:
155: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
160: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
161: );
162:
163: --=======================================================
156: p_creation_date IN DATE := FND_API.G_MISS_DATE,
157: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
158: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
159: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
160: p_loader_timestamp IN DATE := FND_API.G_MISS_DATE
161: );
162:
163: --=======================================================
164: -- Procedure DOWNLOAD_EXCLUDED
197: -- Version Initial version number = 1.0
198: -- History Current version number = 1.0
199: --=======================================================
200: procedure DOWNLOAD_EXCLUDED (
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_api_version_number IN NUMBER,
203: p_return_status OUT NOCOPY VARCHAR2,
204: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
205: p_excluded_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
200: procedure DOWNLOAD_EXCLUDED (
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_api_version_number IN NUMBER,
203: p_return_status OUT NOCOPY VARCHAR2,
204: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
205: p_excluded_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
206: AK_SECURITY_PUB.G_MISS_RESP_PK_TBL,
207: p_nls_language IN VARCHAR2
208: );
244: -- Version Initial version number = 1.0
245: -- History Current version number = 1.0
246: --=======================================================
247: procedure DOWNLOAD_RESP_SEC (
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: p_api_version_number IN NUMBER,
250: p_return_status OUT NOCOPY VARCHAR2,
251: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_resp_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
247: procedure DOWNLOAD_RESP_SEC (
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
249: p_api_version_number IN NUMBER,
250: p_return_status OUT NOCOPY VARCHAR2,
251: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
252: p_resp_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
253: AK_SECURITY_PUB.G_MISS_RESP_PK_TBL,
254: p_nls_language IN VARCHAR2
255: );
335: -- Version Initial version number = 1.0
336: -- History Current version number = 1.0
337: --=======================================================
338: procedure UPLOAD_SECURITY (
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: p_api_version_number IN NUMBER,
341: p_return_status OUT NOCOPY VARCHAR2,
342: p_index IN OUT NOCOPY NUMBER,
343: p_loader_timestamp IN DATE,
340: p_api_version_number IN NUMBER,
341: p_return_status OUT NOCOPY VARCHAR2,
342: p_index IN OUT NOCOPY NUMBER,
343: p_loader_timestamp IN DATE,
344: p_line_num IN NUMBER := FND_API.G_MISS_NUM,
345: p_buffer IN AK_ON_OBJECTS_PUB.Buffer_Type,
346: p_line_num_out OUT NOCOPY NUMBER,
347: p_buffer_out OUT NOCOPY AK_ON_OBJECTS_PUB.Buffer_Type,
348: p_upl_loader_cur IN OUT NOCOPY AK_ON_OBJECTS_PUB.LoaderCurTyp
380: -- Version Initial version number = 1.0
381: -- History Current version number = 1.0
382: --=======================================================
383: function VALIDATE_SECURITY (
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: p_api_version_number IN NUMBER,
386: p_return_status OUT NOCOPY VARCHAR2,
387: p_responsibility_appl_id IN NUMBER := FND_API.G_MISS_NUM,
388: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
383: function VALIDATE_SECURITY (
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: p_api_version_number IN NUMBER,
386: p_return_status OUT NOCOPY VARCHAR2,
387: p_responsibility_appl_id IN NUMBER := FND_API.G_MISS_NUM,
388: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
389: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
390: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
391: p_caller IN VARCHAR2
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: p_api_version_number IN NUMBER,
386: p_return_status OUT NOCOPY VARCHAR2,
387: p_responsibility_appl_id IN NUMBER := FND_API.G_MISS_NUM,
388: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
389: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
390: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
391: p_caller IN VARCHAR2
392: ) return BOOLEAN;
385: p_api_version_number IN NUMBER,
386: p_return_status OUT NOCOPY VARCHAR2,
387: p_responsibility_appl_id IN NUMBER := FND_API.G_MISS_NUM,
388: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
389: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
390: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
391: p_caller IN VARCHAR2
392: ) return BOOLEAN;
393:
386: p_return_status OUT NOCOPY VARCHAR2,
387: p_responsibility_appl_id IN NUMBER := FND_API.G_MISS_NUM,
388: p_responsibility_id IN NUMBER := FND_API.G_MISS_NUM,
389: p_attribute_application_id IN NUMBER := FND_API.G_MISS_NUM,
390: p_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
391: p_caller IN VARCHAR2
392: ) return BOOLEAN;
393:
394: end AK_SECURITY_pvt;