397: x_is_standalone_location=>l_collab_details.is_standalone_location,
398: x_location=>l_location,
399: x_dial_in=>p_exclusion.dial_in,
400: x_last_update_date=>SYSDATE,
401: x_last_updated_by=>jtf_task_utl.updated_by,
402: x_last_update_login=>jtf_task_utl.login_id);
403:
404: END IF;
405:
398: x_location=>l_location,
399: x_dial_in=>p_exclusion.dial_in,
400: x_last_update_date=>SYSDATE,
401: x_last_updated_by=>jtf_task_utl.updated_by,
402: x_last_update_login=>jtf_task_utl.login_id);
403:
404: END IF;
405:
406:
1614: p_resource_type_code => p_resource_type
1615: );
1616: IF l_category_id IS NOT NULL
1617: THEN
1618: l_category_name := substr(jtf_task_utl.get_category_name(l_category_id), 1, 240);
1619: END IF;
1620: x_task_rec.category := l_category_name;
1621:
1622: x_task_rec.alarmdate := set_alarm_date (
3383: x_is_standalone_location => 'Y',
3384: x_location => l_location,-- previous it was p_task_rec.locations,
3385: x_dial_in => p_task_rec.dial_in,
3386: x_creation_date => SYSDATE,
3387: x_created_by => jtf_task_utl.created_by,
3388: x_last_update_date => SYSDATE,
3389: x_last_updated_by => jtf_task_utl.updated_by,
3390: x_last_update_login => jtf_task_utl.login_id
3391: );
3385: x_dial_in => p_task_rec.dial_in,
3386: x_creation_date => SYSDATE,
3387: x_created_by => jtf_task_utl.created_by,
3388: x_last_update_date => SYSDATE,
3389: x_last_updated_by => jtf_task_utl.updated_by,
3390: x_last_update_login => jtf_task_utl.login_id
3391: );
3392:
3393: ELSIF (l_source_object_type_code = G_TASK) THEN
3386: x_creation_date => SYSDATE,
3387: x_created_by => jtf_task_utl.created_by,
3388: x_last_update_date => SYSDATE,
3389: x_last_updated_by => jtf_task_utl.updated_by,
3390: x_last_update_login => jtf_task_utl.login_id
3391: );
3392:
3393: ELSIF (l_source_object_type_code = G_TASK) THEN
3394:
3486: x_is_standalone_location=>l_collab_details.is_standalone_location,
3487: x_location=>l_location,
3488: x_dial_in=>p_task_rec.dial_in,
3489: x_last_update_date=>SYSDATE,
3490: x_last_updated_by=>jtf_task_utl.updated_by,
3491: x_last_update_login=>jtf_task_utl.login_id);
3492:
3493: END IF;
3494:
3487: x_location=>l_location,
3488: x_dial_in=>p_task_rec.dial_in,
3489: x_last_update_date=>SYSDATE,
3490: x_last_updated_by=>jtf_task_utl.updated_by,
3491: x_last_update_login=>jtf_task_utl.login_id);
3492:
3493: END IF;
3494:
3495:
3546: x_is_standalone_location => 'Y',
3547: x_location => l_location,-- previous it was p_task_rec.locations,
3548: x_dial_in => p_task_rec.dial_in,
3549: x_creation_date => SYSDATE,
3550: x_created_by => jtf_task_utl.created_by,
3551: x_last_update_date => SYSDATE,
3552: x_last_updated_by => jtf_task_utl.updated_by,
3553: x_last_update_login => jtf_task_utl.login_id
3554: );
3548: x_dial_in => p_task_rec.dial_in,
3549: x_creation_date => SYSDATE,
3550: x_created_by => jtf_task_utl.created_by,
3551: x_last_update_date => SYSDATE,
3552: x_last_updated_by => jtf_task_utl.updated_by,
3553: x_last_update_login => jtf_task_utl.login_id
3554: );
3555:
3556:
3549: x_creation_date => SYSDATE,
3550: x_created_by => jtf_task_utl.created_by,
3551: x_last_update_date => SYSDATE,
3552: x_last_updated_by => jtf_task_utl.updated_by,
3553: x_last_update_login => jtf_task_utl.login_id
3554: );
3555:
3556:
3557: END IF; -- for (doesBookingExists%FOUND)
4318: x_is_standalone_location=>p_getTaskForRecurRule.is_standalone_location,
4319: x_location=>l_location,-- p_task_rec.locations,
4320: x_dial_in=>p_task_rec.dial_in,
4321: x_last_update_date=>sysdate,
4322: x_last_updated_by=>jtf_task_utl.updated_by,
4323: x_last_update_login=>jtf_task_utl.login_id);
4324:
4325: END LOOP;
4326:
4319: x_location=>l_location,-- p_task_rec.locations,
4320: x_dial_in=>p_task_rec.dial_in,
4321: x_last_update_date=>sysdate,
4322: x_last_updated_by=>jtf_task_utl.updated_by,
4323: x_last_update_login=>jtf_task_utl.login_id);
4324:
4325: END LOOP;
4326:
4327: IF (getTaskForRecurRule%ISOPEN) then
4422: x_is_standalone_location=>l_collab_details.is_standalone_location,
4423: x_location=>l_location,-- was p_task_rec.locations,
4424: x_dial_in=>p_task_rec.dial_in,
4425: x_last_update_date=>sysdate,
4426: x_last_updated_by=>jtf_task_utl.updated_by,
4427: x_last_update_login=>jtf_task_utl.login_id);
4428:
4429:
4430: else
4423: x_location=>l_location,-- was p_task_rec.locations,
4424: x_dial_in=>p_task_rec.dial_in,
4425: x_last_update_date=>sysdate,
4426: x_last_updated_by=>jtf_task_utl.updated_by,
4427: x_last_update_login=>jtf_task_utl.login_id);
4428:
4429:
4430: else
4431:
4443: x_is_standalone_location => 'Y',
4444: x_location => l_location,--was p_task_rec.locations,
4445: x_dial_in => p_task_rec.dial_in,
4446: x_creation_date => SYSDATE,
4447: x_created_by => jtf_task_utl.created_by,
4448: x_last_update_date => SYSDATE,
4449: x_last_updated_by => jtf_task_utl.updated_by,
4450: x_last_update_login => jtf_task_utl.login_id);
4451:
4445: x_dial_in => p_task_rec.dial_in,
4446: x_creation_date => SYSDATE,
4447: x_created_by => jtf_task_utl.created_by,
4448: x_last_update_date => SYSDATE,
4449: x_last_updated_by => jtf_task_utl.updated_by,
4450: x_last_update_login => jtf_task_utl.login_id);
4451:
4452:
4453: end if;
4446: x_creation_date => SYSDATE,
4447: x_created_by => jtf_task_utl.created_by,
4448: x_last_update_date => SYSDATE,
4449: x_last_updated_by => jtf_task_utl.updated_by,
4450: x_last_update_login => jtf_task_utl.login_id);
4451:
4452:
4453: end if;
4454:
4475: x_is_standalone_location=>p_getTaskForRecurRule.is_standalone_location,
4476: x_location=>l_location,--was p_task_rec.locations,
4477: x_dial_in=>p_task_rec.dial_in,
4478: x_last_update_date=>sysdate,
4479: x_last_updated_by=>jtf_task_utl.updated_by,
4480: x_last_update_login=>jtf_task_utl.login_id);
4481: END LOOP;
4482: close getTaskForRecurRule;
4483:
4476: x_location=>l_location,--was p_task_rec.locations,
4477: x_dial_in=>p_task_rec.dial_in,
4478: x_last_update_date=>sysdate,
4479: x_last_updated_by=>jtf_task_utl.updated_by,
4480: x_last_update_login=>jtf_task_utl.login_id);
4481: END LOOP;
4482: close getTaskForRecurRule;
4483:
4484: end if;-- for if (l_rec_rule_id is null)
4587: x_is_standalone_location=>l_collab_details.is_standalone_location,
4588: x_location=>l_location,
4589: x_dial_in=>p_task_rec.dial_in,
4590: x_last_update_date=>SYSDATE,
4591: x_last_updated_by=>jtf_task_utl.updated_by,
4592: x_last_update_login=>jtf_task_utl.login_id);
4593:
4594: END IF;
4595:
4588: x_location=>l_location,
4589: x_dial_in=>p_task_rec.dial_in,
4590: x_last_update_date=>SYSDATE,
4591: x_last_updated_by=>jtf_task_utl.updated_by,
4592: x_last_update_login=>jtf_task_utl.login_id);
4593:
4594: END IF;
4595:
4596: