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

Line 78: l_draft_id PO_DRAFTS.draft_id%TYPE;

74:
75: l_ItemKey VARCHAR2(240);
76: l_agreement_num PO_HEADERS_ALL.segment1%TYPE;
77: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
78: l_draft_id PO_DRAFTS.draft_id%TYPE;
79: l_draft_status PO_DRAFTS.status%TYPE;
80: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
81: l_draft_owner_user_id PO_DRAFTS.owner_user_id%TYPE;
82: l_org_id PO_HEADERS_ALL.org_id%TYPE;

Line 79: l_draft_status PO_DRAFTS.status%TYPE;

75: l_ItemKey VARCHAR2(240);
76: l_agreement_num PO_HEADERS_ALL.segment1%TYPE;
77: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
78: l_draft_id PO_DRAFTS.draft_id%TYPE;
79: l_draft_status PO_DRAFTS.status%TYPE;
80: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
81: l_draft_owner_user_id PO_DRAFTS.owner_user_id%TYPE;
82: l_org_id PO_HEADERS_ALL.org_id%TYPE;
83: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;

Line 80: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;

76: l_agreement_num PO_HEADERS_ALL.segment1%TYPE;
77: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
78: l_draft_id PO_DRAFTS.draft_id%TYPE;
79: l_draft_status PO_DRAFTS.status%TYPE;
80: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
81: l_draft_owner_user_id PO_DRAFTS.owner_user_id%TYPE;
82: l_org_id PO_HEADERS_ALL.org_id%TYPE;
83: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
84: l_buyer_user_name FND_USER.user_name%TYPE;

Line 81: l_draft_owner_user_id PO_DRAFTS.owner_user_id%TYPE;

77: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
78: l_draft_id PO_DRAFTS.draft_id%TYPE;
79: l_draft_status PO_DRAFTS.status%TYPE;
80: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
81: l_draft_owner_user_id PO_DRAFTS.owner_user_id%TYPE;
82: l_org_id PO_HEADERS_ALL.org_id%TYPE;
83: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
84: l_buyer_user_name FND_USER.user_name%TYPE;
85: l_buyer_name_dsp VARCHAR2(1000);

Line 102: PO_DRAFTS_PVT.find_draft

98: WHERE po_header_id = p_po_header_id;
99:
100: d_position := 10;
101:
102: PO_DRAFTS_PVT.find_draft
103: ( p_po_header_id => p_po_header_id,
104: x_draft_id => l_draft_id,
105: x_draft_status => l_draft_status,
106: x_draft_owner_role => l_draft_owner_role

Line 116: FROM po_drafts DFT

112: END IF;
113:
114: SELECT owner_user_id
115: INTO l_draft_owner_user_id
116: FROM po_drafts DFT
117: WHERE draft_id = l_draft_id;
118:
119: d_position := 20;
120:

Line 328: l_draft_id PO_DRAFTS.draft_id%TYPE;

324:
325: l_contains_changes VARCHAR2(1);
326: l_acceptance_required VARCHAR2(1);
327: l_org_id PO_HEADERS_ALL.org_id%TYPE;
328: l_draft_id PO_DRAFTS.draft_id%TYPE;
329: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
330: l_acceptance_level PO_SYSTEM_PARAMETERS_ALL.cat_admin_authoring_acceptance%TYPE;
331: BEGIN
332: d_position := 0;

Line 329: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;

325: l_contains_changes VARCHAR2(1);
326: l_acceptance_required VARCHAR2(1);
327: l_org_id PO_HEADERS_ALL.org_id%TYPE;
328: l_draft_id PO_DRAFTS.draft_id%TYPE;
329: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
330: l_acceptance_level PO_SYSTEM_PARAMETERS_ALL.cat_admin_authoring_acceptance%TYPE;
331: BEGIN
332: d_position := 0;
333:

Line 535: l_draft_id PO_DRAFTS.draft_id%TYPE;

531: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
532: d_position NUMBER;
533:
534: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
535: l_draft_id PO_DRAFTS.draft_id%TYPE;
536: l_emp_id FND_USER.employee_id%TYPE;
537: l_buyer_user_name FND_USER.user_name%TYPE;
538:
539: l_lock_owner_role PO_DRAFTS.owner_role%TYPE;

Line 539: l_lock_owner_role PO_DRAFTS.owner_role%TYPE;

535: l_draft_id PO_DRAFTS.draft_id%TYPE;
536: l_emp_id FND_USER.employee_id%TYPE;
537: l_buyer_user_name FND_USER.user_name%TYPE;
538:
539: l_lock_owner_role PO_DRAFTS.owner_role%TYPE;
540: l_lock_owner_user_id PO_DRAFTS.owner_user_id%TYPE;
541:
542: l_lock_owner_wf_role WF_USERS.name%TYPE;
543: l_lock_owner_wf_role_dsp WF_USERS.display_name%TYPE;

Line 540: l_lock_owner_user_id PO_DRAFTS.owner_user_id%TYPE;

536: l_emp_id FND_USER.employee_id%TYPE;
537: l_buyer_user_name FND_USER.user_name%TYPE;
538:
539: l_lock_owner_role PO_DRAFTS.owner_role%TYPE;
540: l_lock_owner_user_id PO_DRAFTS.owner_user_id%TYPE;
541:
542: l_lock_owner_wf_role WF_USERS.name%TYPE;
543: l_lock_owner_wf_role_dsp WF_USERS.display_name%TYPE;
544:

Line 566: PO_DRAFTS_PVT.update_draft_status

562: );
563:
564: d_position := 10;
565:
566: PO_DRAFTS_PVT.update_draft_status
567: ( p_draft_id => l_draft_id,
568: p_new_status => PO_DRAFTS_PVT.g_status_IN_PROCESS
569: );
570:

