DBA Data[Home] [Help]

APPS.JTF_TASK_UTL_EXT dependencies on FND_PROFILE

Line 28: where base_uom_flag = 'Y' and uom_class = fnd_profile.value('JTF_TIME_UOM_CLASS');

24: end if;
25:
26: -- Get default inventory code, which is always hours
27: select uom_code into l_base_uom_code from mtl_units_of_measure
28: where base_uom_flag = 'Y' and uom_class = fnd_profile.value('JTF_TIME_UOM_CLASS');
29: -- Get the adjustment time
30:
31: if (p_adjustment_time_uom = l_base_uom_code)
32: then

Line 227: --select decode(fnd_profile.value('JTF_TASK_DEFAULT_DATE_SELECTED'),

223: is
224:
225: -- Fix for bug 2932012
226: --cursor c_date_selected is
227: --select decode(fnd_profile.value('JTF_TASK_DEFAULT_DATE_SELECTED'),
228: -- 'PLANNED', 'P',
229: -- 'SCHEDULED', 'S',
230: -- 'ACTUAL', 'A',
231: -- 'S')

Line 238: l_date_profile varchar2(30) := fnd_profile.value('JTF_TASK_DEFAULT_DATE_SELECTED');

234: l_date_selected varchar2(1);
235: l_cal_start_date date;
236: l_cal_end_date date;
237: l_show_2day varchar2(1);
238: l_date_profile varchar2(30) := fnd_profile.value('JTF_TASK_DEFAULT_DATE_SELECTED');
239:
240: begin
241: x_return_status := fnd_api.g_ret_sts_success;
242:

Line 400: l_date_profile varchar2(30) := fnd_profile.value('JTF_TASK_DEFAULT_DATE_SELECTED');

396:
397: rec_status c_status%ROWTYPE;
398:
399: -- Added by SBARAT on 21/12/2005 for bug# 4616119
400: l_date_profile varchar2(30) := fnd_profile.value('JTF_TASK_DEFAULT_DATE_SELECTED');
401:
402: BEGIN
403: x_return_status := fnd_api.g_ret_sts_success;
404: