APPS.AMS_ACT_CONTACT_POINTS_PKG dependencies on AMS_ACT_CONTACT_POINTS

Line 1: PACKAGE BODY AMS_ACT_CONTACT_POINTS_PKG as

1: PACKAGE BODY AMS_ACT_CONTACT_POINTS_PKG as
2: /* $Header: amstconb.pls 120.0 2005/05/31 17:56:32 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_ACT_CONTACT_POINTS_PKG

2: /* $Header: amstconb.pls 120.0 2005/05/31 17:56:32 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_ACT_CONTACT_POINTS_PKG
7: -- Purpose
8: --
9: -- History
10: -- 20-may-2005 musman Added contact_point_value_id column for webadi collaboration script usage

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

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

Line 81: INSERT INTO AMS_ACT_CONTACT_POINTS(

77:
78: px_object_version_number := 1;
79:
80:
81: INSERT INTO AMS_ACT_CONTACT_POINTS(
82: contact_point_id,
83: last_update_date,
84: last_updated_by,
85: creation_date,

Line 199: Update AMS_ACT_CONTACT_POINTS

195: IS
196: BEGIN
197:
198:
199: Update AMS_ACT_CONTACT_POINTS
200: SET
201: contact_point_id = DECODE( p_contact_point_id, FND_API.g_miss_num, contact_point_id, p_contact_point_id),
202: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
203: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 259: DELETE FROM AMS_ACT_CONTACT_POINTS

255: PROCEDURE Delete_Row(
256: p_CONTACT_POINT_ID NUMBER)
257: IS
258: BEGIN
259: DELETE FROM AMS_ACT_CONTACT_POINTS
260: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID;
261: If (SQL%NOTFOUND) then
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: End If;

Line 289: FROM AMS_ACT_CONTACT_POINTS

285:
286: IS
287: CURSOR C IS
288: SELECT *
289: FROM AMS_ACT_CONTACT_POINTS
290: WHERE CONTACT_POINT_ID = p_CONTACT_POINT_ID
291: FOR UPDATE of CONTACT_POINT_ID NOWAIT;
292: Recinfo C%ROWTYPE;
293: BEGIN

Line 304: END AMS_ACT_CONTACT_POINTS_PKG;

300: END IF;
301: CLOSE C;
302: END Lock_Row;
303:
304: END AMS_ACT_CONTACT_POINTS_PKG;