APPS.AMS_DM_BIN_VALUES_PKG dependencies on AMS_DM_BIN_VALUES

Line 1: PACKAGE BODY AMS_DM_BIN_VALUES_PKG as

1: PACKAGE BODY AMS_DM_BIN_VALUES_PKG as
2: /* $Header: amstdbvb.pls 115.3 2002/12/09 11:03:20 choang noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_DM_BIN_VALUES_PKG

2: /* $Header: amstdbvb.pls 115.3 2002/12/09 11:03:20 choang noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_DM_BIN_VALUES_PKG
7: -- Purpose
8: --
9: -- History
10: --

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

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

Line 65: INSERT INTO AMS_DM_BIN_VALUES(

61:
62: px_object_version_number := 1;
63:
64:
65: INSERT INTO AMS_DM_BIN_VALUES(
66: bin_value_id,
67: last_update_date,
68: last_updated_by,
69: creation_date,

Line 126: Update AMS_DM_BIN_VALUES

122: p_end_value NUMBER)
123:
124: IS
125: BEGIN
126: Update AMS_DM_BIN_VALUES
127: SET
128: bin_value_id = DECODE( p_bin_value_id, FND_API.g_miss_num, bin_value_id, p_bin_value_id),
129: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
130: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 169: DELETE FROM AMS_DM_BIN_VALUES

165: PROCEDURE Delete_Row(
166: p_BIN_VALUE_ID NUMBER)
167: IS
168: BEGIN
169: DELETE FROM AMS_DM_BIN_VALUES
170: WHERE BIN_VALUE_ID = p_BIN_VALUE_ID;
171: If (SQL%NOTFOUND) then
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: End If;

Line 211: FROM AMS_DM_BIN_VALUES

207:
208: IS
209: CURSOR C IS
210: SELECT *
211: FROM AMS_DM_BIN_VALUES
212: WHERE BIN_VALUE_ID = p_BIN_VALUE_ID
213: FOR UPDATE of BIN_VALUE_ID NOWAIT;
214: Recinfo C%ROWTYPE;
215: BEGIN

Line 267: END AMS_DM_BIN_VALUES_PKG;

263: APP_EXCEPTION.RAISE_EXCEPTION;
264: END IF;
265: END Lock_Row;
266:
267: END AMS_DM_BIN_VALUES_PKG;