eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_QUERY_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 32: l_access_list asg_download.access_list;

28: l_sqlerrmsg VARCHAR2(2000);
29: l_mark_dirty boolean;
30: g_pub_item VARCHAR2(30) := 'CSM_QUERY';
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
32: l_access_list asg_download.access_list;
33: l_user_list asg_download.user_list;
34: l_query_id_list QUERY_LIST;
35: l_variable_id_list VARIABLE_LIST;
36:

Line 33: l_user_list asg_download.user_list;

29: l_mark_dirty boolean;
30: g_pub_item VARCHAR2(30) := 'CSM_QUERY';
31: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
32: l_access_list asg_download.access_list;
33: l_user_list asg_download.user_list;
34: l_query_id_list QUERY_LIST;
35: l_variable_id_list VARIABLE_LIST;
36:
37: -- Cursor Declaration

Line 197: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,

193: FETCH c_query_del BULK COLLECT INTO l_access_list,l_user_list LIMIT 1000;
194: EXIT WHEN l_access_list.count = 0;
195:
196: FOR i IN 1..l_access_list.count LOOP
197: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,
198: p_accessid => l_access_list(i),
199: p_userid => l_user_list(i),
200: p_dml => asg_download.del,
201: p_timestamp => l_run_date);

Line 200: p_dml => asg_download.del,

196: FOR i IN 1..l_access_list.count LOOP
197: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,
198: p_accessid => l_access_list(i),
199: p_userid => l_user_list(i),
200: p_dml => asg_download.del,
201: p_timestamp => l_run_date);
202:
203: END LOOP;
204: FORALL i IN 1..l_access_list.count

Line 227: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,

223: FETCH c_query_variables_del BULK COLLECT INTO l_access_list,l_user_list LIMIT 1000;
224: EXIT WHEN l_access_list.count = 0;
225:
226: FOR i IN 1..l_access_list.count LOOP
227: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,
228: p_accessid => l_access_list(i),
229: p_userid => l_user_list(i),
230: p_dml => asg_download.del,
231: p_timestamp => l_run_date);

Line 230: p_dml => asg_download.del,

226: FOR i IN 1..l_access_list.count LOOP
227: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,
228: p_accessid => l_access_list(i),
229: p_userid => l_user_list(i),
230: p_dml => asg_download.del,
231: p_timestamp => l_run_date);
232:
233: END LOOP;
234: FORALL i IN 1..l_access_list.count

Line 257: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,

253: FETCH c_query_instances_del BULK COLLECT INTO l_access_list,l_user_list LIMIT 1000;
254: EXIT WHEN l_access_list.count = 0;
255:
256: FOR i IN 1..l_access_list.count LOOP
257: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
258: p_accessid => l_access_list(i),
259: p_userid => l_user_list(i),
260: p_dml => asg_download.del,
261: p_timestamp => l_run_date);

Line 260: p_dml => asg_download.del,

256: FOR i IN 1..l_access_list.count LOOP
257: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qins,
258: p_accessid => l_access_list(i),
259: p_userid => l_user_list(i),
260: p_dml => asg_download.del,
261: p_timestamp => l_run_date);
262:
263: END LOOP;
264: FORALL i IN 1..l_access_list.count

Line 287: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qval,

283: FETCH c_query_variables_val_del BULK COLLECT INTO l_access_list,l_user_list LIMIT 1000;
284: EXIT WHEN l_access_list.count = 0;
285:
286: FOR i IN 1..l_access_list.count LOOP
287: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qval,
288: p_accessid => l_access_list(i),
289: p_userid => l_user_list(i),
290: p_dml => asg_download.del,
291: p_timestamp => l_run_date);

Line 290: p_dml => asg_download.del,

286: FOR i IN 1..l_access_list.count LOOP
287: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qval,
288: p_accessid => l_access_list(i),
289: p_userid => l_user_list(i),
290: p_dml => asg_download.del,
291: p_timestamp => l_run_date);
292:
293: END LOOP;
294: FORALL i IN 1..l_access_list.count

Line 317: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,

313: FETCH c_query_results_del BULK COLLECT INTO l_access_list,l_user_list LIMIT 1000;
314: EXIT WHEN l_access_list.count = 0;
315:
316: FOR i IN 1..l_access_list.count LOOP
317: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
318: p_accessid => l_access_list(i),
319: p_userid => l_user_list(i),
320: p_dml => asg_download.del,
321: p_timestamp => l_run_date);

Line 320: p_dml => asg_download.del,

316: FOR i IN 1..l_access_list.count LOOP
317: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qres,
318: p_accessid => l_access_list(i),
319: p_userid => l_user_list(i),
320: p_dml => asg_download.del,
321: p_timestamp => l_run_date);
322:
323: END LOOP;
324: FORALL i IN 1..l_access_list.count

Line 351: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,

347: FETCH c_query_upd BULK COLLECT INTO l_access_list,l_user_list LIMIT 1000;
348: EXIT WHEN l_access_list.count = 0;
349:
350: FOR i IN 1..l_access_list.count LOOP
351: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,
352: p_accessid => l_access_list(i),
353: p_userid => l_user_list(i),
354: p_dml => asg_download.upd,
355: p_timestamp => l_run_date);

Line 354: p_dml => asg_download.upd,

350: FOR i IN 1..l_access_list.count LOOP
351: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,
352: p_accessid => l_access_list(i),
353: p_userid => l_user_list(i),
354: p_dml => asg_download.upd,
355: p_timestamp => l_run_date);
356:
357: END LOOP;
358: COMMIT;

Line 378: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,

374: FETCH c_query_var_upd BULK COLLECT INTO l_access_list,l_user_list LIMIT 1000;
375: EXIT WHEN l_access_list.count = 0;
376:
377: FOR i IN 1..l_access_list.count LOOP
378: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,
379: p_accessid => l_access_list(i),
380: p_userid => l_user_list(i),
381: p_dml => asg_download.upd,
382: p_timestamp => l_run_date);

Line 381: p_dml => asg_download.upd,

377: FOR i IN 1..l_access_list.count LOOP
378: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,
379: p_accessid => l_access_list(i),
380: p_userid => l_user_list(i),
381: p_dml => asg_download.upd,
382: p_timestamp => l_run_date);
383:
384: END LOOP;
385: COMMIT;

Line 409: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,

405: FETCH c_query_ins BULK COLLECT INTO l_access_list,l_user_list,l_query_id_list LIMIT 1000;
406: EXIT WHEN l_access_list.count = 0;
407:
408: FOR i IN 1..l_access_list.count LOOP
409: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,
410: p_accessid => l_access_list(i),
411: p_userid => l_user_list(i),
412: p_dml => asg_download.ins,
413: p_timestamp => l_run_date);

Line 412: p_dml => asg_download.ins,

408: FOR i IN 1..l_access_list.count LOOP
409: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,
410: p_accessid => l_access_list(i),
411: p_userid => l_user_list(i),
412: p_dml => asg_download.ins,
413: p_timestamp => l_run_date);
414:
415: END LOOP;
416: FORALL i IN 1..l_access_list.count

Line 461: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,

457: FETCH c_query_var_ins BULK COLLECT INTO l_access_list,l_user_list,l_query_id_list,l_variable_id_list LIMIT 1000;
458: EXIT WHEN l_access_list.count = 0;
459:
460: FOR i IN 1..l_access_list.count LOOP
461: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,
462: p_accessid => l_access_list(i),
463: p_userid => l_user_list(i),
464: p_dml => asg_download.ins,
465: p_timestamp => l_run_date);

Line 464: p_dml => asg_download.ins,

460: FOR i IN 1..l_access_list.count LOOP
461: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,
462: p_accessid => l_access_list(i),
463: p_userid => l_user_list(i),
464: p_dml => asg_download.ins,
465: p_timestamp => l_run_date);
466:
467: END LOOP;
468: FORALL i IN 1..l_access_list.count

Line 536: l_access_list asg_download.access_list;

532: TYPE VARIABLE_LIST IS TABLE OF CSM_QUERY_VARIABLES_B.VARIABLE_ID%TYPE INDEX BY BINARY_INTEGER;
533: l_sqlerrno VARCHAR2(20);
534: l_sqlerrmsg VARCHAR2(2000);
535: l_mark_dirty boolean;
536: l_access_list asg_download.access_list;
537: l_user_list asg_download.user_list;
538: l_query_id_list QUERY_LIST;
539: l_variable_id_list VARIABLE_LIST;
540:

Line 537: l_user_list asg_download.user_list;

533: l_sqlerrno VARCHAR2(20);
534: l_sqlerrmsg VARCHAR2(2000);
535: l_mark_dirty boolean;
536: l_access_list asg_download.access_list;
537: l_user_list asg_download.user_list;
538: l_query_id_list QUERY_LIST;
539: l_variable_id_list VARIABLE_LIST;
540:
541: -- Cursor Declaration

Line 621: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,

617: sysdate,
618: fnd_global.login_id);
619:
620: FOR i IN 1..l_access_list.count LOOP
621: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,
622: p_accessid => l_access_list(i),
623: p_userid => l_user_list(i),
624: p_dml => asg_download.ins,
625: p_timestamp => sysdate);

Line 624: p_dml => asg_download.ins,

620: FOR i IN 1..l_access_list.count LOOP
621: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qry,
622: p_accessid => l_access_list(i),
623: p_userid => l_user_list(i),
624: p_dml => asg_download.ins,
625: p_timestamp => sysdate);
626:
627: END LOOP;
628: END LOOP;

Line 678: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,

674: fnd_global.login_id,
675: l_access_list(i));
676:
677: FOR i IN 1..l_access_list.count LOOP
678: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,
679: p_accessid => l_access_list(i),
680: p_userid => l_user_list(i),
681: p_dml => asg_download.ins,
682: p_timestamp => sysdate);

Line 681: p_dml => asg_download.ins,

677: FOR i IN 1..l_access_list.count LOOP
678: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => g_pub_item_qvar,
679: p_accessid => l_access_list(i),
680: p_userid => l_user_list(i),
681: p_dml => asg_download.ins,
682: p_timestamp => sysdate);
683:
684: END LOOP;
685: