DBA Data[Home] [Help]

APPS.PO_DOCS_INTERFACE_PURGE dependencies on PO_DRAFTS

Line 201: l_draft_id PO_DRAFTS.draft_id%TYPE;

197: d_position NUMBER;
198:
199: l_new_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
200:
201: l_draft_id PO_DRAFTS.draft_id%TYPE;
202: l_request_id PO_DRAFTS.request_id%TYPE;
203: l_old_request_complete VARCHAR2(1);
204: l_need_collapsing BOOLEAN := FALSE;
205:

Line 202: l_request_id PO_DRAFTS.request_id%TYPE;

198:
199: l_new_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
200:
201: l_draft_id PO_DRAFTS.draft_id%TYPE;
202: l_request_id PO_DRAFTS.request_id%TYPE;
203: l_old_request_complete VARCHAR2(1);
204: l_need_collapsing BOOLEAN := FALSE;
205:
206: l_cur_index NUMBER;

Line 230: PO_DRAFTS_PVT.find_draft

226: -- if user wants to purge the intf record that is still in process, make
227: -- sure that the drafts are removed and locks are released, if the
228: -- record is no longer being touched.
229:
230: PO_DRAFTS_PVT.find_draft
231: ( p_po_header_id => p_po_header_id,
232: x_draft_id => l_draft_id
233: );
234:

Line 238: PO_DRAFTS_PVT.get_request_id

234:
235: d_position := 30;
236:
237: IF (l_draft_id IS NOT NULL) THEN
238: PO_DRAFTS_PVT.get_request_id
239: ( p_draft_id => l_draft_id,
240: x_request_id => l_request_id
241: );
242:

Line 258: PO_DRAFTS_PVT.unlock_document

254:
255: IF (l_old_request_complete = FND_API.G_TRUE) THEN
256: d_position := 50;
257:
258: PO_DRAFTS_PVT.unlock_document
259: ( p_po_header_id => p_po_header_id
260: );
261: ELSE
262: d_position := 60;