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_DRAFTS_PVT dependencies on PO_EXHIBIT_DETAILS_DRAFT

Line 442: FROM po_exhibit_details_draft pexd

438: --AND poel.entity_name = G_LOCK_EXHIBIT_ENTITY
439: )
440: -- : Stamping revision_num for newly added shipment on mod.
441: OR EXISTS ( SELECT 'New Exhibit'
442: FROM po_exhibit_details_draft pexd
443: WHERE pexd.po_exhibit_details_id = pex.po_exhibit_details_id
444: AND pexd.draft_id = p_draft_id
445: AND pexd.change_status = 'NEW'
446: )

Line 9209: INSERT INTO po_exhibit_details_draft

9205: END IF;
9206:
9207: -- Insert the exhibits that are created in document but does not exist in the PO_EXHIBIT_DETAILS
9208: FORALL idx IN 1..clm_exhibit_name_tbl.Count
9209: INSERT INTO po_exhibit_details_draft
9210: (
9211: po_exhibit_details_id,
9212: exhibit_name,
9213: exhibit_description,

Line 9285: INSERT INTO po_exhibit_details_draft

9281: END IF;
9282:
9283: -- Delete the exhibits that does not exists in document but exist in the PO_EXHIBIT_DETAILS
9284: FORALL idx IN 1..po_exhibit_details_id_tbl.Count
9285: INSERT INTO po_exhibit_details_draft
9286: (
9287: po_exhibit_details_id,
9288: exhibit_name,
9289: exhibit_description,

Line 9316: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details_draft exd

9312: SYSDATE,
9313: fnd_global.user_id,
9314: fnd_global.login_id
9315: FROM dual
9316: WHERE NOT EXISTS (SELECT 1 FROM po_exhibit_details_draft exd
9317: WHERE exd.po_exhibit_details_id = po_exhibit_details_id_tbl(idx)
9318: )
9319: );
9320:

Line 9327: UPDATE po_exhibit_details_draft ex

9323: IF (PO_LOG.d_stmt) THEN
9324: PO_LOG.stmt(d_module,d_position ,'number of rows inserted for deletion ',SQL%ROWCOUNT);
9325: END IF;
9326:
9327: UPDATE po_exhibit_details_draft ex
9328: SET ex.delete_flag = 'Y'
9329: WHERE ex.po_exhibit_details_id IN (SELECT column_value FROM TABLE(po_exhibit_details_id_tbl));
9330:
9331: IF (PO_LOG.d_stmt) THEN

Line 9531: FROM po_exhibit_details_draft pexd,

9527: po_exhibit_mod_p_lock_attrs(
9528: NVL(pexd.exhibit_description ,G_NULL_CHAR),
9529: NVL(pexd.reference_line_id ,G_NULL_NUM)
9530: ) p_lock_attrs
9531: FROM po_exhibit_details_draft pexd,
9532: po_session_gt pogt
9533: WHERE pexd.draft_id = p_draft_id
9534: AND pexd.po_exhibit_details_id = pogt.char1 -- po_exhibit_details_id
9535: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID