1 PACKAGE AMS_Upgrade_Track_Error_PVT AS
2 /* $Header: amsvutes.pls 120.0 2005/06/01 00:14:57 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Upgrade_Track_Error_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- upgrade_track_error_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- object_code
26 -- object_id
27 -- creation_date
28 -- error_code
29 -- object_name
30 -- language
31 -- error_message
32 -- proposed_action
33 --
34 -- Required
35 --
36 -- Defaults
37 --
38 -- Note: This is automatic generated record definition, it includes all columns
39 -- defined in the table, developer must manually add or delete some of the attributes.
40 --
41 -- End of Comments
42
43 --===================================================================
44 TYPE upgrade_track_error_rec_type IS RECORD
45 (
46 object_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
47 object_id NUMBER := FND_API.G_MISS_NUM,
48 creation_date DATE := FND_API.G_MISS_DATE,
49 error_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
50 object_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
51 language VARCHAR2(4) := FND_API.G_MISS_CHAR,
52 error_message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
53 proposed_action VARCHAR2(2000) := FND_API.G_MISS_CHAR
54 );
55
56 g_miss_upgrade_track_error_rec upgrade_track_error_rec_type;
57 TYPE upgrade_track_error_tbl_type IS TABLE OF upgrade_track_error_rec_type INDEX BY BINARY_INTEGER;
58 g_miss_upgrade_track_error_tbl upgrade_track_error_tbl_type;
59
60 -- ==============================================================================
61 -- Start of Comments
62 -- ==============================================================================
63 -- API Name
64 -- Create_Upgrade_Track_Error
65 -- Type
66 -- Private
67 -- Pre-Req
68 --
69 -- Parameters
70 --
71 -- IN
72 -- p_api_version_number IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
74 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
75 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
76 -- p_upgrade_track_error_rec IN upgrade_track_error_rec_type Required
77 --
78 -- OUT
79 -- x_return_status OUT VARCHAR2
80 -- x_msg_count OUT NUMBER
81 -- x_msg_data OUT VARCHAR2
82 -- Version : Current version 1.0
83 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
84 -- and basic operation, developer must manually add parameters and business logic as necessary.
85 --
86 -- End of Comments
87 -- ==============================================================================
88 --
89
90 PROCEDURE Create_Upgrade_Track_Error(
91 p_api_version_number IN NUMBER,
92 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_upgrade_track_error_rec IN upgrade_track_error_rec_type
99 := g_miss_upgrade_track_error_rec
100 );
101
102 -- ==============================================================================
103 -- Start of Comments
104 -- ==============================================================================
105 -- API Name
106 -- Update_Upgrade_Track_Error
107 -- Type
108 -- Private
109 -- Pre-Req
110 --
111 -- Parameters
112 --
113 -- IN
114 -- p_api_version_number IN NUMBER Required
115 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
117 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
118 -- p_upgrade_track_error_rec IN upgrade_track_error_rec_type Required
119 --
120 -- OUT
121 -- x_return_status OUT VARCHAR2
122 -- x_msg_count OUT NUMBER
123 -- x_msg_data OUT VARCHAR2
124 -- Version : Current version 1.0
125 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
126 -- and basic operation, developer must manually add parameters and business logic as necessary.
127 --
128 -- End of Comments
129 -- ==============================================================================
130 --
131
132 PROCEDURE Update_Upgrade_Track_Error(
133 p_api_version_number IN NUMBER,
134 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
135 p_commit IN VARCHAR2 := FND_API.G_FALSE,
136 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
137 p_upgrade_track_error_rec IN upgrade_track_error_rec_type,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2
141 );
142
143 -- ==============================================================================
144 -- Start of Comments
145 -- ==============================================================================
146 -- API Name
147 -- Delete_Upgrade_Track_Error
148 -- Type
149 -- Private
150 -- Pre-Req
151 --
152 -- Parameters
153 --
154 -- IN
155 -- p_api_version_number IN NUMBER Required
156 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
157 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
158 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
159 -- p_OBJECT_CODE,OBJECT_ID IN NUMBER
160 -- p_object_version_number IN NUMBER Optional Default = NULL
161 --
162 -- OUT
163 -- x_return_status OUT VARCHAR2
164 -- x_msg_count OUT NUMBER
165 -- x_msg_data OUT VARCHAR2
166 -- Version : Current version 1.0
167 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
168 -- and basic operation, developer must manually add parameters and business logic as necessary.
169 --
170 -- End of Comments
171 -- ==============================================================================
172 --
173
174 PROCEDURE Delete_Upgrade_Track_Error(
175 p_api_version_number IN NUMBER,
176 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177 p_commit IN VARCHAR2 := FND_API.G_FALSE,
178 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_object_code IN Number,
183 p_object_id IN NUMBER
184 );
185
186 END AMS_Upgrade_Track_Error_PVT;