75:
76: --===================================================================
77: TYPE pretty_url_rec_type IS RECORD
78: (
79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
76: --===================================================================
77: TYPE pretty_url_rec_type IS RECORD
78: (
79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
77: TYPE pretty_url_rec_type IS RECORD
78: (
79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
78: (
79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
79: pretty_url_id NUMBER := FND_API.G_MISS_NUM,
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
87: );
80: creation_date DATE := FND_API.G_MISS_DATE,
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
87: );
88:
81: created_by NUMBER := FND_API.G_MISS_NUM,
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
87: );
88:
89: g_miss_pretty_url_rec pretty_url_rec_type;
82: last_update_date DATE := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER := FND_API.G_MISS_NUM,
84: last_update_login NUMBER := FND_API.G_MISS_NUM,
85: object_version_number NUMBER := FND_API.G_MISS_NUM,
86: landing_page_url VARCHAR2(2000) := FND_API.G_MISS_CHAR
87: );
88:
89: g_miss_pretty_url_rec pretty_url_rec_type;
90: TYPE pretty_url_tbl_type IS TABLE OF pretty_url_rec_type INDEX BY BINARY_INTEGER;
102: -- Parameters
103: --
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109: -- p_pretty_url_rec IN pretty_url_rec_type Required
110: --
103: --
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109: -- p_pretty_url_rec IN pretty_url_rec_type Required
110: --
111: -- OUT NOCOPY
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109: -- p_pretty_url_rec IN pretty_url_rec_type Required
110: --
111: -- OUT NOCOPY
112: -- x_return_status OUT NOCOPY VARCHAR2
121: --
122:
123: PROCEDURE Create_Pretty_Url(
124: p_api_version_number IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
122:
123: PROCEDURE Create_Pretty_Url(
124: p_api_version_number IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
123: PROCEDURE Create_Pretty_Url(
124: p_api_version_number IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
146: -- Parameters
147: --
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153: -- p_pretty_url_rec IN pretty_url_rec_type Required
154: --
147: --
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153: -- p_pretty_url_rec IN pretty_url_rec_type Required
154: --
155: -- OUT NOCOPY
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153: -- p_pretty_url_rec IN pretty_url_rec_type Required
154: --
155: -- OUT NOCOPY
156: -- x_return_status OUT NOCOPY VARCHAR2
165: --
166:
167: PROCEDURE Update_Pretty_Url(
168: p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172:
173: x_return_status OUT NOCOPY VARCHAR2,
166:
167: PROCEDURE Update_Pretty_Url(
168: p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172:
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
167: PROCEDURE Update_Pretty_Url(
168: p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172:
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
190: -- Parameters
191: --
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_PRETTY_URL_ID IN NUMBER
198: -- p_object_version_number IN NUMBER Optional Default = NULL
191: --
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_PRETTY_URL_ID IN NUMBER
198: -- p_object_version_number IN NUMBER Optional Default = NULL
199: --
192: -- IN
193: -- p_api_version_number IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197: -- p_PRETTY_URL_ID IN NUMBER
198: -- p_object_version_number IN NUMBER Optional Default = NULL
199: --
200: -- OUT NOCOPY
210: --
211:
212: PROCEDURE Delete_Pretty_Url(
213: p_api_version_number IN NUMBER,
214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
211:
212: PROCEDURE Delete_Pretty_Url(
213: p_api_version_number IN NUMBER,
214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
212: PROCEDURE Delete_Pretty_Url(
213: p_api_version_number IN NUMBER,
214: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215: p_commit IN VARCHAR2 := FND_API.G_FALSE,
216: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_pretty_url_id IN NUMBER,
233: -- Parameters
234: --
235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
240: -- p_pretty_url_rec IN pretty_url_rec_type Required
241: --
234: --
235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
240: -- p_pretty_url_rec IN pretty_url_rec_type Required
241: --
242: -- OUT NOCOPY
235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
240: -- p_pretty_url_rec IN pretty_url_rec_type Required
241: --
242: -- OUT NOCOPY
243: -- x_return_status OUT NOCOPY VARCHAR2
252: --
253:
254: PROCEDURE Lock_Pretty_Url(
255: p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257:
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
276: -- End of Comments
277:
278: PROCEDURE Validate_pretty_url(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: p_pretty_url_rec IN pretty_url_rec_type,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
277:
278: PROCEDURE Validate_pretty_url(
279: p_api_version_number IN NUMBER,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: p_pretty_url_rec IN pretty_url_rec_type,
283: x_return_status OUT NOCOPY VARCHAR2,
284: x_msg_count OUT NOCOPY NUMBER,
285: x_msg_data OUT NOCOPY VARCHAR2
314: -- End of Comments
315:
316: PROCEDURE Validate_pretty_url_rec(
317: p_api_version_number IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: p_pretty_url_rec IN pretty_url_rec_type