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_COMMON dependencies on JTF_TASKS_B

Line 41: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb

37: --cursor to check if the task is recurring once every more than one year
38: cursor getTaskRecur(b_task_id IN NUMBER) is
39:
40: SELECT 1
41: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb
42: WHERE ((jtrr.occurs_uom ='YER' AND
43: jtrr.occurs_every > 1)
44: OR
45: (jtrr.occurs_uom ='MON'

Line 341: p_updation_record.private_flag :=p_exclusion.privateflag ; -- jtf_tasks_b.private_flag%TYPE DEFAULT fnd_api.g_miss_char,

337: end if;
338:
339: p_updation_record.timezone_id :=get_task_timezone_id(p_task_id=>p_exclude_task_id);
340:
341: p_updation_record.private_flag :=p_exclusion.privateflag ; -- jtf_tasks_b.private_flag%TYPE DEFAULT fnd_api.g_miss_char,
342: p_updation_record.alarm_on:=p_exclusion.alarmflag; -- NUMBER DEFAULT fnd_api.g_miss_num,
343: p_updation_record.change_mode:=jtf_task_repeat_appt_pvt.G_ONE;
344: p_updation_record.recurrence_rule_id:=p_rec_rule_id;
345: p_updation_record.free_busy_type :=p_exclusion.free_busy_type;

Line 487: FROM jtf_tasks_b

483: l_count NUMBER;
484: BEGIN
485: SELECT COUNT (recurrence_rule_id)
486: INTO l_count
487: FROM jtf_tasks_b
488: WHERE recurrence_rule_id = p_recurrence_rule_id;
489: RETURN l_count;
490: END count_excluded_tasks;
491:

Line 538: FROM jtf_tasks_b

534: CURSOR c_recur_tasks (b_recurrence_rule_id NUMBER,
535: b_exclusion_start_date DATE)
536: IS
537: SELECT task_id
538: FROM jtf_tasks_b
539: WHERE recurrence_rule_id = b_recurrence_rule_id
540: AND TRUNC (calendar_start_date) = TRUNC (b_exclusion_start_date);
541: l_sync_task_id NUMBER;
542: l_task_id NUMBER;

Line 584: FROM jtf_tasks_b jt

580:
581: CURSOR c_dateselect
582: IS
583: SELECT jt.date_selected
584: FROM jtf_tasks_b jt
585: WHERE jt.task_id = p_task_id;
586: --check for alarm flag
587:
588: BEGIN

Line 711: FROM jtf_tasks_b

707: IS
708: CURSOR c_task_timezone
709: IS
710: SELECT timezone_id
711: FROM jtf_tasks_b
712: WHERE task_id = p_task_id;
713:
714: l_task_timezone_id NUMBER;
715: BEGIN

Line 751: FROM jtf_tasks_b

747: IS
748: CURSOR c_tasks_ovn (b_task_id NUMBER)
749: IS
750: SELECT object_version_number
751: FROM jtf_tasks_b
752: WHERE task_id = b_task_id;
753:
754: l_object_version_number NUMBER;
755: BEGIN

Line 1230: FROM ( select b.calendar_start_date from jtf_tasks_b b

1226:
1227: CURSOR c_recur_tasks
1228: IS
1229: SELECT MAX (tasks.calendar_start_date)
1230: FROM ( select b.calendar_start_date from jtf_tasks_b b
1231: where b.recurrence_rule_id=p_recurrence_rule_id
1232: union
1233: select b.calendar_start_date from jtf_tasks_b b,
1234: jta_task_exclusions jte where

Line 1233: select b.calendar_start_date from jtf_tasks_b b,

1229: SELECT MAX (tasks.calendar_start_date)
1230: FROM ( select b.calendar_start_date from jtf_tasks_b b
1231: where b.recurrence_rule_id=p_recurrence_rule_id
1232: union
1233: select b.calendar_start_date from jtf_tasks_b b,
1234: jta_task_exclusions jte where
1235: jte.recurrence_rule_id=p_recurrence_rule_id
1236: and jte.task_id=b.task_id) tasks;
1237:

Line 1283: FROM jtf_tasks_b

1279: IS
1280: CURSOR get_priorityId
1281: IS
1282: SELECT task_priority_id
1283: FROM jtf_tasks_b
1284: WHERE task_id = p_task_id;
1285:
1286: l_priorityId Number;
1287: BEGIN

Line 2058: FROM jtf_tasks_b

2054: IS
2055: CURSOR c_source (b_task_id NUMBER)
2056: IS
2057: SELECT source_object_type_code
2058: FROM jtf_tasks_b
2059: WHERE task_id = b_task_id;
2060:
2061: l_source_object_type_code VARCHAR2(60);
2062: BEGIN

Line 2127: , jtf_tasks_b tsk

2123: AND fg.instance_pk2_value = 'RS_GROUP'
2124: AND fg.instance_pk1_value = to_char(g.group_id)
2125: ) rs
2126: , jtf_task_all_assignments asg
2127: , jtf_tasks_b tsk
2128: WHERE asg.resource_type_code = rs.resource_type_code
2129: AND asg.resource_id = rs.resource_id
2130: AND asg.task_id = tsk.task_id
2131: AND tsk.task_id = p_task_id

Line 2267: jtf_tasks_b t

2263: jtf_task_statuses_b ts,
2264: jtf_task_priorities_b tb,
2265: jtf_tasks_tl tl,
2266: jtf_task_all_assignments ta,
2267: jtf_tasks_b t
2268: WHERE
2269: ta.task_id = t.task_id
2270: and ta.assignee_role= b_role
2271: AND tl.task_id = t.task_id

Line 2280: l_task_id jtf_tasks_b.task_id%type;

2276: and t.task_id=b_task_id
2277: and nvl(t.deleted_flag,'N')='N';
2278:
2279: task_info get_task_info%rowtype;
2280: l_task_id jtf_tasks_b.task_id%type;
2281: l_start_date date;
2282: l_end_date DATE;
2283: l_occurs_which NUMBER;
2284: l_date_of_month NUMBER;

Line 2426: FROM jtf_tasks_b t

2422: IS
2423: CURSOR c_recur
2424: IS
2425: SELECT t.recurrence_rule_id
2426: FROM jtf_tasks_b t
2427: WHERE t.task_id = p_task_id;
2428:
2429: l_recurrence_rule_id NUMBER;
2430: BEGIN

Line 3275: select b.object_version_number,b.task_id from jtf_tasks_b b,jtf_tasks_tl t

3271: cursor doesBookingExists(b_task_name VARCHAR2,b_cal_start_date DATE,
3272: b_cal_end_date DATE,b_owner_type_code VARCHAR2,
3273: b_owner_id NUMBER)
3274: is
3275: select b.object_version_number,b.task_id from jtf_tasks_b b,jtf_tasks_tl t
3276: where b.entity in ('BOOKING','APPOINTMENT')
3277: and b.source_object_type_code='EXTERNAL APPOINTMENT'
3278: and t.task_id=b.task_id
3279: and t.language=userenv('LANG')

Line 3286: l_source_object_type_code jtf_tasks_b.source_object_type_code%type;

3282: and b.calendar_start_date =b_cal_start_date
3283: and b.calendar_end_date=b_cal_end_date
3284: and b.owner_type_code=b_owner_type_code
3285: and b.owner_id=b_owner_id;
3286: l_source_object_type_code jtf_tasks_b.source_object_type_code%type;
3287:
3288:
3289: cursor syncIDExists(b_principal_id NUMBER,b_task_id NUMBER,b_resource_id NUMBER)
3290: is

Line 3822: jtf_tasks_b t

3818: jtf_task_statuses_b ts,
3819: jtf_task_priorities_b tb,
3820: jtf_tasks_tl tl,
3821: jtf_task_all_assignments ta,
3822: jtf_tasks_b t
3823: WHERE
3824:
3825: ta.task_id = t.task_id
3826: and ta.assignee_role= b_role

Line 4067: FROM jtf_tasks_b

4063: actual_start_date,
4064: actual_end_date,
4065: calendar_start_date,
4066: timezone_id
4067: FROM jtf_tasks_b
4068: WHERE recurrence_rule_id = b_recurrence_rule_id;
4069:
4070: l_changed_rule boolean ;
4071: l_status_id number;

Line 4079: from cac_view_collab_details_vl cac, jtf_tasks_b jtb1,jtf_tasks_b jtb2

4075: cursor getTaskForRecurRule(b_task_id number) is
4076: select CAC.COLLAB_ID, CAC.MEETING_MODE,CAC.MEETING_ID,CAC.MEETING_URL,
4077: CAC.JOIN_URL ,CAC.PLAYBACK_URL ,CAC.DOWNLOAD_URL ,CAC.CHAT_URL ,
4078: CAC.IS_STANDALONE_LOCATION,CAC.DIAL_IN, jtb1.task_id
4079: from cac_view_collab_details_vl cac, jtf_tasks_b jtb1,jtf_tasks_b jtb2
4080: where cac.task_id=jtb1.task_id
4081: and jtb1.recurrence_rule_id=jtb2.recurrence_rule_id
4082: and jtb2.task_id=b_task_id;
4083:

Line 4093: l_priorityId jtf_tasks_b.task_priority_id%type;

4089: PLAYBACK_URL ,DOWNLOAD_URL ,CHAT_URL ,IS_STANDALONE_LOCATION,DIAL_IN
4090: from CAC_VIEW_COLLAB_DETAILS_VL
4091: where task_id=b_task_id;
4092: l_collab_details getCollabDetails%rowtype;
4093: l_priorityId jtf_tasks_b.task_priority_id%type;
4094:
4095: repeat_to_nonrepeat BOOLEAN;
4096: nonrepeat_to_repeat BOOLEAN;
4097: l_location CAC_VIEW_COLLAB_DETAILS_TL.LOCATION%type:=substrb(p_task_rec.locations,1,100);

Line 4867: -- FROM jtf_tasks_b

4863:
4864: --CURSOR c_tasks (b_recurrence_rule_id NUMBER, b_task_id NUMBER)
4865: --IS
4866: -- SELECT task_id, source_object_type_code
4867: -- FROM jtf_tasks_b
4868: -- WHERE ( b_recurrence_rule_id IS NOT NULL
4869: -- AND recurrence_rule_id = b_recurrence_rule_id)
4870: -- OR ( b_recurrence_rule_id IS NULL
4871: -- AND task_id = b_task_id);

Line 4935: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb

4931: IS
4932: CURSOR c_task_recur (b_task_id NUMBER)
4933: IS
4934: SELECT jtrr.*
4935: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb
4936: WHERE jtb.task_id = b_task_id
4937: AND jtb.recurrence_rule_id IS NOT NULL
4938: AND jtrr.recurrence_rule_id = jtb.recurrence_rule_id;
4939:

Line 5247: FROM jta_sync_task_mapping jstm, jtf_tasks_b jtb

5243:
5244: CURSOR getBookings(b_principal_id IN NUMBER, b_user_id IN NUMBER)
5245: IS
5246: SELECT jtb.task_id,jtb.object_version_number,jstm.task_sync_id, jtb.source_object_type_code objectcode
5247: FROM jta_sync_task_mapping jstm, jtf_tasks_b jtb
5248: WHERE jstm.principal_id IN
5249: (SELECT principal_id
5250: FROM cac_sync_principals
5251: WHERE device_id = (SELECT device_id FROM cac_sync_principals

Line 5350: from jtf_task_recur_rules jtrr, jtf_tasks_b b

5346: OCCURS_MONTH,OCCURS_UOM,OCCURS_EVERY,
5347: OCCURS_NUMBER,START_DATE_ACTIVE,END_DATE_ACTIVE,
5348: SUNDAY,MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,
5349: SATURDAY
5350: from jtf_task_recur_rules jtrr, jtf_tasks_b b
5351: where b.recurrence_rule_id=jtrr.recurrence_rule_id
5352: and b.task_id=b_task_id;
5353:
5354: l_get_recur_rule get_recur_rule%rowtype;

Line 5469: l_recurrence_rule_id jtf_tasks_b.recurrence_rule_id%type;

5465: jta_task_exclusions jte
5466: where jte.recurrence_rule_id=b_recurrence_rule_id;
5467:
5468: l_tsk_ids get_tasks_ids%rowtype;
5469: l_recurrence_rule_id jtf_tasks_b.recurrence_rule_id%type;
5470: l_ovn NUMBER;
5471: l_msg_data VARCHAR2(2000);
5472: l_msg_count NUMBER;
5473:

Line 5538: from jtf_tasks_b b, jtf_task_all_assignments a, jta_sync_Task_mapping s

5534:
5535: CURSOR check_appt(b_resource_id NUMBER, b_resource_type_code VARCHAR2)
5536: IS
5537: SELECT a.assignment_status_id
5538: from jtf_tasks_b b, jtf_task_all_assignments a, jta_sync_Task_mapping s
5539: where b.task_id = a.task_id
5540: and s.task_id = b.task_id
5541: and s.task_sync_id = p_task_sync_id
5542: and a.resource_id = b_resource_id