| insert by cursor [message #577614] |
Tue, 19 February 2013 01:48  |
 |
n.shahab
Messages: 3
Registered: February 2013
|
Junior Member |
|
|
hi
i want insert in detail block by The following function and I want If the change P2_SLT_ID( id block master )
Clear block detail then Insert new values but Insert a row
Please Please Help
FUNCTION cat_elemnt_insert(P2_SLT_ID NUMBER, p_itca_cod VARCHAR2,P_ERR_LST IN OUT VARCHAR2)
RETURN BOOLEAN is
CURSOR CUR_ITCE IS
SELECT ITCE.ITCE_ITCA_COD ,ITCE.ITCE_FLG_REQUIRED,ITCE.ITCE_ICET_COD,ITCE.ITCE_MSUN_COD
FROM WAM_ITEM_CATALOG_ELEMENTS ITCE
WHERE ITCE.ITCE_ITCA_COD= p_itca_cod;
BEGIN
begin
FOR C IN CUR_ITCE LOOP
DELETE SAL_LAYOUT_SPECIFICATIONS S
WHERE S.SALS_SALT_ID=P2_SLT_ID ;
INSERT INTO SAL_LAYOUT_SPECIFICATIONS(
SALS_ID ,
SALS_SALT_ID ,
SALS_ITCE_ITCA_COD,
SALS_ITCE_ICET_COD ,
SALS_VALUE
) VALUES(
SALS_SEQ.NEXTVAL,
P2_SLT_ID ,
C.ITCE_ITCA_COD,
C.ITCE_ICET_COD ,
NULL);
END LOOP ;
exception
when others then
p_err_lst := p_err_lst||','||substr(sqlerrm,1,9)||',$sal-10037';
RETURN FALSE ;
end;
return TRUE;
END cat_elemnt_insert;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
