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.JTA_SYNC_TASK_CURSORS dependencies on JTA_SYNC_TASK

Line 1: PACKAGE JTA_SYNC_TASK_CURSORS AUTHID CURRENT_USER AS

1: PACKAGE JTA_SYNC_TASK_CURSORS AUTHID CURRENT_USER AS
2: /* $Header: jtavstzs.pls 120.3 2005/09/08 06:02:40 deeprao ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 64: | ==>tm.resource_id = jta_sync_task.g_login_resource_id|

60: | not to pick up any rejected appts/task |
61: | 2)Modified the following statement in all |
62: | cursors |
63: | tm.resource_id = b_resource_id |
64: | ==>tm.resource_id = jta_sync_task.g_login_resource_id|
65: | 3)Modified all cursor for handling group id |
66: | |
67: |04-29-2002 CJANG Added a condition in c_new_non_repeat_task |
68: | "AND ta.assignment_status_id IN (3,18)" |

Line 121: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,

117: t.alarm_start,
118: UPPER (t.alarm_start_uom) alarm_start_uom,
119: NVL (t.private_flag, 'N') private_flag,
120: t.deleted_flag,
121: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,
122: t.task_id,
123: t.owner_type_code,
124: t.source_object_type_code,
125: rc.recurrence_rule_id,

Line 158: FROM jta_sync_task_mapping tm

154: AND jtb.source_object_type_code = b_source_object_type
155: AND b_source_object_type = 'APPOINTMENT'
156: AND jtb.recurrence_rule_id IS NOT NULL
157: HAVING NOT EXISTS (SELECT 1
158: FROM jta_sync_task_mapping tm
159: WHERE tm.task_id = MIN(jtb.task_id)
160: AND tm.resource_id = jta_sync_task.g_login_resource_id)
161: GROUP BY jtb.recurrence_rule_id) newtask
162: WHERE t.task_id = newtask.task_id

Line 160: AND tm.resource_id = jta_sync_task.g_login_resource_id)

156: AND jtb.recurrence_rule_id IS NOT NULL
157: HAVING NOT EXISTS (SELECT 1
158: FROM jta_sync_task_mapping tm
159: WHERE tm.task_id = MIN(jtb.task_id)
160: AND tm.resource_id = jta_sync_task.g_login_resource_id)
161: GROUP BY jtb.recurrence_rule_id) newtask
162: WHERE t.task_id = newtask.task_id
163: AND ( (b_resource_type = 'RS_GROUP' AND
164: t.owner_type_code = b_resource_type AND

Line 214: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,

210: t.alarm_start,
211: UPPER (t.alarm_start_uom) alarm_start_uom,
212: NVL (t.private_flag, 'N') private_flag,
213: t.deleted_flag,
214: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,
215: tm.task_sync_id,
216: t.task_id,
217: t.owner_type_code,
218: t.source_object_type_code,

Line 237: jta_sync_task_mapping tm,

233: rc.date_of_month,
234: rc.occurs_which,
235: greatest(t.object_changed_date, ta.last_update_date) new_timestamp
236: FROM jtf_task_recur_rules rc,
237: jta_sync_task_mapping tm,
238: jtf_task_all_assignments ta,
239: jtf_task_statuses_b ts,
240: jtf_task_priorities_b tb,
241: jtf_tasks_tl tl,

Line 243: WHERE tm.resource_id = jta_sync_task.g_login_resource_id

239: jtf_task_statuses_b ts,
240: jtf_task_priorities_b tb,
241: jtf_tasks_tl tl,
242: jtf_tasks_b t
243: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
244: AND t.task_id = tm.task_id
245: AND t.task_id = ta.task_id
246: AND tl.task_id = t.task_id
247: AND ( (b_resource_type = 'RS_GROUP' AND

Line 281: , jta_sync_task_mapping tm

277: b_source_object_type VARCHAR2)
278: IS
279: SELECT tm.task_sync_id
280: FROM jtf_tasks_b t
281: , jta_sync_task_mapping tm
282: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
283: AND t.task_id = tm.task_id
284: AND ( (b_resource_type = 'RS_GROUP' AND
285: t.owner_type_code = b_resource_type AND

Line 282: WHERE tm.resource_id = jta_sync_task.g_login_resource_id

278: IS
279: SELECT tm.task_sync_id
280: FROM jtf_tasks_b t
281: , jta_sync_task_mapping tm
282: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
283: AND t.task_id = tm.task_id
284: AND ( (b_resource_type = 'RS_GROUP' AND
285: t.owner_type_code = b_resource_type AND
286: t.owner_id = b_resource_id

Line 307: , jta_sync_task_mapping tm

303: b_source_object_type VARCHAR2)
304: IS
305: SELECT tm.task_sync_id
306: FROM jtf_tasks_b t
307: , jta_sync_task_mapping tm
308: , jtf_task_all_assignments ta
309: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
310: AND t.task_id = tm.task_id
311: AND t.owner_type_code = b_resource_type

Line 309: WHERE tm.resource_id = jta_sync_task.g_login_resource_id

305: SELECT tm.task_sync_id
306: FROM jtf_tasks_b t
307: , jta_sync_task_mapping tm
308: , jtf_task_all_assignments ta
309: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
310: AND t.task_id = tm.task_id
311: AND t.owner_type_code = b_resource_type
312: AND b_resource_type = 'RS_EMPLOYEE'
313: AND NVL (t.deleted_flag, 'N') = 'N'

Line 331: , jta_sync_task_mapping tm

327: b_source_object_type VARCHAR2)
328: IS
329: SELECT tm.task_sync_id
330: FROM jtf_tasks_b t
331: , jta_sync_task_mapping tm
332: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
333: AND t.task_id = tm.task_id
334: AND ( (b_resource_type = 'RS_GROUP' AND
335: t.owner_type_code = b_resource_type AND

Line 332: WHERE tm.resource_id = jta_sync_task.g_login_resource_id

328: IS
329: SELECT tm.task_sync_id
330: FROM jtf_tasks_b t
331: , jta_sync_task_mapping tm
332: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
333: AND t.task_id = tm.task_id
334: AND ( (b_resource_type = 'RS_GROUP' AND
335: t.owner_type_code = b_resource_type AND
336: t.owner_id = b_resource_id

Line 371: , jta_sync_task_mapping tm

367: b_source_object_type VARCHAR2)
368: IS
369: SELECT tm.task_sync_id
370: FROM jtf_tasks_b t
371: , jta_sync_task_mapping tm
372: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
373: AND t.task_id = tm.task_id
374: AND t.owner_type_code = b_resource_type
375: AND b_resource_type = 'RS_EMPLOYEE'

Line 372: WHERE tm.resource_id = jta_sync_task.g_login_resource_id

368: IS
369: SELECT tm.task_sync_id
370: FROM jtf_tasks_b t
371: , jta_sync_task_mapping tm
372: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
373: AND t.task_id = tm.task_id
374: AND t.owner_type_code = b_resource_type
375: AND b_resource_type = 'RS_EMPLOYEE'
376: AND NVL (t.deleted_flag, 'N') = 'N'

Line 408: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,

404: t.alarm_start,
405: UPPER (t.alarm_start_uom) alarm_start_uom,
406: NVL (t.private_flag, 'N') private_flag,
407: t.deleted_flag,
408: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,
409: t.task_id,
410: t.owner_type_code,
411: t.source_object_type_code,
412: t.recurrence_rule_id,

Line 437: FROM jta_sync_task_mapping tm

433: )
434: )
435: AND task_type_id <> 22
436: AND NOT EXISTS (SELECT 1
437: FROM jta_sync_task_mapping tm
438: WHERE tm.task_id = t.task_id
439: AND tm.resource_id = jta_sync_task.g_login_resource_id)
440: AND t.recurrence_rule_id IS NULL
441: AND decode(t.source_object_type_code,'APPOINTMENT','APPOINTMENT','TASK') = b_source_object_type

Line 439: AND tm.resource_id = jta_sync_task.g_login_resource_id)

435: AND task_type_id <> 22
436: AND NOT EXISTS (SELECT 1
437: FROM jta_sync_task_mapping tm
438: WHERE tm.task_id = t.task_id
439: AND tm.resource_id = jta_sync_task.g_login_resource_id)
440: AND t.recurrence_rule_id IS NULL
441: AND decode(t.source_object_type_code,'APPOINTMENT','APPOINTMENT','TASK') = b_source_object_type
442: AND tl.task_id = t.task_id
443: AND tl.language = USERENV ('LANG')

Line 474: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,

470: t.alarm_start,
471: UPPER (t.alarm_start_uom) alarm_start_uom,
472: NVL (t.private_flag, 'N') private_flag,
473: t.deleted_flag,
474: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,
475: tm.task_sync_id,
476: t.task_id,
477: t.owner_type_code,
478: t.source_object_type_code,

Line 482: FROM jta_sync_task_mapping tm,

478: t.source_object_type_code,
479: t.recurrence_rule_id,
480: ta.assignment_status_id,
481: greatest(t.object_changed_date, ta.last_update_date) new_timestamp
482: FROM jta_sync_task_mapping tm,
483: jtf_task_all_assignments ta,
484: jtf_task_priorities_b tb,
485: jtf_tasks_tl tl,
486: jtf_tasks_b t

Line 487: WHERE tm.resource_id = jta_sync_task.g_login_resource_id

483: jtf_task_all_assignments ta,
484: jtf_task_priorities_b tb,
485: jtf_tasks_tl tl,
486: jtf_tasks_b t
487: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
488: AND t.task_id = tm.task_id
489: AND ( (b_resource_type = 'RS_GROUP' AND
490: t.owner_type_code = b_resource_type AND
491: t.owner_id = b_resource_id

Line 522: FROM jtf_tasks_b b, jta_sync_task_mapping m

518: b_source_object_type VARCHAR2
519: )
520: IS
521: SELECT m.task_sync_id
522: FROM jtf_tasks_b b, jta_sync_task_mapping m
523: WHERE b.task_id = m.task_id
524: AND m.resource_id = jta_sync_task.g_login_resource_id
525: AND NVL (b.deleted_flag, 'N') = 'N'
526: AND b.owner_type_code ='RS_GROUP'

Line 524: AND m.resource_id = jta_sync_task.g_login_resource_id

520: IS
521: SELECT m.task_sync_id
522: FROM jtf_tasks_b b, jta_sync_task_mapping m
523: WHERE b.task_id = m.task_id
524: AND m.resource_id = jta_sync_task.g_login_resource_id
525: AND NVL (b.deleted_flag, 'N') = 'N'
526: AND b.owner_type_code ='RS_GROUP'
527: AND b.source_object_type_code = jta_sync_task_common.G_APPOINTMENT
528: AND b_resource_id = m.resource_id

Line 527: AND b.source_object_type_code = jta_sync_task_common.G_APPOINTMENT

523: WHERE b.task_id = m.task_id
524: AND m.resource_id = jta_sync_task.g_login_resource_id
525: AND NVL (b.deleted_flag, 'N') = 'N'
526: AND b.owner_type_code ='RS_GROUP'
527: AND b.source_object_type_code = jta_sync_task_common.G_APPOINTMENT
528: AND b_resource_id = m.resource_id
529: AND b_source_object_type = jta_sync_task_common.G_APPOINTMENT
530: AND b_resource_type = 'RS_EMPLOYEE'
531: AND NOT EXISTS

Line 529: AND b_source_object_type = jta_sync_task_common.G_APPOINTMENT

525: AND NVL (b.deleted_flag, 'N') = 'N'
526: AND b.owner_type_code ='RS_GROUP'
527: AND b.source_object_type_code = jta_sync_task_common.G_APPOINTMENT
528: AND b_resource_id = m.resource_id
529: AND b_source_object_type = jta_sync_task_common.G_APPOINTMENT
530: AND b_resource_type = 'RS_EMPLOYEE'
531: AND NOT EXISTS
532: (SELECT 1
533: FROM fnd_grants g

Line 535: AND g.grantee_key = to_char(jta_sync_task.g_login_resource_id) -- fix bug#4592625

531: AND NOT EXISTS
532: (SELECT 1
533: FROM fnd_grants g
534: WHERE g.instance_pk1_value = to_char(b.owner_id) -- fix bug bug 2613008
535: AND g.grantee_key = to_char(jta_sync_task.g_login_resource_id) -- fix bug#4592625
536: );
537:
538:
539: END; -- Package Specification JTA_SYNC_TASK_CURSORS

Line 539: END; -- Package Specification JTA_SYNC_TASK_CURSORS

535: AND g.grantee_key = to_char(jta_sync_task.g_login_resource_id) -- fix bug#4592625
536: );
537:
538:
539: END; -- Package Specification JTA_SYNC_TASK_CURSORS