DBA Data[Home] [Help]

PACKAGE: APPS.OKL_ECC_DEF_PVT_W

Source


1 package okl_ecc_def_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLEECCS.pls 120.1 2005/10/30 04:58:24 appldev noship $ */
3   procedure create_ecc(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , x_return_status out nocopy  VARCHAR2
6     , x_msg_count out nocopy  NUMBER
7     , x_msg_data out nocopy  VARCHAR2
8     , p5_a0  NUMBER
9     , p5_a1  NUMBER
10     , p5_a2  VARCHAR2
11     , p5_a3  NUMBER
12     , p5_a4  VARCHAR2
13     , p5_a5  VARCHAR2
14     , p5_a6  VARCHAR2
15     , p5_a7  VARCHAR2
16     , p5_a8  VARCHAR2
17     , p5_a9  VARCHAR2
18     , p5_a10  VARCHAR2
19     , p5_a11  NUMBER
20     , p5_a12  VARCHAR2
21     , p5_a13  VARCHAR2
22     , p5_a14  NUMBER
23     , p5_a15  DATE
24     , p5_a16  NUMBER
25     , p5_a17  DATE
26     , p5_a18  NUMBER
27     , p6_a0 out nocopy  NUMBER
28     , p6_a1 out nocopy  NUMBER
29     , p6_a2 out nocopy  VARCHAR2
30     , p6_a3 out nocopy  NUMBER
31     , p6_a4 out nocopy  VARCHAR2
32     , p6_a5 out nocopy  VARCHAR2
33     , p6_a6 out nocopy  VARCHAR2
34     , p6_a7 out nocopy  VARCHAR2
35     , p6_a8 out nocopy  VARCHAR2
36     , p6_a9 out nocopy  VARCHAR2
37     , p6_a10 out nocopy  VARCHAR2
38     , p6_a11 out nocopy  NUMBER
39     , p6_a12 out nocopy  VARCHAR2
40     , p6_a13 out nocopy  VARCHAR2
41     , p6_a14 out nocopy  NUMBER
42     , p6_a15 out nocopy  DATE
43     , p6_a16 out nocopy  NUMBER
44     , p6_a17 out nocopy  DATE
45     , p6_a18 out nocopy  NUMBER
46     , p7_a0 JTF_NUMBER_TABLE
47     , p7_a1 JTF_NUMBER_TABLE
48     , p7_a2 JTF_NUMBER_TABLE
49     , p7_a3 JTF_VARCHAR2_TABLE_100
50     , p7_a4 JTF_VARCHAR2_TABLE_100
51     , p7_a5 JTF_NUMBER_TABLE
52     , p7_a6 JTF_DATE_TABLE
53     , p7_a7 JTF_NUMBER_TABLE
54     , p7_a8 JTF_DATE_TABLE
55     , p7_a9 JTF_NUMBER_TABLE
56     , p8_a0 out nocopy JTF_NUMBER_TABLE
57     , p8_a1 out nocopy JTF_NUMBER_TABLE
58     , p8_a2 out nocopy JTF_NUMBER_TABLE
59     , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
60     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
61     , p8_a5 out nocopy JTF_NUMBER_TABLE
62     , p8_a6 out nocopy JTF_DATE_TABLE
63     , p8_a7 out nocopy JTF_NUMBER_TABLE
64     , p8_a8 out nocopy JTF_DATE_TABLE
65     , p8_a9 out nocopy JTF_NUMBER_TABLE
66   );
67   procedure update_ecc(p_api_version  NUMBER
68     , p_init_msg_list  VARCHAR2
69     , x_return_status out nocopy  VARCHAR2
70     , x_msg_count out nocopy  NUMBER
71     , x_msg_data out nocopy  VARCHAR2
72     , p5_a0  NUMBER
73     , p5_a1  NUMBER
74     , p5_a2  VARCHAR2
75     , p5_a3  NUMBER
76     , p5_a4  VARCHAR2
77     , p5_a5  VARCHAR2
78     , p5_a6  VARCHAR2
79     , p5_a7  VARCHAR2
80     , p5_a8  VARCHAR2
81     , p5_a9  VARCHAR2
82     , p5_a10  VARCHAR2
83     , p5_a11  NUMBER
84     , p5_a12  VARCHAR2
85     , p5_a13  VARCHAR2
86     , p5_a14  NUMBER
87     , p5_a15  DATE
88     , p5_a16  NUMBER
89     , p5_a17  DATE
90     , p5_a18  NUMBER
91     , p6_a0 out nocopy  NUMBER
92     , p6_a1 out nocopy  NUMBER
93     , p6_a2 out nocopy  VARCHAR2
94     , p6_a3 out nocopy  NUMBER
95     , p6_a4 out nocopy  VARCHAR2
96     , p6_a5 out nocopy  VARCHAR2
97     , p6_a6 out nocopy  VARCHAR2
98     , p6_a7 out nocopy  VARCHAR2
99     , p6_a8 out nocopy  VARCHAR2
100     , p6_a9 out nocopy  VARCHAR2
101     , p6_a10 out nocopy  VARCHAR2
102     , p6_a11 out nocopy  NUMBER
103     , p6_a12 out nocopy  VARCHAR2
104     , p6_a13 out nocopy  VARCHAR2
105     , p6_a14 out nocopy  NUMBER
106     , p6_a15 out nocopy  DATE
107     , p6_a16 out nocopy  NUMBER
108     , p6_a17 out nocopy  DATE
109     , p6_a18 out nocopy  NUMBER
110     , p7_a0 JTF_NUMBER_TABLE
111     , p7_a1 JTF_NUMBER_TABLE
112     , p7_a2 JTF_NUMBER_TABLE
113     , p7_a3 JTF_VARCHAR2_TABLE_100
114     , p7_a4 JTF_VARCHAR2_TABLE_100
115     , p7_a5 JTF_NUMBER_TABLE
116     , p7_a6 JTF_DATE_TABLE
117     , p7_a7 JTF_NUMBER_TABLE
118     , p7_a8 JTF_DATE_TABLE
119     , p7_a9 JTF_NUMBER_TABLE
120     , p8_a0 out nocopy JTF_NUMBER_TABLE
121     , p8_a1 out nocopy JTF_NUMBER_TABLE
122     , p8_a2 out nocopy JTF_NUMBER_TABLE
123     , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
124     , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
125     , p8_a5 out nocopy JTF_NUMBER_TABLE
126     , p8_a6 out nocopy JTF_DATE_TABLE
127     , p8_a7 out nocopy JTF_NUMBER_TABLE
128     , p8_a8 out nocopy JTF_DATE_TABLE
129     , p8_a9 out nocopy JTF_NUMBER_TABLE
130   );
131 end okl_ecc_def_pvt_w;