DBA Data[Home] [Help]

APPS.PV_GE_CHKLST_PVT dependencies on FND_API

Line 67: checklist_item_name VARCHAR2(4000):= FND_API.G_MISS_CHAR

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;

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

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

Line 88: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

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

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

Line 109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 110: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

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

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,

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

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

Line 135: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

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

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

Line 157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

Line 158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

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

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

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

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

Line 181: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

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

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

Line 202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 203: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

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

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,

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

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

Line 227: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

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

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

Line 249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 250: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

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

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,

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

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

Line 273: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

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

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

Line 294: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

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

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,

Line 387: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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