80: -- Parameters
81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
88: --
81: --
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
88: --
89: -- OUT
82: -- IN
83: -- p_api_version_number IN NUMBER Required
84: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
85: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
86: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
87: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
88: --
89: -- OUT
90: -- x_return_status OUT VARCHAR2
102: -- ==============================================================================
103:
104: PROCEDURE Create_Ge_Chklst_Resp(
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
103:
104: PROCEDURE Create_Ge_Chklst_Resp(
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
104: PROCEDURE Create_Ge_Chklst_Resp(
105: p_api_version_number IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109:
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
127: -- Parameters
128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
135: --
128: --
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
135: --
136: -- OUT
129: -- IN
130: -- p_api_version_number IN NUMBER Required
131: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
133: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
134: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
135: --
136: -- OUT
137: -- x_return_status OUT VARCHAR2
149: -- ==============================================================================
150:
151: PROCEDURE Update_Ge_Chklst_Resp(
152: p_api_version_number IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
150:
151: PROCEDURE Update_Ge_Chklst_Resp(
152: p_api_version_number IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
151: PROCEDURE Update_Ge_Chklst_Resp(
152: p_api_version_number IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156:
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
173: -- Parameters
174: --
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_chklst_response_id IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
174: --
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_chklst_response_id IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
182: --
175: -- IN
176: -- p_api_version_number IN NUMBER Required
177: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180: -- p_chklst_response_id IN NUMBER
181: -- p_object_version_number IN NUMBER Optional Default = NULL
182: --
183: -- OUT
196: -- ==============================================================================
197:
198: PROCEDURE Delete_Ge_Chklst_Resp(
199: p_api_version_number IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
197:
198: PROCEDURE Delete_Ge_Chklst_Resp(
199: p_api_version_number IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
198: PROCEDURE Delete_Ge_Chklst_Resp(
199: p_api_version_number IN NUMBER,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_chklst_response_id IN NUMBER,
219: -- Parameters
220: --
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
227: --
220: --
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
227: --
228: -- OUT
221: -- IN
222: -- p_api_version_number IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
225: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
226: -- p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type Required
227: --
228: -- OUT
229: -- x_return_status OUT VARCHAR2
241: -- ==============================================================================
242:
243: PROCEDURE Lock_Ge_Chklst_Resp(
244: p_api_version_number IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246:
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
275:
276:
277: PROCEDURE Validate_Ge_Chklst_Resp(
278: p_api_version_number IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type,
282: p_validation_mode IN VARCHAR2,
283: x_return_status OUT NOCOPY VARCHAR2,
276:
277: PROCEDURE Validate_Ge_Chklst_Resp(
278: p_api_version_number IN NUMBER,
279: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
281: p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type,
282: p_validation_mode IN VARCHAR2,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
334:
335:
336: PROCEDURE Validate_Ge_Chklst_Resp_Rec (
337: p_api_version_number IN NUMBER,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,
342: p_ge_chklst_resp_rec IN ge_chklst_resp_rec_type
344:
345:
346: PROCEDURE Create_Enrq_Responses (
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351:
352: x_return_status OUT NOCOPY VARCHAR2,
345:
346: PROCEDURE Create_Enrq_Responses (
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351:
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
346: PROCEDURE Create_Enrq_Responses (
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351:
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
354: x_msg_data OUT NOCOPY VARCHAR2,