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 1402: IF (p_action = PO_DRAFTS_PVT.g_ACCEPT_ALL) THEN

1398: -- the draft changes
1399:
1400: l_activity := 'BUYER_NOTIFICATIONS:WAIT_FOR_RESP_TO_CHG';
1401:
1402: IF (p_action = PO_DRAFTS_PVT.g_ACCEPT_ALL) THEN
1403: l_activity_result := 'ACCEPT';
1404: ELSIF (p_action = PO_DRAFTS_PVT.g_REJECT_ALL) THEN
1405: l_activity_result := 'REJECT';
1406: ELSIF (p_action = PO_DRAFTS_PVT.g_LINE_DISP) THEN

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

1400: l_activity := 'BUYER_NOTIFICATIONS:WAIT_FOR_RESP_TO_CHG';
1401:
1402: IF (p_action = PO_DRAFTS_PVT.g_ACCEPT_ALL) THEN
1403: l_activity_result := 'ACCEPT';
1404: ELSIF (p_action = PO_DRAFTS_PVT.g_REJECT_ALL) THEN
1405: l_activity_result := 'REJECT';
1406: ELSIF (p_action = PO_DRAFTS_PVT.g_LINE_DISP) THEN
1407: l_activity_result := 'SUBMIT_LINE_DISP';
1408: END IF;

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

1402: IF (p_action = PO_DRAFTS_PVT.g_ACCEPT_ALL) THEN
1403: l_activity_result := 'ACCEPT';
1404: ELSIF (p_action = PO_DRAFTS_PVT.g_REJECT_ALL) THEN
1405: l_activity_result := 'REJECT';
1406: ELSIF (p_action = PO_DRAFTS_PVT.g_LINE_DISP) THEN
1407: l_activity_result := 'SUBMIT_LINE_DISP';
1408: END IF;
1409:
1410: d_position := 20;

Line 1655: FROM po_drafts DFT,

1651: END IF;
1652:
1653: SELECT PH.created_language
1654: INTO l_created_language
1655: FROM po_drafts DFT,
1656: po_headers_all PH
1657: WHERE DFT.draft_id = p_draft_id
1658: AND PH.po_header_id = DFT.document_id;
1659: