DBA Data[Home] [Help]

APPS.JTF_CAL_AVLBLTY_PVT_W dependencies on JTF_VARCHAR2_TABLE_400

Line 18: , a2 JTF_VARCHAR2_TABLE_400

14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_avlblty_pvt.rstab, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_400
19: ) as
20: ddindx binary_integer; indx binary_integer;
21: begin
22: if a0 is not null and a0.count > 0 then

Line 41: , a2 out nocopy JTF_VARCHAR2_TABLE_400

37: end if;
38: end rosetta_table_copy_in_p1;
39: procedure rosetta_table_copy_out_p1(t jtf_cal_avlblty_pvt.rstab, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_VARCHAR2_TABLE_100
41: , a2 out nocopy JTF_VARCHAR2_TABLE_400
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then

Line 48: a2 := JTF_VARCHAR2_TABLE_400();

44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_NUMBER_TABLE();
47: a1 := JTF_VARCHAR2_TABLE_100();
48: a2 := JTF_VARCHAR2_TABLE_400();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: a2 := JTF_VARCHAR2_TABLE_400();

Line 52: a2 := JTF_VARCHAR2_TABLE_400();

48: a2 := JTF_VARCHAR2_TABLE_400();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();
52: a2 := JTF_VARCHAR2_TABLE_400();
53: if t.count > 0 then
54: a0.extend(t.count);
55: a1.extend(t.count);
56: a2.extend(t.count);

Line 75: , a2 JTF_VARCHAR2_TABLE_400

71: end rosetta_table_copy_out_p1;
72:
73: procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_avlblty_pvt.avlbltb, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_VARCHAR2_TABLE_400
76: , a3 JTF_NUMBER_TABLE
77: , a4 JTF_NUMBER_TABLE
78: ) as
79: ddindx binary_integer; indx binary_integer;

Line 102: , a2 out nocopy JTF_VARCHAR2_TABLE_400

98: end if;
99: end rosetta_table_copy_in_p3;
100: procedure rosetta_table_copy_out_p3(t jtf_cal_avlblty_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , a2 out nocopy JTF_VARCHAR2_TABLE_400
103: , a3 out nocopy JTF_NUMBER_TABLE
104: , a4 out nocopy JTF_NUMBER_TABLE
105: ) as
106: ddindx binary_integer; indx binary_integer;

Line 111: a2 := JTF_VARCHAR2_TABLE_400();

107: begin
108: if t is null or t.count = 0 then
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_VARCHAR2_TABLE_100();
111: a2 := JTF_VARCHAR2_TABLE_400();
112: a3 := JTF_NUMBER_TABLE();
113: a4 := JTF_NUMBER_TABLE();
114: else
115: a0 := JTF_NUMBER_TABLE();

Line 117: a2 := JTF_VARCHAR2_TABLE_400();

113: a4 := JTF_NUMBER_TABLE();
114: else
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_VARCHAR2_TABLE_100();
117: a2 := JTF_VARCHAR2_TABLE_400();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_NUMBER_TABLE();
120: if t.count > 0 then
121: a0.extend(t.count);

Line 151: , p5_a2 JTF_VARCHAR2_TABLE_400

147: , x_msg_count out nocopy NUMBER
148: , x_msg_data out nocopy VARCHAR2
149: , p5_a0 JTF_NUMBER_TABLE
150: , p5_a1 JTF_VARCHAR2_TABLE_100
151: , p5_a2 JTF_VARCHAR2_TABLE_400
152: , p_startdatetime date
153: , p_enddatetime date
154: , p_slotsize NUMBER
155: , x_numberofslots out nocopy NUMBER

Line 158: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_400

154: , p_slotsize NUMBER
155: , x_numberofslots out nocopy NUMBER
156: , p10_a0 out nocopy JTF_NUMBER_TABLE
157: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
158: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_400
159: , p10_a3 out nocopy JTF_NUMBER_TABLE
160: , p10_a4 out nocopy JTF_NUMBER_TABLE
161: , p11_a0 out nocopy JTF_NUMBER_TABLE
162: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 163: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400

159: , p10_a3 out nocopy JTF_NUMBER_TABLE
160: , p10_a4 out nocopy JTF_NUMBER_TABLE
161: , p11_a0 out nocopy JTF_NUMBER_TABLE
162: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
163: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400
164: , p11_a3 out nocopy JTF_NUMBER_TABLE
165: , p11_a4 out nocopy JTF_NUMBER_TABLE
166: )
167: