APPS.IEX_OBJECT_FILTERS_PKG dependencies on IEX_OBJECT_FILTERS

Line 1: PACKAGE BODY IEX_OBJECT_FILTERS_PKG AS

1: PACKAGE BODY IEX_OBJECT_FILTERS_PKG AS
2: /* $Header: iextobfb.pls 120.0 2004/01/24 03:22:20 appldev noship $ */
3:
4: /* Insert_Row procedure */
5: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

Line 26: CURSOR C IS SELECT ROWID FROM IEX_OBJECT_FILTERS

22: ,p_LAST_UPDATED_BY NUMBER
23: ,p_LAST_UPDATE_DATE DATE
24: ,p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL
25: ) IS
26: CURSOR C IS SELECT ROWID FROM IEX_OBJECT_FILTERS
27: WHERE OBJECT_FILTER_ID = p_OBJECT_FILTER_ID;
28:
29: BEGIN
30: INSERT INTO IEX_OBJECT_FILTERS

Line 30: INSERT INTO IEX_OBJECT_FILTERS

26: CURSOR C IS SELECT ROWID FROM IEX_OBJECT_FILTERS
27: WHERE OBJECT_FILTER_ID = p_OBJECT_FILTER_ID;
28:
29: BEGIN
30: INSERT INTO IEX_OBJECT_FILTERS
31: (
32: OBJECT_FILTER_ID
33: ,OBJECT_FILTER_TYPE
34: ,OBJECT_FILTER_NAME

Line 99: UPDATE IEX_OBJECT_FILTERS SET

95: ,p_LAST_UPDATE_DATE DATE
96: ,p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL
97: ) IS
98: BEGIN
99: UPDATE IEX_OBJECT_FILTERS SET
100: OBJECT_FILTER_ID = p_OBJECT_FILTER_ID
101: ,OBJECT_FILTER_TYPE = p_OBJECT_FILTER_TYPE
102: ,OBJECT_FILTER_NAME = p_OBJECT_FILTER_NAME
103: ,OBJECT_ID = p_OBJECT_ID

Line 127: DELETE FROM IEX_OBJECT_FILTERS

123:
124: /* Delete_Row procedure */
125: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
126: BEGIN
127: DELETE FROM IEX_OBJECT_FILTERS
128: WHERE rowid = x_rowid;
129:
130: if (sql%notfound) then
131: raise no_data_found;

Line 155: CURSOR C IS SELECT * FROM IEX_OBJECT_FILTERS

151: ,p_LAST_UPDATED_BY NUMBER
152: ,p_LAST_UPDATE_DATE DATE
153: ,p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL
154: ) IS
155: CURSOR C IS SELECT * FROM IEX_OBJECT_FILTERS
156: WHERE rowid = x_rowid
157: FOR UPDATE of OBJECT_FILTER_ID NOWAIT;
158: Recinfo C%ROWTYPE;
159: BEGIN