APPS.CAC_SYNC_TASK_COMMON dependencies on JTA_TASK_EXCLUSIONS

Line 192: SELECT task_id FROM jta_task_exclusions WHERE

188: l_temp NUMBER;
189:
190: CURSOR exclusion_exists(b_exclude_task_id IN NUMBER)
191: IS
192: SELECT task_id FROM jta_task_exclusions WHERE
193: task_id=b_exclude_task_id;
194: l_exclusion_exists exclusion_exists%ROWTYPE;
195: l_update_exclusion BOOLEAN:=FALSE;
196:

Line 230: delete from jta_task_exclusions

226:
227:
228: if (l_update_exclusion) then
229:
230: delete from jta_task_exclusions
231: where task_id=l_exclude_task_id
232: and recurrence_rule_id=p_rec_rule_id;
233:
234: end if;-- if (l_update_exclusion) then

Line 475: FROM jta_task_exclusions

471: l_count NUMBER;
472: BEGIN
473: SELECT COUNT (recurrence_rule_id)
474: INTO l_count
475: FROM jta_task_exclusions
476: WHERE recurrence_rule_id = p_recurrence_rule_id;
477: RETURN l_count;
478: END count_exclusions;
479:

Line 1234: jta_task_exclusions jte where

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:
1238: l_date DATE;

Line 5465: jta_task_exclusions jte

5461:
5462: cursor get_tasks_ids (b_recurrence_rule_id IN NUMBER)
5463: is
5464: select jte.task_id from
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;