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 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 532: INSERT INTO po_drafts

528: IF (l_new_dft_idx_tbl.COUNT > 0) THEN
529: d_position := 140;
530: -- Create new drafts
531: FORALL i IN VALUES OF l_new_dft_idx_tbl
532: INSERT INTO po_drafts
533: ( draft_id,
534: document_id,
535: revision_num,
536: owner_user_id,

Line 588: UPDATE po_drafts

584: d_position := 160;
585: -- If we are updating an existing draft, we need to temporarily set the
586: -- status to PDOI_PROCESSING
587: FORALL i IN VALUES OF l_existing_dft_idx_tbl
588: UPDATE po_drafts
589: SET status = l_status,
590: request_id = FND_GLOBAL.conc_request_id,
591: last_update_date = SYSDATE,
592: last_updated_by = FND_GLOBAL.user_id

Line 808: l_dft_request_id PO_DRAFTS.request_id%TYPE;

804: d_api_name CONSTANT VARCHAR2(30) := 'check_new_draft_needed';
805: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
806: d_position NUMBER;
807:
808: l_dft_request_id PO_DRAFTS.request_id%TYPE;
809: l_cur_request_id NUMBER;
810:
811:
812: BEGIN

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;