DBA Data[Home] [Help]

APPS.JTF_CAL_AVLBLTY_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 17: , a1 JTF_VARCHAR2_TABLE_100

13: return d;
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

Line 40: , a1 out nocopy JTF_VARCHAR2_TABLE_100

36: end if;
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

Line 47: a1 := JTF_VARCHAR2_TABLE_100();

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_VARCHAR2_TABLE_100();
48: a2 := JTF_VARCHAR2_TABLE_400();
49: else
50: a0 := JTF_NUMBER_TABLE();
51: a1 := JTF_VARCHAR2_TABLE_100();

Line 51: a1 := JTF_VARCHAR2_TABLE_100();

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();
53: if t.count > 0 then
54: a0.extend(t.count);
55: a1.extend(t.count);

Line 74: , a1 JTF_VARCHAR2_TABLE_100

70: end if;
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

Line 101: , a1 out nocopy JTF_VARCHAR2_TABLE_100

97: end if;
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

Line 110: a1 := JTF_VARCHAR2_TABLE_100();

106: ddindx binary_integer; indx binary_integer;
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

Line 116: a1 := JTF_VARCHAR2_TABLE_100();

112: a3 := JTF_NUMBER_TABLE();
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

Line 150: , p5_a1 JTF_VARCHAR2_TABLE_100

146: , x_return_status out nocopy VARCHAR2
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

Line 157: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100

153: , p_enddatetime date
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

Line 162: , p11_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
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: )