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.

[Home] [Help]

APPS.PA_DEDUCTIONS_W dependencies on PA_DEDUCTIONS

Line 1: package body pa_deductions_w as

1: package body pa_deductions_w as
2: /* $Header: PADCTNRB.pls 120.0.12010000.1 2009/07/21 10:59:25 sosharma noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy pa_deductions.g_dctn_hdrid, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy pa_deductions.g_dctn_hdrid, a0 JTF_NUMBER_TABLE) as

1: package body pa_deductions_w as
2: /* $Header: PADCTNRB.pls 120.0.12010000.1 2009/07/21 10:59:25 sosharma noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy pa_deductions.g_dctn_hdrid, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then

Line 21: procedure rosetta_table_copy_out_p0(t pa_deductions.g_dctn_hdrid, a0 out nocopy JTF_NUMBER_TABLE) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p0;
21: procedure rosetta_table_copy_out_p0(t pa_deductions.g_dctn_hdrid, a0 out nocopy JTF_NUMBER_TABLE) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();

Line 44: procedure rosetta_table_copy_in_p1(t out nocopy pa_deductions.g_dctn_txnid, a0 JTF_NUMBER_TABLE) as

40: end if;
41: end if;
42: end rosetta_table_copy_out_p0;
43:
44: procedure rosetta_table_copy_in_p1(t out nocopy pa_deductions.g_dctn_txnid, a0 JTF_NUMBER_TABLE) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if a0 is not null and a0.count > 0 then
48: if a0.count > 0 then

Line 62: procedure rosetta_table_copy_out_p1(t pa_deductions.g_dctn_txnid, a0 out nocopy JTF_NUMBER_TABLE) as

58: end loop;
59: end if;
60: end if;
61: end rosetta_table_copy_in_p1;
62: procedure rosetta_table_copy_out_p1(t pa_deductions.g_dctn_txnid, a0 out nocopy JTF_NUMBER_TABLE) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_NUMBER_TABLE();

Line 85: procedure rosetta_table_copy_in_p4(t out nocopy pa_deductions.g_dctn_hdrtbl, a0 JTF_NUMBER_TABLE

81: end if;
82: end if;
83: end rosetta_table_copy_out_p1;
84:
85: procedure rosetta_table_copy_in_p4(t out nocopy pa_deductions.g_dctn_hdrtbl, a0 JTF_NUMBER_TABLE
86: , a1 JTF_NUMBER_TABLE
87: , a2 JTF_NUMBER_TABLE
88: , a3 JTF_NUMBER_TABLE
89: , a4 JTF_VARCHAR2_TABLE_100

Line 144: procedure rosetta_table_copy_out_p4(t pa_deductions.g_dctn_hdrtbl, a0 out nocopy JTF_NUMBER_TABLE

140: end loop;
141: end if;
142: end if;
143: end rosetta_table_copy_in_p4;
144: procedure rosetta_table_copy_out_p4(t pa_deductions.g_dctn_hdrtbl, a0 out nocopy JTF_NUMBER_TABLE
145: , a1 out nocopy JTF_NUMBER_TABLE
146: , a2 out nocopy JTF_NUMBER_TABLE
147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 268: procedure rosetta_table_copy_in_p5(t out nocopy pa_deductions.g_dctn_txntbl, a0 JTF_NUMBER_TABLE

264: end if;
265: end if;
266: end rosetta_table_copy_out_p4;
267:
268: procedure rosetta_table_copy_in_p5(t out nocopy pa_deductions.g_dctn_txntbl, a0 JTF_NUMBER_TABLE
269: , a1 JTF_NUMBER_TABLE
270: , a2 JTF_NUMBER_TABLE
271: , a3 JTF_NUMBER_TABLE
272: , a4 JTF_VARCHAR2_TABLE_100

Line 325: procedure rosetta_table_copy_out_p5(t pa_deductions.g_dctn_txntbl, a0 out nocopy JTF_NUMBER_TABLE

321: end loop;
322: end if;
323: end if;
324: end rosetta_table_copy_in_p5;
325: procedure rosetta_table_copy_out_p5(t pa_deductions.g_dctn_txntbl, a0 out nocopy JTF_NUMBER_TABLE
326: , a1 out nocopy JTF_NUMBER_TABLE
327: , a2 out nocopy JTF_NUMBER_TABLE
328: , a3 out nocopy JTF_NUMBER_TABLE
329: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 472: ddp_dctn_hdr pa_deductions.g_dctn_hdrtbl;

468: , p_calling_mode VARCHAR2
469: )
470:
471: as
472: ddp_dctn_hdr pa_deductions.g_dctn_hdrtbl;
473: ddindx binary_integer; indx binary_integer;
474: begin
475:
476: -- copy data to the local IN or IN-OUT args, if any

Line 477: pa_deductions_w.rosetta_table_copy_in_p4(ddp_dctn_hdr, p0_a0

473: ddindx binary_integer; indx binary_integer;
474: begin
475:
476: -- copy data to the local IN or IN-OUT args, if any
477: pa_deductions_w.rosetta_table_copy_in_p4(ddp_dctn_hdr, p0_a0
478: , p0_a1
479: , p0_a2
480: , p0_a3
481: , p0_a4

Line 505: pa_deductions.create_deduction_hdr(ddp_dctn_hdr,

501:
502:
503:
504: -- here's the delegated call to the old PL/SQL routine
505: pa_deductions.create_deduction_hdr(ddp_dctn_hdr,
506: p_msg_count,
507: p_msg_data,
508: p_return_status,
509: p_calling_mode);

Line 512: pa_deductions_w.rosetta_table_copy_out_p4(ddp_dctn_hdr, p0_a0

508: p_return_status,
509: p_calling_mode);
510:
511: -- copy data back from the local variables to OUT or IN-OUT args, if any
512: pa_deductions_w.rosetta_table_copy_out_p4(ddp_dctn_hdr, p0_a0
513: , p0_a1
514: , p0_a2
515: , p0_a3
516: , p0_a4

Line 567: ddp_dctn_dtl pa_deductions.g_dctn_txntbl;

563: , p_calling_mode VARCHAR2
564: )
565:
566: as
567: ddp_dctn_dtl pa_deductions.g_dctn_txntbl;
568: ddindx binary_integer; indx binary_integer;
569: begin
570:
571: -- copy data to the local IN or IN-OUT args, if any

Line 572: pa_deductions_w.rosetta_table_copy_in_p5(ddp_dctn_dtl, p0_a0

568: ddindx binary_integer; indx binary_integer;
569: begin
570:
571: -- copy data to the local IN or IN-OUT args, if any
572: pa_deductions_w.rosetta_table_copy_in_p5(ddp_dctn_dtl, p0_a0
573: , p0_a1
574: , p0_a2
575: , p0_a3
576: , p0_a4

Line 599: pa_deductions.create_deduction_txn(ddp_dctn_dtl,

595:
596:
597:
598: -- here's the delegated call to the old PL/SQL routine
599: pa_deductions.create_deduction_txn(ddp_dctn_dtl,
600: p_msg_count,
601: p_msg_data,
602: p_return_status,
603: p_calling_mode);

Line 606: pa_deductions_w.rosetta_table_copy_out_p5(ddp_dctn_dtl, p0_a0

602: p_return_status,
603: p_calling_mode);
604:
605: -- copy data back from the local variables to OUT or IN-OUT args, if any
606: pa_deductions_w.rosetta_table_copy_out_p5(ddp_dctn_dtl, p0_a0
607: , p0_a1
608: , p0_a2
609: , p0_a3
610: , p0_a4

Line 661: ddp_dctn_hdr pa_deductions.g_dctn_hdrtbl;

657: , p_calling_mode VARCHAR2
658: )
659:
660: as
661: ddp_dctn_hdr pa_deductions.g_dctn_hdrtbl;
662: ddindx binary_integer; indx binary_integer;
663: begin
664:
665: -- copy data to the local IN or IN-OUT args, if any

Line 666: pa_deductions_w.rosetta_table_copy_in_p4(ddp_dctn_hdr, p0_a0

662: ddindx binary_integer; indx binary_integer;
663: begin
664:
665: -- copy data to the local IN or IN-OUT args, if any
666: pa_deductions_w.rosetta_table_copy_in_p4(ddp_dctn_hdr, p0_a0
667: , p0_a1
668: , p0_a2
669: , p0_a3
670: , p0_a4

Line 694: pa_deductions.update_deduction_hdr(ddp_dctn_hdr,

690:
691:
692:
693: -- here's the delegated call to the old PL/SQL routine
694: pa_deductions.update_deduction_hdr(ddp_dctn_hdr,
695: p_msg_count,
696: p_msg_data,
697: p_return_status,
698: p_calling_mode);

Line 701: pa_deductions_w.rosetta_table_copy_out_p4(ddp_dctn_hdr, p0_a0

697: p_return_status,
698: p_calling_mode);
699:
700: -- copy data back from the local variables to OUT or IN-OUT args, if any
701: pa_deductions_w.rosetta_table_copy_out_p4(ddp_dctn_hdr, p0_a0
702: , p0_a1
703: , p0_a2
704: , p0_a3
705: , p0_a4

Line 756: ddp_dctn_dtl pa_deductions.g_dctn_txntbl;

752: , p_calling_mode VARCHAR2
753: )
754:
755: as
756: ddp_dctn_dtl pa_deductions.g_dctn_txntbl;
757: ddindx binary_integer; indx binary_integer;
758: begin
759:
760: -- copy data to the local IN or IN-OUT args, if any

Line 761: pa_deductions_w.rosetta_table_copy_in_p5(ddp_dctn_dtl, p0_a0

757: ddindx binary_integer; indx binary_integer;
758: begin
759:
760: -- copy data to the local IN or IN-OUT args, if any
761: pa_deductions_w.rosetta_table_copy_in_p5(ddp_dctn_dtl, p0_a0
762: , p0_a1
763: , p0_a2
764: , p0_a3
765: , p0_a4

Line 788: pa_deductions.update_deduction_txn(ddp_dctn_dtl,

784:
785:
786:
787: -- here's the delegated call to the old PL/SQL routine
788: pa_deductions.update_deduction_txn(ddp_dctn_dtl,
789: p_msg_count,
790: p_msg_data,
791: p_return_status,
792: p_calling_mode);

Line 795: pa_deductions_w.rosetta_table_copy_out_p5(ddp_dctn_dtl, p0_a0

791: p_return_status,
792: p_calling_mode);
793:
794: -- copy data back from the local variables to OUT or IN-OUT args, if any
795: pa_deductions_w.rosetta_table_copy_out_p5(ddp_dctn_dtl, p0_a0
796: , p0_a1
797: , p0_a2
798: , p0_a3
799: , p0_a4

Line 829: ddp_dctn_hdrid pa_deductions.g_dctn_hdrid;

825: , p_return_status out nocopy VARCHAR2
826: )
827:
828: as
829: ddp_dctn_hdrid pa_deductions.g_dctn_hdrid;
830: ddindx binary_integer; indx binary_integer;
831: begin
832:
833: -- copy data to the local IN or IN-OUT args, if any

Line 834: pa_deductions_w.rosetta_table_copy_in_p0(ddp_dctn_hdrid, p_dctn_hdrid);

830: ddindx binary_integer; indx binary_integer;
831: begin
832:
833: -- copy data to the local IN or IN-OUT args, if any
834: pa_deductions_w.rosetta_table_copy_in_p0(ddp_dctn_hdrid, p_dctn_hdrid);
835:
836:
837:
838:

Line 840: pa_deductions.delete_deduction_hdr(ddp_dctn_hdrid,

836:
837:
838:
839: -- here's the delegated call to the old PL/SQL routine
840: pa_deductions.delete_deduction_hdr(ddp_dctn_hdrid,
841: p_msg_count,
842: p_msg_data,
843: p_return_status);
844:

Line 858: ddp_dctn_txnid pa_deductions.g_dctn_txnid;

854: , p_return_status out nocopy VARCHAR2
855: )
856:
857: as
858: ddp_dctn_txnid pa_deductions.g_dctn_txnid;
859: ddindx binary_integer; indx binary_integer;
860: begin
861:
862: -- copy data to the local IN or IN-OUT args, if any

Line 863: pa_deductions_w.rosetta_table_copy_in_p1(ddp_dctn_txnid, p_dctn_txnid);

859: ddindx binary_integer; indx binary_integer;
860: begin
861:
862: -- copy data to the local IN or IN-OUT args, if any
863: pa_deductions_w.rosetta_table_copy_in_p1(ddp_dctn_txnid, p_dctn_txnid);
864:
865:
866:
867:

Line 869: pa_deductions.delete_deduction_txn(ddp_dctn_txnid,

865:
866:
867:
868: -- here's the delegated call to the old PL/SQL routine
869: pa_deductions.delete_deduction_txn(ddp_dctn_txnid,
870: p_msg_count,
871: p_msg_data,
872: p_return_status);
873:

Line 909: ddp_dctn_hdr pa_deductions.g_dctn_hdrtbl;

905: , ddrosetta_retval_bool OUT NOCOPY NUMBER
906: )
907:
908: as
909: ddp_dctn_hdr pa_deductions.g_dctn_hdrtbl;
910: ddindx binary_integer; indx binary_integer;
911: ddrosetta_retval boolean;
912: begin
913:

Line 915: pa_deductions_w.rosetta_table_copy_in_p4(ddp_dctn_hdr, p0_a0

911: ddrosetta_retval boolean;
912: begin
913:
914: -- copy data to the local IN or IN-OUT args, if any
915: pa_deductions_w.rosetta_table_copy_in_p4(ddp_dctn_hdr, p0_a0
916: , p0_a1
917: , p0_a2
918: , p0_a3
919: , p0_a4

Line 943: ddrosetta_retval := pa_deductions.validate_deduction_hdr(ddp_dctn_hdr,

939:
940:
941:
942: -- here's the delegated call to the old PL/SQL routine
943: ddrosetta_retval := pa_deductions.validate_deduction_hdr(ddp_dctn_hdr,
944: p_msg_count,
945: p_msg_data,
946: p_return_status,
947: p_calling_mode);

Line 956: pa_deductions_w.rosetta_table_copy_out_p4(ddp_dctn_hdr, p0_a0

952: elsif ddrosetta_retval
953: then ddrosetta_retval_bool := 1;
954: else ddrosetta_retval_bool := 0;
955: end if;
956: pa_deductions_w.rosetta_table_copy_out_p4(ddp_dctn_hdr, p0_a0
957: , p0_a1
958: , p0_a2
959: , p0_a3
960: , p0_a4

Line 1012: ddp_dctn_dtl pa_deductions.g_dctn_txntbl;

1008: , ddrosetta_retval_bool OUT NOCOPY NUMBER
1009: )
1010:
1011: as
1012: ddp_dctn_dtl pa_deductions.g_dctn_txntbl;
1013: ddindx binary_integer; indx binary_integer;
1014: ddrosetta_retval boolean;
1015: begin
1016:

Line 1018: pa_deductions_w.rosetta_table_copy_in_p5(ddp_dctn_dtl, p0_a0

1014: ddrosetta_retval boolean;
1015: begin
1016:
1017: -- copy data to the local IN or IN-OUT args, if any
1018: pa_deductions_w.rosetta_table_copy_in_p5(ddp_dctn_dtl, p0_a0
1019: , p0_a1
1020: , p0_a2
1021: , p0_a3
1022: , p0_a4

Line 1045: ddrosetta_retval := pa_deductions.validate_deduction_txn(ddp_dctn_dtl,

1041:
1042:
1043:
1044: -- here's the delegated call to the old PL/SQL routine
1045: ddrosetta_retval := pa_deductions.validate_deduction_txn(ddp_dctn_dtl,
1046: p_msg_count,
1047: p_msg_data,
1048: p_return_status,
1049: p_calling_mode);

Line 1058: pa_deductions_w.rosetta_table_copy_out_p5(ddp_dctn_dtl, p0_a0

1054: elsif ddrosetta_retval
1055: then ddrosetta_retval_bool := 1;
1056: else ddrosetta_retval_bool := 0;
1057: end if;
1058: pa_deductions_w.rosetta_table_copy_out_p5(ddp_dctn_dtl, p0_a0
1059: , p0_a1
1060: , p0_a2
1061: , p0_a3
1062: , p0_a4

Line 1085: end pa_deductions_w;

1081:
1082:
1083: end;
1084:
1085: end pa_deductions_w;