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

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

2876: l_autocash_hier_id_for_adr hz_customer_profiles.autocash_hierarchy_id_for_adr%TYPE := NULL;
2877: l_lockbox_matching_option hz_customer_profiles.lockbox_matching_option%TYPE := NULL;
2878: l_lockbox_matching_name VARCHAR2(80) := NULL;
2879:
2880: s_Address_Id hz_locations.location_id%TYPE := NULL;
2881: s_Status hz_party_sites.Status%TYPE := 'A';
2882: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2883: s_Country hz_locations.Country%TYPE := NULL;
2884: s_Address1 hz_locations.Address1%TYPE := NULL;

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

2878: l_lockbox_matching_name VARCHAR2(80) := NULL;
2879:
2880: s_Address_Id hz_locations.location_id%TYPE := NULL;
2881: s_Status hz_party_sites.Status%TYPE := 'A';
2882: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2883: s_Country hz_locations.Country%TYPE := NULL;
2884: s_Address1 hz_locations.Address1%TYPE := NULL;
2885: s_Address2 hz_locations.Address2%TYPE := NULL;
2886: s_Address3 hz_locations.Address3%TYPE := NULL;

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

2879:
2880: s_Address_Id hz_locations.location_id%TYPE := NULL;
2881: s_Status hz_party_sites.Status%TYPE := 'A';
2882: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2883: s_Country hz_locations.Country%TYPE := NULL;
2884: s_Address1 hz_locations.Address1%TYPE := NULL;
2885: s_Address2 hz_locations.Address2%TYPE := NULL;
2886: s_Address3 hz_locations.Address3%TYPE := NULL;
2887: s_Address4 hz_locations.Address4%TYPE := NULL;

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

2880: s_Address_Id hz_locations.location_id%TYPE := NULL;
2881: s_Status hz_party_sites.Status%TYPE := 'A';
2882: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2883: s_Country hz_locations.Country%TYPE := NULL;
2884: s_Address1 hz_locations.Address1%TYPE := NULL;
2885: s_Address2 hz_locations.Address2%TYPE := NULL;
2886: s_Address3 hz_locations.Address3%TYPE := NULL;
2887: s_Address4 hz_locations.Address4%TYPE := NULL;
2888: s_City hz_locations.City%TYPE := NULL;

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

2881: s_Status hz_party_sites.Status%TYPE := 'A';
2882: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2883: s_Country hz_locations.Country%TYPE := NULL;
2884: s_Address1 hz_locations.Address1%TYPE := NULL;
2885: s_Address2 hz_locations.Address2%TYPE := NULL;
2886: s_Address3 hz_locations.Address3%TYPE := NULL;
2887: s_Address4 hz_locations.Address4%TYPE := NULL;
2888: s_City hz_locations.City%TYPE := NULL;
2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;

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

2882: s_Orig_System_Reference hz_locations.Orig_System_Reference%TYPE := NULL;
2883: s_Country hz_locations.Country%TYPE := NULL;
2884: s_Address1 hz_locations.Address1%TYPE := NULL;
2885: s_Address2 hz_locations.Address2%TYPE := NULL;
2886: s_Address3 hz_locations.Address3%TYPE := NULL;
2887: s_Address4 hz_locations.Address4%TYPE := NULL;
2888: s_City hz_locations.City%TYPE := NULL;
2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2890: s_State hz_locations.State%TYPE := NULL;

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

2883: s_Country hz_locations.Country%TYPE := NULL;
2884: s_Address1 hz_locations.Address1%TYPE := NULL;
2885: s_Address2 hz_locations.Address2%TYPE := NULL;
2886: s_Address3 hz_locations.Address3%TYPE := NULL;
2887: s_Address4 hz_locations.Address4%TYPE := NULL;
2888: s_City hz_locations.City%TYPE := NULL;
2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2890: s_State hz_locations.State%TYPE := NULL;
2891: s_Province hz_locations.Province%TYPE := NULL;

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

2884: s_Address1 hz_locations.Address1%TYPE := NULL;
2885: s_Address2 hz_locations.Address2%TYPE := NULL;
2886: s_Address3 hz_locations.Address3%TYPE := NULL;
2887: s_Address4 hz_locations.Address4%TYPE := NULL;
2888: s_City hz_locations.City%TYPE := NULL;
2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2890: s_State hz_locations.State%TYPE := NULL;
2891: s_Province hz_locations.Province%TYPE := NULL;
2892: s_County hz_locations.County%TYPE := NULL;

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

