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 725: --l_legal_name hr_all_organization_units.name%TYPE;

721: l_performer_exists number;
722: l_notification_preference varchar2(20) := 'MAILHTM2';
723: --Bug13871793
724: l_orgid number;
725: --l_legal_name hr_all_organization_units.name%TYPE;
726: --bug##3682458 replaced legal entity name with operating unit
727: l_operating_unit hr_all_organization_units.name%TYPE;
728:
729: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

Line 727: l_operating_unit hr_all_organization_units.name%TYPE;

723: --Bug13871793
724: l_orgid number;
725: --l_legal_name hr_all_organization_units.name%TYPE;
726: --bug##3682458 replaced legal entity name with operating unit
727: l_operating_unit hr_all_organization_units.name%TYPE;
728:
729: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
730: l_docNumber PO_HEADERS_ALL.SEGMENT1%TYPE;
731: l_doc_num_rel varchar2(30);

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

4977:
4978: IF(p_document_type in ('PO', 'PA')) THEN
4979: IF p_which_tables = 'MAIN' THEN
4980:
4981: /*Bug5983107 Commenting out the below sql and writing the new sql below without reference to hr_all_organization_units*/
4982: /* SELECT hle.name, vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4983: INTO po_communication_pvt.g_buyer_org, l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4984: FROM hr_all_organization_units hle, po_vendors vn, po_headers_all ph
4985: WHERE to_char(hle.organization_id) = (select org_information2 from hr_organization_information where

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

4980:
4981: /*Bug5983107 Commenting out the below sql and writing the new sql below without reference to hr_all_organization_units*/
4982: /* SELECT hle.name, vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4983: INTO po_communication_pvt.g_buyer_org, l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4984: FROM hr_all_organization_units hle, po_vendors vn, po_headers_all ph
4985: WHERE to_char(hle.organization_id) = (select org_information2 from hr_organization_information where
4986: org_information_context = 'Operating Unit Information' and organization_id = ph.org_id) AND vn.vendor_id = ph.vendor_id
4987: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num; */
4988:

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

5000:
5001:
5002: ELSIF p_which_tables = 'ARCHIVE' THEN
5003:
5004: /*Bug5983107 Modifying the below sql by removing reference to hr_all_organization_units*/
5005:
5006: SELECT vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
5007: INTO l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
5008: FROM po_vendors vn, po_headers_archive_all ph

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

7145: PO_COMMUNICATION_PVT.g_ou_region2 := null;
7146: PO_COMMUNICATION_PVT.g_ou_postal_code := null;
7147: PO_COMMUNICATION_PVT.g_ou_country := null;
7148:
7149: /*select name and location id from hr_all_organization_units*/
7150:
7151: SELECT name, location_id into PO_COMMUNICATION_PVT.g_ou_name, l_location_id
7152: FROM hr_all_organization_units
7153: WHERE organization_id = p_org_id;

Line 7152: FROM hr_all_organization_units

7148:
7149: /*select name and location id from hr_all_organization_units*/
7150:
7151: SELECT name, location_id into PO_COMMUNICATION_PVT.g_ou_name, l_location_id
7152: FROM hr_all_organization_units
7153: WHERE organization_id = p_org_id;
7154:
7155: /* Call get_alladdress_lines procedure to retrieve address details*/
7156:

Line 7866: FROM hr_all_organization_units

7862: /*Bug5983107 Commenting out the sql below and replacing the API's provided by XLE*/
7863:
7864: /* SELECT name, LOCATION_ID
7865: INTO PO_COMMUNICATION_PVT.g_legal_entity_name, l_location_id
7866: FROM hr_all_organization_units
7867: WHERE to_char(organization_id) = ( SELECT org_information2 FROM hr_organization_information WHERE org_information_context = 'Accounting Information'
7868: and organization_id = p_org_id ) ; */
7869:
7870: l_legal_entity_id := PO_CORE_S.get_default_legal_entity_id(p_org_id);

Line 8102: , hr_all_organization_units hou

8098: INTO x_pendingSignatureFlag
8099: , PO_COMMUNICATION_PVT.g_ou_name
8100: -- FROM po_headers_all poh
8101: FROM po_headers_merge_v poh
8102: , hr_all_organization_units hou
8103: WHERE poh.po_header_id = p_documentID
8104: AND poh.draft_id = p_draftId --CLM
8105: AND hou.organization_id = poh.org_id;
8106: