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_PDOI_PVT dependencies on PO_DRAFTS

Line 1160: UPDATE po_drafts DFT

1156: --SQL Why: Since the draft may have incomplete data, we want to prevent
1157: -- others from updating the document until the drafts are removed.
1158: -- The way to remove it is by running PDOI against the same document
1159: -- again.
1160: UPDATE po_drafts DFT
1161: SET DFT.status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
1162: WHERE DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING
1163: AND DFT.draft_id IN
1164: (SELECT PHI.draft_id

Line 1161: SET DFT.status = PO_DRAFTS_PVT.g_status_PDOI_ERROR

1157: -- others from updating the document until the drafts are removed.
1158: -- The way to remove it is by running PDOI against the same document
1159: -- again.
1160: UPDATE po_drafts DFT
1161: SET DFT.status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
1162: WHERE DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING
1163: AND DFT.draft_id IN
1164: (SELECT PHI.draft_id
1165: FROM po_headers_interface PHI

Line 1162: WHERE DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING

1158: -- The way to remove it is by running PDOI against the same document
1159: -- again.
1160: UPDATE po_drafts DFT
1161: SET DFT.status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
1162: WHERE DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING
1163: AND DFT.draft_id IN
1164: (SELECT PHI.draft_id
1165: FROM po_headers_interface PHI
1166: WHERE PHI.processing_id IN (PO_PDOI_PARAMS.g_processing_id,