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 2723: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;

2719: l_api_name CONSTANT VARCHAR2(30) := 'ship_to_address_handler';
2720: EXCP_USER_DEFINED EXCEPTION;
2721:
2722: l_customer_profile_class_id AR_CUSTOMER_PROFILE_CLASSES_V.customer_profile_class_id%TYPE := 0; -- internal customer
2723: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2724: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2725: l_location_id hr_locations_all.location_id%TYPE := NULL;
2726: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;

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

2720: EXCP_USER_DEFINED EXCEPTION;
2721:
2722: l_customer_profile_class_id AR_CUSTOMER_PROFILE_CLASSES_V.customer_profile_class_id%TYPE := 0; -- internal customer
2723: l_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2724: t_customer_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2725: l_location_id hr_locations_all.location_id%TYPE := NULL;
2726: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;

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

2730: l_party_id hz_parties.party_id%TYPE := NULL;
2731: l_first_name hz_parties.person_first_name%TYPE := NULL;
2732: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2733: l_last_name hz_parties.person_last_name%TYPE := NULL;
2734: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2735: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2736: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2737: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2738: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;

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

2731: l_first_name hz_parties.person_first_name%TYPE := NULL;
2732: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2733: l_last_name hz_parties.person_last_name%TYPE := NULL;
2734: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2735: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2736: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2737: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2738: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2739: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;

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

2732: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2733: l_last_name hz_parties.person_last_name%TYPE := NULL;
2734: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2735: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2736: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2737: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2738: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2739: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2740: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;

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

2733: l_last_name hz_parties.person_last_name%TYPE := NULL;
2734: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2735: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2736: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2737: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2738: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2739: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2740: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2741: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;

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

2734: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2735: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2736: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2737: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2738: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2739: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2740: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2741: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2742: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;

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

2735: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2736: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2737: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2738: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2739: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2740: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2741: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2742: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2743: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;

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

2736: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2737: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2738: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2739: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2740: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2741: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2742: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2743: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2744: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;

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

2737: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2738: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2739: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2740: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2741: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2742: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2743: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2744: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2745: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;

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

2738: l_Attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2739: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2740: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2741: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2742: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2743: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2744: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2745: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2746: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;

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

2739: l_Attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2740: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2741: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2742: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2743: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2744: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2745: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2746: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2747: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;

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

2740: l_Attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2741: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2742: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2743: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2744: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2745: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2746: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2747: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2748: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;

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

2741: l_Attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2742: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2743: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2744: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2745: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2746: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2747: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2748: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2749: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;

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

2742: l_Attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2743: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2744: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2745: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2746: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2747: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2748: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2749: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2750: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;

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

2743: l_Attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2744: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2745: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2746: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2747: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2748: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2749: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2750: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2751: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;

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

2744: l_Attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2745: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2746: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2747: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2748: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2749: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2750: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2751: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2752: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;

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

2745: l_Attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2746: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2747: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2748: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2749: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2750: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2751: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2752: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2753: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;

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

2746: l_Attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2747: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2748: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2749: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2750: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2751: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2752: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2753: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2754: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;

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

2747: l_Attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2748: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2749: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2750: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2751: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2752: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2753: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2754: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2755: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;

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

2748: l_Attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2749: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2750: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2751: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2752: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2753: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2754: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2755: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2756: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;

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

2749: l_Attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2750: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2751: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2752: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2753: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2754: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2755: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2756: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2757: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;

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

2750: l_Attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2751: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2752: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2753: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2754: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2755: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2756: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2757: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2758: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;

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

2751: l_Attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2752: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2753: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2754: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2755: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2756: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2757: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2758: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2759: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;

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

2752: l_Attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2753: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2754: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2755: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2756: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2757: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2758: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2759: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2760: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;

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

2753: l_Attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2754: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2755: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2756: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2757: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2758: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2759: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2760: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2761: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;

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

2754: l_Attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2755: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2756: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2757: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2758: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2759: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2760: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2761: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2762: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;

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

2755: l_Attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2756: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2757: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2758: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2759: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2760: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2761: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2762: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2763: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;

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

2756: l_Attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2757: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2758: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2759: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2760: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2761: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2762: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2763: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2764: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;

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

2757: l_global_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2758: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2759: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2760: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2761: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2762: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2763: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2764: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2765: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;

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

2758: l_global_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2759: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2760: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2761: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2762: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2763: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2764: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2765: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2766: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;

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

2759: l_global_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2760: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2761: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2762: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2763: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2764: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2765: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2766: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2767: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;

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

2760: l_global_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2761: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2762: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2763: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2764: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2765: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2766: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2767: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2768: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;

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

