DBA Data[Home] [Help]

APPS.IEU_PVT dependencies on FND_PROFILE

Line 79: FND_PROFILE.GET( 'IEU_BLENDING_STYLE', l_wb_style );

75: -- 'O' - Optional Blended
76: -- 'F' - Force Blended
77:
78: BEGIN
79: FND_PROFILE.GET( 'IEU_BLENDING_STYLE', l_wb_style );
80: EXCEPTION
81: WHEN OTHERS THEN
82: l_wb_style := 'N';
83: END;

Line 159: IF (FND_PROFILE.VALUE('IEU_MDEN_TELEPHONY') = 'Y')

155:
156: END IF;
157:
158: /*
159: IF (FND_PROFILE.VALUE('IEU_MDEN_TELEPHONY') = 'Y')
160: THEN
161: --
162: -- assume that the plugin for INBOUND or OUTBOUND will do...
163: -- picking by who's been around the longest...

Line 199: IF (FND_PROFILE.VALUE('IEU_MDEN_EMAIL') = 'Y')

195:
196: END IF;
197:
198:
199: IF (FND_PROFILE.VALUE('IEU_MDEN_EMAIL') = 'Y')
200: THEN
201:
202: --
203: -- assume that the plugin for one of the email enablers will do...

Line 481: FND_PROFILE_OPTIONS

477: PROFILE_OPTION_ID
478: INTO
479: l_profile_id
480: FROM
481: FND_PROFILE_OPTIONS
482: WHERE
483: PROFILE_OPTION_NAME = L_WORK_Q_ENABLE_PROFILE_OPTION;
484: EXCEPTION
485: WHEN NO_DATA_FOUND THEN

Line 491: IF (FND_PROFILE.VALUE(L_WORK_Q_ENABLE_PROFILE_OPTION) = 'N'

487: l_valid := FALSE;
488: END;
489:
490: -- Assume a profile value of Y or NULL is valid!
491: IF (FND_PROFILE.VALUE(L_WORK_Q_ENABLE_PROFILE_OPTION) = 'N'
492: AND l_doCheck = TRUE)
493: THEN
494: l_valid := FALSE;
495: END IF;

Line 697: nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value(e.work_q_order_profile_option)), e.work_q_order_system_default) display_order,

693: CURSOR c_enum IS
694: SELECT
695: e.SEL_ENUM_ID sel_enum_id,
696: e.ENUM_PROC enum_proc,
697: nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value(e.work_q_order_profile_option)), e.work_q_order_system_default) display_order,
698: e.work_q_register_type,
699: e.media_type_id
700: FROM
701: IEU_UWQ_SEL_ENUMERATORS e

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

698: e.work_q_register_type,
699: e.media_type_id
700: FROM
701: IEU_UWQ_SEL_ENUMERATORS e
702: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
703: where b.PROFILE_OPTION_NAME = upper(e.work_q_enable_profile_option)
704: and (b.end_date_active is null -- Niraj, bug 4738501, Added
705: or trunc(b.end_date_active) > trunc(sysdate))) -- Niraj, Bug 5031721, Added
706: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND

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

703: where b.PROFILE_OPTION_NAME = upper(e.work_q_enable_profile_option)
704: and (b.end_date_active is null -- Niraj, bug 4738501, Added
705: or trunc(b.end_date_active) > trunc(sysdate))) -- Niraj, Bug 5031721, Added
706: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
707: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
708: ORDER BY
709: display_order;
710:
711: BEGIN

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

870: X_SEL_ENUM_ID => 0,
871: X_NODE_ID => IEU_CONSTS_PUB.G_SNID_MEDIA,
872: X_NODE_TYPE => 0,
873: X_NODE_PID => 0,
874: X_NODE_WEIGHT => nvl(IEU_UWQ_UTIL_PUB.to_number_noerr(fnd_profile.value('IEU_QOR_MEDIA')) , IEU_CONSTS_PUB.G_SNID_MEDIA),
875: X_NODE_DEPTH => 1,
876: X_SEL_ENUM_PID => 0,
877: X_MEDIA_TYPE_ID => NULL,
878: X_COUNT => 0,

Line 1779: FND_PROFILE.GET( 'IEU_CLI_NET_USE_PROXY', X_USE_PROXY );

1775: -- Note: l_server_id was collected above so we can use it to get
1776: -- variables that may be associated with the server.
1777: --
1778:
1779: FND_PROFILE.GET( 'IEU_CLI_NET_USE_PROXY', X_USE_PROXY );
1780: IF (X_USE_PROXY <> 'Y')
1781: THEN
1782: X_USE_PROXY := '';
1783: END IF;

Line 2529: fnd_profile.value(e.work_q_order_profile_option) ) ,

2525: -- display order as well. (Ray Cardillo / 12-21-2000)
2526: select
2527: nvl (
2528: IEU_UWQ_UTIL_PUB.to_number_noerr (
2529: fnd_profile.value(e.work_q_order_profile_option) ) ,
2530: e.work_q_order_system_default
2531: )
2532: into
2533: l_node_weight