APPS.IEU_DIAGNOSTICS_PVT dependencies on FND_PROFILE

Line 764: if (fnd_profile.value(l_work_q_enable_profile_option) = 'N')then

760: WHEN NO_DATA_FOUND THEN
761: null;
762: END;
763:
764: if (fnd_profile.value(l_work_q_enable_profile_option) = 'N')then
765: l_valid := FALSE;
766: end if;
767:
768: if (l_valid = true)then

Line 1218: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b

1214: e.SEL_ENUM_ID enum_id
1215: FROM
1216: IEU_UWQ_SEL_ENUMERATORS e,
1217: fnd_lookup_values l
1218: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
1219: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
1220: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
1221: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
1222: AND l.language = l_language

Line 1221: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')

1217: fnd_lookup_values l
1218: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
1219: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
1220: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
1221: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
1222: AND l.language = l_language
1223: AND l.lookup_code = e.work_q_label_lu_code
1224: AND l.lookup_type = e.work_q_label_lu_type order by l.meaning;
1225:

Line 1710: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b

1706: e.work_q_label_lu_type,
1707: e.work_q_label_lu_code
1708: FROM
1709: IEU_UWQ_SEL_ENUMERATORS e
1710: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
1711: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
1712: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
1713: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
1714: AND (e.work_q_register_type <> 'W' or e.work_q_register_type is null)

Line 1713: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')

1709: IEU_UWQ_SEL_ENUMERATORS e
1710: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
1711: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
1712: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
1713: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
1714: AND (e.work_q_register_type <> 'W' or e.work_q_register_type is null)
1715: order by e.sel_enum_id;
1716:
1717:

Line 2067: X_NODE_WEIGHT => nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value('IEU_QOR_MEDIA')) , IEU_CONSTS_PUB.G_SNID_MEDIA),

2063: X_SEL_ENUM_ID => 0,
2064: X_NODE_ID => IEU_CONSTS_PUB.G_SNID_MEDIA,
2065: X_NODE_TYPE => 0,
2066: X_NODE_PID => 0,
2067: X_NODE_WEIGHT => nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value('IEU_QOR_MEDIA')) , IEU_CONSTS_PUB.G_SNID_MEDIA),
2068: X_NODE_DEPTH => 1,
2069: X_SEL_ENUM_PID => 0,
2070: X_MEDIA_TYPE_ID => NULL,
2071: X_COUNT => 0,

Line 2565: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b

2561: e.work_q_label_lu_type,
2562: e.work_q_label_lu_code
2563: FROM
2564: IEU_UWQ_SEL_ENUMERATORS e
2565: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
2566: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
2567: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
2568: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
2569: order by e.sel_enum_id;

Line 2568: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')

2564: IEU_UWQ_SEL_ENUMERATORS e
2565: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
2566: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
2567: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
2568: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
2569: order by e.sel_enum_id;
2570:
2571:
2572: cursor c_dproc (enum_id NUMBER, app_id NUMBER, l_type VARCHAR2, l_code VARCHAR2)is