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_EC_UPTAKE_PVT_W dependencies on OKL_EC_UPTAKE_PVT

Line 1: package body okl_ec_uptake_pvt_w as

1: package body okl_ec_uptake_pvt_w as
2: /* $Header: OKLEECXB.pls 120.7 2006/03/08 11:34:39 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin

Line 3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE) as

1: package body okl_ec_uptake_pvt_w as
2: /* $Header: OKLEECXB.pls 120.7 2006/03/08 11:34:39 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, 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_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p18;
21: procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, 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_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300) as

40: end if;
41: end if;
42: end rosetta_table_copy_out_p18;
43:
44: procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300) 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_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300) as

58: end loop;
59: end if;
60: end if;
61: end rosetta_table_copy_in_p19;
62: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_VARCHAR2_TABLE_300();

Line 85: procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE) as

81: end if;
82: end if;
83: end rosetta_table_copy_out_p19;
84:
85: procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE) as
86: ddindx binary_integer; indx binary_integer;
87: begin
88: if a0 is not null and a0.count > 0 then
89: if a0.count > 0 then

Line 103: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE) as

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p20;
103: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_DATE_TABLE();

Line 126: procedure rosetta_table_copy_in_p22(t out nocopy okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 JTF_VARCHAR2_TABLE_300

122: end if;
123: end if;
124: end rosetta_table_copy_out_p20;
125:
126: procedure rosetta_table_copy_in_p22(t out nocopy okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 JTF_VARCHAR2_TABLE_300
127: , a1 JTF_VARCHAR2_TABLE_100
128: ) as
129: ddindx binary_integer; indx binary_integer;
130: begin

Line 147: procedure rosetta_table_copy_out_p22(t okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

143: end loop;
144: end if;
145: end if;
146: end rosetta_table_copy_in_p22;
147: procedure rosetta_table_copy_out_p22(t okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
148: , a1 out nocopy JTF_VARCHAR2_TABLE_100
149: ) as
150: ddindx binary_integer; indx binary_integer;
151: begin

Line 176: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE

172: end if;
173: end if;
174: end rosetta_table_copy_out_p22;
175:
176: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE
177: , a1 JTF_NUMBER_TABLE
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_VARCHAR2_TABLE_200
180: , a4 JTF_VARCHAR2_TABLE_2000

Line 215: procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

211: end loop;
212: end if;
213: end if;
214: end rosetta_table_copy_in_p24;
215: procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
216: , a1 out nocopy JTF_NUMBER_TABLE
217: , a2 out nocopy JTF_NUMBER_TABLE
218: , a3 out nocopy JTF_VARCHAR2_TABLE_200
219: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 289: procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE

285: end if;
286: end if;
287: end rosetta_table_copy_out_p24;
288:
289: procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE
290: , a1 JTF_NUMBER_TABLE
291: , a2 JTF_NUMBER_TABLE
292: , a3 JTF_VARCHAR2_TABLE_300
293: , a4 JTF_VARCHAR2_TABLE_2000

Line 330: procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

326: end loop;
327: end if;
328: end if;
329: end rosetta_table_copy_in_p26;
330: procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
331: , a1 out nocopy JTF_NUMBER_TABLE
332: , a2 out nocopy JTF_NUMBER_TABLE
333: , a3 out nocopy JTF_VARCHAR2_TABLE_300
334: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 409: procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE

405: end if;
406: end if;
407: end rosetta_table_copy_out_p26;
408:
409: procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE
410: , a1 JTF_VARCHAR2_TABLE_200
411: , a2 JTF_VARCHAR2_TABLE_200
412: , a3 JTF_NUMBER_TABLE
413: , a4 JTF_VARCHAR2_TABLE_2000

Line 442: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

438: end loop;
439: end if;
440: end if;
441: end rosetta_table_copy_in_p28;
442: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
443: , a1 out nocopy JTF_VARCHAR2_TABLE_200
444: , a2 out nocopy JTF_VARCHAR2_TABLE_200
445: , a3 out nocopy JTF_NUMBER_TABLE
446: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 501: procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE

497: end if;
498: end if;
499: end rosetta_table_copy_out_p28;
500:
501: procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE
502: , a1 JTF_VARCHAR2_TABLE_200
503: , a2 JTF_DATE_TABLE
504: , a3 JTF_DATE_TABLE
505: ) as

Line 526: procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

522: end loop;
523: end if;
524: end if;
525: end rosetta_table_copy_in_p30;
526: procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
527: , a1 out nocopy JTF_VARCHAR2_TABLE_200
528: , a2 out nocopy JTF_DATE_TABLE
529: , a3 out nocopy JTF_DATE_TABLE
530: ) as

Line 586: ddx_okl_lrs_table okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type;

582: , x_msg_data out nocopy VARCHAR2
583: )
584:
585: as
586: ddx_okl_lrs_table okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type;
587: ddindx binary_integer; indx binary_integer;
588: begin
589:
590: -- copy data to the local IN or IN-OUT args, if any

Line 600: okl_ec_uptake_pvt.populate_lease_rate_set(p_api_version,

596:
597:
598:
599: -- here's the delegated call to the old PL/SQL routine
600: okl_ec_uptake_pvt.populate_lease_rate_set(p_api_version,
601: p_init_msg_list,
602: p_target_id,
603: p_target_type,
604: ddx_okl_lrs_table,

Line 614: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p24(ddx_okl_lrs_table, p4_a0

610:
611:
612:
613:
614: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p24(ddx_okl_lrs_table, p4_a0
615: , p4_a1
616: , p4_a2
617: , p4_a3
618: , p4_a4

Line 653: ddx_okl_srt_table okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type;

649: , x_msg_data out nocopy VARCHAR2
650: )
651:
652: as
653: ddx_okl_srt_table okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type;
654: ddindx binary_integer; indx binary_integer;
655: begin
656:
657: -- copy data to the local IN or IN-OUT args, if any

Line 667: okl_ec_uptake_pvt.populate_std_rate_tmpl(p_api_version,

663:
664:
665:
666: -- here's the delegated call to the old PL/SQL routine
667: okl_ec_uptake_pvt.populate_std_rate_tmpl(p_api_version,
668: p_init_msg_list,
669: p_target_id,
670: p_target_type,
671: ddx_okl_srt_table,

Line 681: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p26(ddx_okl_srt_table, p4_a0

677:
678:
679:
680:
681: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p26(ddx_okl_srt_table, p4_a0
682: , p4_a1
683: , p4_a2
684: , p4_a3
685: , p4_a4

Line 731: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;

727: , x_msg_data out nocopy VARCHAR2
728: )
729:
730: as
731: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;
732: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;
733: ddx_okl_lrs_table okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type;
734: ddindx binary_integer; indx binary_integer;
735: begin

Line 732: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;

728: )
729:
730: as
731: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;
732: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;
733: ddx_okl_lrs_table okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type;
734: ddindx binary_integer; indx binary_integer;
735: begin
736:

Line 733: ddx_okl_lrs_table okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type;

729:
730: as
731: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;
732: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;
733: ddx_okl_lrs_table okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type;
734: ddindx binary_integer; indx binary_integer;
735: begin
736:
737: -- copy data to the local IN or IN-OUT args, if any

Line 751: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_table, p_item_table);

747:
748:
749:
750:
751: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_table, p_item_table);
752:
753: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_categories_table, p_item_categories_table);
754:
755:

Line 753: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_categories_table, p_item_categories_table);

749:
750:
751: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_table, p_item_table);
752:
753: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_categories_table, p_item_categories_table);
754:
755:
756:
757:

Line 760: okl_ec_uptake_pvt.populate_lease_rate_set(p_api_version,

756:
757:
758:
759: -- here's the delegated call to the old PL/SQL routine
760: okl_ec_uptake_pvt.populate_lease_rate_set(p_api_version,
761: p_init_msg_list,
762: p_target_id,
763: p_target_type,
764: p_target_eff_from,

Line 796: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p24(ddx_okl_lrs_table, p15_a0

792:
793:
794:
795:
796: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p24(ddx_okl_lrs_table, p15_a0
797: , p15_a1
798: , p15_a2
799: , p15_a3
800: , p15_a4

Line 846: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;

842: , x_msg_data out nocopy VARCHAR2
843: )
844:
845: as
846: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;
847: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;
848: ddx_okl_srt_table okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type;
849: ddindx binary_integer; indx binary_integer;
850: begin

Line 847: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;

843: )
844:
845: as
846: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;
847: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;
848: ddx_okl_srt_table okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type;
849: ddindx binary_integer; indx binary_integer;
850: begin
851:

Line 848: ddx_okl_srt_table okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type;

844:
845: as
846: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;
847: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;
848: ddx_okl_srt_table okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type;
849: ddindx binary_integer; indx binary_integer;
850: begin
851:
852: -- copy data to the local IN or IN-OUT args, if any

Line 866: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_table, p_item_table);

862:
863:
864:
865:
866: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_table, p_item_table);
867:
868: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_categories_table, p_item_categories_table);
869:
870:

Line 868: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_categories_table, p_item_categories_table);

864:
865:
866: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_table, p_item_table);
867:
868: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_categories_table, p_item_categories_table);
869:
870:
871:
872:

Line 875: okl_ec_uptake_pvt.populate_std_rate_tmpl(p_api_version,

871:
872:
873:
874: -- here's the delegated call to the old PL/SQL routine
875: okl_ec_uptake_pvt.populate_std_rate_tmpl(p_api_version,
876: p_init_msg_list,
877: p_target_id,
878: p_target_type,
879: p_target_eff_from,

Line 911: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p26(ddx_okl_srt_table, p15_a0

907:
908:
909:
910:
911: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p26(ddx_okl_srt_table, p15_a0
912: , p15_a1
913: , p15_a2
914: , p15_a3
915: , p15_a4

Line 947: ddx_okl_prod_table okl_ec_uptake_pvt.okl_prod_tbl_type;

943: , x_msg_data out nocopy VARCHAR2
944: )
945:
946: as
947: ddx_okl_prod_table okl_ec_uptake_pvt.okl_prod_tbl_type;
948: ddindx binary_integer; indx binary_integer;
949: begin
950:
951: -- copy data to the local IN or IN-OUT args, if any

Line 961: okl_ec_uptake_pvt.populate_product(p_api_version,

957:
958:
959:
960: -- here's the delegated call to the old PL/SQL routine
961: okl_ec_uptake_pvt.populate_product(p_api_version,
962: p_init_msg_list,
963: p_target_id,
964: p_target_type,
965: ddx_okl_prod_table,

Line 975: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p28(ddx_okl_prod_table, p4_a0

971:
972:
973:
974:
975: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p28(ddx_okl_prod_table, p4_a0
976: , p4_a1
977: , p4_a2
978: , p4_a3
979: , p4_a4

Line 1013: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;

1009: , x_msg_data out nocopy VARCHAR2
1010: )
1011:
1012: as
1013: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;
1014: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;
1015: ddx_okl_vp_table okl_ec_uptake_pvt.okl_vp_tbl_type;
1016: ddindx binary_integer; indx binary_integer;
1017: begin

Line 1014: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;

1010: )
1011:
1012: as
1013: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;
1014: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;
1015: ddx_okl_vp_table okl_ec_uptake_pvt.okl_vp_tbl_type;
1016: ddindx binary_integer; indx binary_integer;
1017: begin
1018:

Line 1015: ddx_okl_vp_table okl_ec_uptake_pvt.okl_vp_tbl_type;

1011:
1012: as
1013: ddp_item_table okl_ec_uptake_pvt.okl_number_table_type;
1014: ddp_item_categories_table okl_ec_uptake_pvt.okl_number_table_type;
1015: ddx_okl_vp_table okl_ec_uptake_pvt.okl_vp_tbl_type;
1016: ddindx binary_integer; indx binary_integer;
1017: begin
1018:
1019: -- copy data to the local IN or IN-OUT args, if any

Line 1032: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_table, p_item_table);

1028:
1029:
1030:
1031:
1032: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_table, p_item_table);
1033:
1034: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_categories_table, p_item_categories_table);
1035:
1036:

Line 1034: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_categories_table, p_item_categories_table);

1030:
1031:
1032: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_table, p_item_table);
1033:
1034: okl_ec_uptake_pvt_w.rosetta_table_copy_in_p18(ddp_item_categories_table, p_item_categories_table);
1035:
1036:
1037:
1038:

Line 1041: okl_ec_uptake_pvt.populate_vendor_program(p_api_version,

1037:
1038:
1039:
1040: -- here's the delegated call to the old PL/SQL routine
1041: okl_ec_uptake_pvt.populate_vendor_program(p_api_version,
1042: p_init_msg_list,
1043: p_target_id,
1044: p_target_type,
1045: p_target_eff_from,

Line 1075: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p30(ddx_okl_vp_table, p14_a0

1071:
1072:
1073:
1074:
1075: okl_ec_uptake_pvt_w.rosetta_table_copy_out_p30(ddx_okl_vp_table, p14_a0
1076: , p14_a1
1077: , p14_a2
1078: , p14_a3
1079: );

Line 1085: end okl_ec_uptake_pvt_w;

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