2885: s_Address2 hz_locations.Address2%TYPE := NULL;
2886: s_Address3 hz_locations.Address3%TYPE := NULL;
2887: s_Address4 hz_locations.Address4%TYPE := NULL;
2888: s_City hz_locations.City%TYPE := NULL;
2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2890: s_State hz_locations.State%TYPE := NULL;
2891: s_Province hz_locations.Province%TYPE := NULL;
2892: s_County hz_locations.County%TYPE := NULL;
2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);

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

2886: s_Address3 hz_locations.Address3%TYPE := NULL;
2887: s_Address4 hz_locations.Address4%TYPE := NULL;
2888: s_City hz_locations.City%TYPE := NULL;
2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2890: s_State hz_locations.State%TYPE := NULL;
2891: s_Province hz_locations.Province%TYPE := NULL;
2892: s_County hz_locations.County%TYPE := NULL;
2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;

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

2887: s_Address4 hz_locations.Address4%TYPE := NULL;
2888: s_City hz_locations.City%TYPE := NULL;
2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2890: s_State hz_locations.State%TYPE := NULL;
2891: s_Province hz_locations.Province%TYPE := NULL;
2892: s_County hz_locations.County%TYPE := NULL;
2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2895: s_Language hz_locations.Language%TYPE := NULL;

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

2888: s_City hz_locations.City%TYPE := NULL;
2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2890: s_State hz_locations.State%TYPE := NULL;
2891: s_Province hz_locations.Province%TYPE := NULL;
2892: s_County hz_locations.County%TYPE := NULL;
2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2895: s_Language hz_locations.Language%TYPE := NULL;
2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;

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

2889: s_Postal_Code hz_locations.Postal_Code%TYPE := NULL;
2890: s_State hz_locations.State%TYPE := NULL;
2891: s_Province hz_locations.Province%TYPE := NULL;
2892: s_County hz_locations.County%TYPE := NULL;
2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2895: s_Language hz_locations.Language%TYPE := NULL;
2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;

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

2890: s_State hz_locations.State%TYPE := NULL;
2891: s_Province hz_locations.Province%TYPE := NULL;
2892: s_County hz_locations.County%TYPE := NULL;
2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2895: s_Language hz_locations.Language%TYPE := NULL;
2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2898: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;

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

2891: s_Province hz_locations.Province%TYPE := NULL;
2892: s_County hz_locations.County%TYPE := NULL;
2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2895: s_Language hz_locations.Language%TYPE := NULL;
2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2898: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2899: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;

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

2892: s_County hz_locations.County%TYPE := NULL;
2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2895: s_Language hz_locations.Language%TYPE := NULL;
2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2898: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2899: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2900: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;

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

2893: s_Last_Update_Login hz_locations.Last_Update_Login%TYPE := nvl(fnd_global.user_id,1);
2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2895: s_Language hz_locations.Language%TYPE := NULL;
2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2898: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2899: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2900: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2901: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;

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

2894: s_Address_Key hz_locations.Address_Key%TYPE := NULL;
2895: s_Language hz_locations.Language%TYPE := NULL;
2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2898: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2899: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2900: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2901: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2902: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;

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

2895: s_Language hz_locations.Language%TYPE := NULL;
2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2898: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2899: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2900: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2901: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2902: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2903: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;

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

2896: s_Attribute_Category hz_locations.Attribute_Category%TYPE := NULL;
2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2898: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2899: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2900: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2901: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2902: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2903: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2904: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;

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

2897: s_Attribute1 hz_locations.Attribute1%TYPE := NULL;
2898: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2899: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2900: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2901: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2902: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2903: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2904: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2905: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;

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

2898: s_Attribute2 hz_locations.Attribute2%TYPE := NULL;
2899: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2900: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2901: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2902: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2903: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2904: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2905: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2906: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;

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

2899: s_Attribute3 hz_locations.Attribute3%TYPE := NULL;
2900: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2901: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2902: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2903: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2904: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2905: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2906: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2907: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;

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

2900: s_Attribute4 hz_locations.Attribute4%TYPE := NULL;
2901: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2902: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2903: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2904: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2905: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2906: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2907: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2908: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;

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

2901: s_Attribute5 hz_locations.Attribute5%TYPE := NULL;
2902: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2903: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2904: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2905: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2906: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2907: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2908: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2909: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;

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

2902: s_Attribute6 hz_locations.Attribute6%TYPE := NULL;
2903: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2904: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2905: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2906: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2907: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2908: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2909: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2910: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;

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

2903: s_Attribute7 hz_locations.Attribute7%TYPE := NULL;
2904: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2905: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2906: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2907: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2908: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2909: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2910: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2911: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;

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

