APPS.AMS_PRETTY_URL_ASSOC_PKG dependencies on AMS_PRETTY_URL_ASSOC

Line 1: PACKAGE BODY AMS_PRETTY_URL_ASSOC_PKG as

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

Line 6: -- AMS_PRETTY_URL_ASSOC_PKG

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

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

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

Line 59: INSERT INTO AMS_PRETTY_URL_ASSOC(

55:
56: px_object_version_number := 1;
57:
58:
59: INSERT INTO AMS_PRETTY_URL_ASSOC(
60: assoc_id,
61: creation_date,
62: created_by,
63: last_update_date,

Line 114: Update AMS_PRETTY_URL_ASSOC

110: p_used_by_obj_id NUMBER)
111:
112: IS
113: BEGIN
114: Update AMS_PRETTY_URL_ASSOC
115: SET
116: assoc_id = DECODE( p_assoc_id, FND_API.g_miss_num, assoc_id, p_assoc_id),
117: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 155: DELETE FROM AMS_PRETTY_URL_ASSOC

151: PROCEDURE Delete_Row(
152: p_ASSOC_ID NUMBER)
153: IS
154: BEGIN
155: DELETE FROM AMS_PRETTY_URL_ASSOC
156: WHERE ASSOC_ID = p_ASSOC_ID;
157: If (SQL%NOTFOUND) then
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: End If;

Line 195: FROM AMS_PRETTY_URL_ASSOC

191:
192: IS
193: CURSOR C IS
194: SELECT *
195: FROM AMS_PRETTY_URL_ASSOC
196: WHERE ASSOC_ID = p_ASSOC_ID
197: FOR UPDATE of ASSOC_ID NOWAIT;
198: Recinfo C%ROWTYPE;
199: BEGIN

Line 245: END AMS_PRETTY_URL_ASSOC_PKG;

241: APP_EXCEPTION.RAISE_EXCEPTION;
242: END IF;
243: END Lock_Row;
244:
245: END AMS_PRETTY_URL_ASSOC_PKG;