1 PACKAGE JTM_LOOKUPS_ACC_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtmvluas.pls 120.1 2005/08/24 02:20:16 saradhak noship $ */
3
4 --
5 -- NAME
6 -- JTM_LOOKUPS_ACC_PKG
7 --
8 -- PURPOSE
9 -- TABLE-LEVEL PACKAGE SPEC for JTM_LOOKUPS_ACC.
10
11
12 PROCEDURE INSERT_ROW (
13 X_LOOKUP_TYPE IN VARCHAR2 ,
14 X_VIEW_APPLICATION_ID IN NUMBER ,
15 X_SECURITY_GROUP_ID IN NUMBER ,
16 X_APPLICATION_ID IN NUMBER ,
17 X_ACCESS_ID OUT NOCOPY NUMBER
18 );
19
20
21 PROCEDURE UPDATE_ROW (
22 X_LOOKUP_TYPE IN VARCHAR2 ,
23 X_VIEW_APPLICATION_ID IN NUMBER ,
24 X_SECURITY_GROUP_ID IN NUMBER ,
25 X_APPLICATION_ID IN NUMBER
26 );
27
28 PROCEDURE DELETE_ROW (
29 X_LOOKUP_TYPE IN VARCHAR2 ,
30 X_VIEW_APPLICATION_ID IN NUMBER ,
31 X_SECURITY_GROUP_ID IN NUMBER ,
32 X_APPLICATION_ID IN NUMBER
33 );
34
35 END JTM_LOOKUPS_ACC_PKG;