APPS.PO_PDOI_HEADER_GROUPING_PVT dependencies on PO_DRAFTS_PVT

Line 342: l_status PO_DRAFTS.status%TYPE := PO_DRAFTS_PVT.g_status_PDOI_PROCESSING;

338: l_tmp_draft_owner_role PO_DRAFTS.owner_role%TYPE;
339: l_new_draft_needed VARCHAR2(1);
340: l_return_status VARCHAR2(1);
341:
342: l_status PO_DRAFTS.status%TYPE := PO_DRAFTS_PVT.g_status_PDOI_PROCESSING;
343:
344: l_locking_allowed VARCHAR2(1);
345: l_message VARCHAR2(30);
346:

Line 395: PO_DRAFTS_PVT.find_draft

391: -- If we are updating a document, a draft for the document may or may
392: -- not exist. if the draft exists, reuse it; if not, create a new
393: -- draft
394:
395: PO_DRAFTS_PVT.find_draft
396: ( p_po_header_id => l_po_header_id_tbl(i),
397: x_draft_id => l_tmp_draft_id,
398: x_draft_status => l_tmp_draft_status,
399: x_draft_owner_role => l_tmp_draft_owner_role

Line 414: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;

410:
411: -- need to create a new draft
412: l_new_dft_idx_tbl.extend;
413: l_new_dft_idx_tbl(l_new_dft_idx_tbl.COUNT) := i;
414: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
415:
416: ELSE
417: IF (l_tmp_draft_status IN (PO_DRAFTS_PVT.g_status_PDOI_PROCESSING,
418: PO_DRAFTS_PVT.g_status_PDOI_ERROR)) THEN

Line 417: IF (l_tmp_draft_status IN (PO_DRAFTS_PVT.g_status_PDOI_PROCESSING,

413: l_new_dft_idx_tbl(l_new_dft_idx_tbl.COUNT) := i;
414: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
415:
416: ELSE
417: IF (l_tmp_draft_status IN (PO_DRAFTS_PVT.g_status_PDOI_PROCESSING,
418: PO_DRAFTS_PVT.g_status_PDOI_ERROR)) THEN
419:
420: d_position := 50;
421:

Line 418: PO_DRAFTS_PVT.g_status_PDOI_ERROR)) THEN

414: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
415:
416: ELSE
417: IF (l_tmp_draft_status IN (PO_DRAFTS_PVT.g_status_PDOI_PROCESSING,
418: PO_DRAFTS_PVT.g_status_PDOI_ERROR)) THEN
419:
420: d_position := 50;
421:
422: IF (PO_LOG.d_stmt) THEN

Line 448: PO_DRAFTS_PVT.remove_draft_changes

444: PO_LOG.stmt(d_module, d_position, 'old draft can be removed. ' ||
445: 'Creating a new one');
446: END IF;
447:
448: PO_DRAFTS_PVT.remove_draft_changes
449: ( p_draft_id => l_tmp_draft_id,
450: p_exclude_ctrl_tbl => FND_API.G_FALSE,
451: x_return_status => l_return_status
452: );

Line 457: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;

453:
454: -- new draft to be created
455: l_new_dft_idx_tbl.EXTEND;
456: l_new_dft_idx_tbl(l_new_dft_idx_tbl.COUNT) := i;
457: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
458: ELSE
459: d_position := 80;
460:
461: IF (PO_LOG.d_stmt) THEN

Line 502: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;

498:
499: -- actions that cause new documents to be created
500: l_new_dft_idx_tbl.extend;
501: l_new_dft_idx_tbl(l_new_dft_idx_tbl.COUNT) := i;
502: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
503: END IF;
504: END LOOP;
505:
506: d_position := 110;

Line 822: IF (p_status = PO_DRAFTS_PVT.g_status_PDOI_ERROR) THEN

818: END IF;
819:
820: x_new_draft_needed := FND_API.G_FALSE;
821:
822: IF (p_status = PO_DRAFTS_PVT.g_status_PDOI_ERROR) THEN
823: d_position := 10;
824:
825: x_new_draft_needed := FND_API.G_TRUE;
826:

Line 827: ELSIF (p_status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING) THEN

823: d_position := 10;
824:
825: x_new_draft_needed := FND_API.G_TRUE;
826:
827: ELSIF (p_status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING) THEN
828: d_position := 20;
829:
830: l_cur_request_id := FND_GLOBAL.conc_request_id;
831:

Line 832: PO_DRAFTS_PVT.get_request_id

828: d_position := 20;
829:
830: l_cur_request_id := FND_GLOBAL.conc_request_id;
831:
832: PO_DRAFTS_PVT.get_request_id
833: ( p_draft_id => p_draft_id,
834: x_request_id => l_dft_request_id
835: );
836:

Line 841: END IF; -- if status = p_status = PO_DRAFTS_PVT.g_status_PDOI_ERROR

837: x_new_draft_needed := PO_PDOI_UTL.is_old_request_complete
838: ( p_old_request_id => l_dft_request_id
839: );
840:
841: END IF; -- if status = p_status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
842:
843: IF (PO_LOG.d_proc) THEN
844: PO_LOG.proc_end (d_module, 'x_new_draft_needed', x_new_draft_needed);
845: END IF;