APPS.AMS_WEB_TRACK_PKG dependencies on AMS_WEB_TRACKING

Line 77: INSERT INTO ams_web_tracking(

73:
74: px_object_version_number := nvl(px_object_version_number, 1);
75:
76:
77: INSERT INTO ams_web_tracking(
78: web_tracking_id,
79: schedule_id,
80: party_id,
81: placement_id,

Line 180: Update ams_web_tracking

176: p_attribute15 VARCHAR2)
177:
178: IS
179: BEGIN
180: Update ams_web_tracking
181: SET
182: web_tracking_id = DECODE( p_web_tracking_id, null, web_tracking_id, FND_API.G_MISS_NUM, null, p_web_tracking_id),
183: schedule_id = DECODE( p_schedule_id, null, schedule_id, FND_API.G_MISS_NUM, null, p_schedule_id),
184: party_id = DECODE( p_party_id, null, party_id, FND_API.G_MISS_NUM, null, p_party_id),

Line 238: DELETE FROM ams_web_tracking

234: p_web_tracking_id NUMBER,
235: p_object_version_number NUMBER)
236: IS
237: BEGIN
238: DELETE FROM ams_web_tracking
239: WHERE web_tracking_id = p_web_tracking_id
240: AND object_version_number = p_object_version_number;
241: If (SQL%NOTFOUND) then
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 268: FROM ams_web_tracking

264: p_object_version_number NUMBER)
265: IS
266: CURSOR C IS
267: SELECT *
268: FROM ams_web_tracking
269: WHERE web_tracking_id = p_web_tracking_id
270: AND object_version_number = p_object_version_number
271: FOR UPDATE OF web_tracking_id NOWAIT;
272: Recinfo C%ROWTYPE;