createorreplaceprocedureUP_cc_stand_bom_IOASCURSORCORisSELECTitem,item_class,item_d,item_d_class,net_qty,start_date,end_date,remarkFROMcc_stand_bom_temp_io;itemvarchar2(1...
create or replace procedure UP_cc_stand_bom_IO
AS
CURSOR COR is SELECT item,item_class,item_d,item_d_class,net_qty,start_date,end_date,remark FROM cc_stand_bom_temp_io;
item varchar2(128);
item_class varchar2(1);
item_d varchar2(128);
item_d_class varchar2(1);
net_qty number(18,8);
start_date datet;
end_date date;
remark varchar2(256);
v_count number;
rec_COR COR%rowtype;
begin
FOR rec_COR in COR loop
OPEN COR;
begin
WHILE FETCH_STATUS=0 loop
BEGIN
SELECT COUNT(*)into v_count FROM cc_stand_bom_io WHERE item=item and item_d=item_d and start_date=start_date;
IF v_count>0
<