1 PACKAGE JTM_HOOK_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtmhutls.pls 120.1 2005/08/24 02:14:37 saradhak noship $ */
3
4 /***
5 Debug levels:
6 0 = No debug
7 1 = Log errors
8 2 = Log errors and functional messages
9 3 = Log errors, functional messages and SQL statements
10 4 = Full Debug
11 ***/
12 g_debug_level_none CONSTANT NUMBER := 0;
13 g_debug_level_error CONSTANT NUMBER := 1;
14 g_debug_level_medium CONSTANT NUMBER := 2;
15 g_debug_level_sql CONSTANT NUMBER := 3;
16 g_debug_level_full CONSTANT NUMBER := 4;
17
18 /*** type containing list of publication items that use an ACC table ***/
19 TYPE t_publication_item_list IS TABLE OF VARCHAR2(30);
20
21 FUNCTION Get_Debug_Level
22 RETURN NUMBER;
23 /***
24 Function that returns debug level.
25 0 = No debug
26 1 = Log errors
27 2 = Log errors and replication info messages
28 3 = Log errors, sql and replication info messages
29 4 = Full Debug (including entering/leaving procedures)
30 ***/
31
32 FUNCTION isMobileFSresource
33 ( p_resource_id in NUMBER
34 )
35 RETURN BOOLEAN;
36 /* Returns whether resource_id is mobile Field Service/Laptop resource */
37
38 FUNCTION Get_Resource_Id( p_client_name IN VARCHAR2
39 )
40 RETURN NUMBER;
41 /***
42 Procedure that returns resource_id for a given client_name.
43 ***/
44
45 FUNCTION Get_User_Id( p_client_name IN VARCHAR2
46 )
47 RETURN NUMBER;
48 /***
49 Procedure that returns user_id for a given client_name.
50 ***/
51
52 FUNCTION Get_Acc_Id
53 ( p_acc_table_name in VARCHAR2
54 , p_resource_id in NUMBER
55 , p_pk1_name in VARCHAR2
56 , p_pk1_num_value in NUMBER DEFAULT NULL
57 , p_pk1_char_value in VARCHAR2 DEFAULT NULL
58 , p_pk1_date_value in DATE DEFAULT NULL
59 , p_pk2_name in VARCHAR2 DEFAULT NULL
60 , p_pk2_num_value in NUMBER DEFAULT NULL
61 , p_pk2_char_value in VARCHAR2 DEFAULT NULL
62 , p_pk2_date_value in DATE DEFAULT NULL
63 , p_pk3_name in VARCHAR2 DEFAULT NULL
64 , p_pk3_num_value in NUMBER DEFAULT NULL
65 , p_pk3_char_value in VARCHAR2 DEFAULT NULL
66 , p_pk3_date_value in DATE DEFAULT NULL
67 )
68 RETURN NUMBER;
69 /***
70 Procedure that checks if an ACC record exists for a given resource_id.
71 If so, it returns the ACC record's access_id.
72 If not, it returns -1.
73 ***/
74
75 PROCEDURE Get_Resource_Acc_List
76 ( p_acc_table_name in VARCHAR2
77 , p_pk1_name in VARCHAR2
78 , p_pk1_num_value in NUMBER DEFAULT NULL
79 , p_pk1_char_value in VARCHAR2 DEFAULT NULL
80 , p_pk1_date_value in DATE DEFAULT NULL
81 , p_pk2_name in VARCHAR2 DEFAULT NULL
82 , p_pk2_num_value in NUMBER DEFAULT NULL
83 , p_pk2_char_value in VARCHAR2 DEFAULT NULL
84 , p_pk2_date_value in DATE DEFAULT NULL
85 , p_pk3_name in VARCHAR2 DEFAULT NULL
86 , p_pk3_num_value in NUMBER DEFAULT NULL
87 , p_pk3_char_value in VARCHAR2 DEFAULT NULL
88 , p_pk3_date_value in DATE DEFAULT NULL
89 , l_tab_resource_id out nocopy dbms_sql.Number_Table
90 , l_tab_access_id out nocopy dbms_sql.Number_Table
91 );
92 /***
93 Procedure that returns all RESOURCE_ID, ACCESS_ID combinations present in ACC for a given
94 table_name, primary key name and primary key value
95 ***/
96
97 PROCEDURE Insert_Acc
98 ( p_publication_item_names in t_publication_item_list
99 ,p_acc_table_name in VARCHAR2
100 ,p_resource_id in NUMBER
101 , p_pk1_name in VARCHAR2
102 , p_pk1_num_value in NUMBER DEFAULT NULL
103 , p_pk1_char_value in VARCHAR2 DEFAULT NULL
104 , p_pk1_date_value in DATE DEFAULT NULL
105 , p_pk2_name in VARCHAR2 DEFAULT NULL
106 , p_pk2_num_value in NUMBER DEFAULT NULL
107 , p_pk2_char_value in VARCHAR2 DEFAULT NULL
108 , p_pk2_date_value in DATE DEFAULT NULL
109 , p_pk3_name in VARCHAR2 DEFAULT NULL
110 , p_pk3_num_value in NUMBER DEFAULT NULL
111 , p_pk3_char_value in VARCHAR2 DEFAULT NULL
112 , p_pk3_date_value in DATE DEFAULT NULL
113 );
114 /*** Procedure that inserts record into any ACC table ***/
115
116 PROCEDURE Update_Acc
117 ( p_publication_item_names in t_publication_item_list
118 ,p_acc_table_name in VARCHAR2
119 ,p_resource_id in NUMBER
120 ,p_access_id in NUMBER
121 );
122 /*** Procedure that re-sends a record with given acc_id to the mobile ***/
123
124 PROCEDURE Delete_Acc
125 ( p_publication_item_names in t_publication_item_list
126 , p_acc_table_name in VARCHAR2
127 , p_pk1_name in VARCHAR2
128 , p_pk1_num_value in NUMBER DEFAULT NULL
129 , p_pk1_char_value in VARCHAR2 DEFAULT NULL
130 , p_pk1_date_value in DATE DEFAULT NULL
131 , p_pk2_name in VARCHAR2 DEFAULT NULL
132 , p_pk2_num_value in NUMBER DEFAULT NULL
133 , p_pk2_char_value in VARCHAR2 DEFAULT NULL
134 , p_pk2_date_value in DATE DEFAULT NULL
135 , p_pk3_name in VARCHAR2 DEFAULT NULL
136 , p_pk3_num_value in NUMBER DEFAULT NULL
137 , p_pk3_char_value in VARCHAR2 DEFAULT NULL
138 , p_pk3_date_value in DATE DEFAULT NULL
139 , p_resource_id in NUMBER DEFAULT NULL
140 , p_operator in VARCHAR2 DEFAULT NULL
141 );
142 /***
143 Procedure that deletes record(s) from any ACC table
144 If p_resource_id is NULL, all ACC records that match the PK values are deleted.
145 If p_resource_id is specified and p_operator='=' the ACC record is only deleted for that specific resource.
146 If p_resource_id is specified and p_operator='<>' all ACC records with resource_id<>p_resource_id are deleted
147 ***/
148
149 PROCEDURE DELETE_ACC_FOR_RESOURCE
150 ( p_acc_table_name IN VARCHAR2
151 , p_resource_id IN NUMBER
152 );
153 /****
154 Procedure that deletes all acc records for an acc table for a resource
155 ****/
156
157 FUNCTION Get_Profile_Value( p_name IN VARCHAR2
158 , p_site_id IN NUMBER DEFAULT NULL
159 , p_appl_id IN NUMBER DEFAULT NULL
160 , p_user_id IN NUMBER DEFAULT NULL
161 , p_resp_id IN NUMBER DEFAULT NULL
162 )
163 RETURN VARCHAR2;
164 /***
165 Procedure that returns profile value with a given name.
166 The level from which the value is coming can be chosen by entering a site,appl,user or resp ID
167 ***/
168
169 END JTM_HOOK_UTIL_PKG;