APPS.AMS_SYSTEM_PRETTY_URL_PKG dependencies on AMS_SYSTEM_PRETTY_URL

Line 1: PACKAGE BODY AMS_SYSTEM_PRETTY_URL_PKG as

1: PACKAGE BODY AMS_SYSTEM_PRETTY_URL_PKG as
2: /* $Header: amstspub.pls 120.0 2005/07/01 03:56:31 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_SYSTEM_PRETTY_URL_PKG

2: /* $Header: amstspub.pls 120.0 2005/07/01 03:56:31 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_SYSTEM_PRETTY_URL_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_SYSTEM_PRETTY_URL_PKG';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_SYSTEM_PRETTY_URL_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstspub.pls';
19:
20:
21: ----------------------------------------------------------

Line 61: INSERT INTO AMS_SYSTEM_PRETTY_URL(

57:
58: px_object_version_number := 1;
59:
60:
61: INSERT INTO AMS_SYSTEM_PRETTY_URL(
62: system_url_id,
63: creation_date,
64: created_by,
65: last_update_date,

Line 122: Update AMS_SYSTEM_PRETTY_URL

118: p_track_url VARCHAR2)
119:
120: IS
121: BEGIN
122: Update AMS_SYSTEM_PRETTY_URL
123: SET
124: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 165: DELETE FROM AMS_SYSTEM_PRETTY_URL

161: PROCEDURE Delete_Row(
162: p_SYSTEM_URL_ID NUMBER)
163: IS
164: BEGIN
165: DELETE FROM AMS_SYSTEM_PRETTY_URL
166: WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID;
167: If (SQL%NOTFOUND) then
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: End If;

Line 207: FROM AMS_SYSTEM_PRETTY_URL

203:
204: IS
205: CURSOR C IS
206: SELECT *
207: FROM AMS_SYSTEM_PRETTY_URL
208: WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID
209: FOR UPDATE of SYSTEM_URL_ID NOWAIT;
210: Recinfo C%ROWTYPE;
211: BEGIN

Line 263: END AMS_SYSTEM_PRETTY_URL_PKG;

259: APP_EXCEPTION.RAISE_EXCEPTION;
260: END IF;
261: END Lock_Row;
262:
263: END AMS_SYSTEM_PRETTY_URL_PKG;