APPS.AMS_PRETTY_URL_PKG dependencies on AMS_PRETTY_URL

Line 1: PACKAGE BODY AMS_PRETTY_URL_PKG as

1: PACKAGE BODY AMS_PRETTY_URL_PKG as
2: /* $Header: amstpurb.pls 120.0 2005/07/01 03:54:48 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_PRETTY_URL_PKG

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

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

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

Line 57: INSERT INTO AMS_PRETTY_URL(

53:
54: px_object_version_number := 1;
55:
56:
57: INSERT INTO AMS_PRETTY_URL(
58: pretty_url_id,
59: creation_date,
60: created_by,
61: last_update_date,

Line 106: Update AMS_PRETTY_URL

102: p_landing_page_url VARCHAR2)
103:
104: IS
105: BEGIN
106: Update AMS_PRETTY_URL
107: SET
108: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
109: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
110: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 145: DELETE FROM AMS_PRETTY_URL

141: PROCEDURE Delete_Row(
142: p_PRETTY_URL_ID NUMBER)
143: IS
144: BEGIN
145: DELETE FROM AMS_PRETTY_URL
146: WHERE PRETTY_URL_ID = p_PRETTY_URL_ID;
147: If (SQL%NOTFOUND) then
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: End If;

Line 183: FROM AMS_PRETTY_URL

179:
180: IS
181: CURSOR C IS
182: SELECT *
183: FROM AMS_PRETTY_URL
184: WHERE PRETTY_URL_ID = p_PRETTY_URL_ID
185: FOR UPDATE of PRETTY_URL_ID NOWAIT;
186: Recinfo C%ROWTYPE;
187: BEGIN

Line 227: END AMS_PRETTY_URL_PKG;

223: APP_EXCEPTION.RAISE_EXCEPTION;
224: END IF;
225: END Lock_Row;
226:
227: END AMS_PRETTY_URL_PKG;