[Home] [Help]
3641: l_group_details_rec_tab group_details_rec_tab_type;
3642:
3643: -- Sort the organization ids to prevent processing of duplicate organization ids
3644: CURSOR c_distinct_organization_id IS
3645: SELECT distinct id FROM wsh_tmp;
3646:
3647: CURSOR c_get_backordered_details(l_batch_id NUMBER) IS
3648: SELECT wdd.delivery_detail_id, wda.delivery_id, wda.parent_delivery_detail_id, wdd.organization_id,
3649: wdd.line_direction, wdd.gross_weight, wdd.net_weight, wdd.volume,
3858: nvl(wpgr.end_date_active, trunc(sysdate)+1);
3859:
3860: CURSOR c_is_print_ps_mode_I IS
3861: select wsp.organization_id
3862: from wsh_shipping_parameters wsp, wsh_tmp wt
3863: where wt.id = wsp.organization_id
3864: and wsp.print_pick_slip_mode = 'I'
3865: and rownum = 1;
3866:
3871: and wsp.print_pick_slip_mode = 'I';
3872:
3873: CURSOR c_prnt_PS_mode_PS_grp IS
3874: select wsp.organization_id
3875: from wsh_shipping_parameters wsp, wsh_tmp wt
3876: where wt.id = wsp.organization_id
3877: and (wsp.print_pick_slip_mode = 'I'
3878: OR exists
3879: (select '1'
4249: IF l_organization_tab.count > 1 AND l_mode IS NULL THEN --{
4250: IF l_debug_on THEN
4251: WSH_DEBUG_SV.log(l_module_name,'Count is more than 1 : ',l_organization_tab.count);
4252: END IF;
4253: DELETE FROM wsh_tmp;
4254:
4255: FORALL i IN l_organization_tab.FIRST..l_organization_tab.LAST
4256: INSERT INTO wsh_tmp (id) VALUES(l_organization_tab(i));
4257:
4252: END IF;
4253: DELETE FROM wsh_tmp;
4254:
4255: FORALL i IN l_organization_tab.FIRST..l_organization_tab.LAST
4256: INSERT INTO wsh_tmp (id) VALUES(l_organization_tab(i));
4257:
4258: OPEN c_distinct_organization_id;
4259: FETCH c_distinct_organization_id BULK COLLECT INTO l_distinct_organization_tab;
4260: CLOSE c_distinct_organization_id;
4317: END IF;
4318:
4319: -- END Bug 5247554.
4320:
4321: DELETE FROM wsh_tmp;
4322:
4323: l_organization_tab.delete;
4324: l_organization_tab := l_distinct_organization_tab;
4325: ELSIF l_organization_tab.count = 1 AND l_mode IS NULL THEN