APPS.ZX_PARTY_MERGE_PKG dependencies on DBMS_UTILITY
Line 727: l_hash_key := DBMS_UTILITY.get_hash_value(REC.REGISTRATION_TYPE_CODE||REC.REGISTRATION_NUMBER||REC.ROUNDING_RULE_CODE||REC.SELF_ASSESS_FLAG||REC.INCLUSIVE_TAX_FLAG,1,TABLE_SIZE);
723:
724: FOR REC in Registration_Attributes(p_ptp_id_to)
725: LOOP
726: 727: l_hash_key := DBMS_UTILITY.get_hash_value(REC.REGISTRATION_TYPE_CODE||REC.REGISTRATION_NUMBER||REC.ROUNDING_RULE_CODE||REC.SELF_ASSESS_FLAG||REC.INCLUSIVE_TAX_FLAG,1,TABLE_SIZE); 728:
729: l_reg_attr_tbl_to(l_hash_key) := REC;
730: END LOOP;
731:
Line 735: l_hash_key := DBMS_UTILITY.get_hash_value(REC.REGISTRATION_TYPE_CODE||REC.REGISTRATION_NUMBER||REC.ROUNDING_RULE_CODE||REC.SELF_ASSESS_FLAG||REC.INCLUSIVE_TAX_FLAG,1,TABLE_SIZE);
731:
732: FOR REC in Registration_Attributes(p_ptp_id_from)
733: LOOP
734: 735: l_hash_key := DBMS_UTILITY.get_hash_value(REC.REGISTRATION_TYPE_CODE||REC.REGISTRATION_NUMBER||REC.ROUNDING_RULE_CODE||REC.SELF_ASSESS_FLAG||REC.INCLUSIVE_TAX_FLAG,1,TABLE_SIZE); 736:
737: if(l_reg_attr_tbl_to.exists(l_hash_key)) THEN
738: x_merge_yn := 'Y';
739: ELSE