APPS.HR_BPL_ALERT_TRNSLT dependencies on DBMS_UTILITY

Line 476: DBMS_UTILITY.get_hash_value(p_lookup_code || ':' || p_lookup_type || ':' || p_person_id

472: RETURN (NULL);
473: END IF;
474: -- determine hash number for plsql table index.
475: g_hash_number :=
476: DBMS_UTILITY.get_hash_value(p_lookup_code || ':' || p_lookup_type || ':' || p_person_id
477: ,1
478: ,1048576);
479: g_language := hr_bpl_alert_recipient.get_psn_lng(p_person_id);
480: -- (2^20)

Line 723: DBMS_UTILITY.get_hash_value(p_lookup_code || ':' || p_lookup_type || ':' || p_assignment_id

719: RETURN (NULL);
720: END IF;
721: -- determine hash number for plsql table index.
722: g_hash_number :=
723: DBMS_UTILITY.get_hash_value(p_lookup_code || ':' || p_lookup_type || ':' || p_assignment_id
724: ,1
725: ,1048576);
726: g_language := hr_bpl_alert_recipient.get_asg_psn_lng(p_assignment_id);
727: -- (2^20)

Line 836: DBMS_UTILITY.get_hash_value(p_lookup_code || ':' || p_lookup_type || ':' || p_assignment_id

832: RETURN (NULL);
833: END IF;
834: -- determine hash number for plsql table index.
835: g_hash_number :=
836: DBMS_UTILITY.get_hash_value(p_lookup_code || ':' || p_lookup_type || ':' || p_assignment_id
837: ,1
838: ,1048576);
839: g_language := hr_bpl_alert_recipient.get_asg_sup_lng(p_assignment_id);
840: -- (2^20)

Line 1003: DBMS_UTILITY.get_hash_value(p_lookup_code || ':' || p_lookup_type || ':' || p_assignment_id

999: END IF;
1000: -- get the security group
1001: -- determine hash number for plsql table index.
1002: g_hash_number :=
1003: DBMS_UTILITY.get_hash_value(p_lookup_code || ':' || p_lookup_type || ':' || p_assignment_id
1004: ,1
1005: ,1048576);
1006: g_language := hr_bpl_alert_recipient.get_pasg_sup_lng(p_assignment_id);
1007: -- (2^20)