[Home] [Help]
PACKAGE: APPS.AMS_ITEM_REVISION_PUB
Source
1 PACKAGE AMS_ITEM_REVISION_PUB AUTHID CURRENT_USER AS
2 /* $Header: amsprevs.pls 115.4 2002/11/15 21:01:15 abhola ship $ */
3
4 -- ============================================================================
5 -- Global variables and cursors
6 -- ============================================================================
7
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'AMSPREVS.pls';
9
10 -- ============================================================================
11 -- Record Type: Item_Revision_rec_type
12 -- ============================================================================
13
14 TYPE Item_Revision_rec_type IS RECORD
15 (
16 inventory_item_id NUMBER := FND_API.g_MISS_NUM
17 , organization_id NUMBER := FND_API.g_MISS_NUM
18 , revision VARCHAR2(3) := FND_API.g_MISS_CHAR
19 , description VARCHAR2(240) := FND_API.g_MISS_CHAR
20 , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
21 , ecn_initiation_date DATE := FND_API.g_MISS_DATE
22 , implementation_date DATE := FND_API.g_MISS_DATE
23 , effectivity_date DATE := FND_API.g_MISS_DATE
24 , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
25 , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
26 , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
27 , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
28 , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
29 , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
30 , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
31 , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
32 , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
33 , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
34 , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
35 , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
36 , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
37 , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
38 , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
39 , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
40 , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
41 , creation_date DATE := FND_API.g_MISS_DATE
42 , created_by NUMBER := FND_API.g_MISS_NUM
43 , last_update_date DATE := FND_API.g_MISS_DATE
44 , last_updated_by NUMBER := FND_API.g_MISS_NUM
45 , last_update_login NUMBER := FND_API.g_MISS_NUM
46 , request_id NUMBER := FND_API.g_MISS_NUM
47 , program_application_id NUMBER := FND_API.g_MISS_NUM
48 , program_id NUMBER := FND_API.g_MISS_NUM
49 , program_update_date DATE := FND_API.g_MISS_DATE
50 , object_version_number NUMBER := FND_API.g_MISS_NUM
51 );
52
53
54 -- ------------------- Variables representing missing values ------------------
55
56 g_Miss_Item_Revision_rec Item_Revision_rec_type;
57
58
59 -- ============================================================================
60 -- Start of Comments
61 --
62 -- API Name: Create_Item_Revision
63 --
64 -- Type: Public
65 --
66 -- Pre-Req
67 --
68 -- Parameters
69 --
70 -- IN
71 -- p_api_version IN NUMBER Required
72 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
73 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
74 --
75 -- OUT
76 -- x_return_status OUT VARCHAR2
77 -- x_msg_count OUT NUMBER
78 -- x_msg_data OUT VARCHAR2
79 --
80 -- IN OUT
81 -- p_Item_Revision_rec IN OUT Item_Revision_rec_type Required
82 --
83 -- Version: Current version 1.0
84 --
85 -- End of Comments
86 -- ============================================================================
87
88 PROCEDURE Create_Item_Revision
89 (
90 p_api_version IN NUMBER
91 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92 , p_commit IN VARCHAR2 := FND_API.G_FALSE
93 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
94 , x_return_status OUT NOCOPY VARCHAR2
95 , x_msg_count OUT NOCOPY NUMBER
96 , x_msg_data OUT NOCOPY VARCHAR2
97 , p_Item_Revision_rec IN Item_Revision_rec_type
98 );
99
100 -- ============================================================================
101 -- Start of Comments
102 --
103 -- API Name: Update_Item_Revision
104 --
105 -- Type: Public
106 --
107 -- Pre-Req
108 --
109 -- Parameters
110 --
111 -- IN
112 -- p_api_version_number IN NUMBER Required
113 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115 -- p_Item_Revision_rec IN Item_Revision_rec_type Required
116 --
117 -- OUT
118 -- x_return_status OUT VARCHAR2
119 -- x_msg_count OUT NUMBER
120 -- x_msg_data OUT VARCHAR2
121 --
122 -- Version: Current version 1.0
123 --
124 -- End of Comments
125 -- ============================================================================
126
127 PROCEDURE Update_Item_Revision
128 (
129 p_api_version IN NUMBER
130 , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
131 , p_commit IN VARCHAR2 := FND_API.g_FALSE
132 , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
133 , x_return_status OUT NOCOPY VARCHAR2
134 , x_msg_count OUT NOCOPY NUMBER
135 , x_msg_data OUT NOCOPY VARCHAR2
136 , p_Item_Revision_rec IN Item_Revision_rec_type
137 );
138
139
140 -- ============================================================================
141 -- Start of Comments
142 --
143 -- API Name: Delete_Item_Revision
144 --
145 -- Type: Public
146 --
147 -- Pre-Req
148 --
149 -- Parameters
150 --
151 -- IN
152 -- p_api_version_number IN NUMBER Required
153 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
154 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
155 -- p_inventory_item_id IN NUMBER Required
156 -- p_organization_id IN NUMBER Required
157 -- p_revision IN VARCHAR2 Required
158 -- p_object_version_number IN NUMBER Required
159 --
160 -- OUT
161 -- x_return_status OUT VARCHAR2
162 -- x_msg_count OUT NUMBER
163 -- x_msg_data OUT VARCHAR2
164 --
165 -- Version: Current version 1.0
166 --
167 -- End of Comments
168 -- ============================================================================
169
170 PROCEDURE Delete_Item_Revision
171 (
172 p_api_version IN NUMBER
173 , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
174 , p_commit IN VARCHAR2 := FND_API.g_FALSE
175 , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
176 , x_return_status OUT NOCOPY VARCHAR2
177 , x_msg_count OUT NOCOPY NUMBER
178 , x_msg_data OUT NOCOPY VARCHAR2
179 , p_inventory_item_id IN NUMBER
180 , p_organization_id IN NUMBER
181 , p_revision IN VARCHAR2
182 , p_object_version_number IN NUMBER
183 );
184
185
186 END AMS_ITEM_REVISION_PUB;