47:
48: --===================================================================
49: TYPE iba_pl_pages_rec_type IS RECORD
50: (
51: page_id NUMBER := FND_API.G_MISS_NUM,
52: site_id NUMBER := FND_API.G_MISS_NUM,
53: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
48: --===================================================================
49: TYPE iba_pl_pages_rec_type IS RECORD
50: (
51: page_id NUMBER := FND_API.G_MISS_NUM,
52: site_id NUMBER := FND_API.G_MISS_NUM,
53: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
49: TYPE iba_pl_pages_rec_type IS RECORD
50: (
51: page_id NUMBER := FND_API.G_MISS_NUM,
52: site_id NUMBER := FND_API.G_MISS_NUM,
53: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
50: (
51: page_id NUMBER := FND_API.G_MISS_NUM,
52: site_id NUMBER := FND_API.G_MISS_NUM,
53: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
51: page_id NUMBER := FND_API.G_MISS_NUM,
52: site_id NUMBER := FND_API.G_MISS_NUM,
53: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
52: site_id NUMBER := FND_API.G_MISS_NUM,
53: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: site_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: page_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
56: created_by NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
64: );
57: creation_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
64: );
65:
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
64: );
65:
66: g_miss_iba_pl_pages_rec iba_pl_pages_rec_type;
59: last_update_date DATE := FND_API.G_MISS_DATE,
60: last_update_login NUMBER := FND_API.G_MISS_NUM,
61: object_version_number NUMBER := FND_API.G_MISS_NUM,
62: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63: description VARCHAR2(4000) := FND_API.G_MISS_CHAR
64: );
65:
66: g_miss_iba_pl_pages_rec iba_pl_pages_rec_type;
67: TYPE iba_pl_pages_tbl_type IS TABLE OF iba_pl_pages_rec_type INDEX BY BINARY_INTEGER;
79: -- Parameters
80: --
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_iba_pl_pages_rec IN iba_pl_pages_rec_type Required
87: --
80: --
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_iba_pl_pages_rec IN iba_pl_pages_rec_type Required
87: --
88: -- OUT
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_iba_pl_pages_rec IN iba_pl_pages_rec_type Required
87: --
88: -- OUT
89: -- x_return_status OUT VARCHAR2
98: --
99:
100: PROCEDURE Create_Iba_Pl_Pages(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105:
106: x_return_status OUT NOCOPY VARCHAR2,
99:
100: PROCEDURE Create_Iba_Pl_Pages(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105:
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
100: PROCEDURE Create_Iba_Pl_Pages(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105:
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
123: -- Parameters
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_iba_pl_pages_rec IN iba_pl_pages_rec_type Required
131: --
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_iba_pl_pages_rec IN iba_pl_pages_rec_type Required
131: --
132: -- OUT
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_iba_pl_pages_rec IN iba_pl_pages_rec_type Required
131: --
132: -- OUT
133: -- x_return_status OUT VARCHAR2
142: --
143:
144: PROCEDURE Update_Iba_Pl_Pages(
145: p_api_version_number IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149:
150: x_return_status OUT NOCOPY VARCHAR2,
143:
144: PROCEDURE Update_Iba_Pl_Pages(
145: p_api_version_number IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149:
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
144: PROCEDURE Update_Iba_Pl_Pages(
145: p_api_version_number IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149:
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
167: -- Parameters
168: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_PAGE_ID IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
168: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_PAGE_ID IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
176: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_PAGE_ID IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
176: --
177: -- OUT
187: --
188:
189: PROCEDURE Delete_Iba_Pl_Pages(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
188:
189: PROCEDURE Delete_Iba_Pl_Pages(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
189: PROCEDURE Delete_Iba_Pl_Pages(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_page_id IN NUMBER,
210: -- Parameters
211: --
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_iba_pl_pages_rec IN iba_pl_pages_rec_type Required
218: --
211: --
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_iba_pl_pages_rec IN iba_pl_pages_rec_type Required
218: --
219: -- OUT
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_iba_pl_pages_rec IN iba_pl_pages_rec_type Required
218: --
219: -- OUT
220: -- x_return_status OUT VARCHAR2
229: --
230:
231: PROCEDURE Lock_Iba_Pl_Pages(
232: p_api_version_number IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234:
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2,
253: -- End of Comments
254:
255: PROCEDURE Validate_iba_pl_pages(
256: p_api_version_number IN NUMBER
257: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
258: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
259: , p_iba_pl_pages_rec IN iba_pl_pages_rec_type
260: , x_return_status OUT NOCOPY VARCHAR2
261: , x_msg_count OUT NOCOPY NUMBER
254:
255: PROCEDURE Validate_iba_pl_pages(
256: p_api_version_number IN NUMBER
257: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
258: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
259: , p_iba_pl_pages_rec IN iba_pl_pages_rec_type
260: , x_return_status OUT NOCOPY VARCHAR2
261: , x_msg_count OUT NOCOPY NUMBER
262: , x_msg_data OUT NOCOPY VARCHAR2
292: -- End of Comments
293:
294: PROCEDURE Validate_iba_pl_pages_rec(
295: p_api_version_number IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: x_return_status OUT NOCOPY VARCHAR2,
298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_iba_pl_pages_rec IN iba_pl_pages_rec_type