[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))
2224: log_concprogram('Done deleting SDQ for '||l_tmp_user||' '||
2225: SQL%ROWCOUNT||' rows',
2226: 'asg_download',FND_LOG.LEVEL_STATEMENT);
2227:
2228: DELETE FROM asg_complete_refresh
2229: WHERE user_name = l_dormant_rec.user_name
2230: AND publication_item IN
2231: (SELECT item_id FROM asg_pub_item
2232: WHERE pub_name = l_dormant_rec.pub_name);
2238: /* change this .. has to insert for current publicatino..*/
2239: set_user_first_synch_pub(l_dormant_rec.user_name,
2240: l_dormant_rec.pub_name);
2241: END;
2242: -- delete SDQ and DQ , asg_complete_refresh , asg_purge_sdq and commit.
2243: -- set to complete ref in asg_purge_sdq..
2244: END LOOP;
2245: CLOSE c_dormant_users;
2246:
2276: return values :
2277: If it returns "false" then the record need not be inserted into SDQ ..
2278: it may be that:
2279: 1. records for the pub item or the corresponding publication
2280: exists in asg_complete_refresh or asg_purge_sdq
2281: If the return value is "true" then record is inserted.
2282: --
2283: */
2284:
2288: IS
2289: SELECT pub_name FROM asg_pub_item WHERE item_id = p_pub_item;
2290: CURSOR c_exists_compref(l_pi varchar2,l_un varchar2)
2291: IS
2292: SELECT user_name FROM asg_complete_refresh
2293: WHERE user_name = l_un AND publication_item = l_pi
2294: AND synch_completed = 'N';
2295: CURSOR c_exists_purge(l_pub varchar2,l_un varchar2)
2296: IS