[Home] [Help]
PACKAGE: APPS.CAC_VIEW_AVAIL_PVT_W
Source
1 package cac_view_avail_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cacwavs.pls 115.0 2003/10/28 00:59:10 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 );
7 procedure rosetta_table_copy_out_p1(t cac_view_avail_pvt.rstab, a0 out nocopy JTF_NUMBER_TABLE
8 , a1 out nocopy JTF_VARCHAR2_TABLE_100
9 , a2 out nocopy JTF_VARCHAR2_TABLE_400
10 );
11
12 procedure rosetta_table_copy_in_p3(t out nocopy cac_view_avail_pvt.avlbltb, a0 JTF_NUMBER_TABLE
13 , a1 JTF_VARCHAR2_TABLE_100
14 , a2 JTF_VARCHAR2_TABLE_400
15 , a3 JTF_NUMBER_TABLE
16 , a4 JTF_NUMBER_TABLE
17 );
18 procedure rosetta_table_copy_out_p3(t cac_view_avail_pvt.avlbltb, a0 out nocopy JTF_NUMBER_TABLE
19 , a1 out nocopy JTF_VARCHAR2_TABLE_100
20 , a2 out nocopy JTF_VARCHAR2_TABLE_400
21 , a3 out nocopy JTF_NUMBER_TABLE
22 , a4 out nocopy JTF_NUMBER_TABLE
23 );
24
25 procedure availability(p_api_version NUMBER
26 , p_init_msg_list VARCHAR2
27 , x_return_status out nocopy VARCHAR2
28 , x_msg_count out nocopy NUMBER
29 , x_msg_data out nocopy VARCHAR2
30 , p5_a0 JTF_NUMBER_TABLE
31 , p5_a1 JTF_VARCHAR2_TABLE_100
32 , p5_a2 JTF_VARCHAR2_TABLE_400
33 , p_startdatetime DATE
34 , p_enddatetime DATE
35 , p_slotsize NUMBER
36 , x_numberofslots out nocopy NUMBER
37 , p10_a0 out nocopy JTF_NUMBER_TABLE
38 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
39 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_400
40 , p10_a3 out nocopy JTF_NUMBER_TABLE
41 , p10_a4 out nocopy JTF_NUMBER_TABLE
42 , p11_a0 out nocopy JTF_NUMBER_TABLE
43 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
44 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_400
45 , p11_a3 out nocopy JTF_NUMBER_TABLE
46 , p11_a4 out nocopy JTF_NUMBER_TABLE
47 );
48 procedure check_availability(p_api_version NUMBER
49 , p_init_msg_list VARCHAR2
50 , p2_a0 JTF_NUMBER_TABLE
51 , p2_a1 JTF_VARCHAR2_TABLE_100
52 , p2_a2 JTF_VARCHAR2_TABLE_400
53 , p_startdatetime DATE
54 , p_enddatetime DATE
55 , p_slotsize NUMBER
56 , x_numberofslots out nocopy NUMBER
57 , p7_a0 out nocopy JTF_NUMBER_TABLE
58 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
59 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400
60 , p7_a3 out nocopy JTF_NUMBER_TABLE
61 , p7_a4 out nocopy JTF_NUMBER_TABLE
62 , p8_a0 out nocopy JTF_NUMBER_TABLE
63 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
64 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
65 , p8_a3 out nocopy JTF_NUMBER_TABLE
66 , p8_a4 out nocopy JTF_NUMBER_TABLE
67 , x_return_status out nocopy VARCHAR2
68 , x_msg_count out nocopy NUMBER
69 , x_msg_data out nocopy VARCHAR2
70 );
71 procedure check_availability(p_api_version NUMBER
72 , p_init_msg_list VARCHAR2
73 , p_task_id NUMBER
74 , p_startdatetime DATE
75 , p_enddatetime DATE
76 , p_slotsize NUMBER
77 , x_numberofslots out nocopy NUMBER
78 , p7_a0 out nocopy JTF_NUMBER_TABLE
79 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
80 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_400
81 , p7_a3 out nocopy JTF_NUMBER_TABLE
82 , p7_a4 out nocopy JTF_NUMBER_TABLE
83 , p8_a0 out nocopy JTF_NUMBER_TABLE
84 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
85 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
86 , p8_a3 out nocopy JTF_NUMBER_TABLE
87 , p8_a4 out nocopy JTF_NUMBER_TABLE
88 , x_return_status out nocopy VARCHAR2
89 , x_msg_count out nocopy NUMBER
90 , x_msg_data out nocopy VARCHAR2
91 );
92 end cac_view_avail_pvt_w;