APPS.HR_BIS_ALERTS dependencies on HR_GENERAL

Line 719: RETURN hr_general.decode_location(p_location_id);

715: BEGIN
716: IF p_location_id = -1 THEN
717: RETURN translate_all;
718: ELSE
719: RETURN hr_general.decode_location(p_location_id);
720: END IF;
721: END;
722:
723: -------------------------------------------------------------------------

Line 765: l_text := Hr_General.Decode_Lookup('YES_NO','N');

761: l_text hr_lookups.meaning%TYPE;
762:
763: BEGIN
764: IF p_orgprc = 'SINR' THEN
765: l_text := Hr_General.Decode_Lookup('YES_NO','N');
766: ELSIF p_orgprc = 'SINR' THEN
767: l_text := Hr_General.Decode_Lookup('YES_NO','Y');
768: ELSE
769: l_text := '';

Line 767: l_text := Hr_General.Decode_Lookup('YES_NO','Y');

763: BEGIN
764: IF p_orgprc = 'SINR' THEN
765: l_text := Hr_General.Decode_Lookup('YES_NO','N');
766: ELSIF p_orgprc = 'SINR' THEN
767: l_text := Hr_General.Decode_Lookup('YES_NO','Y');
768: ELSE
769: l_text := '';
770: END IF;
771: RETURN l_text;

Line 911: -- USER_ID can not be -1 because of condition in HR_GENERAL.Get_Business_Group

907:
908: -- NOTE:
909: -- Solution to issues in bug 1413300 (not inserting into actuals table)
910: -- USER_ID can not be NULL because of issues of inserting a value into a NOT NULL column
911: -- USER_ID can not be -1 because of condition in HR_GENERAL.Get_Business_Group
912: -- Using -2
913: hrFastAnswers.initialize
914: (-2
915: ,p_responsibility_id

Line 1188: AND nvl(date_to, hr_general.end_of_time)

1184: SELECT business_group_id
1185: FROM hr_all_organization_units
1186: WHERE sysdate
1187: BETWEEN date_from
1188: AND nvl(date_to, hr_general.end_of_time)
1189: AND organization_id = p_c_org_id;
1190:
1191: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
1192: