chapter 9: Limiting Access to Items Functionality Verification Needed

peace95 · July 17th, 2009, 07:10 AM

Hi:
Chapter 9 Limiting Access to Items, pp.284 - 288, exercise #4 on page 286 in particular, does not retain the date entered by the MANAGER. I also read the last paragraph at the bottom of page 287. However, my suspicion for why it is not retaining the entered date is due to the calculation of the ORDER_SHIP_DATE from pp.246-249.

My resolution is as follows:

Code:

1.  Return to the development environment and select the master-detail page to edit.
 
2   Select from Page Processing column>Computatiions Section, Pn_ORDER_SHIP_DATE.
 
3.  Select [Computations] for the PL/SQL code added from Chapter 8.
 

4.  Insert the following after begin:if :APP_USER = 'MANAGER'
then
return (:Pn_ORDER_SHIP_DATE);   where n is the number of master-detail page
else
5.  Scroll to bottom of PL/SQL code, just above the return statement, add:end if;
6.  Click Apply Changes.

The above code accepts any and all dates the Manager enters.

QUESTION: Could I have made the the computation conditional instead of unconditional and added the PL/SQL code of the :APP_USER ='MANAGER' statement as Expression1 and the Return(:P4_ORDER_SHIP_DATE) as Expression 2 and get the same results?

Thanks in advance.