eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_RULES_ALL_PVT_W dependencies on AMS_LIST_RULES_ALL_PVT

Line 1: package body ams_list_rules_all_pvt_w as

1: package body ams_list_rules_all_pvt_w as
2: /* $Header: amswruab.pls 115.5 2002/11/22 08:57:47 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:

Line 46: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

42: , p7_a12 NUMBER := 0-1962.0724
43: , p7_a13 VARCHAR := fnd_api.g_miss_char
44: )
45: as
46: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
47: ddindx binary_integer; indx binary_integer;
48: begin
49:
50: -- copy data to the local IN or IN-OUT args, if any

Line 75: ams_list_rules_all_pvt.create_list_rule(p_api_version,

71: ddp_list_rule_rec.list_rule_type := p7_a13;
72:
73:
74: -- here's the delegated call to the old PL/SQL routine
75: ams_list_rules_all_pvt.create_list_rule(p_api_version,
76: p_init_msg_list,
77: p_commit,
78: p_validation_level,
79: x_return_status,

Line 119: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

115: , p7_a12 NUMBER := 0-1962.0724
116: , p7_a13 VARCHAR := fnd_api.g_miss_char
117: )
118: as
119: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
120: ddindx binary_integer; indx binary_integer;
121: begin
122:
123: -- copy data to the local IN or IN-OUT args, if any

Line 147: ams_list_rules_all_pvt.update_list_rule(p_api_version,

143: ddp_list_rule_rec.org_id := rosetta_g_miss_num_map(p7_a12);
144: ddp_list_rule_rec.list_rule_type := p7_a13;
145:
146: -- here's the delegated call to the old PL/SQL routine
147: ams_list_rules_all_pvt.update_list_rule(p_api_version,
148: p_init_msg_list,
149: p_commit,
150: p_validation_level,
151: x_return_status,

Line 188: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

184: , p6_a12 NUMBER := 0-1962.0724
185: , p6_a13 VARCHAR := fnd_api.g_miss_char
186: )
187: as
188: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
189: ddindx binary_integer; indx binary_integer;
190: begin
191:
192: -- copy data to the local IN or IN-OUT args, if any

Line 215: ams_list_rules_all_pvt.validate_list_rule(p_api_version,

211: ddp_list_rule_rec.org_id := rosetta_g_miss_num_map(p6_a12);
212: ddp_list_rule_rec.list_rule_type := p6_a13;
213:
214: -- here's the delegated call to the old PL/SQL routine
215: ams_list_rules_all_pvt.validate_list_rule(p_api_version,
216: p_init_msg_list,
217: p_validation_level,
218: x_return_status,
219: x_msg_count,

Line 250: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

246: , p2_a12 NUMBER := 0-1962.0724
247: , p2_a13 VARCHAR := fnd_api.g_miss_char
248: )
249: as
250: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
251: ddindx binary_integer; indx binary_integer;
252: begin
253:
254: -- copy data to the local IN or IN-OUT args, if any

Line 273: ams_list_rules_all_pvt.check_items(p_validation_mode,

269: ddp_list_rule_rec.org_id := rosetta_g_miss_num_map(p2_a12);
270: ddp_list_rule_rec.list_rule_type := p2_a13;
271:
272: -- here's the delegated call to the old PL/SQL routine
273: ams_list_rules_all_pvt.check_items(p_validation_mode,
274: x_return_status,
275: ddp_list_rule_rec);
276:
277: -- copy data back from the local OUT or IN-OUT args, if any

Line 300: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

296: , p1_a12 NUMBER := 0-1962.0724
297: , p1_a13 VARCHAR := fnd_api.g_miss_char
298: )
299: as
300: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
301: ddindx binary_integer; indx binary_integer;
302: begin
303:
304: -- copy data to the local IN or IN-OUT args, if any

Line 323: ams_list_rules_all_pvt.check_req_items(p_validation_mode,

319: ddp_list_rule_rec.list_rule_type := p1_a13;
320:
321:
322: -- here's the delegated call to the old PL/SQL routine
323: ams_list_rules_all_pvt.check_req_items(p_validation_mode,
324: ddp_list_rule_rec,
325: x_return_status);
326:
327: -- copy data back from the local OUT or IN-OUT args, if any

Line 350: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

346: , p1_a12 NUMBER := 0-1962.0724
347: , p1_a13 VARCHAR := fnd_api.g_miss_char
348: )
349: as
350: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
351: ddindx binary_integer; indx binary_integer;
352: begin
353:
354: -- copy data to the local IN or IN-OUT args, if any

Line 373: ams_list_rules_all_pvt.check_uk_items(p_validation_mode,

369: ddp_list_rule_rec.list_rule_type := p1_a13;
370:
371:
372: -- here's the delegated call to the old PL/SQL routine
373: ams_list_rules_all_pvt.check_uk_items(p_validation_mode,
374: ddp_list_rule_rec,
375: x_return_status);
376:
377: -- copy data back from the local OUT or IN-OUT args, if any

Line 399: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

395: , p0_a12 NUMBER := 0-1962.0724
396: , p0_a13 VARCHAR := fnd_api.g_miss_char
397: )
398: as
399: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
400: ddindx binary_integer; indx binary_integer;
401: begin
402:
403: -- copy data to the local IN or IN-OUT args, if any

Line 421: ams_list_rules_all_pvt.check_lookup_items(ddp_list_rule_rec,

417: ddp_list_rule_rec.list_rule_type := p0_a13;
418:
419:
420: -- here's the delegated call to the old PL/SQL routine
421: ams_list_rules_all_pvt.check_lookup_items(ddp_list_rule_rec,
422: x_return_status);
423:
424: -- copy data back from the local OUT or IN-OUT args, if any
425:

Line 459: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

455: , p1_a12 NUMBER := 0-1962.0724
456: , p1_a13 VARCHAR := fnd_api.g_miss_char
457: )
458: as
459: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
460: ddp_complete_rec ams_list_rules_all_pvt.list_rule_rec_type;
461: ddindx binary_integer; indx binary_integer;
462: begin
463:

Line 460: ddp_complete_rec ams_list_rules_all_pvt.list_rule_rec_type;

456: , p1_a13 VARCHAR := fnd_api.g_miss_char
457: )
458: as
459: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
460: ddp_complete_rec ams_list_rules_all_pvt.list_rule_rec_type;
461: ddindx binary_integer; indx binary_integer;
462: begin
463:
464: -- copy data to the local IN or IN-OUT args, if any

Line 497: ams_list_rules_all_pvt.check_record(ddp_list_rule_rec,

493: ddp_complete_rec.list_rule_type := p1_a13;
494:
495:
496: -- here's the delegated call to the old PL/SQL routine
497: ams_list_rules_all_pvt.check_record(ddp_list_rule_rec,
498: ddp_complete_rec,
499: x_return_status);
500:
501: -- copy data back from the local OUT or IN-OUT args, if any

Line 536: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

532: , p0_a12 NUMBER := 0-1962.0724
533: , p0_a13 VARCHAR := fnd_api.g_miss_char
534: )
535: as
536: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
537: ddx_complete_rec ams_list_rules_all_pvt.list_rule_rec_type;
538: ddindx binary_integer; indx binary_integer;
539: begin
540:

Line 537: ddx_complete_rec ams_list_rules_all_pvt.list_rule_rec_type;

533: , p0_a13 VARCHAR := fnd_api.g_miss_char
534: )
535: as
536: ddp_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
537: ddx_complete_rec ams_list_rules_all_pvt.list_rule_rec_type;
538: ddindx binary_integer; indx binary_integer;
539: begin
540:
541: -- copy data to the local IN or IN-OUT args, if any

Line 559: ams_list_rules_all_pvt.complete_rec(ddp_list_rule_rec,

555: ddp_list_rule_rec.list_rule_type := p0_a13;
556:
557:
558: -- here's the delegated call to the old PL/SQL routine
559: ams_list_rules_all_pvt.complete_rec(ddp_list_rule_rec,
560: ddx_complete_rec);
561:
562: -- copy data back from the local OUT or IN-OUT args, if any
563:

Line 596: ddx_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;

592: , p0_a12 OUT NOCOPY NUMBER
593: , p0_a13 OUT NOCOPY VARCHAR
594: )
595: as
596: ddx_list_rule_rec ams_list_rules_all_pvt.list_rule_rec_type;
597: ddindx binary_integer; indx binary_integer;
598: begin
599:
600: -- copy data to the local IN or IN-OUT args, if any

Line 603: ams_list_rules_all_pvt.init_rec(ddx_list_rule_rec);

599:
600: -- copy data to the local IN or IN-OUT args, if any
601:
602: -- here's the delegated call to the old PL/SQL routine
603: ams_list_rules_all_pvt.init_rec(ddx_list_rule_rec);
604:
605: -- copy data back from the local OUT or IN-OUT args, if any
606: p0_a0 := rosetta_g_miss_num_map(ddx_list_rule_rec.list_rule_id);
607: p0_a1 := ddx_list_rule_rec.last_update_date;

Line 622: end ams_list_rules_all_pvt_w;

618: p0_a12 := rosetta_g_miss_num_map(ddx_list_rule_rec.org_id);
619: p0_a13 := ddx_list_rule_rec.list_rule_type;
620: end;
621:
622: end ams_list_rules_all_pvt_w;