DBA Data[Home] [Help]

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