DBA Data[Home] [Help]

PACKAGE: APPS.OKL_CURE_VNDR_RFND_PVT_W

Source


1 package okl_cure_vndr_rfnd_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLERFSS.pls 115.0 2003/04/25 04:15:50 smereddy noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy okl_cure_vndr_rfnd_pvt.cure_rfnd_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_200
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_200
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_VARCHAR2_TABLE_200
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_NUMBER_TABLE
19     );
20   procedure rosetta_table_copy_out_p1(t okl_cure_vndr_rfnd_pvt.cure_rfnd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
21     , a1 out nocopy JTF_NUMBER_TABLE
22     , a2 out nocopy JTF_NUMBER_TABLE
23     , a3 out nocopy JTF_NUMBER_TABLE
24     , a4 out nocopy JTF_VARCHAR2_TABLE_100
25     , a5 out nocopy JTF_VARCHAR2_TABLE_200
26     , a6 out nocopy JTF_NUMBER_TABLE
27     , a7 out nocopy JTF_VARCHAR2_TABLE_200
28     , a8 out nocopy JTF_NUMBER_TABLE
29     , a9 out nocopy JTF_NUMBER_TABLE
30     , a10 out nocopy JTF_VARCHAR2_TABLE_200
31     , a11 out nocopy JTF_NUMBER_TABLE
32     , a12 out nocopy JTF_NUMBER_TABLE
33     , a13 out nocopy JTF_NUMBER_TABLE
34     , a14 out nocopy JTF_NUMBER_TABLE
35     , a15 out nocopy JTF_NUMBER_TABLE
36     );
37 
38   procedure create_cure_refund(p_api_version  NUMBER
39     , p_init_msg_list  VARCHAR2
40     , x_return_status out nocopy  VARCHAR2
41     , x_msg_count out nocopy  NUMBER
42     , x_msg_data out nocopy  VARCHAR2
43     , p5_a0 JTF_NUMBER_TABLE
44     , p5_a1 JTF_NUMBER_TABLE
45     , p5_a2 JTF_NUMBER_TABLE
46     , p5_a3 JTF_NUMBER_TABLE
47     , p5_a4 JTF_VARCHAR2_TABLE_100
48     , p5_a5 JTF_VARCHAR2_TABLE_200
49     , p5_a6 JTF_NUMBER_TABLE
50     , p5_a7 JTF_VARCHAR2_TABLE_200
51     , p5_a8 JTF_NUMBER_TABLE
52     , p5_a9 JTF_NUMBER_TABLE
53     , p5_a10 JTF_VARCHAR2_TABLE_200
54     , p5_a11 JTF_NUMBER_TABLE
55     , p5_a12 JTF_NUMBER_TABLE
56     , p5_a13 JTF_NUMBER_TABLE
57     , p5_a14 JTF_NUMBER_TABLE
58     , p5_a15 JTF_NUMBER_TABLE
59     , p6_a0 out nocopy JTF_NUMBER_TABLE
60     , p6_a1 out nocopy JTF_NUMBER_TABLE
61     , p6_a2 out nocopy JTF_NUMBER_TABLE
62     , p6_a3 out nocopy JTF_NUMBER_TABLE
63     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
64     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
65     , p6_a6 out nocopy JTF_NUMBER_TABLE
66     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
67     , p6_a8 out nocopy JTF_NUMBER_TABLE
68     , p6_a9 out nocopy JTF_NUMBER_TABLE
69     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
70     , p6_a11 out nocopy JTF_NUMBER_TABLE
71     , p6_a12 out nocopy JTF_NUMBER_TABLE
72     , p6_a13 out nocopy JTF_NUMBER_TABLE
73     , p6_a14 out nocopy JTF_NUMBER_TABLE
74     , p6_a15 out nocopy JTF_NUMBER_TABLE
75   );
76   procedure update_cure_refund(p_api_version  NUMBER
77     , p_init_msg_list  VARCHAR2
78     , x_return_status out nocopy  VARCHAR2
79     , x_msg_count out nocopy  NUMBER
80     , x_msg_data out nocopy  VARCHAR2
81     , p5_a0 JTF_NUMBER_TABLE
82     , p5_a1 JTF_NUMBER_TABLE
83     , p5_a2 JTF_NUMBER_TABLE
84     , p5_a3 JTF_NUMBER_TABLE
85     , p5_a4 JTF_VARCHAR2_TABLE_100
86     , p5_a5 JTF_VARCHAR2_TABLE_200
87     , p5_a6 JTF_NUMBER_TABLE
88     , p5_a7 JTF_VARCHAR2_TABLE_200
89     , p5_a8 JTF_NUMBER_TABLE
90     , p5_a9 JTF_NUMBER_TABLE
91     , p5_a10 JTF_VARCHAR2_TABLE_200
92     , p5_a11 JTF_NUMBER_TABLE
93     , p5_a12 JTF_NUMBER_TABLE
94     , p5_a13 JTF_NUMBER_TABLE
95     , p5_a14 JTF_NUMBER_TABLE
96     , p5_a15 JTF_NUMBER_TABLE
97     , p6_a0 out nocopy JTF_NUMBER_TABLE
98     , p6_a1 out nocopy JTF_NUMBER_TABLE
99     , p6_a2 out nocopy JTF_NUMBER_TABLE
100     , p6_a3 out nocopy JTF_NUMBER_TABLE
101     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
102     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
103     , p6_a6 out nocopy JTF_NUMBER_TABLE
104     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
105     , p6_a8 out nocopy JTF_NUMBER_TABLE
106     , p6_a9 out nocopy JTF_NUMBER_TABLE
107     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
108     , p6_a11 out nocopy JTF_NUMBER_TABLE
109     , p6_a12 out nocopy JTF_NUMBER_TABLE
110     , p6_a13 out nocopy JTF_NUMBER_TABLE
111     , p6_a14 out nocopy JTF_NUMBER_TABLE
112     , p6_a15 out nocopy JTF_NUMBER_TABLE
113   );
114   procedure delete_cure_refund(p_api_version  NUMBER
115     , p_init_msg_list  VARCHAR2
116     , x_return_status out nocopy  VARCHAR2
117     , x_msg_count out nocopy  NUMBER
118     , x_msg_data out nocopy  VARCHAR2
119     , p5_a0 JTF_NUMBER_TABLE
120     , p5_a1 JTF_NUMBER_TABLE
121     , p5_a2 JTF_NUMBER_TABLE
122     , p5_a3 JTF_NUMBER_TABLE
123     , p5_a4 JTF_VARCHAR2_TABLE_100
124     , p5_a5 JTF_VARCHAR2_TABLE_200
125     , p5_a6 JTF_NUMBER_TABLE
126     , p5_a7 JTF_VARCHAR2_TABLE_200
127     , p5_a8 JTF_NUMBER_TABLE
128     , p5_a9 JTF_NUMBER_TABLE
129     , p5_a10 JTF_VARCHAR2_TABLE_200
130     , p5_a11 JTF_NUMBER_TABLE
131     , p5_a12 JTF_NUMBER_TABLE
132     , p5_a13 JTF_NUMBER_TABLE
133     , p5_a14 JTF_NUMBER_TABLE
134     , p5_a15 JTF_NUMBER_TABLE
135   );
136 end okl_cure_vndr_rfnd_pvt_w;