APPS.BIX_UWQ_TEMP_PKG dependencies on FND_PROFILE

Line 36: FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));

32: --below to convert the string to a date
33: --
34:
35: v_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'STARTDATE'),
36: FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'));
37:
38: --
39: --Due to a JTF bug, old pcontext is always being passed in.
40: --This will cause problems when running from listing pages.

Line 71: select fnd_profile.value('BIX_DM_DEFAULT_GROUP')

67: --Means it was not run from the bin
68: --
69: THEN
70: BEGIN
71: select fnd_profile.value('BIX_DM_DEFAULT_GROUP')
72: into v_default_group_id
73: from dual;
74:
75: EXCEPTION

Line 88: and res.user_id = fnd_profile.value('USER_ID')

84: select grp.group_id
85: into v_default_group_id
86: from jtf_rs_group_members grp, jtf_rs_resource_extns res
87: where res.resource_id = grp.resource_id
88: and res.user_id = fnd_profile.value('USER_ID')
89: and grp.last_update_date = (select max(grp2.last_update_date)
90: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2
91: where res2.resource_id = grp2.resource_id
92: and res2.user_id = fnd_profile.value('USER_ID')

Line 92: and res2.user_id = fnd_profile.value('USER_ID')

88: and res.user_id = fnd_profile.value('USER_ID')
89: and grp.last_update_date = (select max(grp2.last_update_date)
90: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2
91: where res2.resource_id = grp2.resource_id
92: and res2.user_id = fnd_profile.value('USER_ID')
93: );
94: EXCEPTION
95: WHEN OTHERS
96: THEN

Line 170: select fnd_profile.value('BIX_DM_DEFAULT_GROUP')

166: --
167:
168: BEGIN
169:
170: select fnd_profile.value('BIX_DM_DEFAULT_GROUP')
171: into v_default_group_id
172: from dual;
173:
174: EXCEPTION

Line 187: and res.user_id = fnd_profile.value('USER_ID')

183: select grp.group_id
184: into v_default_group_id
185: from jtf_rs_group_members grp, jtf_rs_resource_extns res
186: where res.resource_id = grp.resource_id
187: and res.user_id = fnd_profile.value('USER_ID')
188: and grp.last_update_date = (select max(grp2.last_update_date)
189: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2
190: where res.resource_id = grp.resource_id
191: and res.user_id = fnd_profile.value('USER_ID')

Line 191: and res.user_id = fnd_profile.value('USER_ID')

187: and res.user_id = fnd_profile.value('USER_ID')
188: and grp.last_update_date = (select max(grp2.last_update_date)
189: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2
190: where res.resource_id = grp.resource_id
191: and res.user_id = fnd_profile.value('USER_ID')
192: );
193: EXCEPTION
194: WHEN OTHERS
195: THEN