eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_BPL_ALERT_TRNSLT dependencies on HR_BPL_ALERT_RECIPIENT

Line 479: g_language := hr_bpl_alert_recipient.get_psn_lng(p_person_id);

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)
481: BEGIN
482: -- check if we have a hash number generated that is for a different
483: -- lookup_type and lookup_code combination

Line 542: Cache_location_details(hr_bpl_alert_recipient.Get_psn_lng(p_person_id)

538: RETURN VARCHAR2 IS
539: --
540: BEGIN
541: --
542: Cache_location_details(hr_bpl_alert_recipient.Get_psn_lng(p_person_id)
543: ,p_location_id);
544: --
545: RETURN g_location_code;
546: --

Line 559: Cache_organization_details(hr_bpl_alert_recipient.Get_psn_lng(p_person_id)

555: RETURN VARCHAR2 IS
556: --
557: BEGIN
558: --
559: Cache_organization_details(hr_bpl_alert_recipient.Get_psn_lng(p_person_id)
560: ,p_organization_id);
561: --
562: RETURN g_organization_name;
563: --

Line 577: Cache_location_details(hr_bpl_alert_recipient.Get_psn_sup_psn_lng(

573: RETURN VARCHAR2 IS
574: --
575: BEGIN
576: --
577: Cache_location_details(hr_bpl_alert_recipient.Get_psn_sup_psn_lng(
578: p_person_id)
579: ,p_location_id);
580:
581: --

Line 597: Cache_organization_details(hr_bpl_alert_recipient.Get_psn_sup_psn_lng(

593: RETURN VARCHAR2 IS
594: --
595: BEGIN
596: --
597: Cache_organization_details(hr_bpl_alert_recipient.Get_psn_sup_psn_lng(
598: p_person_id)
599: ,p_organization_id);
600:
601: --

Line 726: g_language := hr_bpl_alert_recipient.get_asg_psn_lng(p_assignment_id);

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)
728: BEGIN
729: -- check if we have a hash number generated that is for a different
730: -- lookup_type and lookup_code combination

Line 788: Cache_location_details(hr_bpl_alert_recipient.Get_asg_psn_lng(

784: RETURN VARCHAR2 IS
785: --
786: BEGIN
787: --
788: Cache_location_details(hr_bpl_alert_recipient.Get_asg_psn_lng(
789: p_assignment_id)
790: ,p_location_id);
791: --
792: RETURN g_location_code;

Line 807: Cache_organization_details(hr_bpl_alert_recipient.Get_asg_psn_lng(

803: RETURN VARCHAR2 IS
804: --
805: BEGIN
806: --
807: Cache_organization_details(hr_bpl_alert_recipient.Get_asg_psn_lng(
808: p_assignment_id)
809: ,p_organization_id);
810: --
811: RETURN g_organization_name;

Line 839: g_language := hr_bpl_alert_recipient.get_asg_sup_lng(p_assignment_id);

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)
841: BEGIN
842: -- check if we have a hash number generated that is for a different
843: -- lookup_type and lookup_code combination

Line 902: Cache_location_details(hr_bpl_alert_recipient.Get_asg_sup_lng(

898: RETURN VARCHAR2 IS
899: --
900: BEGIN
901: --
902: Cache_location_details(hr_bpl_alert_recipient.Get_asg_sup_lng(
903: p_assignment_id)
904: ,p_location_id);
905:
906: --

Line 922: Cache_organization_details(hr_bpl_alert_recipient.Get_asg_sup_lng(

918: RETURN VARCHAR2 IS
919: --
920: BEGIN
921: --
922: Cache_organization_details(hr_bpl_alert_recipient.Get_asg_sup_lng(
923: p_assignment_id)
924: ,p_organization_id);
925:
926: --

Line 1006: g_language := hr_bpl_alert_recipient.get_pasg_sup_lng(p_assignment_id);

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)
1008: BEGIN
1009: -- check if we have a hash number generated that is for a different
1010: -- lookup_type and lookup_code combination

Line 1069: Cache_location_details(hr_bpl_alert_recipient.Get_pasg_sup_lng(

1065: RETURN VARCHAR2 IS
1066: --
1067: BEGIN
1068: --
1069: Cache_location_details(hr_bpl_alert_recipient.Get_pasg_sup_lng(
1070: p_assignment_id)
1071: ,p_location_id);
1072:
1073: --

Line 1089: Cache_organization_details(hr_bpl_alert_recipient.Get_pasg_sup_lng(

1085: RETURN VARCHAR2 IS
1086: --
1087: BEGIN
1088: --
1089: Cache_organization_details(hr_bpl_alert_recipient.Get_pasg_sup_lng(
1090: p_assignment_id)
1091: ,p_organization_id);
1092:
1093: --