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.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_LOCATIONS

Line 2374: s_Address_Id hz_locations.location_id%TYPE := NULL;

2370: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2371: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2372: l_lockbox_matching_name VARCHAR2(80) := NULL;
2373:
2374: s_Address_Id hz_locations.location_id%TYPE := NULL;
2375: s_Status hz_party_sites.Status%TYPE := 'A';
2376: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2377: s_Country hz_locations.Country%TYPE := NULL;
2378: s_Address1 hz_locations.Address1%TYPE := NULL;

Line 2376: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;

2372: l_lockbox_matching_name VARCHAR2(80) := NULL;
2373:
2374: s_Address_Id hz_locations.location_id%TYPE := NULL;
2375: s_Status hz_party_sites.Status%TYPE := 'A';
2376: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2377: s_Country hz_locations.Country%TYPE := NULL;
2378: s_Address1 hz_locations.Address1%TYPE := NULL;
2379: s_Address2 hz_locations.Address2%TYPE := NULL;
2380: s_Address3 hz_locations.Address3%TYPE := NULL;

Line 2377: s_Country hz_locations.Country%TYPE := NULL;

2373:
2374: s_Address_Id hz_locations.location_id%TYPE := NULL;
2375: s_Status hz_party_sites.Status%TYPE := 'A';
2376: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2377: s_Country hz_locations.Country%TYPE := NULL;
2378: s_Address1 hz_locations.Address1%TYPE := NULL;
2379: s_Address2 hz_locations.Address2%TYPE := NULL;
2380: s_Address3 hz_locations.Address3%TYPE := NULL;
2381: s_Address4 hz_locations.Address4%TYPE := NULL;

Line 2378: s_Address1 hz_locations.Address1%TYPE := NULL;

2374: s_Address_Id hz_locations.location_id%TYPE := NULL;
2375: s_Status hz_party_sites.Status%TYPE := 'A';
2376: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2377: s_Country hz_locations.Country%TYPE := NULL;
2378: s_Address1 hz_locations.Address1%TYPE := NULL;
2379: s_Address2 hz_locations.Address2%TYPE := NULL;
2380: s_Address3 hz_locations.Address3%TYPE := NULL;
2381: s_Address4 hz_locations.Address4%TYPE := NULL;
2382: s_City hz_locations.City%TYPE := NULL;

Line 2379: s_Address2 hz_locations.Address2%TYPE := NULL;

2375: s_Status hz_party_sites.Status%TYPE := 'A';
2376: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2377: s_Country hz_locations.Country%TYPE := NULL;
2378: s_Address1 hz_locations.Address1%TYPE := NULL;
2379: s_Address2 hz_locations.Address2%TYPE := NULL;
2380: s_Address3 hz_locations.Address3%TYPE := NULL;
2381: s_Address4 hz_locations.Address4%TYPE := NULL;
2382: s_City hz_locations.City%TYPE := NULL;
2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;

Line 2380: s_Address3 hz_locations.Address3%TYPE := NULL;

2376: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2377: s_Country hz_locations.Country%TYPE := NULL;
2378: s_Address1 hz_locations.Address1%TYPE := NULL;
2379: s_Address2 hz_locations.Address2%TYPE := NULL;
2380: s_Address3 hz_locations.Address3%TYPE := NULL;
2381: s_Address4 hz_locations.Address4%TYPE := NULL;
2382: s_City hz_locations.City%TYPE := NULL;
2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2384: s_State hz_locations.State%TYPE := NULL;

Line 2381: s_Address4 hz_locations.Address4%TYPE := NULL;

2377: s_Country hz_locations.Country%TYPE := NULL;
2378: s_Address1 hz_locations.Address1%TYPE := NULL;
2379: s_Address2 hz_locations.Address2%TYPE := NULL;
2380: s_Address3 hz_locations.Address3%TYPE := NULL;
2381: s_Address4 hz_locations.Address4%TYPE := NULL;
2382: s_City hz_locations.City%TYPE := NULL;
2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2384: s_State hz_locations.State%TYPE := NULL;
2385: s_Province hz_locations.Province%TYPE := NULL;

Line 2382: s_City hz_locations.City%TYPE := NULL;

