[Home] [Help]
PACKAGE: APPS.JTF_CAL_PVT_W
Source
1 package jtf_cal_pvt_w as
2 /* $Header: jtfwhcs.pls 120.2 2006/04/28 01:30 deeprao ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy jtf_cal_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_400
6 , a3 JTF_VARCHAR2_TABLE_100
7 );
8 procedure rosetta_table_copy_out_p1(t jtf_cal_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
9 , a1 out nocopy JTF_VARCHAR2_TABLE_100
10 , a2 out nocopy JTF_VARCHAR2_TABLE_400
11 , a3 out nocopy JTF_VARCHAR2_TABLE_100
12 );
13
14 procedure rosetta_table_copy_in_p3(t out nocopy jtf_cal_pvt.weektimepreftbltype, a0 JTF_NUMBER_TABLE
15 , a1 JTF_NUMBER_TABLE
16 );
17 procedure rosetta_table_copy_out_p3(t jtf_cal_pvt.weektimepreftbltype, a0 out nocopy JTF_NUMBER_TABLE
18 , a1 out nocopy JTF_NUMBER_TABLE
19 );
20
21 procedure rosetta_table_copy_in_p7(t out nocopy jtf_cal_pvt.queryouttab, a0 JTF_NUMBER_TABLE
22 , a1 JTF_NUMBER_TABLE
23 , a2 JTF_VARCHAR2_TABLE_100
24 , a3 JTF_VARCHAR2_TABLE_100
25 , a4 JTF_NUMBER_TABLE
26 , a5 JTF_NUMBER_TABLE
27 , a6 JTF_VARCHAR2_TABLE_200
28 , a7 JTF_NUMBER_TABLE
29 , a8 JTF_VARCHAR2_TABLE_100
30 , a9 JTF_NUMBER_TABLE
31 , a10 JTF_NUMBER_TABLE
32 , a11 JTF_DATE_TABLE
33 , a12 JTF_DATE_TABLE
34 , a13 JTF_VARCHAR2_TABLE_2000
35 , a14 JTF_VARCHAR2_TABLE_2000
36 , a15 JTF_NUMBER_TABLE
37 , a16 JTF_VARCHAR2_TABLE_100
38 , a17 JTF_NUMBER_TABLE
39 , a18 JTF_VARCHAR2_TABLE_300
40 , a19 JTF_VARCHAR2_TABLE_100
41 , a20 JTF_NUMBER_TABLE
42 , a21 JTF_NUMBER_TABLE
43 , a22 JTF_NUMBER_TABLE
44 );
45 procedure rosetta_table_copy_out_p7(t jtf_cal_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
46 , a1 out nocopy JTF_NUMBER_TABLE
47 , a2 out nocopy JTF_VARCHAR2_TABLE_100
48 , a3 out nocopy JTF_VARCHAR2_TABLE_100
49 , a4 out nocopy JTF_NUMBER_TABLE
50 , a5 out nocopy JTF_NUMBER_TABLE
51 , a6 out nocopy JTF_VARCHAR2_TABLE_200
52 , a7 out nocopy JTF_NUMBER_TABLE
53 , a8 out nocopy JTF_VARCHAR2_TABLE_100
54 , a9 out nocopy JTF_NUMBER_TABLE
55 , a10 out nocopy JTF_NUMBER_TABLE
56 , a11 out nocopy JTF_DATE_TABLE
57 , a12 out nocopy JTF_DATE_TABLE
58 , a13 out nocopy JTF_VARCHAR2_TABLE_2000
59 , a14 out nocopy JTF_VARCHAR2_TABLE_2000
60 , a15 out nocopy JTF_NUMBER_TABLE
61 , a16 out nocopy JTF_VARCHAR2_TABLE_100
62 , a17 out nocopy JTF_NUMBER_TABLE
63 , a18 out nocopy JTF_VARCHAR2_TABLE_300
64 , a19 out nocopy JTF_VARCHAR2_TABLE_100
65 , a20 out nocopy JTF_NUMBER_TABLE
66 , a21 out nocopy JTF_NUMBER_TABLE
67 , a22 out nocopy JTF_NUMBER_TABLE
68 );
69
70 procedure getcalendarlist(p_api_version NUMBER
71 , p_init_msg_list VARCHAR2
72 , p_validation_level NUMBER
73 , x_return_status out nocopy VARCHAR2
74 , x_msg_count out nocopy NUMBER
75 , x_msg_data out nocopy VARCHAR2
76 , p_resourceid in out nocopy NUMBER
77 , p_resourcetype in out nocopy VARCHAR2
78 , p_userid NUMBER
79 , p9_a0 out nocopy JTF_NUMBER_TABLE
80 , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
81 , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
82 , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
83 );
84 procedure getview(p_api_version NUMBER
85 , p_init_msg_list VARCHAR2
86 , p_validation_level NUMBER
87 , x_return_status out nocopy VARCHAR2
88 , x_msg_count out nocopy NUMBER
89 , x_msg_data out nocopy VARCHAR2
90 , p6_a0 NUMBER
91 , p6_a1 NUMBER
92 , p6_a2 VARCHAR2
93 , p6_a3 NUMBER
94 , p6_a4 VARCHAR2
95 , p6_a5 DATE
96 , p6_a6 NUMBER
97 , p7_a0 out nocopy JTF_NUMBER_TABLE
98 , p7_a1 out nocopy JTF_NUMBER_TABLE
99 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
100 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
101 , p7_a4 out nocopy JTF_NUMBER_TABLE
102 , p7_a5 out nocopy JTF_NUMBER_TABLE
103 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
104 , p7_a7 out nocopy JTF_NUMBER_TABLE
105 , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
106 , p7_a9 out nocopy JTF_NUMBER_TABLE
107 , p7_a10 out nocopy JTF_NUMBER_TABLE
108 , p7_a11 out nocopy JTF_DATE_TABLE
109 , p7_a12 out nocopy JTF_DATE_TABLE
110 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
111 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
112 , p7_a15 out nocopy JTF_NUMBER_TABLE
113 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
114 , p7_a17 out nocopy JTF_NUMBER_TABLE
115 , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
116 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
117 , p7_a20 out nocopy JTF_NUMBER_TABLE
118 , p7_a21 out nocopy JTF_NUMBER_TABLE
119 , p7_a22 out nocopy JTF_NUMBER_TABLE
120 , p8_a0 out nocopy NUMBER
121 , p8_a1 out nocopy VARCHAR2
122 , p8_a2 out nocopy VARCHAR2
123 , p8_a3 out nocopy VARCHAR2
124 , p8_a4 out nocopy VARCHAR2
125 , p8_a5 out nocopy VARCHAR2
126 , p8_a6 out nocopy NUMBER
127 , p8_a7 out nocopy NUMBER
128 , p8_a8 out nocopy NUMBER
129 , p8_a9 out nocopy NUMBER
130 , p8_a10 out nocopy DATE
131 , p8_a11 out nocopy DATE
132 , p8_a12 out nocopy DATE
133 , p8_a13 out nocopy VARCHAR2
134 , p8_a14 out nocopy VARCHAR2
135 , p8_a15 out nocopy VARCHAR2
136 , p8_a16 out nocopy VARCHAR2
137 , p8_a17 out nocopy VARCHAR2
138 , p8_a18 out nocopy VARCHAR2
139 , p8_a19 out nocopy VARCHAR2
140 , p8_a20 out nocopy VARCHAR2
141 );
142 end jtf_cal_pvt_w;