1 PACKAGE AML_TIMEFRAME_PVT AUTHID CURRENT_USER as
2 /* $Header: amlvtfrs.pls 115.5 2002/12/05 00:27:00 ckapoor noship $ */
3 -- Start of Comments
4 -- Package name : AML_TIMEFRAME_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 -- *******************************************************
12 -- Start of Comments
13 -- *******************************************************
14 -- API Name: Create_timeframe
15 -- Type : Private
16 -- Pre-Req :
17 -- Parameters:
18 -- IN
19 -- p_api_version_number IN NUMBER Required
20 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
21 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
22 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
23 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
24 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
25 -- p_admin_group_id IN NUMBER Required
26 -- P_timeframe_Rec IN timeframe_Rec_Type Required
27 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
28 --
29 -- OUT:
30 -- x_return_status OUT VARCHAR2
31 -- x_msg_count OUT NUMBER
32 -- x_msg_data OUT VARCHAR2
33 -- Version : Current version 2.0
34 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
35 -- and basic operation, developer must manually add parameters and business logic as necessary.
36 --
37 -- End of Comments
38 --
39 PROCEDURE Create_timeframe(
40 P_Api_Version_Number IN NUMBER,
41 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
42 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
45 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
46 P_Admin_Group_Id IN NUMBER,
47 P_Identity_Salesforce_Id IN NUMBER,
48 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
49 P_timeframe_Rec IN AML_TIMEFRAME_PUB.timeframe_Rec_Type ,
50 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
51 X_TIMEFRAME_ID OUT NOCOPY NUMBER,
52 X_Return_Status OUT NOCOPY VARCHAR2,
53 X_Msg_Count OUT NOCOPY NUMBER,
54 X_Msg_Data OUT NOCOPY VARCHAR2
55 );
56
57 -- *******************************************************
58 -- Start of Comments
59 -- *******************************************************
60 -- API Name: Update_timeframe
61 -- Type : Private
62 -- Pre-Req :
63 -- Parameters:
64 -- IN
65 -- p_api_version_number IN NUMBER Required
66 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
67 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
68 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
69 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
70 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
71 -- p_admin_group_id IN NUMBER Required
72 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
73 -- P_timeframe_Rec IN timeframe_Rec_Type Required
74 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
75 --
76 -- OUT:
77 -- x_return_status OUT VARCHAR2
78 -- x_msg_count OUT NUMBER
79 -- x_msg_data OUT VARCHAR2
80 -- Version : Current version 2.0
81 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
82 -- and basic operation, developer must manually add parameters and business logic as necessary.
83 --
84 -- End of Comments
85 --
86 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
87 PROCEDURE Update_timeframe(
88 P_Api_Version_Number IN NUMBER,
89 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
93 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
94 P_Admin_Group_Id IN NUMBER,
95 P_Identity_Salesforce_Id IN NUMBER,
96 P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
97 P_timeframe_Rec IN AML_TIMEFRAME_PUB.timeframe_Rec_Type,
98 X_Return_Status OUT NOCOPY VARCHAR2,
99 X_Msg_Count OUT NOCOPY NUMBER,
100 X_Msg_Data OUT NOCOPY VARCHAR2
101 );
102
103 -- *******************************************************
104 -- Start of Comments
105 -- *******************************************************
106 -- API Name: Delete_timeframe
107 -- Type : Private
108 -- Pre-Req :
109 -- Parameters:
110 -- IN
111 -- p_api_version_number IN NUMBER Required
112 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
113 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
114 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
115 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
116 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
117 -- p_admin_group_id IN NUMBER Required
118 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
119 -- P_timeframe_Rec IN timeframe_Rec_Type Required
120 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
121 --
122 -- OUT:
123 -- x_return_status OUT VARCHAR2
124 -- x_msg_count OUT NUMBER
125 -- x_msg_data OUT VARCHAR2
126 -- Version : Current version 2.0
127 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
128 -- and basic operation, developer must manually add parameters and business logic as necessary.
129 --
130 -- End of Comments
131 --
132 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
133 -- The Master delete procedure may not be needed depends on different business requirements.
134 PROCEDURE Delete_timeframe(
135 P_Api_Version_Number IN NUMBER,
136 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139 P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
140 P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
141 P_Admin_Group_Id IN NUMBER,
142 P_Identity_Salesforce_Id IN NUMBER,
143 P_Profile_Tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
144 P_timeframe_Rec IN AML_TIMEFRAME_PUB.timeframe_Rec_Type,
145 X_Return_Status OUT NOCOPY VARCHAR2,
146 X_Msg_Count OUT NOCOPY NUMBER,
147 X_Msg_Data OUT NOCOPY VARCHAR2
148 );
149
150
151 -- Start of Comments
152 --
153 -- Item level validation procedures
154 --
155 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
156 -- For create: G_CREATE, for update: G_UPDATE
157 -- Note: 1. This is automated generated item level validation procedure.
158 -- The actual validation detail is needed to be added.
159 --
160 -- End of Comments
161
162 PROCEDURE Validate_TIMEFRAME_ID (
163 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164 P_Validation_mode IN VARCHAR2,
165 P_TIMEFRAME_ID IN NUMBER,
166 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
167 X_Return_Status OUT NOCOPY VARCHAR2,
168 X_Msg_Count OUT NOCOPY NUMBER,
169 X_Msg_Data OUT NOCOPY VARCHAR2
170 );
171
172 -- Start of Comments
173 --
174 -- Item level validation procedures
175 --
176 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
177 -- For create: G_CREATE, for update: G_UPDATE
178 -- Note: 1. This is automated generated item level validation procedure.
179 -- The actual validation detail is needed to be added.
180 --
181 -- End of Comments
182
183 PROCEDURE Validate_DECN_TIMEFRAME_CODE (
184 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
185 P_Validation_mode IN VARCHAR2,
186 P_DECISION_TIMEFRAME_CODE IN VARCHAR2,
187 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
188 X_Return_Status OUT NOCOPY VARCHAR2,
189 X_Msg_Count OUT NOCOPY NUMBER,
190 X_Msg_Data OUT NOCOPY VARCHAR2
191 );
192
193 -- Start of Comments
194 --
195 -- Item level validation procedures
196 --
197 -- p_validation_mode is a constant defined in AS_UTILITY_PVT package
198 -- For create: G_CREATE, for update: G_UPDATE
199 -- Note: 1. This is automated generated item level validation procedure.
200 -- The actual validation detail is needed to be added.
201 --
202 -- End of Comments
203
204 PROCEDURE Validate_TIMEFRAME_DAYS (
205 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
206 P_Validation_mode IN VARCHAR2,
207 P_TIMEFRAME_DAYS IN NUMBER,
208 -- Hint: You may add 'X_Item_Property_Rec OUT AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
209 X_Return_Status OUT NOCOPY VARCHAR2,
210 X_Msg_Count OUT NOCOPY NUMBER,
211 X_Msg_Data OUT NOCOPY VARCHAR2
212 );
213
214
215 End AML_TIMEFRAME_PVT;