[Home] [Help]
1: package body ams_list_word_replaces_pvt_w as
2: /* $Header: amswwdrb.pls 115.6 2002/11/22 08:58:02 jieli ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
39: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41: )
42: as
43: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
44: ddindx binary_integer; indx binary_integer;
45: begin
46:
47: -- copy data to the local IN or IN-OUT args, if any
65: ddp_wrd_rpl_rec.description := p7_a10;
66:
67:
68: -- here's the delegated call to the old PL/SQL routine
69: ams_list_word_replaces_pvt.create_list_word_replace(p_api_version,
70: p_init_msg_list,
71: p_commit,
72: p_validation_level,
73: x_return_status,
106: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
108: )
109: as
110: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
111: ddindx binary_integer; indx binary_integer;
112: begin
113:
114: -- copy data to the local IN or IN-OUT args, if any
131: ddp_wrd_rpl_rec.enabled_flag := p7_a9;
132: ddp_wrd_rpl_rec.description := p7_a10;
133:
134: -- here's the delegated call to the old PL/SQL routine
135: ams_list_word_replaces_pvt.update_list_word_replace(p_api_version,
136: p_init_msg_list,
137: p_commit,
138: p_validation_level,
139: x_return_status,
169: , p6_a9 VARCHAR2 := fnd_api.g_miss_char
170: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
171: )
172: as
173: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
174: ddindx binary_integer; indx binary_integer;
175: begin
176:
177: -- copy data to the local IN or IN-OUT args, if any
193: ddp_wrd_rpl_rec.enabled_flag := p6_a9;
194: ddp_wrd_rpl_rec.description := p6_a10;
195:
196: -- here's the delegated call to the old PL/SQL routine
197: ams_list_word_replaces_pvt.validate_list_word_replace(p_api_version,
198: p_init_msg_list,
199: p_validation_level,
200: x_return_status,
201: x_msg_count,
225: , p2_a9 VARCHAR2 := fnd_api.g_miss_char
226: , p2_a10 VARCHAR2 := fnd_api.g_miss_char
227: )
228: as
229: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
230: ddindx binary_integer; indx binary_integer;
231: begin
232:
233: -- copy data to the local IN or IN-OUT args, if any
245: ddp_wrd_rpl_rec.enabled_flag := p2_a9;
246: ddp_wrd_rpl_rec.description := p2_a10;
247:
248: -- here's the delegated call to the old PL/SQL routine
249: ams_list_word_replaces_pvt.check_items(p_validation_mode,
250: x_return_status,
251: ddp_wrd_rpl_rec);
252:
253: -- copy data back from the local OUT or IN-OUT args, if any
269: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
270: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
271: )
272: as
273: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
274: ddindx binary_integer; indx binary_integer;
275: begin
276:
277: -- copy data to the local IN or IN-OUT args, if any
289: ddp_wrd_rpl_rec.description := p1_a10;
290:
291:
292: -- here's the delegated call to the old PL/SQL routine
293: ams_list_word_replaces_pvt.check_req_items(p_validation_mode,
294: ddp_wrd_rpl_rec,
295: x_return_status);
296:
297: -- copy data back from the local OUT or IN-OUT args, if any
313: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
314: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
315: )
316: as
317: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
318: ddindx binary_integer; indx binary_integer;
319: begin
320:
321: -- copy data to the local IN or IN-OUT args, if any
333: ddp_wrd_rpl_rec.description := p1_a10;
334:
335:
336: -- here's the delegated call to the old PL/SQL routine
337: ams_list_word_replaces_pvt.check_uk_items(p_validation_mode,
338: ddp_wrd_rpl_rec,
339: x_return_status);
340:
341: -- copy data back from the local OUT or IN-OUT args, if any
366: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
367: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
368: )
369: as
370: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
371: ddx_complete_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
372: ddindx binary_integer; indx binary_integer;
373: begin
374:
367: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
368: )
369: as
370: ddp_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
371: ddx_complete_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
372: ddindx binary_integer; indx binary_integer;
373: begin
374:
375: -- copy data to the local IN or IN-OUT args, if any
386: ddp_wrd_rpl_rec.description := p0_a10;
387:
388:
389: -- here's the delegated call to the old PL/SQL routine
390: ams_list_word_replaces_pvt.complete_rec(ddp_wrd_rpl_rec,
391: ddx_complete_rec);
392:
393: -- copy data back from the local OUT or IN-OUT args, if any
394:
417: , p0_a9 OUT NOCOPY VARCHAR2
418: , p0_a10 OUT NOCOPY VARCHAR2
419: )
420: as
421: ddx_wrd_rpl_rec ams_list_word_replaces_pvt.wrd_rpl_rec_type;
422: ddindx binary_integer; indx binary_integer;
423: begin
424:
425: -- copy data to the local IN or IN-OUT args, if any
424:
425: -- copy data to the local IN or IN-OUT args, if any
426:
427: -- here's the delegated call to the old PL/SQL routine
428: ams_list_word_replaces_pvt.init_rec(ddx_wrd_rpl_rec);
429:
430: -- copy data back from the local OUT or IN-OUT args, if any
431: p0_a0 := rosetta_g_miss_num_map(ddx_wrd_rpl_rec.list_word_replaces_id);
432: p0_a1 := ddx_wrd_rpl_rec.last_update_date;
440: p0_a9 := ddx_wrd_rpl_rec.enabled_flag;
441: p0_a10 := ddx_wrd_rpl_rec.description;
442: end;
443:
444: end ams_list_word_replaces_pvt_w;