1 package PQH_TABLE_ROUTE_PKG as
2 /* $Header: pqtrtpkg.pkh 120.2 2005/10/12 20:20:34 srajakum noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_TABLE_ROUTE_ID in NUMBER,
6 X_SHADOW_TABLE_ROUTE_ID in NUMBER,
7 X_FROM_CLAUSE in VARCHAR2,
8 X_TABLE_ALIAS in VARCHAR2,
9 X_WHERE_CLAUSE in VARCHAR2,
10 X_OBJECT_VERSION_NUMBER in NUMBER,
11 X_DISPLAY_NAME in VARCHAR2,
12 X_MAP_REQUIRED_FLAG in VARCHAR2,
13 X_SELECT_ALLOWED_FLAG in VARCHAR2,
14 X_HIDE_TABLE_FOR_VIEW_FLAG in VARCHAR2,
15 X_DISPLAY_ORDER in NUMBER,
16 X_CREATION_DATE in DATE,
17 X_CREATED_BY in NUMBER,
18 X_LAST_UPDATE_DATE in DATE,
19 X_LAST_UPDATED_BY in NUMBER,
20 X_LAST_UPDATE_LOGIN in NUMBER);
21
22 procedure LOCK_ROW (
23 X_TABLE_ROUTE_ID in NUMBER,
24 X_SHADOW_TABLE_ROUTE_ID in NUMBER,
25 X_FROM_CLAUSE in VARCHAR2,
26 X_TABLE_ALIAS in VARCHAR2,
27 X_WHERE_CLAUSE in VARCHAR2,
28 X_OBJECT_VERSION_NUMBER in NUMBER,
29 X_DISPLAY_NAME in VARCHAR2
30 );
31
32 procedure UPDATE_ROW (
33 X_TABLE_ROUTE_ID in NUMBER,
34 X_SHADOW_TABLE_ROUTE_ID in NUMBER,
35 X_FROM_CLAUSE in VARCHAR2,
36 X_TABLE_ALIAS in VARCHAR2,
37 X_WHERE_CLAUSE in VARCHAR2,
38 X_OBJECT_VERSION_NUMBER in NUMBER,
39 X_DISPLAY_NAME in VARCHAR2,
40 X_MAP_REQUIRED_FLAG in VARCHAR2,
41 X_SELECT_ALLOWED_FLAG in VARCHAR2,
42 X_HIDE_TABLE_FOR_VIEW_FLAG in VARCHAR2,
43 X_DISPLAY_ORDER in NUMBER,
44 X_LAST_UPDATE_DATE in DATE,
45 X_LAST_UPDATED_BY in NUMBER,
46 X_LAST_UPDATE_LOGIN in NUMBER
47 );
48
49 procedure DELETE_ROW (
50 X_TABLE_ROUTE_ID in NUMBER
51 );
52
53 procedure ADD_LANGUAGE;
54
55
56 procedure LOAD_ROW (
57 p_table_alias IN VARCHAR2,
58 p_shadow_table IN VARCHAR2,
59 p_from_clause IN VARCHAR2,
60 p_where_clause IN VARCHAR2,
61 p_display_name IN VARCHAR2,
62 p_map_required_flag IN VARCHAR2,
63 p_select_allowed_flag IN VARCHAR2,
64 p_hide_table_for_view_flag IN VARCHAR2,
65 p_display_order IN NUMBER,
66 p_last_update_date IN VARCHAR2,
67 p_owner IN VARCHAR2
68 );
69
70
71 procedure TRANSLATE_ROW (
72 p_table_alias in varchar2,
73 p_display_name in varchar2,
74 p_owner in varchar2);
75 --
76
77 procedure LOAD_SEED_ROW (
78 p_upload_mode IN VARCHAR2,
79 p_table_alias IN VARCHAR2,
80 p_shadow_table IN VARCHAR2,
81 p_from_clause IN VARCHAR2,
82 p_where_clause IN VARCHAR2,
83 p_display_name IN VARCHAR2,
84 p_map_required_flag IN VARCHAR2,
85 p_select_allowed_flag IN VARCHAR2,
86 p_hide_table_for_view_flag IN VARCHAR2,
87 p_display_order IN NUMBER,
88 p_last_update_date IN VARCHAR2,
89 p_owner IN VARCHAR2
90 );
91
92 end PQH_TABLE_ROUTE_PKG;
93