DBA Data[Home] [Help]

APPS.PV_GE_NOTIF_RULES_PVT dependencies on FND_API

Line 83: notif_name VARCHAR2(4000) := FND_API.G_MISS_CHAR,

79: creation_date DATE,
80: last_updated_by NUMBER,
81: last_update_date DATE,
82: last_update_login NUMBER,
83: notif_name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: notif_content VARCHAR2(4000) := FND_API.G_MISS_CHAR,
85: notif_desc VARCHAR2(4000):= FND_API.G_MISS_CHAR
86:
87:

Line 84: notif_content VARCHAR2(4000) := FND_API.G_MISS_CHAR,

80: last_updated_by NUMBER,
81: last_update_date DATE,
82: last_update_login NUMBER,
83: notif_name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: notif_content VARCHAR2(4000) := FND_API.G_MISS_CHAR,
85: notif_desc VARCHAR2(4000):= FND_API.G_MISS_CHAR
86:
87:
88: );

Line 85: notif_desc VARCHAR2(4000):= FND_API.G_MISS_CHAR

81: last_update_date DATE,
82: last_update_login NUMBER,
83: notif_name VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: notif_content VARCHAR2(4000) := FND_API.G_MISS_CHAR,
85: notif_desc VARCHAR2(4000):= FND_API.G_MISS_CHAR
86:
87:
88: );
89:

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

103: -- Parameters
104: --
105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
111: --

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

104: --
105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
111: --
112: -- OUT

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

105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
111: --
112: -- OUT
113: -- x_return_status OUT VARCHAR2

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

125: -- ==============================================================================
126:
127: PROCEDURE Create_Ge_Notif_Rules(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,

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

126:
127: PROCEDURE Create_Ge_Notif_Rules(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,

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

127: PROCEDURE Create_Ge_Notif_Rules(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,

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

150: -- Parameters
151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_src_object_id IN NUMBER Required
158: -- p_tar_object_id IN NUMBER Required

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

151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_src_object_id IN NUMBER Required
158: -- p_tar_object_id IN NUMBER Required
159: --

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

152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_src_object_id IN NUMBER Required
158: -- p_tar_object_id IN NUMBER Required
159: --
160: -- OUT

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

173: -- ==============================================================================
174: PROCEDURE Copy_Row
175: (
176: p_api_version_number IN NUMBER
177: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER

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

174: PROCEDURE Copy_Row
175: (
176: p_api_version_number IN NUMBER
177: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
182: ,x_msg_data OUT NOCOPY VARCHAR2

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

175: (
176: p_api_version_number IN NUMBER
177: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
182: ,x_msg_data OUT NOCOPY VARCHAR2
183: ,p_src_object_id IN NUMBER

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

196: -- Parameters
197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
204: --

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

197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
204: --
205: -- OUT

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

198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
204: --
205: -- OUT
206: -- x_return_status OUT VARCHAR2

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

218: -- ==============================================================================
219:
220: PROCEDURE Update_Ge_Notif_Rules(
221: p_api_version_number IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225:
226: x_return_status OUT NOCOPY VARCHAR2,

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

219:
220: PROCEDURE Update_Ge_Notif_Rules(
221: p_api_version_number IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,

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

220: PROCEDURE Update_Ge_Notif_Rules(
221: p_api_version_number IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
223: p_commit IN VARCHAR2 := FND_API.G_FALSE,
224: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,

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

242: -- Parameters
243: --
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_notif_rule_id IN NUMBER
250: -- p_object_version_number IN NUMBER Optional Default = NULL

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

243: --
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_notif_rule_id IN NUMBER
250: -- p_object_version_number IN NUMBER Optional Default = NULL
251: --

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

244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_notif_rule_id IN NUMBER
250: -- p_object_version_number IN NUMBER Optional Default = NULL
251: --
252: -- OUT

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

265: -- ==============================================================================
266:
267: PROCEDURE Delete_Ge_Notif_Rules(
268: p_api_version_number IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,

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

266:
267: PROCEDURE Delete_Ge_Notif_Rules(
268: p_api_version_number IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,

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

267: PROCEDURE Delete_Ge_Notif_Rules(
268: p_api_version_number IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_notif_rule_id IN NUMBER,

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

288: -- Parameters
289: --
290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
296: --

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

289: --
290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
296: --
297: -- OUT

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

290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295: -- p_ge_notif_rules_rec IN ge_notif_rules_rec_type Required
296: --
297: -- OUT
298: -- x_return_status OUT VARCHAR2

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

310: -- ==============================================================================
311:
312: PROCEDURE Lock_Ge_Notif_Rules(
313: p_api_version_number IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315:
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,

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

344:
345:
346: PROCEDURE Validate_Ge_Notif_Rules(
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_ge_notif_rules_rec IN ge_notif_rules_rec_type,
351: p_validation_mode IN VARCHAR2,
352: x_return_status OUT NOCOPY VARCHAR2,

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

345:
346: PROCEDURE Validate_Ge_Notif_Rules(
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: p_ge_notif_rules_rec IN ge_notif_rules_rec_type,
351: p_validation_mode IN VARCHAR2,
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,

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

403:
404:
405: PROCEDURE Validate_Ge_Notif_Rules_Rec (
406: p_api_version_number IN NUMBER,
407: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2,
411: p_ge_notif_rules_rec IN ge_notif_rules_rec_type

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

412: );
413:
414: PROCEDURE Create_Ge_Notif_Rules_Rec (
415: p_api_version_number IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419:
420: x_return_status OUT NOCOPY VARCHAR2,

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

413:
414: PROCEDURE Create_Ge_Notif_Rules_Rec (
415: p_api_version_number IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419:
420: x_return_status OUT NOCOPY VARCHAR2,
421: x_msg_count OUT NOCOPY NUMBER,

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

414: PROCEDURE Create_Ge_Notif_Rules_Rec (
415: p_api_version_number IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_commit IN VARCHAR2 := FND_API.G_FALSE,
418: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
419:
420: x_return_status OUT NOCOPY VARCHAR2,
421: x_msg_count OUT NOCOPY NUMBER,
422: x_msg_data OUT NOCOPY VARCHAR2,