1 package JTF_PREFAB_POLICIES_PKG as
2 /* $Header: jtfprepolicyts.pls 120.2 2005/10/28 00:26:34 emekala noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_POLICY_ID in NUMBER,
6 X_OBJECT_VERSION_NUMBER in NUMBER,
7 X_SECURITY_GROUP_ID in NUMBER,
8 X_POLICY_NAME in VARCHAR2,
9 X_PRIORITY in NUMBER,
10 X_ENABLED_FLAG in VARCHAR2,
11 X_APPLICATION_ID in NUMBER,
12 X_ALL_APPLICATIONS_FLAG in VARCHAR2,
13 X_DEPTH in NUMBER,
14 X_ALL_RESPONSIBILITIES_FLAG in VARCHAR2,
15 X_ALL_USERS_FLAG in VARCHAR2,
16 X_REFRESH_INTERVAL in NUMBER,
17 X_INTERVAL_UNIT in VARCHAR2,
18 X_START_TIME in NUMBER,
19 X_END_TIME in NUMBER,
20 X_RUN_ALWAYS_FLAG in VARCHAR2,
21 X_DESCRIPTION in VARCHAR2,
22 X_CREATION_DATE in DATE,
23 X_CREATED_BY in NUMBER,
24 X_LAST_UPDATE_DATE in DATE,
25 X_LAST_UPDATED_BY in NUMBER,
26 X_LAST_UPDATE_LOGIN in NUMBER);
27 procedure LOCK_ROW (
28 X_POLICY_ID in NUMBER,
29 X_OBJECT_VERSION_NUMBER in NUMBER,
30 X_SECURITY_GROUP_ID in NUMBER,
31 X_POLICY_NAME in VARCHAR2,
32 X_PRIORITY in NUMBER,
33 X_ENABLED_FLAG in VARCHAR2,
34 X_APPLICATION_ID in NUMBER,
35 X_ALL_APPLICATIONS_FLAG in VARCHAR2,
36 X_DEPTH in NUMBER,
37 X_ALL_RESPONSIBILITIES_FLAG in VARCHAR2,
38 X_ALL_USERS_FLAG in VARCHAR2,
39 X_REFRESH_INTERVAL in NUMBER,
40 X_INTERVAL_UNIT in VARCHAR2,
41 X_START_TIME in NUMBER,
42 X_END_TIME in NUMBER,
43 X_RUN_ALWAYS_FLAG in VARCHAR2,
44 X_DESCRIPTION in VARCHAR2
45 );
46 procedure UPDATE_ROW (
47 X_POLICY_ID in NUMBER,
48 X_OBJECT_VERSION_NUMBER in NUMBER,
49 X_SECURITY_GROUP_ID in NUMBER,
50 X_POLICY_NAME in VARCHAR2,
51 X_PRIORITY in NUMBER,
52 X_ENABLED_FLAG in VARCHAR2,
53 X_APPLICATION_ID in NUMBER,
54 X_ALL_APPLICATIONS_FLAG in VARCHAR2,
55 X_DEPTH in NUMBER,
56 X_ALL_RESPONSIBILITIES_FLAG in VARCHAR2,
57 X_ALL_USERS_FLAG in VARCHAR2,
58 X_REFRESH_INTERVAL in NUMBER,
59 X_INTERVAL_UNIT in VARCHAR2,
60 X_START_TIME in NUMBER,
61 X_END_TIME in NUMBER,
62 X_RUN_ALWAYS_FLAG in VARCHAR2,
63 X_DESCRIPTION in VARCHAR2,
64 X_LAST_UPDATE_DATE in DATE,
65 X_LAST_UPDATED_BY in NUMBER,
66 X_LAST_UPDATE_LOGIN in NUMBER
67 );
68 procedure DELETE_ROW (
69 X_POLICY_ID in NUMBER
70 );
71 procedure ADD_LANGUAGE;
72 procedure LOAD_ROW (
73 X_OBJECT_VERSION_NUMBER in NUMBER,
74 X_SECURITY_GROUP_ID in NUMBER,
75 X_POLICY_NAME in VARCHAR2,
76 X_PRIORITY in NUMBER,
77 X_ENABLED_FLAG in VARCHAR2,
78 X_APPLICATION_ID in NUMBER,
79 X_ALL_APPLICATIONS_FLAG in VARCHAR2,
80 X_DEPTH in NUMBER,
81 X_ALL_RESPONSIBILITIES_FLAG in VARCHAR2,
82 X_ALL_USERS_FLAG in VARCHAR2,
83 X_REFRESH_INTERVAL in NUMBER,
84 X_INTERVAL_UNIT in VARCHAR2,
85 X_START_TIME in NUMBER,
86 X_END_TIME in NUMBER,
87 X_RUN_ALWAYS_FLAG in VARCHAR2,
88 X_DESCRIPTION in VARCHAR2,
89 X_LAST_UPDATE_DATE in DATE,
90 X_OWNER in VARCHAR2,
91 X_CUSTOM_MODE in VARCHAR2
92 );
93 procedure TRANSLATE_ROW (
94 X_POLICY_NAME in VARCHAR2,
95 X_APPLICATION_ID in NUMBER,
96 X_DESCRIPTION in VARCHAR2,
97 X_LAST_UPDATE_DATE in DATE,
98 X_OWNER in VARCHAR2,
99 X_CUSTOM_MODE in VARCHAR2
100 );
101 procedure LOAD_UR_ROW (
102 X_OBJECT_VERSION_NUMBER in NUMBER,
103 X_SECURITY_GROUP_ID in NUMBER,
104 X_APPLICATION_ID in NUMBER,
105 X_POLICY_NAME in VARCHAR2,
106 X_USERRESP_ID in NUMBER,
107 X_USERRESP_TYPE in VARCHAR2,
108 X_LAST_UPDATE_DATE in DATE,
109 X_OWNER in VARCHAR2,
110 X_CUSTOM_MODE in VARCHAR2
111 );
112 procedure LOAD_SYS_ROW (
113 X_OBJECT_VERSION_NUMBER in NUMBER,
114 X_SECURITY_GROUP_ID in NUMBER,
115 X_START_FLAG in VARCHAR2,
116 X_CPU in NUMBER,
117 X_MEMORY in NUMBER,
118 X_DISK_LOCATION in VARCHAR2,
119 X_MAX_CONCURRENCY in NUMBER,
120 X_USE_LOAD_BALANCER_FLAG in VARCHAR2,
121 X_LOAD_BALANCER_URL in VARCHAR2,
122 X_REFRESH_FLAG in VARCHAR2,
123 X_INTERCEPTOR_ENABLED_FLAG in VARCHAR2,
124 X_CACHE_MEMORY in NUMBER,
125 X_LAST_UPDATE_DATE in DATE,
126 X_OWNER in VARCHAR2,
127 X_CUSTOM_MODE in VARCHAR2
128 );
129 end JTF_PREFAB_POLICIES_PKG;