DBA Data[Home] [Help]

APPS.JTF_CAL_AVLBLTY_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_avlblty_pvt.rstab, 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 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;

Line 39: procedure rosetta_table_copy_out_p1(t jtf_cal_avlblty_pvt.rstab, 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 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;

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

Line 50: a0 := JTF_NUMBER_TABLE();

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

Line 73: procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_avlblty_pvt.avlbltb, a0 JTF_NUMBER_TABLE

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

Line 76: , a3 JTF_NUMBER_TABLE

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

Line 77: , a4 JTF_NUMBER_TABLE

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

Line 100: procedure rosetta_table_copy_out_p3(t jtf_cal_avlblty_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE

96: end loop;
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

Line 103: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 104: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 109: a0 := JTF_NUMBER_TABLE();

105: ) as
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();

Line 112: a3 := JTF_NUMBER_TABLE();

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();
116: a1 := JTF_VARCHAR2_TABLE_100();

Line 113: a4 := JTF_NUMBER_TABLE();

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();
116: a1 := JTF_VARCHAR2_TABLE_100();
117: a2 := JTF_VARCHAR2_TABLE_400();

Line 115: a0 := JTF_NUMBER_TABLE();

111: a2 := JTF_VARCHAR2_TABLE_400();
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();

Line 118: a3 := 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);
122: a1.extend(t.count);

Line 119: a4 := JTF_NUMBER_TABLE();

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);
122: a1.extend(t.count);
123: a2.extend(t.count);

Line 149: , p5_a0 JTF_NUMBER_TABLE

145: , p_init_msg_list VARCHAR2
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

Line 156: , p10_a0 out nocopy JTF_NUMBER_TABLE

152: , p_startdatetime date
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

Line 159: , p10_a3 out nocopy JTF_NUMBER_TABLE

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
163: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400

Line 160: , p10_a4 out nocopy JTF_NUMBER_TABLE

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
163: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400
164: , p11_a3 out nocopy JTF_NUMBER_TABLE

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

Line 164: , p11_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:
168: as

Line 165: , p11_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:
168: as
169: ddp_rslist jtf_cal_avlblty_pvt.rstab;