2378: s_Address1 hz_locations.Address1%TYPE := NULL;
2379: s_Address2 hz_locations.Address2%TYPE := NULL;
2380: s_Address3 hz_locations.Address3%TYPE := NULL;
2381: s_Address4 hz_locations.Address4%TYPE := NULL;
2382: s_City hz_locations.City%TYPE := NULL;
2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2384: s_State hz_locations.State%TYPE := NULL;
2385: s_Province hz_locations.Province%TYPE := NULL;
2386: s_County hz_locations.County%TYPE := NULL;

Line 2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;

2379: s_Address2 hz_locations.Address2%TYPE := NULL;
2380: s_Address3 hz_locations.Address3%TYPE := NULL;
2381: s_Address4 hz_locations.Address4%TYPE := NULL;
2382: s_City hz_locations.City%TYPE := NULL;
2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2384: s_State hz_locations.State%TYPE := NULL;
2385: s_Province hz_locations.Province%TYPE := NULL;
2386: s_County hz_locations.County%TYPE := NULL;
2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);

Line 2384: s_State hz_locations.State%TYPE := NULL;

2380: s_Address3 hz_locations.Address3%TYPE := NULL;
2381: s_Address4 hz_locations.Address4%TYPE := NULL;
2382: s_City hz_locations.City%TYPE := NULL;
2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2384: s_State hz_locations.State%TYPE := NULL;
2385: s_Province hz_locations.Province%TYPE := NULL;
2386: s_County hz_locations.County%TYPE := NULL;
2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;

Line 2385: s_Province hz_locations.Province%TYPE := NULL;

2381: s_Address4 hz_locations.Address4%TYPE := NULL;
2382: s_City hz_locations.City%TYPE := NULL;
2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2384: s_State hz_locations.State%TYPE := NULL;
2385: s_Province hz_locations.Province%TYPE := NULL;
2386: s_County hz_locations.County%TYPE := NULL;
2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2389: s_Language hz_locations.Language%TYPE := NULL;

Line 2386: s_County hz_locations.County%TYPE := NULL;

2382: s_City hz_locations.City%TYPE := NULL;
2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2384: s_State hz_locations.State%TYPE := NULL;
2385: s_Province hz_locations.Province%TYPE := NULL;
2386: s_County hz_locations.County%TYPE := NULL;
2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2389: s_Language hz_locations.Language%TYPE := NULL;
2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;

Line 2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);

2383: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2384: s_State hz_locations.State%TYPE := NULL;
2385: s_Province hz_locations.Province%TYPE := NULL;
2386: s_County hz_locations.County%TYPE := NULL;
2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2389: s_Language hz_locations.Language%TYPE := NULL;
2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;

Line 2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;

2384: s_State hz_locations.State%TYPE := NULL;
2385: s_Province hz_locations.Province%TYPE := NULL;
2386: s_County hz_locations.County%TYPE := NULL;
2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2389: s_Language hz_locations.Language%TYPE := NULL;
2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;

Line 2389: s_Language hz_locations.Language%TYPE := NULL;

2385: s_Province hz_locations.Province%TYPE := NULL;
2386: s_County hz_locations.County%TYPE := NULL;
2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2389: s_Language hz_locations.Language%TYPE := NULL;
2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;

Line 2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;

2386: s_County hz_locations.County%TYPE := NULL;
2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2389: s_Language hz_locations.Language%TYPE := NULL;
2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;

Line 2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;

2387: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2389: s_Language hz_locations.Language%TYPE := NULL;
2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;

Line 2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;

2388: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2389: s_Language hz_locations.Language%TYPE := NULL;
2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;

Line 2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;

2389: s_Language hz_locations.Language%TYPE := NULL;
2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;

Line 2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;

2390: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;

Line 2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;

2391: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;

Line 2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;

2392: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;

Line 2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;

2393: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;

Line 2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;

2394: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;

Line 2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;

2395: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;

Line 2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;

2396: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;

Line 2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;

2397: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;

Line 2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;

2398: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;

Line 2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;

2399: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;

Line 2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;

2400: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;

Line 2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;

2401: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;

Line 2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;

2402: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;

Line 2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;

2403: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;

Line 2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;

2404: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;

Line 2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;

2405: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;

Line 2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;

2406: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;

Line 2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;

2407: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;

Line 2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;

2408: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;

Line 2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;

2409: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;

Line 2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;

2410: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;

Line 2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;

2411: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;

Line 2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;

2412: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;

Line 2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;

