DBA Data[Home] [Help]

APPS.AHL_VWP_TASKS_PVT_W dependencies on JTF_DATE_TABLE

Line 17: , a1 JTF_DATE_TABLE

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;
21: begin

Line 18: , a2 JTF_DATE_TABLE

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;
21: begin
22: if a0 is not null and a0.count > 0 then

Line 40: , a1 out nocopy JTF_DATE_TABLE

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;
44: begin

Line 41: , a2 out nocopy JTF_DATE_TABLE

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;
44: begin
45: if t is null or t.count = 0 then

Line 47: a1 := JTF_DATE_TABLE();

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();
51: a1 := JTF_DATE_TABLE();

Line 48: a2 := JTF_DATE_TABLE();

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();
51: a1 := JTF_DATE_TABLE();
52: a2 := JTF_DATE_TABLE();

Line 51: a1 := JTF_DATE_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);
55: a1.extend(t.count);

Line 52: a2 := 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);
55: a1.extend(t.count);
56: a2.extend(t.count);

Line 985: , p6_a1 in out nocopy JTF_DATE_TABLE

981: , p_validation_level NUMBER
982: , p_module_type VARCHAR2
983: , p_visit_id NUMBER
984: , p6_a0 in out nocopy JTF_NUMBER_TABLE
985: , p6_a1 in out nocopy JTF_DATE_TABLE
986: , p6_a2 in out nocopy JTF_DATE_TABLE
987: , x_return_status out nocopy VARCHAR2
988: , x_msg_count out nocopy NUMBER
989: , x_msg_data out nocopy VARCHAR2

Line 986: , p6_a2 in out nocopy JTF_DATE_TABLE

982: , p_module_type VARCHAR2
983: , p_visit_id NUMBER
984: , p6_a0 in out nocopy JTF_NUMBER_TABLE
985: , p6_a1 in out nocopy JTF_DATE_TABLE
986: , p6_a2 in out nocopy JTF_DATE_TABLE
987: , x_return_status out nocopy VARCHAR2
988: , x_msg_count out nocopy NUMBER
989: , x_msg_data out nocopy VARCHAR2
990: )

Line 1079: , p5_a34 in out nocopy JTF_DATE_TABLE

1075: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_4000
1076: , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1077: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
1078: , p5_a33 in out nocopy JTF_NUMBER_TABLE
1079: , p5_a34 in out nocopy JTF_DATE_TABLE
1080: , p5_a35 in out nocopy JTF_NUMBER_TABLE
1081: , p5_a36 in out nocopy JTF_DATE_TABLE
1082: , p5_a37 in out nocopy JTF_NUMBER_TABLE
1083: , p5_a38 in out nocopy JTF_NUMBER_TABLE

Line 1081: , p5_a36 in out nocopy JTF_DATE_TABLE

1077: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
1078: , p5_a33 in out nocopy JTF_NUMBER_TABLE
1079: , p5_a34 in out nocopy JTF_DATE_TABLE
1080: , p5_a35 in out nocopy JTF_NUMBER_TABLE
1081: , p5_a36 in out nocopy JTF_DATE_TABLE
1082: , p5_a37 in out nocopy JTF_NUMBER_TABLE
1083: , p5_a38 in out nocopy JTF_NUMBER_TABLE
1084: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
1085: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1100: , p5_a55 in out nocopy JTF_DATE_TABLE

1096: , p5_a51 in out nocopy JTF_VARCHAR2_TABLE_200
1097: , p5_a52 in out nocopy JTF_VARCHAR2_TABLE_200
1098: , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
1099: , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
1100: , p5_a55 in out nocopy JTF_DATE_TABLE
1101: , p5_a56 in out nocopy JTF_DATE_TABLE
1102: , p5_a57 in out nocopy JTF_DATE_TABLE
1103: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1101: , p5_a56 in out nocopy JTF_DATE_TABLE

1097: , p5_a52 in out nocopy JTF_VARCHAR2_TABLE_200
1098: , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
1099: , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
1100: , p5_a55 in out nocopy JTF_DATE_TABLE
1101: , p5_a56 in out nocopy JTF_DATE_TABLE
1102: , p5_a57 in out nocopy JTF_DATE_TABLE
1103: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a60 in out nocopy JTF_NUMBER_TABLE

Line 1102: , p5_a57 in out nocopy JTF_DATE_TABLE

1098: , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
1099: , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
1100: , p5_a55 in out nocopy JTF_DATE_TABLE
1101: , p5_a56 in out nocopy JTF_DATE_TABLE
1102: , p5_a57 in out nocopy JTF_DATE_TABLE
1103: , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a60 in out nocopy JTF_NUMBER_TABLE
1106: , p5_a61 in out nocopy JTF_NUMBER_TABLE

Line 1111: , p5_a66 in out nocopy JTF_DATE_TABLE

1107: , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
1108: , p5_a63 in out nocopy JTF_NUMBER_TABLE
1109: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
1110: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100
1111: , p5_a66 in out nocopy JTF_DATE_TABLE
1112: , p5_a67 in out nocopy JTF_DATE_TABLE
1113: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
1114: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
1115: , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1112: , p5_a67 in out nocopy JTF_DATE_TABLE

1108: , p5_a63 in out nocopy JTF_NUMBER_TABLE
1109: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
1110: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100
1111: , p5_a66 in out nocopy JTF_DATE_TABLE
1112: , p5_a67 in out nocopy JTF_DATE_TABLE
1113: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
1114: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
1115: , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100
1116: , p5_a71 in out nocopy JTF_NUMBER_TABLE

Line 1123: , p5_a78 in out nocopy JTF_DATE_TABLE

1119: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
1120: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
1121: , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_100
1122: , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
1123: , p5_a78 in out nocopy JTF_DATE_TABLE
1124: , p5_a79 in out nocopy JTF_DATE_TABLE
1125: , p5_a80 in out nocopy JTF_NUMBER_TABLE
1126: , p5_a81 in out nocopy JTF_NUMBER_TABLE
1127: , p5_a82 in out nocopy JTF_NUMBER_TABLE

Line 1124: , p5_a79 in out nocopy JTF_DATE_TABLE

1120: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
1121: , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_100
1122: , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
1123: , p5_a78 in out nocopy JTF_DATE_TABLE
1124: , p5_a79 in out nocopy JTF_DATE_TABLE
1125: , p5_a80 in out nocopy JTF_NUMBER_TABLE
1126: , p5_a81 in out nocopy JTF_NUMBER_TABLE
1127: , p5_a82 in out nocopy JTF_NUMBER_TABLE
1128: , p5_a83 in out nocopy JTF_VARCHAR2_TABLE_100