[Home] [Help]
PACKAGE: APPS.IEX_STATUS_RULE_PUB_W
Source
1 package iex_status_rule_pub_w AUTHID CURRENT_USER as
2 /* $Header: iexwcsts.pls 120.1 2005/07/06 14:10:27 schekuri noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy iex_status_rule_pub.status_rule_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_200
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 );
17 procedure rosetta_table_copy_out_p1(t iex_status_rule_pub.status_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18 , a1 out nocopy JTF_VARCHAR2_TABLE_100
19 , a2 out nocopy JTF_VARCHAR2_TABLE_200
20 , a3 out nocopy JTF_DATE_TABLE
21 , a4 out nocopy JTF_DATE_TABLE
22 , a5 out nocopy JTF_DATE_TABLE
23 , a6 out nocopy JTF_NUMBER_TABLE
24 , a7 out nocopy JTF_DATE_TABLE
25 , a8 out nocopy JTF_NUMBER_TABLE
26 , a9 out nocopy JTF_NUMBER_TABLE
27 , a10 out nocopy JTF_NUMBER_TABLE
28 , a11 out nocopy JTF_NUMBER_TABLE
29 , a12 out nocopy JTF_NUMBER_TABLE
30 );
31
32 procedure rosetta_table_copy_in_p3(t out nocopy iex_status_rule_pub.status_rule_line_tbl_type, a0 JTF_NUMBER_TABLE
33 , a1 JTF_VARCHAR2_TABLE_100
34 , a2 JTF_NUMBER_TABLE
35 , a3 JTF_VARCHAR2_TABLE_100
36 , a4 JTF_NUMBER_TABLE
37 , a5 JTF_DATE_TABLE
38 , a6 JTF_NUMBER_TABLE
39 , a7 JTF_DATE_TABLE
40 , a8 JTF_NUMBER_TABLE
41 , a9 JTF_NUMBER_TABLE
42 , a10 JTF_NUMBER_TABLE
43 , a11 JTF_NUMBER_TABLE
44 , a12 JTF_NUMBER_TABLE
45 );
46 procedure rosetta_table_copy_out_p3(t iex_status_rule_pub.status_rule_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47 , a1 out nocopy JTF_VARCHAR2_TABLE_100
48 , a2 out nocopy JTF_NUMBER_TABLE
49 , a3 out nocopy JTF_VARCHAR2_TABLE_100
50 , a4 out nocopy JTF_NUMBER_TABLE
51 , a5 out nocopy JTF_DATE_TABLE
52 , a6 out nocopy JTF_NUMBER_TABLE
53 , a7 out nocopy JTF_DATE_TABLE
54 , a8 out nocopy JTF_NUMBER_TABLE
55 , a9 out nocopy JTF_NUMBER_TABLE
56 , a10 out nocopy JTF_NUMBER_TABLE
57 , a11 out nocopy JTF_NUMBER_TABLE
58 , a12 out nocopy JTF_NUMBER_TABLE
59 );
60
61 procedure rosetta_table_copy_in_p4(t out nocopy iex_status_rule_pub.status_rule_id_tbl_type, a0 JTF_NUMBER_TABLE);
62 procedure rosetta_table_copy_out_p4(t iex_status_rule_pub.status_rule_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
63
64 procedure rosetta_table_copy_in_p5(t out nocopy iex_status_rule_pub.status_rule_line_id_tbl_type, a0 JTF_NUMBER_TABLE);
65 procedure rosetta_table_copy_out_p5(t iex_status_rule_pub.status_rule_line_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
66
67 procedure create_status_rule(p_api_version NUMBER
68 , p_init_msg_list VARCHAR2
69 , p_commit VARCHAR2
70 , x_dup_status out nocopy VARCHAR2
71 , x_return_status out nocopy VARCHAR2
72 , x_msg_count out nocopy NUMBER
73 , x_msg_data out nocopy VARCHAR2
74 , x_status_rule_id out nocopy NUMBER
75 , p3_a0 NUMBER := 0-1962.0724
76 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
77 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
78 , p3_a3 DATE := fnd_api.g_miss_date
79 , p3_a4 DATE := fnd_api.g_miss_date
80 , p3_a5 DATE := fnd_api.g_miss_date
81 , p3_a6 NUMBER := 0-1962.0724
82 , p3_a7 DATE := fnd_api.g_miss_date
83 , p3_a8 NUMBER := 0-1962.0724
84 , p3_a9 NUMBER := 0-1962.0724
85 , p3_a10 NUMBER := 0-1962.0724
86 , p3_a11 NUMBER := 0-1962.0724
87 , p3_a12 NUMBER := 0-1962.0724
88 );
89 procedure update_status_rule(p_api_version NUMBER
90 , p_init_msg_list VARCHAR2
91 , p_commit VARCHAR2
92 , p3_a0 JTF_NUMBER_TABLE
93 , p3_a1 JTF_VARCHAR2_TABLE_100
94 , p3_a2 JTF_VARCHAR2_TABLE_200
95 , p3_a3 JTF_DATE_TABLE
96 , p3_a4 JTF_DATE_TABLE
97 , p3_a5 JTF_DATE_TABLE
98 , p3_a6 JTF_NUMBER_TABLE
99 , p3_a7 JTF_DATE_TABLE
100 , p3_a8 JTF_NUMBER_TABLE
101 , p3_a9 JTF_NUMBER_TABLE
102 , p3_a10 JTF_NUMBER_TABLE
103 , p3_a11 JTF_NUMBER_TABLE
104 , p3_a12 JTF_NUMBER_TABLE
105 , x_dup_status out nocopy VARCHAR2
106 , x_return_status out nocopy VARCHAR2
107 , x_msg_count out nocopy NUMBER
108 , x_msg_data out nocopy VARCHAR2
109 );
110 procedure delete_status_rule(p_api_version NUMBER
111 , p_init_msg_list VARCHAR2
112 , p_commit VARCHAR2
113 , p_status_rule_id_tbl JTF_NUMBER_TABLE
114 , x_return_status out nocopy VARCHAR2
115 , x_msg_count out nocopy NUMBER
116 , x_msg_data out nocopy VARCHAR2
117 );
118 procedure create_status_rule_line(p_api_version NUMBER
119 , p_init_msg_list VARCHAR2
120 , p_commit VARCHAR2
121 , x_return_status out nocopy VARCHAR2
122 , x_msg_count out nocopy NUMBER
123 , x_msg_data out nocopy VARCHAR2
124 , p3_a0 NUMBER := 0-1962.0724
125 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
126 , p3_a2 NUMBER := 0-1962.0724
127 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
128 , p3_a4 NUMBER := 0-1962.0724
129 , p3_a5 DATE := fnd_api.g_miss_date
130 , p3_a6 NUMBER := 0-1962.0724
131 , p3_a7 DATE := fnd_api.g_miss_date
132 , p3_a8 NUMBER := 0-1962.0724
133 , p3_a9 NUMBER := 0-1962.0724
134 , p3_a10 NUMBER := 0-1962.0724
135 , p3_a11 NUMBER := 0-1962.0724
136 , p3_a12 NUMBER := 0-1962.0724
137 );
138 procedure update_status_rule_line(p_api_version NUMBER
139 , p_init_msg_list VARCHAR2
140 , p_commit VARCHAR2
141 , p3_a0 JTF_NUMBER_TABLE
142 , p3_a1 JTF_VARCHAR2_TABLE_100
143 , p3_a2 JTF_NUMBER_TABLE
144 , p3_a3 JTF_VARCHAR2_TABLE_100
145 , p3_a4 JTF_NUMBER_TABLE
146 , p3_a5 JTF_DATE_TABLE
147 , p3_a6 JTF_NUMBER_TABLE
148 , p3_a7 JTF_DATE_TABLE
149 , p3_a8 JTF_NUMBER_TABLE
150 , p3_a9 JTF_NUMBER_TABLE
151 , p3_a10 JTF_NUMBER_TABLE
152 , p3_a11 JTF_NUMBER_TABLE
153 , p3_a12 JTF_NUMBER_TABLE
154 , x_dup_status out nocopy VARCHAR2
155 , x_return_status out nocopy VARCHAR2
156 , x_msg_count out nocopy NUMBER
157 , x_msg_data out nocopy VARCHAR2
158 );
159 procedure delete_status_rule_line(p_api_version NUMBER
160 , p_init_msg_list VARCHAR2
161 , p_commit VARCHAR2
162 , p_status_rule_id NUMBER
163 , p_status_rule_line_id_tbl JTF_NUMBER_TABLE
164 , x_return_status out nocopy VARCHAR2
165 , x_msg_count out nocopy NUMBER
166 , x_msg_data out nocopy VARCHAR2
167 );
168 end iex_status_rule_pub_w;