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.PO_DOCUMENT_CANCEL_PVT dependencies on DUAL

Line 223: FROM DUAL

219: --Canceling Header
220: l_progress := '002';
221: SELECT 1
222: INTO l_partial_rcv_bld
223: FROM DUAL
224: WHERE EXISTS (SELECT 1
225: FROM po_line_locations
226: WHERE ( (p_document_type <>c_doc_type_RELEASE
227: AND po_header_id = p_entity_id)

Line 241: FROM DUAL

237: --Canceling Line
238: l_progress := '003' ;
239: SELECT 1
240: INTO l_partial_rcv_bld
241: FROM DUAL
242: WHERE EXISTS (SELECT 1
243: FROM po_line_locations
244: WHERE po_line_id = p_entity_id
245: AND NVL(cancel_flag, 'N') <> 'Y'

Line 255: FROM DUAL

251: --Canceling Shipment
252: l_progress := '004';
253: SELECT 1
254: INTO l_partial_rcv_bld
255: FROM DUAL
256: WHERE EXISTS(SELECT 1
257: FROM po_line_locations
258: WHERE line_location_id = p_entity_id
259: AND NVL(cancel_flag, 'N') <> 'Y'

Line 3563: FROM SYS.DUAL;

3559: l_progress := '002' ;
3560:
3561: SELECT PO_REQUISITION_LINES_S.NEXTVAL
3562: INTO x_new_line_id
3563: FROM SYS.DUAL;
3564:
3565: IF g_debug_stmt THEN
3566: PO_DEBUG.debug_var(d_module, l_progress, 'x_new_line_id', x_new_line_id);
3567: PO_DEBUG.debug_var(d_module, l_progress, 'l_next_line_num', l_next_line_num);

Line 6019: -- and not individual entity id

6015:
6016: l_progress := '007' ;
6017:
6018: -- Calling update closed code only once for a document header id
6019: -- and not individual entity id
6020: -- So Checking if this is the last entity or the next entity belongs
6021: -- to a different doc_id.If So,then making a call to update closed code.
6022: -- This is based on the assumption/fact that the records in
6023: -- l_entity_rec_tbl are sorted based on doc_id.This soring is done