APPS.AMS_THLDCHK_PVT_W dependencies on AMS_THLDCHK_PVT

Line 1: package body ams_thldchk_pvt_w as

1: package body ams_thldchk_pvt_w as
2: /* $Header: amswthcb.pls 115.1 2003/07/03 14:24:52 cgoyal 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 65: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;

61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: )
63:
64: as
65: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
66: ddindx binary_integer; indx binary_integer;
67: begin
68:
69: -- copy data to the local IN or IN-OUT args, if any

Line 112: ams_thldchk_pvt.create_thldchk(p_api_version,

108: ddp_thldchk_rec.chk2_worksheet_name := p7_a31;
109:
110:
111: -- here's the delegated call to the old PL/SQL routine
112: ams_thldchk_pvt.create_thldchk(p_api_version,
113: p_init_msg_list,
114: p_commit,
115: p_validation_level,
116: x_return_status,

Line 175: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;

171: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
172: )
173:
174: as
175: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
176: ddindx binary_integer; indx binary_integer;
177: begin
178:
179: -- copy data to the local IN or IN-OUT args, if any

Line 221: ams_thldchk_pvt.update_thldchk(p_api_version,

217: ddp_thldchk_rec.chk2_workbook_owner := p7_a30;
218: ddp_thldchk_rec.chk2_worksheet_name := p7_a31;
219:
220: -- here's the delegated call to the old PL/SQL routine
221: ams_thldchk_pvt.update_thldchk(p_api_version,
222: p_init_msg_list,
223: p_commit,
224: p_validation_level,
225: x_return_status,

Line 281: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;

277: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
278: )
279:
280: as
281: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
282: ddindx binary_integer; indx binary_integer;
283: begin
284:
285: -- copy data to the local IN or IN-OUT args, if any

Line 326: ams_thldchk_pvt.validate_thldchk(p_api_version,

322: ddp_thldchk_rec.chk2_workbook_owner := p6_a30;
323: ddp_thldchk_rec.chk2_worksheet_name := p6_a31;
324:
325: -- here's the delegated call to the old PL/SQL routine
326: ams_thldchk_pvt.validate_thldchk(p_api_version,
327: p_init_msg_list,
328: p_validation_level,
329: x_return_status,
330: x_msg_count,

Line 380: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;

376: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
377: )
378:
379: as
380: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
381: ddindx binary_integer; indx binary_integer;
382: begin
383:
384: -- copy data to the local IN or IN-OUT args, if any

Line 421: ams_thldchk_pvt.check_thldchk_items(ddp_thldchk_rec,

417:
418:
419:
420: -- here's the delegated call to the old PL/SQL routine
421: ams_thldchk_pvt.check_thldchk_items(ddp_thldchk_rec,
422: p_validation_mode,
423: x_return_status);
424:
425: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 498: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;

494: , p1_a31 VARCHAR2 := fnd_api.g_miss_char
495: )
496:
497: as
498: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
499: ddp_complete_rec ams_thldchk_pvt.thldchk_rec_type;
500: ddindx binary_integer; indx binary_integer;
501: begin
502:

Line 499: ddp_complete_rec ams_thldchk_pvt.thldchk_rec_type;

495: )
496:
497: as
498: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
499: ddp_complete_rec ams_thldchk_pvt.thldchk_rec_type;
500: ddindx binary_integer; indx binary_integer;
501: begin
502:
503: -- copy data to the local IN or IN-OUT args, if any

Line 572: ams_thldchk_pvt.check_thldchk_record(ddp_thldchk_rec,

568: ddp_complete_rec.chk2_worksheet_name := p1_a31;
569:
570:
571: -- here's the delegated call to the old PL/SQL routine
572: ams_thldchk_pvt.check_thldchk_record(ddp_thldchk_rec,
573: ddp_complete_rec,
574: x_return_status);
575:
576: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 616: ddx_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;

612: , p0_a31 out nocopy VARCHAR2
613: )
614:
615: as
616: ddx_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
617: ddindx binary_integer; indx binary_integer;
618: begin
619:
620: -- copy data to the local IN or IN-OUT args, if any

Line 623: ams_thldchk_pvt.init_thldchk_rec(ddx_thldchk_rec);

619:
620: -- copy data to the local IN or IN-OUT args, if any
621:
622: -- here's the delegated call to the old PL/SQL routine
623: ams_thldchk_pvt.init_thldchk_rec(ddx_thldchk_rec);
624:
625: -- copy data back from the local variables to OUT or IN-OUT args, if any
626: p0_a0 := rosetta_g_miss_num_map(ddx_thldchk_rec.trigger_check_id);
627: p0_a1 := ddx_thldchk_rec.last_update_date;

Line 727: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;

723: , p0_a31 VARCHAR2 := fnd_api.g_miss_char
724: )
725:
726: as
727: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
728: ddx_complete_rec ams_thldchk_pvt.thldchk_rec_type;
729: ddindx binary_integer; indx binary_integer;
730: begin
731:

Line 728: ddx_complete_rec ams_thldchk_pvt.thldchk_rec_type;

724: )
725:
726: as
727: ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
728: ddx_complete_rec ams_thldchk_pvt.thldchk_rec_type;
729: ddindx binary_integer; indx binary_integer;
730: begin
731:
732: -- copy data to the local IN or IN-OUT args, if any

Line 768: ams_thldchk_pvt.complete_thldchk_rec(ddp_thldchk_rec,

764: ddp_thldchk_rec.chk2_worksheet_name := p0_a31;
765:
766:
767: -- here's the delegated call to the old PL/SQL routine
768: ams_thldchk_pvt.complete_thldchk_rec(ddp_thldchk_rec,
769: ddx_complete_rec);
770:
771: -- copy data back from the local variables to OUT or IN-OUT args, if any
772:

Line 807: end ams_thldchk_pvt_w;

803: p1_a30 := ddx_complete_rec.chk2_workbook_owner;
804: p1_a31 := ddx_complete_rec.chk2_worksheet_name;
805: end;
806:
807: end ams_thldchk_pvt_w;