DBA Data[Home] [Help]

PACKAGE: APPS.IEX_OBJECT_FILTERS_PKG

Source


1 PACKAGE IEX_OBJECT_FILTERS_PKG AS
2 /* $Header: iextobfs.pls 120.0 2004/01/24 03:22:22 appldev noship $ */
3 
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(x_rowid                    IN OUT NOCOPY VARCHAR2
6                     ,p_OBJECT_FILTER_ID         NUMBER
7                     ,p_OBJECT_FILTER_TYPE       VARCHAR2
8                     ,p_OBJECT_FILTER_NAME       VARCHAR2
9                     ,p_OBJECT_ID                NUMBER
10                     ,p_SELECT_COLUMN            VARCHAR2
11                     ,p_ENTITY_NAME              VARCHAR2
12                     ,p_ACTIVE_FLAG              VARCHAR2
13                     ,p_OBJECT_VERSION_NUMBER    NUMBER
14                     ,p_PROGRAM_ID               NUMBER  DEFAULT NULL
15                     ,p_REQUEST_ID               NUMBER  DEFAULT NULL
16                     ,p_PROGRAM_APPLICATION_ID   NUMBER  DEFAULT NULL
17                     ,p_PROGRAM_UPDATE_DATE      DATE    DEFAULT NULL
18                     ,p_CREATED_BY               NUMBER
19                     ,p_CREATION_DATE            DATE
20                     ,p_LAST_UPDATED_BY          NUMBER
21                     ,p_LAST_UPDATE_DATE         DATE
22                     ,p_LAST_UPDATE_LOGIN        NUMBER  DEFAULT NULL
23                 );
24 
25 /* Update_Row procedure */
26 PROCEDURE Update_Row(x_rowid                    VARCHAR2
27                     ,p_OBJECT_FILTER_ID         NUMBER
28                     ,p_OBJECT_FILTER_TYPE       VARCHAR2
29                     ,p_OBJECT_FILTER_NAME       VARCHAR2
30                     ,p_OBJECT_ID                NUMBER
31                     ,p_SELECT_COLUMN            VARCHAR2
32                     ,p_ENTITY_NAME              VARCHAR2
33                     ,p_ACTIVE_FLAG              VARCHAR2
34                     ,p_OBJECT_VERSION_NUMBER    NUMBER
35                     ,p_PROGRAM_ID               NUMBER  DEFAULT NULL
36                     ,p_REQUEST_ID               NUMBER  DEFAULT NULL
37                     ,p_PROGRAM_APPLICATION_ID   NUMBER  DEFAULT NULL
38                     ,p_PROGRAM_UPDATE_DATE      DATE    DEFAULT NULL
39                     ,p_CREATED_BY               NUMBER
40                     ,p_CREATION_DATE            DATE
41                     ,p_LAST_UPDATED_BY          NUMBER
42                     ,p_LAST_UPDATE_DATE         DATE
43                     ,p_LAST_UPDATE_LOGIN        NUMBER  DEFAULT NULL
44                 );
45 
46 /* Delete_Row procedure */
47 PROCEDURE Delete_Row(x_rowid	VARCHAR2);
48 
49 /* Lock_Row procedure */
50 PROCEDURE Lock_Row(x_rowid                      VARCHAR2
51                     ,p_OBJECT_FILTER_ID         NUMBER
52                     ,p_OBJECT_FILTER_TYPE       VARCHAR2
53                     ,p_OBJECT_FILTER_NAME       VARCHAR2
54                     ,p_OBJECT_ID                NUMBER
55                     ,p_SELECT_COLUMN            VARCHAR2
56                     ,p_ENTITY_NAME              VARCHAR2
57                     ,p_ACTIVE_FLAG              VARCHAR2
58                     ,p_OBJECT_VERSION_NUMBER    NUMBER
59                     ,p_PROGRAM_ID               NUMBER  DEFAULT NULL
60                     ,p_REQUEST_ID               NUMBER  DEFAULT NULL
61                     ,p_PROGRAM_APPLICATION_ID   NUMBER  DEFAULT NULL
62                     ,p_PROGRAM_UPDATE_DATE      DATE    DEFAULT NULL
63                     ,p_CREATED_BY               NUMBER
64                     ,p_CREATION_DATE            DATE
65                     ,p_LAST_UPDATED_BY          NUMBER
66                     ,p_LAST_UPDATE_DATE         DATE
67                     ,p_LAST_UPDATE_LOGIN        NUMBER  DEFAULT NULL
68                 );
69 END;
70