<?xml version="1.0"?>
<queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

    <fullquery name="user_curriculum_map_insert">
        <querytext>
         insert into cu_user_curriculum_map
         (user_id, curriculum_id, package_id)
         select :user_id,
                :curriculum_id,
                :package_id
         from   dual
         where  not exists (select 1
                            from   cu_user_curriculum_map
                            where  user_id = :user_id
                            and    curriculum_id = :curriculum_id)
        </querytext>
    </fullquery>

    <fullquery name="desired_curriculums">
        <querytext>
            select   curriculum_id
            from     cu_curriculums
            where    package_id = :package_id
            MINUS
            select   curriculum_id
            from     cu_user_curriculum_map
            where    user_id = :user_id
            and      package_id = :package_id
        </querytext>
    </fullquery>

</queryset>