2904: s_Attribute8 hz_locations.Attribute8%TYPE := NULL;
2905: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2906: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2907: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2908: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2909: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2910: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2911: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2912: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;

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

2905: s_Attribute9 hz_locations.Attribute9%TYPE := NULL;
2906: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2907: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2908: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2909: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2910: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2911: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2912: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2913: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;

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

2906: s_Attribute10 hz_locations.Attribute10%TYPE := NULL;
2907: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2908: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2909: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2910: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2911: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2912: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2913: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2914: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;

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

2907: s_Attribute11 hz_locations.Attribute11%TYPE := NULL;
2908: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2909: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2910: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2911: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2912: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2913: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2914: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2915: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;

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

2908: s_Attribute12 hz_locations.Attribute12%TYPE := NULL;
2909: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2910: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2911: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2912: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2913: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2914: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2915: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2916: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;

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

2909: s_Attribute13 hz_locations.Attribute13%TYPE := NULL;
2910: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2911: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2912: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2913: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2914: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2915: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2916: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2917: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;

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

2910: s_Attribute14 hz_locations.Attribute14%TYPE := NULL;
2911: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2912: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2913: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2914: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2915: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2916: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2917: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2918: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;

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

2911: s_Attribute15 hz_locations.Attribute15%TYPE := NULL;
2912: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2913: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2914: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2915: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2916: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2917: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2918: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2919: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;

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

2912: s_Attribute16 hz_locations.Attribute16%TYPE := NULL;
2913: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2914: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2915: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2916: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2917: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2918: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2919: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2920: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;

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

2913: s_Attribute17 hz_locations.Attribute17%TYPE := NULL;
2914: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2915: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2916: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2917: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2918: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2919: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2920: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2921: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;

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

2914: s_Attribute18 hz_locations.Attribute18%TYPE := NULL;
2915: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2916: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2917: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2918: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2919: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2920: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2921: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2922: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;

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

2915: s_Attribute19 hz_locations.Attribute19%TYPE := NULL;
2916: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2917: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2918: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2919: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2920: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2921: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2922: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2923: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;

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

2916: s_Attribute20 hz_locations.Attribute20%TYPE := NULL;
2917: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2918: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2919: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2920: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2921: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2922: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2923: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2924: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;

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

2917: s_Global_Attribute_Category hz_locations.Global_Attribute_Category%TYPE := NULL;
2918: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2919: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2920: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2921: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2922: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2923: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2924: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2925: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;

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

2918: s_Global_Attribute1 hz_locations.Global_Attribute1%TYPE := NULL;
2919: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2920: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2921: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2922: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2923: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2924: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2925: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2926: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;

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

2919: s_Global_Attribute2 hz_locations.Global_Attribute2%TYPE := NULL;
2920: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2921: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2922: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2923: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2924: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2925: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2926: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2927: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;

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

2920: s_Global_Attribute3 hz_locations.Global_Attribute3%TYPE := NULL;
2921: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2922: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2923: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2924: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2925: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2926: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2927: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2928: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;

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

2921: s_Global_Attribute4 hz_locations.Global_Attribute4%TYPE := NULL;
2922: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2923: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2924: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2925: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2926: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2927: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2928: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2929: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;

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

2922: s_Global_Attribute5 hz_locations.Global_Attribute5%TYPE := NULL;
2923: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2924: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2925: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2926: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2927: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2928: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2929: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2930: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;

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

2923: s_Global_Attribute6 hz_locations.Global_Attribute6%TYPE := NULL;
2924: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2925: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2926: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2927: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2928: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2929: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2930: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2931: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;

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

2924: s_Global_Attribute7 hz_locations.Global_Attribute7%TYPE := NULL;
2925: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2926: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2927: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2928: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2929: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2930: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2931: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2932: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;

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

2925: s_Global_Attribute8 hz_locations.Global_Attribute8%TYPE := NULL;
2926: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2927: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2928: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2929: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2930: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2931: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2932: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2933: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;

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

2926: s_Global_Attribute9 hz_locations.Global_Attribute9%TYPE := NULL;
2927: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2928: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2929: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2930: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2931: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2932: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2933: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2934: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;

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

2927: s_Global_Attribute10 hz_locations.Global_Attribute10%TYPE := NULL;
2928: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2929: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2930: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2931: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2932: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2933: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2934: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2935: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;

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

2928: s_Global_Attribute11 hz_locations.Global_Attribute11%TYPE := NULL;
2929: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2930: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2931: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2932: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2933: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2934: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2935: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2936: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;

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

