[Home] [Help]
229: and ms.applied =2;
230:
231: CURSOR cur_demand_order IS
232: -- SELECT 1
233: -- FROM msc_demands md
234: -- where md.plan_id = p_plan_id
235: -- and md.release_errors is null
236: -- and md.load_type =30
237: -- and MD.ORIGINATION_TYPE = 30
241: -- and md.applied =2;
242:
243: select 1 from dual
244: where exists ( SELECT /*+ first_rows */ 1
245: FROM msc_demands md
246: where md.plan_id = p_plan_id
247: and md.release_errors is null
248: and md.load_type =30
249: and MD.ORIGINATION_TYPE = 30
893: AND mtp.partner_type =3
894: AND mtps.partner_id = mtp.partner_id;
895:
896: cursor is_so_line_split_c is
897: select nvl(sales_order_line_split, 2) from msc_demands dem
898: where dem.demand_id=p_transaction_id
899: and p_source_table='MSC_DEMANDS'
900: and dem.plan_id=p_plan_id
901: and dem.sr_instance_id=p_inst_id
895:
896: cursor is_so_line_split_c is
897: select nvl(sales_order_line_split, 2) from msc_demands dem
898: where dem.demand_id=p_transaction_id
899: and p_source_table='MSC_DEMANDS'
900: and dem.plan_id=p_plan_id
901: and dem.sr_instance_id=p_inst_id
902: and dem.organization_id=P_org_id;
903:
985:
986:
987:
988: /* not able to release sales order */
989: if (p_source_table ='MSC_DEMANDS' and p_order_type=30) then
990: p_rel_error := msc_rel_wf.verify_so_release(p_plan_id,p_transaction_id,p_inst_id);
991: if (p_rel_error is not null) then
992: return p_rel_error;
993: end if;
1028:
1029: end if;
1030:
1031: -- additional check to ensure for so line split, release is not allowed.
1032: if p_source_table='MSC_DEMANDS' and p_order_type=30 then
1033: open is_so_line_split_c;
1034: fetch is_so_line_split_c into l_so_line;
1035: close is_so_line_split_c;
1036: if l_so_line = 1 then