APPS.JTF_CAL_AVLBLTY_PVT_W dependencies on JTF_CAL_AVLBLTY_PVT

Line 1: package body jtf_cal_avlblty_pvt_w as

1: package body jtf_cal_avlblty_pvt_w as
2: /* $Header: jtfwavb.pls 120.2 2006/04/27 23:29 deeprao ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

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 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 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 169: ddp_rslist jtf_cal_avlblty_pvt.rstab;

165: , p11_a4 out nocopy JTF_NUMBER_TABLE
166: )
167:
168: as
169: ddp_rslist jtf_cal_avlblty_pvt.rstab;
170: ddp_startdatetime date;
171: ddp_enddatetime date;
172: ddx_availbltylist jtf_cal_avlblty_pvt.avlbltb;
173: ddx_totalavailbltylist jtf_cal_avlblty_pvt.avlbltb;

Line 172: ddx_availbltylist jtf_cal_avlblty_pvt.avlbltb;

168: as
169: ddp_rslist jtf_cal_avlblty_pvt.rstab;
170: ddp_startdatetime date;
171: ddp_enddatetime date;
172: ddx_availbltylist jtf_cal_avlblty_pvt.avlbltb;
173: ddx_totalavailbltylist jtf_cal_avlblty_pvt.avlbltb;
174: ddindx binary_integer; indx binary_integer;
175: begin
176:

Line 173: ddx_totalavailbltylist jtf_cal_avlblty_pvt.avlbltb;

169: ddp_rslist jtf_cal_avlblty_pvt.rstab;
170: ddp_startdatetime date;
171: ddp_enddatetime date;
172: ddx_availbltylist jtf_cal_avlblty_pvt.avlbltb;
173: ddx_totalavailbltylist jtf_cal_avlblty_pvt.avlbltb;
174: ddindx binary_integer; indx binary_integer;
175: begin
176:
177: -- copy data to the local IN or IN-OUT args, if any

Line 183: jtf_cal_avlblty_pvt_w.rosetta_table_copy_in_p1(ddp_rslist, p5_a0

179:
180:
181:
182:
183: jtf_cal_avlblty_pvt_w.rosetta_table_copy_in_p1(ddp_rslist, p5_a0
184: , p5_a1
185: , p5_a2
186: );
187:

Line 197: jtf_cal_avlblty_pvt.availability(p_api_version,

193:
194:
195:
196: -- here's the delegated call to the old PL/SQL routine
197: jtf_cal_avlblty_pvt.availability(p_api_version,
198: p_init_msg_list,
199: x_return_status,
200: x_msg_count,
201: x_msg_data,

Line 221: jtf_cal_avlblty_pvt_w.rosetta_table_copy_out_p3(ddx_availbltylist, p10_a0

217:
218:
219:
220:
221: jtf_cal_avlblty_pvt_w.rosetta_table_copy_out_p3(ddx_availbltylist, p10_a0
222: , p10_a1
223: , p10_a2
224: , p10_a3
225: , p10_a4

Line 228: jtf_cal_avlblty_pvt_w.rosetta_table_copy_out_p3(ddx_totalavailbltylist, p11_a0

224: , p10_a3
225: , p10_a4
226: );
227:
228: jtf_cal_avlblty_pvt_w.rosetta_table_copy_out_p3(ddx_totalavailbltylist, p11_a0
229: , p11_a1
230: , p11_a2
231: , p11_a3
232: , p11_a4

Line 236: end jtf_cal_avlblty_pvt_w;

232: , p11_a4
233: );
234: end;
235:
236: end jtf_cal_avlblty_pvt_w;