DBA Data[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;