How to hide a tabpages in a tab canvas
Hi All,
I am using oracle Apps R12.2 and forms 10g version
I have Tab canvas in my page and it contain two page.
My requirement is when the user is "PROC HEAD" means the Tab_page2 is Visible and able to acces.When other user logged means the tab should be grade out.
I have tried so for is i have written my code in When New form Instance trigger
And this is my code.
declare
tp_id TAB_PAGE;
v_user_id number;
begin
select user_id into v_user_id from fnd_user where user_name='PROC HEAD';
if fnd_global.user_id= v_user_id then
tp_id :=FIND_TAB_PAGE('EXPEDITOR');
SET_TAB_PAGE_PROPERTY(tp_id, visible, property_true);
else
SET_TAB_PAGE_PROPERTY(tp_id, visible, property_false);
end if;
Can any pls correct me where i went wrong.
Thanks & Regards
Srikkanth
end;