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_LOCATIONS

Line 36: g_address_line1 HR_LOCATIONS.ADDRESS_LINE_1%type := null;

32: g_amendment_message VARCHAR2(2001);
33: g_test_flag VARCHAR2(1);
34: g_release_header_id PO_HEADERS_ALL.po_header_id%type;
35: g_location_id number;
36: g_address_line1 HR_LOCATIONS.ADDRESS_LINE_1%type := null;
37: g_address_line2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
38: g_address_line3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
39: g_Territory_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;
40: g_address_info varchar2(500) := null;

Line 37: g_address_line2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;

33: g_test_flag VARCHAR2(1);
34: g_release_header_id PO_HEADERS_ALL.po_header_id%type;
35: g_location_id number;
36: g_address_line1 HR_LOCATIONS.ADDRESS_LINE_1%type := null;
37: g_address_line2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
38: g_address_line3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
39: g_Territory_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;
40: g_address_info varchar2(500) := null;
41: g_org_id PO_HEADERS_ALL.ORG_ID%type := null;

Line 38: g_address_line3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;

34: g_release_header_id PO_HEADERS_ALL.po_header_id%type;
35: g_location_id number;
36: g_address_line1 HR_LOCATIONS.ADDRESS_LINE_1%type := null;
37: g_address_line2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
38: g_address_line3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
39: g_Territory_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;
40: g_address_info varchar2(500) := null;
41: g_org_id PO_HEADERS_ALL.ORG_ID%type := null;
42:

Line 74: g_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;

70: g_vendor_city_state_zipInfo varchar2(500) := null;
71: g_vendor_site_id PO_HEADERS_ALL.vendor_site_id%type := null;
72: g_job_id PO_LINES_ALL.JOB_ID%type := null;
73: g_job_name PER_JOBS_VL.name%type := null;
74: g_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
75: --Bug 4504228 START
76: g_person_id PER_ALL_PEOPLE_F.PERSON_ID%type := null;
77: g_buyer_email_address PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type := null;
78: g_buyer_phone PER_ALL_PEOPLE_F.office_number%type := null;

Line 80: g_buyer_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null; --Bug5671523 Adding g_buyer_fax

76: g_person_id PER_ALL_PEOPLE_F.PERSON_ID%type := null;
77: g_buyer_email_address PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type := null;
78: g_buyer_phone PER_ALL_PEOPLE_F.office_number%type := null;
79: --Bug 4504228 END
80: g_buyer_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null; --Bug5671523 Adding g_buyer_fax
81: g_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
82: g_location_name HR_LOCATIONS.LOCATION_CODE%type := null;
83: g_documentType PO_DOCUMENT_TYPES_TL.TYPE_NAME%type;
84: g_currency_code PO_HEADERS_ALL.CURRENCY_CODE%type := null;

Line 81: g_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;

77: g_buyer_email_address PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type := null;
78: g_buyer_phone PER_ALL_PEOPLE_F.office_number%type := null;
79: --Bug 4504228 END
80: g_buyer_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null; --Bug5671523 Adding g_buyer_fax
81: g_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
82: g_location_name HR_LOCATIONS.LOCATION_CODE%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;

Line 82: g_location_name HR_LOCATIONS.LOCATION_CODE%type := null;

78: g_buyer_phone PER_ALL_PEOPLE_F.office_number%type := null;
79: --Bug 4504228 END
80: g_buyer_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null; --Bug5671523 Adding g_buyer_fax
81: g_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
82: g_location_name HR_LOCATIONS.LOCATION_CODE%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;

Line 94: hr_locations.town_or_city or hr_locations.postal_code (30) to varchar2(100) */

90: --bug#3438608 added the three global variables g_town_or_city
91: --g_postal_code and g_state_or_province
92: /*Begin Edit Akyanama Bug # 11062630 */
93: /*Increased variable g_town_or_city , g_postal_code limit from
94: hr_locations.town_or_city or hr_locations.postal_code (30) to varchar2(100) */
95: g_town_or_city varchar2(100) := NULL;
96: g_postal_code varchar2(100) := NULL;
97: g_state_or_province varchar2(100) := NULL;
98: /*End Edit Akyanama Bug # 11062630 */

