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 CAC_SYNC_TASK

Line 1: PACKAGE CAC_SYNC_TASK_COMMON AUTHID CURRENT_USER AS

1: PACKAGE CAC_SYNC_TASK_COMMON AUTHID CURRENT_USER AS
2: /* $Header: cacvstcs.pls 120.10.12000000.4 2007/10/19 07:56:56 vsood ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 50: G_CAC_SYNC_TASK_NO_DATE CONSTANT VARCHAR2(255):= nvl(fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE'),'N');

46: G_CARRIAGE_RETURN_ORACLE VARCHAR2(10) := '
47: ';
48: G_USER_DEFAULT_REPEAT_COUNT CONSTANT NUMBER := TO_NUMBER (fnd_profile.VALUE ('JTF_TASK_DEFAULT_REPEAT_COUNT'));
49: --CAC Sync: Include Tasks Without Date -added the profile to check if this profile is yes then bring endless task
50: G_CAC_SYNC_TASK_NO_DATE CONSTANT VARCHAR2(255):= nvl(fnd_profile.VALUE ('CAC_SYNC_TASK_NO_DATE'),'N');
51: -- The record type to store a group id and resource_type "RS_GROUP"
52: TYPE resource_list_rec IS RECORD (
53: resource_id NUMBER,
54: resource_type VARCHAR2(100),

Line 86: p_task_rec IN cac_sync_task.task_rec,

82: x_resources OUT NOCOPY resource_list_tbl
83: );
84:
85: PROCEDURE get_alarm_mins (
86: p_task_rec IN cac_sync_task.task_rec,
87: x_alarm_mins OUT NOCOPY NUMBER
88: );
89:
90: -- Used in creating a new task

Line 106: p_task_rec IN cac_sync_task.task_rec,

102: FUNCTION convert_gmt_to_server (p_date IN DATE) RETURN DATE;
103:
104: -- Used in creating a task
105: PROCEDURE convert_dates (
106: p_task_rec IN cac_sync_task.task_rec,
107: p_operation IN VARCHAR2, --CREATE OR UPDATE
108: x_planned_start OUT NOCOPY DATE,
109: x_planned_end OUT NOCOPY DATE,
110: x_scheduled_start OUT NOCOPY DATE,

Line 129: x_task_rec IN OUT NOCOPY cac_sync_task.task_rec);

125: p_scheduled_end_date IN DATE,
126: p_actual_start_date IN DATE,
127: p_actual_end_date IN DATE,
128: p_item_display_type IN NUMBER,
129: x_task_rec IN OUT NOCOPY cac_sync_task.task_rec);
130:
131: FUNCTION get_max_enddate(p_recurrence_rule_id IN NUMBER)
132: RETURN DATE;
133:

Line 221: x_data IN OUT NOCOPY cac_sync_task.task_tbl

217: p_source_object_type IN VARCHAR2,
218: p_get_data IN BOOLEAN,
219: x_totalnew IN OUT NOCOPY NUMBER,
220: x_totalmodified IN OUT NOCOPY NUMBER,
221: x_data IN OUT NOCOPY cac_sync_task.task_tbl
222: --p_new_syncanchor in date
223: );
224: PROCEDURE get_all_deleted_tasks(
225: p_request_type IN VARCHAR2,

Line 234: x_data IN OUT NOCOPY cac_sync_task.task_tbl

230: p_resource_type IN VARCHAR2,
231: p_source_object_type IN VARCHAR2,
232: p_get_data IN BOOLEAN,
233: x_totaldeleted IN OUT NOCOPY NUMBER,
234: x_data IN OUT NOCOPY cac_sync_task.task_tbl
235: --p_new_syncanchor in date
236: );
237: PROCEDURE get_all_repeat_tasks(
238: p_request_type IN VARCHAR2,

Line 249: x_data IN OUT NOCOPY cac_sync_task.task_tbl,

245: p_get_data IN BOOLEAN,
246: x_totalnew IN OUT NOCOPY NUMBER,
247: x_totalmodified IN OUT NOCOPY NUMBER,
248: -- x_totaldeleted IN OUT NOCOPY NUMBER,
249: x_data IN OUT NOCOPY cac_sync_task.task_tbl,
250: x_exclusion_data IN OUT NOCOPY cac_Sync_Task.exclusion_tbl
251: --p_new_syncanchor in date
252: );
253:

Line 250: x_exclusion_data IN OUT NOCOPY cac_Sync_Task.exclusion_tbl

246: x_totalnew IN OUT NOCOPY NUMBER,
247: x_totalmodified IN OUT NOCOPY NUMBER,
248: -- x_totaldeleted IN OUT NOCOPY NUMBER,
249: x_data IN OUT NOCOPY cac_sync_task.task_tbl,
250: x_exclusion_data IN OUT NOCOPY cac_Sync_Task.exclusion_tbl
251: --p_new_syncanchor in date
252: );
253:
254: PROCEDURE create_new_data(p_task_rec IN OUT NOCOPY cac_sync_task.task_rec

Line 254: PROCEDURE create_new_data(p_task_rec IN OUT NOCOPY cac_sync_task.task_rec

250: x_exclusion_data IN OUT NOCOPY cac_Sync_Task.exclusion_tbl
251: --p_new_syncanchor in date
252: );
253:
254: PROCEDURE create_new_data(p_task_rec IN OUT NOCOPY cac_sync_task.task_rec
255: ,p_mapping_type IN VARCHAR2 DEFAULT G_NEW -- Fixed bug 2497963 for 9i issue
256: ,p_exclusion_tbl IN OUT NOCOPY cac_sync_task.exclusion_tbl
257: ,p_resource_id IN NUMBER
258: ,p_resource_type IN VARCHAR2

Line 256: ,p_exclusion_tbl IN OUT NOCOPY cac_sync_task.exclusion_tbl

252: );
253:
254: PROCEDURE create_new_data(p_task_rec IN OUT NOCOPY cac_sync_task.task_rec
255: ,p_mapping_type IN VARCHAR2 DEFAULT G_NEW -- Fixed bug 2497963 for 9i issue
256: ,p_exclusion_tbl IN OUT NOCOPY cac_sync_task.exclusion_tbl
257: ,p_resource_id IN NUMBER
258: ,p_resource_type IN VARCHAR2
259: );
260:

Line 261: PROCEDURE update_existing_data(p_task_rec IN OUT NOCOPY cac_sync_task.task_rec

257: ,p_resource_id IN NUMBER
258: ,p_resource_type IN VARCHAR2
259: );
260:
261: PROCEDURE update_existing_data(p_task_rec IN OUT NOCOPY cac_sync_task.task_rec
262: ,p_exclusion_tbl IN OUT NOCOPY cac_sync_task.exclusion_tbl
263: ,p_resource_id IN NUMBER
264: ,p_resource_type IN VARCHAR2);
265:

Line 262: ,p_exclusion_tbl IN OUT NOCOPY cac_sync_task.exclusion_tbl

258: ,p_resource_type IN VARCHAR2
259: );
260:
261: PROCEDURE update_existing_data(p_task_rec IN OUT NOCOPY cac_sync_task.task_rec
262: ,p_exclusion_tbl IN OUT NOCOPY cac_sync_task.exclusion_tbl
263: ,p_resource_id IN NUMBER
264: ,p_resource_type IN VARCHAR2);
265:
266: PROCEDURE delete_exclusion_task(

Line 268: ,x_task_rec IN OUT NOCOPY cac_sync_task.task_rec

264: ,p_resource_type IN VARCHAR2);
265:
266: PROCEDURE delete_exclusion_task(
267: p_repeating_task_id IN NUMBER
268: ,x_task_rec IN OUT NOCOPY cac_sync_task.task_rec
269: );
270:
271: PROCEDURE delete_task_data(
272: p_task_rec IN OUT NOCOPY cac_sync_task.task_rec

Line 272: p_task_rec IN OUT NOCOPY cac_sync_task.task_rec

268: ,x_task_rec IN OUT NOCOPY cac_sync_task.task_rec
269: );
270:
271: PROCEDURE delete_task_data(
272: p_task_rec IN OUT NOCOPY cac_sync_task.task_rec
273: ,p_delete_map_flag IN BOOLEAN DEFAULT TRUE
274: );
275:
276: PROCEDURE reject_task_data(

Line 277: p_task_rec IN OUT NOCOPY cac_sync_task.task_rec

273: ,p_delete_map_flag IN BOOLEAN DEFAULT TRUE
274: );
275:
276: PROCEDURE reject_task_data(
277: p_task_rec IN OUT NOCOPY cac_sync_task.task_rec
278: );
279:
280: FUNCTION changed_repeat_rule(p_task_rec IN cac_sync_task.task_rec)
281: RETURN BOOLEAN;

Line 280: FUNCTION changed_repeat_rule(p_task_rec IN cac_sync_task.task_rec)

276: PROCEDURE reject_task_data(
277: p_task_rec IN OUT NOCOPY cac_sync_task.task_rec
278: );
279:
280: FUNCTION changed_repeat_rule(p_task_rec IN cac_sync_task.task_rec)
281: RETURN BOOLEAN;
282:
283: -- function to check if a repeating task is on exclusion list
284: FUNCTION check_for_exclusion(p_sync_id IN NUMBER,

Line 285: p_exclusion_tbl IN OUT NOCOPY cac_sync_task.exclusion_tbl,

281: RETURN BOOLEAN;
282:
283: -- function to check if a repeating task is on exclusion list
284: FUNCTION check_for_exclusion(p_sync_id IN NUMBER,
285: p_exclusion_tbl IN OUT NOCOPY cac_sync_task.exclusion_tbl,
286: p_calendar_start_date IN DATE,
287: p_client_time_zone_id NUMBER)
288: RETURN BOOLEAN;
289:

Line 292: p_exclusion_rec IN OUT NOCOPY cac_sync_task.exclusion_rec)

288: RETURN BOOLEAN;
289:
290: FUNCTION get_excluding_taskid (p_sync_id IN NUMBER,
291: p_recurrence_rule_id IN NUMBER,
292: p_exclusion_rec IN OUT NOCOPY cac_sync_task.exclusion_rec)
293: RETURN NUMBER;
294:
295: PROCEDURE transformStatus(p_task_status_id IN out NOCOPY NUMBER,
296: p_task_sync_id IN NUMBER,

Line 332: ,p_task_tbl IN cac_sync_task.task_tbl)

328: );
329:
330: FUNCTION already_selected(p_task_id IN NUMBER DEFAULT NULL
331: ,p_sync_id IN NUMBER DEFAULT NULL
332: ,p_task_tbl IN cac_sync_task.task_tbl)
333: RETURN BOOLEAN;
334:
335: -- this procedure is made public only for testing ...should not be used otherwise
336: PROCEDURE add_task (

Line 382: x_task_rec IN OUT NOCOPY cac_sync_task.task_rec

378: p_occurs_which IN VARCHAR2,
379: p_locations IN VARCHAR2,
380: p_free_busy_type IN VARCHAR2,
381: p_dial_in IN VARCHAR2,
382: x_task_rec IN OUT NOCOPY cac_sync_task.task_rec
383: );
384:
385: FUNCTION set_alarm_date (
386: p_task_id IN NUMBER,

Line 426: (p_exclusion IN OUT NOCOPY cac_sync_task.exclusion_rec,

422: procedure delete_bookings (
423: p_principal_id IN NUMBER);
424:
425: procedure create_updation_record
426: (p_exclusion IN OUT NOCOPY cac_sync_task.exclusion_rec,
427: p_task_rec IN cac_sync_task.task_rec ,
428: p_exclude_task_id IN NUMBER,
429: p_rec_rule_id IN NUMBER
430: );

Line 427: p_task_rec IN cac_sync_task.task_rec ,

423: p_principal_id IN NUMBER);
424:
425: procedure create_updation_record
426: (p_exclusion IN OUT NOCOPY cac_sync_task.exclusion_rec,
427: p_task_rec IN cac_sync_task.task_rec ,
428: p_exclude_task_id IN NUMBER,
429: p_rec_rule_id IN NUMBER
430: );
431:

Line 433: p_task_rec IN OUT NOCOPY cac_sync_task.task_rec

429: p_rec_rule_id IN NUMBER
430: );
431:
432: function is_recur_rule_same (
433: p_task_rec IN OUT NOCOPY cac_sync_task.task_rec
434:
435: ) return boolean;
436:
437: PROCEDURE delete_tasks(

Line 447: END CAC_SYNC_TASK_COMMON ; -- Package spec

443: RETURN NUMBER;
444:
445: PROCEDURE is_appointment_existing(p_task_sync_id IN NUMBER, x_result OUT NOCOPY VARCHAR2);
446:
447: END CAC_SYNC_TASK_COMMON ; -- Package spec