APPS.AMS_WEB_RECOMMS_PKG dependencies on AMS_WEB_RECOMMS

Line 1: PACKAGE BODY AMS_Web_Recomms_PKG as

1: PACKAGE BODY AMS_Web_Recomms_PKG as
2: /* $Header: amstwreb.pls 120.1 2005/06/27 05:40:48 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_Web_Recomms_PKG

2: /* $Header: amstwreb.pls 120.1 2005/06/27 05:40:48 appldev ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_Web_Recomms_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Web_Recomms_PKG';

16: -- End of Comments
17: -- ===============================================================
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Web_Recomms_PKG';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstwreb.pls';
22:
23:
24:

Line 79: INSERT INTO ams_web_recomms(

75:
76: px_object_version_number := nvl(px_object_version_number, 1);
77:
78:
79: INSERT INTO ams_web_recomms(
80: web_recomm_id,
81: web_tracking_id,
82: recomm_object_id,
83: recomm_type,

Line 188: Update ams_web_recomms

184: p_attribute15 VARCHAR2)
185:
186: IS
187: BEGIN
188: Update ams_web_recomms
189: SET
190: web_recomm_id = DECODE( p_web_recomm_id, null, web_recomm_id, FND_API.G_MISS_NUM, null, p_web_recomm_id),
191: web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),
192: recomm_object_id = DECODE( p_recomm_object_id, null, recomm_object_id, FND_API.G_MISS_NUM, null, p_recomm_object_id),

Line 248: DELETE FROM ams_web_recomms

244: p_web_recomm_id NUMBER,
245: p_object_version_number NUMBER)
246: IS
247: BEGIN
248: DELETE FROM ams_web_recomms
249: WHERE web_recomm_id = p_web_recomm_id
250: AND object_version_number = p_object_version_number;
251: If (SQL%NOTFOUND) then
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 278: FROM ams_web_recomms

274: p_object_version_number NUMBER)
275: IS
276: CURSOR C IS
277: SELECT *
278: FROM ams_web_recomms
279: WHERE web_recomm_id = p_web_recomm_id
280: AND object_version_number = p_object_version_number
281: FOR UPDATE OF web_recomm_id NOWAIT;
282: Recinfo C%ROWTYPE;

Line 297: END AMS_Web_Recomms_PKG;

293: END Lock_Row;
294:
295:
296:
297: END AMS_Web_Recomms_PKG;