DBA Data[Home] [Help]

APPS.AML_TIMEFRAME_PUB dependencies on FND_API

Line 31: TIMEFRAME_ID NUMBER := FND_API.G_MISS_NUM

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

Line 32: , DECISION_TIMEFRAME_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR

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

Line 33: , TIMEFRAME_DAYS NUMBER := FND_API.G_MISS_NUM

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

Line 64: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 65: -- p_commit 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

Line 66: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 67: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 68: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 85: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 86: P_Commit 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,

Line 87: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 88: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 89: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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 ,

Line 110: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 111: -- p_commit 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

Line 112: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 113: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 114: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 134: P_Commit 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,

Line 135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 136: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 137: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 156: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 157: -- p_commit 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

Line 158: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 159: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 160: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 180: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 181: P_Commit 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,

Line 182: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 183: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 184: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 205: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 206: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 207: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 208: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 220: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

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:

Line 242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 243: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 250: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

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,