[Home] [Help]
1746: -- gdf_cust_prof_attr_cat
1747: -- gdf_cust_prof_attr1..20
1748: --
1749:
1750: CURSOR ra_customer_profiles_interface IS
1751: SELECT i.global_attribute_category,i.global_attribute1,
1752: i.global_attribute2,i.global_attribute3,i.global_attribute4,
1753: i.global_attribute5,i.global_attribute6,i.global_attribute7,
1754: i.global_attribute8,i.global_attribute9,i.global_attribute10,
1764: i.gdf_cust_prof_attribute14,i.gdf_cust_prof_attribute15,i.gdf_cust_prof_attribute16,
1765: i.gdf_cust_prof_attribute17,i.gdf_cust_prof_attribute18,i.gdf_cust_prof_attribute19,
1766: i.gdf_cust_prof_attribute20,
1767: i.rowid
1768: FROM ra_customer_profiles_interface i
1769: WHERE i.request_id = p_request_id
1770: AND nvl(i.validated_flag,'N') <> 'Y';
1771:
1772:
1925:
1926: OPEN generate_number;
1927: FETCH generate_number INTO l_cust_man_numbering;
1928: CLOSE generate_number;
1929: FOR idx_cur IN ra_customer_profiles_interface LOOP
1930: gdf_rec1.global_attribute_category := idx_cur.global_attribute_category;
1931: gdf_rec1.global_attribute1 := idx_cur.global_attribute1;
1932: gdf_rec1.global_attribute2 := idx_cur.global_attribute2;
1933: gdf_rec1.global_attribute3 := idx_cur.global_attribute3;
2206: ELSIF p_int_table_name = 'PROFILE' THEN
2207:
2208: -- Check for JG_HZ_CUSTOMER_PROFILES
2209: -- Since the existing global_attributes 1..20 in
2210: -- ra_customer_profiles_interface are used for profile amounts and
2211: -- gdf_cust_prof_attributes1..20 are used for customer_profiles,
2212: -- we are passing p_glob_attr_set2 argument for JG_HZ_CUSTOMER_PROFILES
2213: -- and p_glob_attr_set1 argument for JG_HZ_CUST_PROFILE_AMTS.
2214:
2236: -- Update STATUS column of the profile interface table
2237: --
2238: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(
2239: p_glob_attr_general.core_prod_arg2,
2240: 'RA_CUSTOMER_PROFILES_INTERFACE',
2241: l_errcode,
2242: 'E');
2243:
2244: END IF;