63: creation_date DATE,
64: last_updated_by NUMBER,
65: last_update_date DATE,
66: last_update_login NUMBER,
67: checklist_item_name VARCHAR2(4000):= FND_API.G_MISS_CHAR
68: );
69:
70: g_miss_ge_chklst_rec ge_chklst_rec_type := NULL;
71: TYPE ge_chklst_tbl_type IS TABLE OF ge_chklst_rec_type INDEX BY BINARY_INTEGER;
83: -- Parameters
84: --
85: -- IN
86: -- p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
90: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
91: --
84: --
85: -- IN
86: -- p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
90: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
91: --
92: -- OUT
85: -- IN
86: -- p_api_version_number IN NUMBER Required
87: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
90: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
91: --
92: -- OUT
93: -- x_return_status OUT VARCHAR2
105: -- ==============================================================================
106:
107: PROCEDURE Create_Ge_Chklst(
108: p_api_version_number IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112:
113: x_return_status OUT NOCOPY VARCHAR2,
106:
107: PROCEDURE Create_Ge_Chklst(
108: p_api_version_number IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112:
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
107: PROCEDURE Create_Ge_Chklst(
108: p_api_version_number IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110: p_commit IN VARCHAR2 := FND_API.G_FALSE,
111: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112:
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
130: -- Parameters
131: --
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_src_object_id IN NUMBER Required
138: -- p_tar_object_id IN NUMBER Required
131: --
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_src_object_id IN NUMBER Required
138: -- p_tar_object_id IN NUMBER Required
139: --
132: -- IN
133: -- p_api_version_number IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
136: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
137: -- p_src_object_id IN NUMBER Required
138: -- p_tar_object_id IN NUMBER Required
139: --
140: -- OUT
153: -- ==============================================================================
154: PROCEDURE Copy_Row
155: (
156: p_api_version_number IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_count OUT NOCOPY NUMBER
154: PROCEDURE Copy_Row
155: (
156: p_api_version_number IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_count OUT NOCOPY NUMBER
162: ,x_msg_data OUT NOCOPY VARCHAR2
155: (
156: p_api_version_number IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_count OUT NOCOPY NUMBER
162: ,x_msg_data OUT NOCOPY VARCHAR2
163: ,p_src_object_id IN NUMBER
176: -- Parameters
177: --
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
184: --
177: --
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
184: --
185: -- OUT
178: -- IN
179: -- p_api_version_number IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
183: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
184: --
185: -- OUT
186: -- x_return_status OUT VARCHAR2
198: -- ==============================================================================
199:
200: PROCEDURE Update_Ge_Chklst(
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
199:
200: PROCEDURE Update_Ge_Chklst(
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
200: PROCEDURE Update_Ge_Chklst(
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
222: -- Parameters
223: --
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_checklist_item_id IN NUMBER
230: -- p_object_version_number IN NUMBER Optional Default = NULL
223: --
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_checklist_item_id IN NUMBER
230: -- p_object_version_number IN NUMBER Optional Default = NULL
231: --
224: -- IN
225: -- p_api_version_number IN NUMBER Required
226: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
229: -- p_checklist_item_id IN NUMBER
230: -- p_object_version_number IN NUMBER Optional Default = NULL
231: --
232: -- OUT
245: -- ==============================================================================
246:
247: PROCEDURE Delete_Ge_Chklst(
248: p_api_version_number IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
246:
247: PROCEDURE Delete_Ge_Chklst(
248: p_api_version_number IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
247: PROCEDURE Delete_Ge_Chklst(
248: p_api_version_number IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_checklist_item_id IN NUMBER,
268: -- Parameters
269: --
270: -- IN
271: -- p_api_version_number IN NUMBER Required
272: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
273: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
276: --
269: --
270: -- IN
271: -- p_api_version_number IN NUMBER Required
272: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
273: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
276: --
277: -- OUT
270: -- IN
271: -- p_api_version_number IN NUMBER Required
272: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
273: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_ge_chklst_rec IN ge_chklst_rec_type Required
276: --
277: -- OUT
278: -- x_return_status OUT VARCHAR2
290: -- ==============================================================================
291:
292: PROCEDURE Lock_Ge_Chklst(
293: p_api_version_number IN NUMBER,
294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
295:
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
324:
325:
326: PROCEDURE Validate_Ge_Chklst(
327: p_api_version_number IN NUMBER,
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: p_ge_chklst_rec IN ge_chklst_rec_type,
331: p_validation_mode IN VARCHAR2,
332: x_return_status OUT NOCOPY VARCHAR2,
325:
326: PROCEDURE Validate_Ge_Chklst(
327: p_api_version_number IN NUMBER,
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: p_ge_chklst_rec IN ge_chklst_rec_type,
331: p_validation_mode IN VARCHAR2,
332: x_return_status OUT NOCOPY VARCHAR2,
333: x_msg_count OUT NOCOPY NUMBER,
383:
384:
385: PROCEDURE Validate_Ge_Chklst_Rec (
386: p_api_version_number IN NUMBER,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
388: x_return_status OUT NOCOPY VARCHAR2,
389: x_msg_count OUT NOCOPY NUMBER,
390: x_msg_data OUT NOCOPY VARCHAR2,
391: p_ge_chklst_rec IN ge_chklst_rec_type