DBA Data[Home] [Help]

APPS.CAC_VIEW_AVAIL_PVT_W dependencies on CAC_VIEW_AVAIL_PVT

Line 1: package body cac_view_avail_pvt_w as

1: package body cac_view_avail_pvt_w as
2: /* $Header: cacwavb.pls 115.0 2003/10/28 00:59:35 cjang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_avail_pvt.rstab, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_avail_pvt.rstab, a0 JTF_NUMBER_TABLE

1: package body cac_view_avail_pvt_w as
2: /* $Header: cacwavb.pls 115.0 2003/10/28 00:59:35 cjang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_avail_pvt.rstab, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: ) as
7: ddindx binary_integer; indx binary_integer;

Line 26: procedure rosetta_table_copy_out_p1(t cac_view_avail_pvt.rstab, a0 out nocopy JTF_NUMBER_TABLE

22: end loop;
23: end if;
24: end if;
25: end rosetta_table_copy_in_p1;
26: procedure rosetta_table_copy_out_p1(t cac_view_avail_pvt.rstab, a0 out nocopy JTF_NUMBER_TABLE
27: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a2 out nocopy JTF_VARCHAR2_TABLE_400
29: ) as
30: ddindx binary_integer; indx binary_integer;

Line 60: procedure rosetta_table_copy_in_p3(t out nocopy cac_view_avail_pvt.avlbltb, a0 JTF_NUMBER_TABLE

56: end if;
57: end if;
58: end rosetta_table_copy_out_p1;
59:
60: procedure rosetta_table_copy_in_p3(t out nocopy cac_view_avail_pvt.avlbltb, a0 JTF_NUMBER_TABLE
61: , a1 JTF_VARCHAR2_TABLE_100
62: , a2 JTF_VARCHAR2_TABLE_400
63: , a3 JTF_NUMBER_TABLE
64: , a4 JTF_NUMBER_TABLE

Line 87: procedure rosetta_table_copy_out_p3(t cac_view_avail_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE

83: end loop;
84: end if;
85: end if;
86: end rosetta_table_copy_in_p3;
87: procedure rosetta_table_copy_out_p3(t cac_view_avail_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_VARCHAR2_TABLE_100
89: , a2 out nocopy JTF_VARCHAR2_TABLE_400
90: , a3 out nocopy JTF_NUMBER_TABLE
91: , a4 out nocopy JTF_NUMBER_TABLE

Line 156: ddp_rslist cac_view_avail_pvt.rstab;

152: , p11_a4 out nocopy JTF_NUMBER_TABLE
153: )
154:
155: as
156: ddp_rslist cac_view_avail_pvt.rstab;
157: ddx_availbltylist cac_view_avail_pvt.avlbltb;
158: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;
159: ddindx binary_integer; indx binary_integer;
160: begin

Line 157: ddx_availbltylist cac_view_avail_pvt.avlbltb;

153: )
154:
155: as
156: ddp_rslist cac_view_avail_pvt.rstab;
157: ddx_availbltylist cac_view_avail_pvt.avlbltb;
158: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;
159: ddindx binary_integer; indx binary_integer;
160: begin
161:

Line 158: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;

154:
155: as
156: ddp_rslist cac_view_avail_pvt.rstab;
157: ddx_availbltylist cac_view_avail_pvt.avlbltb;
158: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;
159: ddindx binary_integer; indx binary_integer;
160: begin
161:
162: -- copy data to the local IN or IN-OUT args, if any

Line 168: cac_view_avail_pvt_w.rosetta_table_copy_in_p1(ddp_rslist, p5_a0

164:
165:
166:
167:
168: cac_view_avail_pvt_w.rosetta_table_copy_in_p1(ddp_rslist, p5_a0
169: , p5_a1
170: , p5_a2
171: );
172:

Line 180: cac_view_avail_pvt.availability(p_api_version,

176:
177:
178:
179: -- here's the delegated call to the old PL/SQL routine
180: cac_view_avail_pvt.availability(p_api_version,
181: p_init_msg_list,
182: x_return_status,
183: x_msg_count,
184: x_msg_data,

Line 204: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_availbltylist, p10_a0

200:
201:
202:
203:
204: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_availbltylist, p10_a0
205: , p10_a1
206: , p10_a2
207: , p10_a3
208: , p10_a4

Line 211: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_totalavailbltylist, p11_a0

207: , p10_a3
208: , p10_a4
209: );
210:
211: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_totalavailbltylist, p11_a0
212: , p11_a1
213: , p11_a2
214: , p11_a3
215: , p11_a4

Line 244: ddp_rslist cac_view_avail_pvt.rstab;

240: , x_msg_data out nocopy VARCHAR2
241: )
242:
243: as
244: ddp_rslist cac_view_avail_pvt.rstab;
245: ddx_availbltylist cac_view_avail_pvt.avlbltb;
246: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;
247: ddindx binary_integer; indx binary_integer;
248: begin

Line 245: ddx_availbltylist cac_view_avail_pvt.avlbltb;

241: )
242:
243: as
244: ddp_rslist cac_view_avail_pvt.rstab;
245: ddx_availbltylist cac_view_avail_pvt.avlbltb;
246: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;
247: ddindx binary_integer; indx binary_integer;
248: begin
249:

Line 246: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;

242:
243: as
244: ddp_rslist cac_view_avail_pvt.rstab;
245: ddx_availbltylist cac_view_avail_pvt.avlbltb;
246: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;
247: ddindx binary_integer; indx binary_integer;
248: begin
249:
250: -- copy data to the local IN or IN-OUT args, if any

Line 253: cac_view_avail_pvt_w.rosetta_table_copy_in_p1(ddp_rslist, p2_a0

249:
250: -- copy data to the local IN or IN-OUT args, if any
251:
252:
253: cac_view_avail_pvt_w.rosetta_table_copy_in_p1(ddp_rslist, p2_a0
254: , p2_a1
255: , p2_a2
256: );
257:

Line 268: cac_view_avail_pvt.check_availability(p_api_version,

264:
265:
266:
267: -- here's the delegated call to the old PL/SQL routine
268: cac_view_avail_pvt.check_availability(p_api_version,
269: p_init_msg_list,
270: ddp_rslist,
271: p_startdatetime,
272: p_enddatetime,

Line 289: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_availbltylist, p7_a0

285:
286:
287:
288:
289: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_availbltylist, p7_a0
290: , p7_a1
291: , p7_a2
292: , p7_a3
293: , p7_a4

Line 296: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_totalavailbltylist, p8_a0

292: , p7_a3
293: , p7_a4
294: );
295:
296: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_totalavailbltylist, p8_a0
297: , p8_a1
298: , p8_a2
299: , p8_a3
300: , p8_a4

Line 330: ddx_availbltylist cac_view_avail_pvt.avlbltb;

326: , x_msg_data out nocopy VARCHAR2
327: )
328:
329: as
330: ddx_availbltylist cac_view_avail_pvt.avlbltb;
331: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;
332: ddindx binary_integer; indx binary_integer;
333: begin
334:

Line 331: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;

327: )
328:
329: as
330: ddx_availbltylist cac_view_avail_pvt.avlbltb;
331: ddx_totalavailbltylist cac_view_avail_pvt.avlbltb;
332: ddindx binary_integer; indx binary_integer;
333: begin
334:
335: -- copy data to the local IN or IN-OUT args, if any

Line 349: cac_view_avail_pvt.check_availability(p_api_version,

345:
346:
347:
348: -- here's the delegated call to the old PL/SQL routine
349: cac_view_avail_pvt.check_availability(p_api_version,
350: p_init_msg_list,
351: p_task_id,
352: p_startdatetime,
353: p_enddatetime,

Line 370: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_availbltylist, p7_a0

366:
367:
368:
369:
370: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_availbltylist, p7_a0
371: , p7_a1
372: , p7_a2
373: , p7_a3
374: , p7_a4

Line 377: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_totalavailbltylist, p8_a0

373: , p7_a3
374: , p7_a4
375: );
376:
377: cac_view_avail_pvt_w.rosetta_table_copy_out_p3(ddx_totalavailbltylist, p8_a0
378: , p8_a1
379: , p8_a2
380: , p8_a3
381: , p8_a4

Line 388: end cac_view_avail_pvt_w;

384:
385:
386: end;
387:
388: end cac_view_avail_pvt_w;