Skip to Content
0

How to restrict to user Batch detail updation.

Oct 06, 2017 at 03:29 AM

51

avatar image

Hi All,

How to restrict to user Batch detail updation.

Thanks

Danish

cbgl5.png (188.6 kB)
10 |10000 characters needed characters left characters exceeded

help on this

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Oct 07, 2017 at 08:57 AM
0

there is an authorization --> Batch Details. Set it to "No Authorization"

Regards

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Sir through transaction notification

0

---Ist
IF :object_type = '10000044' THEN
Declare temp_var_0 integer;
SELECT
(SELECT Count (*)
FROM OBTN T0
WHERE T0."AbsEntry" <> :list_of_cols_val_tab_del AND T0."LotNumber" =
(SELECT TOP 1 "LotNumber"
FROM OBTN
WHERE "AbsEntry" = :list_of_cols_val_tab_del )) INTO temp_var_0 FROM DUMMY;
IF :temp_var_0 > 0 THEN
SELECT 1, 'Duplicate AR Not Allowed!' INTO error, error_message FROM DUMMY;
END IF;
END IF;

----IInd
IF :Object_Type = '10000044' THEN
Declare temp_VVvar_0 integer;
SELECT
(SELECT "AbsEntry"
FROM OBTN B
WHERE ("LotNumber" <>
(SELECT "LotNumber"
FROM ABTN C
WHERE ("LogInstanc" =
(SELECT COUNT("LogInstanc") AS "Expr1"
FROM ABTN A
WHERE ("AbsEntry" = C."AbsEntry"))) AND ("AbsEntry" = B."AbsEntry"))) AND ("AbsEntry" = :list_of_cols_val_tab_del)) INTO temp_VVvar_0 FROM DUMMY;
IF :temp_VVvar_0 > 0 THEN
error := 406;
error_message := 'U R Not Auth. to change ';
END IF;
END IF;

0