APPS.AMS_CTD_PARAM_VALUES_PKG dependencies on AMS_CTD_PARAM_VALUES

Line 1: PACKAGE BODY AMS_CTD_PARAM_VALUES_PKG as

1: PACKAGE BODY AMS_CTD_PARAM_VALUES_PKG as
2: /* $Header: amstcpvb.pls 120.0 2005/07/01 03:59:46 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_CTD_PARAM_VALUES_PKG

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

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

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

Line 60: INSERT INTO AMS_CTD_PARAM_VALUES(

56:
57: px_object_version_number := 1;
58:
59:
60: INSERT INTO AMS_CTD_PARAM_VALUES(
61: action_param_value_id,
62: action_param_value,
63: ctd_id,
64: action_param_id,

Line 118: Update AMS_CTD_PARAM_VALUES

114: p_security_group_id NUMBER)
115:
116: IS
117: BEGIN
118: Update AMS_CTD_PARAM_VALUES
119: SET
120: action_param_value_id = DECODE( p_action_param_value_id, FND_API.g_miss_num, action_param_value_id, p_action_param_value_id),
121: action_param_value = DECODE( p_action_param_value, FND_API.g_miss_char, action_param_value, p_action_param_value),
122: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),

Line 160: DELETE FROM AMS_CTD_PARAM_VALUES

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

Line 201: FROM AMS_CTD_PARAM_VALUES

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

Line 254: END AMS_CTD_PARAM_VALUES_PKG;

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