Line 568: p_new_status => PO_DRAFTS_PVT.g_status_IN_PROCESS

564: d_position := 10;
565:
566: PO_DRAFTS_PVT.update_draft_status
567: ( p_draft_id => l_draft_id,
568: p_new_status => PO_DRAFTS_PVT.g_status_IN_PROCESS
569: );
570:
571: l_buyer_user_name := PO_WF_UTIL_PKG.GetItemAttrText
572: ( itemtype => itemtype,

Line 591: PO_DRAFTS_PVT.get_lock_owner_info

587:
588: -- bug5249393
589: -- Get the document lock owner as it is the last owner that touched the
590: -- document
591: PO_DRAFTS_PVT.get_lock_owner_info
592: ( p_po_header_id => l_po_header_id,
593: x_lock_owner_role => l_lock_owner_role,
594: x_lock_owner_user_id => l_lock_owner_user_id
595: );

Line 719: avalue => PO_DRAFTS_PVT.g_ACCEPT_ALL

715: PO_WF_UTIL_PKG.SetItemAttrText
716: ( itemtype => itemType,
717: itemkey => itemKey,
718: aname => 'ACCEPTANCE_RESULT',
719: avalue => PO_DRAFTS_PVT.g_ACCEPT_ALL
720: );
721:
722: IF (PO_LOG.d_proc) THEN
723: PO_LOG.proc_end (d_module);

Line 745: l_draft_id PO_DRAFTS.draft_id%TYPE;

741: d_api_name CONSTANT VARCHAR2(30) := 'buyer_reject_changes';
742: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
743: d_position NUMBER;
744:
745: l_draft_id PO_DRAFTS.draft_id%TYPE;
746: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
747: l_created_language PO_HEADERS_ALL.created_language%TYPE;
748: l_reject_list PO_TBL_NUMBER;
749:

Line 877: l_draft_id PO_DRAFTS.draft_id%TYPE;

873: d_api_name CONSTANT VARCHAR2(30) := 'any_lines_get_rejected';
874: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
875: d_position NUMBER;
876:
877: l_draft_id PO_DRAFTS.draft_id%TYPE;
878: l_any_lines_get_rejected VARCHAR2(10);
879: BEGIN
880: d_position := 0;
881:

Line 959: l_draft_id PO_DRAFTS.draft_id%TYPE;

955: d_api_name CONSTANT VARCHAR2(30) := 'transfer_draft_to_txn';
956: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
957: d_position NUMBER;
958:
959: l_draft_id PO_DRAFTS.draft_id%TYPE;
960: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
961: l_acceptance_action VARCHAR2(20);
962: l_need_notif VARCHAR2(1);
963: l_return_status VARCHAR2(1);

Line 992: PO_DRAFTS_PVT.transfer_draft_to_txn

988: );
989:
990: d_position := 10;
991:
992: PO_DRAFTS_PVT.transfer_draft_to_txn
993: ( p_api_version => 1.0,
994: p_init_msg_list => FND_API.G_TRUE,
995: p_draft_id => l_draft_id,
996: p_po_header_id => l_po_header_id,

Line 1422: IF (p_action = PO_DRAFTS_PVT.g_ACCEPT_ALL) THEN

1418: -- the draft changes
1419:
1420: l_activity := 'BUYER_NOTIFICATIONS:WAIT_FOR_RESP_TO_CHG';
1421:
1422: IF (p_action = PO_DRAFTS_PVT.g_ACCEPT_ALL) THEN
1423: l_activity_result := 'ACCEPT';
1424: ELSIF (p_action = PO_DRAFTS_PVT.g_REJECT_ALL) THEN
1425: l_activity_result := 'REJECT';
1426: ELSIF (p_action = PO_DRAFTS_PVT.g_LINE_DISP) THEN

Line 1424: ELSIF (p_action = PO_DRAFTS_PVT.g_REJECT_ALL) THEN

1420: l_activity := 'BUYER_NOTIFICATIONS:WAIT_FOR_RESP_TO_CHG';
1421:
1422: IF (p_action = PO_DRAFTS_PVT.g_ACCEPT_ALL) THEN
1423: l_activity_result := 'ACCEPT';
1424: ELSIF (p_action = PO_DRAFTS_PVT.g_REJECT_ALL) THEN
1425: l_activity_result := 'REJECT';
1426: ELSIF (p_action = PO_DRAFTS_PVT.g_LINE_DISP) THEN
1427: l_activity_result := 'SUBMIT_LINE_DISP';
1428: END IF;

Line 1426: ELSIF (p_action = PO_DRAFTS_PVT.g_LINE_DISP) THEN

1422: IF (p_action = PO_DRAFTS_PVT.g_ACCEPT_ALL) THEN
1423: l_activity_result := 'ACCEPT';
1424: ELSIF (p_action = PO_DRAFTS_PVT.g_REJECT_ALL) THEN
1425: l_activity_result := 'REJECT';
1426: ELSIF (p_action = PO_DRAFTS_PVT.g_LINE_DISP) THEN
1427: l_activity_result := 'SUBMIT_LINE_DISP';
1428: END IF;
1429:
1430: d_position := 20;

Line 1681: FROM po_drafts DFT,

1677: END IF;
1678:
1679: SELECT PH.created_language
1680: INTO l_created_language
1681: FROM po_drafts DFT,
1682: po_headers_all PH
1683: WHERE DFT.draft_id = p_draft_id
1684: AND PH.po_header_id = DFT.document_id;
1685:

Line 3519: l_draft_id po_drafts.draft_id%TYPE;

3515: d_api_name);
3516: d_position NUMBER;
3517: l_launch_approval VARCHAR2(10);
3518: l_any_line_accepted VARCHAR2(1);
3519: l_draft_id po_drafts.draft_id%TYPE;
3520: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
3521:
3522: BEGIN
3523:

Line 3586: PO_DRAFTS_PVT.unlock_document(l_po_header_id);

3582:
3583: IF( l_any_line_accepted = 'Y' AND l_launch_approval = 'Y' ) THEN
3584: resultout := wf_engine.eng_completed || ':Y';
3585: ELSE
3586: PO_DRAFTS_PVT.unlock_document(l_po_header_id);
3587: resultout := wf_engine.eng_completed || ':N';
3588: END IF;
3589:
3590: IF ( po_log.d_proc ) THEN