DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_COMMON dependencies on CAC_VIEW_COLLAB_DETAILS_TL

Line 277: l_location CAC_VIEW_COLLAB_DETAILS_TL.LOCATION%TYPE;

273: l_msg_count NUMBER;
274: l_msg_data VARCHAR2(2000);
275: p_updation_record jtf_task_repeat_appt_pvt.updated_field_rec;
276: l_ovn NUMBER;
277: l_location CAC_VIEW_COLLAB_DETAILS_TL.LOCATION%TYPE;
278: l_alarm_days NUMBER;
279: l_alarm_mins NUMBER;
280:
281: Begin

Line 3304: l_location CAC_VIEW_COLLAB_DETAILS_TL.LOCATION%type:=substrb(p_task_rec.locations,1,100);

3300: WHERE task_id=b_task_id;
3301: l_collab_details getCollabDetails%ROWTYPE;
3302:
3303: Dates VARCHAR2(4000);
3304: l_location CAC_VIEW_COLLAB_DETAILS_TL.LOCATION%type:=substrb(p_task_rec.locations,1,100);
3305:
3306:
3307: BEGIN
3308: fnd_msg_pub.initialize;

Line 4097: l_location CAC_VIEW_COLLAB_DETAILS_TL.LOCATION%type:=substrb(p_task_rec.locations,1,100);

4093: l_priorityId jtf_tasks_b.task_priority_id%type;
4094:
4095: repeat_to_nonrepeat BOOLEAN;
4096: nonrepeat_to_repeat BOOLEAN;
4097: l_location CAC_VIEW_COLLAB_DETAILS_TL.LOCATION%type:=substrb(p_task_rec.locations,1,100);
4098: l_free_busy_type VARCHAR2(25) := FND_API.G_MISS_CHAR;
4099:
4100: BEGIN
4101: fnd_msg_pub.initialize;

Line 5202: cac_view_collab_details_tl cactl,

5198: cursor getDialInValue(b_task_id number)
5199: is
5200: select cactl.dial_in
5201: from
5202: cac_view_collab_details_tl cactl,
5203: cac_view_collab_details cac
5204: where cac.collab_id=cactl.collab_id
5205: and cactl.LANGUAGE = userenv('LANG')
5206: and cac.task_id=b_task_id;