APPS.AMS_CTDS_PKG dependencies on AMS_CTDS

Line 1: PACKAGE BODY AMS_CTDS_PKG as

1: PACKAGE BODY AMS_CTDS_PKG as
2: /* $Header: amstctdb.pls 120.1 2005/06/03 12:41:22 appldev $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_CTDS_PKG

2: /* $Header: amstctdb.pls 120.1 2005/06/03 12:41:22 appldev $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_CTDS_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 62: INSERT INTO AMS_CTDS(

58:
59: px_object_version_number := 1;
60:
61:
62: INSERT INTO AMS_CTDS(
63: ctd_id,
64: action_id,
65: forward_url,
66: track_url,

Line 126: Update AMS_CTDS

122: p_security_group_id NUMBER)
123:
124: IS
125: BEGIN
126: Update AMS_CTDS
127: SET
128: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
129: action_id = DECODE( p_action_id, FND_API.g_miss_num, action_id, p_action_id),
130: forward_url = DECODE( p_forward_url, FND_API.g_miss_char, forward_url, p_forward_url),

Line 170: DELETE FROM AMS_CTDS

166: PROCEDURE Delete_Row(
167: p_CTD_ID NUMBER)
168: IS
169: BEGIN
170: DELETE FROM AMS_CTDS
171: WHERE CTD_ID = p_CTD_ID;
172: If (SQL%NOTFOUND) then
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: End If;

Line 213: FROM AMS_CTDS

209:
210: IS
211: CURSOR C IS
212: SELECT *
213: FROM AMS_CTDS
214: WHERE CTD_ID = p_CTD_ID
215: FOR UPDATE of CTD_ID NOWAIT;
216: Recinfo C%ROWTYPE;
217: BEGIN

Line 305: from AMS_CTDS

301:
302: cursor c_obj_verno is
303: select OBJECT_VERSION_NUMBER,
304: last_updated_by
305: from AMS_CTDS
306: where CTD_ID = X_CTD_ID;
307:
308: cursor c_chk_ctd_exists is
309: select 'X'

Line 310: from AMS_CTDS

306: where CTD_ID = X_CTD_ID;
307:
308: cursor c_chk_ctd_exists is
309: select 'X'
310: from AMS_CTDS
311: where CTD_ID = X_CTD_ID;
312:
313: cursor c_get_ctd_id is
314: select ams_ctds_s.nextval

Line 314: select ams_ctds_s.nextval

310: from AMS_CTDS
311: where CTD_ID = X_CTD_ID;
312:
313: cursor c_get_ctd_id is
314: select ams_ctds_s.nextval
315: from dual;
316:
317: BEGIN
318:

Line 341: AMS_CTDS_PKG.INSERT_ROW (

337: end if;
338:
339: close c_chk_ctd_exists;
340: l_obj_verno := 1;
341: AMS_CTDS_PKG.INSERT_ROW (
342: px_ctd_id => l_ctd_id,
343: p_action_id => X_ACTION_ID,
344: p_forward_url => x_forward_url,
345: p_track_url => x_track_url,

Line 369: AMS_CTDS_PKG.UPDATE_ROW(

365:
366: if (l_last_updated_by in (1,2,0) OR
367: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
368:
369: AMS_CTDS_PKG.UPDATE_ROW(
370: p_ctd_id => X_CTD_ID,
371: p_action_id => X_ACTION_ID,
372: p_forward_url => X_FORWARD_URL,
373: p_track_url => X_TRACK_URL,

Line 418: END AMS_CTDS_PKG;

414: select sysdate into l_date from dual;
415: END TRANSLATE_ROW;
416:
417:
418: END AMS_CTDS_PKG;