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.HRI_APL_DGNSTC_WRKFC dependencies on FND_PROFILE

Line 17: l_rate_type_code := fnd_profile.value('BIS_PRIMARY_RATE_TYPE');

13:
14: BEGIN
15:
16: IF (p_parameter_value = 'PRIMARY') THEN
17: l_rate_type_code := fnd_profile.value('BIS_PRIMARY_RATE_TYPE');
18: l_currency_code := fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE');
19: ELSE
20: l_rate_type_code := fnd_profile.value('BIS_SECONDARY_RATE_TYPE');
21: l_currency_code := fnd_profile.value('BIS_SECONDARY_CURRENCY_CODE');

Line 18: l_currency_code := fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE');

14: BEGIN
15:
16: IF (p_parameter_value = 'PRIMARY') THEN
17: l_rate_type_code := fnd_profile.value('BIS_PRIMARY_RATE_TYPE');
18: l_currency_code := fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE');
19: ELSE
20: l_rate_type_code := fnd_profile.value('BIS_SECONDARY_RATE_TYPE');
21: l_currency_code := fnd_profile.value('BIS_SECONDARY_CURRENCY_CODE');
22: END IF;

Line 20: l_rate_type_code := fnd_profile.value('BIS_SECONDARY_RATE_TYPE');

16: IF (p_parameter_value = 'PRIMARY') THEN
17: l_rate_type_code := fnd_profile.value('BIS_PRIMARY_RATE_TYPE');
18: l_currency_code := fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE');
19: ELSE
20: l_rate_type_code := fnd_profile.value('BIS_SECONDARY_RATE_TYPE');
21: l_currency_code := fnd_profile.value('BIS_SECONDARY_CURRENCY_CODE');
22: END IF;
23:
24: l_sql_stmt :=

Line 21: l_currency_code := fnd_profile.value('BIS_SECONDARY_CURRENCY_CODE');

17: l_rate_type_code := fnd_profile.value('BIS_PRIMARY_RATE_TYPE');
18: l_currency_code := fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE');
19: ELSE
20: l_rate_type_code := fnd_profile.value('BIS_SECONDARY_RATE_TYPE');
21: l_currency_code := fnd_profile.value('BIS_SECONDARY_CURRENCY_CODE');
22: END IF;
23:
24: l_sql_stmt :=
25: 'SELECT -- Missing conversion rates

Line 251: l_wmv_type_code := fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');

247:
248: BEGIN
249:
250: -- Get the abv type
251: l_wmv_type_code := fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');
252:
253: -- Default to headcount
254: IF l_wmv_type_code IS NULL THEN
255: l_wmv_type_code := 'HEAD';

Line 804: l_abv_unit := fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');

800:
801: BEGIN
802:
803: -- Get the abv type
804: l_abv_unit := fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');
805:
806: -- Default to headcount
807: IF l_abv_unit IS NULL THEN
808: l_abv_unit := 'HEAD';

Line 862: l_abv_unit := fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');

858:
859: BEGIN
860:
861: -- Get the abv type
862: l_abv_unit := fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');
863:
864: -- Default to headcount
865: IF l_abv_unit IS NULL THEN
866: l_abv_unit := 'HEAD';

Line 1138: AND fnd_profile.value(''HRI_IMPL_DBI'') = ''Y''

1134: FROM bis_obj_properties
1135: WHERE object_name like ''HRI%''
1136: AND object_type = ''PAGE''
1137: AND implementation_flag = ''Y''
1138: AND fnd_profile.value(''HRI_IMPL_DBI'') = ''Y''
1139: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y''
1140: UNION ALL
1141: SELECT object_name
1142: FROM bis_obj_properties

Line 1139: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y''

1135: WHERE object_name like ''HRI%''
1136: AND object_type = ''PAGE''
1137: AND implementation_flag = ''Y''
1138: AND fnd_profile.value(''HRI_IMPL_DBI'') = ''Y''
1139: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y''
1140: UNION ALL
1141: SELECT object_name
1142: FROM bis_obj_properties
1143: WHERE object_name like ''HRI%SUBJECTAREA''

Line 1146: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y'')

1142: FROM bis_obj_properties
1143: WHERE object_name like ''HRI%SUBJECTAREA''
1144: AND object_type = ''REPORT''
1145: AND implementation_flag = ''Y''
1146: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y'')
1147: GROUP BY obj.request_set_name
1148: HAVING COUNT(*) < (SELECT COUNT(*)
1149: FROM bis_obj_properties
1150: WHERE implementation_flag = ''Y''

Line 1156: AND fnd_profile.value(''HRI_IMPL_DBI'') = ''Y''

1152: FROM bis_obj_properties
1153: WHERE object_name like ''HRI%''
1154: AND object_type = ''PAGE''
1155: AND implementation_flag = ''Y''
1156: AND fnd_profile.value(''HRI_IMPL_DBI'') = ''Y''
1157: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y''
1158: UNION ALL
1159: SELECT object_name
1160: FROM bis_obj_properties

Line 1157: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y''

1153: WHERE object_name like ''HRI%''
1154: AND object_type = ''PAGE''
1155: AND implementation_flag = ''Y''
1156: AND fnd_profile.value(''HRI_IMPL_DBI'') = ''Y''
1157: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y''
1158: UNION ALL
1159: SELECT object_name
1160: FROM bis_obj_properties
1161: WHERE object_name like ''HRI%SUBJECTAREA''

Line 1164: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y'')

