57:
58: --===================================================================
59: TYPE iba_plcmnt_rec_type IS RECORD
60: (
61: placement_id NUMBER := FND_API.G_MISS_NUM,
62: site_id NUMBER := FND_API.G_MISS_NUM,
63: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: page_id NUMBER := FND_API.G_MISS_NUM,
65: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: --===================================================================
59: TYPE iba_plcmnt_rec_type IS RECORD
60: (
61: placement_id NUMBER := FND_API.G_MISS_NUM,
62: site_id NUMBER := FND_API.G_MISS_NUM,
63: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: page_id NUMBER := FND_API.G_MISS_NUM,
65: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: location_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
59: TYPE iba_plcmnt_rec_type IS RECORD
60: (
61: placement_id NUMBER := FND_API.G_MISS_NUM,
62: site_id NUMBER := FND_API.G_MISS_NUM,
63: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: page_id NUMBER := FND_API.G_MISS_NUM,
65: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: location_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: param1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: (
61: placement_id NUMBER := FND_API.G_MISS_NUM,
62: site_id NUMBER := FND_API.G_MISS_NUM,
63: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: page_id NUMBER := FND_API.G_MISS_NUM,
65: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: location_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: param1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: param2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: placement_id NUMBER := FND_API.G_MISS_NUM,
62: site_id NUMBER := FND_API.G_MISS_NUM,
63: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: page_id NUMBER := FND_API.G_MISS_NUM,
65: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: location_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: param1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: param2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: param3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
62: site_id NUMBER := FND_API.G_MISS_NUM,
63: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: page_id NUMBER := FND_API.G_MISS_NUM,
65: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: location_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: param1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: param2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: param3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: param4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
63: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: page_id NUMBER := FND_API.G_MISS_NUM,
65: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: location_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: param1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: param2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: param3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: param4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: param5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: page_id NUMBER := FND_API.G_MISS_NUM,
65: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: location_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: param1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: param2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: param3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: param4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: param5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
65: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: location_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: param1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: param2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: param3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: param4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: param5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
73: posting_id NUMBER := FND_API.G_MISS_NUM,
66: location_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: param1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: param2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: param3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: param4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: param5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
73: posting_id NUMBER := FND_API.G_MISS_NUM,
74: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: param1 VARCHAR2(30) := FND_API.G_MISS_CHAR,
68: param2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: param3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: param4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: param5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
73: posting_id NUMBER := FND_API.G_MISS_NUM,
74: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: track_events_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: param2 VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: param3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: param4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: param5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
73: posting_id NUMBER := FND_API.G_MISS_NUM,
74: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: track_events_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: created_by NUMBER := FND_API.G_MISS_NUM,
69: param3 VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: param4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: param5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
73: posting_id NUMBER := FND_API.G_MISS_NUM,
74: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: track_events_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: created_by NUMBER := FND_API.G_MISS_NUM,
77: creation_date DATE := FND_API.G_MISS_DATE,
70: param4 VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: param5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
73: posting_id NUMBER := FND_API.G_MISS_NUM,
74: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: track_events_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: created_by NUMBER := FND_API.G_MISS_NUM,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: last_updated_by NUMBER := FND_API.G_MISS_NUM,
71: param5 VARCHAR2(30) := FND_API.G_MISS_CHAR,
72: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
73: posting_id NUMBER := FND_API.G_MISS_NUM,
74: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: track_events_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: created_by NUMBER := FND_API.G_MISS_NUM,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: last_updated_by NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
72: stylesheet_id NUMBER := FND_API.G_MISS_NUM,
73: posting_id NUMBER := FND_API.G_MISS_NUM,
74: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: track_events_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: created_by NUMBER := FND_API.G_MISS_NUM,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: last_updated_by NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
73: posting_id NUMBER := FND_API.G_MISS_NUM,
74: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: track_events_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: created_by NUMBER := FND_API.G_MISS_NUM,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: last_updated_by NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
74: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: track_events_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: created_by NUMBER := FND_API.G_MISS_NUM,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: last_updated_by NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: track_events_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: created_by NUMBER := FND_API.G_MISS_NUM,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: last_updated_by NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
76: created_by NUMBER := FND_API.G_MISS_NUM,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: last_updated_by NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
84: );
77: creation_date DATE := FND_API.G_MISS_DATE,
78: last_updated_by NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
84: );
85:
78: last_updated_by NUMBER := FND_API.G_MISS_NUM,
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
84: );
85:
86: g_miss_iba_plcmnt_rec iba_plcmnt_rec_type;
79: last_update_date DATE := FND_API.G_MISS_DATE,
80: last_update_login NUMBER := FND_API.G_MISS_NUM,
81: object_version_number NUMBER := FND_API.G_MISS_NUM,
82: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
84: );
85:
86: g_miss_iba_plcmnt_rec iba_plcmnt_rec_type;
87: TYPE iba_plcmnt_tbl_type IS TABLE OF iba_plcmnt_rec_type INDEX BY BINARY_INTEGER;
99: -- Parameters
100: --
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_iba_plcmnt_rec IN iba_plcmnt_rec_type Required
107: --
100: --
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_iba_plcmnt_rec IN iba_plcmnt_rec_type Required
107: --
108: -- OUT
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_iba_plcmnt_rec IN iba_plcmnt_rec_type Required
107: --
108: -- OUT
109: -- x_return_status OUT VARCHAR2
118: --
119:
120: PROCEDURE Create_Iba_Plcmnt(
121: p_api_version_number IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125:
126: x_return_status OUT NOCOPY VARCHAR2,
119:
120: PROCEDURE Create_Iba_Plcmnt(
121: p_api_version_number IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125:
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
120: PROCEDURE Create_Iba_Plcmnt(
121: p_api_version_number IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125:
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
143: -- Parameters
144: --
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_iba_plcmnt_rec IN iba_plcmnt_rec_type Required
151: --
144: --
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_iba_plcmnt_rec IN iba_plcmnt_rec_type Required
151: --
152: -- OUT
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_iba_plcmnt_rec IN iba_plcmnt_rec_type Required
151: --
152: -- OUT
153: -- x_return_status OUT VARCHAR2
162: --
163:
164: PROCEDURE Update_Iba_Plcmnt(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169:
170: x_return_status OUT NOCOPY VARCHAR2,
163:
164: PROCEDURE Update_Iba_Plcmnt(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169:
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
164: PROCEDURE Update_Iba_Plcmnt(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169:
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
187: -- Parameters
188: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_PLACEMENT_ID IN NUMBER
195: -- p_object_version_number IN NUMBER Optional Default = NULL
188: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_PLACEMENT_ID IN NUMBER
195: -- p_object_version_number IN NUMBER Optional Default = NULL
196: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_PLACEMENT_ID IN NUMBER
195: -- p_object_version_number IN NUMBER Optional Default = NULL
196: --
197: -- OUT
207: --
208:
209: PROCEDURE Delete_Iba_Plcmnt(
210: p_api_version_number IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
208:
209: PROCEDURE Delete_Iba_Plcmnt(
210: p_api_version_number IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
209: PROCEDURE Delete_Iba_Plcmnt(
210: p_api_version_number IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_placement_id IN NUMBER,
230: -- Parameters
231: --
232: -- IN
233: -- p_api_version_number IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_iba_plcmnt_rec IN iba_plcmnt_rec_type Required
238: --
231: --
232: -- IN
233: -- p_api_version_number IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_iba_plcmnt_rec IN iba_plcmnt_rec_type Required
238: --
239: -- OUT
232: -- IN
233: -- p_api_version_number IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_iba_plcmnt_rec IN iba_plcmnt_rec_type Required
238: --
239: -- OUT
240: -- x_return_status OUT VARCHAR2
249: --
250:
251: PROCEDURE Lock_Iba_Plcmnt(
252: p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254:
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
273: -- End of Comments
274:
275: PROCEDURE Validate_iba_plcmnt(
276: p_api_version_number IN NUMBER
277: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
278: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
279: , p_iba_plcmnt_rec IN iba_plcmnt_rec_type
280: , x_return_status OUT NOCOPY VARCHAR2
281: , x_msg_count OUT NOCOPY NUMBER
274:
275: PROCEDURE Validate_iba_plcmnt(
276: p_api_version_number IN NUMBER
277: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
278: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
279: , p_iba_plcmnt_rec IN iba_plcmnt_rec_type
280: , x_return_status OUT NOCOPY VARCHAR2
281: , x_msg_count OUT NOCOPY NUMBER
282: , x_msg_data OUT NOCOPY VARCHAR2
312: -- End of Comments
313:
314: PROCEDURE Validate_iba_plcmnt_rec(
315: p_api_version_number IN NUMBER,
316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317: x_return_status OUT NOCOPY VARCHAR2,
318: x_msg_count OUT NOCOPY NUMBER,
319: x_msg_data OUT NOCOPY VARCHAR2,
320: p_iba_plcmnt_rec IN iba_plcmnt_rec_type