APPS.AMS_CTD_ADHOC_PARAM_VALUES_PKG dependencies on AMS_CTD_ADHOC_PARAM_VALUES

Line 1: PACKAGE BODY AMS_CTD_ADHOC_PARAM_VALUES_PKG as

1: PACKAGE BODY AMS_CTD_ADHOC_PARAM_VALUES_PKG as
2: /* $Header: amstapvb.pls 120.0 2005/07/01 03:53:15 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_CTD_ADHOC_PARAM_VALUES_PKG

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

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

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

Line 60: INSERT INTO AMS_CTD_ADHOC_PARAM_VALUES(

56:
57: px_object_version_number := 1;
58:
59:
60: INSERT INTO AMS_CTD_ADHOC_PARAM_VALUES(
61: adhoc_param_id,
62: adhoc_param_code,
63: adhoc_param_value,
64: ctd_id,

Line 118: Update AMS_CTD_ADHOC_PARAM_VALUES

114: p_security_group_id NUMBER)
115:
116: IS
117: BEGIN
118: Update AMS_CTD_ADHOC_PARAM_VALUES
119: SET
120: adhoc_param_id = DECODE( p_adhoc_param_id, FND_API.g_miss_num, adhoc_param_id, p_adhoc_param_id),
121: adhoc_param_code = DECODE( p_adhoc_param_code, FND_API.g_miss_char, adhoc_param_code, p_adhoc_param_code),
122: adhoc_param_value = DECODE( p_adhoc_param_value, FND_API.g_miss_char, adhoc_param_value, p_adhoc_param_value),

Line 160: DELETE FROM AMS_CTD_ADHOC_PARAM_VALUES

156: PROCEDURE Delete_Row(
157: p_ADHOC_PARAM_ID NUMBER)
158: IS
159: BEGIN
160: DELETE FROM AMS_CTD_ADHOC_PARAM_VALUES
161: WHERE ADHOC_PARAM_ID = p_ADHOC_PARAM_ID;
162: If (SQL%NOTFOUND) then
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: End If;

Line 201: FROM AMS_CTD_ADHOC_PARAM_VALUES

197:
198: IS
199: CURSOR C IS
200: SELECT *
201: FROM AMS_CTD_ADHOC_PARAM_VALUES
202: WHERE ADHOC_PARAM_ID = p_ADHOC_PARAM_ID
203: FOR UPDATE of ADHOC_PARAM_ID NOWAIT;
204: Recinfo C%ROWTYPE;
205: BEGIN

Line 254: END AMS_CTD_ADHOC_PARAM_VALUES_PKG;

250: APP_EXCEPTION.RAISE_EXCEPTION;
251: END IF;
252: END Lock_Row;
253:
254: END AMS_CTD_ADHOC_PARAM_VALUES_PKG;