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
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
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
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
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
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
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
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: --
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,
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,
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,
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,
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 ,
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
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
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
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
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
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,
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,
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,
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,
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,
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
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
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
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
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
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,
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,
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,
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,
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,
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
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
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
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
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:
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,
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
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,