eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PODUS dependencies on PO_REQUISITION_HEADERS

Line 10: UPDATE po_requisition_headers porh

6: p_new_status in varchar2 ) is
7: --
8: begin
9: --
10: UPDATE po_requisition_headers porh
11: SET porh.authorization_status = p_new_status,
12: porh.last_update_date = sysdate,
13: porh.last_updated_by = fnd_global.user_id,
14: porh.last_update_login = fnd_global.login_id

Line 126: l_old_status po_requisition_headers.authorization_status%TYPE;

122: p_emp_id in number,
123: p_note in varchar2,
124: p_new_status in varchar2 ) is
125: --
126: l_old_status po_requisition_headers.authorization_status%TYPE;
127: --
128: begin
129: select porh.authorization_status
130: into l_old_status

Line 131: from po_requisition_headers porh

127: --
128: begin
129: select porh.authorization_status
130: into l_old_status
131: from po_requisition_headers porh
132: where porh.requisition_header_id = p_requisition_header_id;
133: --
134: --
135: if ( l_old_status in ( 'INCOMPLETE', 'RETURNED', 'REJECTED', 'REQUIRES REAPPROVAL') ) then