APPS.ASG_PERF dependencies on ASG_BASE

Line 64: IF (g_first_synch = asg_base.G_YES) THEN

60: log_newline();
61: log('User: ' || g_user_name);
62: log('Database: ' || l_db_instance);
63:
64: IF (g_first_synch = asg_base.G_YES) THEN
65: log('Type of Synch: COMPLETE REFRESH');
66: ELSE
67: log('Type of Synch: INCREMENTAL REFRESH');
68: END IF;

Line 104: IF(p_first_synch = asg_base.G_YES) THEN

100: l_comp_ref VARCHAR2(1);
101: l_query_string VARCHAR2(512);
102: BEGIN
103:
104: IF(p_first_synch = asg_base.G_YES) THEN
105: l_comp_ref := 'Y';
106: ELSE
107: l_comp_ref := 'N';
108: END IF;

Line 110: l_query_string := 'insert into ' || asg_base.G_OLITE_SCHEMA ||

106: ELSE
107: l_comp_ref := 'N';
108: END IF;
109:
110: l_query_string := 'insert into ' || asg_base.G_OLITE_SCHEMA ||
111: '.c$pub_list_q(name, comp_ref) ' ||
112: ' values (:1, :2)';
113: EXECUTE IMMEDIATE l_query_string
114: USING p_pub_item, l_comp_ref;

Line 116: IF p_first_synch = asg_base.G_YES THEN

112: ' values (:1, :2)';
113: EXECUTE IMMEDIATE l_query_string
114: USING p_pub_item, l_comp_ref;
115:
116: IF p_first_synch = asg_base.G_YES THEN
117: g_last_tran_id := -1;
118: g_curr_tran_id := 1;
119: ELSE
120: SELECT max(transaction_id) into g_last_tran_id

Line 186: IF(p_first_synch = asg_base.G_YES) THEN

182: l_comp_ref VARCHAR2(1);
183: l_query_string VARCHAR2(512);
184: BEGIN
185:
186: IF(p_first_synch = asg_base.G_YES) THEN
187: l_comp_ref := 'Y';
188: ELSE
189: l_comp_ref := 'N';
190: END IF;

Line 192: l_query_string := 'insert into ' || asg_base.G_OLITE_SCHEMA ||

188: ELSE
189: l_comp_ref := 'N';
190: END IF;
191:
192: l_query_string := 'insert into ' || asg_base.G_OLITE_SCHEMA ||
193: '.c$pub_list_q(name, comp_ref) ' ||
194: ' select publication_item, ''' || l_comp_ref || '''' ||
195: ' from ' || asg_base.G_OLITE_SCHEMA ||
196: '.c$all_client_items ' ||

Line 195: ' from ' || asg_base.G_OLITE_SCHEMA ||

191:
192: l_query_string := 'insert into ' || asg_base.G_OLITE_SCHEMA ||
193: '.c$pub_list_q(name, comp_ref) ' ||
194: ' select publication_item, ''' || l_comp_ref || '''' ||
195: ' from ' || asg_base.G_OLITE_SCHEMA ||
196: '.c$all_client_items ' ||
197: ' where clientid = :1 ' ||
198: ' and publication_item in ' ||
199: ' (select name from asg_pub_item)';

Line 203: IF p_first_synch = asg_base.G_YES THEN

199: ' (select name from asg_pub_item)';
200: EXECUTE IMMEDIATE l_query_string
201: USING p_user_name;
202:
203: IF p_first_synch = asg_base.G_YES THEN
204: g_last_tran_id := -1;
205: g_curr_tran_id := 1;
206: ELSE
207: SELECT max(transaction_id) into g_last_tran_id

Line 249: 'FROM ' || asg_base.G_OLITE_SCHEMA ||'.' ||'c$pub_list_q';

245: begin
246:
247: l_select_pi_sqlstring :=
248: 'SELECT name ' ||
249: 'FROM ' || asg_base.G_OLITE_SCHEMA ||'.' ||'c$pub_list_q';
250:
251: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
252: DBMS_SQL.PARSE (l_cursor_id, l_select_pi_sqlstring, DBMS_SQL.v7);
253: DBMS_SQL.DEFINE_COLUMN (l_cursor_id, 1, l_curr_pub_item, 30);

Line 274: l_query_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||

270: PROCEDURE cleanup_setup
271: IS
272: l_query_string VARCHAR2(512);
273: BEGIN
274: l_query_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
275: '.c$pub_list_q';
276: EXECUTE IMMEDIATE l_query_string;
277: asg_base.reset_all_globals();
278: asg_download.reset_all_globals();

Line 277: asg_base.reset_all_globals();

273: BEGIN
274: l_query_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
275: '.c$pub_list_q';
276: EXECUTE IMMEDIATE l_query_string;
277: asg_base.reset_all_globals();
278: asg_download.reset_all_globals();
279: rollback;
280: END cleanup_setup;
281:

Line 289: g_first_synch := asg_base.G_YES;

285: PROCEDURE get_first_synch_report(p_user_name IN VARCHAR2)
286: IS
287: BEGIN
288: g_user_name := upper(p_user_name);
289: g_first_synch := asg_base.G_YES;
290: g_pub_item := null;
291:
292: print_header();
293: setup_download(g_user_name, g_first_synch);

Line 306: g_first_synch := asg_base.G_NO;

302: PROCEDURE get_incremental_synch_report(p_user_name IN VARCHAR2)
303: IS
304: BEGIN
305: g_user_name := upper(p_user_name);
306: g_first_synch := asg_base.G_NO;
307: g_pub_item := null;
308:
309: print_header();
310: setup_download(g_user_name, g_first_synch);

Line 324: g_first_synch := asg_base.G_YES;

320: p_pub_item IN VARCHAR2)
321: IS
322: BEGIN
323: g_user_name := upper(p_user_name);
324: g_first_synch := asg_base.G_YES;
325: g_pub_item := upper(p_pub_item);
326:
327: print_header();
328: setup_pub_item_download(g_user_name, g_pub_item, g_first_synch);

Line 342: g_first_synch := asg_base.G_NO;

338: p_pub_item IN VARCHAR2)
339: IS
340: BEGIN
341: g_user_name := upper(p_user_name);
342: g_first_synch := asg_base.G_NO;
343: g_pub_item := upper(p_pub_item);
344:
345: print_header();
346: setup_pub_item_download(g_user_name, g_pub_item, g_first_synch);