2413: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;

Line 2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;

2414: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;

Line 2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;

2415: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;

Line 2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;

2416: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;

Line 2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;

2417: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;

Line 2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;

2418: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;

Line 2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;

2419: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;

Line 2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;

2420: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2428: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;

Line 2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;

2421: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2428: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2429: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;

Line 2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;

2422: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2428: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2429: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2430: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;

Line 2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;

2423: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2428: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2429: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2430: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2431: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;

Line 2428: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;

2424: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2428: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2429: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2430: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2431: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2432:

Line 2429: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;

2425: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2428: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2429: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2430: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2431: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2432:
2433: s_Address_warning BOOLEAN;

Line 2430: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;

2426: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2428: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2429: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2430: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2431: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2432:
2433: s_Address_warning BOOLEAN;
2434: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;

Line 2431: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;

2427: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2428: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2429: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2430: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2431: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2432:
2433: s_Address_warning BOOLEAN;
2434: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2435: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;

Line 2434: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;

2430: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2431: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2432:
2433: s_Address_warning BOOLEAN;
2434: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2435: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2436: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2437: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2438: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;

Line 2455: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;

2451: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2452: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2453: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2454: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2455: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2456: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
2457: s_ADDRESSEE VARCHAR2(50) := NULL;
2458: s_shared_party_site VARCHAR2(1) := 'N';
2459: s_update_account_site VARCHAR2(1) := 'N';

Line 2456: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';

2452: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2453: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2454: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2455: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2456: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
2457: s_ADDRESSEE VARCHAR2(50) := NULL;
2458: s_shared_party_site VARCHAR2(1) := 'N';
2459: s_update_account_site VARCHAR2(1) := 'N';
2460: s_create_location_party_site VARCHAR2(1) := 'N';

Line 2467: t_orig_system_reference hz_locations.orig_system_reference%TYPE;

2463: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2464: t_status hz_cust_site_uses_all.status%TYPE;
2465: t_address_id po_location_associations_all.address_id%TYPE;
2466: t_site_loc_id hr_locations.location_id%TYPE;
2467: t_orig_system_reference hz_locations.orig_system_reference%TYPE;
2468: t_last_update_date DATE;
2469: t_party_site_last_update_date DATE;
2470: t_loc_last_update_date DATE;
2471: t_party_id hz_cust_accounts.party_id%TYPE;

Line 2575: from po_location_associations p, hz_locations z, hz_cust_acct_sites c, hz_party_sites ps

2571: c.translated_customer_name,
2572: c.last_update_date,
2573: ps.last_update_date,
2574: z.last_update_date
2575: from po_location_associations p, hz_locations z, hz_cust_acct_sites c, hz_party_sites ps
2576: where p.address_id = c.cust_acct_site_id and c.party_site_id = ps.party_site_id and ps.location_id = z.location_id and p.location_id = l_inv_location_id;
2577:
2578: CURSOR l_inv_loc_csr IS
2579: select address_line_1, address_line_2, address_line_3, town_or_city, country, postal_code, region_1, region_2, region_3, attribute_category,

Line 3291: update hz_locations set time_zone = l_timezone_id where location_id = t_site_loc_id;

3287: t_primary_flag := p_primary_flag;
3288: END IF;
3289:
3290: IF l_timezone_id IS NOT NULL THEN
3291: update hz_locations set time_zone = l_timezone_id where location_id = t_site_loc_id;
3292: END IF;
3293:
3294: -- If p_primary_flag is not null or p_status is not null, calling from the
3295: -- Resource Ship To Address and Subinventory Assignments form, update it.

Line 3677: update hz_locations set time_zone = l_timezone_id where location_id = s_location_id;

3673: RAISE EXCP_USER_DEFINED;
3674: END IF;
3675:
3676: IF l_timezone_id IS NOT NULL THEN
3677: update hz_locations set time_zone = l_timezone_id where location_id = s_location_id;
3678: END IF;
3679:
3680: -- Create site use to link to the inventory location
3681: do_create_site_use(

Line 4444: FROM hz_locations

4440: CURSOR address_cur IS
4441: SELECT country, address1, address2, address3,
4442: address4, city, postal_code, state,
4443: province, county
4444: FROM hz_locations
4445: WHERE location_id = px_location_id;
4446:
4447: address_rec address_cur%ROWTYPE;
4448: