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_CUST_ACCOUNTS

Line 2217: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;

2213: l_api_name CONSTANT VARCHAR2(30) := 'ship_to_address_handler';
2214: EXCP_USER_DEFINED EXCEPTION;
2215:
2216: l_customer_profile_class_id AR_CUSTOMER_PROFILE_CLASSES_V.customer_profile_class_id%TYPE := 0; -- internal customer
2217: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2218: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2219: l_location_id hr_locations_all.location_id%TYPE := NULL;
2220: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2221: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;

Line 2218: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;

2214: EXCP_USER_DEFINED EXCEPTION;
2215:
2216: l_customer_profile_class_id AR_CUSTOMER_PROFILE_CLASSES_V.customer_profile_class_id%TYPE := 0; -- internal customer
2217: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2218: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2219: l_location_id hr_locations_all.location_id%TYPE := NULL;
2220: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2221: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2222: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;

Line 2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;

2224: l_party_id hz_parties.party_id%TYPE := NULL;
2225: l_first_name hz_parties.person_first_name%TYPE := NULL;
2226: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2227: l_last_name hz_parties.person_last_name%TYPE := NULL;
2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;

Line 2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;

2225: l_first_name hz_parties.person_first_name%TYPE := NULL;
2226: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2227: l_last_name hz_parties.person_last_name%TYPE := NULL;
2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;

Line 2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;

2226: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2227: l_last_name hz_parties.person_last_name%TYPE := NULL;
2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;

Line 2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;

2227: l_last_name hz_parties.person_last_name%TYPE := NULL;
2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;

Line 2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;

2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;

Line 2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;

2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;

Line 2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;

2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;

Line 2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;

2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;

Line 2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;

2232: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;

Line 2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;

2233: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;

Line 2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;

2234: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;

Line 2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;

2235: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;

Line 2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;

2236: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;

Line 2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;

2237: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;

Line 2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;

2238: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;

Line 2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;

2239: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;

Line 2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;

2240: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;

Line 2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;

2241: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;

Line 2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;

2242: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;

Line 2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;

2243: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;

Line 2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;

2244: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;

Line 2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;

2245: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;

Line 2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;

2246: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;

Line 2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;

2247: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;

Line 2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;

2248: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;

Line 2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;

2249: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;

Line 2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;

2250: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;

Line 2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;

2251: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;

Line 2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;

2252: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;

Line 2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;

2253: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;

Line 2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;

2254: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;

Line 2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;

2255: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;

Line 2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;

2256: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;

Line 2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;

2257: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;

Line 2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;

2258: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;

Line 2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;

2259: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;

Line 2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;

2260: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;

Line 2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;

2261: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;

Line 2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;

2262: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;

Line 2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;

2263: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;

Line 2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;

2264: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;

Line 2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;

2265: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;

Line 2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;

2266: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;

Line 2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;

2267: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;

Line 2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;

2268: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;

Line 2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;

2269: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;

Line 2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;

2270: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;

Line 2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;

2271: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;

Line 2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;

2272: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;

Line 2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;

2273: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;

Line 2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;

2274: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;

Line 2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;

2275: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;

Line 2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;

2276: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;

Line 2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;

2277: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;

Line 2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;

2278: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;

Line 2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;

2279: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;

Line 2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;

2280: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;

Line 2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;

2281: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active

Line 2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;

2282: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal

Line 2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;

2283: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;

Line 2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;

2284: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;

Line 2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active

2285: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;

Line 2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal

2286: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;

Line 2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;

2287: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;

Line 2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;

2288: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;

Line 2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;

2289: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2297: l_reference_use_flag VARCHAR2(1) := 'N';

Line 2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;

2290: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2297: l_reference_use_flag VARCHAR2(1) := 'N';
2298: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;

Line 2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;

2291: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2297: l_reference_use_flag VARCHAR2(1) := 'N';
2298: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2299: l_third_party_flag VARCHAR2(1) := 'N';

Line 2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;

