[Home] [Help]
3729: l_group_details_rec_tab group_details_rec_tab_type;
3730:
3731: -- Sort the organization ids to prevent processing of duplicate organization ids
3732: CURSOR c_distinct_organization_id IS
3733: SELECT distinct id FROM wsh_tmp;
3734:
3735: CURSOR c_get_backordered_details(l_batch_id NUMBER) IS
3736: SELECT wdd.delivery_detail_id, wda.delivery_id, wda.parent_delivery_detail_id, wdd.organization_id,
3737: wdd.line_direction, wdd.gross_weight, wdd.net_weight, wdd.volume,
3948: nvl(wpgr.end_date_active, trunc(sysdate)+1);
3949:
3950: CURSOR c_is_print_ps_mode_I IS
3951: select wsp.organization_id
3952: from wsh_shipping_parameters wsp, wsh_tmp wt
3953: where wt.id = wsp.organization_id
3954: and wsp.print_pick_slip_mode = 'I'
3955: and rownum = 1;
3956:
3961: and wsp.print_pick_slip_mode = 'I';
3962:
3963: CURSOR c_prnt_PS_mode_PS_grp IS
3964: select wsp.organization_id
3965: from wsh_shipping_parameters wsp, wsh_tmp wt
3966: where wt.id = wsp.organization_id
3967: and (wsp.print_pick_slip_mode = 'I'
3968: OR exists
3969: (select '1'
4341: IF l_organization_tab.count > 1 AND l_mode IS NULL THEN --{
4342: IF l_debug_on THEN
4343: WSH_DEBUG_SV.log(l_module_name,'Count is more than 1 : ',l_organization_tab.count);
4344: END IF;
4345: DELETE FROM wsh_tmp;
4346:
4347: FORALL i IN l_organization_tab.FIRST..l_organization_tab.LAST
4348: INSERT INTO wsh_tmp (id) VALUES(l_organization_tab(i));
4349:
4344: END IF;
4345: DELETE FROM wsh_tmp;
4346:
4347: FORALL i IN l_organization_tab.FIRST..l_organization_tab.LAST
4348: INSERT INTO wsh_tmp (id) VALUES(l_organization_tab(i));
4349:
4350: OPEN c_distinct_organization_id;
4351: FETCH c_distinct_organization_id BULK COLLECT INTO l_distinct_organization_tab;
4352: CLOSE c_distinct_organization_id;
4409: END IF;
4410:
4411: -- END Bug 5247554.
4412:
4413: DELETE FROM wsh_tmp;
4414:
4415: l_organization_tab.delete;
4416: l_organization_tab := l_distinct_organization_tab;
4417: ELSIF l_organization_tab.count = 1 AND l_mode IS NULL THEN