DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_COMMON dependencies on CAC_SYNC_TASK_CURSORS

Line 1320: l_exclusion cac_sync_task_cursors.c_exclusions%ROWTYPE;

1316: IS
1317:
1318: l_date DATE;
1319: l_alarm_date DATE;
1320: l_exclusion cac_sync_task_cursors.c_exclusions%ROWTYPE;
1321: i BINARY_INTEGER := nvl(p_exclusion_data.last,0) ;
1322: BEGIN
1323:
1324: FOR l_exclusion in cac_sync_task_cursors.c_exclusions(

Line 1324: FOR l_exclusion in cac_sync_task_cursors.c_exclusions(

1320: l_exclusion cac_sync_task_cursors.c_exclusions%ROWTYPE;
1321: i BINARY_INTEGER := nvl(p_exclusion_data.last,0) ;
1322: BEGIN
1323:
1324: FOR l_exclusion in cac_sync_task_cursors.c_exclusions(
1325: p_syncanchor,
1326: p_recurrence_rule_id,
1327: p_resource_id,
1328: p_resource_type)

Line 2585: FOR rec_modify_nonrepeat IN cac_sync_task_cursors.c_modify_non_repeat_task (

2581: i INTEGER := p_recordindex;
2582: l_invalid BOOLEAN;
2583: l_end_date DATE;
2584: BEGIN
2585: FOR rec_modify_nonrepeat IN cac_sync_task_cursors.c_modify_non_repeat_task (
2586: p_syncanchor,
2587: p_resource_id,
2588: p_principal_id,
2589: p_resource_type,

Line 2678: FOR rec_new_nonrepeat IN cac_sync_task_cursors.c_new_non_repeat_task (

2674: END IF; -- l_invalid
2675:
2676: END LOOP;
2677:
2678: FOR rec_new_nonrepeat IN cac_sync_task_cursors.c_new_non_repeat_task (
2679: p_syncanchor,
2680: p_resource_id,
2681: p_principal_id,
2682: p_resource_type,

Line 2787: FOR rec_delete IN cac_sync_task_cursors.c_delete_task (

2783: )
2784: IS
2785: i INTEGER := nvl(x_data.last,0);
2786: BEGIN
2787: FOR rec_delete IN cac_sync_task_cursors.c_delete_task (
2788: p_syncanchor,
2789: p_resource_id,
2790: p_principal_id,
2791: p_resource_type,

Line 2819: FOR rec_delete IN cac_sync_task_cursors.c_delete_assignee_reject (

2815: x_totaldeleted := x_totaldeleted + 1;
2816: END IF;
2817: END LOOP;
2818:
2819: FOR rec_delete IN cac_sync_task_cursors.c_delete_assignee_reject (
2820: p_syncanchor,
2821: p_resource_id,
2822: p_principal_id,
2823: p_resource_type,

Line 2854: FOR rec_delete IN cac_sync_task_cursors.c_delete_assignment (

2850: x_totaldeleted := x_totaldeleted + 1;
2851: END IF;
2852: END LOOP;
2853:
2854: FOR rec_delete IN cac_sync_task_cursors.c_delete_assignment (
2855: p_syncanchor,
2856: p_resource_id,
2857: p_resource_type,
2858: p_principal_id,

Line 2886: FOR rec_delete IN cac_sync_task_cursors.c_delete_rejected_tasks (

2882: x_totaldeleted := x_totaldeleted + 1;
2883: END IF;
2884: END LOOP;
2885:
2886: FOR rec_delete IN cac_sync_task_cursors.c_delete_rejected_tasks (
2887: p_syncanchor,
2888: p_resource_id,
2889: p_resource_type,
2890: p_principal_id,

Line 2918: FOR rec_delete IN cac_sync_task_cursors.c_delete_unsubscribed(

2914: x_totaldeleted := x_totaldeleted + 1;
2915: END IF;
2916: END LOOP;
2917:
2918: FOR rec_delete IN cac_sync_task_cursors.c_delete_unsubscribed(
2919: p_resource_id,
2920: p_resource_type,
2921: p_principal_id,
2922: p_source_object_type

Line 2978: FOR rec_modify_repeat IN cac_sync_task_cursors.c_modify_repeating_task (

2974: BEGIN
2975:
2976:
2977:
2978: FOR rec_modify_repeat IN cac_sync_task_cursors.c_modify_repeating_task (
2979: p_syncanchor,
2980: p_resource_id,
2981: p_principal_id,
2982: p_resource_type,

Line 3104: FOR rec_new_repeat IN cac_sync_task_cursors.c_new_repeating_task (

3100: END IF; -- l_invalid
3101:
3102: END LOOP;
3103:
3104: FOR rec_new_repeat IN cac_sync_task_cursors.c_new_repeating_task (
3105: p_syncanchor,
3106: p_resource_id,
3107: p_principal_id,
3108: p_resource_type,