DBA Data[Home] [Help]

PACKAGE: APPS.ICX_RESP_SEC_ATTR_PVT

Source


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;