APPS.CAC_SYNC_TASK_COMMON dependencies on CAC_VIEW_COLLAB_DETAILS_PKG

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 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 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 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 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 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 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,