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.

[Home] [Help]

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 92: g_town_or_city HR_LOCATIONS.town_or_city%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
92: g_town_or_city HR_LOCATIONS.town_or_city%type :=NULL;
93: g_postal_code HR_LOCATIONS.postal_code%type :=NULL;
94: g_state_or_province varchar2(100) :=NULL;
95:
96: --Start of global variables to hold the legal entity details --

Line 93: g_postal_code HR_LOCATIONS.postal_code%type :=NULL;

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
92: g_town_or_city HR_LOCATIONS.town_or_city%type :=NULL;
93: g_postal_code HR_LOCATIONS.postal_code%type :=NULL;
94: g_state_or_province varchar2(100) :=NULL;
95:
96: --Start of global variables to hold the legal entity details --
97:

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

95:
96: --Start of global variables to hold the legal entity details --
97:
98: g_legal_entity_name HR_ORGANIZATION_UNITS_V.NAME%type := null;
99: g_legal_entity_address_line_1 HR_LOCATIONS.ADDRESS_LINE_1 %type := null;
100: g_legal_entity_address_line_2 HR_LOCATIONS.ADDRESS_LINE_2%type := null;
101: g_legal_entity_address_line_3 HR_LOCATIONS.ADDRESS_LINE_3%type := null;
102: g_legal_entity_town_or_city HR_LOCATIONS.TOWN_OR_CITY%type := null;
103: g_legal_entity_state HR_LOCATIONS.REGION_1%type := null;

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

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

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

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

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

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

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

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

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

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

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

5933: end;
5934: --bug#3438608
5935:
5936: /*Bug 4504228 START Retrieving the phone and email contact of buyer from
5937: per_all_people_f rather than the hr_locations.So commenting out
5938: the below function and adding two functions getPhone(p_agent_id)
5939: and getEmail()*/
5940:
5941: /*function getPhone return varchar2 is

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

6016:
6017: /* Bug#3580225: Changed the function to call po_hr_location.get_alladdress_lines PROCEDURE*/
6018: function getOperationInfo(p_org_id in NUMBER) return varchar2 is
6019: l_address_line4 varchar2(240) :=null;
6020: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6021: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
6022: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
6023: l_address_info varchar2(500) := null;
6024: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;

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

6017: /* Bug#3580225: Changed the function to call po_hr_location.get_alladdress_lines PROCEDURE*/
6018: function getOperationInfo(p_org_id in NUMBER) return varchar2 is
6019: l_address_line4 varchar2(240) :=null;
6020: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6021: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
6022: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
6023: l_address_info varchar2(500) := null;
6024: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;
6025:

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

6018: function getOperationInfo(p_org_id in NUMBER) return varchar2 is
6019: l_address_line4 varchar2(240) :=null;
6020: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6021: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
6022: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
6023: l_address_info varchar2(500) := null;
6024: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;
6025:
6026: begin

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

6020: l_ou_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6021: l_ou_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
6022: l_ou_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
6023: l_address_info varchar2(500) := null;
6024: l_location_id PO_HR_LOCATIONS.LOCATION_ID%type := null;
6025:
6026: begin
6027: if PO_COMMUNICATION_PVT.g_org_id <> p_org_id or
6028: PO_COMMUNICATION_PVT.g_org_id is null then

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

6635: /* function to retrieve legal entity details for given Inventory Organization */
6636:
6637: function getLegalEntityDetails(p_org_id in NUMBER) return varchar2 is
6638:
6639: l_location_id HR_LOCATIONS.location_id%type :=null;
6640: l_address_line4 varchar2(240) :=null;
6641: l_legal_entity_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6642: l_legal_entity_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
6643: l_legal_entity_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;

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

6637: function getLegalEntityDetails(p_org_id in NUMBER) return varchar2 is
6638:
6639: l_location_id HR_LOCATIONS.location_id%type :=null;
6640: l_address_line4 varchar2(240) :=null;
6641: l_legal_entity_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6642: l_legal_entity_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
6643: l_legal_entity_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
6644: l_address_info varchar2(500) := null;
6645:

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

6638:
6639: l_location_id HR_LOCATIONS.location_id%type :=null;
6640: l_address_line4 varchar2(240) :=null;
6641: l_legal_entity_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6642: l_legal_entity_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
6643: l_legal_entity_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
6644: l_address_info varchar2(500) := null;
6645:
6646: /*Bug5983107 */

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

6639: l_location_id HR_LOCATIONS.location_id%type :=null;
6640: l_address_line4 varchar2(240) :=null;
6641: l_legal_entity_location_code HR_LOCATIONS.LOCATION_CODE%type := null;
6642: l_legal_entity_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type := null;
6643: l_legal_entity_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type := null;
6644: l_address_info varchar2(500) := null;
6645:
6646: /*Bug5983107 */
6647: l_legal_entity_id NUMBER;

Line 7231: SELECT location_id into l_location_id FROM hr_locations

7227:
7228: l_one_time_location := FND_PROFILE.VALUE('POR_ONE_TIME_LOCATION');
7229:
7230: if l_one_time_location is not null then
7231: SELECT location_id into l_location_id FROM hr_locations
7232: where location_code=l_one_time_location;
7233: end if;
7234:
7235: if (l_location_id = p_location_id) then