DBA Data[Home] [Help]

APPS.AMS_ACCESS_PVT_W_NEW dependencies on AMS_ACCESS_PVT

Line 1: package body ams_access_pvt_w_new as

1: package body ams_access_pvt_w_new as
2: /* $Header: amsacesb.pls 120.1 2005/08/29 06:01 anskumar noship $ */
3: procedure create_access(p_api_version NUMBER
4: , p_init_msg_list VARCHAR2
5: , p_commit VARCHAR2

Line 31: ddp_access_rec ams_access_pvt.access_rec_type;

27: , x_access_id out nocopy NUMBER
28: )
29:
30: as
31: ddp_access_rec ams_access_pvt.access_rec_type;
32: ddindx binary_integer; indx binary_integer;
33: begin
34:
35: -- copy data to the local IN or IN-OUT args, if any

Line 63: ams_access_pvt.create_access(p_api_version,

59: ddp_access_rec.delete_flag := p7_a16;
60:
61:
62: -- here's the delegated call to the old PL/SQL routine
63: ams_access_pvt.create_access(p_api_version,
64: p_init_msg_list,
65: p_commit,
66: p_validation_level,
67: x_return_status,

Line 111: ddp_access_rec ams_access_pvt.access_rec_type;

107: , p7_a16 VARCHAR2
108: )
109:
110: as
111: ddp_access_rec ams_access_pvt.access_rec_type;
112: ddindx binary_integer; indx binary_integer;
113: begin
114:
115: -- copy data to the local IN or IN-OUT args, if any

Line 142: ams_access_pvt.update_access(p_api_version,

138: ddp_access_rec.owner_flag := p7_a15;
139: ddp_access_rec.delete_flag := p7_a16;
140:
141: -- here's the delegated call to the old PL/SQL routine
142: ams_access_pvt.update_access(p_api_version,
143: p_init_msg_list,
144: p_commit,
145: p_validation_level,
146: x_return_status,

Line 187: ddp_access_rec ams_access_pvt.access_rec_type;

183: , p6_a16 VARCHAR2
184: )
185:
186: as
187: ddp_access_rec ams_access_pvt.access_rec_type;
188: ddindx binary_integer; indx binary_integer;
189: begin
190:
191: -- copy data to the local IN or IN-OUT args, if any

Line 217: ams_access_pvt.validate_access(p_api_version,

213: ddp_access_rec.owner_flag := p6_a15;
214: ddp_access_rec.delete_flag := p6_a16;
215:
216: -- here's the delegated call to the old PL/SQL routine
217: ams_access_pvt.validate_access(p_api_version,
218: p_init_msg_list,
219: p_validation_level,
220: x_return_status,
221: x_msg_count,

Line 256: ddp_access_rec ams_access_pvt.access_rec_type;

252: , x_return_status out nocopy VARCHAR2
253: )
254:
255: as
256: ddp_access_rec ams_access_pvt.access_rec_type;
257: ddindx binary_integer; indx binary_integer;
258: begin
259:
260: -- copy data to the local IN or IN-OUT args, if any

Line 282: ams_access_pvt.check_access_items(ddp_access_rec,

278:
279:
280:
281: -- here's the delegated call to the old PL/SQL routine
282: ams_access_pvt.check_access_items(ddp_access_rec,
283: p_validation_mode,
284: x_return_status);
285:
286: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 329: ddp_access_rec ams_access_pvt.access_rec_type;

325: , x_return_status out nocopy VARCHAR2
326: )
327:
328: as
329: ddp_access_rec ams_access_pvt.access_rec_type;
330: ddp_complete_rec ams_access_pvt.access_rec_type;
331: ddindx binary_integer; indx binary_integer;
332: begin
333:

Line 330: ddp_complete_rec ams_access_pvt.access_rec_type;

326: )
327:
328: as
329: ddp_access_rec ams_access_pvt.access_rec_type;
330: ddp_complete_rec ams_access_pvt.access_rec_type;
331: ddindx binary_integer; indx binary_integer;
332: begin
333:
334: -- copy data to the local IN or IN-OUT args, if any

Line 373: ams_access_pvt.check_access_record(ddp_access_rec,

369: ddp_complete_rec.delete_flag := p1_a16;
370:
371:
372: -- here's the delegated call to the old PL/SQL routine
373: ams_access_pvt.check_access_record(ddp_access_rec,
374: ddp_complete_rec,
375: x_return_status);
376:
377: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 402: ddx_access_rec ams_access_pvt.access_rec_type;

398: , p0_a16 out nocopy VARCHAR2
399: )
400:
401: as
402: ddx_access_rec ams_access_pvt.access_rec_type;
403: ddindx binary_integer; indx binary_integer;
404: begin
405:
406: -- copy data to the local IN or IN-OUT args, if any

Line 409: ams_access_pvt.init_access_rec(ddx_access_rec);

405:
406: -- copy data to the local IN or IN-OUT args, if any
407:
408: -- here's the delegated call to the old PL/SQL routine
409: ams_access_pvt.init_access_rec(ddx_access_rec);
410:
411: -- copy data back from the local variables to OUT or IN-OUT args, if any
412: p0_a0 := ddx_access_rec.activity_access_id;
413: p0_a1 := ddx_access_rec.last_update_date;

Line 468: ddp_access_rec ams_access_pvt.access_rec_type;

464: , p1_a16 out nocopy VARCHAR2
465: )
466:
467: as
468: ddp_access_rec ams_access_pvt.access_rec_type;
469: ddx_complete_rec ams_access_pvt.access_rec_type;
470: ddindx binary_integer; indx binary_integer;
471: begin
472:

Line 469: ddx_complete_rec ams_access_pvt.access_rec_type;

465: )
466:
467: as
468: ddp_access_rec ams_access_pvt.access_rec_type;
469: ddx_complete_rec ams_access_pvt.access_rec_type;
470: ddindx binary_integer; indx binary_integer;
471: begin
472:
473: -- copy data to the local IN or IN-OUT args, if any

Line 494: ams_access_pvt.complete_access_rec(ddp_access_rec,

490: ddp_access_rec.delete_flag := p0_a16;
491:
492:
493: -- here's the delegated call to the old PL/SQL routine
494: ams_access_pvt.complete_access_rec(ddp_access_rec,
495: ddx_complete_rec);
496:
497: -- copy data back from the local variables to OUT or IN-OUT args, if any
498:

Line 530: ddrosetta_retval := ams_access_pvt.check_admin_access(p_resource_id);

526:
527: -- copy data to the local IN or IN-OUT args, if any
528:
529: -- here's the delegated call to the old PL/SQL routine
530: ddrosetta_retval := ams_access_pvt.check_admin_access(p_resource_id);
531:
532: -- copy data back from the local variables to OUT or IN-OUT args, if any
533: if ddrosetta_retval is null
534: then ddrosetta_retval_bool := null;

Line 541: end ams_access_pvt_w_new;

537: else ddrosetta_retval_bool := 0;
538: end if;
539: end;
540:
541: end ams_access_pvt_w_new;