2761: l_global_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2762: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2763: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2764: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2765: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2766: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2767: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2768: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2769: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;

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

2762: l_global_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2763: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2764: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2765: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2766: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2767: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2768: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2769: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2770: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;

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

2763: l_global_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2764: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2765: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2766: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2767: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2768: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2769: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2770: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2771: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;

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

2764: l_global_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2765: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2766: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2767: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2768: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2769: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2770: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2771: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2772: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;

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

2765: l_global_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2766: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2767: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2768: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2769: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2770: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2771: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2772: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2773: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;

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

2766: l_global_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2767: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2768: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2769: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2770: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2771: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2772: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2773: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2774: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;

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

2767: l_global_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2768: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2769: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2770: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2771: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2772: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2773: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2774: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2775: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;

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

2768: l_global_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2769: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2770: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2771: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2772: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2773: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2774: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2775: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2776: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;

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

2769: l_global_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2770: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2771: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2772: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2773: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2774: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2775: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2776: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2777: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;

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

2770: l_global_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2771: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2772: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2773: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2774: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2775: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2776: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2777: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2778: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;

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

2771: l_global_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2772: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2773: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2774: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2775: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2776: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2777: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2778: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2779: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;

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

2772: l_global_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2773: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2774: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2775: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2776: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2777: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2778: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2779: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2780: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;

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

2773: l_global_attribute16 hz_cust_accounts.attribute16%TYPE := NULL;
2774: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2775: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2776: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2777: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2778: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2779: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2780: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2781: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;

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

2774: l_global_attribute17 hz_cust_accounts.attribute17%TYPE := NULL;
2775: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2776: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2777: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2778: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2779: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2780: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2781: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2782: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;

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

2775: l_global_attribute18 hz_cust_accounts.attribute18%TYPE := NULL;
2776: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2777: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2778: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2779: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2780: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2781: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2782: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2783: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;

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

2776: l_global_attribute19 hz_cust_accounts.attribute19%TYPE := NULL;
2777: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2778: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2779: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2780: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2781: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2782: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2783: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2784: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;

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

2777: l_global_attribute20 hz_cust_accounts.attribute20%TYPE := NULL;
2778: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2779: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2780: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2781: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2782: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2783: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2784: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2785: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;

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

2778: l_jgzz_attribute_category hz_cust_accounts.global_attribute_category%TYPE := NULL;
2779: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2780: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2781: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2782: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2783: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2784: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2785: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2786: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;

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

2779: l_jgzz_attribute1 hz_cust_accounts.attribute1%TYPE := NULL;
2780: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2781: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2782: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2783: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2784: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2785: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2786: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2787: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;

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

2780: l_jgzz_attribute2 hz_cust_accounts.attribute2%TYPE := NULL;
2781: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2782: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2783: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2784: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2785: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2786: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2787: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2788: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;

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

2781: l_jgzz_attribute3 hz_cust_accounts.attribute3%TYPE := NULL;
2782: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2783: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2784: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2785: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2786: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2787: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2788: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2789: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;

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

2782: l_jgzz_attribute4 hz_cust_accounts.attribute4%TYPE := NULL;
2783: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2784: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2785: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2786: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2787: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2788: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2789: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2790: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;

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

2783: l_jgzz_attribute5 hz_cust_accounts.attribute5%TYPE := NULL;
2784: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2785: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2786: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2787: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2788: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2789: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2790: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2791: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;

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

2784: l_jgzz_attribute6 hz_cust_accounts.attribute6%TYPE := NULL;
2785: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2786: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2787: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2788: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2789: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2790: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2791: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2792: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;

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

2785: l_jgzz_attribute7 hz_cust_accounts.attribute7%TYPE := NULL;
2786: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2787: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2788: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2789: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2790: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2791: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2792: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2793: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;

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

2786: l_jgzz_attribute8 hz_cust_accounts.attribute8%TYPE := NULL;
2787: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2788: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2789: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2790: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2791: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2792: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2793: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2794: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;

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

2787: l_jgzz_attribute9 hz_cust_accounts.attribute9%TYPE := NULL;
2788: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2789: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2790: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2791: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2792: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2793: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2794: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2795: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active

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

2788: l_jgzz_attribute10 hz_cust_accounts.attribute10%TYPE := NULL;
2789: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2790: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2791: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2792: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2793: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2794: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2795: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2796: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal

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

2789: l_jgzz_attribute11 hz_cust_accounts.attribute11%TYPE := NULL;
2790: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2791: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2792: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2793: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2794: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2795: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2796: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2797: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;

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

2790: l_jgzz_attribute12 hz_cust_accounts.attribute12%TYPE := NULL;
2791: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2792: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2793: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2794: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2795: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2796: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2797: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2798: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;

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

2791: l_jgzz_attribute13 hz_cust_accounts.attribute13%TYPE := NULL;
2792: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2793: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2794: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2795: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2796: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2797: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2798: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2799: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;

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

2792: l_jgzz_attribute14 hz_cust_accounts.attribute14%TYPE := NULL;
2793: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2794: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2795: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2796: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2797: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2798: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2799: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2800: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;

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

2793: l_jgzz_attribute15 hz_cust_accounts.attribute15%TYPE := NULL;
2794: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2795: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2796: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2797: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2798: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2799: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2800: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2801: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;

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

2794: l_orig_system_reference hz_cust_accounts.orig_system_reference%TYPE := NULL;
2795: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2796: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2797: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2798: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2799: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2800: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2801: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2802: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;

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

2795: l_status hz_cust_accounts.status%TYPE := 'A'; -- Active
2796: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2797: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2798: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2799: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2800: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2801: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2802: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2803: l_reference_use_flag VARCHAR2(1) := 'N';

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

2796: l_customer_type hz_cust_accounts.customer_type%TYPE := 'I'; -- Internal
2797: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2798: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2799: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2800: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2801: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2802: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2803: l_reference_use_flag VARCHAR2(1) := 'N';
2804: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;

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

2797: l_customer_class_code hz_cust_accounts.customer_class_code%TYPE := NULL;
2798: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2799: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2800: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2801: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2802: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2803: l_reference_use_flag VARCHAR2(1) := 'N';
2804: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2805: l_third_party_flag VARCHAR2(1) := 'N';

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

2798: l_primary_salesrep_id hz_cust_accounts.primary_salesrep_id%TYPE := NULL;
2799: l_sales_channel_code hz_cust_accounts.sales_channel_code%TYPE := NULL;
2800: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2801: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2802: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2803: l_reference_use_flag VARCHAR2(1) := 'N';
2804: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2805: l_third_party_flag VARCHAR2(1) := 'N';
2806: l_competitor_flag VARCHAR2(1) := 'N';

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

2800: l_order_type_id hz_cust_accounts.order_type_id%TYPE := NULL;
2801: l_price_list_id hz_cust_accounts.price_list_id%TYPE := NULL;
2802: l_category_code hz_cust_accounts.subcategory_code%TYPE := NULL;
2803: l_reference_use_flag VARCHAR2(1) := 'N';
2804: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2805: l_third_party_flag VARCHAR2(1) := 'N';
2806: l_competitor_flag VARCHAR2(1) := 'N';
2807: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2808: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;

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

2803: l_reference_use_flag VARCHAR2(1) := 'N';
2804: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2805: l_third_party_flag VARCHAR2(1) := 'N';
2806: l_competitor_flag VARCHAR2(1) := 'N';
2807: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2808: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2809: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2810: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2811: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;

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

2804: l_tax_code hz_cust_accounts.tax_code%TYPE := NULL;
2805: l_third_party_flag VARCHAR2(1) := 'N';
2806: l_competitor_flag VARCHAR2(1) := 'N';
2807: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2808: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2809: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2810: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2811: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2812: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;

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

2805: l_third_party_flag VARCHAR2(1) := 'N';
2806: l_competitor_flag VARCHAR2(1) := 'N';
2807: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2808: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2809: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2810: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2811: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2812: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2813: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;

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

2806: l_competitor_flag VARCHAR2(1) := 'N';
2807: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2808: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2809: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2810: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2811: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2812: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2813: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2814: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;

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

2807: l_fob_point hz_cust_accounts.fob_point%TYPE := NULL;
2808: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2809: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2810: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2811: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2812: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2813: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2814: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2815: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;

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

2808: l_tax_header_level_flag hz_cust_accounts.tax_header_level_flag%TYPE := NULL;
2809: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2810: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2811: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2812: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2813: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2814: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2815: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2816: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;

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

2809: l_tax_rounding_rule hz_cust_accounts.tax_rounding_rule%TYPE := NULL;
2810: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2811: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2812: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2813: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2814: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2815: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2816: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2817: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;

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

2810: l_account_name hz_cust_accounts.account_name%TYPE := NULL;
2811: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2812: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2813: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2814: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2815: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2816: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2817: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2818: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;

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

2811: l_freight_term hz_cust_accounts.freight_term%TYPE := NULL;
2812: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2813: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2814: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2815: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2816: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2817: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2818: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2819: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;

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

2812: l_ship_partial hz_cust_accounts.ship_partial%TYPE := NULL;
2813: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2814: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2815: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2816: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2817: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2818: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2819: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2820: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;

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

2813: l_ship_via hz_cust_accounts.ship_via%TYPE := NULL;
2814: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2815: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2816: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2817: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2818: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2819: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2820: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2821: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;

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

