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

Line 336: l_tmp_draft_id PO_DRAFTS.draft_id%TYPE;

332: l_po_header_id_tbl PO_TBL_NUMBER;
333: l_action_tbl PO_TBL_VARCHAR30;
334: l_revision_num_tbl PO_TBL_NUMBER;
335:
336: l_tmp_draft_id PO_DRAFTS.draft_id%TYPE;
337: l_tmp_draft_status PO_DRAFTS.status%TYPE;
338: l_tmp_draft_owner_role PO_DRAFTS.owner_role%TYPE;
339: l_new_draft_needed VARCHAR2(1);
340: l_return_status VARCHAR2(1);

Line 337: l_tmp_draft_status PO_DRAFTS.status%TYPE;

333: l_action_tbl PO_TBL_VARCHAR30;
334: l_revision_num_tbl PO_TBL_NUMBER;
335:
336: l_tmp_draft_id PO_DRAFTS.draft_id%TYPE;
337: l_tmp_draft_status PO_DRAFTS.status%TYPE;
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:

Line 338: l_tmp_draft_owner_role PO_DRAFTS.owner_role%TYPE;

334: l_revision_num_tbl PO_TBL_NUMBER;
335:
336: l_tmp_draft_id PO_DRAFTS.draft_id%TYPE;
337: l_tmp_draft_status PO_DRAFTS.status%TYPE;
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;

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 414: PO_DRAFTS_PVT.find_draft

410: -- If we are updating a document, a draft for the document may or may
411: -- not exist. if the draft exists, reuse it; if not, create a new
412: -- draft
413:
414: PO_DRAFTS_PVT.find_draft
415: ( p_po_header_id => l_po_header_id_tbl(i),
416: x_draft_id => l_tmp_draft_id,
417: x_draft_status => l_tmp_draft_status,
418: x_draft_owner_role => l_tmp_draft_owner_role

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

429:
430: -- need to create a new draft
431: l_new_dft_idx_tbl.extend;
432: l_new_dft_idx_tbl(l_new_dft_idx_tbl.COUNT) := i;
433: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
434:
435: ELSE
436: IF (l_tmp_draft_status IN (PO_DRAFTS_PVT.g_status_PDOI_PROCESSING,
437: PO_DRAFTS_PVT.g_status_PDOI_ERROR)) THEN

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

432: l_new_dft_idx_tbl(l_new_dft_idx_tbl.COUNT) := i;
433: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
434:
435: ELSE
436: IF (l_tmp_draft_status IN (PO_DRAFTS_PVT.g_status_PDOI_PROCESSING,
437: PO_DRAFTS_PVT.g_status_PDOI_ERROR)) THEN
438:
439: d_position := 50;
440:

Line 437: PO_DRAFTS_PVT.g_status_PDOI_ERROR)) THEN

433: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
434:
435: ELSE
436: IF (l_tmp_draft_status IN (PO_DRAFTS_PVT.g_status_PDOI_PROCESSING,
437: PO_DRAFTS_PVT.g_status_PDOI_ERROR)) THEN
438:
439: d_position := 50;
440:
441: IF (PO_LOG.d_stmt) THEN

Line 467: PO_DRAFTS_PVT.remove_draft_changes

463: PO_LOG.stmt(d_module, d_position, 'old draft can be removed. ' ||
464: 'Creating a new one');
465: END IF;
466:
467: PO_DRAFTS_PVT.remove_draft_changes
468: ( p_draft_id => l_tmp_draft_id,
469: p_exclude_ctrl_tbl => FND_API.G_FALSE,
470: x_return_status => l_return_status
471: );

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

472:
473: -- new draft to be created
474: l_new_dft_idx_tbl.EXTEND;
475: l_new_dft_idx_tbl(l_new_dft_idx_tbl.COUNT) := i;
476: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
477: ELSE
478: d_position := 80;
479:
480: IF (PO_LOG.d_stmt) THEN

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

517:
518: -- actions that cause new documents to be created
519: l_new_dft_idx_tbl.extend;
520: l_new_dft_idx_tbl(l_new_dft_idx_tbl.COUNT) := i;
521: l_draft_id_tbl(i) := PO_DRAFTS_PVT.draft_id_nextval;
522: END IF;
523: END LOOP;
524:
525: d_position := 110;

Line 551: INSERT INTO po_drafts

547: IF (l_new_dft_idx_tbl.COUNT > 0) THEN
548: d_position := 140;
549: -- Create new drafts
550: FORALL i IN VALUES OF l_new_dft_idx_tbl
551: INSERT INTO po_drafts
552: ( draft_id,
553: document_id,
554: revision_num,
555: owner_user_id,

Line 607: UPDATE po_drafts

603: d_position := 160;
604: -- If we are updating an existing draft, we need to temporarily set the
605: -- status to PDOI_PROCESSING
606: FORALL i IN VALUES OF l_existing_dft_idx_tbl
607: UPDATE po_drafts
608: SET status = l_status,
609: request_id = FND_GLOBAL.conc_request_id,
610: last_update_date = SYSDATE,
611: last_updated_by = FND_GLOBAL.user_id

Line 827: l_dft_request_id PO_DRAFTS.request_id%TYPE;

823: d_api_name CONSTANT VARCHAR2(30) := 'check_new_draft_needed';
824: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
825: d_position NUMBER;
826:
827: l_dft_request_id PO_DRAFTS.request_id%TYPE;
828: l_cur_request_id NUMBER;
829:
830:
831: BEGIN

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

837: END IF;
838:
839: x_new_draft_needed := FND_API.G_FALSE;
840:
841: IF (p_status = PO_DRAFTS_PVT.g_status_PDOI_ERROR) THEN
842: d_position := 10;
843:
844: x_new_draft_needed := FND_API.G_TRUE;
845:

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

842: d_position := 10;
843:
844: x_new_draft_needed := FND_API.G_TRUE;
845:
846: ELSIF (p_status = PO_DRAFTS_PVT.g_status_PDOI_PROCESSING) THEN
847: d_position := 20;
848:
849: l_cur_request_id := FND_GLOBAL.conc_request_id;
850:

Line 851: PO_DRAFTS_PVT.get_request_id

847: d_position := 20;
848:
849: l_cur_request_id := FND_GLOBAL.conc_request_id;
850:
851: PO_DRAFTS_PVT.get_request_id
852: ( p_draft_id => p_draft_id,
853: x_request_id => l_dft_request_id
854: );
855:

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

856: x_new_draft_needed := PO_PDOI_UTL.is_old_request_complete
857: ( p_old_request_id => l_dft_request_id
858: );
859:
860: END IF; -- if status = p_status = PO_DRAFTS_PVT.g_status_PDOI_ERROR
861:
862: IF (PO_LOG.d_proc) THEN
863: PO_LOG.proc_end (d_module, 'x_new_draft_needed', x_new_draft_needed);
864: END IF;