Line 102: g_legal_entity_address_line_1 HR_LOCATIONS.ADDRESS_LINE_1 %type := null;

98: /*End Edit Akyanama Bug # 11062630 */
99: --Start of global variables to hold the legal entity details --
100:
101: g_legal_entity_name HR_ORGANIZATION_UNITS_V.NAME%type := null;
102: g_legal_entity_address_line_1 HR_LOCATIONS.ADDRESS_LINE_1 %type := null;
103: g_legal_entity_address_line_2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
104: g_legal_entity_address_line_3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
105: g_legal_entity_town_or_city HR_LOCATIONS.TOWN_OR_CITY%type := null;
106: g_legal_entity_state HR_LOCATIONS.REGION_1%type := null;

Line 103: g_legal_entity_address_line_2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;

99: --Start of global variables to hold the legal entity details --
100:
101: g_legal_entity_name HR_ORGANIZATION_UNITS_V.NAME%type := null;
102: g_legal_entity_address_line_1 HR_LOCATIONS.ADDRESS_LINE_1 %type := null;
103: g_legal_entity_address_line_2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
104: g_legal_entity_address_line_3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
105: g_legal_entity_town_or_city HR_LOCATIONS.TOWN_OR_CITY%type := null;
106: g_legal_entity_state HR_LOCATIONS.REGION_1%type := null;
107: g_legal_entity_postal_code HR_LOCATIONS.POSTAL_CODE%type := null;

Line 104: g_legal_entity_address_line_3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;

100:
101: g_legal_entity_name HR_ORGANIZATION_UNITS_V.NAME%type := null;
102: g_legal_entity_address_line_1 HR_LOCATIONS.ADDRESS_LINE_1 %type := null;
103: g_legal_entity_address_line_2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
104: g_legal_entity_address_line_3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
105: g_legal_entity_town_or_city HR_LOCATIONS.TOWN_OR_CITY%type := null;
106: g_legal_entity_state HR_LOCATIONS.REGION_1%type := null;
107: g_legal_entity_postal_code HR_LOCATIONS.POSTAL_CODE%type := null;
108: g_legal_entity_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;

Line 105: g_legal_entity_town_or_city HR_LOCATIONS.TOWN_OR_CITY%type := null;

101: g_legal_entity_name HR_ORGANIZATION_UNITS_V.NAME%type := null;
102: g_legal_entity_address_line_1 HR_LOCATIONS.ADDRESS_LINE_1 %type := null;
103: g_legal_entity_address_line_2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
104: g_legal_entity_address_line_3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
105: g_legal_entity_town_or_city HR_LOCATIONS.TOWN_OR_CITY%type := null;
106: g_legal_entity_state HR_LOCATIONS.REGION_1%type := null;
107: g_legal_entity_postal_code HR_LOCATIONS.POSTAL_CODE%type := null;
108: g_legal_entity_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;
109: g_legal_entity_org_id PO_HEADERS_ALL.ORG_ID%type := null;

Line 106: g_legal_entity_state HR_LOCATIONS.REGION_1%type := null;

102: g_legal_entity_address_line_1 HR_LOCATIONS.ADDRESS_LINE_1 %type := null;
103: g_legal_entity_address_line_2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
104: g_legal_entity_address_line_3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
105: g_legal_entity_town_or_city HR_LOCATIONS.TOWN_OR_CITY%type := null;
106: g_legal_entity_state HR_LOCATIONS.REGION_1%type := null;
107: g_legal_entity_postal_code HR_LOCATIONS.POSTAL_CODE%type := null;
108: g_legal_entity_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;
109: g_legal_entity_org_id PO_HEADERS_ALL.ORG_ID%type := null;
110:

Line 107: g_legal_entity_postal_code HR_LOCATIONS.POSTAL_CODE%type := null;

103: g_legal_entity_address_line_2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
104: g_legal_entity_address_line_3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
105: g_legal_entity_town_or_city HR_LOCATIONS.TOWN_OR_CITY%type := null;
106: g_legal_entity_state HR_LOCATIONS.REGION_1%type := null;
107: g_legal_entity_postal_code HR_LOCATIONS.POSTAL_CODE%type := null;
108: g_legal_entity_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;
109: g_legal_entity_org_id PO_HEADERS_ALL.ORG_ID%type := null;
110:
111: -- End of Legal Entity details ----