2814: l_warehouse_id hz_cust_accounts.warehouse_id%TYPE := NULL;
2815: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2816: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2817: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2818: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2819: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2820: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2821: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2822: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;

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

2815: l_payment_term_id hz_cust_accounts.payment_term_id%TYPE := NULL;
2816: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2817: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2818: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2819: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2820: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2821: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2822: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2823: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;

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

2816: l_DATES_NEGATIVE_TOLERANCE hz_cust_accounts.DATES_NEGATIVE_TOLERANCE%TYPE := NULL;
2817: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2818: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2819: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2820: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2821: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2822: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2823: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2824: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';

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

2817: l_DATES_POSITIVE_TOLERANCE hz_cust_accounts.DATES_POSITIVE_TOLERANCE%TYPE := NULL;
2818: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2819: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2820: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2821: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2822: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2823: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2824: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2825: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';

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

2818: l_DATE_TYPE_PREFERENCE hz_cust_accounts.DATE_TYPE_PREFERENCE%TYPE := NULL;
2819: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2820: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2821: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2822: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2823: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2824: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2825: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2826: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';

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

2819: l_OVER_SHIPMENT_TOLERANCE hz_cust_accounts.OVER_SHIPMENT_TOLERANCE%TYPE := NULL;
2820: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2821: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2822: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2823: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2824: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2825: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2826: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2827: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;

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

2820: l_UNDER_SHIPMENT_TOLERANCE hz_cust_accounts.UNDER_SHIPMENT_TOLERANCE%TYPE := NULL;
2821: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2822: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2823: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2824: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2825: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2826: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2827: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2828: l_party_number hz_parties.party_number%TYPE := NULL;

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

2821: l_ITEM_CROSS_REF_PREF hz_cust_accounts.ITEM_CROSS_REF_PREF%TYPE := NULL;
2822: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2823: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2824: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2825: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2826: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2827: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2828: l_party_number hz_parties.party_number%TYPE := NULL;
2829: l_customer_key hz_parties.customer_key%TYPE := NULL;

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

2822: l_OVER_RETURN_TOLERANCE hz_cust_accounts.OVER_RETURN_TOLERANCE%TYPE := NULL;
2823: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2824: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2825: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2826: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2827: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2828: l_party_number hz_parties.party_number%TYPE := NULL;
2829: l_customer_key hz_parties.customer_key%TYPE := NULL;
2830: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;

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

2823: l_UNDER_RETURN_TOLERANCE hz_cust_accounts.UNDER_RETURN_TOLERANCE%TYPE := NULL;
2824: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2825: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2826: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2827: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2828: l_party_number hz_parties.party_number%TYPE := NULL;
2829: l_customer_key hz_parties.customer_key%TYPE := NULL;
2830: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2831: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;

Line 2977: t_party_id hz_cust_accounts.party_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;
2978: t_party_site_id hz_party_sites.party_site_id%TYPE;
2979: t_party_site_number hz_party_sites.party_site_number%TYPE;
2980: t_Bill_To_Flag hz_cust_acct_sites_all.Bill_To_Flag%TYPE;
2981: t_Ship_To_Flag hz_cust_acct_sites_all.Ship_To_Flag%TYPE;

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

3025: where resource_type = l_resource_type
3026: and resource_id = l_resource_id;
3027:
3028: CURSOR l_party_id_csr IS
3029: select party_id from hz_cust_accounts where cust_account_id = l_customer_id;
3030:
3031: CURSOR l_requirement_hdr_csr IS
3032: -- select ship_to_location_id from csp_requirement_headers where task_assignment_id = p_task_assignment_id;
3033: select ship_to_location_id,

Line 3054: select hz_cust_accounts_s.nextval from dual;

3050: CURSOR l_party_number_csr IS
3051: select hz_parties_s.nextval from dual;
3052:
3053: CURSOR l_customer_number_csr IS
3054: select hz_cust_accounts_s.nextval from dual;
3055:
3056: CURSOR l_party_site_number_csr IS
3057: select hz_party_sites_s.nextval from dual;
3058:

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

3365: csp_ship_to_address_pvt.g_rs_cust_relation_id := l_rs_cust_relation_id;
3366: IF l_customer_id_csr%FOUND and l_customer_id IS NOT NULL THEN
3367: CLOSE l_customer_id_csr;
3368:
3369: -- Use the customer_id to retrieve party_id from hz_cust_accounts
3370: OPEN l_party_id_csr;
3371: FETCH l_party_id_csr INTO l_party_id;
3372: IF l_party_id_csr%NOTFOUND THEN
3373: CLOSE l_party_id_csr;