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_HEADERS_ALL

Line 76: l_agreement_num PO_HEADERS_ALL.segment1%TYPE;

72: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
73: d_position NUMBER;
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;

Line 77: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

73: d_position NUMBER;
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;

Line 82: l_org_id PO_HEADERS_ALL.org_id%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);
86:

Line 83: l_agent_id PO_HEADERS_ALL.agent_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);
86:
87: BEGIN

Line 97: FROM po_headers_all

93:
94: -- Get the agreement number and revision number
95: SELECT NVL(revision_num, 0), segment1, org_id, agent_id
96: INTO l_revision_num, l_agreement_num, l_org_id, l_agent_id
97: FROM po_headers_all
98: WHERE po_header_id = p_po_header_id;
99:
100: d_position := 10;
101:

Line 253: l_cur_org_id PO_HEADERS_ALL.org_id%TYPE;

249: d_api_name CONSTANT VARCHAR2(30) := 'selector';
250: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
251: d_position NUMBER;
252:
253: l_cur_org_id PO_HEADERS_ALL.org_id%TYPE;
254: l_org_id PO_HEADERS_ALL.org_id%TYPE;
255: BEGIN
256: d_position := 0;
257: IF (PO_LOG.d_proc) THEN

Line 254: l_org_id PO_HEADERS_ALL.org_id%TYPE;

250: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
251: d_position NUMBER;
252:
253: l_cur_org_id PO_HEADERS_ALL.org_id%TYPE;
254: l_org_id PO_HEADERS_ALL.org_id%TYPE;
255: BEGIN
256: d_position := 0;
257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin (d_module, 'item_type', item_type);

Line 327: l_org_id PO_HEADERS_ALL.org_id%TYPE;

323: d_position NUMBER;
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

Line 534: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

530: d_api_name CONSTANT VARCHAR2(30) := 'start_buyer_acceptance_process';
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:

Line 642: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;

638: d_api_name CONSTANT VARCHAR2(30) := 'get_buyers_manager';
639: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
640: d_position NUMBER;
641:
642: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
643: l_manager_id NUMBER;
644: l_manager_user_name FND_USER.user_name%TYPE;
645: l_manager_name_dsp VARCHAR2(1000);
646: BEGIN

Line 746: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

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:
750: l_return_status VARCHAR2(1);

Line 747: l_created_language PO_HEADERS_ALL.created_language%TYPE;

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:
750: l_return_status VARCHAR2(1);
751:

Line 777: FROM po_headers_all

773: d_position := 10;
774:
775: SELECT created_language
776: INTO l_created_language
777: FROM po_headers_all
778: WHERE po_header_id = l_po_header_id;
779:
780: d_position := 20;
781:

Line 960: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

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);
964:

Line 1032: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

1028: d_position NUMBER;
1029:
1030: l_document_type VARCHAR2(10) := 'PA';
1031: l_document_subtype VARCHAR2(10) := 'BLANKET';
1032: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1033: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1034: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
1035:
1036: l_printflag VARCHAR2(1) := 'N';

Line 1033: l_org_id PO_HEADERS_ALL.org_id%TYPE;

1029:
1030: l_document_type VARCHAR2(10) := 'PA';
1031: l_document_subtype VARCHAR2(10) := 'BLANKET';
1032: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1033: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1034: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
1035:
1036: l_printflag VARCHAR2(1) := 'N';
1037: l_faxflag VARCHAR2(1) := 'N';

Line 1034: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;

1030: l_document_type VARCHAR2(10) := 'PA';
1031: l_document_subtype VARCHAR2(10) := 'BLANKET';
1032: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1033: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1034: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
1035:
1036: l_printflag VARCHAR2(1) := 'N';
1037: l_faxflag VARCHAR2(1) := 'N';
1038: l_faxnum VARCHAR2(30); --Bug 5765243

Line 1115: PO_HEADERS_ALL

1111: SELECT AUTO_SOURCING_FLAG,UPDATE_SOURCING_RULES_FLAG
1112: INTO
1113: l_create_sourcing_rule,l_update_sourcing_rule
1114: FROM
1115: PO_HEADERS_ALL
1116: WHERE
1117: PO_HEADER_ID=l_po_header_id;
1118:
1119: /* Bug 10026155 End */

Line 1552: FROM po_headers_all PH,

1548: l_category_id_tbl,
1549: l_new_price_tbl,
1550: l_old_price_tbl,
1551: l_new_line_flag_tbl
1552: FROM po_headers_all PH,
1553: po_lines_draft_all PLD,
1554: po_lines_all PL
1555: WHERE PLD.draft_id = p_draft_id
1556: AND NVL(PLD.delete_flag, 'N') = 'N'

Line 1669: l_created_language PO_HEADERS_ALL.created_language%TYPE;

1665: d_api_name CONSTANT VARCHAR2(30) := 'accept_translations';
1666: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1667: d_position NUMBER;
1668:
1669: l_created_language PO_HEADERS_ALL.created_language%TYPE;
1670:
1671: BEGIN
1672:
1673: d_position := 0;

Line 1682: po_headers_all PH

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:
1686: UPDATE po_attribute_values_tlp_draft PAVTD

Line 3520: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

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:
3524: d_position := 0;