425: VALUES
426: (l_access_list(i),
427: l_user_list(i),
428: l_query_id_list(i),
429: fnd_global.user_id,
430: l_run_date,
431: fnd_global.user_id,
432: l_run_date,
433: fnd_global.login_id);
427: l_user_list(i),
428: l_query_id_list(i),
429: fnd_global.user_id,
430: l_run_date,
431: fnd_global.user_id,
432: l_run_date,
433: fnd_global.login_id);
434:
435: COMMIT;
429: fnd_global.user_id,
430: l_run_date,
431: fnd_global.user_id,
432: l_run_date,
433: fnd_global.login_id);
434:
435: COMMIT;
436:
437: END LOOP;
481: (l_access_list(i),
482: l_user_list(i),
483: l_query_id_list(i),
484: l_variable_id_list(i),
485: fnd_global.user_id,
486: l_run_date,
487: fnd_global.user_id,
488: l_run_date,
489: fnd_global.login_id,
483: l_query_id_list(i),
484: l_variable_id_list(i),
485: fnd_global.user_id,
486: l_run_date,
487: fnd_global.user_id,
488: l_run_date,
489: fnd_global.login_id,
490: l_access_list(i));
491:
485: fnd_global.user_id,
486: l_run_date,
487: fnd_global.user_id,
488: l_run_date,
489: fnd_global.login_id,
490: l_access_list(i));
491:
492: COMMIT;
493:
610: VALUES
611: (l_access_list(i),
612: l_user_list(i),
613: l_query_id_list(i),
614: fnd_global.user_id,
615: sysdate,
616: fnd_global.user_id,
617: sysdate,
618: fnd_global.login_id);
612: l_user_list(i),
613: l_query_id_list(i),
614: fnd_global.user_id,
615: sysdate,
616: fnd_global.user_id,
617: sysdate,
618: fnd_global.login_id);
619:
620: FOR i IN 1..l_access_list.count LOOP
614: fnd_global.user_id,
615: sysdate,
616: fnd_global.user_id,
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),
666: (l_access_list(i),
667: l_user_list(i),
668: l_query_id_list(i),
669: l_variable_id_list(i),
670: fnd_global.user_id,
671: sysdate,
672: fnd_global.user_id,
673: sysdate,
674: fnd_global.login_id,
668: l_query_id_list(i),
669: l_variable_id_list(i),
670: fnd_global.user_id,
671: sysdate,
672: fnd_global.user_id,
673: sysdate,
674: fnd_global.login_id,
675: l_access_list(i));
676:
670: fnd_global.user_id,
671: sysdate,
672: fnd_global.user_id,
673: sysdate,
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,