APPS.CAC_SYNC_TASK_CURSORS dependencies on CAC_SYNC_TASK_COMMON

Line 55: NVL (t.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,

51: t.alarm_start,
52: UPPER (t.alarm_start_uom) alarm_start_uom,
53: NVL (t.private_flag, 'N') private_flag,
54: t.deleted_flag,
55: NVL (t.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,
56: t.task_id,
57: t.owner_type_code,
58: t.source_object_type_code,
59: rc.recurrence_rule_id,

Line 163: NVL (t.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,

159: t.alarm_start,
160: UPPER (t.alarm_start_uom) alarm_start_uom,
161: NVL (t.private_flag, 'N') private_flag,
162: t.deleted_flag,
163: NVL (t.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,
164: tm.task_sync_id,
165: t.task_id,
166: t.owner_type_code,
167: t.source_object_type_code,

Line 272: NVL (tb.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,

268: tb.alarm_start,
269: UPPER (tb.alarm_start_uom) alarm_start_uom,
270: NVL (tb.private_flag, 'N') private_flag,
271: tb.deleted_flag,
272: NVL (tb.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,
273: tb.owner_type_code,
274: tb.owner_id,
275: tb.source_object_type_code,
276: jte.recurrence_rule_id,

Line 282: when ((nvl(tb.deleted_flag,'N')='Y') and tb.recurrence_rule_id is null) then cac_sync_task_common.g_delete

278: CAC_VIEW_UTIL_PUB.get_locations(tl.task_id) locations,
279: ta.free_busy_type,
280: tb.entity,
281: case
282: when ((nvl(tb.deleted_flag,'N')='Y') and tb.recurrence_rule_id is null) then cac_sync_task_common.g_delete
283: when ((nvl(tb.deleted_flag,'N')='N') and tb.recurrence_rule_id is null) then cac_sync_task_common.g_modify
284: when ( tb.recurrence_rule_id is not null) then cac_sync_task_common.g_delete
285:
286:

Line 283: when ((nvl(tb.deleted_flag,'N')='N') and tb.recurrence_rule_id is null) then cac_sync_task_common.g_modify

279: ta.free_busy_type,
280: tb.entity,
281: case
282: when ((nvl(tb.deleted_flag,'N')='Y') and tb.recurrence_rule_id is null) then cac_sync_task_common.g_delete
283: when ((nvl(tb.deleted_flag,'N')='N') and tb.recurrence_rule_id is null) then cac_sync_task_common.g_modify
284: when ( tb.recurrence_rule_id is not null) then cac_sync_task_common.g_delete
285:
286:
287:

Line 284: when ( tb.recurrence_rule_id is not null) then cac_sync_task_common.g_delete

280: tb.entity,
281: case
282: when ((nvl(tb.deleted_flag,'N')='Y') and tb.recurrence_rule_id is null) then cac_sync_task_common.g_delete
283: when ((nvl(tb.deleted_flag,'N')='N') and tb.recurrence_rule_id is null) then cac_sync_task_common.g_modify
284: when ( tb.recurrence_rule_id is not null) then cac_sync_task_common.g_delete
285:
286:
287:
288:

Line 460: NVL (t.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,

456: t.alarm_start,
457: UPPER (t.alarm_start_uom) alarm_start_uom,
458: NVL (t.private_flag, 'N') private_flag,
459: t.deleted_flag,
460: NVL (t.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,
461: t.task_id,
462: t.owner_type_code,
463: t.source_object_type_code,
464: t.recurrence_rule_id,

Line 543: NVL (t.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,

539: t.alarm_start,
540: UPPER (t.alarm_start_uom) alarm_start_uom,
541: NVL (t.private_flag, 'N') private_flag,
542: t.deleted_flag,
543: NVL (t.timezone_id, cac_sync_task_common.g_client_timezone_id) timezone_id,
544: tm.task_sync_id,
545: t.task_id,
546: t.owner_type_code,
547: t.source_object_type_code,

Line 609: AND b.source_object_type_code = cac_sync_task_common.G_APPOINTMENT

605: AND m.principal_id = b_principal_id
606: AND m.resource_id = cac_sync_task.g_login_resource_id
607: AND NVL (b.deleted_flag, 'N') = 'N'
608: AND b.owner_type_code ='RS_GROUP'
609: AND b.source_object_type_code = cac_sync_task_common.G_APPOINTMENT
610: AND b_resource_id = m.resource_id
611: AND b_source_object_type = cac_sync_task_common.G_APPOINTMENT
612: AND b_resource_type = 'RS_EMPLOYEE'
613: AND NOT EXISTS

Line 611: AND b_source_object_type = cac_sync_task_common.G_APPOINTMENT

607: AND NVL (b.deleted_flag, 'N') = 'N'
608: AND b.owner_type_code ='RS_GROUP'
609: AND b.source_object_type_code = cac_sync_task_common.G_APPOINTMENT
610: AND b_resource_id = m.resource_id
611: AND b_source_object_type = cac_sync_task_common.G_APPOINTMENT
612: AND b_resource_type = 'RS_EMPLOYEE'
613: AND NOT EXISTS
614: (SELECT 1
615: FROM fnd_grants g