1 PACKAGE AST_camp_outcome_PVT AUTHID CURRENT_USER as
2 /* $Header: astvrcos.pls 115.8 2002/02/06 11:44:26 pkm ship $ */
3
4 -- Start of Comments
5 -- Package name : AST_camp_outcome_PVT
6 -- Purpose :
7 -- History :
8 -- NOTE :
9 -- End of Comments
10
11 -- Default number of records fetch per call
12 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
13 -- *******************************************************
14 -- Start of Comments
15 -- -------------------------------------------------------
16 -- Record name:camp_outcome_Rec_Type
17 -- -------------------------------------------------------
18 -- Parameters:
19 --
20 -- Required:
21 -- Defaults:
22 -- Note: This is automatic generated record definition, it includes all columns
23 -- defined in the table, developer must manually add or delete some of the attributes.
24 --
25 -- End of Comments
26
27 TYPE camp_outcome_Rec_Type IS RECORD
28 (
29 outcome_id NUMBER := FND_API.G_MISS_NUM,
30 object_id NUMBER := FND_API.G_MISS_NUM,
31 object_version_number NUMBER := FND_API.G_MISS_NUM,
32 created_by NUMBER := FND_API.G_MISS_NUM,
33 creation_date DATE := FND_API.G_MISS_DATE,
34 last_updated_by NUMBER := FND_API.G_MISS_NUM,
35 last_update_date DATE := FND_API.G_MISS_DATE,
36 last_update_login NUMBER := FND_API.G_MISS_NUM,
37 object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
38 source_code_id NUMBER := FND_API.G_MISS_NUM,
39 source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
40 );
41
42 G_MISS_camp_outcome_REC camp_outcome_Rec_Type;
43 TYPE camp_outcome_Tbl_Type IS TABLE OF camp_outcome_Rec_Type
44 INDEX BY BINARY_INTEGER;
45 G_MISS_camp_outcome_TBL camp_outcome_Tbl_Type;
46
47 -- *******************************************************
48 -- Start of Comments
49 -- *******************************************************
50 -- API Name: Create_camp_outcome
51 -- Type : Private
52 -- Pre-Req :
53 -- Parameters:
54 -- IN
55 -- p_api_version_number IN NUMBER Required
56 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
57 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
58 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
59 -- P_camp_outcome_Rec IN camp_outcome_Rec_Type Required
60 --
61 -- OUT:
62 -- x_return_status OUT VARCHAR2
63 -- x_msg_count OUT NUMBER
64 -- x_msg_data OUT VARCHAR2
65 -- Version : Current version 2.0
66 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
67 -- and basic operation, developer must manually add parameters and business logic as necessary.
68
69 --
70 -- End of Comments
71 --
72 FUNCTION get_camp_outcome_Rec RETURN AST_camp_outcome_PVT.camp_outcome_rec_type;
73
74 PROCEDURE Create_camp_outcome(
75 P_Api_Version_Number IN NUMBER,
76 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79 P_camp_outcome_Rec IN camp_outcome_Rec_Type := G_MISS_camp_outcome_REC,
80 X_Return_Status OUT VARCHAR2,
81 X_Msg_Count OUT NUMBER,
82 X_Msg_Data OUT VARCHAR2
83 );
84
85 -- *******************************************************
86 -- Start of Comments
87 -- *******************************************************
88 -- API Name: Delete_camp_outcome
89 -- Type : Private
90 -- Pre-Req :
91 -- Parameters:
92 -- IN
93 -- p_api_version_number IN NUMBER Required
94 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
97 -- P_camp_outcome_Rec IN camp_outcome_Rec_Type Required
98 --
99 -- OUT:
100 -- x_return_status OUT VARCHAR2
101 -- x_msg_count OUT NUMBER
102 -- x_msg_data OUT VARCHAR2
103 -- Version : Current version 2.0
104 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
105 -- and basic operation, developer must manually add parameters and business logic as necessary.
106
107 --
108 -- End of Comments
109 --
110 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
111 -- The Master delete procedure may not be needed depends on different business requirements.
112 PROCEDURE Delete_camp_outcome(
113 P_Api_Version_Number IN NUMBER,
114 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
115 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117 P_camp_outcome_Rec IN camp_outcome_Rec_Type,
118 X_Return_Status OUT VARCHAR2,
119 X_Msg_Count OUT NUMBER,
120 X_Msg_Data OUT VARCHAR2
121 );
122
123 -- *******************************************************
124 -- Start of Comments
125 -- *******************************************************
126 -- API Name: Save_Change
127 -- Type : Private
128 -- Pre-Req :
129 -- Parameters:
130 -- IN
131 -- p_api_version_number IN NUMBER Required
132 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
135 --
136 -- OUT:
137 -- x_return_status OUT VARCHAR2
138 -- x_msg_count OUT NUMBER
139 -- x_msg_data OUT VARCHAR2
140 -- Version : Current version 2.0
141 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
142 --
143 -- and basic operation, developer must manually add parameters and business logic as necessary.
144 -- End of Comments
145 PROCEDURE Save_Change(
146 P_Api_Version_Number IN NUMBER,
147 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
148 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
149 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150 X_Return_Status OUT VARCHAR2,
151 X_Msg_Count OUT NUMBER,
152 X_Msg_Data OUT VARCHAR2
153 );
154 --
155 --
156 -- *******************************************************
157 -- API Name: Save_Defaults
158 -- Type : Private
159 -- Pre-Req :
160 -- Parameters:
161 -- IN
162 -- p_api_version_number IN NUMBER Required
163 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166 -- p_object_id IN NUMBER
167 -- p_outcome_id IN NUMBER
168 -- p_result_id IN NUMBER
169 -- p_reason_id IN NUMBER
170 -- p_action_id IN NUMBER
171 -- p_action_item_id IN NUMBER
172 --
173 -- OUT:
174 -- x_return_status OUT VARCHAR2
175 -- x_msg_count OUT NUMBER
176 -- x_msg_data OUT VARCHAR2
177 -- Version : Current version 2.0
178 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
179 -- and basic operation, developer must manually add parameters and business logic as necessary.
180 --
181 -- End of Comments
182
183 PROCEDURE Save_Defaults(
184 P_Api_Version_Number IN NUMBER,
185 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
186 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
187 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188 p_object_id IN NUMBER,
189 p_outcome_id IN NUMBER,
190 p_result_id IN NUMBER,
191 p_reason_id IN NUMBER,
192 p_action_id IN NUMBER,
193 p_action_item_id IN NUMBER,
194 p_defaultyn IN VARCHAR2,
195 X_Return_Status OUT VARCHAR2,
196 X_Msg_Count OUT NUMBER,
197 X_Msg_Data OUT VARCHAR2
198 );
199
200 -- *******************************************************
201 -- Start of Comments
202 -- *******************************************************
203 -- API Name: Rset_Change
204 -- Type : Private
205 -- Pre-Req :
206 -- Parameters:
207 -- IN
208 -- p_api_version_number IN NUMBER Required
209 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
210 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
211 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
212 --
213 -- OUT:
214 -- x_return_status OUT VARCHAR2
215 -- x_msg_count OUT NUMBER
216 -- x_msg_data OUT VARCHAR2
217 -- Version : Current version 2.0
218 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
219 -- and basic operation, developer must manually add parameters and business logic as necessary.
220 --
221 -- End of Comments
222 PROCEDURE Reset_Change(
223 P_Api_Version_Number IN NUMBER,
224 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
225 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
226 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227 X_Return_Status OUT VARCHAR2,
228 X_Msg_Count OUT NUMBER,
229 X_Msg_Data OUT VARCHAR2
230 );
231 End AST_camp_outcome_PVT;