DBA Data[Home] [Help]

APPS.HRFASTANSWERS dependencies on HR_BIS

Line 89: -- using the profile option "HR:BIS Reporting Hierarchy"

85: --
86: ---------------------------------------------------------------------------
87: -- Private function to get the ID of the BIS Organization Hierarchy to
88: -- to be used in reporting. This can be set by the System Administrator
89: -- using the profile option "HR:BIS Reporting Hierarchy"
90: --
91: -- 17-Jun-1999 (BG)
92: -- Altered to check for existence of Profile Option first. If not found
93: -- or Profile not set, we fetch the Organization Structure ID from the

Line 155: l_bus_id := hr_bis.get_sec_profile_bg_id;

151:
152: begin
153:
154: -- bug 2968520;
155: l_bus_id := hr_bis.get_sec_profile_bg_id;
156:
157: /************************************************************************
158: 1. Get org hierarchy from BIS Reporting Hierarchy profile option
159: (for customers who have upgraded from BIS 1.2 to BIS 11i)

Line 162: if (FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') is not null) then

158: 1. Get org hierarchy from BIS Reporting Hierarchy profile option
159: (for customers who have upgraded from BIS 1.2 to BIS 11i)
160: ************************************************************************/
161:
162: if (FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') is not null) then
163:
164: l_str_id := to_number( FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') );
165:
166: -- Check to see if Structure still exists

Line 164: l_str_id := to_number( FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') );

160: ************************************************************************/
161:
162: if (FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') is not null) then
163:
164: l_str_id := to_number( FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') );
165:
166: -- Check to see if Structure still exists
167: if (l_str_id is not null) then
168:

Line 830: l_leaving_reason_meaning := fnd_message.get_string('HRI','HR_BIS_UNKNOWN');

826: , p_leaving_reason => l_leaving_reason
827: , p_service_band => l_service_band );
828: --
829: if (l_leaving_reason is null) then
830: l_leaving_reason_meaning := fnd_message.get_string('HRI','HR_BIS_UNKNOWN');
831: elsif
832: (l_leaving_reason = 'NOTSEPARATED') then
833: --
834: l_leaving_reason_meaning := 'NotSeparated';

Line 876: l_service_band := fnd_message.get_string('HRI','HR_BIS_LESS_THAN_1_YEAR');

872:
873: l_service_band := substr(l_service_band,1,1);
874: --
875: if(l_service_band = '<') then
876: l_service_band := fnd_message.get_string('HRI','HR_BIS_LESS_THAN_1_YEAR');
877: elsif(l_service_band = '1') then
878: l_service_band := fnd_message.get_string('HRI','HR_BIS_1_TO_3_YEARS');
879: elsif(l_service_band = '3') then
880: l_service_band := fnd_message.get_string('HRI','HR_BIS_3_TO_5_YEARS');

Line 878: l_service_band := fnd_message.get_string('HRI','HR_BIS_1_TO_3_YEARS');

874: --
875: if(l_service_band = '<') then
876: l_service_band := fnd_message.get_string('HRI','HR_BIS_LESS_THAN_1_YEAR');
877: elsif(l_service_band = '1') then
878: l_service_band := fnd_message.get_string('HRI','HR_BIS_1_TO_3_YEARS');
879: elsif(l_service_band = '3') then
880: l_service_band := fnd_message.get_string('HRI','HR_BIS_3_TO_5_YEARS');
881: elsif(l_service_band = '5') then
882: l_service_band := fnd_message.get_string('HRI','HR_BIS_5_YEARS+');

Line 880: l_service_band := fnd_message.get_string('HRI','HR_BIS_3_TO_5_YEARS');

876: l_service_band := fnd_message.get_string('HRI','HR_BIS_LESS_THAN_1_YEAR');
877: elsif(l_service_band = '1') then
878: l_service_band := fnd_message.get_string('HRI','HR_BIS_1_TO_3_YEARS');
879: elsif(l_service_band = '3') then
880: l_service_band := fnd_message.get_string('HRI','HR_BIS_3_TO_5_YEARS');
881: elsif(l_service_band = '5') then
882: l_service_band := fnd_message.get_string('HRI','HR_BIS_5_YEARS+');
883: end if;
884: --

Line 882: l_service_band := fnd_message.get_string('HRI','HR_BIS_5_YEARS+');

878: l_service_band := fnd_message.get_string('HRI','HR_BIS_1_TO_3_YEARS');
879: elsif(l_service_band = '3') then
880: l_service_band := fnd_message.get_string('HRI','HR_BIS_3_TO_5_YEARS');
881: elsif(l_service_band = '5') then
882: l_service_band := fnd_message.get_string('HRI','HR_BIS_5_YEARS+');
883: end if;
884: --
885: RETURN (l_service_band);
886: --

Line 1153: l_business_group_id Number := hr_bis.get_sec_profile_bg_id ;

1149: from per_org_structure_elements ose2
1150: where ose2.org_structure_version_id = osv.org_structure_version_id
1151: and ose.organization_id_parent = ose2.organization_id_child );
1152:
1153: l_business_group_id Number := hr_bis.get_sec_profile_bg_id ;
1154: l_org_structure_id Number := GetReportingHierarchy;
1155: l_org_structure_element_id Number;
1156:
1157: BEGIN

Line 1199: l_business_group_id Number := hr_bis.get_sec_profile_bg_id ;

1195: and ost.organization_structure_id = cp_str_id
1196: and ost.organization_structure_id = osv.organization_structure_id
1197: and trunc(sysdate) between nvl(osv.date_from,trunc(sysdate)) and nvl(osv.date_to,sysdate);
1198:
1199: l_business_group_id Number := hr_bis.get_sec_profile_bg_id ;
1200: l_org_structure_id Number := GetReportingHierarchy;
1201: l_org_structure_version_id Number;
1202:
1203: BEGIN

Line 1261: l_business_group_id := hr_bis.get_sec_profile_bg_id;

1257: , resp_appl_id => p_resp_appl_id
1258: , security_group_id => p_sec_group_id );
1259:
1260: -- bug 2968520
1261: l_business_group_id := hr_bis.get_sec_profile_bg_id;
1262:
1263: if (l_business_group_id is not null)
1264: then
1265: l_org_structure_id := GetReportingHierarchy;

Line 2042: Fnd_Message.Set_Name('HRI', 'HR_BIS_FF_NOT_EXIST');

2038: PROCEDURE Raise_FF_Not_Exist
2039: ( p_bgttyp in VarChar2 )
2040: IS
2041: BEGIN
2042: Fnd_Message.Set_Name('HRI', 'HR_BIS_FF_NOT_EXIST');
2043:
2044: -- Removed tokens in version 115.15
2045: -- Fnd_Message.Set_Token('BUDGET_FORMULA', 'BUDGET_'||p_bgttyp, FALSE);
2046: -- Fnd_Message.Set_Token('TEMPLATE_FORMULA', 'TEMPLATE_'||p_bgttyp, FALSE);

Line 2067: Fnd_Message.Set_Name('HRI', 'HR_BIS_FF_NOT_COMPILED');

2063: open fast_formula_csr;
2064: fetch fast_formula_csr into l_formula_name;
2065: close fast_formula_csr;
2066:
2067: Fnd_Message.Set_Name('HRI', 'HR_BIS_FF_NOT_COMPILED');
2068: Fnd_Message.Set_Token('FORMULA', l_formula_name, FALSE);
2069:
2070: raise ff_not_compiled;
2071: END Raise_FF_Not_Compiled;