APPS.PO_COMMUNICATION_PVT dependencies on FND_TERRITORIES_TL

Line 39: g_Territory_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;

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:
43: -- Global variables to hold the Operating Unit details --

Line 69: g_vendor_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type := null;

65: g_release_id PO_RELEASES_ALL.PO_RELEASE_ID%type := null;
66: g_timezone VARCHAR2(255) := NULL;
67: g_vendor_address_line_2 PO_VENDOR_SITES.ADDRESS_LINE2%type := null;
68: g_vendor_address_line_3 PO_VENDOR_SITES.ADDRESS_LINE3%type := null;
69: g_vendor_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%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;

Line 108: g_legal_entity_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%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 ----
112:

Line 7388: FND_TERRITORIES_TL FTE

7384: l_address_line_1, PO_COMMUNICATION_PVT.g_vendor_address_line_2, PO_COMMUNICATION_PVT.g_vendor_address_line_3,
7385: l_city, l_state, l_zip, PO_COMMUNICATION_PVT.g_vendor_country, PO_COMMUNICATION_PVT.g_vendor_address_line_4
7386: FROM
7387: PO_VENDOR_SITES_ALL PVS,
7388: FND_TERRITORIES_TL FTE
7389: WHERE
7390: PVS.COUNTRY = FTE.TERRITORY_CODE AND
7391: DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, '1', USERENV('LANG')) AND
7392: PVS.VENDOR_SITE_ID = p_vendor_site_id ;