APPS.AMS_USER_STATUSES_PVT_W dependencies on AMS_USER_STATUSES_PVT

Line 1: package body ams_user_statuses_pvt_w as

1: package body ams_user_statuses_pvt_w as
2: /* $Header: amswustb.pls 120.1 2005/09/30 06:55 mayjain noship $ */
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:

Line 49: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

45: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46: )
47:
48: as
49: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;
50: ddindx binary_integer; indx binary_integer;
51: begin
52:
53: -- copy data to the local IN or IN-OUT args, if any

Line 80: ams_user_statuses_pvt.create_user_status(p_api_version,

76: ddp_user_status_rec.description := p7_a15;
77:
78:
79: -- here's the delegated call to the old PL/SQL routine
80: ams_user_statuses_pvt.create_user_status(p_api_version,
81: p_init_msg_list,
82: p_commit,
83: p_validation_level,
84: x_return_status,

Line 127: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

123: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
124: )
125:
126: as
127: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;
128: ddindx binary_integer; indx binary_integer;
129: begin
130:
131: -- copy data to the local IN or IN-OUT args, if any

Line 157: ams_user_statuses_pvt.update_user_status(p_api_version,

153: ddp_user_status_rec.name := p7_a14;
154: ddp_user_status_rec.description := p7_a15;
155:
156: -- here's the delegated call to the old PL/SQL routine
157: ams_user_statuses_pvt.update_user_status(p_api_version,
158: p_init_msg_list,
159: p_commit,
160: p_validation_level,
161: x_return_status,

Line 202: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

198: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
199: )
200:
201: as
202: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;
203: ddindx binary_integer; indx binary_integer;
204: begin
205:
206: -- copy data to the local IN or IN-OUT args, if any

Line 232: ams_user_statuses_pvt.validate_user_status(p_api_version,

228: ddp_user_status_rec.name := p7_a14;
229: ddp_user_status_rec.description := p7_a15;
230:
231: -- here's the delegated call to the old PL/SQL routine
232: ams_user_statuses_pvt.validate_user_status(p_api_version,
233: p_init_msg_list,
234: p_commit,
235: p_validation_level,
236: x_return_status,

Line 272: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

268: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
269: )
270:
271: as
272: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;
273: ddindx binary_integer; indx binary_integer;
274: begin
275:
276: -- copy data to the local IN or IN-OUT args, if any

Line 297: ams_user_statuses_pvt.check_user_status_items(ddp_user_status_rec,

293:
294:
295:
296: -- here's the delegated call to the old PL/SQL routine
297: ams_user_statuses_pvt.check_user_status_items(ddp_user_status_rec,
298: p_validation_mode,
299: x_return_status);
300:
301: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 342: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

338: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
339: )
340:
341: as
342: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;
343: ddp_complete_rec ams_user_statuses_pvt.user_status_rec_type;
344: ddindx binary_integer; indx binary_integer;
345: begin
346:

Line 343: ddp_complete_rec ams_user_statuses_pvt.user_status_rec_type;

339: )
340:
341: as
342: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;
343: ddp_complete_rec ams_user_statuses_pvt.user_status_rec_type;
344: ddindx binary_integer; indx binary_integer;
345: begin
346:
347: -- copy data to the local IN or IN-OUT args, if any

Line 384: ams_user_statuses_pvt.check_user_status_record(ddp_user_status_rec,

380: ddp_complete_rec.description := p1_a15;
381:
382:
383: -- here's the delegated call to the old PL/SQL routine
384: ams_user_statuses_pvt.check_user_status_record(ddp_user_status_rec,
385: ddp_complete_rec,
386: x_return_status);
387:
388: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 412: ddx_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

408: , p0_a15 out nocopy VARCHAR2
409: )
410:
411: as
412: ddx_user_status_rec ams_user_statuses_pvt.user_status_rec_type;
413: ddindx binary_integer; indx binary_integer;
414: begin
415:
416: -- copy data to the local IN or IN-OUT args, if any

Line 419: ams_user_statuses_pvt.init_user_status_rec(ddx_user_status_rec);

415:
416: -- copy data to the local IN or IN-OUT args, if any
417:
418: -- here's the delegated call to the old PL/SQL routine
419: ams_user_statuses_pvt.init_user_status_rec(ddx_user_status_rec);
420:
421: -- copy data back from the local variables to OUT or IN-OUT args, if any
422: p0_a0 := rosetta_g_miss_num_map(ddx_user_status_rec.user_status_id);
423: p0_a1 := ddx_user_status_rec.last_update_date;

Line 475: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;

471: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
472: )
473:
474: as
475: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;
476: ddx_complete_rec ams_user_statuses_pvt.user_status_rec_type;
477: ddindx binary_integer; indx binary_integer;
478: begin
479:

Line 476: ddx_complete_rec ams_user_statuses_pvt.user_status_rec_type;

472: )
473:
474: as
475: ddp_user_status_rec ams_user_statuses_pvt.user_status_rec_type;
476: ddx_complete_rec ams_user_statuses_pvt.user_status_rec_type;
477: ddindx binary_integer; indx binary_integer;
478: begin
479:
480: -- copy data to the local IN or IN-OUT args, if any

Line 500: ams_user_statuses_pvt.complete_user_status_rec(ddp_user_status_rec,

496: ddp_user_status_rec.description := p0_a15;
497:
498:
499: -- here's the delegated call to the old PL/SQL routine
500: ams_user_statuses_pvt.complete_user_status_rec(ddp_user_status_rec,
501: ddx_complete_rec);
502:
503: -- copy data back from the local variables to OUT or IN-OUT args, if any
504:

Line 523: end ams_user_statuses_pvt_w;

519: p1_a14 := ddx_complete_rec.name;
520: p1_a15 := ddx_complete_rec.description;
521: end;
522:
523: end ams_user_statuses_pvt_w;