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.IEX_STATUS_RULE_PUB_W dependencies on IEX_STATUS_RULE_PUB

Line 1: package body iex_status_rule_pub_w as

1: package body iex_status_rule_pub_w as
2: /* $Header: iexwcstb.pls 120.1 2005/07/06 14:10:34 schekuri 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 22: procedure rosetta_table_copy_in_p1(t out nocopy iex_status_rule_pub.status_rule_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy iex_status_rule_pub.status_rule_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_DATE_TABLE

Line 65: procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

61: end loop;
62: end if;
63: end if;
64: end rosetta_table_copy_in_p1;
65: procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
66: , a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , a2 out nocopy JTF_VARCHAR2_TABLE_200
68: , a3 out nocopy JTF_DATE_TABLE
69: , a4 out nocopy JTF_DATE_TABLE

Line 149: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE

145: end if;
146: end if;
147: end rosetta_table_copy_out_p1;
148:
149: procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
150: , a1 JTF_VARCHAR2_TABLE_100
151: , a2 JTF_NUMBER_TABLE
152: , a3 JTF_VARCHAR2_TABLE_100
153: , a4 JTF_NUMBER_TABLE

Line 192: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

188: end loop;
189: end if;
190: end if;
191: end rosetta_table_copy_in_p3;
192: procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
193: , a1 out nocopy JTF_VARCHAR2_TABLE_100
194: , a2 out nocopy JTF_NUMBER_TABLE
195: , a3 out nocopy JTF_VARCHAR2_TABLE_100
196: , a4 out nocopy JTF_NUMBER_TABLE

Line 276: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE) as

272: end if;
273: end if;
274: end rosetta_table_copy_out_p3;
275:
276: procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE) as
277: ddindx binary_integer; indx binary_integer;
278: begin
279: if a0 is not null and a0.count > 0 then
280: if a0.count > 0 then

Line 294: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

290: end loop;
291: end if;
292: end if;
293: end rosetta_table_copy_in_p4;
294: procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
295: ddindx binary_integer; indx binary_integer;
296: begin
297: if t is null or t.count = 0 then
298: a0 := JTF_NUMBER_TABLE();

Line 317: procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE) as

313: end if;
314: end if;
315: end rosetta_table_copy_out_p4;
316:
317: procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE) as
318: ddindx binary_integer; indx binary_integer;
319: begin
320: if a0 is not null and a0.count > 0 then
321: if a0.count > 0 then

Line 335: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

331: end loop;
332: end if;
333: end if;
334: end rosetta_table_copy_in_p5;
335: procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
336: ddindx binary_integer; indx binary_integer;
337: begin
338: if t is null or t.count = 0 then
339: a0 := JTF_NUMBER_TABLE();

Line 382: ddp_status_rule_rec iex_status_rule_pub.status_rule_rec_type;

378: , p3_a12 NUMBER := 0-1962.0724
379: )
380:
381: as
382: ddp_status_rule_rec iex_status_rule_pub.status_rule_rec_type;
383: ddindx binary_integer; indx binary_integer;
384: begin
385:
386: -- copy data to the local IN or IN-OUT args, if any

Line 410: iex_status_rule_pub.create_status_rule(p_api_version,

406:
407:
408:
409: -- here's the delegated call to the old PL/SQL routine
410: iex_status_rule_pub.create_status_rule(p_api_version,
411: p_init_msg_list,
412: p_commit,
413: ddp_status_rule_rec,
414: x_dup_status,

Line 454: ddp_status_rule_tbl iex_status_rule_pub.status_rule_tbl_type;

450: , x_msg_data out nocopy VARCHAR2
451: )
452:
453: as
454: ddp_status_rule_tbl iex_status_rule_pub.status_rule_tbl_type;
455: ddindx binary_integer; indx binary_integer;
456: begin
457:
458: -- copy data to the local IN or IN-OUT args, if any

Line 462: iex_status_rule_pub_w.rosetta_table_copy_in_p1(ddp_status_rule_tbl, p3_a0

458: -- copy data to the local IN or IN-OUT args, if any
459:
460:
461:
462: iex_status_rule_pub_w.rosetta_table_copy_in_p1(ddp_status_rule_tbl, p3_a0
463: , p3_a1
464: , p3_a2
465: , p3_a3
466: , p3_a4

Line 482: iex_status_rule_pub.update_status_rule(p_api_version,

478:
479:
480:
481: -- here's the delegated call to the old PL/SQL routine
482: iex_status_rule_pub.update_status_rule(p_api_version,
483: p_init_msg_list,
484: p_commit,
485: ddp_status_rule_tbl,
486: x_dup_status,

Line 511: ddp_status_rule_id_tbl iex_status_rule_pub.status_rule_id_tbl_type;

507: , x_msg_data out nocopy VARCHAR2
508: )
509:
510: as
511: ddp_status_rule_id_tbl iex_status_rule_pub.status_rule_id_tbl_type;
512: ddindx binary_integer; indx binary_integer;
513: begin
514:
515: -- copy data to the local IN or IN-OUT args, if any

Line 519: iex_status_rule_pub_w.rosetta_table_copy_in_p4(ddp_status_rule_id_tbl, p_status_rule_id_tbl);

515: -- copy data to the local IN or IN-OUT args, if any
516:
517:
518:
519: iex_status_rule_pub_w.rosetta_table_copy_in_p4(ddp_status_rule_id_tbl, p_status_rule_id_tbl);
520:
521:
522:
523:

Line 525: iex_status_rule_pub.delete_status_rule(p_api_version,

521:
522:
523:
524: -- here's the delegated call to the old PL/SQL routine
525: iex_status_rule_pub.delete_status_rule(p_api_version,
526: p_init_msg_list,
527: p_commit,
528: ddp_status_rule_id_tbl,
529: x_return_status,

Line 564: ddp_status_rule_line_rec iex_status_rule_pub.status_rule_line_rec_type;

560: , p3_a12 NUMBER := 0-1962.0724
561: )
562:
563: as
564: ddp_status_rule_line_rec iex_status_rule_pub.status_rule_line_rec_type;
565: ddindx binary_integer; indx binary_integer;
566: begin
567:
568: -- copy data to the local IN or IN-OUT args, if any

Line 590: iex_status_rule_pub.create_status_rule_line(p_api_version,

586:
587:
588:
589: -- here's the delegated call to the old PL/SQL routine
590: iex_status_rule_pub.create_status_rule_line(p_api_version,
591: p_init_msg_list,
592: p_commit,
593: ddp_status_rule_line_rec,
594: x_return_status,

Line 630: ddp_status_rule_line_tbl iex_status_rule_pub.status_rule_line_tbl_type;

626: , x_msg_data out nocopy VARCHAR2
627: )
628:
629: as
630: ddp_status_rule_line_tbl iex_status_rule_pub.status_rule_line_tbl_type;
631: ddindx binary_integer; indx binary_integer;
632: begin
633:
634: -- copy data to the local IN or IN-OUT args, if any

Line 638: iex_status_rule_pub_w.rosetta_table_copy_in_p3(ddp_status_rule_line_tbl, p3_a0

634: -- copy data to the local IN or IN-OUT args, if any
635:
636:
637:
638: iex_status_rule_pub_w.rosetta_table_copy_in_p3(ddp_status_rule_line_tbl, p3_a0
639: , p3_a1
640: , p3_a2
641: , p3_a3
642: , p3_a4

Line 658: iex_status_rule_pub.update_status_rule_line(p_api_version,

654:
655:
656:
657: -- here's the delegated call to the old PL/SQL routine
658: iex_status_rule_pub.update_status_rule_line(p_api_version,
659: p_init_msg_list,
660: p_commit,
661: ddp_status_rule_line_tbl,
662: x_dup_status,

Line 688: ddp_status_rule_line_id_tbl iex_status_rule_pub.status_rule_line_id_tbl_type;

684: , x_msg_data out nocopy VARCHAR2
685: )
686:
687: as
688: ddp_status_rule_line_id_tbl iex_status_rule_pub.status_rule_line_id_tbl_type;
689: ddindx binary_integer; indx binary_integer;
690: begin
691:
692: -- copy data to the local IN or IN-OUT args, if any

Line 697: iex_status_rule_pub_w.rosetta_table_copy_in_p5(ddp_status_rule_line_id_tbl, p_status_rule_line_id_tbl);

693:
694:
695:
696:
697: iex_status_rule_pub_w.rosetta_table_copy_in_p5(ddp_status_rule_line_id_tbl, p_status_rule_line_id_tbl);
698:
699:
700:
701:

Line 703: iex_status_rule_pub.delete_status_rule_line(p_api_version,

699:
700:
701:
702: -- here's the delegated call to the old PL/SQL routine
703: iex_status_rule_pub.delete_status_rule_line(p_api_version,
704: p_init_msg_list,
705: p_commit,
706: p_status_rule_id,
707: ddp_status_rule_line_id_tbl,

Line 722: end iex_status_rule_pub_w;

718:
719:
720: end;
721:
722: end iex_status_rule_pub_w;