[Home] [Help]
1639: -- gdf_cust_prof_attr_cat
1640: -- gdf_cust_prof_attr1..20
1641: --
1642:
1643: CURSOR ra_customer_profiles_interface IS
1644: SELECT i.global_attribute_category,i.global_attribute1,
1645: i.global_attribute2,i.global_attribute3,i.global_attribute4,
1646: i.global_attribute5,i.global_attribute6,i.global_attribute7,
1647: i.global_attribute8,i.global_attribute9,i.global_attribute10,
1657: i.gdf_cust_prof_attribute14,i.gdf_cust_prof_attribute15,i.gdf_cust_prof_attribute16,
1658: i.gdf_cust_prof_attribute17,i.gdf_cust_prof_attribute18,i.gdf_cust_prof_attribute19,
1659: i.gdf_cust_prof_attribute20,
1660: i.rowid
1661: FROM ra_customer_profiles_interface i
1662: WHERE i.request_id = p_request_id
1663: AND nvl(i.validated_flag,'N') <> 'Y';
1664:
1665:
1818:
1819: OPEN generate_number;
1820: FETCH generate_number INTO l_cust_man_numbering;
1821: CLOSE generate_number;
1822: FOR idx_cur IN ra_customer_profiles_interface LOOP
1823: gdf_rec1.global_attribute_category := idx_cur.global_attribute_category;
1824: gdf_rec1.global_attribute1 := idx_cur.global_attribute1;
1825: gdf_rec1.global_attribute2 := idx_cur.global_attribute2;
1826: gdf_rec1.global_attribute3 := idx_cur.global_attribute3;
2099: ELSIF p_int_table_name = 'PROFILE' THEN
2100:
2101: -- Check for JG_HZ_CUSTOMER_PROFILES
2102: -- Since the existing global_attributes 1..20 in
2103: -- ra_customer_profiles_interface are used for profile amounts and
2104: -- gdf_cust_prof_attributes1..20 are used for customer_profiles,
2105: -- we are passing p_glob_attr_set2 argument for JG_HZ_CUSTOMER_PROFILES
2106: -- and p_glob_attr_set1 argument for JG_HZ_CUST_PROFILE_AMTS.
2107:
2129: -- Update STATUS column of the profile interface table
2130: --
2131: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(
2132: p_glob_attr_general.core_prod_arg2,
2133: 'RA_CUSTOMER_PROFILES_INTERFACE',
2134: l_errcode,
2135: 'E');
2136:
2137: END IF;