77: , p8_a1 NUMBER
78: , p8_a2 NUMBER
79: , x_rule_id OUT NOCOPY NUMBER
80: , p7_a0 NUMBER := 0-1962.0724
81: , p7_a1 DATE := fnd_api.g_miss_date
82: , p7_a2 NUMBER := 0-1962.0724
83: , p7_a3 DATE := fnd_api.g_miss_date
84: , p7_a4 NUMBER := 0-1962.0724
85: , p7_a5 NUMBER := 0-1962.0724
79: , x_rule_id OUT NOCOPY NUMBER
80: , p7_a0 NUMBER := 0-1962.0724
81: , p7_a1 DATE := fnd_api.g_miss_date
82: , p7_a2 NUMBER := 0-1962.0724
83: , p7_a3 DATE := fnd_api.g_miss_date
84: , p7_a4 NUMBER := 0-1962.0724
85: , p7_a5 NUMBER := 0-1962.0724
86: , p7_a6 NUMBER := 0-1962.0724
87: , p7_a7 NUMBER := 0-1962.0724
87: , p7_a7 NUMBER := 0-1962.0724
88: , p7_a8 NUMBER := 0-1962.0724
89: , p7_a9 NUMBER := 0-1962.0724
90: , p7_a10 NUMBER := 0-1962.0724
91: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a14 NUMBER := 0-1962.0724
95: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a8 NUMBER := 0-1962.0724
89: , p7_a9 NUMBER := 0-1962.0724
90: , p7_a10 NUMBER := 0-1962.0724
91: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a14 NUMBER := 0-1962.0724
95: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a9 NUMBER := 0-1962.0724
90: , p7_a10 NUMBER := 0-1962.0724
91: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a14 NUMBER := 0-1962.0724
95: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a17 NUMBER := 0-1962.0724
91: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a14 NUMBER := 0-1962.0724
95: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a17 NUMBER := 0-1962.0724
98: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a14 NUMBER := 0-1962.0724
95: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a17 NUMBER := 0-1962.0724
98: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a14 NUMBER := 0-1962.0724
95: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a17 NUMBER := 0-1962.0724
98: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a17 NUMBER := 0-1962.0724
98: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a17 NUMBER := 0-1962.0724
98: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a17 NUMBER := 0-1962.0724
98: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
108: );
101: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
108: );
109: procedure update_ps_rule(p_api_version_number NUMBER
102: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
108: );
109: procedure update_ps_rule(p_api_version_number NUMBER
110: , p_init_msg_list VARCHAR2
103: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
108: );
109: procedure update_ps_rule(p_api_version_number NUMBER
110: , p_init_msg_list VARCHAR2
111: , p_commit VARCHAR2
121: , p10_a0 JTF_VARCHAR2_TABLE_100
122: , p10_a1 JTF_VARCHAR2_TABLE_100
123: , x_object_version_number OUT NOCOPY NUMBER
124: , p7_a0 NUMBER := 0-1962.0724
125: , p7_a1 DATE := fnd_api.g_miss_date
126: , p7_a2 NUMBER := 0-1962.0724
127: , p7_a3 DATE := fnd_api.g_miss_date
128: , p7_a4 NUMBER := 0-1962.0724
129: , p7_a5 NUMBER := 0-1962.0724
123: , x_object_version_number OUT NOCOPY NUMBER
124: , p7_a0 NUMBER := 0-1962.0724
125: , p7_a1 DATE := fnd_api.g_miss_date
126: , p7_a2 NUMBER := 0-1962.0724
127: , p7_a3 DATE := fnd_api.g_miss_date
128: , p7_a4 NUMBER := 0-1962.0724
129: , p7_a5 NUMBER := 0-1962.0724
130: , p7_a6 NUMBER := 0-1962.0724
131: , p7_a7 NUMBER := 0-1962.0724
131: , p7_a7 NUMBER := 0-1962.0724
132: , p7_a8 NUMBER := 0-1962.0724
133: , p7_a9 NUMBER := 0-1962.0724
134: , p7_a10 NUMBER := 0-1962.0724
135: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a14 NUMBER := 0-1962.0724
139: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
132: , p7_a8 NUMBER := 0-1962.0724
133: , p7_a9 NUMBER := 0-1962.0724
134: , p7_a10 NUMBER := 0-1962.0724
135: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a14 NUMBER := 0-1962.0724
139: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a9 NUMBER := 0-1962.0724
134: , p7_a10 NUMBER := 0-1962.0724
135: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a14 NUMBER := 0-1962.0724
139: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a17 NUMBER := 0-1962.0724
135: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a14 NUMBER := 0-1962.0724
139: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a17 NUMBER := 0-1962.0724
142: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a14 NUMBER := 0-1962.0724
139: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a17 NUMBER := 0-1962.0724
142: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a14 NUMBER := 0-1962.0724
139: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a17 NUMBER := 0-1962.0724
142: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a17 NUMBER := 0-1962.0724
142: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a17 NUMBER := 0-1962.0724
142: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a17 NUMBER := 0-1962.0724
142: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
152: );
145: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
152: );
153: procedure update_ps_rule_alt(p_api_version_number NUMBER
146: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
152: );
153: procedure update_ps_rule_alt(p_api_version_number NUMBER
154: , p_init_msg_list VARCHAR2
147: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
150: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
151: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
152: );
153: procedure update_ps_rule_alt(p_api_version_number NUMBER
154: , p_init_msg_list VARCHAR2
155: , p_commit VARCHAR2
167: , p_vistype_change number
168: , p_rem_change number
169: , x_object_version_number OUT NOCOPY NUMBER
170: , p7_a0 NUMBER := 0-1962.0724
171: , p7_a1 DATE := fnd_api.g_miss_date
172: , p7_a2 NUMBER := 0-1962.0724
173: , p7_a3 DATE := fnd_api.g_miss_date
174: , p7_a4 NUMBER := 0-1962.0724
175: , p7_a5 NUMBER := 0-1962.0724
169: , x_object_version_number OUT NOCOPY NUMBER
170: , p7_a0 NUMBER := 0-1962.0724
171: , p7_a1 DATE := fnd_api.g_miss_date
172: , p7_a2 NUMBER := 0-1962.0724
173: , p7_a3 DATE := fnd_api.g_miss_date
174: , p7_a4 NUMBER := 0-1962.0724
175: , p7_a5 NUMBER := 0-1962.0724
176: , p7_a6 NUMBER := 0-1962.0724
177: , p7_a7 NUMBER := 0-1962.0724
177: , p7_a7 NUMBER := 0-1962.0724
178: , p7_a8 NUMBER := 0-1962.0724
179: , p7_a9 NUMBER := 0-1962.0724
180: , p7_a10 NUMBER := 0-1962.0724
181: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a14 NUMBER := 0-1962.0724
185: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
178: , p7_a8 NUMBER := 0-1962.0724
179: , p7_a9 NUMBER := 0-1962.0724
180: , p7_a10 NUMBER := 0-1962.0724
181: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a14 NUMBER := 0-1962.0724
185: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
186: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
179: , p7_a9 NUMBER := 0-1962.0724
180: , p7_a10 NUMBER := 0-1962.0724
181: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a14 NUMBER := 0-1962.0724
185: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
186: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
187: , p7_a17 NUMBER := 0-1962.0724
181: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a14 NUMBER := 0-1962.0724
185: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
186: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
187: , p7_a17 NUMBER := 0-1962.0724
188: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
189: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
182: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
183: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a14 NUMBER := 0-1962.0724
185: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
186: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
187: , p7_a17 NUMBER := 0-1962.0724
188: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
189: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
190: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
184: , p7_a14 NUMBER := 0-1962.0724
185: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
186: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
187: , p7_a17 NUMBER := 0-1962.0724
188: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
189: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
190: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
185: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
186: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
187: , p7_a17 NUMBER := 0-1962.0724
188: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
189: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
190: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
186: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
187: , p7_a17 NUMBER := 0-1962.0724
188: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
189: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
190: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
187: , p7_a17 NUMBER := 0-1962.0724
188: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
189: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
190: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
188: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
189: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
190: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
196: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
189: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
190: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
196: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
197: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
190: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
191: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
196: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
197: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
198: );
191: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
192: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
196: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
197: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
198: );
199: procedure delete_ps_rule_alt(p_api_version_number NUMBER
192: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
193: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
196: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
197: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
198: );
199: procedure delete_ps_rule_alt(p_api_version_number NUMBER
200: , p_init_msg_list VARCHAR2
193: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
194: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
195: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
196: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
197: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
198: );
199: procedure delete_ps_rule_alt(p_api_version_number NUMBER
200: , p_init_msg_list VARCHAR2
201: , p_commit VARCHAR2
204: , x_msg_count OUT NOCOPY NUMBER
205: , x_msg_data OUT NOCOPY VARCHAR2
206: , p_object_version_number NUMBER
207: , p7_a0 NUMBER := 0-1962.0724
208: , p7_a1 DATE := fnd_api.g_miss_date
209: , p7_a2 NUMBER := 0-1962.0724
210: , p7_a3 DATE := fnd_api.g_miss_date
211: , p7_a4 NUMBER := 0-1962.0724
212: , p7_a5 NUMBER := 0-1962.0724
206: , p_object_version_number NUMBER
207: , p7_a0 NUMBER := 0-1962.0724
208: , p7_a1 DATE := fnd_api.g_miss_date
209: , p7_a2 NUMBER := 0-1962.0724
210: , p7_a3 DATE := fnd_api.g_miss_date
211: , p7_a4 NUMBER := 0-1962.0724
212: , p7_a5 NUMBER := 0-1962.0724
213: , p7_a6 NUMBER := 0-1962.0724
214: , p7_a7 NUMBER := 0-1962.0724
214: , p7_a7 NUMBER := 0-1962.0724
215: , p7_a8 NUMBER := 0-1962.0724
216: , p7_a9 NUMBER := 0-1962.0724
217: , p7_a10 NUMBER := 0-1962.0724
218: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a14 NUMBER := 0-1962.0724
222: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
215: , p7_a8 NUMBER := 0-1962.0724
216: , p7_a9 NUMBER := 0-1962.0724
217: , p7_a10 NUMBER := 0-1962.0724
218: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a14 NUMBER := 0-1962.0724
222: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
216: , p7_a9 NUMBER := 0-1962.0724
217: , p7_a10 NUMBER := 0-1962.0724
218: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a14 NUMBER := 0-1962.0724
222: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a17 NUMBER := 0-1962.0724
218: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a14 NUMBER := 0-1962.0724
222: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a17 NUMBER := 0-1962.0724
225: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
219: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
220: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a14 NUMBER := 0-1962.0724
222: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a17 NUMBER := 0-1962.0724
225: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
221: , p7_a14 NUMBER := 0-1962.0724
222: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a17 NUMBER := 0-1962.0724
225: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
222: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a17 NUMBER := 0-1962.0724
225: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
223: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a17 NUMBER := 0-1962.0724
225: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
224: , p7_a17 NUMBER := 0-1962.0724
225: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
225: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
226: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
227: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
228: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
235: );
228: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
229: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
235: );
236: procedure validate_ps_rule(p_api_version_number NUMBER
229: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
235: );
236: procedure validate_ps_rule(p_api_version_number NUMBER
237: , p_init_msg_list VARCHAR2
230: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
231: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
235: );
236: procedure validate_ps_rule(p_api_version_number NUMBER
237: , p_init_msg_list VARCHAR2
238: , p_validation_level NUMBER
239: , x_return_status OUT NOCOPY VARCHAR2
240: , x_msg_count OUT NOCOPY NUMBER
241: , x_msg_data OUT NOCOPY VARCHAR2
242: , p3_a0 NUMBER := 0-1962.0724
243: , p3_a1 DATE := fnd_api.g_miss_date
244: , p3_a2 NUMBER := 0-1962.0724
245: , p3_a3 DATE := fnd_api.g_miss_date
246: , p3_a4 NUMBER := 0-1962.0724
247: , p3_a5 NUMBER := 0-1962.0724
241: , x_msg_data OUT NOCOPY VARCHAR2
242: , p3_a0 NUMBER := 0-1962.0724
243: , p3_a1 DATE := fnd_api.g_miss_date
244: , p3_a2 NUMBER := 0-1962.0724
245: , p3_a3 DATE := fnd_api.g_miss_date
246: , p3_a4 NUMBER := 0-1962.0724
247: , p3_a5 NUMBER := 0-1962.0724
248: , p3_a6 NUMBER := 0-1962.0724
249: , p3_a7 NUMBER := 0-1962.0724
249: , p3_a7 NUMBER := 0-1962.0724
250: , p3_a8 NUMBER := 0-1962.0724
251: , p3_a9 NUMBER := 0-1962.0724
252: , p3_a10 NUMBER := 0-1962.0724
253: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p3_a14 NUMBER := 0-1962.0724
257: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
250: , p3_a8 NUMBER := 0-1962.0724
251: , p3_a9 NUMBER := 0-1962.0724
252: , p3_a10 NUMBER := 0-1962.0724
253: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p3_a14 NUMBER := 0-1962.0724
257: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
258: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
251: , p3_a9 NUMBER := 0-1962.0724
252: , p3_a10 NUMBER := 0-1962.0724
253: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p3_a14 NUMBER := 0-1962.0724
257: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
258: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p3_a17 NUMBER := 0-1962.0724
253: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
254: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p3_a14 NUMBER := 0-1962.0724
257: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
258: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p3_a17 NUMBER := 0-1962.0724
260: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
261: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
254: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
255: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
256: , p3_a14 NUMBER := 0-1962.0724
257: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
258: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p3_a17 NUMBER := 0-1962.0724
260: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
261: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
256: , p3_a14 NUMBER := 0-1962.0724
257: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
258: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p3_a17 NUMBER := 0-1962.0724
260: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
261: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
257: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
258: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p3_a17 NUMBER := 0-1962.0724
260: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
261: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
258: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
259: , p3_a17 NUMBER := 0-1962.0724
260: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
261: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
259: , p3_a17 NUMBER := 0-1962.0724
260: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
261: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
260: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
261: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
261: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
262: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
269: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
262: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
263: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
269: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
270: );
263: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
264: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
269: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
270: );
271: procedure check_ps_rules_items(p_validation_mode VARCHAR2
264: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
265: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
269: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
270: );
271: procedure check_ps_rules_items(p_validation_mode VARCHAR2
272: , x_return_status OUT NOCOPY VARCHAR2
265: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
266: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
267: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
268: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
269: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
270: );
271: procedure check_ps_rules_items(p_validation_mode VARCHAR2
272: , x_return_status OUT NOCOPY VARCHAR2
273: , p0_a0 NUMBER := 0-1962.0724
270: );
271: procedure check_ps_rules_items(p_validation_mode VARCHAR2
272: , x_return_status OUT NOCOPY VARCHAR2
273: , p0_a0 NUMBER := 0-1962.0724
274: , p0_a1 DATE := fnd_api.g_miss_date
275: , p0_a2 NUMBER := 0-1962.0724
276: , p0_a3 DATE := fnd_api.g_miss_date
277: , p0_a4 NUMBER := 0-1962.0724
278: , p0_a5 NUMBER := 0-1962.0724
272: , x_return_status OUT NOCOPY VARCHAR2
273: , p0_a0 NUMBER := 0-1962.0724
274: , p0_a1 DATE := fnd_api.g_miss_date
275: , p0_a2 NUMBER := 0-1962.0724
276: , p0_a3 DATE := fnd_api.g_miss_date
277: , p0_a4 NUMBER := 0-1962.0724
278: , p0_a5 NUMBER := 0-1962.0724
279: , p0_a6 NUMBER := 0-1962.0724
280: , p0_a7 NUMBER := 0-1962.0724
280: , p0_a7 NUMBER := 0-1962.0724
281: , p0_a8 NUMBER := 0-1962.0724
282: , p0_a9 NUMBER := 0-1962.0724
283: , p0_a10 NUMBER := 0-1962.0724
284: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a14 NUMBER := 0-1962.0724
288: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
281: , p0_a8 NUMBER := 0-1962.0724
282: , p0_a9 NUMBER := 0-1962.0724
283: , p0_a10 NUMBER := 0-1962.0724
284: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a14 NUMBER := 0-1962.0724
288: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
282: , p0_a9 NUMBER := 0-1962.0724
283: , p0_a10 NUMBER := 0-1962.0724
284: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a14 NUMBER := 0-1962.0724
288: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a17 NUMBER := 0-1962.0724
284: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a14 NUMBER := 0-1962.0724
288: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a17 NUMBER := 0-1962.0724
291: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
285: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
286: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a14 NUMBER := 0-1962.0724
288: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a17 NUMBER := 0-1962.0724
291: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
287: , p0_a14 NUMBER := 0-1962.0724
288: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a17 NUMBER := 0-1962.0724
291: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
294: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
295: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
288: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a17 NUMBER := 0-1962.0724
291: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
294: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
295: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
296: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
289: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a17 NUMBER := 0-1962.0724
291: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
294: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
295: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
296: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
297: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
290: , p0_a17 NUMBER := 0-1962.0724
291: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
294: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
295: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
296: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
297: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
298: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
291: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
294: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
295: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
296: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
297: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
298: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
299: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
292: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
294: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
295: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
296: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
297: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
298: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
299: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
300: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
293: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
294: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
295: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
296: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
297: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
298: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
299: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
300: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
301: );
294: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
295: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
296: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
297: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
298: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
299: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
300: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
301: );
302: procedure update_filters(p_rulegroup_id NUMBER
295: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
296: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
297: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
298: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
299: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
300: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
301: );
302: procedure update_filters(p_rulegroup_id NUMBER
303: , p1_a0 JTF_VARCHAR2_TABLE_100
296: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
297: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
298: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
299: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
300: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
301: );
302: procedure update_filters(p_rulegroup_id NUMBER
303: , p1_a0 JTF_VARCHAR2_TABLE_100
304: , p1_a1 JTF_VARCHAR2_TABLE_100
314: , x_return_status OUT NOCOPY VARCHAR2
315: , x_msg_count OUT NOCOPY NUMBER
316: , x_msg_data OUT NOCOPY VARCHAR2
317: , p5_a0 NUMBER := 0-1962.0724
318: , p5_a1 DATE := fnd_api.g_miss_date
319: , p5_a2 NUMBER := 0-1962.0724
320: , p5_a3 DATE := fnd_api.g_miss_date
321: , p5_a4 NUMBER := 0-1962.0724
322: , p5_a5 NUMBER := 0-1962.0724
316: , x_msg_data OUT NOCOPY VARCHAR2
317: , p5_a0 NUMBER := 0-1962.0724
318: , p5_a1 DATE := fnd_api.g_miss_date
319: , p5_a2 NUMBER := 0-1962.0724
320: , p5_a3 DATE := fnd_api.g_miss_date
321: , p5_a4 NUMBER := 0-1962.0724
322: , p5_a5 NUMBER := 0-1962.0724
323: , p5_a6 NUMBER := 0-1962.0724
324: , p5_a7 NUMBER := 0-1962.0724
324: , p5_a7 NUMBER := 0-1962.0724
325: , p5_a8 NUMBER := 0-1962.0724
326: , p5_a9 NUMBER := 0-1962.0724
327: , p5_a10 NUMBER := 0-1962.0724
328: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
329: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
330: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
331: , p5_a14 NUMBER := 0-1962.0724
332: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
325: , p5_a8 NUMBER := 0-1962.0724
326: , p5_a9 NUMBER := 0-1962.0724
327: , p5_a10 NUMBER := 0-1962.0724
328: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
329: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
330: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
331: , p5_a14 NUMBER := 0-1962.0724
332: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
326: , p5_a9 NUMBER := 0-1962.0724
327: , p5_a10 NUMBER := 0-1962.0724
328: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
329: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
330: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
331: , p5_a14 NUMBER := 0-1962.0724
332: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a17 NUMBER := 0-1962.0724
328: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
329: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
330: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
331: , p5_a14 NUMBER := 0-1962.0724
332: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a17 NUMBER := 0-1962.0724
335: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
329: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
330: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
331: , p5_a14 NUMBER := 0-1962.0724
332: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a17 NUMBER := 0-1962.0724
335: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
337: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
331: , p5_a14 NUMBER := 0-1962.0724
332: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a17 NUMBER := 0-1962.0724
335: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
337: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
338: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a17 NUMBER := 0-1962.0724
335: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
337: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
338: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
340: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a17 NUMBER := 0-1962.0724
335: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
337: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
338: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
340: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
341: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
334: , p5_a17 NUMBER := 0-1962.0724
335: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
337: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
338: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
340: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
341: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
342: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
335: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
337: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
338: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
340: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
341: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
342: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
343: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
337: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
338: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
340: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
341: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
342: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
343: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
344: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
337: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
338: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
340: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
341: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
342: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
343: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
344: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
345: );
338: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
339: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
340: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
341: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
342: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
343: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
344: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
345: );
346: end ams_ps_rule_pvt_w;
339: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
340: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
341: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
342: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
343: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
344: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
345: );
346: end ams_ps_rule_pvt_w;
340: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
341: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
342: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
343: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
344: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
345: );
346: end ams_ps_rule_pvt_w;