DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_COMMON dependencies on JTA_SYNC_TASK

Line 1: PACKAGE JTA_SYNC_TASK_COMMON AUTHID CURRENT_USER AS

1: PACKAGE JTA_SYNC_TASK_COMMON AUTHID CURRENT_USER AS
2: /* $Header: jtavstcs.pls 115.58 2002/12/13 22:25:44 cjang ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 125: p_task_rec IN jta_sync_task.task_rec,

121: x_resources OUT NOCOPY resource_list_tbl
122: );
123:
124: PROCEDURE get_alarm_mins (
125: p_task_rec IN jta_sync_task.task_rec,
126: x_alarm_mins OUT NOCOPY NUMBER
127: );
128:
129: -- Used in creating a new task

Line 145: p_task_rec IN jta_sync_task.task_rec,

141: FUNCTION convert_gmt_to_server (p_date IN DATE) RETURN DATE;
142:
143: -- Used in creating a task
144: PROCEDURE convert_dates (
145: p_task_rec IN jta_sync_task.task_rec,
146: p_operation IN VARCHAR2, --CREATE OR UPDATE
147: x_planned_start OUT NOCOPY DATE,
148: x_planned_end OUT NOCOPY DATE,
149: x_scheduled_start OUT NOCOPY DATE,

Line 168: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec);

164: p_scheduled_end_date IN DATE,
165: p_actual_start_date IN DATE,
166: p_actual_end_date IN DATE,
167: p_item_display_type IN NUMBER,
168: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec);
169:
170: FUNCTION get_max_enddate(p_recurrence_rule_id IN NUMBER)
171: RETURN DATE;
172:

Line 249: x_data IN OUT NOCOPY jta_sync_task.task_tbl

245: p_source_object_type IN VARCHAR2,
246: p_get_data IN BOOLEAN,
247: x_totalnew IN OUT NOCOPY NUMBER,
248: x_totalmodified IN OUT NOCOPY NUMBER,
249: x_data IN OUT NOCOPY jta_sync_task.task_tbl
250: --p_new_syncanchor in date
251: );
252: PROCEDURE get_all_deleted_tasks(
253: p_request_type IN VARCHAR2,

Line 261: x_data IN OUT NOCOPY jta_sync_task.task_tbl

257: p_resource_type IN VARCHAR2,
258: p_source_object_type IN VARCHAR2,
259: p_get_data IN BOOLEAN,
260: x_totaldeleted IN OUT NOCOPY NUMBER,
261: x_data IN OUT NOCOPY jta_sync_task.task_tbl
262: --p_new_syncanchor in date
263: );
264: PROCEDURE get_all_repeat_tasks(
265: p_request_type IN VARCHAR2,

Line 275: x_data IN OUT NOCOPY jta_sync_task.task_tbl,

271: p_get_data IN BOOLEAN,
272: x_totalnew IN OUT NOCOPY NUMBER,
273: x_totalmodified IN OUT NOCOPY NUMBER,
274: -- x_totaldeleted IN OUT NOCOPY NUMBER,
275: x_data IN OUT NOCOPY jta_sync_task.task_tbl,
276: x_exclusion_data IN OUT NOCOPY Jta_Sync_Task.exclusion_tbl
277: --p_new_syncanchor in date
278: );
279:

Line 276: x_exclusion_data IN OUT NOCOPY Jta_Sync_Task.exclusion_tbl

272: x_totalnew IN OUT NOCOPY NUMBER,
273: x_totalmodified IN OUT NOCOPY NUMBER,
274: -- x_totaldeleted IN OUT NOCOPY NUMBER,
275: x_data IN OUT NOCOPY jta_sync_task.task_tbl,
276: x_exclusion_data IN OUT NOCOPY Jta_Sync_Task.exclusion_tbl
277: --p_new_syncanchor in date
278: );
279:
280: PROCEDURE create_new_data(p_task_rec IN OUT NOCOPY jta_sync_task.task_rec

Line 280: PROCEDURE create_new_data(p_task_rec IN OUT NOCOPY jta_sync_task.task_rec

276: x_exclusion_data IN OUT NOCOPY Jta_Sync_Task.exclusion_tbl
277: --p_new_syncanchor in date
278: );
279:
280: PROCEDURE create_new_data(p_task_rec IN OUT NOCOPY jta_sync_task.task_rec
281: ,p_mapping_type IN VARCHAR2 DEFAULT G_NEW -- Fixed bug 2497963 for 9i issue
282: ,p_exclusion_tbl IN jta_sync_task.exclusion_tbl
283: ,p_resource_id IN NUMBER
284: ,p_resource_type IN VARCHAR2

Line 282: ,p_exclusion_tbl IN jta_sync_task.exclusion_tbl

278: );
279:
280: PROCEDURE create_new_data(p_task_rec IN OUT NOCOPY jta_sync_task.task_rec
281: ,p_mapping_type IN VARCHAR2 DEFAULT G_NEW -- Fixed bug 2497963 for 9i issue
282: ,p_exclusion_tbl IN jta_sync_task.exclusion_tbl
283: ,p_resource_id IN NUMBER
284: ,p_resource_type IN VARCHAR2
285: );
286:

Line 287: PROCEDURE update_existing_data(p_task_rec IN OUT NOCOPY jta_sync_task.task_rec

283: ,p_resource_id IN NUMBER
284: ,p_resource_type IN VARCHAR2
285: );
286:
287: PROCEDURE update_existing_data(p_task_rec IN OUT NOCOPY jta_sync_task.task_rec
288: ,p_exclusion_tbl IN jta_sync_task.exclusion_tbl
289: ,p_resource_id IN NUMBER
290: ,p_resource_type IN VARCHAR2);
291:

Line 288: ,p_exclusion_tbl IN jta_sync_task.exclusion_tbl

284: ,p_resource_type IN VARCHAR2
285: );
286:
287: PROCEDURE update_existing_data(p_task_rec IN OUT NOCOPY jta_sync_task.task_rec
288: ,p_exclusion_tbl IN jta_sync_task.exclusion_tbl
289: ,p_resource_id IN NUMBER
290: ,p_resource_type IN VARCHAR2);
291:
292: PROCEDURE delete_exclusion_task(

Line 294: ,x_task_rec IN OUT NOCOPY jta_sync_task.task_rec

290: ,p_resource_type IN VARCHAR2);
291:
292: PROCEDURE delete_exclusion_task(
293: p_repeating_task_id IN NUMBER
294: ,x_task_rec IN OUT NOCOPY jta_sync_task.task_rec
295: );
296:
297: PROCEDURE delete_task_data(
298: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec

Line 298: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec

294: ,x_task_rec IN OUT NOCOPY jta_sync_task.task_rec
295: );
296:
297: PROCEDURE delete_task_data(
298: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec
299: ,p_delete_map_flag IN BOOLEAN DEFAULT TRUE
300: );
301:
302: PROCEDURE reject_task_data(

Line 303: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec

299: ,p_delete_map_flag IN BOOLEAN DEFAULT TRUE
300: );
301:
302: PROCEDURE reject_task_data(
303: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec
304: );
305:
306: FUNCTION changed_repeat_rule(p_task_rec IN jta_sync_task.task_rec)
307: RETURN BOOLEAN;

Line 306: FUNCTION changed_repeat_rule(p_task_rec IN jta_sync_task.task_rec)

302: PROCEDURE reject_task_data(
303: p_task_rec IN OUT NOCOPY jta_sync_task.task_rec
304: );
305:
306: FUNCTION changed_repeat_rule(p_task_rec IN jta_sync_task.task_rec)
307: RETURN BOOLEAN;
308:
309: -- function to check if a repeating task is on exclusion list
310: FUNCTION check_for_exclusion(p_sync_id IN NUMBER,

Line 311: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,

307: RETURN BOOLEAN;
308:
309: -- function to check if a repeating task is on exclusion list
310: FUNCTION check_for_exclusion(p_sync_id IN NUMBER,
311: p_exclusion_tbl IN jta_sync_task.exclusion_tbl,
312: p_calendar_start_date IN DATE,
313: p_client_time_zone_id NUMBER)
314: RETURN BOOLEAN;
315:

Line 318: p_exclusion_rec IN jta_sync_task.exclusion_rec)

314: RETURN BOOLEAN;
315:
316: FUNCTION get_excluding_taskid (p_sync_id IN NUMBER,
317: p_recurrence_rule_id IN NUMBER,
318: p_exclusion_rec IN jta_sync_task.exclusion_rec)
319: RETURN NUMBER;
320:
321: PROCEDURE transformStatus(p_task_status_id IN out NOCOPY NUMBER,
322: p_task_sync_id IN NUMBER,

Line 357: ,p_task_tbl IN jta_sync_task.task_tbl)

353: );
354:
355: FUNCTION already_selected(p_task_id IN NUMBER DEFAULT NULL
356: ,p_sync_id IN NUMBER DEFAULT NULL
357: ,p_task_tbl IN jta_sync_task.task_tbl)
358: RETURN BOOLEAN;
359:
360: -- this procedure is made public only for testing ...should not be used otherwise
361: PROCEDURE add_task (

Line 403: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec

399: p_friday IN VARCHAR2,
400: p_saturday IN VARCHAR2,
401: p_date_of_month IN VARCHAR2,
402: p_occurs_which IN VARCHAR2,
403: x_task_rec IN OUT NOCOPY jta_sync_task.task_rec
404: );
405:
406: FUNCTION set_alarm_date (
407: p_task_id IN NUMBER,

Line 421: END jta_sync_task_common; -- Package spec

417: -- Added to fix bug 2382927
418: FUNCTION validate_syncid(p_syncid IN NUMBER)
419: RETURN BOOLEAN;
420:
421: END jta_sync_task_common; -- Package spec