28: --
29: -- End of Comments
30: TYPE ps_rules_tuple_rec_type IS RECORD
31: (
32: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: value VARCHAR2(30) := FND_API.G_MISS_CHAR
34: );
35:
36: g_miss_ps_rules_tuple_rec ps_rules_tuple_rec_type;
29: -- End of Comments
30: TYPE ps_rules_tuple_rec_type IS RECORD
31: (
32: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
33: value VARCHAR2(30) := FND_API.G_MISS_CHAR
34: );
35:
36: g_miss_ps_rules_tuple_rec ps_rules_tuple_rec_type;
37: TYPE ps_rules_tuple_tbl_type IS TABLE OF ps_rules_tuple_rec_type INDEX BY BINARY_INTEGER;
86: );
87:
88: TYPE ps_rules_rec_type IS RECORD
89: (
90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
87:
88: TYPE ps_rules_rec_type IS RECORD
89: (
90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
88: TYPE ps_rules_rec_type IS RECORD
89: (
90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
89: (
90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
90: created_by NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
91: creation_date DATE := FND_API.G_MISS_DATE,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
92: last_updated_by NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
93: last_update_date DATE := FND_API.G_MISS_DATE,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
96: rule_id NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
97: rulegroup_id NUMBER := FND_API.G_MISS_NUM,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: posting_id NUMBER := FND_API.G_MISS_NUM,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: strategy_id NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
100: exec_priority NUMBER := FND_API.G_MISS_NUM,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: bus_priority_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: bus_priority_disp_order VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: clausevalue1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
104: clausevalue2 NUMBER := FND_API.G_MISS_NUM,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: clausevalue3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
106: clausevalue4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: clausevalue5 NUMBER := FND_API.G_MISS_NUM,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: clausevalue6 VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
109: clausevalue7 VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR
110: clausevalue8 VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR
118: );
111: clausevalue9 VARCHAR2(30) := FND_API.G_MISS_CHAR,
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR
118: );
119:
112: clausevalue10 VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR
118: );
119:
120: g_miss_ps_rules_rec ps_rules_rec_type;
113: use_clause6 VARCHAR2(1) := FND_API.G_MISS_CHAR,
114: use_clause7 VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: use_clause8 VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: use_clause9 VARCHAR2(1) := FND_API.G_MISS_CHAR,
117: use_clause10 VARCHAR2(1) := FND_API.G_MISS_CHAR
118: );
119:
120: g_miss_ps_rules_rec ps_rules_rec_type;
121: TYPE ps_rules_tbl_type IS TABLE OF ps_rules_rec_type INDEX BY BINARY_INTEGER;
133: -- Parameters
134: --
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_ps_rules_rec IN ps_rules_rec_type Required
141: --
134: --
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_ps_rules_rec IN ps_rules_rec_type Required
141: --
142: -- OUT
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_ps_rules_rec IN ps_rules_rec_type Required
141: --
142: -- OUT
143: -- x_return_status OUT VARCHAR2
152: --
153:
154: PROCEDURE Create_Ps_Rule(
155: p_api_version_number IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159:
160: x_return_status OUT NOCOPY VARCHAR2,
153:
154: PROCEDURE Create_Ps_Rule(
155: p_api_version_number IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159:
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
154: PROCEDURE Create_Ps_Rule(
155: p_api_version_number IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159:
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
178: -- Parameters
179: --
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_ps_rules_rec IN ps_rules_rec_type Required
186: --
179: --
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_ps_rules_rec IN ps_rules_rec_type Required
186: --
187: -- OUT
180: -- IN
181: -- p_api_version_number IN NUMBER Required
182: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185: -- p_ps_rules_rec IN ps_rules_rec_type Required
186: --
187: -- OUT
188: -- x_return_status OUT VARCHAR2
197: --
198:
199: PROCEDURE Update_Ps_Rule(
200: p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204:
205: x_return_status OUT NOCOPY VARCHAR2,
198:
199: PROCEDURE Update_Ps_Rule(
200: p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204:
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
199: PROCEDURE Update_Ps_Rule(
200: p_api_version_number IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
204:
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
215:
216:
217: PROCEDURE Update_Ps_Rule_Alt(
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222:
223: x_return_status OUT NOCOPY VARCHAR2,
216:
217: PROCEDURE Update_Ps_Rule_Alt(
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222:
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
217: PROCEDURE Update_Ps_Rule_Alt(
218: p_api_version_number IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222:
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
247: -- Parameters
248: --
249: -- IN
250: -- p_api_version_number IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254: -- p_RULE_ID IN NUMBER
255: -- p_object_version_number IN NUMBER Optional Default = NULL
248: --
249: -- IN
250: -- p_api_version_number IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254: -- p_RULE_ID IN NUMBER
255: -- p_object_version_number IN NUMBER Optional Default = NULL
256: --
249: -- IN
250: -- p_api_version_number IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254: -- p_RULE_ID IN NUMBER
255: -- p_object_version_number IN NUMBER Optional Default = NULL
256: --
257: -- OUT
267: --
268:
269: PROCEDURE Delete_Ps_Rule(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
268:
269: PROCEDURE Delete_Ps_Rule(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,
269: PROCEDURE Delete_Ps_Rule(
270: p_api_version_number IN NUMBER,
271: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272: p_commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,
277: p_rule_id IN NUMBER,
279: );
280:
281: PROCEDURE Delete_Ps_Rule_Alt(
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
280:
281: PROCEDURE Delete_Ps_Rule_Alt(
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
281: PROCEDURE Delete_Ps_Rule_Alt(
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
289: p_ps_rules_rec IN ps_rules_rec_type,
302: -- Parameters
303: --
304: -- IN
305: -- p_api_version_number IN NUMBER Required
306: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
307: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
308: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
309: -- p_ps_rules_rec IN ps_rules_rec_type Required
310: --
303: --
304: -- IN
305: -- p_api_version_number IN NUMBER Required
306: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
307: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
308: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
309: -- p_ps_rules_rec IN ps_rules_rec_type Required
310: --
311: -- OUT
304: -- IN
305: -- p_api_version_number IN NUMBER Required
306: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
307: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
308: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
309: -- p_ps_rules_rec IN ps_rules_rec_type Required
310: --
311: -- OUT
312: -- x_return_status OUT VARCHAR2
321: --
322:
323: PROCEDURE Lock_Ps_Rule(
324: p_api_version_number IN NUMBER,
325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
326:
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,
346:
347:
348: PROCEDURE Validate_ps_rule(
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
352: p_ps_rules_rec IN ps_rules_rec_type,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,
347:
348: PROCEDURE Validate_ps_rule(
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
352: p_ps_rules_rec IN ps_rules_rec_type,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,
355: x_msg_data OUT NOCOPY VARCHAR2
405: -- End of Comments
406:
407: PROCEDURE Validate_ps_rules_rec(
408: p_api_version_number IN NUMBER,
409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
410: x_return_status OUT NOCOPY VARCHAR2,
411: x_msg_count OUT NOCOPY NUMBER,
412: x_msg_data OUT NOCOPY VARCHAR2,
413: p_ps_rules_rec IN ps_rules_rec_type