2929: s_Global_Attribute12 hz_locations.Global_Attribute12%TYPE := NULL;
2930: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2931: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2932: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2933: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2934: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2935: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2936: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2937: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;

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

2930: s_Global_Attribute13 hz_locations.Global_Attribute13%TYPE := NULL;
2931: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2932: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2933: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2934: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2935: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2936: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2937: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2938:

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

2931: s_Global_Attribute14 hz_locations.Global_Attribute14%TYPE := NULL;
2932: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2933: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2934: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2935: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2936: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2937: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2938:
2939: s_Address_warning BOOLEAN;

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

2932: s_Global_Attribute15 hz_locations.Global_Attribute15%TYPE := NULL;
2933: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2934: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2935: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2936: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2937: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2938:
2939: s_Address_warning BOOLEAN;
2940: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;

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

2933: s_Global_Attribute16 hz_locations.Global_Attribute16%TYPE := NULL;
2934: s_Global_Attribute17 hz_locations.Global_Attribute17%TYPE := NULL;
2935: s_Global_Attribute18 hz_locations.Global_Attribute18%TYPE := NULL;
2936: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2937: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2938:
2939: s_Address_warning BOOLEAN;
2940: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2941: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;

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

2936: s_Global_Attribute19 hz_locations.Global_Attribute19%TYPE := NULL;
2937: s_Global_Attribute20 hz_locations.Global_Attribute20%TYPE := NULL;
2938:
2939: s_Address_warning BOOLEAN;
2940: s_Address_Lines_Phonetic hz_locations.Address_Lines_Phonetic%TYPE := NULL;
2941: s_Party_site_id hz_party_sites.Party_site_id%TYPE := NULL;
2942: s_Party_id hz_party_sites.Party_id%TYPE := NULL;
2943: s_Location_id hz_party_sites.Location_id%TYPE := NULL;
2944: s_Party_Site_Number hz_party_sites.Party_Site_Number%TYPE := NULL;

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

2957: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2958: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2959: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2960: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2961: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2962: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
2963: s_ADDRESSEE VARCHAR2(50) := NULL;
2964: s_shared_party_site VARCHAR2(1) := 'N';
2965: s_update_account_site VARCHAR2(1) := 'N';

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

2958: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2959: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2960: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2961: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2962: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
2963: s_ADDRESSEE VARCHAR2(50) := NULL;
2964: s_shared_party_site VARCHAR2(1) := 'N';
2965: s_update_account_site VARCHAR2(1) := 'N';
2966: s_create_location_party_site VARCHAR2(1) := 'N';

Line 2973: t_orig_system_reference hz_locations.orig_system_reference%TYPE;

2969: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2970: t_status hz_cust_site_uses_all.status%TYPE;
2971: t_address_id po_location_associations_all.address_id%TYPE;
2972: t_site_loc_id hr_locations.location_id%TYPE;
2973: t_orig_system_reference hz_locations.orig_system_reference%TYPE;
2974: t_last_update_date DATE;
2975: t_party_site_last_update_date DATE;
2976: t_loc_last_update_date DATE;
2977: t_party_id hz_cust_accounts.party_id%TYPE;

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

3079: c.translated_customer_name,
3080: c.last_update_date,
3081: ps.last_update_date,
3082: z.last_update_date
3083: from po_location_associations p, hz_locations z, hz_cust_acct_sites c, hz_party_sites ps
3084: 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;
3085:
3086: CURSOR l_inv_loc_csr IS
3087: 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 3849: update hz_locations set time_zone = l_timezone_id where location_id = t_site_loc_id;

3845: t_primary_flag := p_primary_flag;
3846: END IF;
3847:
3848: IF l_timezone_id IS NOT NULL THEN
3849: update hz_locations set time_zone = l_timezone_id where location_id = t_site_loc_id;
3850: END IF;
3851:
3852: open l_cust_acct_site(t_cust_acct_site_id);
3853: fetch l_cust_acct_site into l_attribute_category,

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

4254: RAISE EXCP_USER_DEFINED;
4255: END IF;
4256:
4257: IF l_timezone_id IS NOT NULL THEN
4258: update hz_locations set time_zone = l_timezone_id where location_id = s_location_id;
4259: END IF;
4260:
4261: -- Create site use to link to the inventory location
4262: do_create_site_use(

Line 5306: FROM hz_locations

5302: CURSOR address_cur IS
5303: SELECT country, address1, address2, address3,
5304: address4, city, postal_code, state,
5305: province, county
5306: FROM hz_locations
5307: WHERE location_id = px_location_id;
5308:
5309: address_rec address_cur%ROWTYPE;
5310: