48:
49: --===================================================================
50: TYPE ps_strats_rec_type IS RECORD
51: (
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
49: --===================================================================
50: TYPE ps_strats_rec_type IS RECORD
51: (
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
50: TYPE ps_strats_rec_type IS RECORD
51: (
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: strategy_id NUMBER := FND_API.G_MISS_NUM,
51: (
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: strategy_id NUMBER := FND_API.G_MISS_NUM,
59: max_returned NUMBER := FND_API.G_MISS_NUM,
52: created_by NUMBER := FND_API.G_MISS_NUM,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: strategy_id NUMBER := FND_API.G_MISS_NUM,
59: max_returned NUMBER := FND_API.G_MISS_NUM,
60: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: creation_date DATE := FND_API.G_MISS_DATE,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: strategy_id NUMBER := FND_API.G_MISS_NUM,
59: max_returned NUMBER := FND_API.G_MISS_NUM,
60: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: last_updated_by NUMBER := FND_API.G_MISS_NUM,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: strategy_id NUMBER := FND_API.G_MISS_NUM,
59: max_returned NUMBER := FND_API.G_MISS_NUM,
60: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: last_update_date DATE := FND_API.G_MISS_DATE,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: strategy_id NUMBER := FND_API.G_MISS_NUM,
59: max_returned NUMBER := FND_API.G_MISS_NUM,
60: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: strategy_id NUMBER := FND_API.G_MISS_NUM,
59: max_returned NUMBER := FND_API.G_MISS_NUM,
60: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
64: strategy_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
57: object_version_number NUMBER := FND_API.G_MISS_NUM,
58: strategy_id NUMBER := FND_API.G_MISS_NUM,
59: max_returned NUMBER := FND_API.G_MISS_NUM,
60: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
64: strategy_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: strategy_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
58: strategy_id NUMBER := FND_API.G_MISS_NUM,
59: max_returned NUMBER := FND_API.G_MISS_NUM,
60: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
64: strategy_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: strategy_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66: );
59: max_returned NUMBER := FND_API.G_MISS_NUM,
60: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
64: strategy_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: strategy_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66: );
67:
60: strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
64: strategy_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: strategy_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66: );
67:
68: g_miss_ps_strats_rec ps_strats_rec_type;
61: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
64: strategy_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
65: strategy_description VARCHAR2(4000) := FND_API.G_MISS_CHAR
66: );
67:
68: g_miss_ps_strats_rec ps_strats_rec_type;
69: TYPE ps_strats_tbl_type IS TABLE OF ps_strats_rec_type INDEX BY BINARY_INTEGER;
81: -- Parameters
82: --
83: -- IN
84: -- p_api_version_number IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_ps_strats_rec IN ps_strats_rec_type Required
89: --
82: --
83: -- IN
84: -- p_api_version_number IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_ps_strats_rec IN ps_strats_rec_type Required
89: --
90: -- OUT
83: -- IN
84: -- p_api_version_number IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
86: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
87: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
88: -- p_ps_strats_rec IN ps_strats_rec_type Required
89: --
90: -- OUT
91: -- x_return_status OUT VARCHAR2
100: --
101:
102: PROCEDURE Create_Ps_Strats(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
101:
102: PROCEDURE Create_Ps_Strats(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
102: PROCEDURE Create_Ps_Strats(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
125: -- Parameters
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_ps_strats_rec IN ps_strats_rec_type Required
133: --
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_ps_strats_rec IN ps_strats_rec_type Required
133: --
134: -- OUT
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_ps_strats_rec IN ps_strats_rec_type Required
133: --
134: -- OUT
135: -- x_return_status OUT VARCHAR2
144: --
145:
146: PROCEDURE Update_Ps_Strats(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151:
152: x_return_status OUT NOCOPY VARCHAR2,
145:
146: PROCEDURE Update_Ps_Strats(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151:
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
146: PROCEDURE Update_Ps_Strats(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151:
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
169: -- Parameters
170: --
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_ps_strats_rec IN ps_strats_rec_type Required
177: --
170: --
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_ps_strats_rec IN ps_strats_rec_type Required
177: --
178: -- OUT
171: -- IN
172: -- p_api_version_number IN NUMBER Required
173: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
174: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
175: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
176: -- p_ps_strats_rec IN ps_strats_rec_type Required
177: --
178: -- OUT
179: -- x_return_status OUT VARCHAR2
188: --
189:
190: PROCEDURE Update_Ps_Strats_Seg(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
189:
190: PROCEDURE Update_Ps_Strats_Seg(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
190: PROCEDURE Update_Ps_Strats_Seg(
191: p_api_version_number IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
214: -- Parameters
215: --
216: -- IN
217: -- p_api_version_number IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221: -- p_STRATEGY_ID IN NUMBER
222: -- p_object_version_number IN NUMBER Optional Default = NULL
215: --
216: -- IN
217: -- p_api_version_number IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221: -- p_STRATEGY_ID IN NUMBER
222: -- p_object_version_number IN NUMBER Optional Default = NULL
223: --
216: -- IN
217: -- p_api_version_number IN NUMBER Required
218: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
221: -- p_STRATEGY_ID IN NUMBER
222: -- p_object_version_number IN NUMBER Optional Default = NULL
223: --
224: -- OUT
234: --
235:
236: PROCEDURE Delete_Ps_Strats(
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
235:
236: PROCEDURE Delete_Ps_Strats(
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
236: PROCEDURE Delete_Ps_Strats(
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_strategy_id IN NUMBER,
257: -- Parameters
258: --
259: -- IN
260: -- p_api_version_number IN NUMBER Required
261: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
262: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_ps_strats_rec IN ps_strats_rec_type Required
265: --
258: --
259: -- IN
260: -- p_api_version_number IN NUMBER Required
261: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
262: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_ps_strats_rec IN ps_strats_rec_type Required
265: --
266: -- OUT
259: -- IN
260: -- p_api_version_number IN NUMBER Required
261: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
262: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
263: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
264: -- p_ps_strats_rec IN ps_strats_rec_type Required
265: --
266: -- OUT
267: -- x_return_status OUT VARCHAR2
276: --
277:
278: PROCEDURE Lock_Ps_Strats(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281:
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
300: -- End of Comments
301:
302: PROCEDURE Validate_ps_strats(
303: p_api_version_number IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_ps_strats_rec IN ps_strats_rec_type,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
301:
302: PROCEDURE Validate_ps_strats(
303: p_api_version_number IN NUMBER,
304: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: p_ps_strats_rec IN ps_strats_rec_type,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
309: x_msg_data OUT NOCOPY VARCHAR2
338: -- End of Comments
339:
340: PROCEDURE Validate_ps_strats_rec(
341: p_api_version_number IN NUMBER,
342: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
343: x_return_status OUT NOCOPY VARCHAR2,
344: x_msg_count OUT NOCOPY NUMBER,
345: x_msg_data OUT NOCOPY VARCHAR2,
346: p_ps_strats_rec IN ps_strats_rec_type