1 PACKAGE asg_download AUTHID CURRENT_USER AS
2 /* $Header: asgdwlds.pls 120.4 2011/01/10 11:20:50 saradhak ship $*/
3
4
5 -- Type Declarations for External Use
6 TYPE user_list IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7 TYPE access_list IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
8 TYPE dml_list IS TABLE OF CHAR(1) INDEX BY BINARY_INTEGER;
9 TYPE qid_list IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10 TYPE pk_list IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
11
12 TYPE username_list IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
13
14 -- Constants
15 OK CONSTANT BOOLEAN := TRUE;
16 FAIL CONSTANT BOOLEAN := FALSE;
17 INS CONSTANT CHAR := 'I';
18 UPD CONSTANT CHAR := 'U';
19 DEL CONSTANT CHAR := 'D';
20 ALL_USERS CONSTANT NUMBER := -999999;
21
22 -- Exceptions
23 PARAMETER_COUNT_MISMATCH EXCEPTION;
24
25 -- Type Declarations for Internal Use
26 TYPE PKTAB_LIST IS TABLE OF VARCHAR(30) INDEX BY BINARY_INTEGER;
27 TYPE PKDTYPE_LIST IS TABLE OF VARCHAR(30) INDEX BY BINARY_INTEGER;
28 TYPE session_id_list IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
29 TYPE c_purge_session IS REF CURSOR;
30
31
32 -- ** Functions/Procedures
33
34 FUNCTION markDirty ( p_pub_item IN VARCHAR2,
35 p_accessList IN access_list,
36 p_resourceList IN user_list,
37 p_dmlList IN dml_list,
38 p_timestamp IN DATE) RETURN BOOLEAN;
39
40 FUNCTION markDirty ( p_pub_item IN VARCHAR2,
41 p_accessList IN access_list,
42 p_resourceList IN user_list,
43 p_dml_type IN CHAR,
44 p_timestamp IN DATE) RETURN BOOLEAN;
45
46 FUNCTION markDirty ( p_pub_item IN VARCHAR2,
47 p_accessid IN NUMBER,
48 p_resourceid IN NUMBER,
49 p_dml IN CHAR,
50 p_timestamp IN DATE )
51 RETURN BOOLEAN;
52
53 FUNCTION markDirty ( p_pub_item IN VARCHAR2,
54 p_accessid IN NUMBER,
55 p_resourceid IN NUMBER,
56 p_dml IN CHAR,
57 p_timestamp IN DATE,
58 p_pkvalues IN pk_list )
59 RETURN BOOLEAN;
60
61 FUNCTION markDirty ( p_pub_item IN VARCHAR2,
62 p_accessList IN access_list,
63 p_resourceList IN user_list,
64 p_dml_type IN CHAR,
65 p_timestamp IN DATE,
66 p_bulk_flag IN BOOLEAN) RETURN BOOLEAN;
67
68 FUNCTION markDirty ( p_pub_item IN VARCHAR2,
69 p_user_name IN VARCHAR2,
70 p_tran_id IN NUMBER,
71 p_seq_no IN NUMBER) RETURN BOOLEAN;
72
73
74 --mark_dirty API's that take user ID.
75
76 FUNCTION mark_dirty ( p_pub_item IN VARCHAR2,
77 p_accessList IN access_list,
78 p_userid_list IN user_list,
79 p_dmlList IN dml_list,
80 p_timestamp IN DATE) RETURN BOOLEAN;
81
82 FUNCTION mark_dirty ( p_pub_item IN VARCHAR2,
83 p_accessList IN access_list,
84 p_userid_list IN user_list,
85 p_dml_type IN CHAR,
86 p_timestamp IN DATE) RETURN BOOLEAN;
87
88 FUNCTION mark_dirty ( p_pub_item IN VARCHAR2,
89 p_accessid IN NUMBER,
90 p_userid IN NUMBER,
91 p_dml IN CHAR,
92 p_timestamp IN DATE )RETURN BOOLEAN;
93
94 FUNCTION mark_dirty ( p_pub_item IN VARCHAR2,
95 p_accessid IN NUMBER,
96 p_userid IN NUMBER,
97 p_dml IN CHAR,
98 p_timestamp IN DATE,
99 p_pkvalues IN pk_list ) RETURN BOOLEAN;
100
101 FUNCTION mark_dirty ( p_pub_item IN VARCHAR2,
102 p_accessList IN access_list,
103 p_userid_list IN user_list,
104 p_dml_type IN CHAR,
105 p_timestamp IN DATE,
106 p_bulk_flag IN BOOLEAN) RETURN BOOLEAN;
107
108
109
110 FUNCTION getPrimaryKeys ( p_pub_item IN VARCHAR2,
111 x_pk_list OUT NOCOPY VARCHAR2,
112 x_pk_cnt OUT NOCOPY NUMBER) RETURN BOOLEAN;
113
114
115 FUNCTION processSdq ( p_clientid IN VARCHAR2,
116 p_last_tranid IN NUMBER,
117 p_curr_tranid IN NUMBER,
118 p_high_prty IN VARCHAR2,
119 x_ret_msg OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
120
121
122 FUNCTION storeDeletedPK ( p_pub_item IN VARCHAR2,
123 p_accessList IN access_list,
124 p_qidList IN qid_list
125 ) RETURN BOOLEAN;
126
127 FUNCTION storeDeletedPK ( p_pub_item IN VARCHAR2,
128 p_qid IN NUMBER,
129 p_pkvalList IN pk_list
130 ) RETURN BOOLEAN;
131
132 FUNCTION storeDeletedPK ( p_pub_item IN VARCHAR2,
133 p_client_name IN VARCHAR2,
134 p_tran_id IN NUMBER,
135 p_seq_no IN NUMBER,
136 p_qid IN NUMBER
137 ) RETURN BOOLEAN;
138
139 FUNCTION purgeSdq RETURN BOOLEAN;
140
141 FUNCTION purgeSdq(p_clientid VARCHAR2) RETURN BOOLEAN;
142
143 PROCEDURE log (p_mesg VARCHAR2);
144
145 FUNCTION isFirstSync RETURN BOOLEAN;
146
147 PROCEDURE reset_all_globals;
148
149 PROCEDURE delete_Sdq( P_Status OUT NOCOPY VARCHAR2,
150 P_Message OUT NOCOPY VARCHAR2);
151
152 --function to verify whether a record shd be inserted into SDQ or not
153 FUNCTION insert_sdq(p_pub_item VARCHAR2,
154 p_user_name VARCHAR2) RETURN boolean;
155
156 --checks whether the record exists in SDQ
157 FUNCTION is_exists(p_clientid VARCHAR2,
158 p_pub_item varchar2,
159 p_access_id NUMBER,
160 p_dml_type CHAR)
161 RETURN boolean;
162
163 FUNCTION get_listfrom_string(p_string1 IN VARCHAR2) RETURN pk_list;
164
165 PROCEDURE delete_synch_history( P_Status OUT NOCOPY VARCHAR2,
166 P_Message OUT NOCOPY VARCHAR2);
167
168 function get_pk(pi_name varchar2,p_qid number)
169 return varchar2;
170
171 procedure user_incompatibility_test(P_status OUT NOCOPY VARCHAR2,
172 P_message OUT NOCOPY VARCHAR2);
173
174 END asg_download;