1160: FROM bis_obj_properties
1161: WHERE object_name like ''HRI%SUBJECTAREA''
1162: AND object_type = ''REPORT''
1163: AND implementation_flag = ''Y''
1164: AND fnd_profile.value(''HRI_IMPL_OBIEE'')= ''Y'')
1165: )
1166: )'
1167:
1168: ;

Line 1193: AND DECODE(fnd_profile.value(''HRI_REC_USE_PUI_MGR_KEYS''),''Y'',vac.recruiter_id) IS NULL

1189: FROM per_all_vacancies vac,
1190: per_requisitions prq
1191: WHERE vac.requisition_id = prq.requisition_id
1192: AND vac.manager_id IS NULL
1193: AND DECODE(fnd_profile.value(''HRI_REC_USE_PUI_MGR_KEYS''),''Y'',vac.recruiter_id) IS NULL
1194: AND DECODE(fnd_profile.value(''HRI_REC_USE_PUI_MGR_KEYS''),''Y'',prq.person_id) IS NULL
1195: AND hri_bpl_ccmgr.get_ccmgr_id(vac.organization_id) = -1
1196: AND hri_bpl_ccmgr.get_ccmgr_id(vac.business_group_id) = -1
1197: AND vac.date_from >= :p_start_date

Line 1194: AND DECODE(fnd_profile.value(''HRI_REC_USE_PUI_MGR_KEYS''),''Y'',prq.person_id) IS NULL

1190: per_requisitions prq
1191: WHERE vac.requisition_id = prq.requisition_id
1192: AND vac.manager_id IS NULL
1193: AND DECODE(fnd_profile.value(''HRI_REC_USE_PUI_MGR_KEYS''),''Y'',vac.recruiter_id) IS NULL
1194: AND DECODE(fnd_profile.value(''HRI_REC_USE_PUI_MGR_KEYS''),''Y'',prq.person_id) IS NULL
1195: AND hri_bpl_ccmgr.get_ccmgr_id(vac.organization_id) = -1
1196: AND hri_bpl_ccmgr.get_ccmgr_id(vac.business_group_id) = -1
1197: AND vac.date_from >= :p_start_date
1198: AND NVL(vac.date_to, trunc(sysdate)) <= :p_end_date

Line 1309: AND FND_PROFILE.VALUE_SPECIFIC(''HRI_OBIEE_WRKFC_MGRH_TOP''

1305: AND TRUNC(SYSDATE) BETWEEN usr.start_date
1306: AND NVL(usr.end_date, hr_general.end_of_time)
1307: AND TRUNC(SYSDATE) BETWEEN resp.start_date
1308: AND NVL(resp.end_date, hr_general.end_of_time)
1309: AND FND_PROFILE.VALUE_SPECIFIC(''HRI_OBIEE_WRKFC_MGRH_TOP''
1310: ,usr.user_id,resp.responsibility_id
1311: ,resp.application_id) IS NULL' ;
1312:
1313: RETURN l_sql_stmt;

Line 1348: AND FND_PROFILE.VALUE_SPECIFIC(''HRI_OBI_ALL_ORGH_TOP''

1344: AND TRUNC(SYSDATE) BETWEEN usr.start_date
1345: AND NVL(usr.end_date, hr_general.end_of_time)
1346: AND TRUNC(SYSDATE) BETWEEN resp.start_date
1347: AND NVL(resp.end_date, hr_general.end_of_time)
1348: AND FND_PROFILE.VALUE_SPECIFIC(''HRI_OBI_ALL_ORGH_TOP''
1349: ,usr.user_id,resp.responsibility_id
1350: , resp.application_id) IS NULL' ;
1351:
1352: RETURN l_sql_stmt;

Line 1388: AND FND_PROFILE.VALUE_SPECIFIC(''HRI_OBIEE_WRKFC_ORGH_TOP''

1384: AND TRUNC(SYSDATE) BETWEEN usr.start_date
1385: AND NVL(usr.end_date, hr_general.end_of_time)
1386: AND TRUNC(SYSDATE) BETWEEN resp.start_date
1387: AND NVL(resp.end_date, hr_general.end_of_time)
1388: AND FND_PROFILE.VALUE_SPECIFIC(''HRI_OBIEE_WRKFC_ORGH_TOP''
1389: ,usr.user_id,resp.responsibility_id
1390: ,resp.application_id) IS NULL';
1391:
1392: RETURN l_sql_stmt;