2292: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2293: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2297: l_reference_use_flag VARCHAR2(1) := 'N';
2298: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2299: l_third_party_flag VARCHAR2(1) := 'N';
2300: l_competitor_flag VARCHAR2(1) := 'N';

Line 2298: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;

2294: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2295: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2296: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2297: l_reference_use_flag VARCHAR2(1) := 'N';
2298: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2299: l_third_party_flag VARCHAR2(1) := 'N';
2300: l_competitor_flag VARCHAR2(1) := 'N';
2301: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2302: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;

Line 2301: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;

2297: l_reference_use_flag VARCHAR2(1) := 'N';
2298: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2299: l_third_party_flag VARCHAR2(1) := 'N';
2300: l_competitor_flag VARCHAR2(1) := 'N';
2301: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2302: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;

Line 2302: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;

2298: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2299: l_third_party_flag VARCHAR2(1) := 'N';
2300: l_competitor_flag VARCHAR2(1) := 'N';
2301: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2302: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;

Line 2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;

2299: l_third_party_flag VARCHAR2(1) := 'N';
2300: l_competitor_flag VARCHAR2(1) := 'N';
2301: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2302: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;

Line 2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;

2300: l_competitor_flag VARCHAR2(1) := 'N';
2301: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2302: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;

Line 2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;

2301: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2302: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;

Line 2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;

2302: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;

Line 2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;

2303: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;

Line 2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;

2304: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;

Line 2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;

2305: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;

Line 2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;

2306: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;

Line 2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;

2307: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;

Line 2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;

2308: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;

Line 2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;

2309: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;

Line 2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;

2310: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';

Line 2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;

2311: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';

Line 2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;

2312: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';

Line 2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;

2313: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;

Line 2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';

2314: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2322: l_party_number hz_parties.party_number%TYPE := NULL;

Line 2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';

2315: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2322: l_party_number hz_parties.party_number%TYPE := NULL;
2323: l_customer_key hz_parties.customer_key%TYPE := NULL;

Line 2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';

2316: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2322: l_party_number hz_parties.party_number%TYPE := NULL;
2323: l_customer_key hz_parties.customer_key%TYPE := NULL;
2324: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;

Line 2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;

2317: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2322: l_party_number hz_parties.party_number%TYPE := NULL;
2323: l_customer_key hz_parties.customer_key%TYPE := NULL;
2324: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2325: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;

Line 2471: t_party_id hz_cust_accounts.party_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;
2472: t_party_site_id hz_party_sites.party_site_id%TYPE;
2473: t_party_site_number hz_party_sites.party_site_number%TYPE;
2474: t_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE;
2475: t_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE;

Line 2521: select party_id from hz_cust_accounts where cust_account_id = l_customer_id;

2517: where resource_type = l_resource_type
2518: and resource_id = l_resource_id;
2519:
2520: CURSOR l_party_id_csr IS
2521: select party_id from hz_cust_accounts where cust_account_id = l_customer_id;
2522:
2523: CURSOR l_requirement_hdr_csr IS
2524: -- select ship_to_location_id from csp_requirement_headers where task_assignment_id = p_task_assignment_id;
2525: select ship_to_location_id,

Line 2546: select hz_cust_accounts_s.nextval from dual;

2542: CURSOR l_party_number_csr IS
2543: select hz_parties_s.nextval from dual;
2544:
2545: CURSOR l_customer_number_csr IS
2546: select hz_cust_accounts_s.nextval from dual;
2547:
2548: CURSOR l_party_site_number_csr IS
2549: select hz_party_sites_s.nextval from dual;
2550:

Line 2814: -- Use the customer_id to retrieve party_id from hz_cust_accounts

2810: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;
2811: IF l_customer_id_csr%FOUND and l_customer_id IS NOT NULL THEN
2812: CLOSE l_customer_id_csr;
2813:
2814: -- Use the customer_id to retrieve party_id from hz_cust_accounts
2815: OPEN l_party_id_csr;
2816: FETCH l_party_id_csr INTO l_party_id;
2817: IF l_party_id_csr%NOTFOUND THEN
2818: CLOSE l_party_id_csr;