[Home] [Help]
687: RAISE PARAMETER_COUNT_MISMATCH;
688: END IF;
689: l_ctr := 1;
690:
691: --compares each element in the list with asg_purge_sdq ,asg_complete_Refresh
692: -- and SDQ and constructs a new list.. which is used for further processing.
693: FOR i IN p_accessList.FIRST..p_accessList.LAST
694: LOOP
695: IF (insert_sdq(p_pub_item,p_username_list(i))
2226: log_concprogram('Done deleting SDQ for '||l_tmp_user||' '||
2227: SQL%ROWCOUNT||' rows',
2228: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2229:
2230: DELETE FROM asg_complete_refresh
2231: WHERE user_name = l_dormant_rec.user_name
2232: AND publication_item IN
2233: (SELECT item_id FROM asg_pub_item
2234: WHERE pub_name = l_dormant_rec.pub_name);
2240: /* change this .. has to insert for current publicatino..*/
2241: set_user_first_synch_pub(l_dormant_rec.user_name,
2242: l_dormant_rec.pub_name);
2243: END;
2244: -- delete SDQ and DQ , asg_complete_refresh , asg_purge_sdq and commit.
2245: -- set to complete ref in asg_purge_sdq..
2246: END LOOP;
2247: CLOSE c_dormant_users;
2248:
2278: return values :
2279: If it returns "false" then the record need not be inserted into SDQ ..
2280: it may be that:
2281: 1. records for the pub item or the corresponding publication
2282: exists in asg_complete_refresh or asg_purge_sdq
2283: If the return value is "true" then record is inserted.
2284: --
2285: */
2286:
2290: IS
2291: SELECT pub_name FROM asg_pub_item WHERE item_id = p_pub_item;
2292: CURSOR c_exists_compref(l_pi varchar2,l_un varchar2)
2293: IS
2294: SELECT user_name FROM asg_complete_refresh
2295: WHERE user_name = l_un AND publication_item = l_pi
2296: AND synch_completed = 'N';
2297: CURSOR c_exists_purge(l_pub varchar2,l_un varchar2)
2298: IS