eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_SYNC_TASK_COMMON dependencies on CAC_VIEW_COLLAB_DETAILS

Line 267: FROM CAC_VIEW_COLLAB_DETAILS_VL

263: is
264: CURSOR getCollabDetails(b_task_id NUMBER) IS
265: SELECT COLLAB_ID, MEETING_MODE,MEETING_ID,MEETING_URL,JOIN_URL ,
266: PLAYBACK_URL ,DOWNLOAD_URL ,CHAT_URL ,IS_STANDALONE_LOCATION,DIAL_IN
267: FROM CAC_VIEW_COLLAB_DETAILS_VL
268: WHERE task_id=b_task_id;
269:
270: l_collab_details getCollabDetails%ROWTYPE;
271:

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 381: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table

377: OPEN getCollabDetails(p_updation_record.task_id);
378:
379: FETCH getCollabDetails INTO l_collab_details;
380:
381: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table
382: --otherwise close the cursor.
383: IF (getCollabDetails%FOUND) THEN
384:
385: l_location := SUBSTRB(p_exclusion.locations,1,100);

Line 387: cac_view_collab_details_pkg.update_row

383: IF (getCollabDetails%FOUND) THEN
384:
385: l_location := SUBSTRB(p_exclusion.locations,1,100);
386:
387: cac_view_collab_details_pkg.update_row
388: (x_collab_id=> l_collab_details.collab_id ,
389: x_task_id=> p_updation_record.task_id,
390: x_meeting_mode=>l_collab_details.meeting_mode,
391: x_meeting_id=>l_collab_details.meeting_id,

Line 3212: SELECT cac_view_collab_details_s.nextval INTO l_key FROM DUAL;

3208: RETURN NUMBER
3209: IS
3210: l_key NUMBER;
3211: BEGIN
3212: SELECT cac_view_collab_details_s.nextval INTO l_key FROM DUAL;
3213: RETURN l_key;
3214: END get_collab_id;
3215:
3216:

Line 3299: FROM CAC_VIEW_COLLAB_DETAILS_VL

3295:
3296: CURSOR getCollabDetails(b_task_id NUMBER) IS
3297: SELECT COLLAB_ID, MEETING_MODE,MEETING_ID,MEETING_URL,JOIN_URL ,
3298: PLAYBACK_URL ,DOWNLOAD_URL ,CHAT_URL ,IS_STANDALONE_LOCATION,DIAL_IN
3299: FROM CAC_VIEW_COLLAB_DETAILS_VL
3300: WHERE task_id=b_task_id;
3301: l_collab_details getCollabDetails%ROWTYPE;
3302:
3303: Dates VARCHAR2(4000);

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 3372: cac_view_collab_details_pkg.insert_row (

3368: x_return_status => l_return_status,
3369: x_task_id => l_task_id
3370: );
3371:
3372: cac_view_collab_details_pkg.insert_row (
3373: x_rowid => l_rowid,
3374: x_collab_id => get_collab_id,
3375: x_task_id => l_task_id,
3376: x_meeting_mode => 'LIVE',

Line 3470: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table

3466: OPEN getCollabDetails(l_task_id);
3467:
3468: FETCH getCollabDetails INTO l_collab_details;
3469:
3470: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table
3471: --otherwise close the cursor.
3472: IF (getCollabDetails%FOUND) THEN
3473:
3474: l_location := SUBSTRB(p_task_rec.locations,1,100);

Line 3476: cac_view_collab_details_pkg.update_row

3472: IF (getCollabDetails%FOUND) THEN
3473:
3474: l_location := SUBSTRB(p_task_rec.locations,1,100);
3475:
3476: cac_view_collab_details_pkg.update_row
3477: (x_collab_id=> l_collab_details.collab_id ,
3478: x_task_id=> l_task_id,
3479: x_meeting_mode=>l_collab_details.meeting_mode,
3480: x_meeting_id=>l_collab_details.meeting_id,

Line 3535: cac_view_collab_details_pkg.insert_row (

3531: x_return_status => l_return_status,
3532: x_task_id => l_task_id
3533: );
3534:
3535: cac_view_collab_details_pkg.insert_row (
3536: x_rowid => l_rowid,
3537: x_collab_id => get_collab_id,
3538: x_task_id => l_task_id,
3539: x_meeting_mode => 'LIVE',

Line 4079: from cac_view_collab_details_vl cac, jtf_tasks_b jtb1,jtf_tasks_b jtb2

4075: cursor getTaskForRecurRule(b_task_id number) is
4076: select CAC.COLLAB_ID, CAC.MEETING_MODE,CAC.MEETING_ID,CAC.MEETING_URL,
4077: CAC.JOIN_URL ,CAC.PLAYBACK_URL ,CAC.DOWNLOAD_URL ,CAC.CHAT_URL ,
4078: CAC.IS_STANDALONE_LOCATION,CAC.DIAL_IN, jtb1.task_id
4079: from cac_view_collab_details_vl cac, jtf_tasks_b jtb1,jtf_tasks_b jtb2
4080: where cac.task_id=jtb1.task_id
4081: and jtb1.recurrence_rule_id=jtb2.recurrence_rule_id
4082: and jtb2.task_id=b_task_id;
4083:

Line 4090: from CAC_VIEW_COLLAB_DETAILS_VL

4086:
4087: cursor getCollabDetails(b_task_id NUMBER) is
4088: select COLLAB_ID, MEETING_MODE,MEETING_ID,MEETING_URL,JOIN_URL ,
4089: PLAYBACK_URL ,DOWNLOAD_URL ,CHAT_URL ,IS_STANDALONE_LOCATION,DIAL_IN
4090: from CAC_VIEW_COLLAB_DETAILS_VL
4091: where task_id=b_task_id;
4092: l_collab_details getCollabDetails%rowtype;
4093: l_priorityId jtf_tasks_b.task_priority_id%type;
4094:

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 4308: cac_view_collab_details_pkg.update_row

4304: exit when getTaskForRecurRule%NOTFOUND;
4305:
4306: --update collab details
4307:
4308: cac_view_collab_details_pkg.update_row
4309: (x_collab_id=> p_getTaskForRecurRule.collab_id ,
4310: x_task_id=> p_getTaskForRecurRule.task_id,
4311: x_meeting_mode=>p_getTaskForRecurRule.meeting_mode,
4312: x_meeting_id=>p_getTaskForRecurRule.meeting_id,

Line 4404: --getting the Details from table CAC_VIEW_COLLAB_DETAILS for a given non -repeating task

4400:
4401:
4402: if (l_rec_rule_id is null) then
4403:
4404: --getting the Details from table CAC_VIEW_COLLAB_DETAILS for a given non -repeating task
4405: open getCollabDetails(l_task_id);
4406: fetch getCollabDetails into l_collab_details;
4407:
4408: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table

Line 4408: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table

4404: --getting the Details from table CAC_VIEW_COLLAB_DETAILS for a given non -repeating task
4405: open getCollabDetails(l_task_id);
4406: fetch getCollabDetails into l_collab_details;
4407:
4408: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table
4409: --otherwise close the cursor.
4410: If (getCollabDetails%FOUND) then
4411:
4412: cac_view_collab_details_pkg.update_row

Line 4412: cac_view_collab_details_pkg.update_row

4408: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table
4409: --otherwise close the cursor.
4410: If (getCollabDetails%FOUND) then
4411:
4412: cac_view_collab_details_pkg.update_row
4413: (x_collab_id=> l_collab_details.collab_id ,
4414: x_task_id=> l_task_id,
4415: x_meeting_mode=>l_collab_details.meeting_mode,
4416: x_meeting_id=>l_collab_details.meeting_id,

Line 4432: cac_view_collab_details_pkg.insert_row (

4428:
4429:
4430: else
4431:
4432: cac_view_collab_details_pkg.insert_row (
4433: x_rowid => l_rowid,
4434: x_collab_id => get_collab_id,--cac_view_collab_details_s.nextval,
4435: x_task_id => l_task_id,
4436: x_meeting_mode => 'LIVE',

Line 4434: x_collab_id => get_collab_id,--cac_view_collab_details_s.nextval,

4430: else
4431:
4432: cac_view_collab_details_pkg.insert_row (
4433: x_rowid => l_rowid,
4434: x_collab_id => get_collab_id,--cac_view_collab_details_s.nextval,
4435: x_task_id => l_task_id,
4436: x_meeting_mode => 'LIVE',
4437: x_meeting_id => null,
4438: x_meeting_url => null,

Line 4465: cac_view_collab_details_pkg.update_row

4461: LOOP
4462: fetch getTaskForRecurRule into p_getTaskForRecurRule;
4463: exit when getTaskForRecurRule%NOTFOUND;
4464: --update collab details
4465: cac_view_collab_details_pkg.update_row
4466: (x_collab_id=> p_getTaskForRecurRule.collab_id ,
4467: x_task_id=> p_getTaskForRecurRule.task_id,
4468: x_meeting_mode=>p_getTaskForRecurRule.meeting_mode,
4469: x_meeting_id=>p_getTaskForRecurRule.meeting_id,

Line 4571: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table

4567: OPEN getCollabDetails(l_task_id);
4568:
4569: FETCH getCollabDetails INTO l_collab_details;
4570:
4571: -- Update the rows only if there are some information in the CAC_VIEW_COLLAB_DETAILS table
4572: --otherwise close the cursor.
4573: IF (getCollabDetails%FOUND) THEN
4574:
4575: l_location := SUBSTRB(p_task_rec.locations,1,100);

Line 4577: cac_view_collab_details_pkg.update_row

4573: IF (getCollabDetails%FOUND) THEN
4574:
4575: l_location := SUBSTRB(p_task_rec.locations,1,100);
4576:
4577: cac_view_collab_details_pkg.update_row
4578: (x_collab_id=> l_collab_details.collab_id ,
4579: x_task_id=> l_task_id,
4580: x_meeting_mode=>l_collab_details.meeting_mode,
4581: x_meeting_id=>l_collab_details.meeting_id,

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;

Line 5203: cac_view_collab_details cac

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;
5207: