DBA Data[Home] [Help]

APPS.CSM_ACC_PKG dependencies on ASG_DOWNLOAD

Line 318: l_rc := asg_download.markDirty(p_publication_item_names(i), l_access_id, l_resource_id, 'I', sysdate );

314: FETCH c_get_resource INTO l_resource_id;
315: CLOSE c_get_resource;
316: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user
317: FOR i IN 1 .. p_publication_item_names.LAST LOOP
318: l_rc := asg_download.markDirty(p_publication_item_names(i), l_access_id, l_resource_id, 'I', sysdate );
319: END LOOP;
320: END IF;
321: END IF;
322:

Line 469: l_rc := asg_download.markDirty( p_publication_item_names(j), l_tab_access_id(i)

465: CLOSE c_get_resource;
466:
467: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user
468: FOR j IN 1 .. p_publication_item_names.LAST LOOP
469: l_rc := asg_download.markDirty( p_publication_item_names(j), l_tab_access_id(i)
470: , l_resource_id, 'D', sysdate );
471: END LOOP;
472: END IF;
473: END LOOP;

Line 563: l_rc := asg_download.markDirty(p_publication_item_names(i), p_access_id, l_resource_id, 'U', sysdate );

559: CLOSE c_get_resource;
560: IF l_resource_id IS NOT NULL THEN --do mark diry only for valid MFS user
561: --call update outqueue ASG call *****************************************
562: FOR i IN 1 .. p_publication_item_names.LAST LOOP
563: l_rc := asg_download.markDirty(p_publication_item_names(i), p_access_id, l_resource_id, 'U', sysdate );
564: END LOOP;
565: END IF;
566: EXCEPTION
567: WHEN OTHERS THEN