1 PACKAGE ICX_Resp_Excl_Attr_PVT AUTHID CURRENT_USER AS
2 -- $Header: ICXVTRES.pls 115.1 99/07/17 03:30:41 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_Excl_Attr_PVT';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ICXVTREB.pls';
9
10 -- Start of Comments
11 -- API name : Create_Resp_Excl_Attr
12 -- Type : Private.
13 -- Function : Create Excluding Attribute information in AK_EXCLUDED_ITEMS
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_Excl_Attr
50 -- Type : Private.
51 -- Function : Delete Excluding Attribute information in AK_EXCLUDED_ITEMS
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
60 -- p_commit IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_validation_level IN NUMBER Optional
63 -- Default = FND_API.G_VALID_LEVEL_FULL
64 -- p_responsibility_id IN NUMBER Required
65 -- p_application_id IN NUMBER Required
66 -- p_attribute_code IN VARCHAR2(30) Required
67 -- p_attribute_appl_id IN NUMBER Required
68
69 -- OUT : p_return_status OUT VARCHAR2
70 -- p_msg_count OUT NUMBER
71 -- p_msg_data OUT VARCHAR2
72 -- p_msg_entity OUT VARCHAR2
73 -- p_msg_entity_index OUT NUMBER
74 -- .
75 -- Version : Current version 1.0
76 -- Initial version 1.0
77 --
78 -- Notes : Note text
79 --
80 -- End Of Comments
81
82 PROCEDURE Create_Resp_Excl_Attr
83 ( p_api_version_number IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
86 p_commit IN VARCHAR2 := FND_API.G_FALSE,
87 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
88 p_return_status OUT VARCHAR2,
89 p_msg_count OUT NUMBER,
90 p_msg_data OUT VARCHAR2,
91 -- p_msg_entity OUT VARCHAR2,
92 -- p_msg_entity_index OUT NUMBER,
93 p_responsibility_id IN NUMBER,
94 p_application_id IN NUMBER,
95 p_attribute_code IN VARCHAR2,
96 p_attribute_appl_id IN NUMBER,
97 p_created_by IN NUMBER,
98 p_creation_date IN DATE,
99 p_last_updated_by IN NUMBER,
100 p_last_update_date IN DATE,
101 p_last_update_login IN NUMBER
102 );
103
104
105
106 PROCEDURE Delete_Resp_Excl_Attr
107 ( p_api_version_number IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE,
111 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112 p_return_status OUT VARCHAR2,
113 p_msg_count OUT NUMBER,
114 p_msg_data OUT VARCHAR2,
115 -- p_msg_entity OUT VARCHAR2,
116 -- p_msg_entity_index OUT NUMBER,
117 p_responsibility_id IN NUMBER,
118 p_application_id IN NUMBER,
119 p_attribute_code IN VARCHAR2,
120 p_attribute_appl_id IN NUMBER
121 );
122
123
124 END ICX_Resp_Excl_Attr_PVT;