DBA Data[Home] [Help]

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 105: g_legal_entity_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%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 ----
109:

Line 6278: FND_TERRITORIES_TL FTE

6274: l_address_line_1, PO_COMMUNICATION_PVT.g_vendor_address_line_2, PO_COMMUNICATION_PVT.g_vendor_address_line_3,
6275: l_city, l_state, l_zip, PO_COMMUNICATION_PVT.g_vendor_country, PO_COMMUNICATION_PVT.g_vendor_address_line_4
6276: FROM
6277: PO_VENDOR_SITES_ALL PVS,
6278: FND_TERRITORIES_TL FTE
6279: WHERE
6280: PVS.COUNTRY = FTE.TERRITORY_CODE AND
6281: DECODE(FTE.TERRITORY_CODE, NULL, '1', FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE, NULL, '1', USERENV('LANG')) AND
6282: PVS.VENDOR_SITE_ID = p_vendor_site_id ;