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 1153: UPDATE po_drafts DFT

1149: --SQL Why: Since the draft may have incomplete data, we want to prevent
1150: -- others from updating the document until the drafts are removed.
1151: -- The way to remove it is by running PDOI against the same document
1152: -- again.
1153: UPDATE po_drafts DFT
1154: SET DFT.status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
1155: WHERE DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING
1156: AND DFT.draft_id IN
1157: (SELECT PHI.draft_id

Line 1154: SET DFT.status = PO_DRAFTS_PVT.g_status_PDOI_ERROR

1150: -- others from updating the document until the drafts are removed.
1151: -- The way to remove it is by running PDOI against the same document
1152: -- again.
1153: UPDATE po_drafts DFT
1154: SET DFT.status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
1155: WHERE DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING
1156: AND DFT.draft_id IN
1157: (SELECT PHI.draft_id
1158: FROM po_headers_interface PHI

Line 1155: WHERE DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING

1151: -- The way to remove it is by running PDOI against the same document
1152: -- again.
1153: UPDATE po_drafts DFT
1154: SET DFT.status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
1155: WHERE DFT.status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING
1156: AND DFT.draft_id IN
1157: (SELECT PHI.draft_id
1158: FROM po_headers_interface PHI
1159: WHERE PHI.processing_id IN (PO_PDOI_PARAMS.g_processing_id,