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_COMMUNICATION_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 87: g_buyer_org HR_ALL_ORGANIZATION_UNITS.NAME%type := NULL;

83: g_documentType PO_DOCUMENT_TYPES_TL.TYPE_NAME%type;
84: g_currency_code PO_HEADERS_ALL.CURRENCY_CODE%type :=null;
85: g_current_currency_code PO_HEADERS_ALL.CURRENCY_CODE%type :=null;
86: g_format_mask varchar2(100) :=null;
87: g_buyer_org HR_ALL_ORGANIZATION_UNITS.NAME%type := NULL;
88: g_address_line4 HZ_LOCATIONS.ADDRESS4%TYPE := NULL; -- bug: 3463617
89: g_vendor_address_line_4 HZ_LOCATIONS.ADDRESS4%TYPE := NULL; -- bug: 3463617
90: --bug#3438608 added the three global variables g_town_or_city
91: --g_postal_code and g_state_or_province

Line 622: --l_legal_name hr_all_organization_units.name%TYPE;

618: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
619: l_performer_exists number;
620: l_notification_preference varchar2(20) := 'MAILHTML';
621: l_orgid number;
622: --l_legal_name hr_all_organization_units.name%TYPE;
623: --bug##3682458 replaced legal entity name with operating unit
624: l_operating_unit hr_all_organization_units.name%TYPE;
625:
626: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

Line 624: l_operating_unit hr_all_organization_units.name%TYPE;

620: l_notification_preference varchar2(20) := 'MAILHTML';
621: l_orgid number;
622: --l_legal_name hr_all_organization_units.name%TYPE;
623: --bug##3682458 replaced legal entity name with operating unit
624: l_operating_unit hr_all_organization_units.name%TYPE;
625:
626: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
627: l_docNumber PO_HEADERS_ALL.SEGMENT1%TYPE;
628: l_doc_num_rel varchar2(30);

Line 4223: /Bug5983107 Commenting out the below sql and writing the new sql below without reference to hr_all_organization_units/

4219:
4220: IF(p_document_type in ('PO','PA')) THEN
4221: IF p_which_tables = 'MAIN' THEN
4222:
4223: /*Bug5983107 Commenting out the below sql and writing the new sql below without reference to hr_all_organization_units*/
4224: /* SELECT hle.name, vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4225: INTO po_communication_pvt.g_buyer_org, l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4226: FROM hr_all_organization_units hle, po_vendors vn, po_headers_all ph
4227: WHERE to_char(hle.organization_id) = (select org_information2 from hr_organization_information where

Line 4226: FROM hr_all_organization_units hle, po_vendors vn, po_headers_all ph

4222:
4223: /*Bug5983107 Commenting out the below sql and writing the new sql below without reference to hr_all_organization_units*/
4224: /* SELECT hle.name, vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4225: INTO po_communication_pvt.g_buyer_org, l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4226: FROM hr_all_organization_units hle, po_vendors vn, po_headers_all ph
4227: WHERE to_char(hle.organization_id) = (select org_information2 from hr_organization_information where
4228: org_information_context = 'Operating Unit Information' and organization_id = ph.org_id) AND vn.vendor_id = ph.vendor_id
4229: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num; */
4230:

Line 4246: /Bug5983107 Modifying the below sql by removing reference to hr_all_organization_units/

4242:
4243:
4244: ELSIF p_which_tables = 'ARCHIVE' THEN
4245:
4246: /*Bug5983107 Modifying the below sql by removing reference to hr_all_organization_units*/
4247:
4248: SELECT vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4249: INTO l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4250: FROM po_vendors vn, po_headers_archive_all ph

Line 6041: /select name and location id from hr_all_organization_units/

6037: PO_COMMUNICATION_PVT.g_ou_region2 := null;
6038: PO_COMMUNICATION_PVT.g_ou_postal_code := null;
6039: PO_COMMUNICATION_PVT.g_ou_country := null;
6040:
6041: /*select name and location id from hr_all_organization_units*/
6042:
6043: SELECT name, location_id into PO_COMMUNICATION_PVT.g_ou_name, l_location_id
6044: FROM hr_all_organization_units
6045: WHERE organization_id = p_org_id;

Line 6044: FROM hr_all_organization_units

6040:
6041: /*select name and location id from hr_all_organization_units*/
6042:
6043: SELECT name, location_id into PO_COMMUNICATION_PVT.g_ou_name, l_location_id
6044: FROM hr_all_organization_units
6045: WHERE organization_id = p_org_id;
6046:
6047: /* Call get_alladdress_lines procedure to retrieve address details*/
6048:

Line 6674: FROM hr_all_organization_units

6670: /*Bug5983107 Commenting out the sql below and replacing the API's provided by XLE*/
6671:
6672: /* SELECT name, LOCATION_ID
6673: INTO PO_COMMUNICATION_PVT.g_legal_entity_name, l_location_id
6674: FROM hr_all_organization_units
6675: WHERE to_char(organization_id) = ( SELECT org_information2 FROM hr_organization_information WHERE org_information_context = 'Accounting Information'
6676: and organization_id = p_org_id ) ; */
6677:
6678: l_legal_entity_id := PO_CORE_S.get_default_legal_entity_id(p_org_id);

Line 6908: , hr_all_organization_units hou

6904: , hou.name
6905: INTO x_pendingSignatureFlag
6906: , PO_COMMUNICATION_PVT.g_ou_name
6907: FROM po_headers_all poh
6908: , hr_all_organization_units hou
6909: WHERE poh.po_header_id = p_documentID
6910: AND hou.organization_id = poh.org_id;
6911:
6912: x_organizationName := PO_COMMUNICATION_PVT.g_ou_name; -- operating unit name