Line 7028: per_all_people_f rather than the hr_locations.So commenting out

7024: end;
7025: --bug#3438608
7026:
7027: /*Bug 4504228 START Retrieving the phone and email contact of buyer from
7028: per_all_people_f rather than the hr_locations.So commenting out
7029: the below function and adding two functions getPhone(p_agent_id)
7030: and getEmail()*/
7031:
7032: /*function getPhone return varchar2 is

Line 7128: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;

7124:
7125: /* Bug#3580225: Changed the function to call po_hr_location.get_alladdress_lines PROCEDURE*/
7126: function getOperationInfo(p_org_id in NUMBER) return varchar2 is
7127: l_address_line4 varchar2(240) := null;
7128: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7129: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
7130: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
7131: l_address_info varchar2(500) := null;
7132: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;

Line 7129: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;

7125: /* Bug#3580225: Changed the function to call po_hr_location.get_alladdress_lines PROCEDURE*/
7126: function getOperationInfo(p_org_id in NUMBER) return varchar2 is
7127: l_address_line4 varchar2(240) := null;
7128: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7129: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
7130: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
7131: l_address_info varchar2(500) := null;
7132: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;
7133:

Line 7130: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;

7126: function getOperationInfo(p_org_id in NUMBER) return varchar2 is
7127: l_address_line4 varchar2(240) := null;
7128: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7129: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
7130: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
7131: l_address_info varchar2(500) := null;
7132: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;
7133:
7134: begin

Line 7132: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;

7128: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7129: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
7130: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
7131: l_address_info varchar2(500) := null;
7132: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;
7133:
7134: begin
7135: if PO_COMMUNICATION_PVT.g_org_id <> p_org_id or
7136: PO_COMMUNICATION_PVT.g_org_id is null then

Line 7831: l_location_id HR_LOCATIONS.location_id%type := null;

7827: /* function to retrieve legal entity details for given Inventory Organization */
7828:
7829: function getLegalEntityDetails(p_org_id in NUMBER) return varchar2 is
7830:
7831: l_location_id HR_LOCATIONS.location_id%type := null;
7832: l_address_line4 varchar2(240) := null;
7833: l_legal_entity_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7834: l_legal_entity_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
7835: l_legal_entity_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;

Line 7833: l_legal_entity_location_code HR_LOCATIONS.LOCATION_CODE%type := null;

7829: function getLegalEntityDetails(p_org_id in NUMBER) return varchar2 is
7830:
7831: l_location_id HR_LOCATIONS.location_id%type := null;
7832: l_address_line4 varchar2(240) := null;
7833: l_legal_entity_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7834: l_legal_entity_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
7835: l_legal_entity_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
7836: l_address_info varchar2(500) := null;
7837:

Line 7834: l_legal_entity_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;

7830:
7831: l_location_id HR_LOCATIONS.location_id%type := null;
7832: l_address_line4 varchar2(240) := null;
7833: l_legal_entity_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7834: l_legal_entity_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
7835: l_legal_entity_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
7836: l_address_info varchar2(500) := null;
7837:
7838: /*Bug5983107 */

Line 7835: l_legal_entity_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;

7831: l_location_id HR_LOCATIONS.location_id%type := null;
7832: l_address_line4 varchar2(240) := null;
7833: l_legal_entity_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
7834: l_legal_entity_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
7835: l_legal_entity_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
7836: l_address_info varchar2(500) := null;
7837:
7838: /*Bug5983107 */
7839: l_legal_entity_id NUMBER;

Line 8426: SELECT location_id into l_location_id FROM hr_locations

8422:
8423: l_one_time_location := FND_PROFILE.VALUE('POR_ONE_TIME_LOCATION');
8424:
8425: if l_one_time_location is not null then
8426: SELECT location_id into l_location_id FROM hr_locations
8427: where location_code = l_one_time_location;
8428: end if;
8429:
8430: if (l_location_id = p_location_id) then