1 package AMS_COND_STRUCT_RESTR_VAL_PKG as
2 /* $Header: amstqcrs.pls 120.0 2005/06/01 02:44:50 appldev noship $ */
3 procedure INSERT_ROW (
4 X_COND_STRUCT_RESTRICT_ID in NUMBER,
5 X_QUERY_COND_DISP_STRUCT_ID in NUMBER,
6 X_CODE in VARCHAR2,
7 X_INCLUDED_FLAG in VARCHAR2,
8 X_CODE_IND_FLAG in VARCHAR2,
9 X_OBJECT_VERSION_NUMBER in NUMBER,
10 X_REQUEST_ID in NUMBER,
11 X_CREATION_DATE in DATE,
12 X_CREATED_BY in NUMBER,
13 X_LAST_UPDATE_DATE in DATE,
14 X_LAST_UPDATED_BY in NUMBER,
15 X_LAST_UPDATE_LOGIN in NUMBER);
16 procedure LOCK_ROW (
17 X_COND_STRUCT_RESTRICT_ID in NUMBER,
18 X_QUERY_COND_DISP_STRUCT_ID in NUMBER,
19 X_CODE in VARCHAR2,
20 X_INCLUDED_FLAG in VARCHAR2,
21 X_CODE_IND_FLAG in VARCHAR2,
22 X_OBJECT_VERSION_NUMBER in NUMBER,
23 X_REQUEST_ID in NUMBER
24 );
25 procedure UPDATE_ROW (
26 X_COND_STRUCT_RESTRICT_ID in NUMBER,
27 X_QUERY_COND_DISP_STRUCT_ID in NUMBER,
28 X_CODE in VARCHAR2,
29 X_INCLUDED_FLAG in VARCHAR2,
30 X_CODE_IND_FLAG in VARCHAR2,
31 X_OBJECT_VERSION_NUMBER in NUMBER,
32 X_REQUEST_ID in NUMBER,
33 X_LAST_UPDATE_DATE in DATE,
34 X_LAST_UPDATED_BY in NUMBER,
35 X_LAST_UPDATE_LOGIN in NUMBER
36 );
37 procedure DELETE_ROW (
38 X_COND_STRUCT_RESTRICT_ID in NUMBER
39 );
40
41 PROCEDURE load_row (
42 X_COND_STRUCT_RESTRICT_ID in NUMBER,
43 X_QUERY_COND_DISP_STRUCT_ID in NUMBER,
44 X_CODE in VARCHAR2,
45 X_INCLUDED_FLAG in VARCHAR2,
46 X_CODE_IND_FLAG in VARCHAR2,
47 x_owner IN VARCHAR2,
48 x_custom_mode IN VARCHAR2
49 );
50
51 end AMS_COND_STRUCT_RESTR_VAL_PKG;