1 PACKAGE AML_TIMEFRAME_PUB AUTHID CURRENT_USER as
2 /* $Header: amlptfrs.pls 115.4 2003/01/03 23:44:56 ckapoor noship $ */
3 -- Start of Comments
4 -- Package name : AML_TIMEFRAME_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:TIMEFRAME_REC_TYPE
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- TIMEFRAME_ID
19 -- DECISION_TIMEFRAME_CODE
20 -- TIMEFRAME_DAYS
21 --
22 -- Required:
23 -- Defaults:
24 -- Note: This is automatic generated record definition, it includes all columns
25 -- defined in the table, developer must manually add or delete some of the attributes.
26 --
27 -- End of Comments
28
29 TYPE TIMEFRAME_REC_TYPE IS RECORD
30 (
31 TIMEFRAME_ID NUMBER := FND_API.G_MISS_NUM
32 , DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
33 , TIMEFRAME_DAYS NUMBER := FND_API.G_MISS_NUM
34 , LAST_UPDATE_DATE DATE
35 , LAST_UPDATE_LOGIN NUMBER
36 , CREATED_BY NUMBER
37 , CREATION_DATE DATE
38 , LAST_UPDATED_BY NUMBER
39 , ENABLED_FLAG VARCHAR2(1)
40
41
42 );
43
44 G_MISS_timeframe_REC TIMEFRAME_REC_TYPE;
45 TYPE timeframe_Tbl_Type IS TABLE OF TIMEFRAME_REC_TYPE
46 INDEX BY BINARY_INTEGER;
47 G_MISS_timeframe_TBL timeframe_Tbl_Type;
48
49 TYPE timeframe_sort_rec_type IS RECORD
50 (
51 -- Please define your own sort by record here.
52 DECISION_TIMEFRAME_CODE NUMBER := NULL
53 );
54
55 -- *******************************************************
56 -- Start of Comments
57 -- *******************************************************
58 -- API Name: Create_timeframe
59 -- Type : Public
60 -- Pre-Req :
61 -- Parameters:
62 -- IN
63 -- p_api_version_number IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
65 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
67 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
68 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
69 -- p_admin_group_id IN NUMBER Required
70 -- P_timeframe_Rec IN TIMEFRAME_REC_TYPE Required
71 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
72 --
73 -- OUT:
74 -- x_return_status OUT VARCHAR2
75 -- x_msg_count OUT NUMBER
76 -- x_msg_data OUT VARCHAR2
77 -- Version : Current version 2.0
78 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
79 -- and basic operation, developer must manually add parameters and business logic as necessary.
80 --
81 -- End of Comments
82 --
83 PROCEDURE Create_timeframe(
84 P_Api_Version_Number IN NUMBER,
85 P_Init_Msg_List 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_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
89 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
90 P_Admin_Group_Id IN NUMBER,
91 P_Identity_Salesforce_Id IN NUMBER,
92 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
93 P_timeframe_Rec IN TIMEFRAME_REC_TYPE ,
94 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
95 X_TIMEFRAME_ID OUT NOCOPY NUMBER,
96 X_Return_Status OUT NOCOPY VARCHAR2,
97 X_Msg_Count OUT NOCOPY NUMBER,
98 X_Msg_Data OUT NOCOPY VARCHAR2
99 );
100
101 -- *******************************************************
102 -- Start of Comments
103 -- *******************************************************
104 -- API Name: Update_timeframe
105 -- Type : Public
106 -- Pre-Req :
107 -- Parameters:
108 -- IN
109 -- p_api_version_number IN NUMBER Required
110 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
111 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
112 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
113 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
114 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
115 -- p_admin_group_id IN NUMBER Required
116 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
117 -- P_timeframe_Rec IN TIMEFRAME_REC_TYPE Required
118 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_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 2.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 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
131 PROCEDURE Update_timeframe(
132 P_Api_Version_Number IN NUMBER,
133 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
134 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
136 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
137 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
138 P_Admin_Group_Id IN NUMBER,
139 P_Identity_Salesforce_Id IN NUMBER,
140 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
141 P_timeframe_Rec IN TIMEFRAME_REC_TYPE,
142 X_Return_Status OUT NOCOPY VARCHAR2,
143 X_Msg_Count OUT NOCOPY NUMBER,
144 X_Msg_Data OUT NOCOPY VARCHAR2
145 );
146
147 -- *******************************************************
148 -- Start of Comments
149 -- *******************************************************
150 -- API Name: Delete_timeframe
151 -- Type : Public
152 -- Pre-Req :
153 -- Parameters:
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_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
160 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
161 -- p_admin_group_id IN NUMBER Required
162 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
163 -- P_timeframe_Rec IN TIMEFRAME_REC_TYPE Required
164 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
165 --
166 -- OUT:
167 -- x_return_status OUT VARCHAR2
168 -- x_msg_count OUT NUMBER
169 -- x_msg_data OUT VARCHAR2
170 -- Version : Current version 2.0
171 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
172 -- and basic operation, developer must manually add parameters and business logic as necessary.
173 --
174 -- End of Comments
175 --
176 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
177 -- The Master delete procedure may not be needed depends on different business requirements.
178 PROCEDURE Delete_timeframe(
179 P_Api_Version_Number IN NUMBER,
180 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
181 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
182 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
183 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
184 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
185 P_Admin_Group_Id IN NUMBER,
186 P_Identity_Salesforce_Id IN NUMBER,
187 P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
188 P_timeframe_Rec IN TIMEFRAME_REC_TYPE,
189 X_Return_Status OUT NOCOPY VARCHAR2,
190 X_Msg_Count OUT NOCOPY NUMBER,
191 X_Msg_Data OUT NOCOPY VARCHAR2
192 );
193
194
195 /*
196 -- *******************************************************
197 -- Start of Comments
198 -- *******************************************************
199 -- API Name: Get_timeframe
200 -- Type : Public
201 -- Pre-Req :
202 -- Parameters:
203 -- IN
204 -- p_api_version_number IN NUMBER Required
205 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
206 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
207 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
208 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
209 -- p_admin_group_id IN NUMBER Required
210 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
211 -- P_timeframe_Rec IN TIMEFRAME_REC_TYPE Required
212 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
213 -- Hint: Add List of bind variables here
214 -- p_rec_requested IN NUMBER Optional Default = 30
215 -- p_start_rec_ptr IN NUMBER Optional Default = 1
216 --
217 -- Return Total Records Count Flag. This flag controls whether the total record count
218 -- and total record amount is returned.
219 --
220 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
221 -- Hint: User defined record type
222 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
223 --
224 -- OUT:
225 -- x_return_status OUT VARCHAR2
226 -- x_msg_count OUT NUMBER
227 -- x_msg_data OUT VARCHAR2
228 -- X_timeframe_Tbl OUT TIMEFRAME_REC_TYPE
229 -- x_returned_rec_count OUT NUMBER
230 -- x_next_rec_ptr OUT NUMBER
231 -- x_tot_rec_count OUT NUMBER
232 -- other optional out parameters
233 -- x_tot_rec_amount OUT NUMBER
234 -- Version : Current version 2.0
235 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
236 -- and basic operation, developer must manually add parameters and business logic as necessary.
237 --
238 -- End of Comments
239 --
240 PROCEDURE Get_timeframe(
241 P_Api_Version_Number IN NUMBER,
242 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
244 P_Admin_Group_id IN NUMBER,
245 P_identity_salesforce_id IN NUMBER := NULL,
246 P_timeframe_Rec IN AML_timeframe_PUB.TIMEFRAME_REC_TYPE,
247 -- Hint: Add list of bind variables here
248 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
249 p_start_rec_prt IN NUMBER := 1,
250 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
251 -- Hint: user defined record type
252 p_order_by_rec IN AML_timeframe_PUB.timeframe_sort_rec_type,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 X_timeframe_Tbl OUT NOCOPY AML_timeframe_PUB.timeframe_Tbl_Type,
257 x_returned_rec_count OUT NOCOPY NUMBER,
258 x_next_rec_ptr OUT NOCOPY NUMBER,
259 x_tot_rec_count OUT NOCOPY NUMBER
260 -- other optional parameters
261 -- x_tot_rec_amount OUT NUMBER
262 );
263
264 */
265
266
267 End AML_TIMEFRAME_PUB;