1 package AMS_QUERY_ALIAS_PKG as
2 /* $Header: amstqals.pls 120.0 2005/05/31 14:52:35 appldev noship $ */
3 procedure INSERT_ROW (
4 X_QUERY_ALIAS_ID in NUMBER,
5 X_OBJECT_VERSION_NUMBER in NUMBER,
6 X_REQUEST_ID in NUMBER,
7 X_OBJECT_NAME in VARCHAR2,
8 X_ALIAS_SEQ in NUMBER,
9 X_PARENT_QUERY_ALIAS_ID in NUMBER,
10 X_TEMPLATE_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_QUERY_ALIAS_ID in NUMBER,
18 X_OBJECT_VERSION_NUMBER in NUMBER,
19 X_REQUEST_ID in NUMBER,
20 X_OBJECT_NAME in VARCHAR2,
21 X_ALIAS_SEQ in NUMBER,
22 X_PARENT_QUERY_ALIAS_ID in NUMBER,
23 X_TEMPLATE_ID in NUMBER
24 );
25 procedure UPDATE_ROW (
26 X_QUERY_ALIAS_ID in NUMBER,
27 X_OBJECT_VERSION_NUMBER in NUMBER,
28 X_REQUEST_ID in NUMBER,
29 X_OBJECT_NAME in VARCHAR2,
30 X_ALIAS_SEQ in NUMBER,
31 X_PARENT_QUERY_ALIAS_ID in NUMBER,
32 X_TEMPLATE_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_QUERY_ALIAS_ID in NUMBER
39 );
40 PROCEDURE load_row (
41 X_QUERY_ALIAS_ID in NUMBER,
42 X_REQUEST_ID in NUMBER,
43 X_OBJECT_NAME in VARCHAR2,
44 X_ALIAS_SEQ in NUMBER,
45 X_PARENT_QUERY_ALIAS_ID in NUMBER,
46 X_TEMPLATE_ID in NUMBER,
47 x_owner IN VARCHAR2,
48 x_custom_mode IN VARCHAR2
49 ) ;
50
51 end AMS_QUERY_ALIAS_PKG;