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.OKL_RULE_EXTRACT_PVT_W dependencies on OKL_RULE_EXTRACT_PVT

Line 1: package body okl_rule_extract_pvt_w as

1: package body okl_rule_extract_pvt_w as
2: /* $Header: OKLEREXB.pls 115.8 2003/10/14 18:52:29 ashariff 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_p22(t out nocopy okl_rule_extract_pvt.rule_tbl_type, a0 JTF_VARCHAR2_TABLE_100

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p22(t out nocopy okl_rule_extract_pvt.rule_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;

Line 45: procedure rosetta_table_copy_out_p22(t okl_rule_extract_pvt.rule_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

41: end loop;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p22;
45: procedure rosetta_table_copy_out_p22(t okl_rule_extract_pvt.rule_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
46: , a1 out nocopy JTF_VARCHAR2_TABLE_100
47: , a2 out nocopy JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;

Line 79: procedure rosetta_table_copy_in_p24(t out nocopy okl_rule_extract_pvt.sc_rg_tbl_type, a0 JTF_VARCHAR2_TABLE_100

75: end if;
76: end if;
77: end rosetta_table_copy_out_p22;
78:
79: procedure rosetta_table_copy_in_p24(t out nocopy okl_rule_extract_pvt.sc_rg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_VARCHAR2_TABLE_300
83: ) as

Line 104: procedure rosetta_table_copy_out_p24(t okl_rule_extract_pvt.sc_rg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

100: end loop;
101: end if;
102: end if;
103: end rosetta_table_copy_in_p24;
104: procedure rosetta_table_copy_out_p24(t okl_rule_extract_pvt.sc_rg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
105: , a1 out nocopy JTF_VARCHAR2_TABLE_100
106: , a2 out nocopy JTF_VARCHAR2_TABLE_100
107: , a3 out nocopy JTF_VARCHAR2_TABLE_300
108: ) as

Line 143: procedure rosetta_table_copy_in_p26(t out nocopy okl_rule_extract_pvt.rg_rules_tbl_type, a0 JTF_VARCHAR2_TABLE_100

139: end if;
140: end if;
141: end rosetta_table_copy_out_p24;
142:
143: procedure rosetta_table_copy_in_p26(t out nocopy okl_rule_extract_pvt.rg_rules_tbl_type, a0 JTF_VARCHAR2_TABLE_100
144: , a1 JTF_VARCHAR2_TABLE_100
145: , a2 JTF_VARCHAR2_TABLE_100
146: , a3 JTF_VARCHAR2_TABLE_100
147: , a4 JTF_VARCHAR2_TABLE_100

Line 174: procedure rosetta_table_copy_out_p26(t okl_rule_extract_pvt.rg_rules_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

170: end loop;
171: end if;
172: end if;
173: end rosetta_table_copy_in_p26;
174: procedure rosetta_table_copy_out_p26(t okl_rule_extract_pvt.rg_rules_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
175: , a1 out nocopy JTF_VARCHAR2_TABLE_100
176: , a2 out nocopy JTF_VARCHAR2_TABLE_100
177: , a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 228: procedure rosetta_table_copy_in_p28(t out nocopy okl_rule_extract_pvt.rule_segment_tbl_type, a0 JTF_VARCHAR2_TABLE_100

224: end if;
225: end if;
226: end rosetta_table_copy_out_p26;
227:
228: procedure rosetta_table_copy_in_p28(t out nocopy okl_rule_extract_pvt.rule_segment_tbl_type, a0 JTF_VARCHAR2_TABLE_100
229: , a1 JTF_VARCHAR2_TABLE_100
230: , a2 JTF_VARCHAR2_TABLE_100
231: , a3 JTF_VARCHAR2_TABLE_100
232: , a4 JTF_VARCHAR2_TABLE_100

Line 291: procedure rosetta_table_copy_out_p28(t okl_rule_extract_pvt.rule_segment_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

287: end loop;
288: end if;
289: end if;
290: end rosetta_table_copy_in_p28;
291: procedure rosetta_table_copy_out_p28(t okl_rule_extract_pvt.rule_segment_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 425: procedure rosetta_table_copy_in_p30(t out nocopy okl_rule_extract_pvt.rule_segment_tbl_type2, a0 JTF_VARCHAR2_TABLE_100

421: end if;
422: end if;
423: end rosetta_table_copy_out_p28;
424:
425: procedure rosetta_table_copy_in_p30(t out nocopy okl_rule_extract_pvt.rule_segment_tbl_type2, a0 JTF_VARCHAR2_TABLE_100
426: , a1 JTF_VARCHAR2_TABLE_100
427: , a2 JTF_VARCHAR2_TABLE_100
428: , a3 JTF_VARCHAR2_TABLE_100
429: , a4 JTF_VARCHAR2_TABLE_100

Line 498: procedure rosetta_table_copy_out_p30(t okl_rule_extract_pvt.rule_segment_tbl_type2, a0 out nocopy JTF_VARCHAR2_TABLE_100

494: end loop;
495: end if;
496: end if;
497: end rosetta_table_copy_in_p30;
498: procedure rosetta_table_copy_out_p30(t okl_rule_extract_pvt.rule_segment_tbl_type2, a0 out nocopy JTF_VARCHAR2_TABLE_100
499: , a1 out nocopy JTF_VARCHAR2_TABLE_100
500: , a2 out nocopy JTF_VARCHAR2_TABLE_100
501: , a3 out nocopy JTF_VARCHAR2_TABLE_100
502: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 670: ddx_sc_rg_tbl okl_rule_extract_pvt.sc_rg_tbl_type;

666: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
667: )
668:
669: as
670: ddx_sc_rg_tbl okl_rule_extract_pvt.sc_rg_tbl_type;
671: ddindx binary_integer; indx binary_integer;
672: begin
673:
674: -- copy data to the local IN or IN-OUT args, if any

Line 683: okl_rule_extract_pvt.get_subclass_rgs(p_api_version,

679:
680:
681:
682: -- here's the delegated call to the old PL/SQL routine
683: okl_rule_extract_pvt.get_subclass_rgs(p_api_version,
684: p_init_msg_list,
685: x_return_status,
686: x_msg_count,
687: x_msg_data,

Line 698: okl_rule_extract_pvt_w.rosetta_table_copy_out_p24(ddx_sc_rg_tbl, p6_a0

694:
695:
696:
697:
698: okl_rule_extract_pvt_w.rosetta_table_copy_out_p24(ddx_sc_rg_tbl, p6_a0
699: , p6_a1
700: , p6_a2
701: , p6_a3
702: );

Line 721: ddx_rg_rules_tbl okl_rule_extract_pvt.rg_rules_tbl_type;

717: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
718: )
719:
720: as
721: ddx_rg_rules_tbl okl_rule_extract_pvt.rg_rules_tbl_type;
722: ddindx binary_integer; indx binary_integer;
723: begin
724:
725: -- copy data to the local IN or IN-OUT args, if any

Line 734: okl_rule_extract_pvt.get_rg_rules(p_api_version,

730:
731:
732:
733: -- here's the delegated call to the old PL/SQL routine
734: okl_rule_extract_pvt.get_rg_rules(p_api_version,
735: p_init_msg_list,
736: x_return_status,
737: x_msg_count,
738: x_msg_data,

Line 749: okl_rule_extract_pvt_w.rosetta_table_copy_out_p26(ddx_rg_rules_tbl, p6_a0

745:
746:
747:
748:
749: okl_rule_extract_pvt_w.rosetta_table_copy_out_p26(ddx_rg_rules_tbl, p6_a0
750: , p6_a1
751: , p6_a2
752: , p6_a3
753: , p6_a4

Line 793: ddx_rule_segment_tbl okl_rule_extract_pvt.rule_segment_tbl_type;

789: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_300
790: )
791:
792: as
793: ddx_rule_segment_tbl okl_rule_extract_pvt.rule_segment_tbl_type;
794: ddindx binary_integer; indx binary_integer;
795: begin
796:
797: -- copy data to the local IN or IN-OUT args, if any

Line 808: okl_rule_extract_pvt.get_rule_def(p_api_version,

804:
805:
806:
807: -- here's the delegated call to the old PL/SQL routine
808: okl_rule_extract_pvt.get_rule_def(p_api_version,
809: p_init_msg_list,
810: x_return_status,
811: x_msg_count,
812: x_msg_data,

Line 827: okl_rule_extract_pvt_w.rosetta_table_copy_out_p28(ddx_rule_segment_tbl, p8_a0

823:
824:
825:
826:
827: okl_rule_extract_pvt_w.rosetta_table_copy_out_p28(ddx_rule_segment_tbl, p8_a0
828: , p8_a1
829: , p8_a2
830: , p8_a3
831: , p8_a4

Line 898: ddx_rule_segment_tbl okl_rule_extract_pvt.rule_segment_tbl_type2;

894: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
895: )
896:
897: as
898: ddx_rule_segment_tbl okl_rule_extract_pvt.rule_segment_tbl_type2;
899: ddindx binary_integer; indx binary_integer;
900: begin
901:
902: -- copy data to the local IN or IN-OUT args, if any

Line 919: okl_rule_extract_pvt.get_rules_metadata(p_api_version,

915:
916:
917:
918: -- here's the delegated call to the old PL/SQL routine
919: okl_rule_extract_pvt.get_rules_metadata(p_api_version,
920: p_init_msg_list,
921: x_return_status,
922: x_msg_count,
923: x_msg_data,

Line 950: okl_rule_extract_pvt_w.rosetta_table_copy_out_p30(ddx_rule_segment_tbl, p14_a0

946:
947:
948:
949:
950: okl_rule_extract_pvt_w.rosetta_table_copy_out_p30(ddx_rule_segment_tbl, p14_a0
951: , p14_a1
952: , p14_a2
953: , p14_a3
954: , p14_a4

Line 981: end okl_rule_extract_pvt_w;

977: , p14_a27
978: );
979: end;
980:
981: end okl_rule_extract_pvt_w;