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_CURSORS dependencies on CAC_SYNC_TASK

Line 1: PACKAGE CAC_SYNC_TASK_CURSORS AUTHID CURRENT_USER AS

1: PACKAGE CAC_SYNC_TASK_CURSORS AUTHID CURRENT_USER AS
2: /* $Header: cacvstzs.pls 120.16.12010000.1 2008/07/24 18:03:39 appldev ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 26: --G_CAC_SYNC_TASK_NO_DATE VARCHAR2(10) := fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE');

22:
23: -- G_SYNC_DAYS_BEFORE CONSTANT NUMBER := 7;
24:
25: G_SYNC_DAYS_BEFORE CONSTANT NUMBER := TO_NUMBER (nvl(fnd_profile.VALUE ('CAC_SYNC_DAYS_BEFORE'),0));
26: --G_CAC_SYNC_TASK_NO_DATE VARCHAR2(10) := fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE');
27: G_CAC_SYNC_TASK_NO_DATE VARCHAR2(50) := 'FALSE';
28:
29: CURSOR c_new_repeating_task (
30: b_syncanchor DATE,

Line 27: G_CAC_SYNC_TASK_NO_DATE VARCHAR2(50) := 'FALSE';

23: -- G_SYNC_DAYS_BEFORE CONSTANT NUMBER := 7;
24:
25: G_SYNC_DAYS_BEFORE CONSTANT NUMBER := TO_NUMBER (nvl(fnd_profile.VALUE ('CAC_SYNC_DAYS_BEFORE'),0));
26: --G_CAC_SYNC_TASK_NO_DATE VARCHAR2(10) := fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE');
27: G_CAC_SYNC_TASK_NO_DATE VARCHAR2(50) := 'FALSE';
28:
29: CURSOR c_new_repeating_task (
30: b_syncanchor DATE,
31: b_resource_id NUMBER,

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 98: AND tm.resource_id = cac_sync_task.g_login_resource_id

94: AND jtb.recurrence_rule_id IS NOT NULL
95: HAVING NOT EXISTS (SELECT 1
96: FROM jta_sync_task_mapping tm
97: WHERE tm.task_id = MIN(jtb.task_id)
98: AND tm.resource_id = cac_sync_task.g_login_resource_id
99: AND tm.principal_id = b_principal_id)
100: GROUP BY jtb.recurrence_rule_id) newtask
101: WHERE t.task_id = newtask.task_id
102: AND ( (b_resource_type = 'RS_GROUP' AND

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 195: WHERE tm.resource_id = cac_sync_task.g_login_resource_id

191: jtf_task_statuses_b ts,
192: jtf_task_priorities_b tb,
193: jtf_tasks_tl tl,
194: jtf_tasks_b t
195: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
196: AND tm.principal_id = b_principal_id
197: AND t.task_id = tm.task_id
198: AND t.task_id = ta.task_id
199: AND tl.task_id = t.task_id

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 321: WHERE tm.resource_id = cac_sync_task.g_login_resource_id

317: IS
318: SELECT tm.task_sync_id
319: FROM jtf_tasks_b t
320: , jta_sync_task_mapping tm
321: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
322: AND tm.principal_id = b_principal_id
323: AND t.task_id = tm.task_id
324: AND ( (b_resource_type = 'RS_GROUP' AND
325: t.owner_type_code = b_resource_type AND

Line 350: WHERE tm.resource_id = cac_sync_task.g_login_resource_id

346: SELECT tm.task_sync_id
347: FROM jtf_tasks_b t
348: , jta_sync_task_mapping tm
349: , jtf_task_all_assignments ta
350: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
351: AND tm.principal_id = b_principal_id
352: AND t.task_id = tm.task_id
353: AND t.owner_type_code = b_resource_type
354: AND b_resource_type = 'RS_EMPLOYEE'

Line 376: WHERE tm.resource_id = cac_sync_task.g_login_resource_id

372: IS
373: SELECT tm.task_sync_id
374: FROM jtf_tasks_b t
375: , jta_sync_task_mapping tm
376: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
377: AND tm.principal_id = b_principal_id
378: AND t.task_id = tm.task_id
379: AND ( (b_resource_type = 'RS_GROUP' AND
380: t.owner_type_code = b_resource_type AND

Line 421: WHERE tm.resource_id = cac_sync_task.g_login_resource_id

417: IS
418: SELECT tm.task_sync_id
419: FROM jtf_tasks_b t
420: , jta_sync_task_mapping tm
421: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
422: AND tm.principal_id = b_principal_id
423: AND t.task_id = tm.task_id
424: AND t.owner_type_code = b_resource_type
425: AND b_resource_type = 'RS_EMPLOYEE'

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 495: AND tm.resource_id = cac_sync_task.g_login_resource_id

491: AND task_type_id <> 22
492: AND NOT EXISTS (SELECT 1
493: FROM jta_sync_task_mapping tm
494: WHERE tm.task_id = t.task_id
495: AND tm.resource_id = cac_sync_task.g_login_resource_id
496: AND tm.principal_id = b_principal_id)
497: AND t.recurrence_rule_id IS NULL
498: AND decode(t.source_object_type_code,'APPOINTMENT','APPOINTMENT','TASK') = b_source_object_type
499: AND decode(t.entity, 'APPOINTMENT','APPOINTMENT','TASK', 'TASK','BOOKING') = b_source_object_type

Line 513: -- ( (G_CAC_SYNC_TASK_NO_DATE = 'TRUE') AND (t.calendar_end_date IS NULL) );

509: and NOT EXISTS (select 1 from jta_task_exclusions where task_id=t.task_id);
510:
511: -- (t.calendar_end_date > (sysdate - G_SYNC_DAYS_BEFORE ))
512: -- OR
513: -- ( (G_CAC_SYNC_TASK_NO_DATE = 'TRUE') AND (t.calendar_end_date IS NULL) );
514:
515:
516:
517: CURSOR c_modify_non_repeat_task (

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 559: WHERE tm.resource_id = cac_sync_task.g_login_resource_id

555: jtf_task_all_assignments ta,
556: jtf_task_priorities_b tb,
557: jtf_tasks_tl tl,
558: jtf_tasks_b t
559: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
560: AND tm.principal_id = b_principal_id
561: AND t.task_id = tm.task_id
562: AND ( (b_resource_type = 'RS_GROUP' AND
563: t.owner_type_code = b_resource_type AND

Line 606: AND m.resource_id = cac_sync_task.g_login_resource_id

602: SELECT m.task_sync_id
603: FROM jtf_tasks_b b, jta_sync_task_mapping m
604: WHERE b.task_id = m.task_id
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

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

Line 617: AND g.grantee_key = to_char(cac_sync_task.g_login_resource_id)

613: AND NOT EXISTS
614: (SELECT 1
615: FROM fnd_grants g
616: WHERE g.instance_pk1_value = to_char(b.owner_id) -- fix bug bug 2613008
617: AND g.grantee_key = to_char(cac_sync_task.g_login_resource_id)
618: );
619:
620:
621: END; -- Package Specification JTA_SYNC_TASK_CURSORS