APPS.AHL_VWP_TASKS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_DATE_TABLE
18: , a2 JTF_DATE_TABLE
19: ) as
20: ddindx binary_integer; indx binary_integer;

Line 39: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

35: end loop;
36: end if;
37: end if;
38: end rosetta_table_copy_in_p1;
39: procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_DATE_TABLE
41: , a2 out nocopy JTF_DATE_TABLE
42: ) as
43: ddindx binary_integer; indx binary_integer;

Line 46: a0 := JTF_NUMBER_TABLE();

42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_NUMBER_TABLE();
47: a1 := JTF_DATE_TABLE();
48: a2 := JTF_DATE_TABLE();
49: else
50: a0 := JTF_NUMBER_TABLE();

Line 50: a0 := JTF_NUMBER_TABLE();

46: a0 := JTF_NUMBER_TABLE();
47: a1 := JTF_DATE_TABLE();
48: a2 := JTF_DATE_TABLE();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_DATE_TABLE();
52: a2 := JTF_DATE_TABLE();
53: if t.count > 0 then
54: a0.extend(t.count);

Line 832: , p6_a0 in out nocopy JTF_NUMBER_TABLE

828: , p_commit VARCHAR2
829: , p_validation_level NUMBER
830: , p_module_type VARCHAR2
831: , p_visit_id NUMBER
832: , p6_a0 in out nocopy JTF_NUMBER_TABLE
833: , p6_a1 in out nocopy JTF_DATE_TABLE
834: , p6_a2 in out nocopy JTF_DATE_TABLE
835: , x_return_status out nocopy VARCHAR2
836: , x_msg_count out nocopy NUMBER

Line 893: , p5_a0 in out nocopy JTF_NUMBER_TABLE

889: , p_init_msg_list VARCHAR2
890: , p_commit VARCHAR2
891: , p_validation_level NUMBER
892: , p_module_type VARCHAR2
893: , p5_a0 in out nocopy JTF_NUMBER_TABLE
894: , p5_a1 in out nocopy JTF_NUMBER_TABLE
895: , p5_a2 in out nocopy JTF_NUMBER_TABLE
896: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p5_a4 in out nocopy JTF_NUMBER_TABLE

Line 894: , p5_a1 in out nocopy JTF_NUMBER_TABLE

890: , p_commit VARCHAR2
891: , p_validation_level NUMBER
892: , p_module_type VARCHAR2
893: , p5_a0 in out nocopy JTF_NUMBER_TABLE
894: , p5_a1 in out nocopy JTF_NUMBER_TABLE
895: , p5_a2 in out nocopy JTF_NUMBER_TABLE
896: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p5_a4 in out nocopy JTF_NUMBER_TABLE
898: , p5_a5 in out nocopy JTF_NUMBER_TABLE

Line 895: , p5_a2 in out nocopy JTF_NUMBER_TABLE

891: , p_validation_level NUMBER
892: , p_module_type VARCHAR2
893: , p5_a0 in out nocopy JTF_NUMBER_TABLE
894: , p5_a1 in out nocopy JTF_NUMBER_TABLE
895: , p5_a2 in out nocopy JTF_NUMBER_TABLE
896: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p5_a4 in out nocopy JTF_NUMBER_TABLE
898: , p5_a5 in out nocopy JTF_NUMBER_TABLE
899: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 897: , p5_a4 in out nocopy JTF_NUMBER_TABLE

893: , p5_a0 in out nocopy JTF_NUMBER_TABLE
894: , p5_a1 in out nocopy JTF_NUMBER_TABLE
895: , p5_a2 in out nocopy JTF_NUMBER_TABLE
896: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p5_a4 in out nocopy JTF_NUMBER_TABLE
898: , p5_a5 in out nocopy JTF_NUMBER_TABLE
899: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
900: , p5_a7 in out nocopy JTF_NUMBER_TABLE
901: , p5_a8 in out nocopy JTF_NUMBER_TABLE

Line 898: , p5_a5 in out nocopy JTF_NUMBER_TABLE

894: , p5_a1 in out nocopy JTF_NUMBER_TABLE
895: , p5_a2 in out nocopy JTF_NUMBER_TABLE
896: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p5_a4 in out nocopy JTF_NUMBER_TABLE
898: , p5_a5 in out nocopy JTF_NUMBER_TABLE
899: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
900: , p5_a7 in out nocopy JTF_NUMBER_TABLE
901: , p5_a8 in out nocopy JTF_NUMBER_TABLE
902: , p5_a9 in out nocopy JTF_NUMBER_TABLE

Line 900: , p5_a7 in out nocopy JTF_NUMBER_TABLE

896: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
897: , p5_a4 in out nocopy JTF_NUMBER_TABLE
898: , p5_a5 in out nocopy JTF_NUMBER_TABLE
899: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
900: , p5_a7 in out nocopy JTF_NUMBER_TABLE
901: , p5_a8 in out nocopy JTF_NUMBER_TABLE
902: , p5_a9 in out nocopy JTF_NUMBER_TABLE
903: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
904: , p5_a11 in out nocopy JTF_NUMBER_TABLE

Line 901: , p5_a8 in out nocopy JTF_NUMBER_TABLE

897: , p5_a4 in out nocopy JTF_NUMBER_TABLE
898: , p5_a5 in out nocopy JTF_NUMBER_TABLE
899: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
900: , p5_a7 in out nocopy JTF_NUMBER_TABLE
901: , p5_a8 in out nocopy JTF_NUMBER_TABLE
902: , p5_a9 in out nocopy JTF_NUMBER_TABLE
903: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
904: , p5_a11 in out nocopy JTF_NUMBER_TABLE
905: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 902: , p5_a9 in out nocopy JTF_NUMBER_TABLE

898: , p5_a5 in out nocopy JTF_NUMBER_TABLE
899: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
900: , p5_a7 in out nocopy JTF_NUMBER_TABLE
901: , p5_a8 in out nocopy JTF_NUMBER_TABLE
902: , p5_a9 in out nocopy JTF_NUMBER_TABLE
903: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
904: , p5_a11 in out nocopy JTF_NUMBER_TABLE
905: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
906: , p5_a13 in out nocopy JTF_NUMBER_TABLE

Line 904: , p5_a11 in out nocopy JTF_NUMBER_TABLE

900: , p5_a7 in out nocopy JTF_NUMBER_TABLE
901: , p5_a8 in out nocopy JTF_NUMBER_TABLE
902: , p5_a9 in out nocopy JTF_NUMBER_TABLE
903: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
904: , p5_a11 in out nocopy JTF_NUMBER_TABLE
905: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
906: , p5_a13 in out nocopy JTF_NUMBER_TABLE
907: , p5_a14 in out nocopy JTF_NUMBER_TABLE
908: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300

Line 906: , p5_a13 in out nocopy JTF_NUMBER_TABLE

902: , p5_a9 in out nocopy JTF_NUMBER_TABLE
903: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
904: , p5_a11 in out nocopy JTF_NUMBER_TABLE
905: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
906: , p5_a13 in out nocopy JTF_NUMBER_TABLE
907: , p5_a14 in out nocopy JTF_NUMBER_TABLE
908: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
909: , p5_a16 in out nocopy JTF_NUMBER_TABLE
910: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100

Line 907: , p5_a14 in out nocopy JTF_NUMBER_TABLE

903: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
904: , p5_a11 in out nocopy JTF_NUMBER_TABLE
905: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
906: , p5_a13 in out nocopy JTF_NUMBER_TABLE
907: , p5_a14 in out nocopy JTF_NUMBER_TABLE
908: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
909: , p5_a16 in out nocopy JTF_NUMBER_TABLE
910: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
911: , p5_a18 in out nocopy JTF_NUMBER_TABLE

Line 909: , p5_a16 in out nocopy JTF_NUMBER_TABLE

905: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
906: , p5_a13 in out nocopy JTF_NUMBER_TABLE
907: , p5_a14 in out nocopy JTF_NUMBER_TABLE
908: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
909: , p5_a16 in out nocopy JTF_NUMBER_TABLE
910: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
911: , p5_a18 in out nocopy JTF_NUMBER_TABLE
912: , p5_a19 in out nocopy JTF_NUMBER_TABLE
913: , p5_a20 in out nocopy JTF_NUMBER_TABLE

Line 911: , p5_a18 in out nocopy JTF_NUMBER_TABLE

907: , p5_a14 in out nocopy JTF_NUMBER_TABLE
908: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
909: , p5_a16 in out nocopy JTF_NUMBER_TABLE
910: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
911: , p5_a18 in out nocopy JTF_NUMBER_TABLE
912: , p5_a19 in out nocopy JTF_NUMBER_TABLE
913: , p5_a20 in out nocopy JTF_NUMBER_TABLE
914: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
915: , p5_a22 in out nocopy JTF_NUMBER_TABLE

Line 912: , p5_a19 in out nocopy JTF_NUMBER_TABLE

908: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
909: , p5_a16 in out nocopy JTF_NUMBER_TABLE
910: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
911: , p5_a18 in out nocopy JTF_NUMBER_TABLE
912: , p5_a19 in out nocopy JTF_NUMBER_TABLE
913: , p5_a20 in out nocopy JTF_NUMBER_TABLE
914: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
915: , p5_a22 in out nocopy JTF_NUMBER_TABLE
916: , p5_a23 in out nocopy JTF_NUMBER_TABLE

Line 913: , p5_a20 in out nocopy JTF_NUMBER_TABLE

909: , p5_a16 in out nocopy JTF_NUMBER_TABLE
910: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
911: , p5_a18 in out nocopy JTF_NUMBER_TABLE
912: , p5_a19 in out nocopy JTF_NUMBER_TABLE
913: , p5_a20 in out nocopy JTF_NUMBER_TABLE
914: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
915: , p5_a22 in out nocopy JTF_NUMBER_TABLE
916: , p5_a23 in out nocopy JTF_NUMBER_TABLE
917: , p5_a24 in out nocopy JTF_NUMBER_TABLE

Line 915: , p5_a22 in out nocopy JTF_NUMBER_TABLE

911: , p5_a18 in out nocopy JTF_NUMBER_TABLE
912: , p5_a19 in out nocopy JTF_NUMBER_TABLE
913: , p5_a20 in out nocopy JTF_NUMBER_TABLE
914: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
915: , p5_a22 in out nocopy JTF_NUMBER_TABLE
916: , p5_a23 in out nocopy JTF_NUMBER_TABLE
917: , p5_a24 in out nocopy JTF_NUMBER_TABLE
918: , p5_a25 in out nocopy JTF_NUMBER_TABLE
919: , p5_a26 in out nocopy JTF_NUMBER_TABLE

Line 916: , p5_a23 in out nocopy JTF_NUMBER_TABLE

912: , p5_a19 in out nocopy JTF_NUMBER_TABLE
913: , p5_a20 in out nocopy JTF_NUMBER_TABLE
914: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
915: , p5_a22 in out nocopy JTF_NUMBER_TABLE
916: , p5_a23 in out nocopy JTF_NUMBER_TABLE
917: , p5_a24 in out nocopy JTF_NUMBER_TABLE
918: , p5_a25 in out nocopy JTF_NUMBER_TABLE
919: , p5_a26 in out nocopy JTF_NUMBER_TABLE
920: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100

Line 917: , p5_a24 in out nocopy JTF_NUMBER_TABLE

913: , p5_a20 in out nocopy JTF_NUMBER_TABLE
914: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
915: , p5_a22 in out nocopy JTF_NUMBER_TABLE
916: , p5_a23 in out nocopy JTF_NUMBER_TABLE
917: , p5_a24 in out nocopy JTF_NUMBER_TABLE
918: , p5_a25 in out nocopy JTF_NUMBER_TABLE
919: , p5_a26 in out nocopy JTF_NUMBER_TABLE
920: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
921: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100

Line 918: , p5_a25 in out nocopy JTF_NUMBER_TABLE

914: , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
915: , p5_a22 in out nocopy JTF_NUMBER_TABLE
916: , p5_a23 in out nocopy JTF_NUMBER_TABLE
917: , p5_a24 in out nocopy JTF_NUMBER_TABLE
918: , p5_a25 in out nocopy JTF_NUMBER_TABLE
919: , p5_a26 in out nocopy JTF_NUMBER_TABLE
920: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
921: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
922: , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100

Line 919: , p5_a26 in out nocopy JTF_NUMBER_TABLE

915: , p5_a22 in out nocopy JTF_NUMBER_TABLE
916: , p5_a23 in out nocopy JTF_NUMBER_TABLE
917: , p5_a24 in out nocopy JTF_NUMBER_TABLE
918: , p5_a25 in out nocopy JTF_NUMBER_TABLE
919: , p5_a26 in out nocopy JTF_NUMBER_TABLE
920: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
921: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
922: , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100
923: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_4000

Line 926: , p5_a33 in out nocopy JTF_NUMBER_TABLE

922: , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100
923: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_4000
924: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_100
925: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
926: , p5_a33 in out nocopy JTF_NUMBER_TABLE
927: , p5_a34 in out nocopy JTF_DATE_TABLE
928: , p5_a35 in out nocopy JTF_NUMBER_TABLE
929: , p5_a36 in out nocopy JTF_DATE_TABLE
930: , p5_a37 in out nocopy JTF_NUMBER_TABLE

Line 928: , p5_a35 in out nocopy JTF_NUMBER_TABLE

924: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_100
925: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
926: , p5_a33 in out nocopy JTF_NUMBER_TABLE
927: , p5_a34 in out nocopy JTF_DATE_TABLE
928: , p5_a35 in out nocopy JTF_NUMBER_TABLE
929: , p5_a36 in out nocopy JTF_DATE_TABLE
930: , p5_a37 in out nocopy JTF_NUMBER_TABLE
931: , p5_a38 in out nocopy JTF_NUMBER_TABLE
932: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100

Line 930: , p5_a37 in out nocopy JTF_NUMBER_TABLE

926: , p5_a33 in out nocopy JTF_NUMBER_TABLE
927: , p5_a34 in out nocopy JTF_DATE_TABLE
928: , p5_a35 in out nocopy JTF_NUMBER_TABLE
929: , p5_a36 in out nocopy JTF_DATE_TABLE
930: , p5_a37 in out nocopy JTF_NUMBER_TABLE
931: , p5_a38 in out nocopy JTF_NUMBER_TABLE
932: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
933: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_200
934: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_200

Line 931: , p5_a38 in out nocopy JTF_NUMBER_TABLE

927: , p5_a34 in out nocopy JTF_DATE_TABLE
928: , p5_a35 in out nocopy JTF_NUMBER_TABLE
929: , p5_a36 in out nocopy JTF_DATE_TABLE
930: , p5_a37 in out nocopy JTF_NUMBER_TABLE
931: , p5_a38 in out nocopy JTF_NUMBER_TABLE
932: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
933: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_200
934: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_200
935: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_200

Line 953: , p5_a60 in out nocopy JTF_NUMBER_TABLE

949: , p5_a56 in out nocopy JTF_DATE_TABLE
950: , p5_a57 in out nocopy JTF_DATE_TABLE
951: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
952: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
953: , p5_a60 in out nocopy JTF_NUMBER_TABLE
954: , p5_a61 in out nocopy JTF_NUMBER_TABLE
955: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
956: , p5_a63 in out nocopy JTF_NUMBER_TABLE
957: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300

Line 954: , p5_a61 in out nocopy JTF_NUMBER_TABLE

950: , p5_a57 in out nocopy JTF_DATE_TABLE
951: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
952: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
953: , p5_a60 in out nocopy JTF_NUMBER_TABLE
954: , p5_a61 in out nocopy JTF_NUMBER_TABLE
955: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
956: , p5_a63 in out nocopy JTF_NUMBER_TABLE
957: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
958: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100

Line 956: , p5_a63 in out nocopy JTF_NUMBER_TABLE

952: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
953: , p5_a60 in out nocopy JTF_NUMBER_TABLE
954: , p5_a61 in out nocopy JTF_NUMBER_TABLE
955: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
956: , p5_a63 in out nocopy JTF_NUMBER_TABLE
957: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
958: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100
959: , p5_a66 in out nocopy JTF_DATE_TABLE
960: , p5_a67 in out nocopy JTF_DATE_TABLE

Line 964: , p5_a71 in out nocopy JTF_NUMBER_TABLE

960: , p5_a67 in out nocopy JTF_DATE_TABLE
961: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
962: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a71 in out nocopy JTF_NUMBER_TABLE
965: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a73 in out nocopy JTF_NUMBER_TABLE
967: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
968: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100

Line 966: , p5_a73 in out nocopy JTF_NUMBER_TABLE

962: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
963: , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100
964: , p5_a71 in out nocopy JTF_NUMBER_TABLE
965: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
966: , p5_a73 in out nocopy JTF_NUMBER_TABLE
967: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
968: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
969: , x_return_status out nocopy VARCHAR2
970: , x_msg_count out nocopy NUMBER